SUMMARY:

• Almost 8 years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Data Modelling, Application Development, Implementations and Testing of Applications in Data warehouse and data integration environments.
• Extensive Data Warehouse experience using Informatica Power Center 9x/8x/7x (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer) as ETL tool on Oracle, SQL Server and other databases and flat files.
• Comprehensive Knowledge of Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.
• Strong knowledge and experience in interacting with various databases with SQL/PL SQL programming.
• Solid experience in writing SQL queries, PL/SQL, Stored Procedures, Triggers, and optimization.
• Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML into target tables.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Experienced in overall data warehouse, database and ETL tuning for better performance
• Experience of preparing FSD/TSD (Functional/Technical Specification Document) documents from BRD (Business Requirement Document) / Customer Requirements.
• Experienced in Performing Unit testing, regression testing, sanity testing, and system integration testing for Dry runs.
• Extensive experience in Performance Tuning, identifying and resolving performance bottlenecks of targets, sources, mappings, coordinate with DBAs for ETL tuning.
• Well Experienced in doing Error Handling and Troubleshooting using various log files.
• Experienced in integration of Salesforce.com with external applications by using Web Services API.
• Proficient in creating mappings/Mapplets using Informatica Lookup, Aggregator, Joiner, Expression, Filter, update strategy, Source Qualifier, Union, and Normalizer Transformations

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, My - SQL, MSSql Server

ETL Tool: Informatica Power Center 9.5/9.1/8.6/8.0/7.0 Informatica Designer, Workflow Manager, Work flow Monitor

Data Modeling Tools: Erwin 3

Languages: SQL,PL/SQL, expose to java, XML

Tools: Toad 9.6.1, SQL*Plus, SQL Loader, SQL Assistant, Autosys, IBM Platform omputing(scheduler),informatica scheduler,SAS Enterprise guide, Team Foundation Server(TFS).

Operating Systems: Windows XP / 7, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Informatica ETL Lead/Onsite Coordinator

Responsibilities:

• Involved enhancements (based on the change requests raised by the client). The complete cycle of change request started with feasibility check, impact analysis, development, testing and implementation.
• Performed Unit Testing for ETL Mapping and Test cases Document.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Created shortcut objects from the shared folder.
• Creating of Shared folder to maintaining source definitions, transformation rules and targets definitions using Informatica Repository Manager.
• Creating Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool, which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Worked on onsite and offshore team coordination.
• Created Workflow Rules to automate Tasks, Email Alerts, Field Updates,time-dependent actions and Outbound API Messages.
• Prepared and involved month, Quarter and Yearend financial close processes.
• Involved in Planning and scheduling of the work among the resources.
• Liaison between the client team and the offshore team and ensure the common understanding on the requirements specified.
• Designed Xml Schema in xsd files.
• Integrated the Web Services by generating the necessary stubs from the WSDL files for extracting the data from the home grown applications by using the home grown web services.
• Worked with offshore team and engaged in development and support activities.
• Responsible for weekly status updates showing the progress of the ETL process.
• Documented Process Flow for mappings and sessions
• Used the Sql tools like TOAD in order to validate the data against the various databases like Oracle

Technologies: Informatica Power Center 9.1,Oracle 11g, Flat files,UNIX, Shell scripting, Report Net 1.1Toad, Autosys,windows.

Confidential, Dublin, CA

Informatica ETLdeveloper/Production support

Responsibilities:

• Include additional Performance Time Periods for Canadian Website feeds.
• Basis points validation for Performance Data.
• Enhancement to Fixed Income Override Logic Change.
• Risk Calculations Benchmark Data changes.
• Modify the existing logic to reflect the new calculation methodology for Equity elements.
• Enhance the Holiday logic to the Prices feed.
• Understanding and troubleshooting complex customer issues on production environment, responsible for identifying any bugs occurring in the applications as well as fixing .
• Provided feedback on the current operational processes and help update the production support standards and policies.
• Creating of Repository and Shared folder to maintaining source definitions, transformation rules and targets definitions using Informatica Repository Manager.
• Worked with Java based Offshore Team to design and build a automation framework which automatically generates ETL informatica Workflows (XML Files)using Informatica Java API.
• Creating Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, Mapplets using Informatica Designer tool, which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Creating Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger Wizard.
• Provided in-depth analysis to resolve production and application issues/Tickets.
• Resolved data quality issues raised by end users in each of the applications.
• Supported tactical and strategic goals of the IT Production Support Team.
• Created and maintained Technical specification documents.
• Created and maintained production support documents.

Technologies: Informatica Power Center 9.1, OBIEE 10G, DAC 10G, Oracle 11g, Flat files, UNIX, Shell scripting, Toad, Windows.

Confidential, San Francisco, CA

Informatica ETL Developer

Responsibilities:

• Involved in gathering and understating business requirements.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor.
• Worked on changes in the Informatica converting business needs to technical coding.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Worked on various transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Expression, Router, Filter, Normalizer, Aggregator and Sequence Generator transformations.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used Informatica Versioning to deploy code from development to SIT.
• Performed Unit Testing for ETL Mapping and Test cases Document.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Created shortcut objects from the shared folder.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on Unix Environment.Conversant with the Informatica API calls.
• Created SAS connections to deliver SAS Datasets.
• Created and maintained Technical specification documents.
• Wrote UNIX shell scripts for handling various files.
• Scheduled jobs using IBM Platform Computing (LSF).
• Used Team foundation server for agile development practices.

Technologies: Informatica PowerCenter 9.5, UNIX, Platform Computing, Oracle 11g, Pac 2000,Sql Server, SAS Enterprise Guide, Team foundation Server.

Confidential, Dublin, CA

Informatica ETL Developer

Responsibilities:

• Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Worked with Data modeler to restructure the data mart according to changes in the model worked on changes in the Informatica converting business needs to technical coding.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created views, triggers, stored procedures and functions for analyzing data.
• Created and configured the sessions for work flow. Created and maintained parameter files for workflows in UNIX.
• Worked on Joiner, Aggregator, Update Strategy, Router, Lookup, XML, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Implemented slowly changing dimensions - Type I, II & in different mappings as per the requirements.
• Developed reports using OBIEE answers and dashboards.
• Created tasks, Subject Areas, and Execution plans in DAC.
• Setting dependencies between tasks and executing the Execution plans.
• Created connections for relational, Non-relational and applications in the workflow manager.
• Created mappings using Reusable Transformations and mapplets.
• Created and maintained Technical specification documents.
• Created and maintained production support documents.
• Worked on onsite and offshore team coordination.
• Wrote Unix shell scripts for handling various files.

Technologies: Informatica Power Center 9.1, OBIEE 10G, DAC 10G, Oracle 11g, Flat files, UNIX, Shell scripting, Toad, Windows.

Confidential, Dallas, TX

Informatica / ETL Developer

Responsibilities:

• Understanding the Requirement Specifications, reviewing the Functional Specifications document and developing the Technical Design document.
• Developed the interfaces using PL/SQL stored procedures, implementing cursors.
• Used Informatica Power Center 8.6.1 for extraction, transformation and loading (ETL) of data in the data warehouse.
• Proactively identifying opportunities for change within the production environment.
• Creating shell scripting, file archiving, emailing to end users.
• Responded to and resolve database access and performance issues.
• Fine-tuned Transformations and mappings for better performance.
• Created Test Plans.
• Developed schedules to automate the update processes and Informatica Sessions/Batches.
• Developing Informatica workflows and perform the unit testing for the developed mappings.
• Filling release management templates.
• Modified column names as per the user requests and updated Informatica repository with the changes made at database.
• Integrating all the mappings and session and created workflows in the application folder and setting dependencies between the workflows.

Technologies: Informatica Power Center 7.1.3/18.6, Oracle 10g, TOAD, UNIX Shell Scripting, and Windows 7.

Confidential

Software Engineer

Responsibilities:

• Involved in gathering Business requirements and technical aspects for development.
• Scheduling, monitoring, coding and testing of custom PL*SQL modules to load data into the data warehouse from the legacy systems.
• Extensively used all the features of Workflow manager and Repository Manager, Workflow monitor.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Developed mapping to implement type 2 slowly changing dimensions
• Created Star and Snowflake Schema for the Data Model Designing.

Technologies: Informatica Power Center6.1.1, Oracle7.0, SQL, PL/SQL, TOAD.