SUMMARY:

• Working as ETL Technical Lead in Confidential and responsible for analysis, data extraction & loading techniques, implementing best practices and manage deliverables of data warehouse for a healthcare client.
• I have been involved in core design & development of Informatica Power Center, Informatica Power Exchange, Power shell, Unix, PL/SQL & Control - M Components.
• Total 11+ years of experience of which 3+ years of experience in Healthcare industry with sound understanding of Member, Provider and Claim domains data.
• 3 years of experience in Financial & Investments Domain with sound functional knowledge of the finance industry.
• 4.5 years of experience in Life Sciences & Healthcare domain.
• Having sound functional and business understanding of US Pharmaceutical processes.
• 9+ years of experience in Data Warehousing and Business Intelligence.
• I have been involved in analysis, design and development, unit testing of Informatica mappings and Crystal Reports/ Business Objects Reports.
• Excellent Communication, analytical and problem solving skills.
• Strong customer focus, ability to quickly understand customer requirements and respond with a solution, customer focus to ensure the finished product/service meets customer requirements.
• Proficient in working with IT/business managers to effectively prioritize activities and achieve defined objectives.
• Skilled at customizing documentation to communicate complex technical information to all levels of end-users.

TECHNICAL SKILLS:

Data Warehousing: OLAP, OLTP, Star Schema, Snow Flake Schema, RDBMS

Data Modelling: IBM Unified Data Model for Healthcare (UDMH) v 9.3.1, Erwin Web Portal v9.7

Models: Waterfall, Agile

ETL Tools: Informatica Power Center 9.x, 10.x, Informatica Power Exchange 10.2.0

Databases: SQL (Oracle 11g, Oracle 12c), SQL Server 2012

Scripting Languages: Unix Shell Scripting, Windows Batch Scripting, Power Shell Scripting

Scheduling Tools: Control M v8.x, 9.x

Operating Systems: Windows 98/NT/2000/XP/8, UNIX, Linux, MS-DOS

Reporting Tools: OBIEE, Crystal Reports 2008, Business Objects XI R3 Web Intelligence, Business Objects R4 LaunchPad, Business Objects R4 Interactive Analysis

Other Tools/Packages: Remedy, TOAD, SQL Developer, SQL Plus, Reflections, Quality Center, Bamboo for CI/CD, JIRA, SVN, Informatica Analyst, Informatica Metadata Manager

Business Development: Proof of concept development.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Informatica Power Center 10.2.0, Microsoft SQL Server 2012, T-SQL, Windows Batch Scripting, Control M v9, Informatica Analyst, Informatica Metadata Manager, Informatica Power Exchange, IBM UDMH v9.3

Technical Lead

Responsibilities:

• Worked with Business Analysts and with the project team to understand the business requirements.
• Undergone IBM UDMH (Unified Data Model for Healthcare) training.
• Worked with Data Modelers in the team to gain deep understanding of the data model, business terms, analytical requirements & supportive content
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and loading strategy designing.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Involved in code reviews for offshore team as per Informatica best practices and standards
• Developed Windows batch scripts for automating Informatica Code Deployment process using deployment groups.
• Developed a framework to accept the IBM Business Glossary (exported in xml format), parse and generate the data in an excel spreadsheet format which could be loaded into Informatica Analyst tool.
• Developed ETL Batch Summary Report using Power shell scripting
• Completed a POC for Change Data Capture (CDC) using Informatica Power Exchange.
• Developed Informatica Mappings using Designer to extract, transform data according to the requirements and loaded into database from relational sources and non-relational sources.
• Extensively used different types of transformations like Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look ups, Update Strategy, Source Qualifier, Joiner, Normalizer
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Resolved bugs in the existing mappings by analyzing the code using debugger.
• Extensively Used Control M tool for batch scheduling/monitor the Jobs.
• Involved in different environments of testing (SIT/UAT/PRODUCTION), trouble shooting of Informatica mappings and SQL queries and also involved in unit testing and developing test cases.

Confidential

Environment: Informatica Power Center 10.1, Oracle 12g, PL/SQL, Unix Scripting, Control M v8, OBIEE, SQL Developer, Bamboo CI/CD, SVN

Module Lead

Responsibilities:

• Worked with Business Analysts and with the project team to understand the business requirements.
• Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, transformation and loading strategy designing.
• Developed Informatica Mappings using Designer to extract, transform data according to the requirements and loaded into database from relational sources and non-relational sources.
• Extensively used different types of transformations like Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look ups, Update Strategy, Source Qualifier, Joiner, Normalizer
• Expertise in Performance Tuning by identifying the bottlenecks at sources, targets, collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Resolved bugs in the existing mappings by analyzing the code using debugger.
• Developed Unix shell and expert in using Unix utilities (sed, awk, vi, grep)
• Extensively Used Control M tool for batch scheduling/monitor the Jobs.
• Hands on Experience in writing, testing, and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL.
• Involved in different environments of testing (SIT/UAT/PRODUCTION), trouble shooting of Informatica mappings and SQL queries and also involved in unit testing and developing test cases.
• Created and executed Unit Test Plans, test scripts for the project scenarios and raising defects in Quality Center.
• Managed the other members of the team through proper communication and coordination with them to ensure deliverables on time and reviewing the work done by them.
• Informatica - Session partitioning, optimal memory provisioning, pushdown optimization and persistent caches
• Oracle - Partitioning, DOP, indexing and gather statistics
• Unix - Parallel execution using nohup and changes to SMT
• Control-M - Draft restructuring to execute jobs in parallel

Environment: Informatica Power Center 10.1, Oracle 12g, PL/SQL, Unix Scripting, Control M v8, SQL Developer

Senior Team Member

Confidential

Responsibilities:

• Managing ETL operations: Job-stream definition and management, parameters, scheduling, monitoring, communication and alerting.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Understanding of SQL execution plans and tweaking the queries for best performance.
• Used session partitioning, database partitioning, persistent look up caches, Informatica best practices, DTM buffer size concepts to increase the performance of the mappings.
• Created an email utility to shoot out batch progress notification which also helped to set the bench lines for the batch execution timings.
• Developed an ETL data rejection notification framework with machine learning capabilities
• Automated CI/CD process for the platform.
• Created a Control-m xml check utility to point out issues before CI deployments.
• Developed a generic database statistics gathering framework which helped in smoothening the batch runs

Confidential

Environment: Informatica Power Center 9.0.1, Oracle 12g, PL/SQL, Unix Scripting, Control M v8, OBIEE, SQL Developer, Bamboo CI/CD, SVN

Senior Team Member

Responsibilities:

• Built data marts to suffice business requirements and created both high level and low level designs to cater to the system changes necessary to enhance the platform.
• Involved in data analysis, data profiling.
• Managing and designing mappings with many dimension and fact tables as sources.
• Used ETL tools to process ~10 million transactional records daily and extracted business insights for clients.
• Created complex mappings which involved Slowly Changing Dimensions.
• Involved in writing UNIX shell scripts for developing complex and high performance ETL solutions.
• Implementation of Business rules and capturing the deleted records in the source systems.
• Extensively involved in Recovery process for capturing the incremental changes in the Source systems for updating in the staging area and data warehouse respectively.
• Created Dashboards using OBIEE to visualize client-Asset data for marketing products according to client’s age and portfolio
• Acted as Subject Matter Expert on Sales & Assets entities of the Enterprise Data Warehouse
• Created an automated utility for performing the Sales/Assets reconciliation at different hierarchy levels

Confidential

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL, Unix Scripting, Business Objects XI R3, TOAD, Regulus

Senior Team Member

Responsibilities:

• This project helped in reporting the consolidated data to higher management at global level through a single repository.
• I was primarily involved as Reporting resource in this project but I pitched in for ETL development as per the project needs due to resource crunch.
• Helped in creation of automated test scripts for testing different scenarios for the project.
• Involved in core development of Informatica Interfaces (creation of workflows, session, mappings, complex SQL queries)
• Extensively worked on Informatica Designer Components Source and Target Analyzer, Transformation Developer, Mapping Designer, Workflow Designer.
• Developed various mappings to load data from sources using different transformations like Router, Aggregator, Joiner, Lookup, Update Strategy, Expression and Sequence Generator to store the data in target tables.
• Parameterization of mappings so as to avoid hard coding as a single Interface/workflow comprised of more than 1 mappings.
• SQL Query Tuning at Source Qualifier and Look up Transformation level for faster Interface runs.
• Documentation of ETL Mappings to minutest details so that code could be rebuilt from scratch in case of potential code loss.
• Worked as Module Lead for the Business Objects Development.
• Design and Analysis of Universe as per the Data Mart data structure and the reporting requirements.
• Thorough Understanding of Universe Designer functionalities such as Classes & Objects, Derived Tables, Conditions, Joins, Shortcut Joins, Aliases, Contexts, Cardinalities, Loops, Aggregate Awareness, Index Awareness, Cascading Prompts, Access Restrictions etc.
• Development, Testing & Deployment of Web Intelligence Reports using Infoview/Rich Client tool.
• Weekly interaction with site SMEs (Subject Matter Experts) regarding the status update and clarity of requirements.
• Preparing the Universe Design Document, Report Validation Documents, Visualization Test Summary Report and Visualization Test Plan.

Confidential

Environment: Oracle 10g, Business Objects XI R3, Business Objects R4, TOAD, Regulus

Team Member

Responsibilities:

• Analysis of existing Business Object Universe.
• Design & Development of Business Objects Web Intelligence.
• Peer review of reports, design documents, unit testing reports and test scripts developed by other team members.
• Suggesting and implementing value additions to improve quality of deliverables.
• Presentation of developed reports to the client.