Sign in

Sr. Data Analyst

Boston, MA
April 26, 2020

Contact this candidate


Ashish Sang


Phone: 703-***-****


Over 7+ years of experience in the Information Technology (IT) Industry serving as a Data Analyst in a Data warehousing environment.

Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. Chaired and conducted JAD sessions with business and technical teams.

Strong experience with SQL, Normalized Database creation in relational databases like Oracle, MS-SQL Server

Highly skilled in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.

Experienced in various Healthcare areas like Enrollment, Benefits, Claims, Medicare, and implementation of HIPAA key EDI (ANSI X12) transactions.

Extensive experience of 837, 835, 277, 270, 271.

Experienced in gathering requirements for HIPPA (Health Insurance Portability and Accountability Act) EDI (Electronic Data Interchange) Transactions 820, 834, 835, 837 (I, P and D), 270, 271, 276, 277, 278, 997 and 999 in various phases of implementation.

Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ and MDM.

Well-versed experience in all EDI transactions like 834, 837, 835.

Worked extensively with Dimensional Modeling and Data Migration.

Experience in DBMS/RDBMS implementation using object-oriented concept and database toolkit.

Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.

Thorough understanding various dimensional database modeling techniques, such as Snowflake schema and Star schema.

Performed planning and development of Test Plans, Test Strategies, Test Cases and Test Scenario to meet product’s business requirement.

Functional experience in Health Care Industry with in depth knowledge on Medicare and Medicaid Part A, B, C & D, PPO, POS, and HMO health insurance plans.

Worked Normalization and De-normalization concepts and design methodologies like Ralph Kimball and Bill Inmon approaches and implemented Slowly Changing Dimensions.

Experience in developing, trouble shooting and customizing automation test scripts using Quick Test Professional QTP /HP UFT for Functional and Regression Testing.

Solid understanding of Data Governance, Meta Data, Data Management architecture.

Diverse experience in developing advanced T-SQL coding over varied RDBM systems like MS SQL Server for data mining, SQL tuning and report generation, in order to fulfill customer and market request.

Good knowledge on Patient Protection and Affordability Care Act (PPACA), Clinical, Health insurance Marketplaces, Medicare, Medicaid, (CMS) Medicaid Management Information system (MMIS).

Rich theoretical and practical knowledge in RDBMS based on mathematical SET theory and PREDICATE theory.

Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.

Experience on building OLAP Cubes in SQL Server Analysis Services (SSAS) and reports on it.

Comprehensive knowledge and rich experience in all phases of the Software Development Life Cycle (SDLC), for different development methodologies.

Experience in Functional Testing, System Integration Testing, Back End Testing, GUI Testing, configuration Testing, User Acceptance Testing.

Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.

Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures and Functions. Tuning using various types of Partitioning and Indexes.

Excellent communication, documentation and presentation skills.



SQL Server 2012, Oracle

Data Warehouse Concept:

Star Schema, Snowflake schema, OLTP, OLAP

Operating Systems:

UNIX, MS Windows


SQL, T-SQL, Python, XML

ETL & Reporting Tools:





THP is going to build a new system called Health Rules Payer where our team is working on the transformation/conversion of historic data.


Worked on the Data Warehouse team analyzing data files that had to be compiled from disparate non-production sources and readied them for production. Tasks included: comparing data to requirements documentation, creation of data layouts and data dictionary.

Coordinates HIE maintenance events with application owners and partner systems; executes maintenance routines in the system

Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.

Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.

Lead client discussions relating to the Facets configuration of a standard Medicare Advantage plan.

Supported new business requirements by extending the functionality of the core Facets system using the Facets extensibility architecture feature.

Involved in Facets Implementation, including end to end testing of Facets Billing, Claim Processing and Subscriber/Member module.

Receives reviews and enters data and source documents into Medicaid billing system

Participated as member of a project team performing various lifecycle tasks for an intranet application with SQL Server 2012 database. Developed logical and physical database models and data dictionary documentation.

Created Stored Procedure and Views, Indexes, SQL joins and Sub queries

Worked with integration services for transferring and reviewing data from different sources like (Flat file, Excel, CSV)

Responsible for acquisition of Medicaid data from MDW (Medicaid Data warehouse)

Generated Daily, Weekly, Monthly reports for the analysis of managers and end users by using SQL Server Reporting Services.

Co-ordinate with different application team to develop and standardize enterprise wide data model, created dimensional data model using Agile Methodology, Designed and developed dimension tables, fact tables, conformed fact and dimension tables.

Analyzed the member eligibility, plans including Medicaid/Medicare, refill, pricing and drug edits.

Participate in weekly data analyst meeting and submit weekly data governance status

Examined existing XML with TIBCO Resources to solve any existing issues or provide new direction

Data profiling and Data quality checks along with integration rules determination and documentation.

Experience with data mining, data cleansing, data modeling, data manipulation, record matching, table linking, table structures, importing and exporting.

Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation and Aggregator Transformation.

Wrote Test Plans, Test Scenarios, Test Cases and the Test Matrix.

Participated in the tasks of data migration from legacy to new database system

Re-engineered and captured EDI transactions with legacy systems [Enrollment -834, Eligibility Transaction (270/271), Claims (837), Claim Status Request and Response (276/277), Remittance (835)].

Created SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS.

Created SSIS Packages to extract data from different flat files and created C# program to triggers same from windows applications.

Performed Data Driven Testing, Functional Testing, System, Integration, and Regression testing for application releases.

Tested user interface and navigation controls of the application.

Used shell commands to create serialized C# class files from XML based schemas Involved in performing the unit testing, Regression and User Acceptance Testing.

Environment: MS SQL Server 2014, MS SQL Server, Tibco, MS SQL Server Integration Services 2015, XML, MS Access 2010, MS Excel 2010

CareSource, Dayton, OH Feb 2017 – Oct 2018


I worked as a Data Analyst on Provider information delivery team, Health care application Dashboard and involved in troubleshooting and resolving errors in 834 and 820 transactions for health insurance exchanges and performing root cause analysis.


Analyzed the source data coming from Legacy system, Oracle, DB2, SQL server and flat files. Worked with Data Warehouse team in developing Dimensional Data Model.

Worked on solving the errors of EDI 834 load to Facets through MMS. Created keyword files to have member data bulk loaded into the FACETS system through the MMS batch

Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.

Optimized the performance of SSIS packages by filtering data at source level, using fast load options and tuning embedded SQL queries.

Worked extensively on EDI transactions 837 and 835 Involved in writing test cases for different LOB’s (ITS, FEP and Regular) for SIT, Parallel and UAT.

Analyzing Medicare, Medicaid healthcare programs and performs data transformations, data manipulations, data validations using SQL, Access, VLOOKUP, and Index Matches for dealing with data inconsistencies and maintain data systems with accurate data.

Converted syntax of diverse queries from Oracle to MS SQL Server in order to reach the business requirements

Accomplished the data mapping documentations for database updates

Involved in Data Analysis, Data Cleansing, Requirements gathering, Business Analysis, Entity Relationship diagrams (ERD), Architectural design docs, Functional and Technical design docs, and Process Flow diagrams

Handled and maintained model versioning using Erwin.

Analyzing the reference of data which is extract from source table and transform to the target table by using the SQL query.

Designed Enterprise reports using SQL Server Reporting Services (SSRS)

Did Transformation and data cleansing activities use various Control flow and data flow tasks in SSIS packages during data migration

Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Analyzed the FACETS Requirements and conducted gap analysis.

Responsible for Medicaid Claims Resolution/Reimbursement for peach state health plan using MMIS.

Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries.

Analyzed results and EDI ANSI X12 file mapping and reported on standard analysis spreadsheet. Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payer contacts. Acted as a liaison between client and payer/intermediary.

Tested SOAP request and response in XML format using SOAP UI.

Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using SQL Server procedures, packages, functions, database triggers

Created numerous views with complex SQL statements to retrieve data from the Tables.

Devising a planned approach to maintain the month long segmentation process.

Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model to acrobat files and Data Cleansing.

Designed and developed Data warehouse, Data marts, star schemas, fact table, Dimension tables, Slowly Changing Dimension, Staging areas, Operational Data Store.

Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.

Analyze test cases and defects being loaded in HP ALM by QA teams to ensure the link entities and accuracy of data..

Prepared technical design/specifications for data Extraction, Transformation and Loading.

Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.

Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.

Involved in designing Universes incorporating all the business requirements and creating hierarchies to support drill down functionalities in reports.

Environment: MS SQL Server 2012/2014, MS SQL Server Reporting Services, Tibco, MS SQL Server Integration Services 2014, XML, MS Access 2010, .Net, MS Excel 2010, Share point (MOSS), Business Objects, VBA (Visual Basic for Applications).

United Health Care, Minnetonka, MN Aug 2014– Dec 2016


United Health Care Insurance is a leading provider of commercial and personal health insurance. The project involved working with Management Information reporting team to gather information, analyze, define, design, and implement various management and operational reports for Policy and Billing. A regular part of the teams work also involved enhancement and maintenance of internal reports used by Underwriters, marketing representatives, managers and external reports accessed by agents.


Wrote advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.

Responsible for Data modeling and Mapping through data analysis to extract data elements from various OLTP’s using ETL technique and utilized Business Intelligence Tool (Tableau) for report generation.

Analyzed and documented the changes in the compliance rules for adverse action redesign.

Used Data warehousing for Data Profiling to examine the data available (Data Analysis) in an existing database.

Worked in Teradata to make sure completeness of table structures, data and reference table data.

Extensive experience in ETL processes in extracting data from Operational and Legacy Systems to Data Warehouse using Informatics.

Responsible for providing business requirements within an AGILE software development SCRUM environment.

Ensure day-to-day EDI transmission, Reject tracking and Reconciliation.

Run EDI Reconciliation reports daily and document in MS Excel.

Maintained and monitored project progress and status through MS Project.

Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes documentations.

Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.

Designed, Developed and Implemented reports in QlikView BI Dashboard tool – one of the most advanced tools for BI and reports.

Performed Back-End testing manually for database integrity using SQL statements on UNIX platform

Assisted in the oversight for compliance to the Enterprise Data Standards, data governance and data quality.

Worked closely with the Enterprise Data Warehouse team and Business Intelligence.

Used the guidelines and artifacts of the Agile Process to strategize the Implementation in different sprints of the Software Development Life Cycle.

Involved in FACETS Implementation, involved end to end testing of FACETS Billing, Enrollment Claim Processing and Subscriber/Member module.

Involve in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems.

Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardization data structures, data base design, data warehouses, business.

Walk-through the business users: Business Object Reports or QlikView reports.

Involved in creating xml schemas which matches with SQL tables to handle data transformation from different data sources.

Tested and validated the database tables using SQL queries.

Design the process working with both SOA services and SQL developers to ensure seamless conversion.

Perform data alignment and data cleansing and debugger to test the mapping and fixed the bugs.

Development of source data profiling and analysis, reviewed the data content and metadata would facilitate data mapping and validate assumptions that were made in the business requirements.

Extract data from relational databases Oracle and flat files.

Ensure the data consistency by cross-checking sampled data upon migration between the database environments.

Created and maintained test strategies, test plans, test cases, and product release reports for small projects or components of larger projects in Confluence, and Jira.

Develop a process to extract the source data and load it into the flat files after cleansing, transforms and integrating.

Used .net serializable classes to serialize request xml payloads and used xslt utility to test reports.

Data mapping, logical data modeling, used SQL queries to filter data within the Oracle and Sybase.

Used the Agile methodology to build the different phases of Software development life cycle.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2012, XML, MS Access 2010, Excel, VBA (Visual Basic for Applications), NetApp.



Worked for the team that is responsible for receiving, documenting, processing the claims including the eligibility verification. The team is also responsible for making the system changes if there are any changes need to be made in the current policies, rules & regulations due to the business necessities


Modified existing program logic to improve overall system performance.

Created ensuing use cases, report requirements/templates, scope documents, issue tracking and project plans in an Agile environment

Worked with the development team to ensure successful implementation of the project in a fast-paced agile environment.

Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

Handled Source to Target Data Mapping, Technical Specs documentation, and ETL

Used Data warehousing for Data Profiling to examine the data available in an existing database.

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using MicroStrategy.

Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation, and testing for Medicaid Claims.

Designing various reports including sub reports using MicroStrategy.

Worked With HIPAA compliant ANSI X12 837 formats for both professional claims and institutional claims.

Used FACETS Analytics for fast and easy retrieval, display and grouping of information for performing queries and generating reports.

Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.

Working through the phases of SDLC using the Agile methodology

Worked closely with Development team on ETL process, data infrastructure, data modeling, business intelligence reporting and dashboards.

Created Test Cases and Test data after analyzing the BRD.

Responsible for Data mapping testing by writing complex SQL Queries using WINSQL.

Wrote test cases in ALM to cover various scenarios.

Dealt with the EDI transaction claims payments and remittance advice, which deals the payment from payer to provider.

Performed Test execution and wrote and executed Test scenarios/Test Scripts

Tested and managed the XML files of the Claims.

Worked with Waterfall methodology during the beginning of the project then transitioned to Agile methodology

Environment: SQL Server 2008R2, Integration Services 2008R2, Visual SourceSafe, TSQL, MS Access.


Bachelors of Science in Business Studies Stockton University New Jersey

Contact this candidate