SUMMARY:

• Total IT industry experience of over 8 years, which includes technology consulting & professional services
• Domains experience across Banking, Telecom, Life Sciences & Manufacturing
• Hands - on development experience of over 6 years in Data Warehousing implementation projects using Informatica Power Center 9.x and other DW/BI tools
• Strong in Dimensional Modeling, Star/Snow Flake Schema, Extraction, Transformation & Load and Aggregates
• Extensively worked on Requirement gathering, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support and Maintenance of various Data Warehousing Applications
• Strong in converting business requirements to project documentation and technical specifications
• Strong expertise in ETL-Powercenter along with knowledge of ETL-SSIS and reporting tools like OBIEE and Tibco Spotfire
• Proficient in interaction with the business users by attending meetings with the clients in Requirements gathering phase
• Strong expertise in Relational data base systems like Oracle, SQL Server, DB2 and knowledge of AWS Redshift
• Experienced in UNIX work environment, file transfers (FTP, SFTP), job scheduling and error handling
• Subject matter expertise across different Informatica tools - Informatica B2B Data Transformation & Informatica Data Quality(IDQ)
• Extensively worked on Informatica client tools Admin Console, Repository manager, Designer, Workflow manager, Workflow monitor and worked extensively with application teams on complex mappings using different transformations to debug mappings/work flows for error handling and recovery strategies in Informatica ETL environments
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Event Wait, Event Raise, Timer etc)
• Excellent experience with Informatica concepts like Labelling of objects, Versioning, Push Down Optimization
• Well versed in developing complex SQL queries, unions and multiple table joins and experience with Views
• Experienced in filtering and loading only the data that is changed into the data warehouse which is also known as change data capture (CDC)
• Strong knowledge on Performance tuning issues while loading high volume of data and while generating reports
• Proficient in data warehousing techniques like data cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various aspects of the data warehouse infrastructure
• Involved in Unit testing, Integration testing to check whether the data loads into target are accurate
• Expertise in trouble-shooting production issues by root cause analysis to identify the problem, impact analysis to determine the dependencies and providing the resolution
• Experienced in all phases of SDLC using Waterfall, Agile methodology
• Deep understanding & practical experience with onshore/offshore delivery model
• Self-motivated team player with an eye for continuous improvement coupled with strong inclination towards adapting to new technologies
• Technical lead/mentor experience - training/mentoring new associates, prioritization/assignment/tracking tasks based on project targets, inputs for work breakdown structure towards new SOW’s
• Self-Starter and excel in high intensity/challenging work environment
• Excellent problem solving & communication/interpersonal skills, works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change
• Experience in support and knowledge transfer to the production team

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows

Development Tools: Informatica PowerCenter, Informatica IDQ Developer, Informatica B2B Data Transformation, Microsoft SSIS

Reporting Tools: OBIEE 10g, Tibco Spotfire

Languages/Technology: SQL, PL/SQL, UNIX Shell Scripting

Databases: Oracle, DB2, SQL Server, AWS Redshift

Other Tools: Toad, Oracle SQL Developer, WinSCP, FileZilla, Putty

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Informatica Developer

Software: Informatica PowerCenter 9.6.1, Oracle11g, DB2, WinSCP, SQL Developer

Responsibilities:

• Work with Business customers and Business Analysts to analyse business processes, procedures and user requirements in order to establish system requirements and help create BI/DW technology solutions to meet clients’ business needs
• Design systems and processes to capture, integrate and distribute information in an enterprise
• Develop solutions and specifications so that agreed requirements can be converted into functional systems
• Identify and communicate potential impacts of a change/issue to other areas
• Lead system/application design including production of system and program documentation as well as ongoing maintenance
• Develop logical and physical data flow models for ETL applications
• Parsed high-level design specification to simple ETL coding and mapping standards
• Developed mapping parameters and variables to support SQL override
• Develop Informatica PowerCenter components like workflows, sessions, mappings and mapplets
• Delivery of the assigned work within specified timelines with high quality
• Conducted code reviews developed by my team mates before moving the code into QA
• Plan and conduct Informatica ETL unit & development testing activities ensuring that quality meets agreed specifications/requirements
• Achieve key Systems Development Life Cycle (SDLC) stages in terms of quantity, timing and quality of all aspects of work allocated
• Modified existing mappings for enhancements of new business requirements
• Create development and support documentation and provide advice regarding applications to enable support functions to operate effectively
• Contribute to the review and redesign of processes or procedures, on an ongoing basis, to deliver improved system productivity or efficiency
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Resolve production incidents (through diagnosis, testing & applying fix) for assigned application

Confidential, St.Louis, Missouri

Senior ETL Developer

Software: Informatica PowerCenter 9.6.1, Oracle11g, WinSCP, SQL Developer

Responsibilities:

• Estimation and analysis of the work process and designing Business requirement, technical design documents as per client specification
• Designing the Logical & Physical model along with mappings sheets for the ETL layer
• Design and Implement the ETL Layers for Masters entities and its information schema
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Development of Informatica mappings and workflows to load data into the pre-landing area and create JSON file to load into Reltio MDM for different units such as Health Care Professional, Health Care Organisation, Group Purchasing Organisation, Accountable Care Organisation and Integrated Delivery Network
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer
• Involved in Performance tuning at source, target, mappings, sessions, and system levels
• Creation of unix scripts to load source file which includes reading/copying data from sftp server, creating file lists, archiving the source files and merging files for publishing for downstream applications
• Creation of mappings for capturing the audit and reject statistics for the support team
• Created mapping documents to outline data flow from sources to targets
• Documentation of Operational Manuals, Technical Design Specification, Analysis Sheet and Code Review Documents
• Involved in Code Migration of modules into SIT, Pre-Prod environments along with phase releases into Production for Go-Live

Confidential

Senior ETL Developer

Software: Informatica PowerCenter, Informatica MDM, Informatica Developer, Tibco Spotfire, Oracle10g, WinSCP, SQL Developer

Responsibilities:

• Design and Implement the ETL Layers for Reliance Masters and its information schema
• Estimation and analysis of the work process and designing Business requirement, design documents as per client specification
• Development of Informatica Power Center mappings, workflows and scheduling the same
• Executing the batch jobs from the Informatica MDM console for modules such as Location, Subscription, SAP & IDAM
• Creating simple mapplets for basic quality checks using Informatica Developer and later integrating the same in the PowerCenter mappings
• Used various transformations like Source Qualifier, Joiner, Lookup, Sql, Router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement
• Creating scripts for automating the entire process from extracting data from NAS location till the data is loaded in the base objects of MDM along with triggering the mail sent to the concerned stakeholders
• Performance tuning and optimization of mappings, sessions and existing stored procedure, queries.
• Worked on optimization of different key processes of the project
• Created dashboards in Spotfire to display 360 Degree view of the customer based on data from MDM and Greenplum
• Involved in Unit Testing of various modules
• Responsible for End to End Process Implementation and Integration Testing of the modules
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs
• Involved in documentation such as mappings documents, test case document and code review documents
• Planning and Deployment of releases to higher Environments like SIT, Pre Production and Production.

Confidential, USA

ETL Analyst

Software: Informatica9.5.1, Oracle10g, SQL Server, Windows XP/7, Toad, File Zilla

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business
• Build the Acquire and Localize processes based on mapping documents and direction from Data Leads, Super Users
• Involved in new object development which we have never loaded before by developing Informatica Mappings and Workflows
• Add new data cleansing rules, Bug fix to localize based on data action inputs from data leads and Super users inputs
• Using most of the transformations such as the Source Qualifier, Application Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, and Joiner
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica client Tools(Designer. Workflow Manager)
• Using shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load unique number coming from flat file name into Target
• Using Workflow Manager for workflows and session management, Database connection management
• Optimizing Query Performance, Session Performance Delivering objects for client that is correct and on time
• Written documentation to describe program development, logic, coding, testing, changes and corrections
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Involved in production support

Confidential

ETL Developer

Software: Informatica8.5, Oracle10g, Windows XP/7, Toad

Responsibilities:

• Analysis of the business requirements and functional specifications
• Involved in analysis of most of the mappings and workflows that was in scope of the project
• Consolidation and documentation of the analysis sheet that was provided to the client
• Analysed the date table changes that would reflect in other tables
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
• Involved in making changes to current ETL logic
• Adding new columns to target tables
• Extracting additional attributes provided by source to already present target tables
• Optimized the performance of the mappings by various tests on sources, targets and transformations
• Adding history logic to columns as per client requirements hence involved in developing and designing simple extraction queries for meeting the required logic
• Designing and Developing mappings as per the requirement using almost all transformations like router, aggregator, lookup (connected & unconnected), source qualifier, joiner, expression, filter, aggregator and sequence generator, update strategy
• Developed unit/assembly test cases and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort
• Scheduling the sessions to load data in to warehouse database on Business requirements

Confidential

ETL Developer

Software: Informatica 8.5, Oracle10g, Windows XP/7, Toad

Responsibilities:

• Re-designing existing pre-stage area for upgraded source ATOM 8
• Involved in rewriting the ETL to pull the data from new ATOM V8 interface
• Used Change Data Capture (CDC) to simplify ETL in data warehouse applications
• Identified and Removed Bottlenecks inorder to improve the performance of mappings and workflows
• Revising Change Data Capture mechanism for loading data into TDH area
• Extracting additional attributes provided by source to already present target tables
• Modified existing mappings for enhancements of new business requirements
• Developing and Designing simple extraction queries for meeting the required logic
• Designing and Developing complex mappings as per the requirement using almost all transformations like router, aggregator, lookup (connected & unconnected), source qualifier, joiner, expression, filter, aggregator and sequence generator, update strategy
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values
• Created SHELL SCRIPTS for generic use
• Created high level design documents, technical specifications, coding, unit testing and resolved the defects
• Used PMCMD command to automate the PowerCenter sessions and workflows through UNIX
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production

Confidential

ETL Consultant/Developer

Software: Informatica PowerCenter 9.1, Oracle 10g

Responsibilities:

• Involved in Extraction, Transformation and Loading (ETL) of data
• Develop and implement different stages of ETL via Informatica mapping
• Extracting source data from flat files and Oracle and loading to a relational warehouse
• Designing and Developing complex mappings as per the requirement using almost all transformations like router, aggregator, lookup (connected & unconnected), source qualifier, joiner, expression, filter, aggregator and sequence generator, update strategy
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically
• Developed mappings in Informatica using BAPI and ABAP function calls in SAP
• Development of update strategy to keep track of historical data
• Implementing SCD methodology including Type 1, Type 2 changes to keep track of historical data
• Mapping design, loading facts and dimensions from source to target data mart
• Developed reusable Mapplets and Transformations.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions
• Using the Workflow Manager to create workflows and tasks
• Involved in monitoring the workflows and in optimizing the load times
• Created new database objects like Procedures, Indexes and Views in ODS and DWH
• Involved in the preparation of High level design documents, Low level design documents, ETL Specifications
• Performance tuning on partitioned tables for the best and optimum query performance
• Develop scripts for various ETL & integration needs

Confidential

OBIEE Consultant/Developer

Software: OBIEE 10g

Responsibilities:

• Participation in business &requirement gathering workshops
• Analysed the data and designed the Logical Star Schema model with consultation from Data Modelers and Business Analysts
• Customized and developed RPD (Physical, BMM and Presentation Layer)
• Business requirements mapping to design & configuration of Business Intelligence Server Repository
• Extensively used OBIEE Administration Tool for customization and modification of the physical, business model, and presentation layer of the repository
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements
• Developed Time Series Objects using Ago and ToDate functions for time series comparisons
• Using OBIEE Answers to create reports as per the client requirements
• Developed Reports with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services
• Developed intuitive and user friendly Dashboards by appropriately including guided navigational links, prompts, and drilldowns
• Implemented security by creating roles and web groups, and defined Object Level and Data Level Security

Confidential

ETL Consultant/Developer

Software: Microsoft SSIS, SQL Server 2005

Responsibilities:

• Active participation in the impact analysis, planning & strategy discussions related to Data warehouse redesign and upgrade
• Configuration/Development of the staging tables and the activities related to loading them from source to staging and subsequently from staging to the destination tables applying different transformations
• Developing complex SQL queries and SSIS packages design to load the data into the warehouse
• Data cleansing and data transformation activities via SSIS Packages using several transformations as per requirement
• Implemented Historical data maintenance logic
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server
• Documentation of packages as well as getting them audited from the quality team
• Working towards utilizing several transformations like lookup, union all, merge join for implementing the Transformation Logic in the packages
• Creating & maintaining visio designs for the ETL Process. Single point of contact for version control on the ETL designs
• Working towards extraction of data from flat files and from RDBS sources like Oracle and SQL Server
• Configuration of jobs and scheduled packages using SQL Server Management Studio for the daily load
• Point of contact for configuring reports using COGNOS

Confidential

Software Programmer

Software: VB 6.0, MS Sql Server 2000.

Responsibilities:

• Took part in Requirement analysis.
• SQL server database maintenance, Administration of jobs and coding.
• Preparation of Screen Layouts and documentation
• Stored Procedures to communicate with database
• Implementation of Software at client side
• Maintenance, Support and Debugging