SUMMARY

• Sr. Data Conversion Specialist with 8+ years of experience working in software development lifecycle, data migration combined with outstanding track record of transforming business ideas into conceptual models and software solutions.
• Excellent at collaborating with clients, self - organized, demonstrated ability to facilitate discussions and have a strong desire to influence and meet commitments to lead and excel in project deliverables.
• Highly experienced in data mart life cycle development and ETL procedure to load data from different sources into data marts and data warehouse using Power Center Repository Manager, Designer, Server Manager, Workflow Manager, and Workflow Monitor. Extensively worked with Informatica Mappings, sessions and workflows
• Proficient in defining Data specifications, create Data Models, Data Mapping and Data Migration documents in support of Legacy migration or stand-up of new server environment for system and architectural enhancements.
• Experience in Extracting data for creating Value Added Datasets using Python, R, SAS, Azure and SQL to analyze the behavior to target a specific set of customers to obtain hidden insights within the data to effectively implement the project Objectives.
• Experience in azure services DB deployment, management, bckup activities and monitoring .
• Extensive hands-on and HealthCare management experience in a variety of projects involving thecustomization, design, development, implementation, and testing of automated systemsto support the Medicaid Management Information System (MMIS) as well as day-to-day business operations.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle
• Expert in documentation, create Business Requirements document (BRD), Functional Specification document (FSD), Object Definition Document (ODD), Data Migration and Utility documents.
• Excellence in UML Modeling, design of Use Cases, Flowcharts, Business Process Models and Expert in creating KPI Dashboards, deliver presentation to project team and senior management on Reports across UI spec and Data flow.
• Experience in Oracle to Azure SQL DB migration (SSMA, ADF)
• Experience in using SQL queries, Stored Procedures and PL/SQL programs for data validation and data extraction, and Customizing SQL queries as required.
• Expertise in ICD-9 to ICD-10 Conversion.
• Understanding of NoSQL and BigData technologies such as Hadoop, MongoDB, Cassandra.
• Hands on experience organizing requirements, detailed Test plans, test strategies and procedures, test scripts, Test cases and test reports and thus managing Life Cycle of various cross functional projects using all the modules in HP Application Life Cycle Management (ALM), Rally, Quality Center.
• Expert in creating wireframes, UI mock-up screens, design and develop prototypes using Balsamiq and integrate with Atlassian Jira.
• Create Storyboards, prioritize User Stories, conduct requirements walkthrough and contribute to software release plan in Continuous Delivery Pipeline.

TECHNICAL SKILLS

Modeling Tools: MS Visio, Rational Rose, Mockup Screens, Requisite pro, Clear Case, Clear quest

Project Management Tools: JIRA, Rally

Data Warehousing: Data Marts, OLTP, OLAP, Query/Reporting

Data migration: ORACLE, AZURE, SQL SERVER

BI Reporting Tools: Tableau 8.3, Crystal Report, IBM Cognos 10, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Database: MS SQL Server 2012/2008/2005 , Oracle 8/9/10/11

ETL Tools: Informatica, Data Stage

QA Testing Tools: HPALM, HP Quality Center

Web Technologies: HTML, CSS, JavaScript, XML, AJAX, C#, python

Documentation Tools: MS Office Suite, Share Point 2010/2013

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst / Specialist

Responsibilities:

• Developed and improved existing test automation frameworks
• Utilized parallel processing or grid systems to speed up the tests.
• Collaborated with cross-functional teams to understand complex interaction between systems .
• Experienced on delivering solutions using agile delivery practices .
• Established test metrics to measure not just product quality but also quality of testing and feedback to engineers.
• Performed detailed test designs sound software engineering principals in the context of test automation platforms and integration across distributed systems .

Environment: Behavior driven development (BDD) cucumber, SQL, Selenium Webdriver, JMeter, JIRA, COTS

Confidential, Boston, MA

Senior Data Analyst/Data Migration lead / Data Conversion Specialist

Responsibilities:

• Subject Matter Expert for Health Insurance Exchange program with Enrollment and Eligibility modules.
• Coordinated with Product Owner and Business teams for the testing and implementation of EDI 270/271 changes to meet regulatory and compliance.
• Work with 3rd party vendors and TPA partners, communicate with Providers on errors in EDI files.
• Worked on Enrollment and Eligibility files EDI 834 and EDI 837, triage issues in Membership data.
• Managed the team of consultants responsible for developing on-demand Medicaid Management System (MMIS) reports.
• Coordinated with State Health and Regulatory Affairs (Contracts Administrator, Director-Office of IT, Medical health n human services SME) to document Medicaid requirements, Explanation of Benefits and modification to Claims calculations based on legislative changes.
• Enhancement of existing Oracle forms and reports adding new features based on user requirements.
• Created user defined stored procedure PL/SQL Developer for data conversion from flat files to Oracle database.
• Created Data Mapping documents for EDI X12 data elements to XML, and XML Mapping to DSS (Decision Support System), EDW and reports server, used Office365 to document data Mapping.
• Used Erwin to create Data Models for EDW changes, enhancements to Medicaid tables to support HEDIS reports, provided demonstration to business and IT teams on Logical Data Model (LDM).
• Used predictive modeling with tools in SAS, R, Python.
• Experience in Data Warehouse development working with Data Migration, Data Conversion and extraction /Transformation/Loading using Data Services with Oracle, SQL Server.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle.
• Worked and extracted data from various database sources like Oracle, SQL Server, DB2, and Teradata/Big Data.
• Coordinated with development team to document, develop, implement, monitor and maintain data warehouse extracts, apply transformation rules and cleanse data in ETL process.
• Experience with writing scripts in Oracle databases to extract data for reporting and analysis.
• Integrate complex Medicaid principles and policies into the Medicaid Management Information System (MMIS), requiring knowledge in areas of health systems and Medicaid information processing.
• Used SQL queries to perform data analysis, used SQL Joins to validate ETL completed data, validate Transformation rules in the system of records and ensured data quality.
• Worked on RESTful API integration with application modules for end user functionality.
• Involved in Python and R to conduct data analysis and researched on molecular study, used Probability, Inference and Modeling techniques.
• Used DB compare utility to compare source to target Mappings, compare objects and data, Views, Functions, Procedures, Triggers and Events for re-write of stored Procedures.
• Reviewed consumer and provider data to verify integrity and consistency for completeness, accuracy and suitability and implemented business logics to solve the performance issues.
• Performed the requirement analysis and documented BRD and FSD in JIRA.
• Highly involved in data reporting, exchange, and archival, data conversion functionalities, validation programs, keyword resources, related products, services, and information.
• Managed the road map for data migration and development.
• Performed Data Migration for Plant Maintenance. Executed two releases of data migration. Performed and coordinated end to end data migration for Work
• Orders, Notifications, Functional Locations, Equipment’s, Task list, Maintenance.
• Designed file templates for data mapping
• Designed transformation rules for data enrichment.
• Resolved and developed mitigation strategies for complex issues in data migration like currency conversion issue, scheduling issues, field length issues etc.
• Executed Data Migration for RLM containers.
• Managed ETL requirements, developed, analyzed and delivered ETL solutions and reported on Claims data, erroneous data, inconsistent data and invalid data that failed in the ETL process.
• Responsible for Document Management, used SharePoint and integration to Office365 and organized project and program documents from BRDs, FSD and Change Control implementation.
• Validated ETL completed data, performed data analysis using SQL queries, validated stored procedures, coordinated with data modeler and offshore development teams for changes to ETL schema design changes.
• Managed system requirements in SharePoint and created project team site, managed project tasks, requirements review and analysis and created requirements management workflows in SharePoint.
• Applied linear regression in Python and SAS to understand the relationship between different attributes of dataset and causal relationship between them
• Wrote SQL queries for data mining, data retrieval, data manipulation and validate transformation rules and conducted Data Profiling using and managed statistical analysis.
• SME and chaired technical reviews, analysis and involved in preparation of functional specifications and technical specifications for web services with XML and XSD Mapping of domain objects.
• Analyzed HIPAA 5010 standards for 837P EDI X12 transactions, related to Providers, payers, subscribers and other related entities and created data Mapping documents for EDI deserialization to ESB topics.
• Coordinated with Scrum team, used JIRA to document Epics and User Stories, conducted Storyboard reviews to senior management and worked with Agile team for incremental delivery into production.
• Conducted Backlog Grooming sessions, managed Product Backlog and Iteration Backlog, created JIRA Dashboard reports, added Labels to User Stories to sort and filter to meet reporting needs.
• Used SQL to data mine and create Data sets that are usable for UAT testing, created Use Case documents and executed test plans for End-to-End testing, printing reports during UAT test phase.
• Worked in importing and cleansing of data from various sources like Teradata and Oracle Server
• Actively analyzed current business processes (Claims, Billing, Recipient Eligibility and Enrollment etc.) and worked with management to improve and implement enterprise solutions to ensure compliance.

Environment: Atlassian JIRA, Balsamiq, Python, R, UML, SQL, Oracle, UAT, MMIS, Tableau 10x, SharePoint, HIPAA, Health Safety Net (HSN), ETL, HP ALM/Quality Center, XML, JSON, EDI 834, 837, 999.

Confidential, Atlanta, GA

Data Analyst/ Data Integration/Conversion Engineer

Responsibilities:

• Worked in Agile framework for product development and delivery, performed User Story documentation, elicit requirements and convert into Agile Story documents and prioritized User Stories for Iterative development.
• Facilitated the establishment and implementation of standards, guidelines and best practices that guide the various MDM and Data Warehouse projects within the organization.
• Initiated Design of ETL architecture solution from already existing ETL processes which are required to be analyzed as a part of the quality assessments.
• Created system documents for Data Migration project, Data Migration plan and requirements for conversion of Horizon Clinicals Data into Paragon Systems Data, wrote User Stories under Data Migration epic.
• Assisted product owner in story allocation, scope estimation, story sizing and documented discovery during development.
• Involved in MDM Process including data modeling, ETL process, and prepared Data Mapping documents based on graph requirements.
• Involved in project cycle plan for the source XML data extraction process, data analysis, transformation and ETL loading strategy designing.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data /Export, Data Conversions and Data Cleansing.
• Conducted weekly backlog grooming sessions with scrum team to complete story development estimates from dev and QA perspective, documented and reviewed Acceptance Criteria for card completion.
• Extensively used SQL statements to query the Oracle and DB2 Database for Data Validation and Data Integrity
• Proficient in defining Data specification, Integration points and create Data Modeling, Data Mapping and Data Migration documents in support of Legacy migration and re-design of server environments.
• Designed Functional Requirements and Functional Specification Document for Family History and Global Patient Profile and Pick list modules and documented User Story description to meet Definition of Done.
• Validated the Macro-Economic data and predictive analysis of world markets using key indicators in Python and machine learning concepts like regression, Bootstrap Aggregation and Random Forest.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Ab Initio GDE and components.
• Created SSIS packages to drive data into Python code for data analysis and conducted reviews and analysis.
• Developed Use Cases, Data Mapping, screen mockups during the functional specifications.
• Assisted Scrum teams in Agile planning, User Story development, Backlog grooming, Sizing and Estimates, product backlog, helped teams in requirements gaps and managed product demo from Story validation and completion.
• Conduct ETL Regression testing and ETL Integration testing to meet business requirements in Data Migration projects.
• Developed use cases,businessrequirement and functional requirement documents for migration project.
• Understand and translate key application concepts from product development to user groups, development teams, quality assurance teams and release engineering teams on systems specifications.
• Communicated and maintained relationship with cross-functional teams, Level 1 and Level 2 support teams from product support, ensured requirements are delivered and shared to teams.
• Participated in User Acceptance testing phase, provided business critical workflows for UAT Test Coverage.

Environment: UML, Agile, MS SQL Server, MS SharePoint, Python, Oracle10, Paragon Suite, MS Visio, MS Office, RTM, Clinical Workstations/PC - Windows, Microsoft TFS, Rally.

Confidential, Los Angeles, CA

Data Integration Analyst

Responsibilities:

• Conducted requirements review for MPS platform, worked with business team, stakeholders, 3rd party vendors for MPS integration and platform services integration to media channels, media streaming and source-to-target Mapping.
• Used Jira to plan, create Epics and User Stories, prioritize and itemize user stories into Sprints for development and iterative testing, coordinated with offsite teams on requirements management and reviews.
• Monitored network traffic on Splunk and to capture API calls made on various NBC applications using URLs and validated the functionality of Ads publish, resource path, media site, data streaming duration and synchronization options.
• Conducted extensive Data Analysis using Advanced Excel and SQL and created Power Query, Power Pivot and Power Charts for data analysis.
• Conducted database validation, coordinated with DB teams in the development of enhancements, table changes, deployment scripts, design, Query Tuning, Procedures, Triggers and Views.
• Studying the current data sources to write business requirements, Data Mapping requirements and functional requirements to consume data in the Enterprise Data Lake and create data for further use by downstream users.
• Created data transformation rules in FSD for data discovery and remediation techniques to meet enterprise Data Quality, iterative measures for improving the quality of data and integration to Enterprise Data Lake.
• Wrote SQL queries for data analysis, validated service operations and API validation, provide forecast on increasing data volumes that increases workload complexity.
• Created Epics and Issues in Atlassian JIRA, documented work efforts, work estimates, story sizing and acceptance criteria for API consumption by front-end applications.
• Coordinated efforts in Data Migration and data conversion from legacy to Oracle platform, documented Data Mapping and data profiling requirements, data transformation requirements for ETL and data integration.
• Thoroughly reviewed application setup and configuration, coordinated release sign-off, resolved issues and facilitated Agile ceremonies by coordination.
• Involved in creating Data Mapping documents using Component Parallelism, Pipeline Parallelism and Data Parallelism in Ab Initio and developed generic graphs for data cleansing, data validation and data
• Conducted analysis on various tools available at the client to recommend the best possible option for different project, for example Informatica Data Explorer, Informatica Data Quality, PowerCenter, MicroStrategy.
• Managing complex software development and integration projects in a fast paced, constantly changing Agile Environment.
• Gathered business requirements and maintained product documentation for EDW enhancements, data acquisition changes by implementing micro-services and designed enterprise Data Lake.
• Excellent in creating various artifacts for projects which include specification documents,Data Mapping and dataanalysis documents.
• Created User Stories to support Continuous Delivery Pipelines by Continuous Exploration, Continuous Integration, Continuous Deployment and Release in Demand to support Agile implementation.
• Responsible for Document Management, used SharePoint and integration to Office365 and organized project and program documents from BRDs, FSD and Change Control implementation.

Environment: SQL, Tableau, Data Migration, MS Project, Requirement Traceability Matrix (RTM), Rational Rose Test, JAD, RUP, MS Visio, Windows OS, MS Office, SharePoint, Server, Quality Center, ETL, SQL Server.