Summary





Over 6 years of IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, OLAP, MOLAP, OLTP, Client/Server and Web applications on Windows and Unix platforms in various verticals like Financial, Pharmaceutical and Banking.
Certified Informatica developer with 6 years of experience in Informatica Power Center 8.6.1/8.1.1, Informatica Power Analyzer, Informatica Power Connect, Informatica Power Plug, Informatica Designer.
worked on Informatica tools like Power Center Administration console
Repository Manager, Work Flow Manager, Work Flow Designer and Work Flow Monitor.
experience in Autosys, Control M, Visual Source Safe, Maestro, Oracle 9. x/8. x/7 .x, UNIX Shell Scripting.
4 years of Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Teradata, DB2 and Worked on integrating data from XML files and flat files like fixed width and delimited.
Extensive experience in using Power Connect and Power exchange to Access various data sources for Change Data Capture CDC.
Proficient in creating mappings/Mapplets using Informatica Union, Lookup, Aggregator, Joiner, Expression, Filter, update strategy, Reusable transformation, Source Qualifier and Normalizer Transformations.
Involved in developing and designing complex ETL mappings like slowly changing dimensions type1 and type 2, critical performance tweaking stages with partitioning.
Implemented Performance Tuning techniques for ETL Process.
Experience in production support activities like analyzing production migration issues related to Informatica Mappings.
Implemented Performance Tuning techniques for ETL Process like finding bottlenecks in sources, targets, mappings and sessions and have done troubleshooting on them.
Excellent capabilities in integration mappings, static cache lookup, dynamic and persistence mappings for fact table mappings.
Extensive data base experience in Oracle 10g/9i/8i, Sql Server, TeradataV2R6/V2R5, DB2 8.0.
experience in SQL/PLSQL programming, developing and executing Packages, Stored Procedures, triggers, Table Partitioning, Materialized Views.
Worked on UNIX shell Scripting for executing PL/SQL codes and Informatica jobs and performed unit testing and integration testing for the developed data load process.
Excellent communication and interpersonal skills and capable of working independently.


Employment

September, 2009 -  Present
Informatica Developer

Description : Independent Health is a health solutions company headquartered in Buffalo, NY offering HMO, PPO, point of service, flexible spending accounts and Medicare. The Independent Health Care wanted to improve data quality to support decision-making and strategic planning across the health care district and consolidate existing data sources, both internal and external and enables easy and direct access for decision makers.

Responsibilities :
Prepared and updated Technical Design Documents.
used Informatica Client tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
Extracted data from various source systems like DB2, Oracle and flat files and loaded to a relational data warehouse and flat files.
Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
Developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected and unconnected Lookup, Rank, Expression, Router, Filter, Normalizer, Aggregator and Sequence Generator transformations.

optimized all the Informatica sources, targets, mappings and sessions by finding the bottlenecks in different areas and debugged some existing mappings using the Debugger to test and fix the mappings.
worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduling them to run at specified time..
Worked on SQL tools like TOAD for oracle and Surveyor for AS/400 to run SQL queries and validate the data.
Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.
Performed Unit Testing for ETL Mapping and Test cases Document.
Migrated mappings, sessions and workflows from Development to Testing environments.
Worked with DBAs to make the daily loads run much faster by tuning different aspects of the load jobs.
worked with the QA team to get the system and Integration testing done successfully and involved in ETL testing.
Worked with Developers to troubleshoot and resolve mapping or workflow or session logic and performance issues in Development, Test and Production repositories.
Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.
Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.

Environment : Informatica Power Center 8.6.1/8.1.1, AS/400 Oracle 10g, SQL, Flat Files, Visual Source Safe, Reflection, Unix, TOAD, Surveyor, AIX.

November, 2008 -  September, 2009
Informatica Developer

Description : The goal is to have information across the globe to be consolidated into a single data warehouse and generate consolidated and detailed reports out of it. The most important aspect is to bind all of the data coming from various sources into consistent hierarchies and provide drill downs on them. The data is loaded into the data warehouse using Informatica as the ETL Tool. The critical part of the project is to make available this data updated daily.
Responsibilities : Responsible for the full lifecycle development, implementation and production support of the Oracle Data warehouse using Informatica Power Center.
Identified and defined business rules and transformation logic for various phases of the project.
used reusable transformations, parameters and Mapping variables.
Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks like setting and getting Dimension details.
Worked on various Transformations like Connected and Lookup, Aggregator, Expression, Filter, Router, Update Strategy, Stored Procedure and Sequence Generator, Sorter.
Involved in Increasing ETL process performance by identifying performance bottlenecks, eliminating them and identifying the next performance bottleneck until the mapping flow performance is the optimum.
Configured single-pass reading to reduce the number of times the Integration Service reads sources.
Optimized filters to maximize session performance, only process records that belong in the pipeline.
Interacted with the users and making changes to Informatica mappings according to the Business requirements.
Created and monitored sessions using Informatica Server and Workflow monitor.
Created UNIX shell scripts for Informatica jobs automation.
Analyzed sales/spend data and provided quantitative analyses across markets, business units and functions.
Managed all aspects of shared reporting services in Hyperion performance Suite.
Developed short and long term strategies for the Data warehouse, while managing the data quality/integrity across the Data warehouse.
Set direction, validation and testing schedules for upgrade from Hyperion 8.5 to 11g.
Environment : Informatica Power Center 8.6, Informatica Power Exchange, Teradata, Oracle 10g, Windows NT, HP UNIX, IBM, Toad 8.6, BMC Remedy User 7.1

March, 2008 -  October, 2008
Senior Informatica Developer

Description : The main goal of the project was to manage its credit card accounts, web banking, online statements and bill pay services. As an ETL developer the responsibility was to integrate the data from these different sources into data warehouse where decision makers could retrieve it for market analyses and reporting purposes.
Responsibilities : Involved in the upgrading of Informatica from version 7.X to 8.X for data warehouse.
Involved in the design of customer loan data warehouse.
Developed DOS command scripts for running Informatica jobs and to implement pre-session and post-session tasks.
Involved in developing Mainframe JCL jobs for running INFORMATICA jobs.
Developed complex stored procedures to implement the routing logic.
Handled various data sources Teradata, DB2, SQL server, XML, Oracle.
Documented different levels of ETL design process following the Mitsubishi standards.
Designed ETL process flow for entire DWH application and developed data mapping spread sheets to define transformation rules for each stage of ETL process.
Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.

Worked extensively with Informatica to build complex relationship mappings, performing multi-table lookups, several other transformations.
Involved in debugging mappings, recovering sessions and developing error-handling methods.
Used SQL SERVER Data transformation service DTS to load data.
Worked with Terabyte data volumes, Optimized the sessions, mapping to achieve the best performance and to load the data in a specified time window.
Identified and implemented slowly changing dimensions like Tier and Dealership.
Interacting with the users and making changes to the Business object reports and Informatica mappings according to the Business requirements.
Worked in pre and post production environments providing 24x7 production support.

Environment : Informatica 7. X/8 .X, Business objects 5.1, Infoburst 1.5, Mainframe DB2, Oracle10g/9i PL/SQL, SQL Server2000, PL/SQL, T-SQL, Teradata, Solaris8.0, IBM Mainframe - Z/OS, Windows XP/2000/2003, HP-UNIX, T-SQL, DTS.

December, 2007 -  February, 2008
ETL Developer

Description : Customer Focus Initiative CFI is a Datamart which provides analysis for corporate agent Complaint management system. The information stored is used to provide time series analysis of agent complaints as they progress through complaint workflow.
Responsibilities : Worked in all phases of project life cycle Design, Development, Testing and Production Support.
Worked with the Business Analysts to gather Requirements and to implement business
Transformation rules and logic
Developed several Complex Informatica Mappings using filter, expression, look up, joiner and update strategy transformations.
worked on Espresso 5 to schedule Informatica Workflows.
Worked on Informatica Power Exchange to pull Policy data from SAP system.
Helped in Migration from version 7.1 to version 8.x of Informatica Power center.
Contributed to the elaboration of best practices in data integration and management.
Helped in preparing key documents and project Specifications.
Identified the bottlenecks and helped in optimizing ETL performance.
Cleanse the source data, extract and transform the data based on business rules.
Created and Scheduled Sessions and Batches through the Informatica Server Manager.
For better performance created partitions, SQL Over ride in source qualifier.
Worked on Informatica Power Analyzer 3.5 to generate Reports having functionality like Slice and Dice, Master/Detail, Charts/Plots and Formulas.
Wrote Unix Scripts for event automation.
Maintained Development, test and Production repositories.

Environment : Informatica Power Center 8.x Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor, Informatica Power Exchange, SQL Server 2000, Sql Server 2005, Oracle 10g Windows NT, Query Analyzer, Aqua Data Studio, Espresso 5, HP service Desk.

January, 2007 -  November, 2007
Informatica Developer/BO Developer

Description : The project involves designing and developing data warehouses and analyzing the data using Business Objects for helping the management to make better business decisions. The data coming from different operational sources like Mainframe DB2, Flat files, XML and Oracle is loaded into Microsoft SQL server and oracle using Informatica.
Responsibilities : Analyzed the source data on mainframe and created data maps using COBOL copy Books.
Imported the source into the source analyzer using Power connect.
Created specifications for the mappings based on the business requirements.
Worked extensively on transformations like Router, Connected and Unconnected lookups, Union, Joiner, Expression and Aggregator, Update strategy in the mapping development.
Created Mapplets using Mapplet Designer to reuse Mapplets in the mappings.
Used Mapping Parameters and Mapping Variables globally
Designed reusable transformations and shortcuts to share different mappings
Moved the mappings across the different folders
Used workflow manager for session management, database connection management and scheduling of jobs
Identified the performance bottlenecks and tuned the mappings accordingly.
Designed Universes using Designer of Businessobjects5 .x
Worked on schemas by making necessary changes based on user requirements using Designer.
Environment : Informatica Power Center 7.X Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager and Workflow Monitor, Oracle 10g, Sun Solaris, Informatica Power connect Striva Detail, TOAD 8.0, Businessobjects5 .x.

October, 2006 -  December, 2006
Informatica Developer

Description : The project dealt with the Sales and Marketing Data collected from different tests and IMS data which consisted of all the sales and marketing information for the drugs in the market and prescriber information Hospitals and private clinics. The data was consolidated into the data mart which was used for report generation.
Responsibilities : Interacted with the business community and database administrators to identify the business requirements and data realties.
Responsible for dimensional modeling of the data warehouse to design the business process.
Parsing high-level design specification to simple ETL coding and mapping standards.
Designed new database tables to meet business information needs. Designed Mapping document which is a guideline to ETL Coding.
Documented standards handbook for Informatica code development.
Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
Used SQL queries and database programming using PL/SQL writing Packages, Stored Procedures/Functions and Database Triggers.
Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator and Joiner on the extracted source data according to the business rules and technical specifications.
Loaded the data from IMS files into oracle tables using Informatica with any data cleansing required.
Worked on SQL tools like TOAD to run SQL queries and validate the data.
Worked on database connections, SQL Joins, views in Database level.
used SQL*Loader to load Data from flat files to Database tables in Oracle.
Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
Used UNIX shell scripting for Scheduling Informatica Workflows.
interacted with business analysts and assisted in creating Classes and Objects using Business Objects.
Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.
Implemented Slowly Changing Dimensions to update the dimensional schema.
Implemented procedures/functions in PL/SQL for Stored Procedure Transformations.
Monitored workflows and collected performance data to maximize the session performance.
Resolved memory related issues like DTM buffer size, cache size to optimize session runs.

Environment : Informatica Power Center 7.X, Informatica Power Connect, Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager, Erwin 4.5, Flat files, Oracle 9i, Sql Server 2000, PL/SQL, Business Objects 6.5, Shell Programming, SQL Loader, IBM DB28.0 Toad, Excel, Sun Solaris, Windows NT.

January, 2005 -  May, 2006

Description : The project involves designing and developing data warehouses and analyzing the data using Business Objects for helping the management to make better business decisions. The data coming from different operational sources like Mainframe DB2, Flat files, XML and Oracle is loaded into Microsoft SQL server and oracle using Informatica.
Responsibilities : Interacted with various departments in the mainframe environment to know about the format of data coming from mainframe environment.
Used Informatica Designer to create complex mappings using different transformations to move data to Oracle Datamart.
Developed mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Source Qualifier, Expression, Filter, Router, Lookup, Aggregator, Rank, Update Strategy and Joiner.
Used Normalized transformation extensively to normalize the data from the Mainframe environment.
Developed expressions to convert the dates in Gregorian and Julian formats to standard date format that suites the database.
Used FTP connection browser available in Informatica Workflow Manager to FTP the flat files into the Mainframe environment.

Skills

ETL Tools : Informatica . X/6, Informatica Power Analyzer, Informatica Power Connect, Informatica Power Plug, Informatica Designer Components Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor, Power exchange 8.5 RDBMS : Oracle 9i/10g SQL, PL/SQL, Stored Procedures, Triggers, Teradata 4. x/5.0, SQL server, DB2, Mainframe, COBOL, VSAM OLAP : Business Objects 5.1, 6.1, 6.5 Info View, Web intelligence 2.6.6 Hyperion/Brio Explorer 6.x Operating System : UNIX HP UNIX, LINUX, AIX, Windows NT/98/95, WIN 2000 Programming : xml, Visual Basic 6.0/5.0, SQL, PL/SQL, UNIX Shell Scripting Korn, C, Transact-SQL and COBOL Environment : IBM AIX 5.x, Sun Solaris 2.6/2.7, HP-UX, Linux, Windows Server 2003 or XP or NT or 2000 or 98



Miscellaneous

Designed and Developed the Informatica workflows/sessions to extract, transform and load the data into Target.
Involved in upgrading from 6.x to 7.x
Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
Wrote SQL, PL/SQL codes, stored procedures and packages for dropping and re- creating indexes, to generate oracle sequences, procedures that cleans up the base automatically in case the mapping ran, the procedure that will expire existing records and update specific Code, packages to incorporate business rules to eliminates transformation dependency.
Worked with UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
Environment : Informatica Power Center 7. x/6 .x Designer, Workflow Manager, Power Exchange 8.1.1 SQL Server 2000, Oracle 9i, SQL Navigator 5.0, DB2 8.0, Access, Windows NT, UNIX Shell Scripts.