We provide IT Staff Augmentation Services!

Sr. Data Analyst Resume

Nyc, NY

SUMMARY

  • Over 8+ years of Professional Experience in different environments and platforms including Data Analysis, data warehousing, data modelling, data mapping, data lineage, data profiling, Informatica Data Quality (IDQ), Informatica Data Analyst (IDA), Informatica Power Center and Client - Server applications in Healthcare Industry.
  • Strong IT experience in the field of Data analysis, ETL Development, Data Modelling, and Project Management with experience in Big Data and related Hadoop technologies.
  • Strong working knowledge of healthcare standard Health Level Seven (HL7).
  • Strong IT experience in the field of Data analysis, ETL Development, Data Modelling, and Project Management with experience in Big Data and related Hadoop technologies.
  • Strong experience in Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Metadata Management Services and Configuration Management.
  • Extensively used Informatica PowerCenter, Informatica Data Quality (IDQ) as ETL tool for extracting, transforming, loading and cleansing data from various source data inputs to various targets, in batch and real time.
  • Experienced in Installation, Configuration, and Administration of Informatica Data Quality and Informatica Data Analyst.
  • Extensive experience with OLTP/OLAP System and E - R Modelling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional Modelling.
  • Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
  • Expertise with Informatica Data Quality (IDQ) toolkit, data cleansing, data matching, data conversion, data profiling, exception management, reporting and monitoring functions.
  • Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
  • Expertise in Data Modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables.
  • Experience in Medicaid Management Information System (MMIS). Expertise in various subsystems of MMIS- Claims, Provider, Recipient, Procedure Drug and Diagnosis (PDD), Explanation of Benefits (EOB).
  • Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Ab Initio and Informatica Power Center, Informatica Data Quality (IDQ), Informatica Analyst, Informatica Master Data Management (MDM), Informatica Meta Data Manager, Data Stage, SSIS.
  • Complete study and analysis of Revenue Cycle management of the health stream respective to existing billing system, Claims processing etc.
  • Excellent Knowledge in Electronic Medical Record (EMR) module process flow.
  • Experienced in EMR claims process and adjudication in the Medicare, Medicaid and Private Insurance Sectors adherence to HIPPA.
  • Strong experience in Business Intelligence technologies like Cognos, Framework Manager, Report Studio, Query Studio, Cognos connection, Cognos Administration, Business Objects Web Intelligence, Desktop Intelligence, Universe design and Crystal Reports, etc.
  • Good Knowledge of various HL7 EMR systems.
  • Well Versed in creating automated Reports using Crystal Report and SQL Server Reporting Services.
  • Experienced in full life cycle MDM development including data analysis, database design, data mapping and data load in batch.
  • Good Knowledge in Defining the Match and Merge Rules in the MDM Hub by creating Path components, Columns and rules. Implementing MDM solutions and real time enterprise application integration.
  • Strong understanding of FACETS and Facets Data Model working on data model and data extracts.
  • Proficient in Master Data Management (MDM), JDE, ADAPTIV.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
  • Familiar with HIPAA EDI transactions such as 835, 837 (P, D, I) 276, 277, 278 etc.
  • Good exposure at Cognos Data warehouse/ETL and reporting tools.
  • Experienced working in Facets online modules such as Billing, Provider, Claims and Membership modules.
  • Excellent knowledge on Medicare, Medicaid, Medicare Advantage, Medigap, HIPAA Standards, EDI Transactions (4010), EHR/EMR, HIE and HIX.
  • Exposure to implementation and operations of data governance, data strategy, data management and solutions.
  • Experience in SQL, DML, and DDL, writing complex SQL queries and testing scripts for data validation against relational Databases including Data warehouse systems.
  • Working knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
  • Thorough working knowledge of SharePoint and MOSS, (TFS) Team Foundation Systems and Visual Studio Team System (VSTS).
  • Experience with healthcare system, Medicaid and with prime focus on claims adjudication, provider, eligibility and prior authorization.
  • Expertise in handling SQL queries and optimizing them in Oracle, SQL Server, MS Access and Teradata.
  • Expertise in understanding and supporting the client with Project Planning, Project Definition, Requirements Definition, Analysis, Design, Testing, System documentation and user training.
  • Well versed in writing queries/Scripts for Data Analysis and QA reporting and testing.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

Sr. Data Analyst

Responsibilities:

  • Worked with Data Analysis Primarily Identifying Data Sets, Source Data, Source Metadata, Data Definitions Data Formats, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.
  • Created various profiles using Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ), from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.
  • Responsible for envisioning and architecting the enterprise-level Identity and Access Management Infrastructure initiative, addressing the need for compliance with the HIPAA regulations pertaining to security and privacy of patient health information. Importing large amount of data (Enrollment, Medical claims, Pharmacy Claims) from various healthcare group to SCIO SAS system.
  • Created and enhanced the existing reports and dashboards in Cognos 11.x query studio and report studio to fit user requirements.
  • Created a relational model and dimensional model for online services such Clinical EMR records.
  • Designed and developed MDM data model and integration of WebSphere Process Server.
  • Worked with Data Architect in Designing the CIM Model for Master Data Management.
  • Used knowledge of Health Care Information Systems EMR model to develop proposed workflow in MS Visio.
  • Expertise in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server.
  • Involved the implementation of MDM concept with upstream and downstream integration of different applications in agile environment.
  • Developed various charts and graphs like bar chart (side-by-side, stacked), line graphs, pie -charts etc. by using chart expert of Crystal Reports.
  • Performed medical claims analysis and reporting using Cognos Impromptu, MS Office reporting tools.
  • Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
  • Implemented a MDM process to take strategy to roadmap and design development activities. Delivered MDM roadmap & MDM Architecture.
  • Created a road map for the client for the planning, developing, and implementing of MDM solutions, enabling consolidation of MDM data following Mergers and Acquisitions.
  • Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and Teradata databases.
  • Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
  • Participated in Facets Table data Modelling planning, designing, implementation of the data warehouse and conducted testing by developing complex SQL queries.
  • Executed SQL scripts in Netezza data warehouse to ensure marketing campaigns can extract and post correctly to health care providers and consumers.
  • Worked with the business/functional unit to assist in the development, documentation, and analysis of functional and technical requirements within FACETS.
  • Worked on Facets Output generation, Interface development and Facets Migration Projects.
  • Manage the online Master Data Management request tool for new requests ensuring proper decision-making on master data creation, data standardization, duplication checks, data field accuracy and completeness while meeting acceptable turnaround time. Complete large database cleanup projects to ensure data integrity.
  • Created business requirement documents for EDW sourcing projects.
  • Reviewed EDI companion guides for all payers to ensure compliance, edit integrity and maintain up-to-date list of payers’ contacts.
  • Worked on Implementing metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
  • Generated complex SQL subqueries with inner, outer joins, and aggregate functions to update and delete data in Oracle database and Netezza data warehouse.
  • Provide technical support for the Master Data Management environment for implementing fixes for identified data integrity and customer data processing issues.
  • Ensured different internal external systems exchanged data according to the specification to transform data from enterprise data warehouse to SQL Server load data to fact tables.
  • Performed SQL Backup and Restore tasks on Various SQL Servers.
  • Document and communicate changes throughout the user organization, supporting Information System Change Management (ISCM) and compliance.
  • Acted as a Data Steward for Reference Data Management.
  • Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
  • Served as a liaison between the internal and external business community (Claims, Billing, Membership, Capitation, Customer service, membership management, provider management, advanced Healthcare management, provider agreement management) and the project team.
  • Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
  • Conducted user interviews and documented business and functional requirements. Assisted quality assurance team to functional-test the new HL7 interfaces always keeping in mind HL7 and HIPAA guidelines, and coordinated user acceptance testing using derived test data.
  • Tested the HL7 File formats received from different Vendors validated the parsing and Data Loader (BizTalk, SSIS Process) functioning using SQL Statements in the backend.
  • Analyzed the root cause analysis for batch job failures and online application failures and take the appropriate action to avoid the batch delays.
  • Defined, developed specs for federal reporting specific to Medicare Advantage. Contributed to software process-reengineering efforts aimed at evolving previous software development practices to adopt Lean/Agile and Scrum practices.
  • Preparing System Test Cases from functional and technical requirement and Use case documents and performing System Testing. Data mapping, logical data Modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
  • Extensive involved in Conducting Market Research, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
  • Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams.
  • Highly involved in data reporting, exchange, and archival, data conversion functionalities, validation programs, keyword resources, related products, services, and information

Confidential

Data Analyst

Responsibilities:

  • Worked on designing and developing data management application on with central operational database.
  • Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
  • Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
  • Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
  • Designed and implemented tables, Created Indexes, Stored Procedures, Functions, Triggers and DTS Packages to transfer data between servers in a SQL Server environment.
  • Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
  • Evaluated Data from EMR for Clinical Workflow Data.
  • Worked with the business product owners and Data Architects to understand new functionality of EMR.
  • Worked on data and report analysis, design and implementation using Crystal Reports combining data from various sources using different schemas which required intricate data manipulation to combine the data and provide numerous and varied levels of reports.
  • Created and enhanced data models in Cognos frame work manager to fit BI requirements.
  • Designed SSIS Packages to transfer data between servers, load data into database on SQL Server 2005 environment and deploy the data.
  • Responsible for Installing, Mastering data with Info Sphere MDM Server.
  • Reviewed developer SQL code to ensure adherence to client standards and general best coding practices.
  • Tested the changes for the front-end screens in FACETS related to following modules, test the FACETS batches membership, Billing, Provider.
  • Created Data profiling stored procedures using dynamic SQL as well as generating complex scripts to schedule various maintenance tasks.
  • Create and managed requirement types and traceability relationships.
  • Apply knowledge experience of HIPAA Act Rules and Regulations HIPAA transactions.
  • Perform research on Member, Provider, Claims, Authorization, Appeals and Grievances data from Facets back end and front-end application system for reporting purposes.
  • Extensive involvement in data mapping using Facets data model.
  • Implemented metadata standards, Collibra Data Governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
  • Responsible for designing and developing Enterprise Data Warehousing solutions (Netezza).
  • Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.
  • Extensive use of Facets back end tables and front-end application system for data validation purposes.
  • Medicare Part C plan also provides some of the extra coverage of a Medigap insurance policy.
  • Design of tools dependent on changing data using Access Tableau. Presentation of data visualization using PowerPoint Tableau.
  • Duties included maintenance of existing and development of new Unix Korn and C shell scripts for sales/marketing EDI data extraction and uploading to Excel spreadsheets and MS Project files
  • Identified gaps and performed gap analysis with respect to CMS requirements.
  • Used MS-Visio for flow-charting, process model and architectural design of the application.
  • Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using Modelling tools.
  • Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
  • Extracted data from disparate sources by SAS/ACCESS.
  • Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
  • Involved in formatting data stores and generate UML diagrams of logical and physical data.

Confidential

Data Analyst

Responsibilities:

  • Created various data quality mappings in Informatica Data Quality (IDQ) tool and imported them into Informatica PowerCenter as mappings, mapplets.
  • Extensively used Informatica Data Quality transformations - Labeller, Parser, Standardizer, Match, Association, Consolidation, Merge, Address Validator, Case Converter, and Classifier.
  • Implemented metadata standards, Collibra Data Governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive Modelling.
  • Worked with FACETS Team for HIPAA Claims Validation and Verification Process.
  • Worked on requirements of the 835, 276, 277, 837, and HIPAA transaction across the enterprise.
  • Met with the Provider and Trading Partners to ensure that HIPAA transactions pass the EDIgateway and interpret technical difficulties into simple language.
  • Designed a high-level spec document to show various paths that need to be taken into consideration for the transformation phase of 4010 to 5010.
  • Managed functional requirements for interfaces and conversions between other legacy systems to Teradata, MDM, Enhancements, Workflows and Reports for MDM.
  • Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
  • Performed ETL Testing/Validation (Designed and documented test strategy, test plan, test cases, test results, etc.) using Cognos reports to ensure data quality.
  • Evaluation and selection of various MDM technologies and products in view of the client requirements.
  • Used SQL Server Reporting Services SSRS to schedule reports to be generated on predetermined time.
  • Involved in Service Oriented Architecture SOA of the claims processing system.
  • Worked on developing the business requirement and use cases for FACETS batch process, automating the billing entities and commission process.
  • Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Created source table definitions in the DataStage Repository by studying the data sources.
  • Interacted with business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
  • Developed SQL queries and tables which replicated the ETL, and compared the SQL results with the Informatica tables.
  • Define downstream targets for MDM with design for attributes and sync methodologies.
  • Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
  • Created surrogate key tables to map the required dimensions.
  • Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
  • Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.
  • Troubleshot the designed jobs using the DataStage Debugger.
  • Tuned DataStage transformations and jobs to enhance their performance.
  • Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
  • Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
  • Created jobs sequences. Provided data Modelling support for numerous strategic application development projects.
  • Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QAs and Technical Support teams.
  • Created job schedules to automate the ETL process.
  • Enhanced the job properties for performance tuning.
  • Prepared the documentation of Data Acquisition and Interface System Design.

Confidential, MO

Data Analyst

Responsibilities:

  • Designed and developed MDM data model and integration of Web Sphere Process Server.
  • Involved in Creating and maintain data model/architecture standards, including master data management (MDM).
  • Extensively tested the ETL mappings which were developed to load data from Oracle and SQL Server sources into the Oracle Staging/Target Area
  • Involved in (Master Data Management) MDM to help the organization with strategic decision making and process improvements. (streamline data sharing among personnel and departments)
  • Used MDM tool to support Master Data Management by removing duplicates, standardizing data (Mass Maintaining), and incorporating rules to eliminate incorrect data and filter data as per requirements.
  • Created SQL tables with referential integrity and developed queries using SQL, SQL*PLUS and PL/SQL.
  • Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
  • Involved in conducting presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
  • Designing test scripts for testing of Claims in Development, Integration and production environment.
  • Tested the HL7 File formats received from different Vendors validated the parsing and Data Loader (BizTalk, SSIS Process) functioning using SQL Statements in the backend.
  • Participated in all phases of the Facets Extended Enterprise (TM) administrative system implementation including the planning, designing/building/validation (DBV), and Go-live support phases.
  • Assigned tasks among development team, monitored and tracked progress of project following agile methodology.
  • Helped design data warehouse solutions and business intelligence dashboards and scorecards.
  • Identified the impacts the HIPPA 5010 project had on enrollment Claims, FEP (Medicare and Medicaid program). Maintained proper communication with the developers ensuring that the modifications and requirements were addressed and also monitored these revisions.
  • Involved in compatibility testing with other software programs, hardware, Operating systems and network environments.

Hire Now