SUMMARY

• Over 8+ years of experience in IT industry having extensively involved in analysis and design, testing, implementation, maintenance, production support and knowledge transfer.
• Experience with ETL tool Informatica Power Center /Power Mart 9x/8x/7x/6x/5x/4x, Power Exchange 8.6.1/8.1/8.0 in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Experience using Oracle 10g/9i/8i, MS Access 7.0/2000, PL/SQL, SQL Plus, SQL Server. Strong Experience on database interfaces like PL/SQL Developer, SQL Plus and TOAD.
• Experience in complete Software Development Life cycle (SDLC) including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Developed new methodologies in the Data modeling and the Data mart even at the risk environments.
• Extensive knowledge of Data Modeling, Data Conversions, Data integration Data Mining and Data Migration with specialization in Informatica Power Center.
• Expert on Slowly Changing Dimensions Type 1, Type 2 and Type 3 for inserting and updating Target tables for maintaining the history.
• Good knowledge in interacting withInformatica Data Explorer (IDE), and DQ Data Quality (IDQ).
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts to run various batch jobs.
• Solid experience in writing SQL queries, Stored Procedures, Cursors, Indexes, Views, Sequences and Triggers.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience on post - session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Willing to learn and adapt to new challenges.
• Good knowledge on Smart Stream TLM Configuration.

TECHNICAL SKILLS

Data Warehousing / ETL Tools: Informatica 9.1/8.6/8.1/7. x/6.x/5.x (Repository Admin Console, Repository Manager, Designer, Workflow Manger, Workflow Monitor, Power Exchange), Informatica IDQ

Data Modeling: CA Erwin, OBIEE, MS Visio, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000/7.0/6.5/6.0 , MS-Access 2000/97/7.0.

Languages: C, C++, JAVA, SQL, PL/SQL, T-SQL, BTEQ Scripts, Unix Shell Script

Tools: Toad, SQL* plus, SQL Assistant 13, Fast Load, Multi Load, Fast Export, Putty

Operating Systems: Windows 95/98/NT/XP/2000/2003, Sun Solaris, Linux

PROFESSIONAL EXPERIENCE

Confidential, Little Rock, AR

Sr. ETL / Informatica Developer

Responsibilities:

• Worked closely with Business Analysts to gather Business Requirement Specific (BRS) and Prepare Technical Specifications
• Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Created Sessions, command task, worklets and workflows in Workflow Manager
• Created complex workflows to fulfill the business requirements.
• Analyze, design, and modify the existing educational Data Warehouse’s data structures in Oracle Database
• Modify and develop new ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities.
• Involved in creating logical and physical data models using Erwin tool.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the data according to the business logic.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Migrated data from staging to ODS and from ODS to RPT.
• Moved the mappings, sessions, workflows, maplets from one environment to other.
• Worked with numerous flat files, loaded data from flat files to Oracle.
• Handled multiple tasks at a time and successful in completion on time, without any loss of quality
• Used and developed Shell Scripts used for Pre and Post Session commands for the developed Mappings and scheduling.
• Performed Unit testing and Data validation testing using Validation scripts.
• Co-ordinated UAT validation with business users.
• Worked and executed project based on Agile methodology. Involved in scrum meeting for daily planning.
• Co-ordinated with offshore teams on daily basis to meet the project deadlines.

Environment: Informatica Power Center 9.1, Oracle 11g, Flat Files, Win7, SQL * Plus, Toad, Erwin, OBIEE and UNIX.

Confidential, Los Angeles, CA

Sr.ETL/Informatica Developer

Responsibilities:

• Worked with business users to gather business requirements, and prepared high level design documents.
• Co-ordinated with different teams in designing the project plan.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.
• Analyzed the existed data and workflows to design the workflows.
• Created complex ETL workflows from source to target to fulfill business requirements.
• Developed complex mapping in order to implement Change Data Capture (CDC).
• Extensively used almost all types of transformations like filter, joiner, sorter, rank, update strategy, expression and aggregation.
• Used Repository Manager to migrated code for different environments, from stage to development, development to test.
• Involved in creating logical and physical data models using Erwin tool.
• Created Process Control and worked with Metadata Manager.
• Provided production support and worked parallelly on different priority issues.
• Worked on production support tickets with both onsite and offshore teams to provide optimum solution.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL in order to ensure the data integrity and security.
• Used the job scripts in TIVOLI tool to schedule the jobs.
• Worked for long time on Smart Stream TLM Configuration.
• Created Test case summaries, Move to production lists, Request for change documents.
• Used and developed Shell Scripts used for Pre and Post Session commands for the developed Mappings and scheduling.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.
• Co-ordinated UAT validation with business users.
• Worked and executed project based on Agile methodology. Involved in scrum meeting for daily planning.
• Co-ordinated with offshore teams on daily basis to meet the project dead lines.

Environment: Informatica Power Center 9.1, Oracle 11g,PL/SQL, SAP BW Flat Files, CSV files, XML files, Erwin, OBIEE, Tivoli, UNIX, Win XP, SQL * Plus, Transact-SQL, Control-M, Putty, Toad.

Confidential, Philadelphia, PA

Sr.ETL/Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and performInformatica mapping reviews.
• Extensively used Teradata utilities like Fast load, Fast Export, Multiload to load data into target database.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and Worked on developing ETL mappings.
• Created Parameter files and validation scripts.
• Worked withInformaticaData Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Used FakeMload connection and created used custom Mload Scripts from command task.
• Created Process Control and worked with Metadata Manager.
• Used User Defined Functions for converting SAP values.
• Created command task in Workflow Manager.
• Created Sessions, command task, worklets and workflows in Workflow Manager.
• Did production support after development work is done.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level andSession Level.
• Worked for long time on Smart Stream TLM Configuration.
• Assisted with peer code reviews and testing of development team's T-SQL code.
• Wrote Transact-SQL stored procedures
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.
• Provided production support for the Executive Management Information System (EMIS), a web reporting portal to informatica and teradata data sources
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Power Center 8.6, InformaticaData Quality 8.6.1 (IDQ)Oracle 10g, SAP BW Flat Files, CSV files, XML files, Teradata 13, UNIX, Win XP, SQL * Plus, Transact-SQL, Control-M, Putty, BTEQ

Confidential

SQL and ETL Developer

Responsibilities:

• Used technical transformation document to design and build the extraction, transformation, and loading (ETL) modules.
• Performed source data assessment and identified the quality and consistency of the source data.
• Extensively worked with Repository Manager, Designer, Workflow Manager and workflow monitor.
• Developed transformation logic and designed various Complex Mappings and Mapplets using the Designer.
• Developed complex mapping in order to implement Slowly Changing Dimension (SCD).
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
• Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the batch process.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the Sales Force Data according to the business logic.
• Used and developed Shell Scripts used for Pre and Post Session commands for the developed Mappings and scheduling.
• Worked with pmcmd command line program to communicate with the Informatica server, to start, stop and schedule workflows.
• Performed SQL tuning using explain plan.
• Extensively used SQL and PL/SQL Scripts and worked in both UNIX and Windows Environment.
• Fined tuned ETL processes by considering mapping and session performance issues.

Environment: Informatica PowerCenter 6.2, Informatica PowerCenter 7.1, Windows NT, DB2, Oracle 8i/9i,PL/SQL, Erwin, SQL Server 2000, UNIX.

Confidential

SQL and ETL Developer

Responsibilities:

• Development of General Ledger, Transaction and Profit Margins processes.
• Development of staging for P/E, equities, Derivatives and Fixed income.
• Extracted data from heterogeneous source systems.
• Involved in coding, testing in UAT.
• Designed ETL mappings - Design, SSA, LDM, PDM, Construction, Enhancement, Unit Test planning, Status Reporting

Environment: Windows 2000, Unix, Oracle 9i, Toad 6.3, Informatica 6.1.