SUMMARY OF EXPERIENCE:

• Having 8+ years of IT experience with ETL tools Informatica Powercenter, IBM Ascential Datastage, IBM Infosphere SQW and Teradata.
• Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
• Good in Onsite - Offshore work co-ordination.
• Strong experience with Informatica tools - Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor.
• Experience on Data Stage, designing and developing jobs using Data Stage Designer, Data Stage Manager, Data Stage Director and Data Stage Debugger
• Experience on Tereadata load utilities Fast Load, Multi Load, TPump, Bteq, Fast Export and SQL Assistanr Manager to write the complex SQL queries
• Good experience and strong knowledge in Business Intelligence tools such as Business Objects, Cognos and SAS.
• Good exposure on MDM (Master Data Management) Hub developer.
• Experience on Data integration from multiple source systems, files and loading the data into a single staging area.
• Strong in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
• Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
• Quick to learn.
• Experience on Data warehouse methodologies on normalization and dimensional modeling.
• Worked in Agile & Waterfall model work environments.
• Good team player, strong interpersonal and communication skills combined with self-motivation initiative and positive attitude.
• Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.

TECHNICAL SKILLS:

DWH ETL Tools: Informatica Powercenter, Powerexchange, Teradata, Ascential Data Stage, IBM Infosphere SQW and Informatica B2B MFT

RDBMS: IBM DB2, Oracle, SQL Server, Netezza, Toad.

Files: Microsoft Visio,Erwin, MS word, MS Excel, XML and Flat Files.

BI Reporting Tools: SAP Business Objects, Cognos, SAS

Programming Languages/Scirpting: Unix Shell Scipting, PL/SQL, Java, C

Operating Systems: IBM AIX UNIX, Windows 8/7/Vista/NT/XP.

Domain Knowledge:  Finance, Healthcare, Telecommunications, Insurance and Retail

PROFESSIONAL EXPERIENCE:

Confidential, Warwick, RI

Senior Informatica Developer 

• MetLife Campaign Management team to campaign, advertise all the party and individual policies. The main objective of the project is to implement ETL flows to incorporate all various sponsors’ data into the SAS data warehouse. The current application is having various sponsor flow source files and different legacy system sources and a target as a SAS to provide reporting for end users.
• Involved in understanding of architecture design part, business processes and data modeling design.
• Involved with Informatica B2B MFT team and Data quality team interactively before starting the ETL process with the source files and after completing the ETL process with the target files to make ensure with the file format and its naming conventions as per the business user needs.
• Have prepared requirement understanding documents at the time of estimation on planning on design and implementation of ETL flows as per the business flow
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Normalizer transformations while developing mappings using Mapping designer and created the sessions and other tasks using Workflow Manager and used Workflow Monitor to run and monitor the workflows.
• Lead the Offshore team, actively coordinated with client people and updated them with the project status.
• Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
• Extensively worked on Workflow monitor to run the workflows and monitoring the session logs, workflow logs and evaluating on performance statists, thread statistics.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Worked on Linux shell scripting, FTP.
• Enhanced the reusability of the sessions across different workflows.
• Written unit test cases with multiple scenarios and executed the SQL queries.
• Used TOAD to run SQL queries and validate the data in warehouse and mart.
• Interactively coordinated with QA team
• Attended the status meetings with the client people and offshore team.
• Worked with offshore team and given the KT on our development codes and the whole ETL process at the time of production deployment
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment: Informatica 9.5.1, Informatica B2B, Informatica Data Quality, Flat Files,DB2, Oracle 11g, Netezza,FTP, Win SCP, AQT, SQL, PL/SQL, Linux, SAS, Windows 7.

Confidential, Nevada, CA

Senior Informatica Developer 

• Member point is an application that supports wide range of insurance customers of American auto mobile association (AAA). The current application that is having 4 different sources including legacy source systems and PeopleSoft data to feed the application interfaces is being replaced by new system where the current four plus source systems are being integrated to a single source system to feed the different outbound interfaces of AAA.
• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Interacted with data analyst to understand the data format and standards on file naming conventions as per the business requirement and setting up the file frequency to generate the workflows.
• Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
• Data integration has been done from multiple source systems and files into a staging area.
• Involved in Developing Mappings, Sessions and Workflows using Informatica Powercenter tools Mapping Designer, Workflow Manager and scheduled the workflows using Control M
• Involved in Creating sessions and Workflows using Informatica Workflow Manager
• Involved in Performance Tuning at mapping level and session level
• Involved in writing shell scripting for file validation and executing the workflows.
• Involved in admin activities such as creating the Domain, Repository and project folders, users and providing the access privileges to the users.
• Involved with IBM Cognos team creating the reports based on the business adhoc requirements using Cognos studio, Report studio, framework manager tools.
• Worked on enhancement change request and involved in Production support
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment: Informatic Powercenter, Flat files, IBM DB2, Oracle10g, SQL Server -2012, IBM Cognos, SQL Loader, Toad, PL/SQL, Unix, Control M, Windows NT/XP

Confidential, Nashville, TN

Informatica Developer

• Analyzed the existing business model.
• Interacted with business users on weekly basis in finalizing high-level business requirements.
• Prepared detail-level design documents based on the discussions to get sign-off from business.
• Analyzed the impact and provided estimations in PD’s to Client whenever there was a change in client requirements.
• Created Informatica jobs to extract data from different external sources and populate into data warehouse tables/flat files by transforming the data as per business rules.
• Involved in Unit testing and Integration testing of Informatica workflows.
• Responsible for tuning the Performance of Informatica ETL mappings.
• Reviewing and testing of mappings, sessions, workflows.
• Worked on SQL Assistant to write the complex SQL queries
• Involved in writing the Bteq scripts and load utilities Fast Load, Multi Load and Fast Export.
• Involved with SAP BO team and created the universe, reports based on the adhoc requirements.
• Data validation on BO reports by extracting the data from staging database
• Extensively used Designer to design universes for different business groups.
• Used joins concept by taking different tables from different data sources in the Universe.
• Provided the warranty support by interacting with production support teams.

Environment: Informatica 8.1,Teradata V2R6, Oracle 10g,DB2, SQL, PL/SQL, UNIX, SAP BO, Windows 2003.

Confidential

Senior Data Stage and Infosphere SQW Developer & Lead

• Confidential has aligned its businesses vertically across several domains and also provides specialty technology services through its horizontal expertise. The project objective is to implement ETL flows to incorporate various enhancement requests from Finance Team and other objective is to migrate from Datastage to Infosphere SQW.
• Interacted with End user to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements
• Integrated the data from source relational source systems and files and loaded into staging area.
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup stages in accomplishing the ETL Coding.
• Taken complete role of Migration from Datastage to IBM Infosphere SQW and Lead the migration team and reviewed and validated the codes from Datastage to Infosphere SQW and performed the data validation using sql queries on Oracle and DB2.
• Involved with Business Objects team and created the reports and universes and optimized the complex sql queries.
• Verified the BO Reports by extracting data from the Staging Database using SQL queries
• Implemented row and object level security in business objects universe Designer.
• Performed unit testing of the reports.
• Developed job sequencer with proper job dependencies, job control stages and triggers.
• Excessively used DS Director for monitoring Job logs to resolve issues
• Documented ETL test plans, test cases, test scripts, and validations based on design
• Specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis. Participated in weekly status meetings.
• Designed Control Flows, Sub processes, Dataflows in Infosphere SQW
• Created single Master Control Flow for all dimensions by incorporating some dimensions to run in parallel using parallel container step and all dimensions based on their dependency and time priority
• Automated some run time parameters in Infosphere SQW.

Environment: IBM Ascential Data Stage client 7.5.1 (Designer, Director, Manager), Infosphere SQW, IBM DB2, Oracle 10g, SQL Server 2008, Flat files, Sequential files, AIX UNIX, SAP Business Objects.

Confidential

Data Stage Developer

• The core of the EWS Dashboard is a predictive analytics/statistical model built based on historical data. The model provides probability of an associate separating from the Organization and the factors which influence the separation action and the strength of the influence of each of the factors on the separation action. The output from the model provides the Talent Manager an indicative list of associates who are in the high risk category. It also provides the attitude the associate has come to have on each of the factors providing an indicator for which retention measures are needed.
• Interacted with Business Analyst to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and CSV files to staging database and from staging to the target Data Warehouse database.
• Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort etc stages in accomplishing the ETL Coding.
• Involved with Business Objects team and created the reports and universes and verified the BO Reports by extracting data from the Staging Database using SQL queries
• Excessively used DS Director for monitoring Job logs to resolve issues
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Environment: IBM Ascential Data Stage client 7.5.1 (Designer, Director, Manager), Oracle 10g,SQL Server 2008,IBM DB2, Flat files, Sequential files, AIX UNIX, Business Objects

Confidential

Informatica & Teradata Developer

• Client needs to care of the entire application of Vodafone account. It includes developing the new code as well as maintaining the data into Teradata Data warehouse. Data from several sources like BSCS, RCDR, MCDR, CRM, and CRS are extracted at extraction server (ORACLE) into flat files. These files are then processed at ETL server by Informatica, Teradata and finally and data gets loaded into Target tables. The project was to transform the data coming from various sources through multiple stages before being loaded into the data warehouse and maintenance.
• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source. Mainly involved in ETL developing.
• Extensively worked on Informatica mappings for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Developed ETL jobs as per business rules using ETL design document
• Involved in Creating Mappings with various transformations like Expression, Lookup, Joiner, Sorter, Aggregator, Java etc. using Power center designer
• Extracted the data from xml source files, multiple database tables and loaded into a staging area
• Worked with XML source files and loading into relational target table.
• Created different workflows using sessions, command, email tasks etc using Informatica Workflow Manager and monitored the running workflows using Workflow Monitor.
• Involved in Performance Tuning at mapping level and session level and analyzing the session thread statistics to identify the bottlenecks on source, mapping and target threads.
• Involved with SAS reporting team and created adhoc reports based on the business requirement.
• Validated the data during the migration of reports from BO to SAS Reporting Tool.
• Worked on SQL Assistant to write the SQL queries.
• Involved in writing scripts for loading data from source system to target data warehouse for BTEQ, Fastload and Multiload.

Environment: Informatica (Ver 7.5.1), XML Files, Teradata V2R6, MS Access, SAS Reporting tool, SQL-Server 2000/2005,SQL, PL/SQL, Toad.

Confidential

Informatica & Teradata Developer

• ICICI Prudential is India’s largest private sector new insurance organization. Its data warehouse is the Financial Services Logical Data Mart and is built on third normal form. This data warehouse gets data from different systems which include LA, the core insurance system, AMS (information about agents), Goldmine (information about prospects), SAP(finance). This project mainly deals support of the existing system and improving the functionality of warehouse by integrating new systems to the warehouse.
• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source mainly involved in ETL developing.
• Developed the mappings using various transformations Connected and Unconnected Lookup, Expression, Sorter, Aggregator, Joiner, Sequence Generator, Normalizer in mapping designer
• Developed the Sessions and workflows using workflow manager and monitored the running workflows and session logs using workflow monitor.
• Involved in writing scripts for loading data from source system to target data warehouse for BTEQ, Fastload and Multiload.
• Worked on SQL Assistant to write a complex SQL queries
• Involved with SAP BO team and created adhoc reports based on the business requirement.
• Prepared the mapping design document and test cases document.

Environment: Informatica 7.5.1, Teradata V2R6, MS Access, SAP BO Reporting Tool, SQL-Server 2000/2005,SQL, PL/SQL, Toad, UNIX, Windows NT