SUMMARY:

• Data Engineer with over 10 years of Data Analysis including 2 years of experience with Hadoop, Pig and the Amazon Web Services. MBA and Master s Degree in Actuarial Science with experience in Banking

  Telecommunication Data Mining, Financial Services, and Healthcare Industries. Experience with system architecture, data architecture, enterprise architecture, data warehousing, and terabyte data environments.

• Data Analysis, Mining, Analytics
• Enterprise Integration Architecture
• Enterprise Control Model Definition
• Project Management
• Business Process Design
• Statistical Analysis, Multivariate Regression
• Statistical learning with R, Python since 2013

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst/Analytics Engineer

Responsibilities:

• Perform Risk Data Systems Integration Analysis of clusters of vendor systems. Make recommendations and lead the implementation of the integration of many in house, Retail, Commercial, and banking legacy systems with a newly designed architecture. Identify critical data, run tests, define KPIs, process mining, and report progress to Senior Management.
• Analyze current work and data flows
• Define a Data Governance model for monitoring data quality across all databases worldwide
• Define data requirements and implement data mapping from source systems to a new data warehouse
• Design, implement, and maintain a star schema Rejection data warehouse daily error report to users for correction; providing weekly incident dashboard to senior managers.
• Provide statistical analysis of collateral and assets exceptions with the aim of quantifying the financial impact of operational defects
• Train business users on data management processes.
• Present KPI and other data issues to stakeholder weekly
• Represent the Data Quality Risk System department in the weekly project meeting with corporate team members overseas
• Oversee migration and systems coexistence implemented by consultants
• Approve JCL and VBA coding provided by consultants

Confidential

Data Analyst/ Data Warehouse Consultant

Responsibilities:

• Defined data requirements for Health Incentive Management for multiple clients
• Provided star schema dimensional and temporal modeling of health incentive data and the implementation of a data warehouse
• Participated in meetings to define requirements for data conversion, data validation, data usage and analysis server with CIO, VP of IT, VP of IT operations and other stakeholders
• Created Data Requirement Documents, Data Dictionary, and Data Processing Documents to support Data Mart Development
• Provided technical Data Analysis, Wellness Management Health Plans for multiple clients
• Reported against the Data Warehouse

Confidential

Data Engineer

Responsibilities:

• Identified issues and developed stored procedures for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Validated data on cloud using Amazon Redshift
• Designed custom tools for validating telecommunication market data over billions of records
• Worked with Data Architect with rewrite SQL queries with decreased processing time for 4 days to hours
• Validated MDX queries to ensure market research applications presented multidimensional view subscriber data
• Designed and implemented carrier subscribers switching scorecards, dashboards, and reports
• Participated in in Hadoop and programming with pig

Confidential

Data Consultant

Responsibilities:

• Led data management, metadata collection and validation of company, employee and system data
• Provided expert support on Metadata Management, Master Data Management, and Data Quality Management
• Cleaned data to resolve missing values to support data warehouse and operational databases
• Ensured the data accuracy in large, complex Human Resources, Employee Management and Benefits databases
• Organized, cleaned and mapped data as well as designed and developed custom queries and reports for management and clients
• Researched, gathered, analyzed and reported on data for employee benefits, healthcare providers, teaching hospitals, private payers and HMO participants using SQL
• Validated, mapped, translated, loaded, and modeled Medical Plan data in support of plan eligibility for all active employees

Confidential

Benefit Analyst II

Responsibilities:

• Analyzed, validated, cleaned, transformed, loaded, and summarized Flexible Spending Account data for large clients
• Tracked changes in participant demographics, performed complex analysis which prompted employee benefit plan and pricing changes

Confidential

Senior Implementation Analyst

Responsibilities:

• Analyzed large amounts of benefit, insurance, and client employee demographic data to help management determine client pension requirements and to package an appropriate program
• Analyzed, validated, cleansed, de - duplicated pension investment data using SQL and proprietary data validation tools and tested pension and investment calculation applications

Confidential

Data Analyst

Responsibilities:

• Created Access database using SQL, retrieved relevant data from complex data sets, analyzed data and compiled reports for management
• Used Actuarial mathematics to calculate present value or future value of pension, 401k, and other employee benefits annuities.

Confidential

Business Intelligence Data Analyst

Responsibilities:

• Analyzed dialysis medical device manufacturing data to answer queries on patient/physician usage resulting in identifying opportunities to impact labor, facilities, and equipment utilization (SQL Server and Excel)
• Modeled complex data sets representing clinical, billing, revenue, and operational events