Uploaded File
add photo
Arpen
Chicago, IL 60601
Data Analyst/Developer - Sr Consultant
5 years experience W2
0
Recommendations
Average rating
43
Profile views
Summary

Data marts/Data warehousing techniques (Star Schema, snow flaking, denormalization, Normalization, Aggregations).

  • Managed the data load production process and the implementation of new data load files in accordance with the department's change management process.
  • Created, executed, and documented unit test plans for ETL and data integration processes and programs.
  • Performed tasks required to conform to the company's configuration management and software release processes.
  • Monitored and administered automated and manual data integration and ETL jobs to verify execution and measure performance.
  • Strong experience on RDBMS (DB2) with good PL/SQL concepts & strong DAX and SQL skills.
  • ETL Development experience with strong ETL and SQL programming skills (TSQL& MySQL).
  • Strong ETL testing experience and verification utilizing SQL querying skills (PL/SQL, Toad or other tools) and formal testing methodologies. Microsoft Office, and advanced data analytics using Microsoft Excel Power Query, Pivot tables, import/export, formulas, and conditional formatting. Experience in designing and developing analytical applications using Microsoft Power BI, Azure Data factory, Excel, and SQL Server Analysis.
  • Experience with collaborating and interfacing project needs, business data requirements with multiple levels of management, vendors, and clients.
  • Participate in the management of the VDP templates used at Vision. Develop rules used to validate data and transform client data.
  • InRule Data development and business data automations with APIs and SSIS packages.
  • Manage Rules Applications for both internal and client-facing systems.
  • Work with developers to integrate with automated client systems and web portals. Secondary Responsibilities
  • Participated in client-onboarding by assisting with the documentation process and requirements gathering related to client data.
  • Executed daily, weekly, or one-off programs requiring SSIS applications or special database skills.
  • Supported Vision clients by participating in weekly or other recurring meetings or conference calls.
  • Supported other Vision departments with ad-hoc data or reporting requests. Microsoft Office, and advanced data analytics using Microsoft Excel Power Query, Pivot tables, import/export, formulas, and conditional formatting. Experience in designing and developing analytical applications using Microsoft Power BI, Excel, SQL Server Analysis. Managed file transfer automation experience: FTP, SFTP, PGP collaborating and interfacing project needs, business and data requirements with multiple levels of management, vendors, and clients.

Experience
SR. CONSULTANT
Jan 2020 - Mar 2021
Completed and supported projects in Data warehousing, ETL, and testing production SSIS and ETL packages.
No skills were added
Remove Skill
DATA ANALYST/ SQL DEVELOPER
Information Technology
Apr 2017 - May 2019
  • Financial data analysis and healthcare clinical data analysis of claims data. Audited EDI 835, 837, transactions.
  • Medicare claims data adjudication. Prescription benefit, formulary and clinical program design.
  • SOLUTIONS DEVELOPMENT WITH VISUAL STUDIO, SSIS, SSAS, SSRS, and SQL Server. Experience with Python.
  • EXPERIENCED IN DESIGNING AND DEVELOPING COMPLEX STORED PROCEDURES AND SCRIPTS FOR SSIS packages, and custom ETL solutions
  • ABLE TO REWRITE CURRENT complex T-SQL stored procedures to fix current production issues, solutions design and created SSRS reports. Managed SQL Server tables for the team for various internal requests to meet daily reporting needs.
  • CREATEd, modified, and optimized sql views, CTEs, reports, database tables, triggers, indexes, and stored procedures to support the implementation of new solutions and application requirements. Created and maintained Power-BI and Tableau reports and cross functional Dashboards. Utilized PHP, HTML Python, Java, .NET, C#, and Visual Basic to provide support.
  • DATA ANALYSIS WITH EXCEL, Power Query, Power BI. Wrote sql views, CTEs, reports, tables, triggers, indexes. Experience with Power BI, Tabular Data Modeling, Intermediate DAX, SSRS, and creating reports and dashboards. Experienced with Microsoft Office, and advanced data analytics using Microsoft Excel Power Query, Pivot tables, import/export, formulas, and conditional formatting. Experience in designing and developing analytical applications using Microsoft Power BI, Excel, SQL Server Analysis. Managed file transfer automation experience: FTP, SFTP, PGP
No skills were added
Remove Skill
Systems/Data Analyst (Consultant)
Aug 2016 - Sep 2016
Projects
  • Developed and assessed current state systems and processes based on needs, business requirements and business processes. Resolved current issues with EDI 845 transactions and worked toward new process improvement opportunities with AS/400, DB2, Turning Point, Systems Security, and Production Support.
  • Evaluated business requirements and prepared detailed functional and technical specifications.
  • Collaborated with staff ensure testing efforts align with system deliveries and business processes.
  • Cleansing data to refine: current reports, resolve system issues and recommended coding enhancements.
  • Audited EDI 845 transactions, EDI process, current EDI Mapping, Trusted Link (IP-enabled B2B translator for EDI integration).
  • Experienced in Microsoft Office, and advanced data analytics using Microsoft Excel Power Query, Pivot tables, v-lookups, import/export, formulas, macros, and conditional formatting. Experienced with collaborating and interfacing project needs, business and data requirements with multiple levels of management, vendors, and clients.
No skills were added
Remove Skill
Business Systems Analyst II (CONTRACTOR)
Information Technology
Apr 2016 - Jul 2016
Projects- Worked to enhance Data Automation for Business and Managed Care. Using SQL Server and SSIS. Developed integrated solutions for Print, Digital, and Supply Chain Solutions. Analyzed data received for inventory and orders, and fulfillment systems downstream. Data analysis of Client data for Data integration performed data cleansing and transformation. Supported Government and Commercial Insurance Plans. Automated and prepared data for reports based on CMS model & regulations compliance. Experienced in designing and developing complex stored procedures and scripts for SSIS packages, and custom ETL solutions. Wrote sql views, CTEs, triggers, indexes for stored procedures and reports. Experienced with Microsoft Office, and advanced data analytics using Microsoft Excel Power Query, Pivot tables, import/export, formulas, and conditional formatting. Worked in an agile environment using JIRA, OpenProject, and SVN. Experience in designing and developing analytical applications using Microsoft Power BI, Excel, SQL Server Analysis. Data Analysis with Excel, Power Query, Power BI. Wrote sql views, CTEs, reports, tables, triggers, indexes. Experience with Power BI, Tabular Data Modeling, Intermediate DAX, SSRS, and creating reports and dashboards.
No skills were added
Remove Skill
Senior Healthcare IT Consultant
Medical Devices
Mar 2015 - Apr 2016
Greater Chicago area and NW Suburbs Senior Healthcare IT Consultant I have completed these immediate need projects for area clinicians:
  • Project 1
  • Updated the webpage of a Clinical RPH who served as a legal witness on medical malpractice and toxicology cases.
  • Project 2
  • Worked with a Physician's group to set up a remote webserver linked to their office EMR.
  • Project 3
  • Worked with a Dental group to assist completion of a new office EMR install. Independent Consulting
No skills were added
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
LIST
DEVRY INSTITUTE OF TECHNOLOGY
LIST
WILLIAM RAINEY HARPER COLLEGE
DEAN'S
HOFFMAN ESTATES HIGH SCHOOL
Skills