SUMMARY:

• 15 years of IT experience in providing Data Warehousing and Business Intelligence solutions in Insurance, Banking, Telecom, Retail, Manufacturing, Health Care, and Energy sectors.
• Extensive experience in developing, implementing and optimizing ETL processes using Informatica Power Center.
• Experienced in Enterprise Integration - ETL architecture development, Data warehousing, EAI (Interface Development), and Business Process analysis, integration & optimization.
• Good understanding of Data Warehousing Architecture and Modeling (ER, Dimensional Data Modeling - Star, Snow Flake). Gathered and analyzed business requirements, and involved in developing EnterpriseData Models (Conceptual, Logical).
• Developed ETL interfaces for integrating Enterprise applications, and have migrated Tibco code to Informatica ETL.
• Proficient in transforming data from heterogeneous sources (Flat files, Relational, XML, DB2) to data warehouse using Informatica PowerCenter.
• Developed Transformations, Mappings and Workflows using Informatica Power Center Designer (Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
• Identified and resolved performance bottlenecks in ETL processes.
• Experienced in installation and configuration of Informatica PowerCenter on Windows Server.
• Experienced in OLAP tools and report development using Business Objects.

TECHNICAL SKILLS:

ETL Tools: - Informatica Power Center 9.5/9.1/ 8.6, SAP BW 3.5/BI 7.0

Modeling Tools: - Erwin

OLAP Tools: - Business Objects, Crystal Reports

ERP, CRM Packages: SAP R/3 Sales and Distribution, SAP CRM

Programming Languages: - SQL, PL/SQL, Perl, UNIX Shell Scripts, XML

RDBMS: - Oracle 11g/10g/9i, MS SQL Server, MS Access

Other applications: - MS Project, MS Visio, MS Office, VI, Emacs, Putty, FileZilla, WinSCP

Version Control / Configuration Management: - CVS, MS Visual SourceSafe (VSS)

Operating Systems: - Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.5, Oracle 11g, Toad 11.6, SQL Developer 4.0

Responsibilities:

• Worked with business users and analysts to understand the requirements.
• Involved in solution design / ETL architecture, detail design and created STM documents.
• Provided task duration estimates based on detail design and provided task duration estimates.
• Identified reusable logic and moved them to Mapplets and Worklets to create shared objects. Used parameters and variables where needed, for ease of maintenance and scalability.
• Implemented performance optimization techniques in code. Pre-processed data at various stages from source to target to balance pipeline bandwidth usage in ETL code. Implemented push-down optimization to process slow hierarchical data extracts at the database level.
• Used informatica debugger to identify and resolve complex code failures.
• Reviewed code design for compliance of internal design standards and informatica best practices.
• Unit tested the code and participated in integration testing. Created test plans and documented the code with test cases.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.5, Oracle 11g, Toad 11.6, SQL Developer 4.0

Responsibilities:

• Developed ETL mappings to extract data from a flat files (xml, csv), and other source systems and loaded data into a data warehouse.
• Analyzed business requirements, created ETL mapping specs and provided task duration estimates.
• Enhanced several mappings, sessions and workflows to meet new requirements and change requests.
• Optimized some of the old informatica mappings for performance and implemented best practices.
• Unit tested the code and deployed them to QA and Production environments, and provided support.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.5, Oracle 11g, Toad 11.6, SQL Developer 4.0

Responsibilities:

• Gathered requirements from business users and reporting team and developed ETL architecture to provide data for Balanced Scorecard reports.
• Analyzed student data and created ETL data mapping document.
• Enhanced existing mappings and workflows to meet new business requirements.
• Developed several new mappings, sessions and workflows that load data into Cognos Staging tables for various reports.
• Planned and executed end-to-end integration testing and user acceptance tests. Scheduled and prepared the Informatica objects for production deployment.
• Documented the architecture and the code.
• Developed UNIX Shell Scripts for file processing and process control in Workflows.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.5.1, Oracle 11g, Unix, Toad 11.6, SQL Developer 4.0, UltaEdit, ServiceNow

Responsibilities:

• Created mappings, sessions and workflows to convert Calendar year data to Fiscal year for Time dimensiontables.
• Identified reusable logic and moved them to Mapplets and Worklets to create shared objects.
• Developed SQL scripts to maintain / make manual changes to correct bad data in production.
• Deployed mappings, sessions, workflows, and file objects to QA and created deployment groups to be deployed to Production.
• Enhanced several existing mappings and workflows as per new business requirements.
• Masked sensitive data using data masking transformation for use in test and dev environments.
• Used ServiceNow tool to for change management process in production deployments.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.5, Oracle 11g, Unix, Toad, SQL Developer 4.0

Responsibilities:

• Analyzed business requirements and converted complex hierarchical queries to ETL mappings.
• Developed Informatica ETL mappings, sessions and workflows, and scheduled the workflows as per business process. Provided task duration estimates and conducted code reviews.
• Analyzed code reusability across the project and developed reusable objects (mapplets, worklets, sessions...) where redundant logic was identified, enhancing ease of maintenance by minimizing object library.
• Implemented best practices as per Informatica Velocity methodology and optimized the code for performance.
• Analyzed impacts of changes on current ETL mappings and developed mitigation strategies.
• Enhanced several mappings, sessions and workflows to meet new requirements and change requests.
• Unit tested the code and deployed them to QA environments, fixed defects and clarified functionality to test team when needed.
• Attended internal sessions on business analysis, solution architecture development, project costing and estimation, and quality process implementation.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.0.1 / 8.6, Oracle 10g, UNIX, Toad, xml

Responsibilities:

• Developed ETL mappings to extract data from a flat files (xml, csv) and loaded data into a fraud detection data warehouse.
• Analyzed business requirements, created ETL mapping specs and provided task duration estimates.
• Enhanced several mappings, sessions and workflows to meet new requirements and change requests.
• Converted ETL code in Oracle stored procedures into Informatica ETL mappings, and scheduled the workflows. Conducted code reviews with team and business users.
• Unit tested the code and deployed them to QA and Production environments, and provided support.

Confidential

ETL Developer

Environment: Informatica PowerCenter 9.0.1 / 8.6, Oracle 10g, Linux, AFE Navigator, Maximo 7, Tibco, Toad

Responsibilities:

• Analysed Tibco code for AFE Navigator inbound interface (AFENav to JDE XE) and developed an Informatica ETL solution - developed ETL specs for integrating various business areas in the interface.
• Integrated AFE Navigator application with JDE XE through an Enterprise Data Depot (EDD) - developed several mappings, sessions and worklets and workflows in the process, and created support documents.
• Created Tibco to ETL conversion feasibility report for several other Tibco interfaces - reported on interface complexity, effort, and time required for conversion to ETL.
• Analysed business requirements and co-ordinated with business and technical groups to arrive at consensus on requirements. JDE9.0 EDW Upgrade Project:
• Converted JDE XE EDW ETL Objects to JDE9.0 EDW requirements, unit tested them and deployed them to the TQA environment.

Confidential

ETL Developer

Environment: Informatica PowerCenter 8.6, Oracle 10g, Linux, AFE Navigator, Maximo 7

Responsibilities:

• Developed application interface to integrate Maximo asset management system and Enterprise Data Repository (EDR).
• Created several mappings, sessions and workflows for integrating various functional areas and scheduled the workflows as per the required sequence and timing.

Confidential

ETL Developer

Environment: Informatica Power Center 8.6, Power Exchange, HP Quality Center, Oracle 10g, 9i, Solaris 10.0

Responsibilities:

• Created interface specifications along with Maximo and Poplesoft Financials consultants.
• Developed ETL Mappings, sessions and Workflows to develop data interfaces between IBM’s Maximo Asset Management System and PeopleSoft Financials.
• Created a file drop system using trigger files / SSH for applications that cannot be directly interfaced through the Power Exchange CDC process.
• Promoted Informatica objects between different environments for Nodes on a Grid architecture.
• Identified scope change, provided effort estimates and updated change request documents.
• Received to use HP Quality Center, and documented defects, status and actions.
• Documented my work as per client’s standard, and provided user .

Confidential

ETL Developer

Environment: Informatica Power Center 8.6, Oracle 10g, Solaris 10.0

Responsibilities:

• Developed ETL mappings, sessions and workflows to meet business requirements of the Colon CancerScreening Program (InScreen), Confidential Ontario (CCO).
• Maintained / updated workflows used for creating trigger files meant for subsequent ETL processes.
• Documented the scheduling process from the FTP pulls from various remote servers using Secure Shell(SSH) through Staging and Integration. These workflows were used for periodic and on demand scheduling requirements.
• Developed Shell scripts that schedule workflows on a specific (Nth) business day.
• Received periodic privacy and data security in procedures to handle sensitive business data.

Confidential

Sr. Informatica Developer

Environment: Informatica Power Center 8.6, Oracle 9i, Toad, Windows

Responsibilities:

• Participated in requirement gathering, Business analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design documents.
• Developed, tested and implemented Informatica transformations and workflows for extracting the data from the multiple sources.
• Developed complex Source to Target Mapping (STM) in Informatica to load the data from various sources using different transformations like Look up (connected, unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, and Router.
• Identified, developed reusable business logic and implementing them using Informatica reusable components (Transformations, Mapplets, Worklets) and documented them.
• Developed Informatica Mappings to load data from Source systems to ODS to Data Mart.
• Created Informatica workflows/sessions to extract, transform and load the data into various Targets.
• Developed procedures to populate the data marts with transaction data and from other external sources.
• Worked with different Informatica tuning issues and fine-tuned the transformations to improve performance.

Confidential

Sr. Informatica Developer

Environment: Informatica 7.1, Oracle 9i, Business Objects 6.5, Windows, UNIX

Responsibilities:

• Developed mappings to populate data tables which provide codes and descriptions for dimension tables in the database
• Developed complex mappings in Informatica to load the transaction data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Developed mappings to compare data sets and load data in slowly changing dimensions (SCD).
• Optimized ETL code to removed performance bottlenecks at source level, transformation level, and target level.
• Created workflow tasks like event wait, event raise, email, command and pre/post session SQL to control ETL process as per business process automation requirements.
• Created Worklets and workflows with sequential / concurrent session execution order and scheduled them as required.

Confidential

Sr.Informatica Developer

Environment: Informatica 8.1.1, MS SQL Server 2000

Responsibilities:

• Analyzed code in the DTS packages and created mapping document, and developed code to reproduce the same functionality.
• Develop the mappings, sessions and workflows and scheduled them to be in sync with the current process scheduled.
• Worked with all the Informatica tools like Repository manager, Designer, Workflow manager and Workflow monitor.
• Documented the code.

Confidential

ETL Developer

Environment: Informatica Power Center 7.1, Oracle 9i, IBM DB2, SQL, PL/SQL, TOAD, Windows, UNIX

Responsibilities:

• Analyzed business process and gathered business requirements. Conducted information gathering sessions with business managers and end users.
• Created several Informatica mappings to populate the data into dimensions and fact tables.
• Involved in the development of Informatica mappings and mapplets and tuned them for optimum performance.
• Extensively used Informatica PowerCenter Designer in ETL processes to load data from multiple sources (Relational, Flat files) to various Targets.
• Created various transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator in many mappings.
• Identified bottlenecks in data flow and optimized for performance.
• Used debugger to test the mapping and fix the bugs.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Developed UNIX shell scripts to execute workflows as per scheduling requirements.

Confidential

Informatica Developer

Environment: Informatica 7.1, Business Objects 6.5, and MS SQL Server 2000

Responsibilities:

• Responsible for analysis, design and implementation of new Informatica mappings
• Actively participated in requirement gathering sessions.
• Extracted data flat file and relational sources.
• Developed high performance ETL plans to load large volumes of data (about 90 million records).
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures and necessary Test plans to ensure the successful execution of the data loading processes.
• Created stored procedures in database and linked them with the Informatica.
• Developed mapplets, reusable sessions, worklets with Informatica Power Center and scheduled the jobs for loading data into targets.
• Lead, planned and coordinated knowledge transfer from the client to team members.
• Developed transformations and mappings to compare data sets for implementing slowly changing dimensions (SCD).
• Update the management on issues and resolutions.

Confidential

Informatica Developer

Environment: Informatica 6.1, Oracle 9i, Windows

Responsibilities:

• Gathered business requirements and created ETL mapping document.
• Profiled data in source systems to create data quality reports.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Look up (connected and unconnected) Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Designed and Developed the Informatica workflows/sessions to extract transform and load the data into Target.
• Optimized code for performance and enhanced Informatica interfaces and SQL scripts with additional functionality.
• Developed and performed unit-testing on Informatica mapping, session and workflows based on ETL specifications.

Confidential

Business Analyst

Responsibilities:

• Analyzed business requirements for SAP ERP implementation in the company.
• Performed impact analysis and calculated department level ROI.
• Created business process diagrams and documents to map to SAP Sales and Distribution module.
• Developed phased go-live plans to keep business process interruption to an acceptable level.
• Point person and coordinator for go-live issues for the entire company.