We provide IT Staff Augmentation Services!

Technical Lead Resume

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.

Hire Now