SUMMARY

• Over 8 years of experience in Software industry in the areas of Analysis, Design, Modeling, Coding, Testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications, Cognos, SQL, PL/SQL with Oracle, SQL Server back end databases on platform(s) across the UNIX, Windows NT Operating and AIX Systems to provide an integrated management system.
• Experience in Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP).
• Sound knowledge in Relational Database Modeling (RDBMS), Dimensional Modeling (DMS) and DW concepts like - Data marts, Fact tables, Dimension tables, Star schema and Snow Flake Schema modeling.
• In-depth knowledge of Software Development Life Cycle (SDLC),and different methodologies of project like Waterfall and Agile.
• Excellent facilitator and communicator with both upper management and developers in technical / non-technical terms.
• Experience in Data Extraction, Transformation and Loading data using Informatica Power Center 9.5.1/9.1.1/8. x.
• Hands on experience with Complex mappings from varied transformation logics like connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy and Re-Usable transformations.nsformations.
• Experience in performance tuning ETL code, mappings, sessions, workflows, stored procedures, functions, and database.
• Experience in Pipeline and Partitioning Concept.
• Working Knowledge on different data sources such as Flat Files, Oracle, DB2, XML and Excel Files.
• Worked on Workflow Manager by creating Sessions/tasks, Workflows, Worklets, and Reusable Tasks like Sessions, Command, Email and Non-Reusable tasks like Decision, Event Wait and Event Rise.
• Experience in managing Slowly Changing Dimensions (SCD) Type 1, Type 2, Data Marts, OLAP, and OLTP.
• Experience in Production support for maintaining the mappings, sessions and workflows to load the data in Data Warehouse.
• Good in Using the Debugger Wizard to find the bottleneck in the mapping.
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica. Managed & Worked as Lead in different teams along with taking care of my technical responsibilities.
• Highly proficient in web enabled and Client/Server computing environments using SQL Server, PL/SQL and ETL tools like Informatica.
• Hands on experience in using SQL, Indexes, Functions, Stored Procedures, Triggers and Cursors.
• Experience in working with off-shore and near shore models.

TECHNICAL SKILLS

Data Ware Housing: Informatica Power Center 9.x/8.6.1, Informatica Designer, Workflow Manager, Workflow Monitor, Repository Manager, ETL, Datamart, OLAP, OLTP, Mapplet, Transformations.

OLAP Tools: Cognos 8.4 BI

Scripts/programming: Unix Shell Scripts, PL/SQL

Databases: Oracle11g/10g/9i/8i, MS SQL Server 2000/2005/2008/2012 , Teradata 13.10

Software Applications: FTP Applications(Filezilla), MS Word/Excel, MS office visio

Utilities and Tools: putty, Tidal, TOAD, SQL Developer, Erwin, MS Visio, Crystal Reports, MS Office

Programming GUI: PL/SQL, SQL Plus, Unix, Shell Scripting

Environment: Sun Solaris UNIX, IBM AIX, MS DOS, Win 3.x/95/98/2000/XP/7, Win NT, Linux.

PROFESSIONAL EXPERIENCE

Confidential, New Brunswick, NJ

Sr. ETL Consultant

Responsibilities:

• Extensive use of PowerCenter tools like Informatica Designer/Workflow Manager/Monitor to generate iloads with HR data in flat files to support workday feeds
• Involved in extracting data from Oracle, SQL Server and excel files and loading it into workday
• Developed Functional specs, ETL technical specs, ETL execution plan, Test cases, Test scripts etc.
• Knowledge of various transformations.
• Extracted the data from Flat files (Delimited and fixed width) like CSV files or text files, XML files, Oracle 11g, SQL server, IBM mainframe, Sybase and load into Oracle data warehouse.
• Implemented Type 2 Slowly Changing Dimension (SCD) for accessing the full history of accounts and transaction information.
• Knowledge of connected and unconnected lookups
• Developed Error handling process incase Employee record has erroneous data when compared with reference data provided by HR.
• Created multiple sessions for all the existing mappings.
• Created the Workflows, Worklets and Sessions and also through pmcmd for loading the data using the logic from mappings.
• Scheduled Informatica Workflows/Sessions to execute on a timely basis and create backup for source files.
• Deployment of objects using Deployment groups and Export/import options.

Environment: Informatica 9.1, Oracle 11g, SQL Server 2008/12, Workday HR system, Flat Files.

Confidential, Marlborough, MA

Sr. Informatica Developer

Responsibilities:

• Provides Informatica ETL development and support for the Enterprise data warehouse.
• Involved and worked as main resource in migration from our input vendors WKH to IMS.
• Gathered requirements from business CDM(commercial Data Mgmt) and changed the functional spec to technical spec.
• Worked with Large Database and DW Implementation, worked on transactional data regarding the products.
• Implemented Slowly Changing Dimensions methodology to keep track of historical data.
• Using the sources loaded the landing tables, dimensions and then facts in WH.Using these created the Mart tables and using the mart tables build the logic to generate the reports used for Veeva.
• Works within an Oracle environment performing PL/SQL code development, building high performing Oracle queries, and tuning existing queries.
• Develops and maintains mappings within the Informatica ETL tool.
• Designing & documenting the functional specs and preparing the technical design.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets &Parameter files in Mapping Designer using both the Informatica PowerCenter.
• Creating Checklists for Coding, Testing and Release for a smooth, better &error free project flow
• Handling User Acceptance Test & System Integration Test apart from Unit Testing with the help of Quality Center as bug logging tool. Created & Documented Unit Test Plan (UTP) for the code.
• Ensureprojects are successfully completed according to agreed to terms for scope, cost, quality and schedule.
• Collaborate with architects, business analyst, quality assurance (testers) and production support.
• Develop and maintain best practices for application development.
• Development of new code that adheres to current system design and/or make recommendations on improvements to the design. Ensure code complies with coding standards.
• Modified the existing ETL (Informatica) jobs in order to get the report of each load taking place with the time and number of records that have loaded and extracted as well
• Documented all the development work in the format as per the requirement.
• Created functions, procedures and triggers in PL/SQL.

Environment: Oracle 11g /10g, PL/SQL, TOAD, Informatica Power Center 9.1.0/8.6,UNIX Qlikview, Micro strategy (used for extracts).

Confidential - VT

Sr. Informatica Developer

Responsibilities:

• Workedwith Business users to collect requirements and prepared ETL technical specifications.
• Coding in SQL qualifier transformation and Unit Testing, which improved the performance a lot.
• Worked on Informatica Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Extensively worked with triggers, store procs and cursors in PL/SQL.
• Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look-up Transformations.
• Created Mapplets using Mapplet Designer to reuse in different mappings. Used Workflow Manager and Monitor to Create and Monitor Workflows.
• Handled performance tuning by checking bottlenecks, also created partitions, SQL over ride in Source qualifier.
• Worked on different tasks in Workflows likeSessions,Event Raise,Event Wait,Decision,Email,Command,Worklets, Assignment,Timerand scheduling of the workflow.
• PerformedUnit,IntegrationandSystemtesting of Informatica Sessions, Batches and Target Data.
• Involved inUAT Testingand provided necessary reports to the business users.
• Code peer reviews and documenting test results.

Environment: Informatica Power Center 8.6/8.1, Oracle 10g/9i, Windows 2000&UNIX, Crystal Reports.

Confidential, Plano, TX

Sr. Informatica Developer

Responsibilities:

• Performed Business Analysis,Requirements gatheringand converted them intotechnicalspecifications.
• Developedmappingsusing Informatica Designer andWorkflowsusing Workflow Manager.
• DevelopedmappingsusingInformaticato load data from sources such asRelationaltables,Sequentialfilesinto the target.
• DevelopedETLproceduresto ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Extensively worked with transformationslikeLookup,Update Strategy, Expression,Filter,Router,Joiner,Aggregator, Source Qualifier and Normalizer Transformations.
• Extensively worked onSQL overrideinSource Qualifier Transformationfor achieving better performance.
• Developed Informaticamappings by understanding the existing PL/SQL scripts.
• HandledXMLfile data usingNormalizerTransformation.
• UsedPower Exchangeto extract data from Source.
• Useddebuggerto test the data flow between source and target and to fix the logical errors in the mappings.
• Worked on different tasks in Workflows likeSessions,Event Raise,Event Wait,Decision,E-mail,Command,Worklets, Assignment,Timerand scheduling of the workflow.
• PerformedUnit,IntegrationandSystemtesting of Informatica Sessions, Batches and Target Data.
• Involved inUAT Testingand provided necessary reports to the business users.
• Prepared technical specification documents for the development of Informatica Extraction
• Transformation and Loading (ETL) mappings to load data into various tables in Data warehouse and defining ETL standards.
• Associated with Production support team in various performances related issues.

Environment: Informatica Power Center 8.6.1, Informatica power exchange, Oracle 10g, PL/SQL, MS Access, Flat Files, SQL Server

Confidential

Jr. Informatica Developer

Responsibilities:

• Involved in gathering functional and technical requirements.
• Written ETL specifications for all the development tasks, to better evolve the ETL design.
• Worked extensively with Informatica tools such as Source Analyzer, Warehouse Builder, Mapplet Designer, Mapping Designer and Workflow Manager.
• Wrote stored PL/SQL procedures for certain Business Requirements.
• Updated Code (Tables, views, Mappings and Packages) in CVS Version control tool
• Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process.
• Works within an Oracle environment performing PL/SQL code development, building high performing Oracle queries, and tuning existing queries.
• Develops and maintains mappings within the Informatica ETL tool.
• Designing & documenting the functional specs and preparing the technical design.
• Developing several mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters
• Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica PowerCenter.
• Created sessions and workflows for designed mappings
• Performance Tuning of Sessions and Mappings.
• Demonstration to Client.
• Testing - Unit Testing& Integration Testing.
• Integrations with other applications
• Production Support.

Environment: Informatica Power center 8.x/7.x, Informatica power exchange, Oracle 10g, PL/SQL, MS Access, Flat Files, SQL Server