Senior Data Analyst Resume

SUMMARY:

Business intelligence data steward with extensive experience designing, coding, testing and supporting next - generation BI solutions in Oracle enterprise, Teradata, and SQL Server environments. Proficient in an assortment of technologies, including Oracle 10gR2, Business Objects 6.5 and XI, SAS EG, Essbase, MS SQL Server, and Visual Studio.

SKILLS INCLUDE:

KFS Validations and Audit Compliance
Performance Tuning & Capacity Monitoring
Data Security, Backup & Recovery
ETL Processes To Support BI
Meta Data Management
Business Objects XI Reports Development
SQL Tuning in MS SQL Server
SQL Tuning in an Oracle Environment

EXPERIENCE:

Confidential

Senior Data Analyst

Responsibilities:

Developed and supported reporting across all areas of the business.
Confidential is a startup personal lending company that specializes in subprime niche lending markets.
Developed key financial reporting using Business Objects Webi
Performed Business Objects Universe development, maintenance, and break/fix as needed to support key reporting needs
Administered and provided data governance utilizing the Central Management Console ( Confidential )
Developed and implemented key Store Procedures (MS SQL Server) that would build and refresh critical need Data Marts
Performed Ad-Hoc query development and data analysis
Generated key financial data sets needed to fulfill State auditing requirements
Managed data quality both upstream and downstream of reporting to ensure accuracy and clarity

Confidential

Reporting Developer

Responsibilities:

Scope and build out supporting data structures in MS SQL Server and Oracle environments
Develop batch DML/DDL jobs using Pentaho PDI (Kettle/Spoon) to support rich data sets
Identify and develop reporting supporting USDA requirements
Develop reporting that tracks Federal School Lunch programs across the state
Develop reporting that co-ordinates School and non-profit applications and approvals for various Federally funded programs to feed those in need.
Developed reporting to track food warehousing and delivery across the state.
Report development in Pentaho PRD including canned reports, self-serve BI, and dashboards.

Confidential

Data Analyst

Responsibilities:

Maintained HIPPA compliance within reporting utilizing data masking and encryption technologies
Worked within a very complex Teradata Environment.
Developed reporting to enhance diagnosis and treatment approaches with the clinical teams
Developed reporting to improve healthcare membership access to various networks
Developed reporting to track healthcare Provider performance metrics
Generated State mandated reporting within the various healthcare markets in which Cenpatico operates

Confidential, Round Rock, TX

Metrics and Reporting Advisor

Responsibilities:

Ensure production and development SQL Server environments were as synchronized as possible
Reviewed all code to be implemented for possible conflicts and to error check
Developed stored procedures to support SSRS reporting
Actively monitored the production and development servers for performance related issues
Tweaked SQL code to be more efficient due to strained environments
Created data dictionaries and documented business rules when possible

Confidential, Round Rock, TX

Metrics and Reporting Advisor

Responsibilities:

Developed and implemented batch driven ETL processes to load data from various sources into the DFS Data Warehouse to enable and enrich BI reporting.
Maintained over 50 batch ETL processes that interact with multiple data platforms and applications (Oracle, Unidata, SQL Server).
Identified data bottlenecks and worked with the DBA team to generate solutions.
Worked with SAS power users to develop efficient SQL.

Confidential, Round Rock, TX

Senior Data Analyst

Responsibilities:

Brought on to maintain a legacy SQL Server and various data and reporting flows into and originating from this system.
Developed new processes that would enhance reporting.
Completely rebuilt the legacy system utilizing Views instead of building intermediate tables. By doing this the need to retain and maintain large data sets was eliminated.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship