SUMMARY

• 7+ years of IT experience and Technical proficiency in Data Warehousing, ETL, and Reportinginvolved wif Business Requirements Analysis, Application Design, Development, testing and documentation. Implementation of full lifecycle in Data warehouses and Data marts in various industries.
• Extensive experience in developing scalable enterprise applications to teh user needs which serves for Sales and Retail Supply Chain Management, Financial, Insurance, and Banking.
• Experience in all phases of teh Software Development Life Cycle (SDLC).
• Good understanding in Dimensional Data modeling, Star and Snowflake Schema.
• Extensive experience wif Informatica power center and its components like Repository Manager, Designer, Workflow Manager and Workflow Monitor, Reusable Transformations, Mappings, Mapplets etc.
• Experience in Data warehousing, Data Architecture & Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center.
• Involved in all aspects of ETL - requirement procurement, establishing standard interfaces to be used by operational sources, data cleaning, developing data load strategies, designing various mappings, executing mappings, unit testing, integration testing, regression testing and UAT in development.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Experience in processing task, scheduling sessions and monitoring workflows.
• Experience in writing scripts such as SQL queries, PL/SQL Stored Procedures, Views, and Materialized Views & Triggers.
• Experience in Business Object Reporting tool. Designed and maintained BO Universe and created Web Intelligence, Desktop intelligence, Infoview and Web Rich Intelligence client Reports.
• Strong technical and professional client interactional skills. Interacted wif Technical, Functional & Business audiences across different phases of teh project life cycle.
• Excellent communication skills, strong decision making skills, organizational skills, adaptive to new and challenging environments, Quick learner and ability meet operational deadlines.
• Recognized for reliability, team work, persistence and strong work ethics.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x(Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager).

Databases: Oracle 11g/10g/9i, Teradata V2R5/V2R4, DB2 UDB 10.0/9.0/8.0, MS SQL Server 7.0/2000, MS Access 2000/1997

Reporting Tool: SAP Business Object R4/R3/R2/6.5 (Designer, Web Intelligence, Desktop Intelligence, Infoview, Web Rich Intelligence Client)

Languages: SQL, SQL*Plus, PL/SQL

Tools: SQL Navigator, SQL*Loader, SQL-Programmer, TOAD (Tool for Oracle Application Development), Oracle Apps (Oracle Applications)

Operating Systems: Windows95/98/2000,XP,Windows 8/8.1,UNIX

Job Scheduling: Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

Sr. Informatica Developer

Responsibilities:

• Analyzed source data and documented requirements from teh business users.
• Worked on understanding and creating ETL Designs, Technical specifications, Mappings/Transformations and Informatica sessions documents confining to teh business rules.
• Worked wif business analysts for requirement gathering, business analysis,project coordination and testing.
• Extensively used ETL to load data using Power Center from source systems like Flat Files and Excel Files into staging tables and load teh data into teh target database Oracle.
• Created mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence-Generator, look-up, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Worked wif Connected and Unconnected look-ups and Stored Procedure for pre & post load sessions.
• Developed Automation logics for teh existing Manual processes.
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run sessions.
• Worked extensively on Mappings, Mapplets, Sessions and Workflows.
• Created UNIX Shell scripts to automate teh process of generating and consuming teh flat files.
• Designed and maintained Business Objects Universe on top of Oracle database reporting tables for historical data Query and Analysis.
• Developed Concurrent programs using Oracle Apps for running/submitting Oracle jobs/reports using Concurrent Manager.
• Developed test cases, prepared SQL scripts to test data and tested teh sessions and workflows to meet teh Unit Test Requirements and used debugger to fix any invalid mappings.
• Involved in walk-through wif team members and QA teams and communicated interface requirements.
• Involved in coordinatingend-to-end Test Strategy and Test Plans for Unit, UAT and Performance testing effort - includes setting up teh environment, code migration, running teh test cycles and resolving teh issues.

Environment: Informatica Power Center 9.x (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 11g/10g, SQL, Teradata, Flat files, Unix, Informatica Schedulers, Windows server, MS Access, Business Object R3/R4 (Designer, Web Intelligence, Infoview/BI Launch Pad, Web intelligence Rich Client), SQL, PL/SQL, TOAD, Oracle Apps, Windows XP

Confidential, Mossville, Illinois

ETL Informatica Developer

Responsibilities:

• Worked wif Business analysts for requirement gathering, analysisand project coordination in order to translate business requirements into technical documents.
• Worked on understanding and creating ETL Design documents and specifications.
• Prepared technical specifications to develop Informatica ETL mappings to establish loading of data into various Data Mart tables confining to teh business rules.
• Extensively used ETL to load data using PowerCenter/from source systemslike Flat Files and Excel Files into staging tables and load teh data into teh target database Oracle.
• Analyzed teh existing systems and made a Feasibility Study.
• Worked wif various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter,Update Strategy, Stored procedure, Router and Normalizer etc.
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Involved in discussions wif Architect for creating teh Dimensions and fact tables.
• Worked extensively on Mappings, Mapplets, Sessions and Workflows.
• Scheduled and monitored teh Informatica jobs using Informatica scheduler
• Created UNIX Shell scripts to automate teh process of generating and consuming teh flat files from Upstream Teradata system.
• Developed Concurrent programs using Oracle Apps for running/submitting Oracle jobs/reports using Concurrent Manager.
• Interacted wif Project Manager, IT architects and SME’s to get a better understanding of teh Business Processes.
• Studied and analyzed teh existing mappings/ transformations to check performance based on bottlenecks.
• Held walk-through wif team members and QA teams and communicated interface requirements.
• Establishedtest cases, SQL scripts to test data and tested teh sessions and workflows to meet teh Unit Test Requirements and used debugger to fix any invalid mappings.
• Worked wif DB2, MS SQL, Oracle, flat files to perform transformations and load to different Oracle Target Tables,Flat Files.
• Worked onsite and coordinated wif off-shore resources and assisted for production stage.

Environment: Informatica Power Center 8.x (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer),TOAD, Oracle 10g, PL/SQL,DB2, Flat files, Unix, Windows server, MS Access, MS Excel

Confidential, Omaha, Nebraska

ETL Informatica Developer

Responsibilities:

• Involved in business discussions wif data modelers and business users to documentthe data to be organized.
• Re - architected data flow for performance and efficiency.
• Developed complex mappings using multiple Sources & Targets in different databases and flat files.
• Designed and created Informatica mappings to construct data mart tables in accordance wif teh client requirements.
• Operatedwif various mappings including different transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup & Unconnected Lookup, Rank, Expression, Router, Filter, and Aggregator & Sequence Generator Transformation.
• Recommended ETL changes to improve maintainability, performance, data quality & best practices.
• Devised efficient mappings using reusable functions such as lookup, sort etc.
• Created Parameter, Variables based on mappings accordingly for Relational DB connections or to enhance performance.
• Enhanced performance for Informatica sessions using large data files, by using partitions, increasing block size, data cache size and target based commit interval.
• Worked wif Dynamic Cache for better output of sessions containing Rank, Lookup, Joiner and Aggregator Transformations.
• Closely worked wif teh Technical Lead in assisting wif data load related architecture and technical design.
• Interacted wif Oracle DBA team for creation of primary and secondary indexes on data warehouse tables.
• In depth understanding of different financial products Corporate/Government Bonds, Loans, Derivatives (IRS, CCIRS, FX Spot, Forward, Options)
• Developed and generated canned and few ad-hoc BO Web and Infoview reports for reporting data as per business requirement.
• Extensively used TOAD to analyze data and fix errors and develop.
• Coordinated wif teh Technical Lead to develop process automation/job scheduling, Perform testing, Perform defect analysis whenever required.
• Created a migration strategy to migrate Informatica Components from Dev to QA/ UAT/Production environment.
• Also participated in teh documentation to describe program development, logic, coding, testing, changes & correction.

Environment: Informatica Power Center 8.1, Oracle 9i, PL/SQL, Teradata,Business Objects, UNIX, Toad, Access 2000, TOAD.

Confidential, Omaha, Nebraska

 Informatica Developer

Responsibilities:

• Requirement procurement from teh end users and preparation of teh BRDs
• Implemented ETL Informatica designs and processes involved in enabling loading of data from teh sources to teh target warehouse
• Handled teh documentation of entire ETL Process from teh ODS, Staging, to teh MDW warehouse environment
• Involved wif all teh Informatica client components like Designer, workflow Manger, Workflow Monitor, Repository Manger, and Repository Admin Console.
• Installed Informatica Server on teh Unix Box and configured teh clients on windows environment
• Established repositories, folders, and users for teh development, staging, and production environment
• Handled various Active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Worked extensively wif various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, Sorter Transformation, and Lookup Transformation.
• Designed mappings from teh scratch and also did performance tuning of teh mappings that were previously implemented
• Responsible for performance tuning at various levels like mapping level, session level, and database level
• Extensively worked wif aggregate functions like Avg, Min, Max, First, Last, and Count in teh Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in teh Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in teh Joiner Transformation.
• Worked wif various kinds of partitions and sub-partitions like Hash Partitioning Key, Range Partitioning etc.
• Extensively worked wif various re-usable tasks, workflows, worklets, mapplets, and re-usable transformations
• Extensively worked wif Connected and Un-Connected Look up Transformations in teh Designer of Informatica PowerCenter.
• Extensively worked wif various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Scheduled and deployed Informatica mappings according teh business logic
• Worked wif teh Business Intelligence tools like Business Objects (Desktop Intelligence, Web Intelligence, Infoview, Designer)
• Testing data availability for downstream applications.

Environment: Informatica Power Center 7.x, Business Objects, Oracle, UNIX, Windows XP