Data Analyst/SQL Developer Resume Example 1800EZSOLUTIONS Inc.

DATA ANALYST/SQL DEVELOPER

Summary

2+ years of IT experience as SQL Server Database Developer in Education and Retail environments with primary skills on the Analysis, Design, Development, implementing and testing client and server application using Microsoft SQL Server suite.
Experience in Software Development Life Cycle, and involved in Waterfall and Agile projects.
Analysing Execution Plan and managing indexes and troubleshooting deadlocks.
Experienced in Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import, DDL/DML Triggers, Hints, Views, User defined data types, Cursors using SQL/ PLSQL and T-SQL.
2+ years of experience in design and development of Essbase Application.
Maintained and supported Planning applications (versions 11.x /9.x) – implemented application security process, created user/groups, security profiles and application access to different groups using filters.
Provided support work (version 11.x / 9.x) – developed calc scripts & business rules using both business rules and Calculation manage according to customer business needs
Strong database development and business intelligence modeling capabilities; Essbase calculation script experience.
Strong Understanding of dense and sparse settings, performed dynamic calculations, developed, reviewed, and optimized report queries in Microsoft Excel, loaded data from various database to cubes.
Meet with clients to understand business processes and to gather system requirements with subsequent application design and implementation using best practice implementation techniques
Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

Experience

Data Analyst/SQL Developer 08/2012 to Current 1800EZSOLUTIONS Inc. New York, NY

Environment: MS SQL Server 2008/2012, Oracle Hyperion Essbase 11.x, 9.x, Essbase Administration Services, Hyperion Planning, Excel Add-In, SmartView, and Web Analysis.

Project #2: AAA Institute

Develop complex stored procedures, functions, triggers, views and queries in support of application development.
Review and optimize existing stored procedures, functions, triggers and queries.
Develop custom scripts to automate various database management processes.
Occasionally write single-time reports on demand.
Diagnoses, isolation and debugging of software and hardware problems and performs problem resolution.
Ensures adherence to standards and best practices.
Backup and restore database and define maintenance plans
Troubleshooting blocking
Create SQL jobs
Handle Errors in SQL Server using TRY/CATCH function
Writing advanced T-SQL querying using joins ,sub-queries
Manage index statistics, tables, views, cursors and optimize queries by using execution plan for tuning databases.

Project #1: New York Auto Giant

Developed Essbase cubes for sales and marketing group
Loaded data using SQL interface.
Wrote calculation scripts member formulas to calculate Essbase database.
Wrote Maxl to automate Essbase daily and weekly cube refresh.
Supported Planning Application, which includes web forms, business rules, smart list. Also provided access to users based upon their role.
Worked directly with forecasters and planners and helped them in analysis.
Loaded actuals into Planning Application and consolidated actuals, forecast and budget numbers to provide a complete financial view.
Used best practices to optimize calculation time.

Multi-Unit Manager 05/2008 to 08/2012 SSP America Inc. New York, NY

Led all aspects of operations, including the development of people, sales, and profit for assigned areas comprised of 6 restaurants, 75+ employees and $22.35 million in annual revenue. Managed restaurants' profit and loss centers, including food, supply and labor costs to meet annual operating budgets. Performed monthly financial analysis to evaluate financial position and to clearly communicate expectations and actions to maximize restaurants' financial performance.

Operated & Managed following units:

Uptown Brasserie by Marcus Samuelson - Fine Dinning: $6.9 mil
La Brea Bakery - QSR: $5.8 mil
Pizza Vino - Casual Dinning: $4.3 mil
Full Bar - Casual Dinning: $1.12 mil
Jet Box - QSR: $2.2 mil
Cake Tin - QSR: $1.8 mil

Hired in as Supervisor. Promoted to Assistant Manager in 1 Year.

Promoted to General Manager in 1 month Increase sales from $30K week to $55K at La Brea Bakery through promotional advertisements throughout the terminal Increased sales for the year 41% for all three locations. Decrease food & labor costs 10% at Cake Tin. At Z-Pizza decreased labor cost by $3,000 & food cost by 12%. At Z-Pizza increased sale by 20% by adding additional seating area, marketing new promotional ideas, and adding new Grab n Go workstation to expedite speed of service. Customer service ratings 96% from Market Force surveys. Consistently obtained A rating from the NYC health department at all 5 locations. Credible knowledge of quick serve, full service, and fine dinning restaurants.

Education

Bachelor of Science: Business Management 2013 SUNY Farmingdale State College Farmingdale, NY, United States

Minor in Finance
Coursework in Business, Management and Communications
Coursework in Business Communications and Management Information Systems
Strategic Leadership course
Operations and Quality Management coursework

High School Diploma 2008 Sewanhaka High School Floral Park, NY, United States

Resume Overview

Create a job alert for [job role title] at [location].

About About

Help & Support Help & Support

Languages Languages

Customer Service Customer Service

Data Analyst/SQL Developer Resume Example

Resume Score: 65%