Professional Summary:

• Professional with 8 years of experience as Informatica Developer within Healthcare, Corporate, Retail and Manufacturing domain.
• Extensive knowledge in design, development, enhancement of Data Warehouse and Business Intelligence applications using Informatica Power Center 9.x./8.x.
• Strong development skills and ability to work through entire software development life cycle SDLC methodologies like Agile, Waterfall, and RUP from gathering requirements through analysis, design, Implementation and support analysis.
• Expertise in using Informatica Power center for data extraction, transformation and loading ETL from data sources such as oracle, SQL server, flat files, MS Access, JMS and XML files and load the data into different targets.
• Experience working on slowly changing dimensions such as SCD type-1, type-2 and type-3 to maintain the transactional data and historical data for the need of business process and change data capture CDC using Informatica applications.
• In-depth experience in working with UNIX Shell Scripts for automatically running sessions, creating parameter files, running batch jobs and aborting sessions.
• Experienced in data migration from one server / location to different server environments using FTP, Secure FTP, SCP, Network Data Mover methodologies.
• Expertise in enhancements/bug fixes, performance tuning, troubleshooting, impact analysis, Unit testing, Integration Testing, UAT and research skills.
• Extensively worked in developing and implementing Business Objects universe Design, and Crystal Reports.
• Strong database experience with SQL, PL/SQL Programming skills like creating indexes, joins, functions, stored procedures, triggers and cursors using Toad and SQL Plus.
• Expertise in data mining, data analysis, data transformations, source to target data mappings, data profiling, data cleansing, data migration and data integration processes, master data and meta data management.
• Strong knowledge and good work experience in database analysis, normalization and De-normalization techniques for optimum performance of relational and dimensional database environments.
• Highly organized professional with excellent analytical, interpersonal and communication skills.

Technical Skills:

Professional Experience:

Confidential

Role: Sr. ETL Developer/Analyst

Here I was a part of the Business Intelligence team that implemented and supported OBIA modules for ERP and EPPM systems, being a senior developer my role included ETL design, development, testing, deployment, and documentation. My responsibilities further extended to the operations side where I scheduled, monitored and maintained all nightly ETL jobs. I also headed the upgrade team of Financial Analytics and P6 Analytics modules from OBIEE 10g to 11g

Responsibilities:

• Requirement gathering for implementation of Accounts Payable, General Ledger, and Budget reports in OBIEE
• Designed project timeline, reviewed project progress and delivered projects involving efforts worth 60 days or less
• Designed ETL logic for OBIA HR-Analytics history tracking cube
• Designed, developed and tested mapplets, mappings, tasks and workflows involving complex dependency structures in Informatica 8.6.1 and 9.1.0
• Wrote stored procedures for performance improvement of SQL scripts
• Implemented full upgrade life cycle for OBIEE Financial Analytics module including, configuring source and lookup files, configuring DAC/runtime/mapping/session parameters, customizing ETL logic, designing Execution plan, Report migration, Unit testing, and deployment
• Designed ETL logic for FT, AA, PM, and BA reports of Financial Analytics module of OBIA
• Designed ETL and Business layer logic for New Hires, Promotions, headcount, annual rewards, compensations, history tracking and termination reports of Human Resource Analytics of OBIA
• Deployed Resource Allocation, Resource Spread, Activity Spread, Resource Utilization, Time tracking, Actuals, Budget and Earned Value reports of P6 Analytics of OBIA
• Structured Execution plan in Datawarehouse Administration console for efficient execution of nightly jobs
• Validate data between Data Warehouse and different Application Source Systems like JD Edwards, Enterprise Project Portfolio Management, Kenexa, Kronos, and Coupa
• Monitor and resolve production support issues in a multi priority and fast paced environment
• Designed test cases to validate new implementations and owned validation history management
• Developed ICTC, RACI, BRD, FRD, Process flow, Technical Specifications, Data Lineage, and CMD documents
• Developed weekly ticket report for the Asst. Vice President of Corporate Systems department
• Designed, updated and maintained Business Intelligence Team's Sharepoint site

Enviornment: Informatica Powercenter 8.6.1/9.1.0, OBIEE 10g/11g, Oracle 10g/11g, MS SQL Server, DAC 10g/11g, Crontab, Windows, and Linux

Confidential

Role: Sr. Informatica Developer

Confidential through OLTP OLAP source system and the ETL process is governed through Informatica power center. Monitoring these ETL processes and maintaining the integrity of data through various source systems is the key task of this project. Here my role involved preparing the detailed Low level design document for the bug fixing, identifying new data relationships and data flows and performing independent unit and integrated testing.

Responsibilities:

• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica Power Center.
• Imported from various Sources such as Excel, Flat files, to Targets, and developed Transformations using Informatica Power Center Designer.
• Developed various Mappings involving sales strategies with the collection of all Sources, Targets, and Transformations.
• Worked with Informatica Data Quality IDQ to obtaining desired and efficient results.
• Create and maintain metadata and ETL documentation that support business roles and detailed source to target data mappings.
• Developed and maintained technical documentation namely database design document regarding the extract, transformation and load process.
• Designed and developed complex Aggregate, Join, Router, Look up and Update transformation rules
• business rules .
• Implemented mapping level optimization with best route possible without compromising with business requirements.
• Wrote PL/SQL Packages for Inventory package, procedures, functions in oracle for business rules conformity.
• Utilized SQL loader, export/import utilities for data load and transformation in Oracle based 'Latin-AM-operations datamart'.
• Developed PL/SQL stored procedures for source pre-load and target pre-load to verify the existence of tables.
• Worked with different databases such as Oracle and Flat files and used Informatica to extract data.
• Involved in Unit Testing, Integration, and User Acceptance Testing of Mappings
• Performed Data Profiling to assess the risk involved in integrating data for new applications, including the challenges of joins and to track data quality standards.
• Extensively worked with Business Intelligence team in preparing and delivered a variety of interactive and printed reports by using Crystal Reports and Business Objects

Environment: Informatica Power Center 9.1/8.6, IDQ, Oracle 10g/11g, UNIX, Shell Scripts, TOAD 10.6, Control-M 6.4, ERwin7.3, HP Quality Center 10.0.

Confidential

Role: Sr. Informatica Developer

One of the largest Automobile Insurance Provider based in Confidential. I was a part of a team of 4 members we were responsible for database designing of the Universal Life department using Informatica. My role in the team involved designing, testing and documenting the database designs

Responsibilities:

• Gathered Business requirements by conducting meetings with business analyst, stake holders, development teams and data analysts on a scheduled basis for data integration process.
• Identified documented data sources and transformation logic required to populate data and maintain targets.
• Extract and load source data to severity datamart using Informatica
• Implemented transformation logic to support ETL processes to load data into staging database using Informatica power center.
• Played key role in determining data feed extraction process, data analysis, and testing and project coordination.
• Applied transformation logics such as XML transformation, lookup transformations, Update strategy transformation, expression transformation, joiner transformation etc. to extract, transform and load data into target.
• Designed re-useable transformations to quickly add new data sources and transformations related to business needs.
• Worked with SQL Stored Procedures and converted the logic to put in Informatica to integrate the data from different databases.
• Developed the Documentation for all the mappings/workflows, and also developed the run books which were extensively helpful to the Production support team for all the recovery situations.
• Identify performance bottlenecks in sources, mappings, workflow session and used best practices for performance tune of bottlenecks.
• Utilized Autosys scheduler to run sessions and workflows in batch processes.
• Coordinated in writing test plans to perform various test cases for the validity of data.

Environment: Informatica Power Center 8.6.1/9.x, Oracle 10g, SQL server 2005 2008, PL/SQL, SQL Plus, Windows NT, Unix Shell Scripting, Erwin 4.

Confidential

Role: Sr. Informatica Developer

In this project, we had to maintain data of ailments based drugs, patients, prescribers and prescriptions. The focus was to fetch the prescription and patient associated data from retail stores of Walgreens and to maintain a different patient hub and prescriber hub. From patient and prescriber hub we stored relevant extracted data into RXline system while at the same time reference data into Patient/Prescriber Hub. My responsibility was to develop mappings in Informatica to facilitate loading of data into RXline data-mart.

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center 8.x.
• Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
• Responsible for maintaining the surveillance datamart that reported the misuse of medical drugs.
• Used Informatica Data Quality to formulate data conversion and data cleansing rules.
• Developed Sales reports in Crystal Reports to facilitate Sales team Reporting, also reduced reporting times by optimizing SQL queries.
• Performed Data Integration, Data Standardization, and De Duplication using IDQ.
• Created Plans using Informatica Data Quality to perform Data Analysis and validation, Data Profiling and Creating Dashboards.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center.
• Conducted performance tuning to increase performance of the mappings, sessions workflows.
• Used PL/SQL with Informatica Power Center for Oracle 10g database.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Performed project management duties including analysis, design, and implementation of Extraction, Transformation and Loading methodologies.
• Developed Low Level Design LLD documents as per the business requirements and Unit Test Plan UTP documents for all test cases for developed mappings.
• Worked with Production team to resolve Production Support Tickets
• Involved in Universe Designing in Business Objects based with the reporting team
• Identified reporting options to facilitate the reporting of drug specific demand to the marketing team

Environment: Informatica Power Center 8.6.1/9.1, Oracle 10g, SQL server 2005, Informatica power exchange, PL/SQL, SQL Plus, TOAD, ERwin 4.0, Windows NT, Shell Scripting, HP UNIX 10.2.

Confidential

Role: Sr. Informatica Developer

Confidential incorporate new ODS based on new marketing plans into the existing database. My responsibilities included data staging and loading into the marketing and sales data marts using Informatica, and also to address the tickets raised from the reporting team

Responsibilities:

• Involved in development of full life cycle implementation of ETL using Informatica with sources like oracle, Mainframe DB2, SQL server, flat files and XML.
• Created functional document to write, test, debug, document, and implement complex batch jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using Power center.
• Developed mappings for reporting datamart to facilitate new reporting rules
• Created Sessions, reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations
• Developed simple and complex mappings using Informatica to load Dimensions and Fact tables as per star schema techniques.
• Improved the performance of the mappings by moving the filter transformations early into the transformation pipeline, performing the filtering at Source Qualifier for relational databases and selecting the table with fewer rows as master table in joiner transformations.
• Developed Unix scripts to FTP files, parallelize tasks, send email notifications, implement archive strategies, purge old data, etc.
• Programmed UNIX scripts to convert flat files into fixed width format for ETL process.
• Used parallel pipeline partitioning to improve performance. Partition types leveraged were key range, hash key, pass through, round robin and database partitioning.
• Involved in application environments migration from development to testing to production. Documented and implemented migration steps and also drafted operations manual. Migrated repositories, code and application settings smoothly between different systems.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session
• Parameters for the delta process to extract only the additional data added during that period.
• Extensively used Informatica functions like IIF, DECODE, ISNULL, ADD TO DATE, TO DATE, etc in transformations.

Environment: Informatica Power Center 7.1/8.1, Power Exchange, Business Objects 6.1, Oracle 9i, PL/SQL, SQL Plus, SQL Server, MS Access, XML files, UNIX Shell Scripting, Windows NT/2000.

Role: Informatica Developer

Confidential is one of the 25 largest banking companies in US. Being a part of the Group dataware house team my role involved integrating multiple business process like Mortgage, loans, credit into one integrated system called ExposureCheck from different sources. This system was then accessed by the reporting team to provide VaR reports from RR datamart.

Responsibilities:

• Develop technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Analyzed business and systems specifications and developed logic flowcharts.
• Coordinated and worked with the offshore team for development and involved all phases from requirement gathering, design, development, testing and Production deployment.
• Extensively used ETL to load data from wide range of source such as flat files, oracle and XML to ORACLE.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, and Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Implemented bulk load method with SQL Loader for loading history data to staging area.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Executed Multi load scripts for daily batch jobs.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Defined UNIX Batch scripts for automation of execution of Informatica workflows and used UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• Involved Working on Functional testing, Integration/ System testing, Regression testing and User Acceptance Testing.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Expertise in working with Oracle Stored Procedures, Packages, Cursors, Triggers, Database Link, Snapshot, Tables, Constraints, Views, Indexes, Sequences.
• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department.
• Developed excellent professional skills by working independently and also as a team member to analyze the Functional/ Business requirements and to prepare test plans, test scripts and test cases for manual testing.

Environment: Informatica Power Center 8.1/7.1, Oracle 9i, Business Objects 6.5, UNIX, Shell Scripts, TOAD 8.0, Autosys, Sun Solaris.

Role: Systems Engineer DB Professional

Confidential is one of the oldest and largest pharmaceutical companies in India. Here our team was involved in implementing Marketing data mart in the company enterprise dataware house.

Responsibilities:

• Worked with business users to define and analyze problems and business needs by involving in sessions with the analysts.
• Established data standards for customer information, including data definitions, component structures such as for complex data types , code values, and data use.
• Created a bridge table for the numerous dimension groups and related them accordingly.
• Developed enterprise-wide framework that defines how multiple sources of data should be consolidated into a single, structure that enables the use of creative business analytics to extract useful information from a large data sources.
• Applied reusable tasks and work lets in Informatica that can be helped for easier design of workflows to implement the transformations that help movement of data from diversified sources to the target.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations
• Used mapping parameters to extract the required data from the sources and direct the data to the sources.
• Written UNIX Shell Scripts and Pmcmd command line utility to interact with Informatica Server from command mode.

Environment: Informatica Power Center 7.1.2, Oracle 9i, AIX 5.3, Toad 8.5, ERwin 4.1, Windows XP.