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
