PROFESSIONAL SUMMARY

• Over 7 years of strong IT experience in Systems Analysis, Design, Development and Testing of Data Warehouse/Data Mart, Data Integration and Data Migration applications usingInformatica products such as Power Center 9.0/8.6.1/8.6/8.0/7.1, Power Exchange in various domains like Insurance, Financial and Retail sectors.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional andmultidimensional modeling.
• Extensive experience with ETL tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Serverand scheduling the Workflows and sessions.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer transformation using variousCOBOL sources, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Worked with different data sources like Flat files, XML files, and other relational and non-relational Databases.
• Experience in Full life cycle of Software development(SDLC) including Business Requirement Gathering & Analysis, System study, Application Design, Development, testing, Implementation, System Maintenance, Support and Documentation.
• Knowledge of Reporting tools like OBIEE, Cognos, Microstrategy and Business Objects.
• Extensive experience in Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica 6.2 using PMCMD, repository creation/Backup/Restore using PMREP, creating repository user/role/group.
• Extensive Experience in Performance Tuning of targets, sources, mappings and sessions, Co-ordinating with DBAs and UNIX Administrator for ETL tuning.
• Extensively worked in Client-Server application development using Oracle 9i/8i, PL/SQL and SQL*Plus.
• Worked with Oracle Stored Procedures, Triggers
• Experience in SQL tuning and creation of Indexes for faster database access, used explain plan for better query performance.
• Knowledge of Informatica Data Quality (IDQ) and experience in Informatica DAC tool for customizing Datawarehouses.
• Experience in UNIX shell scripting and working on Unix Environment. Experience in working with scheduling tools like Autosys and Control M.
• Experienced in interacting with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tool

Informatica Power Center 9.0/8.6.1/8.6/8.5.1/8.1/ 7.1.3/7.1.1/6.2(Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor) Informatica Power Exchange

Data Modeling

Logical and Physical data modeling, Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, ERWIN

Operating Systems

Red Hat Enterprise Linux RHEL 3.x, 4.x, 5.x, HP-UX 10.x, 11.x, AIX 5.1, 5.2,5.3,6.x, Sun Solaris and Windows NT/2000/03/05/08

RDBMS

Oracle 11g/10g/9i, SQL server 2000/2005/2008,IBM DB2,MS-Access

Languages

SQL, PL/SQL, C, Java Minimal, UNIX Shell Scripting, PERL Scripting

Toolsand Utilities

SQL* PLUS, TOAD for Oracle V8.6,ERWIN 4.0, FTP Tools, PL/SQL Developer, SQL*LOADER

EDUCATION

• Bachelor of Technology in Computer Science Engineering

CERTIFICATIONS

Oracle Certified Associate

PROFESSIONAL EXPERIENCE

Confidential,Austin, TX Mar 10 Mar12
Role: Senior Informatica Developer

Confidential, is an American for-profit privatizing company which provides program management and consulting services to local and state governments across the United States. It is the nation’s largest private provider with a primary focus on health and human services programs.

Responsibilities:

• Used Informatica ETL to load data from flat files, which includes fixed-length as well as delimited files and Sql Server to the Data mart on Oracle database.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Developed complex Mappings using Transformations (Filter, Router, Expression, Joiner, Connect Lookup, Unconnected Lookup, and Updated Strategy) on the extract data according to the Transformation Business Rules and User requirements.
• Built re-usable Mapplet using Informatica Designer. Involved in creating logical and physical data models using Erwin tool.
• Worked with Power Center -Designer tool in developing mappings to extract and loading the data from stage to pre-load and later to date warehouse.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Worked on Push down Optimization (PDO), which improves the mapping performance
• Involved in the debugging of the mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved with the team in Dimensional modeling of the Data warehouse and evaluated INFORMATICA Power exchange for CDC (Change Data Capture).
• Coordinated with SME for technical clarifications. Developed technical design documents of EDW.
• Developed Unit Test Cases to ensure successful execution of the data loading processes.
• Used Parallel processing capabilities, Session partitioning and Target Table partitioning utilities.
• Created Stored Procedures & Functions for data transformation purpose.
• Generated PL/SQL Triggers and Shell scripts for scheduling periodic load processes.
• Scheduled Workflows using Cron.
• 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, andtest cases for manual and automated testing.
• Participated in weekly end user meetings to discuss data quality, performance issues, ways to improve data accuracy and new requirements. Involved in providing Tier 1 support for Informatica Production Support, including off hours and weekends.

Environment: Informatica Power Center 9.0/8.6.1, Power Exchange, Windows, Oracle 11g, SQL server 2008 Erwin, Meta Data Manager SQL, PL/SQL, Unix, Cron, TOAD

Confidential,MI Sep 08- Feb 10
Role: Senior Informatica Developer

Confidential, is a health Insurance companywhich provides product support to other health entities like WellPoint, care first and horizon

Responsibilities:

• Analyzed and interpreted the business requirements for a data warehouse system.
• Used type I and type II dimensions to update and insert the information in the data warehouse.
• Extensively worked on tuning the indexes on Oracle and SQL server tables.
• Worked with different sources like .csv files, Oracle, SQL Server.
• Involved with the team in Dimensional modeling of the Data warehouse and studied Erwin 4.0 business process, grain, dimensions and measured facts design.
• Worked with MLOAD, FASTLOAD, TPUMP and BTEQ utilities for improving the performance.
• Developed mappings by implementing complex business rules using Router, Lookup, Expression, Sequence Generator, Rank, Joiner, Update Strategy etc. to manipulate the data flow from source to target with versioning concepts included
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, Batch jobs/Worklets and Workflows.
• Involved in debugging the Mappings that failed using debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Developed Error handling mechanism and delta logic in different mappings..
• Overriding the default query in the Source Qualifier by incorporating customized SQL queries and applying the business rules at the source itself to improve efficiency and avoid cumbersome transformations.
• Prepared mapping specification documents for EDW project.
• Fixed bugs for ongoing production support application.
• Developed technical design documents of EDW.
• Scheduled different workflows using Informatica scheduler.
• Developed workflows using different tasks like Decision, Email, Command, and Event wait.
• Designed and Deployed extract-transform-load (ETL) processes using Informatica.
• Worked on creating and editing sessions using Informatica pre- and post-session commands, performance and advanced options, error handling settings, log file settings and session level override for transformations.
• Developed UNIX shell script to load environment variables needed to run PowerMart jobs using pmcmd command line.
• Performed unit testing on complex data exchange mappings and Informatica mapping.
• Worked along with the DBA’s to resolve performance and tuning issues.
• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Created, managed and formatted standard reports, master/detail reports for the decision support system regarding to the company’s sales revenue.
• Lead a team of 15 offshore resources and monitored the tasks assigned to them

Environment: Informatica Power Center 8.1/8.6.1, SQL Server 2005,Oracle 10g, Teradata V2R12/V2R6, SQL Assistant, Sybase, Meta Data Manager, Erwin, Enterprise Architect, ER studio, MS Access, Agile Methodology

Confidential, New York City, NYMar 07 Aug 08
Role: Senior Informatica Developer

Confidential, is a major global financial derivatives brokers. MF Global provides exchange-traded derivatives such as futures and options as well as over-the-counter products such as Contract for difference (CFDs), Foreign Exchange and spread betting.

Responsibilities:

• Integrated data into EDW by sourcing it from different sources like mainframe copy books (COBOL files) and Oracle tables
• Involved in analysis and resolving the data issues related to Customer, Distributor and Transaction increments of the data warehouse.
• Involved in review and finalizing the technical specs of source-target mapping documents.
• Involved in designing Error Handling strategy using Error detection/Notification/Re-Processing processes.
• Experience in working with ETL against large scale terabytes of data and databases.
• Involved in designing Audit process for the sessions loaded as part of mapping design as well querying against Informatica repository tables.
• Involved in enhancing the current data model using Erwin 4.0 to accommodate the new EDW and Cross-Reference tables.
• Involved in data migration procedure and mapped data from legacy systems to new existing systems for providing a design for data extraction and data loading.
• Involved in all data migration phases like design, extraction, cleansing, load and verification.
• Created both sequential and parallel loading of the data from Workflow manager.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy.
• Worked on setting up SSIS packages for data management from third party vendors.
• Involved in performance tuning Informatica mappings with XML, Normalizer, Joiner, Aggregator, Sequence Generator, Union, Router, Filter transformations.
• Used Workflow Manager for creating workflows, Worklets, emails, and command tasks.
• Development of UNIX shell scripts to automate starting/recovering the Informatica workflows.
• Involved in scheduling the Informatica workflows using Control-M.
• Involved in tuning the mappings with audit, error design and reprocessing strategies
• Implemented load parallelism using Informatica database partitioning.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batch Jobs and the Target Data.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

Environment: Informatica Power Center 7.1/8.1, Power Exchange 8.1, Metadata Manager,Power Connect, XML, Oracle 10g, Autosys, SSIS, Erwin 7.0, DB2 on Mainframe, AIX

Confidential,New York, NYMar 06 Jan 07
Role: ETL Developer

Redcats USA is a multi-channel home shopping leader offering a wide range of value and quality driven merchandise categories, including men\'s and women\'s plus-size apparel, home and lifestyle product and sporting goods/outdoor gear.

Responsibilities:

• Worked on designing of Central customer database and decision support system for ETL and UNIX process.
• Involved in analysis of three different source systems and prepared technical specifications for the ETL.
• Developed Error/Exception handling mechanism to enhance the data quality loaded to EDW.
• Involved in enhancing the data model for new additions of dimension and reference tables.
• Responsible for data migration in order to achieve an automated migration. Involved in all stages of data migration.
• Worked on Informatica workflow manager to organize sessions, scripts and commands.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Worked on connected as well as unconnected look-ups.
• Worked on column level data validation rules on source data before data enters record by record stage of formatting and standardization.
• Created Mappings and Mapplets using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator and Update Strategy.
• Collaborated with other team members to create technical specifications for ETL/ELT processes based on functional specifications and developed ETL/ELTs based on the technical specifications.
• Extensively worked with Power Connect to import sources from external systems like ERP.
• Created SSIS Packages to migrate slowly changing dimensions.
• Used Workflow Manager for creating workflows, Worklets, email and command tasks.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Involved in tuning Informatica Mappings and Sessions by implementing parallelism, partitioning and caching.
• Developed UNIX and Perl scripts to automate different tasks involved as part of loading process and scheduling.
• Performed Unit Testing and Integration Testing on the mappings.

Environment: Informatica Power Center 7.1.1,SSIS, Erwin, XML, Oracle, SQL, Power Connect, PL/SQL, SAP, UNIX, C#, SQL Server 2005, Windows XP, TOAD

Confidential,Jan 05 Feb 06
Role: ETL Developer

Confidential,is an organization that provides consulting and IT services to clients globally- as partners to conceptualize and realize technology driven business transformation initiatives.

Responsibilities:

• Analyzed specifications and identified source data needs to be moved to Data Mart. Participated in the Design Team and user requirement gathering meetings.
• Involved in designing and analyzing the data warehouse using Reverse engineering and Forward engineering methodology in ERWIN Star schemas and the respective dimension tables were designed and generated.
• Worked on Informatica Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical teams.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to design, develop andtest complex mappings and Mapplets to load data from external flat files and RDBMS.
• Worked with the Business Analyst team during the functional design and technical design phases.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Participated in the analysis of development environment of extraction process and development architecture of ETL process.
• Used Informatica Power Center 6.2 for extracting Oracle, flat files for Data Extraction. Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected and Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, Update Strategy and Sequence Generator.
• Extensively used Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica 6.2 using PMCMD, repository creation/Backup/Restore using PMREP.
• Used INFORMATICA POWERCONNECT to extract data from IBM MAINFRAME/DB2 environment and evaluated INFORMATICA Power exchange for CDC (Change Data Capture).
• Involved in Unit testing for the validity of the data from different data sources.

Environment: Informatica Power Center 6.2/7.1, Power Connect, Power exchange, Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, ERWIN 3.5, Shell Scripting using AWK/ SED on Unix Sun OS 10, WINDOWS NT