SUMMARY

• Over 8 years of experience in IT experience in ETL Design, Data warehousing and business intelligence using various ETL tools Informatica, SQL Server SSIS and Business Objects.
• Expertise in Informatica PowerCenter7.x/8.x/9.1Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Maple Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator transformation, Active andPassive transformations,Joiner and Update Strategy transformations.
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3, type 6.
• Extensively worked on developing and debugging Informatica mappings, applets, sessions and workflows.
• Experience in working with Mainframe files, COBOL files, XML, and Flat Files.
• Experience in using Perl scripts to move the file in server to local folders.
• Experience in Master Data Management approach, Added domains to created data model and worked on data services/data integration using the same industry leading platform
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.
• Experienced in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Implemented IDQ Maple in Power center Mappings with the Latest Informatica 9.0.1.
• Extensive experience working with MS Word, MS Excel, MS PowerPoint, IBM Lotus Notes.
• Experienced in writing, testing and implementation of Stored Procedures, Triggers, Functions and Packages at database level and form level using PL/SQL.
• Experience in Study, Design, Analysis, Development and Implementation of Data Warehousing Concepts.
• Designed on Object Oriented principles and developed the product using on SDLC and SCRUM, Agile Methodology, Iterative Development, TDD.
• Expertise in B2B standards, Implementation of Integrated EDI applications and Enterprise Application Integration (EAI) for business processes across applications.
• Experience in Reporting and analyzing Business Objects tool.
• Experience in BO Reporting, Design and Web Intelligence.
• Proficient working with Unix/Linux environments and writing UNIX shell scripts and worked with Autosys Workload automation server.
• Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Excellent knowledge of studying the data dependencies using Metadata stored in the Informatica Repository and preparing batches for the existing sessions to facilitate scheduling of multiple sessions.
• Experienced in design methodologies and worked on star and snow flake schemas.
• Experienced in tuning PL/SQL Procedures for better performance.
• Excellent analytical and problem solving skills.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work effectively as a team member as well as independently.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6/8.5/7.x/6.x/5.x, Informatica Power Exchange, Reporting Service, Metadata Manager.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling Fact and Dimensions Tables, Physical and Logical Data Modeling,Erwin 4.0/3.5.2/3. x.

Databases: Oracle 10g/9i/8i/8.0/7.0, DB2 8.0/7.0, MS SQL Server2000/05, Teradata, MS Access 7.0/97/2000.

GUI: TOAD, Visual studio 4.0

Programming: SQL, PL/SQL, Teradata SQL, HTML, DHTML, C, C++, XML, XSD, VISUAL STUDIO, UNIX Shell Scripting, Autosys Workload Automation Server.

Design Tools: Erwin 4.0/3.5, Oracle Designer / 2000.

Environment: UNIX AIX 5.2/5.3, Windows95/98/2000/XP/VISTA, WinNT 4.0, MSDOS.

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

ETL Developer

Responsibilities:

• Analyzed functional requirements and provided end-to-end ETL development in a BI Environment supporting royalty payments project.
• Designed and developed various ETL processes to support different projects in the EDW Framework.
• Worked with Informatica Data Quality 8.6.1 (IDQ) by performing analysis, data cleansing, Data matching, data conversion, exception handling and reporting.
• Implemented ETL process to load data related to Customer Logins from Oracle to Teradata EDW.
• Performed data migration and ETL from data sources like Excel, SQL Server, Flat files using SSIS packages.
• Created SSIS packages to transfer data between OLAP Databases with different types of control flow tasks and data flow transformations and with Informatica cloud files.
• Extensively used Mload and Fast Load utilities to execute the extract and load process.
• Used Informatica cloud data loader and automated the import and export of application data, database files and flat files.
• Written Teradata BTEQ scripts as part of UNIX Scripts and also wrote Teradata Stored Procedures instead of using Loader utilities like mload and fast load in order to reduce the Load on the Teradata Server whenever there was a teradata to teradata load.
• Worked with business analysts, and end users to define business rules and interpret data.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the Process of loading, pulling and pushing data from & to different servers.
• Involved in Designing and developing ETL mappings from varied transformation logics like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Integrated various data sources of Oracle, SQL server and sequential files into staging area.
• Error handling in ETL processes using SQL queries or transformations like Router and Lookup.
• Developed reusable transformations, Mapplets and Worklets to reduce development time.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Worklets.
• Created/Enhanced Teradata Stored Procedures to support production ETL jobs.
• Worked closely with reporting team supporting large database clusters running state-of-the-Art Vertical column store database.

Environment: ETL-Informatica - 9.5.1/9.1.1/8.6.0 Power Center, Teradata 13/V2R5/V2R4/14,Cognos, MS SQL Server 2008 R2, Flat Files, Toad for Oracle 9.1.0.62, Visio 2007, SharePoint, Red Hat Enterprise, UNIX SunOS 5.10, Tidal, SSIS, Crontab and Windows 2000/XP/7, Vertica 5.1.

Confidential, Virginia Beach, VA

ETL / Informatica Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Extracted data from different sources likeDB2, Sql server, flat files and loaded into DWH.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Wrote SQL, PL/SQL, stored proceduresfor implementing business rules and transformations.
• Used data miner to process raw data from flat files.
• Used the update strategy to effectively migrate data from source to target.
• Wrote SQL, PL/SQL, stored proceduresfor implementing business rules and transformations.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Used Informatica PowerCenter Workflow to create sessions and run the logic embedded in the mappings.
• Created test cases and completed unit, integration and system tests for Data warehouse.

Environment: Informatica power Center 8.1.1/7.x (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, DB2, SQL server 2005, SSIS, SQL, PL/SQL,Win 2000

Confidential, NY

Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Extensively used Informatica Power Center 8.1.1 to extract data from various sources and load in to staging database.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering.
• Used Power Exchange interface to get the data from mainframe files.
• Performed source data analysis .Primary data sources were from Oracle & SQL server 2005.
• Used batch process CDC (change data capture) mechanism in Power Exchange to get the recent data.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 10g) using Informatica Power Center 8.1.1
• Performed migration of mappings and workflows from Development to Test and to Production Servers.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Participated in all facets of the software development cycle including providing input on requirement specifications, high level design documents, and user’s guides.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Controlled version documents using CVS.
• Implemented Slowly Changing Dimension methodology for accessing the full history.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created Universe business objects and reports using drill down, slice and dice reports
• Involved in Unit testing and documentation.

Environment: Informatica 8.1.1, Power Exchange, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, SQL Server 2005,Business Objects XIR2, Windows NT, UNIX Shell Scripting.

Confidential, Parsippany, NJ

ETL/Informatica Developer

Responsibilities:

• Worked on Informatica Power Center tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
• Extracted, transformed data from various sources such as Oracle, Flat files, MS SQL Server, COBOL, and loaded into the target data warehouse Oracle.
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data.
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
• Assisted the team in configuration and administration of Informatica.
• Created Stored Procedure, Functions and Triggers as per the business requirements.
• Developed Shell Scripts and SQL Queries.
• Used SQL * Loader for bulk loading.
• Scheduled jobs using Control - M scheduler.
• Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading.

Environment: Informatica 8.1.1, Power Exchange, Oracle 10g, PL/SQL, Toad 9.4, ERWIN, SQL Server 2005,Business Objects XIR2, Windows NT, UNIX Shell Scripting.

Confidential

Data warehouse Consultant / Oracle Developer

Responsibilities:

• Design of the new database for the application.
• Installing the Oracle server, client.
• Allocating system storage and planning future storage requirements.
• Creating primary database storage structures (Table space) with appropriate placement of data files for maximum efficiency and performance.
• Creating primary objects (tables, views and indexes) as required by the application design.
• Modifying the Database structure as necessary.
• Controlling and monitoring user access to the Database.
• Monitoring and optimizing database performance.
• Planning for backup and recovery of database information.

Environment: Oracle 8i, Pl/SQL, Developer 2000, Shell Scripting, UNIX, Windows NT.

Confidential

PL/SQL Developer

Responsibilities:

• Created database objects like tables, views, synonyms, indexes, and sequences.
• Developed PL/SQL procedures and functions to migrate data between Oracle Databases.
• Extensive use of SQL Query, Joining tables, SQL functions in Queries, PL/SQL with the use of Cursors and loops.
• Loaded and unloaded data sets from or to Oracle Databases using TOAD.
• Worked on Performance tuning and optimization of SQL Statements using Explain Plan
• Experience in testing the module, creating test plans and technical design specification documents.

Environment: Oracle8i, PL/SQL, TOAD, Test Director.