Senior Data Analyst Resume Baltimore, MD - Hire IT People

SUMMARY

Oracle certified professional with fourteen plus years of experience in Information Technology focused on Data Analysis, design, implementation and maintenance of database applications including testing, reporting, and support of production environments.
Experience in project management, requirements gathering, analysis, test planning and execution, business process improvement, user support and documentation.
Experience in developing stored procedures, functions and packages using PL/SQL in large environments.
Strong working knowledge of Data Warehouse architecture, designing of Star schema and Dimensional tables. Developing strategies for Extraction, Transformation, and loading (ETL) data from various sources into Data warehouse

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Senior Data Analyst

Responsibilities:

Production support, design, code, test and debug large data sets and building custom SQL queries for the improvement, manipulation and analysis of data in SQL Server Management Studio/ DB visualizer and troubleshooting the workflows in Informatica ETL tool after understanding complex business processes.
Created visualizations & Dashboards in Power BI and Qlik in search of critical business insights and communicate the findings to relevant departments and the business at large.
Tracking the issues and the customer queries in Jira ticket management system and resolving/closing the tickets as they get resolved.
Identify, evaluate and document potential data sources and build statistical models, diagnoses, validate and improve the performance of these models over time in addition to creating efficient and reusable SQL code.
Monitoring and troubleshooting the Autosys jobs and ensure timely data loading and maintain accuracy and relevance of data used within the department for all environments Prod/Qual and Dev.

Confidential, Bowie, MD

Senior Data Analyst

Responsibilities:

Design, code, test and debug custom SQL queries using Microsoft SQL queries, SQL Server Management Studio and SQL Server Reporting Services.
Develop working solutions to custom client requirements and Data services automation requirements, keeping in mind product capabilities, scope limitations and the impact on integrated products employing SQL Server built in features and analytical methods.
Automation of complex reports and prepare AdHoc reports to internal and external program consumers.
Perform root cause analysis to identify data flow issues, system performance issues and/or data discrepancy issues of the IT Operations team.
Logging & tracking the work completed in iBSM Ticket management system.
Design specific databases for collection, tracking, and reporting of administrative clinical data and Operational Product Data for IT Operational performance analysis using SQL Server Management Studio 2008, 2012 R2.

Confidential, Washington DC

Senior Data Quality Analyst

Responsibilities:

Automate validation of complex reports and prepare AdHoc reports to internal and external program consumers.
Extensive use of Oracle SQL/PLSQL and routine analysis and streamlining process.
Developed and tested new SQL routines, validation routines per requirements.
Analyze and validate existing reports, communicate and explain variances.
Use of Excel for building the pivot tables, vLookups and graphs.
Interacted with business and technical teams and transformed the business requirements into test cases.
Use of Business Objects Web Intelligence tool for building reports.