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.