SUMMARY:

• 10 years’ Experience in Data Science/ Big Data Analytics / Data Engineering
• Big Pharma and Healthcare experience Mathematical Statistics, Machine Learning Systems and Automated Reasoning Algorithmic Solutions, knowledge of ARRIMA model
• Experience working with Large complex data (1 terabyte in size): Data visualization, Data Mining
• Experience and knowledge of Big Data: IBM Apache Spark (Databricks), Hive
• 4+ years of experience with Data Management, Analytical tools, languages and libraries (e.g. SAS, python - NumPy, seaborn, MATLAB, R). Working experience with AWS and Azure Cloud data
• Data Analysis skills SQL (relational databases), Python, R, Power Bi, Tableau, QlikView, MS SQL SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Green Bay, WI

Sr. Software Engineer

Responsibilities:

• Data Analysis of inbound Rx Medical Claims and performing adjustments
• Big Data extraction of inbound data feeds and analytics performed daily.
• Perform Ab Initio ETL data load, transformation, metadata documentation, development, and data warehousing
• Create advanced SQL Joins (MS SQL, Toad Pl/SQL, DB2, and Teradata and create Linux/Unix shell command scripts
• Perform Service now ticketing and Jira as well as QA validation and performance maintenance

Confidential, Plainfield, IN

EDI Integrations Lead

Responsibilities:

• Created standard data functionality using EDI/Network; standard flat files, ETL or XML formatted data.
• Data Analytics of inbound and outbound orders via Red Prairie Warehouse Management.
• Mapped EDI ANSI X12 data from inbound tractions to outbound transaction.
• Created functions and stored procedures Distribution Center or Manufacturing experience.
• Experienced in creating Power BI interactive dashboards with DAX command language CALCULATE, FILTERS, DAX quires, variables, calendar for chart and graphs.

Confidential, Chicago, IL

Sr. Data Analyst

Responsibilities:

• Conducted Machine Learning Systems and Automated Reasoning Algorithmic Solutions.
• Designed a report delivery system App from a vendor data source and a back-end legacy into a standalone SAS EG and SAS Grid; Built reports using SAS EG platform proc SQL, macro, and Proc report with ODS templates.
• Data analysis and extraction of health care payment integrity analytics while working with large data sets.
• Advanced level of proficiency in coding overpayment analytics using SQL; Data extraction and analysis knowledge of medical coding concepts (CPT, ICD-9/10 coding, HCPCS and DRGs).
• Analyzed query execution plans and optimized database code; Constructed Data Access Adapters (Stored Procedures, SQL Views); Created stored procedures and functions to in corporate complex database algorithms.
• Collaborated as part of Scrum (Agile) development team member.

Confidential, Indianapolis, IN

Business Intelligence Developer Lead

Responsibilities:

• Conducted Machine Learning Systems and Automated Reasoning Algorithmic Solutions.
• Ability to transform data in Power BI for insights in charts using Python (Pandas, NumPy, Matplotlib), Seaborn.
• Extracted medical claims, medical membership/enrollment segments and created Excel, SAS, Qlik reports.
• Developed dashboards in Power BI using Data Analysis (DAX) language expressions in charts.
• Designed Business Intelligence data model and defined data artifacts, including extracts for data business KPIs.
• Reviewed peer dashboards and analysis results and provided feedback; Extracted 10+ million rows of data.
• Performed MS Stack services SSIS, SSRS, and SSAS to extract data and load table in data warehouse.

Confidential, Indianapolis, IN

Business Data Analyst Developer

Responsibilities:

• Conducted Machine Learning Systems and Automated Reasoning Algorithmic Solutions.
• Created VB scripts to move and deploy table objects from Web Services, FTP, and XML.
• Created table from Oracle database using PL\SQL; Provided data analytics and constructed exec dashboard.
• Performed MS Stack services SSIS, SSRS, and SSAS to extract data and load table in data warehouse.
• Developed SQL code for data mart cubes, reporting and GUI platforms for the Quality, Marketing and Claims.

Confidential, Carmel, IN

Consultant

Responsibilities:

• Conducted Machine Learning Systems and Automated Reasoning Algorithmic Solutions.
• Extracted medical claims, medical membership/enrollment segments and created Excel/SAS/ reports.
• Developed daily load of EDI, medical claims flat files, piped files into master tables and uploaded in the QNXT medical CRM environment.
• Consulted with business partners on improvement opportunities identified through data analysis.
• Developed and maintained reporting and analytics related EDI and call center business functions.

Confidential, Metuchen, NJ

Enterprise Systems - Analyst

Responsibilities:

• Extracted medical claims, medical membership/enrollment segments and created Excel/SAS/ reports.
• Performed MS Stack services SSIS, SSRS, and SSAS to extract data and load table in data warehouse.

Confidential, Carmel, IN

Senior Consultant/QlikView Developer Team Lead

Responsibilities:

• Trained Developers and Lead QlikView Development Team for client certification and project engagement.
• Designed Data Warehouse metadata in support of Data Warehouse Analytical Reporting solutions.
• Performed performance tuning of T-SQL Expertise in ETL (Data Extraction, Transformation & Loading), Data modeling, Report and Performance Tuning using QlikView.
• Performed R clustering of data that was used in bobble chart in dashboards.

Confidential, Pittsburgh, PA

Senior Business Intelligence Developer Consultant

Responsibilities:

• Liaised with business owners and provided process improvement consultation for new provider profiling reporting BI/DW tool.
• Prepared business process flows and visual diagrams of data flows for data summarizations.
• Created BI report metrics and data marts for provider profiling analysis on a weekly basis.
• Performed GAP analysis of business system and provided business system dashboard results and test cases to analyze warehouse data.

Confidential, Indianapolis, IN

Project Manager- Quality Improvements

Responsibilities:

• Extracted medical claims, medical membership/enrollment segments and created Excel/SAS/ reports.
• Re-engineered, planned, and developed initiatives including the redesign and implementation of an ACCESS database to a SQL server database.
• Created, planned, and developed the conceptual design of a provider Web portal system.
• Completed a $5.6M contract settlement payout reports project for senior management and the Vice President.

Confidential, Indianapolis, IN

Systems Analyst

Responsibilities:

• Performed member claim research for HealthPlan performance measures and Automated Reasoning Algorithmic Solutions.
• Conducted automated analysis data using Linear regression analysis.
• Mean Squared error analytical analysis.
• Extracted Medical Claims, Medical membership/enrollment segments and created Excel/SAS/ reports.
• Constructed ETL interfaces using SSIS to aggregate, cleanse and migrate data across enterprise-wide MDM, transactional database, and Data Warehousing systems using staged data processing techniques, patterns and best practices.