We provide IT Staff Augmentation Services!

Sr. Database Analyst Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

SUMMARY

  • An accomplished Database/SQL Analyst with proven success in design and implementing internal and customer facing reporting functions.
  • Possess diversified experience in both internal and external data requirement gathering as well as proven leadership and team building qualities
  • Team Lead and Managerial Experience in setting goals, team motivation and results generation.
  • Vast Experience in Customer and Vendor Relations
  • Ability to quickly assess problems and strategize solutions.

TECHNICAL SKILLS

  • SQL Server 2008 (Reporting Services (SSRS))
  • SQL Server 2005 (Integration Services (SSIS)
  • Reporting Services (SSRS))
  • SQL Server 2000
  • T - SQLSSQ
  • SQL PLUS
  • PL/SQL
  • Microsoft Reporting Services/ Builder
  • Microsoft Office Suite (Excel
  • Access)
  • Crystal Reports 8.5
  • Business Objects
  • SagentDTS

PROFESSIONAL EXPERIENC

Confidential Atlanta, GA

Sr. Database Analyst

Responsibilities:

  • Assigned to Marketing Department
  • Gather user requirements to build Marketing lists from CRM and Sales systems in SQL to Excel
  • Develop reports in SSRS for internal team members
  • Data migration and manipulation processes using SSIS to transfer from Excel to SQL.

Confidential, Atlanta, GA

Sr. Database Analyst

Responsibilities:

  • Transition manual reporting practices to automated reporting with SSIS, SSRS and T-SQL.
  • Transition to one central data source for all reporting needs.
  • Save company time of 20hrs per week by automating major Sales and Inventory reports.
  • Develop Executive Dashboard with KPI’s for internal Sharepoint use with SSRS.
  • Develop stored procedures, functions and views to access data across numerous data sources.
  • Data migration and manipulation processes using SSIS.

Confidential Alpharetta, GA

Sr. Database Analyst

Responsibilities:

  • Developed reports for international user access either through intranet or schedule to deliver by email.
  • Develop secured Ad-hoc reporting suites for Sales/Marketing and Finance divisions for users through Microsoft Report Builder
  • Develop stored procedures, functions and views to access data across numerous data sources.
  • Data migration and manipulation processes using SSIS.

Confidential, Atlanta, GA

Production Mgr/Data Analysis

Responsibilities:

  • Interact with internal and external customers to gather requirements.
  • Develop and manage over 300 reports for JWH&N for various departments including, finance, sales, marketing, and production.
  • Develop reports for user access either through our intranet or schedule to deliver by email.
  • Develop reports accessing data direct from SQL 2000 and 2005 Databases as well as from companies Data Warehouse entity.
  • Develop DTS processes to transfer and schedule data transformation procedures.
  • Develop stored procedures, functions views to access data across numerous data sources.
  • Interact with internal and external customers to gather requirements.
  • Train and manage teh Production and Reporting Services Team.
  • Reduced manual reporting man hours by 80% company wide
  • Managed $300k Annual Department Budget

We'd love your feedback!