SUMMARY:

• An accomplished software engineer with 7+ years of experience in Database design and in Data modeling and Data warehousing applications.
• Extensive project development experience using Oracle/Netezza as the main Relational Database Management System, under many platforms & using different combination of tools.
• Extensive Data Warehouse experience using Informatica Power Center v 9.6/9.1/8.6/8.1 , (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer) as ETL tool.
• Experience on Netezza Performance Server (NPS) and Netezza Tools, Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Good Knowledge and experience Ralph Kimball Star Schema strategies for Data warehouse development and maintenance.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Involved in administering Informatica server activities (pmcmd commands) such as creating, scheduling and managing sessions and batches, as well as, troubleshooting and performance tuning of Informatica server.
• Experienced in overall data warehouse, database, ETL and OLAP tuning for better performance.
• Experienced in shell scripting and PL/SQL procedures in automation of ETL process.
• Involved in identification of facts, measures, dimensions and hierarchies for OLAP models.

TECHNICAL SUMMARY:

ETL tools: Power Center 9.6/9.1/8.6/8.1 , Mapping Designer, Server Manager and Repository Manager, Power Connect.

Reporting Tools: Micro Strategy 9.4.1, Business Objects XI, CrystalReports10.0, Cognos 6.5 (Impromptu)

Databases: Oracle 10g/9i/8i, SQL Server 2008/2005, DB2 UDB9.1, COBOL, SQL Loader, MS Access 97/2000

Languages / Packages: UNIX shell scripts, PL/SQL, Perl, Java, JavaScript 4.1/5.5/6.0, C/C++Other Concepts / Libraries Dimensional modeling, Star Schema, snowflake schema, Kimball methodology, code pages, DBCS

Operating Systems: UNIX, Windows 2003/2000/98/95

Data Modeling Tool: ER STUDIO 7.0,Erwin, Oracle Designer, Designer 2000

PROFESSION EXPERIENCE:

Confidential, Washington, DC

Senior Informatica Developer

Responsibilities:

• Understanding Business Processes and coordinating with Business - users to get specific requirements.
• Extracting and loading of data from DB2 (IBM mainframes), Oracle sources to Oracle database using Informatica mappings
• Experience working with databases like Netezza(Appliance) as Target database, Sql Server, DB2 as source systems and used client tools like Aginity Workbench, Winsql to connect to the databases.
• Writing data extracts to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
• Created Complex mappings, Reusable transformations, Shortcuts, mapplets and testing the data extract to check if they conform to the business rules and taking repository backups regularly.
• Involved in creating staging Tables, Indexes, Sequences, Views and performance tuning like using SQL Loader/Parallel loads into tables, analyzing tables, proper indexing and dropping, tuning the mappings.
• Documenting the entire ETL process and mappings and mentored the users in Informatica, maintained the mappings according to the ETL standards.
• Identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Involved in administering and monitoring the daily jobs, provide immediate fixes for any data related issues.
• Performed Informatica administration tasks like migrating the workflows, sessions and mappings from development to production server, periodic restarting the servers
• Developed shell scripts for various Informatica pre and post session operations, used pre and post SQL commands to handle database operations.

Environment: Informatica PowerCenter 9.6.1/9.1,Oracle10g,DB2UDB 8.1, PL/SQL, SQL*Plus, ER STUDIO 7.0, Micro Strategy 9.4.1,Netezza 7.0.1

Confidential, CENTERVILLE, VA

Senior Informatica Developer

Responsibilities:

• Present the IT solutions implementation approach as dictated by the Business Requirements Documents requirements classification and methodology
• Present the risks, dependencies, and outstanding items that require attention from the project stakeholders
• Responsible for designing, developing and unit testing of the mappings.
• Developed mappings using Informatica PowerCenter Designer to load data from various source systems to target database as per the business rules.
• Used various transformations like Source Qualifier, Aggregators, Connected & unconnected lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, etc.
• Involved in developing test cases for the Informatica mappings and update processes.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Performed the unit, system and integration testing for the jobs.
• Validated the test results by executing the queries using the Toad software.
• Prepared test plans for both unit and system tests.
• Responsible to design, develop and unit test the mappings.
• Developed re-usable transformations, re-usable mapplets.
• Wrote design documentation for the ETL process and Informatica mappings.
• Unit tested the mappings by running SQL queries and comparing the data in source and target databases.
• Worked with source teams to resolve data quality issues raised by end users
• Created TIDAL jobs and schedules based on demand, run on time (Daily, Weekly, Monthly), run only once and Ad-Hoc.
• Involved in writing Pre-session and Post-session korn shell scripts for dropping & creating indexes for tables, Created shell scripts which will substitute all the user and schema information in the SQL queries

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008, Business Objects XI R2, TIDAL

Confidential

Senior Informatica Consultant

Responsibilities:

• Involved in the Designing of ETL process, load strategy and the SRDS after collecting the requirements from the end users.
• Designed and Created data cleansing and validation scripts using Informatica ETL tool.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy
• Used transformation Logic to cleanse the data.
• Extensively worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,
• Created Joiner Transformation to join heterogeneous sources using various kinds of joins like Normal Join, Master Outer Join, Detail Outer Join, and Full Outer Join
• Developed slowly changing dimensions mapping to accommodate the passive mode phase.
• Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for weekly loading of Data.
• Worked with Informatica PowerCenter-Source Analyzer, Warehousing designer, Mapping Designer & Mapplet and Transformation Developer for creating Mappings.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Tuned performance of Informatica Sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensively Used Environment SQL commands in workflows prior to extracting the data in the ETL tool.
• Created target load order group mappings and scheduled them for Daily Loads.
• Wrote Unix Scripts and SQL Commands to test and analyze the data.
• Migrated Mappings, Sessions, Workflows and Common Objects from Development to Test and to Production.
• Assisted in fixing and modifying mappings in production support

Environment: Informatica Power Center 8.1, Power Exchange 8.6, Oracle 10g, SQL Server 2005, UNIX,, Windows XP, CrystalReports10.0

Confidential, Camden, NJ

Informatica Developer/ETL Designer

Responsibilities:

• Responsible for meeting with business users to discuss and finalize the requirements and design the approach.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the Loads.
• Prepared various mappings to load the data into different stages
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on Oracle 10g and SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on SQL programs and Db2 stored Procedures as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Automated the Informatica jobs for File validation with Signal and Data files.
• Worked on OLAP Services.
• Closely worked with the reporting team to ensure that correct data is presented in the reports and make sure the correct data is on Targets.
• Interaction with the offshore team on a daily basis on the development activities.
• Generated the DDLscripts for the physical data model.
• Involved in Migration project of Informatica Power center 7.1.2 to 8.1.1.

Environment: Informatica 7.1.2/8.1.1 , Windows 7, Oracle 10g, Db2, DB Visualizer, Cobol DB2 Stored Procedures, Cognos 6.5 (Impromptu)

Confidential, Dublin, OH

Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Prepared a handbook of standards for Informatica code development.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Developed Custom metadata repository.
• Used Informatica designer for designing mappings and mapplets to extract data from SQL Server, Sybase and Oracle sources.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Used Debugger to test the data flow and fix the mappings.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Tuned the workflows and mappings.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• 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.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Executed the workflow using pmcmd command in UNIX.

Environment: Informatica Power Center 7.1.1, Oracle 10g/9i/8i, SQL Server 2000, PL/SQL, Erwin, TOAD, SQL*Plus, SQL*Loader, UDB, Sybase, XML, Windows, Linux and HP-UNIX.