SUMMARY

• 7 years of professional experience in Data warehouse Architecture/Design, Development using INFORMATICA Power Center 8.x/7.x, Dimensional modeling like Star schema and Snowflake schema, Oracle 10G/9i, DB2, Teradata, DB2,MS SQL Server, Informix, PL/SQL,XML. extensive experience in healthcare and Retail industry
• Involved in creating Logical Data model and Physical data model, ETL Migration strategy, Data Lineage and defining the data granularity and surrogate keys creation.
• Architected the Data Integration solutions for Legacy systems and Data conversion projects using Informatica
• Recommended efficient Indexing strategy on large volume data warehouse tables and improved the ETL and BI Reports throughput effectively.
• Have good hands - on experience in creating technical design document, ETL architecture, ETL Process design, ETL logic conversion, Deployment, Production Data volume estimation.
• Strong understanding of Normalization. Good understanding of Data warehousing concepts like star and snowflake schema and well as fact and dimension tables.
• Good understanding of ETL concepts and related technologies. Some experience working with migration of data cross platforms like Oracle, SQL Server and Teradata.
• Have good experience in Web Services, Technical Metadata consolidation, Defining Project Scope, Milestone based Deliverable Strategies, Database size estimation, Data Archival.
• Have good hands-on experience in designing and developing ETL Processes using Informatica mappings, Sessions, event based Tasks, Workflows, Parameters and Scheduling scripts for ETL processes.
• Experience in developing both client-server and web-based applications..
• Understanding of Business Rules and implementing them into Business Process Flow.
• Conducting Requirement Analysis, Feasibility Studies, Risk Analysis, and Adaptability Studies, Base lining Acceptance Criteria and Deliverables, and then organize Review Meetings with the Stakeholders and End Users towards identifying the Business Critical Requirements and finalizing the Software Requirements Specifications (SRS).
• Created Functional and User Acceptance Test Plans, Test Strategies Test Cases, and Test Scenarios to measure requirements and provide a Head Start for the QA Team.
• Used MS Project for scheduling deadlines, resources, and facilities.
• Diversified experience in Data Analysis, Business Analysis and Software Testing.
• Experience working with Oracle, SQL Server, DB2 and Teradata RDBMS systems.
• Experience in SQL, PL/SQL, stored procedures, functions, packages, DB triggers and indexes.
• Strong working knowledge of SQL Querying tools like SSMS, Toad and Teradata SQL Query Assistant.
• Good business understanding and effective at working across multiple teams within an organization.
• Experienced in Tuning SQL statements and procedures for enhancing the load performance in various schemas across databases.
• Strong understanding of DWH concepts like data mining, data quality, data profiling, data cleaning, data scrubbing and data validation.

TECHNICAL SKILLS

Requirement Tracking: Rational RequisitePro, Mercury's Test Director

Automation Testing Tools: Rational Robot, WinRunner, LoadRunner, Quick Test pro

Management Tools: Rational ClearQuest, Test Director, Quality Center, Crystal Reports,ERwin

Languages: C, C++, SQA Basic, SQL, TSL.

Operating Systems: MS Windows NT/98/2000/XP, UNIX

Web/Design Tools: HTML, MS Front Page, Flash, Adobe Photoshop, MS Paint, HTML, XML

Databases: Sql Server 2008,2012,2014,DB2,Oracle, MS Access, Toad

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Data Analyst

Responsibilities:

• Aggregate and mine large volumes of data into valuable analytical insights based on acquisition expense opportunities and risks.
• Compile senior management presentations on a weekly/monthly/ad-hoc basis
• Analyzed campaign performance and provided insights on trends projections and variances against forecast and budget.
• Involved in monitoring months on book customer engagement key. performance indicators and recommended strategy improvements.
• Created reports on trend analyses summary and recommendation for new account premium redemption rates with focus on maintaining annual financial objectives.
• Aggregated and mined large volumes of data from Teradata/Oracle into valuable analytical insights based on acquisition expense using SAS Base and Macros.
• Extensive use of SAS, SQL and Excel (Pivot tables, VLOOKUPS, Macros).
• Expertise in SQL.

Confidential, NJ

Sr. Data Analyst

Responsibilities:

• Responsible for Design, Development, Administer and automation of ETL processes.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Extensively used Informatica- Power center for extracting, transforming and loading into different databases.
• Coordinating with source system owners, day-to-day ETL progress monitoring.
• Working as a support professional on a project that required developing data for SQL Server 2012 and DB2.
• Responsible for Design, Development, Administer and automation of ETL processes.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Coordinating with source system owners, day-to-day ETL progress monitoring.
• Installed, Maintained and Documented the Informatica setup on multiple environments.
• Created, executed and managed ETL processes using Informatica.
• Coordinating with source system owners, performed data migration and monitored day-to-day ETL progress, Data warehouse target schema Design (Star Schema) and maintenance.
• Extraction, Transformation and Loading of the data using Informatica
• Tracking Shipment from foreign countries, Receiving and Delivering to Spencer Stores for (Halloween).
• Developed queries, triggers, views, procedures, assertions and functions using SQL, PL/SQL.
• Utilized SQL Plus to analyze the back end of applications and websites requiring forms.
• Performed back end validation as part of forms development.
• Collaborated with the QA team for developing scenarios for validation and testing. Involved in the User acceptance Testing (UAT) and documented the test scenarios and outcomes. Worked with several off-shores teams and onshore resources. Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.
• Writing SQL Codes on daily Basis.

Confidential, Danville - PA

Data Analyst

Responsibilities:

• Developed a data profiling strategy to ensure data integrity for all feeds using Informatica Analyst v9.x., created ODBC connections from Informatica Analyst to various source systems.
• Created ETL mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Developed complex mappings in Informatica to load the data from various sources using different transformations
• Tuned Informatica Mappings and Sessions for optimum performance.
• Designed ETL specification documents to load the data in target using various transformations according to the business requirements.
• Extensively used Informatica- Power center for extracting, transforming and loading into different databases.
• Used session partitions, dynamic cache memory, and index cache to improve the performance of Informatica server.
• Debugged the mappings using the Debugger facility in Informatica. Used the target load order feature for loading tables with constraints\
• Developed SQL queries to check the post ETL data using ROLLUP function.
• Developed Unix Shell scripts to automate ETL execution, Test data preparation, Results logging.
• Quickly ramped up to become the point of contact, for the upcoming Phase 2,3 requirements in the M 3.2 releases.
• Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes
• Worked closely with ETL developers on the Various XML feeds to analyze how participant, Member, Provider data can be used with all the metrics.
• Acted also as a member of the Quality Assurance team, identifying source to target mapping (STTM) and requirements defects, and documenting recommended solutions
• Took strong initiative to lead integrating data coming multiple domains(Patient && Member) by understanding the data structure and build the target xsd of the HSIS application.
• Defining the data validation rules to run against the authorizations and claims from the transactional system. Worked as a Hands on member for the ICD-9 to ICD-10 migration project.
• Implemented the Match && Merge(Trust settings) for the Semi Enterprise MDM data of the Member for the Next gate feeds.
• Create the strategy for the Error Handling techniques and ftp jobs(Batch Jobs) for the business stake holder to review data for the Error out claims.
• Provided a strong SQL skill set for the Data Integration team to ensure the development of data feeds are implemented successfully.
• Fostered strong team work on the project by assisting fellow DAs/BAs on the Data Integration team, answered questions from business.
• Written functional and High Level documents for the EDW team- Partially helped them for re-writing the Low-level design documents for the ETL and Reporting purposes.

Confidential, Providence - RI

Data Analyst

Responsibilities:

• Maintained data consistency, database integrity and reported instances of data corruption.
• Provide the team with technical leadership on ETL Design, Development best practices, Version Controlling and customization of Data loads.
• Installed, Maintained and Documented the Informatica setup on multiple environments.
• Created, executed and managed ETL processes using Informatica.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for reports.
• Perform source-to-target mapping (STTM) and building database schema in an SQL 2008 environment including creating scripts and procedures for production migration
• Create ETL migration strategy document, Integrate Data stage Metadata to Informatica Metadata and created ETL mappings, sessions, workflows in Informatica.
• Implemented business rules on data using Stored Procedures, Functions and Packages.
• Solid program development and business process knowledge - utilized effective communication skills
• Performed data quality checking.
• Used Teradata OLAP functions like random, qualifies, top n, csum, sample and random. Teradata SQL performance tuning.
• Data migration between different environments and Third Party Databases.
• Using Oracle SQL, SAS procedures, packages, functions, database triggers to developing and execute reports for performance and response purposes
• Created drill down analysis reports using SQL Server Reporting Services.
• Extracted data from Teradata and Oracle and created pivot tables in Excel.
• Created Transformations and Mappings by using Informatica Designer
• Processing tasks using Workflow Manager in order to move data from multiple sources into targets.
• Examines existing data and makes recommendations for improvement/efficiency. Resolved requirements and design issues.
• Involved in meetings with director of analytics, project manager and other stakeholders to identify the cost associated, values delivered and break even time
• Responsible for converting the IMS Data to required structure using Informatica
• Developed and tuned all the Affiliations received from IMS and other data sources using Informatica and tested with high volume of data.
• Worked on analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA 5010 requirements.
• Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions, related to providers, payers, subscribers and other related entities.
• Identifying the requirements for accommodating HIPAA 4010 and 5010 standards for EDI X12 transactions and capture these requirements for mapping purposes.
• Mapped the standard 4010 and 5010 elements to the associated Java classes for rules processing
• Mapped the Bloodhound tool (clinical editing tool) related data elements to the internal XML elements.
• Created the data dictionary for the clinical aberrancy rules
• Participated in the testing process, ensuring testing verifies the user requirements.
• Works to continually improve the quality and efficiency of business systems
• Aided in management and documentation of all project deliverables as well as training knowledge based articles.

Confidential, Alameda, CA

Data Analyst

Responsibilities:

• Spearheaded life cycle implementation of McKesson HEDIS (Health Plan Employer Data Information Set) and CRMS (Care Enhance Resource Management Software) quarterly data warehouse projects.
• Automated the CRMS quarterly. Non-HEDIS and CRMS HEDIS data warehouse ETL processes.
• Instrumental in designing and transforming the monthly manual ETL process of diamond OLTP data files, (a three day process), to an automated, weekly ETL process that only takes eight hours, a 66% processing time improvement.
• Analyzed critical business, data and application issues that were crucial for management reports and data warehouse projects, alerted and proposed possible solutions to the business owners and functional managers.
• Developed high-level business requirements, in-depth data analysis and detailed use cases for Medi-Cal pricing project that was substantial for management to negotiate new contracts with the delegated vendors.
• Own ETL rules for data transfer from different Teradata databases to DataWarehouse
• Conduct Enterprise Analysis and define Solution Scope and Solution Approach
• Analyzed, designed, developed and implemented 834, 837 HIPAA EDI maps for several trading partners.
• Developed and optimized convoluted stored procedures, scripts, Extraction Transformation and Load (ETL) process and database objects.
• Actively involved in performance tuning at source, transformation, target and workflow levels.
• Designed and developed data mappings based on the business requirements and business rules to load data from OLTP legacy source text files to optimized relational target tables.
• Support Unit, Integration, Regression and UAT testing

Confidential, Nashville, TN

Data Analyst

Responsibilities:

• Worked with Informatica Power Mart client tools like Source Analyzer, Warehouse Designer, Power Exchange Data Capture and Mapping.
• Developed Mappings, Mapplets, Parameters and processes in Informatica to implement business rules and standardization of source data from multiple systems into the data warehouse.
• Developed SQL queries to check the post ETL data using ROLLUP function.
• Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.
• Developed Unix Shell scripts to automate ETL execution, Test data preparation, Results logging.
• Analyzed the existing Claims Direct Data Entry (DDE) application
• Worked on analysis of the Facets claims processing application in order to gather requirements to comply with HIPAA requirements.
• Conduct gap analysis between the current system and new requirements to be implemented thereby mapping the business requirements to the application
• Prepared high level and detailed system requirements documents for the application
• Analyzed HIPAA standards for 837P transactions, related to providers, payers, subscribers and other related entities.
• Identified the requirements for accommodating HIPAA standards for 837P transactions and captured these requirements to develop new GUI for the internet based application.
• Identified claims processing functions for different payers including Medicaid, Medicare and other commercial payers.
• Worked with CMS 1500 claims standard required for Medicare and Medicaid processing and utilized it to provide a CMS 1500 view within the claims application.
• Involved in daily Scrums to determine the status of the project and impediments, if any.
• Involved in sprint planning meeting to identify the tasks for the sprint and getting team members acceptance/commitment for the assigned tasks.
• Involved in Sprint review meeting with the team and stakeholders to review the achievements from the sprint and get approvals.
• Debugged the mappings using the Debugger facility in Informatica. Used the target load order feature for loading tables with constraints.
• Worked with Informatica Power Mart client tools like Source Analyzer, Warehouse Designer, Power Exchange Data Capture and Mapping.
• Identified the requirements that go in each sprint, collect them in the sprint backlog and collecting and managing the requirements that are not part of the current sprint into the product backlog.
• Designed the Internet based application and managed the business and design specifications in the business specific wikis.
• Write high level and low level business requirements and design mock-up screens for the application
• Analyzed the existing data model and provided suggestions and recommendations
• Validated the requirements and mock-up screen designs of new GUI for internet based application with the product owner and other stakeholders
• Conducted meeting with the team members to discuss the requirements and mock-up screens
• Involved in designing the mock-up screens of the new GUI for claims entry
• Conducted meeting with the product owner to validate the requirements and mock-up screens for new GUI
• Translated the requirements prepared for SDLC methodology to User Stories and implementing Agile methodology as a standard for the ongoing project
• Wrote user stories and acceptance criteria for the requirements of the project.
• Involved in daily scrum meeting to discuss any roadblocks or impediments in the project path
• Involved in sprint planning session to identify the features and functionalities that should be achieved by the new application
• Identified various points of integration among the new and existing applications and required integration with other IT components
• Worked closely with the business team, development team and the quality assurance team to ensure that desired functionalities will be achieved by the application
• Provided business and technical suggestions and recommendations during the project life cycle.