Data Analyst/SQL Developer Resume Example
- 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.
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.
- 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.
- 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.
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.
- 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
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
- Completeness
- Formatting
- Word choice
- Strong summary
- Typos
Resume Overview
School Attended
- SUNY Farmingdale State College
- Sewanhaka High School
Job Titles Held:
- Data Analyst/SQL Developer
- Multi-Unit Manager
Degrees
- Bachelor of Science : Business Management 2013
High School Diploma 2008
