LiveCareer
LiveCareer
  • Dashboard
  • Jobs
  • Resumes
  • Cover Letters
  • Resumes
    • Resumes
    • Resume Builder
    • Resume Examples
      • Resume Examples
      • Nursing
      • Education
      • Administrative
      • Medical
      • Human Resources
      • View All
    • Resume Search
    • Resume Templates
      • Resume Templates
      • Nursing
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • View All
    • Resume Services
    • Resume Formats
    • Resume Review
    • How to Write a Resume
    • CV Examples
    • Resume Objectives
  • Cover Letters
    • Cover Letters
    • Cover Letter Builder
    • Cover Letter Examples
      • Cover Letter Examples
      • Education
      • Medical
      • Human Resources
      • Customer Service
      • Business Operations
      • View All
    • Cover Letter Services
    • Cover Letter Templates
    • Cover Letter Formats
    • How to Write a Cover Letter
  • Jobs
    • Mobile App
    • Job Search
    • Job Apply Tool
    • Salary Calculator
    • Business Letters
    • Job Descriptions
  • Questions
  • Resources
  • About
  • Contact
  • 0Notifications
    • Notifications

      0 New
  • jane
    • Settings
    • Help & Support
    • Sign Out
  • Sign In
Member Login
  • LiveCareer
  • Resume Search
  • Data Analyst/SQL Developer
Please provide a type of job or location to search!
SEARCH

Data Analyst/SQL Developer Resume Example

Resume Score: 65%

Love this resume?Build Your Own Now
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 Developer08/2012 to Current1800EZSOLUTIONS 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 Manager05/2008 to 08/2012SSP 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 Management2013SUNY Farmingdale State CollegeFarmingdale, 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 Diploma2008Sewanhaka High SchoolFloral Park, NY, United States
Build Your Own Now

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.

Resume Overview

Companies Worked For:

  • 1800EZSOLUTIONS Inc.
  • SSP America Inc.

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

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

×

Advertisement

Similar Resumes

View All
Lead-Power-BI-Data-Analyst-/-SQL-Developer-resume-sample

Lead Power BI Data Analyst / SQL Developer

Pricewaterhouse Coopers LLP (End Client: United Airlines)

Cary, North Carolina

Lead-Power-BI-Data-Analyst-/-SQL-Developer-resume-sample

Lead Power BI Data Analyst / SQL Developer

Cary, North Carolina

SQL-DATA-ANALYST-resume-sample

SQL DATA ANALYST

National Tax Search

Charlotte, North Carolina

About
  • About Us
  • Privacy Policy
  • Terms of Use
  • Sitemap
Help & Support
  • Work Here
  • Contact Us
  • FAQs
Languages
  • EN
  • UK
  • ES
  • FR
  • IT
  • DE
  • NL
  • PT
  • PL
Customer Service
customerservice@livecareer.com
800-652-8430 Mon- Fri 8am - 8pm CST
Sat 8am - 5pm CST, Sun 10am - 6pm CST
  • Stay in touch with us
Site jabber winner award

© 2021, Bold Limited. All rights reserved.