SUMMARY

• Around 10 + years of experience of S/w development which includes experience in ETL, Data warehousing with emphasis on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems.
• In - depth experience developing complex SQL queries.
• Experienced in all phases of software development life cycle- Data Analysis, Data Modeling and designing, Development, Testing, Implementation, Documentation, Maintenance and Support.
• Hands on experience in ETL tool Informatica Power Center in analyzing, designing and developing ETL processes for Data Warehousing projects using Informatica Power Center (9.x/8.x/7.x/6.x).
• Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Experienced in identifying Bottlenecks in ETL Processes, improving teh Performance of teh production loads and data access using Database Tuning, Index Usage.
• Involved in gathering business requirements and defect management team to facilitate ETL Development.
• Experience in creating Reusable tasks (Sessions, Commands and Email) and Non Reusable tasks (Decision, Timer, Assignment, Worklets, and Control).
• Experience in dealing with methodologies like Data loading and SCDI, SCDII and SCDIII.
• Experience in performance tuning of sources, targets, mappings and sessions.
• Worked with BI team to bring teh new tables or new attributes into Data Warehouse for reporting purpose.
• Experience with relational databases such as Oracle 8i/9i/10g, SQL SERVER 2005/2008, Oracle and SQL-Server.
• Worked with various SQL Editors such as TOAD, SQL Plus, and Query Analyzer.
• Expertise in UNIX shell scripting and automation of workflows. Experience in monitoring, maintaining and optimizing database and ETL processes.
• Excellent technical and professional client interaction skills.
• Trained in ILM - TDM (Informatica Lifecycle Management - Test Data Management)

TECHNICAL SKILLS

Operating System: UNIX(IBM AIX), Windows XP/Vista

RDBMS: Oracle 8i/9i/10g, teradata, SQL-Server

ETL: Informatica Power Center 9.0x/8.x/7.x/6.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Monitor and Informatica Server) ETL,, Metadata, Datamart, FACT & Dimensions tables.

Methodologies: Star Schema, Snowflake Schema

Programming Languages: SQL, PL/SQL

Other: TOAD, MS Excel, Word and PowerPoint

PROFESSIONAL EXPERIENCE

Confidential

Support Analyst

Responsibilities:

• Based on teh requirements I created Functional design documents and Technical design specification documents for ETL Process.
• Designed, developed Informatica mappings, enabling teh extract, transport and loading of teh data into target tables.
• Created Workflow, Worklets and Tasks to schedule teh loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Used mapplets for use in mappings thereby saving valuable design time and effort.
• Created complex mappings using Aggregator, Expression, Joiner transformations.
• Extensively worked with joiner functions like full outer, master outer and detail outer join in transformation.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load intervals.
• FTP teh large volume files from one server to another server.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Written shell scripts in UNIX to execute teh workflow, created Workflow, Worklets and Tasks to read parameters from parameter files.
• Designed and implemented mappings using SCD and CDC methodologies.
• Designed and developed process to handle high volumes of data and large volumes of data loading in a given load window.
• Created and scheduled UNIX scripts to control teh ETL processes.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Extensively involved in migration of ETL environment, Informatica, Database objects.

Environment: Informatica Power Center 9.1, IBM UNIX AIX 5.3, Control M

Confidential

IT Analyst

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings.
• Part of Upgrade Team from Informatica 7.1 to Informatica 8.6.
• Responsible for Business Requirement Documents BRD’s and converting Functional Requirements into Technical Specifications.
• Extracted data from various heterogeneous sources like DB2 and Flat Files.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs.
• Extensively used Source Qualifier Transformation, and used most of its features like filter, sorter, and SQL Override.
• Extensively used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, Look up, Update Strategy, Sequence Generator, Rank and Aggregator.
• Extensively used LTRIM, RTRIM, ISNULL, ISDATE, TO DATE functions in Expression Transformation for data cleansing in teh staging area.
• Extensively worked with Substr, Instr, Decode functions in teh Expression Transformation.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling.
• Responsible for Performance Tuning at teh Source level, Target level, Mapping Level and Session Level.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for determining teh bottlenecks and fixing teh bottlenecks with performance tuning.
• Used Update Strategy to insert, delete, update and reject teh items based on teh requirement.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Worked with Session Logs and Workflow Logs for Error handling
• Maintains job scheduling changes and additions, when required

Environment: Informatica Power Center 7.x/8.x, DB2, Flat Files, Oracle, UNIX, Windows XP, Informatica Scheduler

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Interacted with business analysts and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build teh DataMart.
• Developed mappings to extract data from COBOL files, DB2, Flat files and load into DataMart using teh PowerCenter.
• Developed common routine mappings. Made use of mapping variables, mapping parameters
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to meet teh requirements.
• Developed Slowly Changing Dimension for Type 1 SCD.
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Experienced working with Customer Information Data Mart for business reporting thru Reference Data
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter
• Written shell scripts to run teh workflows and automated them through WLM scheduler.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Defects were tracked, reviewed and analysed.
• Used Source Analyser and Warehouse designer to import teh source and target database schemas, and teh Mapping Designer to map teh sources to teh target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 8.6, IBM UNIX AIX 5.3, Control M

Confidential, New York, NY

ETL Developer

Responsibilities:

• Developed common routine mappings. Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to meet teh requirements.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and teh Target Data.
• Data extraction and data transfer from DB2 Database to Flat files with Delimited and Fixed width files and vice versa. Few of teh sources were as .csv files.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Written shell scripts in UNIX to execute teh workflow, created Workflow, Worklets and Tasks to read parameters from parameter files.
• Written few stored procedures in SQL-Server.
• Designed and implemented mappings using SCD and CDC methodologies.
• Designed and developed process to handle high volumes of data and large volumes of data loading in a given load window.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Did testing on ETL Informatica process for various data loading scenarios.
• Validated teh ETL Scripts in teh Target Database (Oracle) for creating teh cube before migrating it to SQL Server.

Environment: Informatica 6.X(Designer, Workflow Manager, Workflow Monitor and Repository Manager,QTP, COGNOS, Quality Center 9.2, Oracle 10g/9i, Flat files, SQL, PL/SQL, TOAD 7.x, java, Windows NT, Agile, Shell Scripting, TOAD,UNIX

Confidential

Senior Application Developer

Responsibilities:

• Translated business requirements into technical requirements
• Designed Web Pages for teh site using HTML, developed forms using ASP, VBScript, and JavaScript.
• Designed various GUI screens to capture teh information and save and update teh user information.
• Did extensive coding to build teh system using complex controls like grid, Repeater and dropdown lists
• Co-ordinated team meeting and assigned and tracked teh module completion assigned to each team member
• Daily version control in Visual Source Safe, saving and maintaining versions and documentation
• Did code reviews of programs and prepared unit test cases and tested teh codes.

Environment: Win95, Win-NT, ASP, JavaScript, VBScript, WAP, VB, VC++ Tools: Nokia SDK, Visual Studio 6.0, MSSQL 7.0, Adobe Photoshop, Microsoft Server Commerce Edition, Macromedia Dreamweaver 3.0, Rational Rose 98 Enterprise edition.

Confidential

Software Application Developer

Responsibilities:

• Studied teh manual process of teh business and interacted with business client to gather teh requirement to automate teh system
• Prepared SRS document, translated business requirements into technical requirements
• Designed teh database for teh system and prepared teh program specifications,
• Designed various GUI screens to capture teh information and save and update teh user information.
• Extensively coded to build teh system.
• Translated business requirements into technical requirements
• Data extraction and data Transfer from DB2 Database to Flat files with Delimited and Fixed width files vice versa. Few of teh sources as .csv files.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Written migration scripts to migrate teh database from MS-Access to SQL-Server