SUMMARY:

• Seven Plus (9+) years of Total IT experience in various stages of Software Development Life Cycle (SLC) including requirements analysis, design, development, testing and implementation.
• Six Plus (9+) years of Data warehousing and ETL experience using Informatica PowerCenter/PowerMart 9.6 - 6.x in Investment, Financial, Medicare and Medicaid, Retail, Telecom sectors.
• Data Modeling experience using Rational Rose, Erwin Modeling tool, Star Schema/Snowflake modeling, Physical & logical data modeling.
• Good experience in writing SQL, PL/SQL Blocks, Stored Procedures, and Triggers on Oracle 10g/9i/8x/7, SQL Server 2005/2000/7.0, DB2,Teradata, Power Exchange.
• Experience in writing UNIX shell scripts for automation of ETL process and Data transfer needs.
• Good exposure to development, testing, debugging, implementation, documentation, end user training and production support.
• Ability to quickly grasp new concepts and apply software methodologies as per business needs.
• Team and Independent Player with excellent Organizational and Interpersonal skills. Excellent written and oral communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, DMExpress.

Reporting Tools: Business Objects, Cognos

Modeling Tools: Erwin 4.1, Rational Rose, MS Visio 2000

Databases: Oracle 11i/10g/9i/8i/7x, SQL Server 2005/2000/7.0, Teradata, DB2,MS Access.

RDBMS Tools: TOAD 8.x, DB Visulizer, SQL Navigator, SQL*Loader (Oracle), SQL Plus

Languages: C, C++, Visual C++, Assembly Language, SQL, PL/SQL, VB, Shell Scripting.

O/S: Windows 95/98/00/NT/XP, DOS, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, RedwoodCity, CA

Informatica Architect

Responsibilities:

• Key architect of EIP(Enterprise Informatica Platform) at IRS which provides unified Data Integration solutions across the IRS
• Design Informatica solution for IRS which can work seamlessly with all other IRS COTS products.
• Installed various Informatica products like Powercenter, Data Transformation, TDM, Address Doctor, PowerExchange for GreenPlum etc
• Implemented multi node platform to enhance the performance of various projects within the EIP
• Provided OS Profiles solution to get pass IRS security issues within various project on EIP platform
• Configured ACL solution to get pass Solaris group limit issue for OS users on EIP Platform
• Resolve various production issues that EIP encountered on day to day basis during the filling season and off season
• Manage around 21 projects on EIP platform and help each project with their application design.
• Implemented GRID and HA solutions on EIP
• Provided solution to various projects within IRS to meet their project timelines
• Helped various projects on their performance issues using Informatica platform
• Developed various scripts to support EIP platform and get the health check of EIP platform.
• Provided solution for code migration across various environment on EIP Platform
• Wrote scripts to back up the Informatica repositories across all the projects, configuration of directory structure for each projects on EIP
• Upgraded various Informatica product across various versions.
• Provided various memory solution to come out from performance issues
• Enabled various IRS employee to configure Informatica for various projects

Environment: Informatica PowerCenter 9.0.1/9.1/9.5.1, PWX, Data Transformation, Address Doctor, Control-M, Solaris, Oracle 11i/10g, GreenPlum, PAM monitoring etc.

Confidential,Owings Mills,MD

Sr. Informatica/ETL Developer

• Understand business requirements and enhancing the existing data warehouse architectural design for a better performance.
• Attended meetings with Performance Analysts and Business Analysts to understand the requirements for FIXED INCOME and EQUITY securities.
• Solving various production issues which occur due to the various data/code issues day to day bases.
• Developed various foreign key and insert/update mapplets, so that same code can be reuse for different feeds
• Set new Integration environment where we can do impact analysis on our newly developed data marts.
• Developed ETL code to load source to landing tables and then from landing to presentation tables.
• Created different Autosys jobs to schedule different workflows, perl scripts and store procs.
• Performed Source system Analysis. Analyzed the source and Target Data elements. Analyzed Source Data granularity.
• Implemented slowly changing dimension data technique to keep track of history
• Extensively worked on various scripts to perform file manipulations on different target files.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the Informatica session for large data files by increasing data cache size and target based commit interval and using sorter as and when required.
• Develop, test, and deliver changes based on business requirements.
• Wrote different test cases and documented each of them
• Extensively performed unit testing and integrity testing.

Environment: Informatica PowerCenter 8.1.1, UNIX, PERL, Oracle 11i/10g, SQL, PL/SQL, DB Visulizer, TOAD, Autosys.

Confidential,Indianapolis,IN

Sr.Informatica/ETL Developer

• Attended meetings with Business Integrator to understand the change requests.
• Developed ETL code and flow using Informatica for integration purpose.
• Performed Source system Analysis. Analyzed the source and Target Data elements. Analyzed Source Data granularity.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the Informatica session for large data files by increasing data cache size and target based commit interval.
• Develop, test, and deliver changes based on supplied requirements.
• Created views and indexes conforming to design requirements.
• Written several PL/SQL procedures, SQL for access various data from tables.
• Wrote different test cases and documented each of them
• Scheduled the Workflows to run at specified intervals.
• Extensively performed unit testing and integrity testing.

Environment: Informatica PowerCenter 7.1.2, UNIX, PERL, Oracle 10g/9i, SQL, PL/SQL, TOAD, Crimson Editor.

Confidential,Montgomery,AL

Sr.Informatica/ETL Developer

• Interacted with Business Analyst to understand the business requirements.
• Assisted in development of design specifications based on business requirements and participated in Dimension modeling.
• Performed Source system Analysis. Analyzed the source and Target Data elements. Analyzed Source Data granularity.
• Implemented slowly changing dimension data technique to keep track of customer history
• Develop, test, and deliver changes based on supplied requirements.
• Identified data quality issues, errors and bottlenecks during data loads and transformations.
• Created outrigger dimensions for aggregated customer information.
• Written several PL/SQL procedures, SQL for converting data from the old data warehouse facts and dimension tables to the new data warehouse.
• Performance tuned the Informatica session for large data files by using pipeline partitioning, increasing data cache size and target based commit interval.
• Code migration from development to test and from test to production environments.
• Used Pushdown Optimization to improve the performance of the ETL processes.
• Implemented different tasks to achieve cyclic execution of workflows
• Scheduled the Workflows to run at specified intervals.
• Extensively performed unit testing and integrity testing.
• Designed number of mappings with transformations using Informatica.
• Designing data extracts layouts i.e. data fields that will be loaded from sources to the staging area in the data warehouse environment.
• Set up sessions to extract data through FTP from remote mainframe data source files.
• Used Debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Exclusively used SQL*Loader to load data to Oracle.
• Developed Shell Scripts, PL/SQL stored procedures, table and Index creation scripts.

Environment: Informatica 7.1.2/6.2, UNIX, Oracle 9i, DB2, SQL, PL/SQL, Business Objects, ERWIN 4.0, TOAD, Power Exchange.

Confidential

ETL Developer

• Installed and configured Informatica 6.1.
• Developed the transformation logic, identifying and tracking the slowly changing dimensions from heterogeneous sources and determining the hierarchies in dimensions.
• Used transformations like Aggregator, Filter, Router, Sequence Generator, Update Strategy, Rank, Expression and lookup (connected and unconnected) while transforming Data according to the business logic.
• Created Sessions, reusable Worklets and Batches in Workflow Manager and Scheduled the batches and sessions at specified frequency.
• Worked extensively on fixing invalid Mappings, and performing Unit and Integration Testing.
• Defined, captured metadata and rules associated with ETL process.

Environment: Informatica 6.1, UNIX, Oracle 8i, SQL, PL/SQL.

Confidential

ETL Developer

• Understanding the RS-232 communication command to exchange information in landline phone.
• Used various TAPI’s to extract the incoming data to landline phone.
• Convert the incoming raw data into meaningful format and store in the database.
• Involved in sending the speech to landline user by using Visual C++ API’s.