SUMMARY

• Over 8+ years of total experience in Information Technology in development and design of ETL methodology for supporting data transformations and processing using Informatica.
• 2 years experienced in Business Objects
• Worked with different databases like Oracle, DB2, SQL Server 2000/2005/2008 , Teradata and ParAccel.
• Created ETL mappings using Informatica PowerMart/PowerCenter to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Very strong understanding of data ware housing, ETL architecture, project life cycle phases and processes.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large - scale data warehouses using Power Center and Power Exchange.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experienced in Installation, Configuration, Administration, & Support of Informatica Power Center on Client or Server environment.
• Experience in integration of various Operational Data Source (ODS) s with Multiple Relational Databases like Oracle, SQL Server, Teradata, ParAccel and DB2 and Worked on integrating data from flat files like fixed width and delimited.
• Experience on IBM Mainframe and SAP ABAP source systems.
• Experience in designing and developing the Universe and updating the existing Universes, developing canned/adhoc reports, scheduling the processes and administering activities using Business Objects
• Exposure to Business Objects XI Enterprise suite using Desktop Intelligence, CMC, Designer, Web Intelligence reporting.
• Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports.
• Strong knowledge on tuning performance issues while loading high volume of data and while generating reports.
• Worked in designing and implementing Data Mart and Data Warehouse applications using Erwin in Data modeling
• Worked with Teradata utilities like BTEQ, FastLoad, MultiLoad, Tpump, Fast Expert and Queryman.
• Experience to work with Oracle using SQL, PL/SQL, SQL*NET, SQL Loader, Server Manager and Import / Export Utilities.
• Experience in creating UNIX shell scripts for server monitoring, deployments, Synchronizing Source System to ETL Routines to automate the process and Experience with file transfer methods (FTP).
• Involved in identification of Facts, Measures, Dimensions and hierarchies for OLAP models.
• Experience in Performance tuning at sources, mappings and target level and tuning the SQL queries.
• Extensive experience in managing teams Onsite/Offshore coordination, Requirement Analysis, Code reviews, implementing standards, Production release management
• Responsible for interacting with business analysts and business users to identify reporting needs and business requirements
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.x/7.x/6.x, Power Exchange 9.1/8.x/7.x, Informatica Data Quality, Power Mart 5.x(Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformation Developer, Repository Manager, Workflow monitor)

BI Report Tool: SAP Business Objects XIR2/R3, Desktop Intelligence, DashboardWeb-Intelligence, Info View, Universe DesignerData Modeling Erwin 4.0/3.5, MS Visio, ER Diagrams.

Databases: Oracle 11g/10g/9i/8i, Sybase, DB2, MS SQL Server 2000/2005, Teradata 11/12,, ParAccel 4.0.2

DB Tools: Oracle SQL Developer, SQL*Loader, Toad

Operating Systems: Windows 98/2003/2000/ XP/7/NT, UNIX, MS-DOS, Linux AIX.

Scheduling Tools: Autosys,Tivoli and Control M

Languages: C, C++, SQL, PL/SQL, Shell Scripting, HTML, XML

Office Suite: MS Word, MS Power Point, MS Excel, MS Access

PROFESSIONAL EXPERIENCE

Confidential, Norwalk, CT

Informatica Developer

Responsibilities:

• Designed and developed ETL code to deal with Oracle, SQL Server and flat files.
• Generated ABAP program extract data from SAP ABAP systems to Oracle using file mode and stream mode in Informatica.
• Worked on developing Informatica code to meet complex business requirements.
• Worked directly with the end business users, analysts, SMEs, DBAs to correctly understand the requirements to deliver the end result before the actual due date.
• Unit tested the developed code to ensure correct and error-free execution of code in all environments.
• Created DDLs and used TOAD to create relational sources and targets, for use in Informatica.
• Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental.
• Migrating code from DEV to QA and validating code in QA before daily batch schedule.
• Extensively worked or shared sources, targets and reusable transformations.
• Responsibilities included designing and developing complex Informatica mappings including Type-I, Type-II slowly changing dimensions.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Created new Jobs, job streams and add dependencies to the existing job streams in Tivoli
• Defined Target Load Order Plan for loading data into Target Tables.
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions.
• Made changes to code and table models to accommodate new requirements and as and when required by the users.
• Used WinSCP to securely move files to/from various locations.
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner.
• Worked extensively on Source Analyzer, Mapping Designer, Target Designer, Workflow Manager and Workflow Monitor
• Performed extensive Unit Testing on the developed Mappings and was also involved in the documentation of Test Plans and testing with the users (UAT)

Environment: Informatica 9.1.0,Oracle 11g/10g,, SQL Server 2005, Flat Files, Toad, MS Visio, SQL Developer 3.0.04, PL/SQL, Erwin, Unix, Putty 0.62.0.0, Win SCP, SAP Netwaver 7300.1.3.1079 , Microsoft Outlook 2013, Microsoft SharePoint,Tivoli.

Confidential, McLean, VA

ETL/DWH Consultant

Responsibilities:

• Designed and developed ETL code to extract data from Flat Files, Oracle and DB2 sources and write to ParAccel target database.
• Worked on developing Informatica code to meet business requirements, including SCD Type 2.
• Worked directly with the end business users, analysts, SMEs, DBAs to correctly understand the requirements to deliver expected end result.
• Unit tested the developed code to ensure correct and error-free execution of code in all environments.
• Worked on Data Movement Control (DMC) to test the correctness of data read from source and loaded to target.
• Provided support to SIT and UAT users and testers. Helped them in deploying and executing code in respective environments. Also helped them in understanding code functionalities.
• Created general unit test cases for developers to use to check correctness of code.
• Used IBM Rational Clear Case to check-in code and files to move from one environment to another.
• Used WinSCP to securely move files to/from various locations.
• Helped other programmers with design, development, unit testing, and required documentation.
• Helped other programmers to correctly and efficiently design their mappings/programs.
• Used SharePoint to upload files and manage them.

Environment: Informatica 8.6.1/9.1.0 , Oracle 10g/11g, DB2 9.7.0.4, Sybase 15.5, Flat Files, ParAccel 4.0.2, RapidSQL 8.1.1, Oracle SQL Developer 1.5.5, IBM Lotus Notes 8.5.2, UNIX, PuTTY 0.62.0.0, Microsoft SharePoint, Win SCP 5.1.1, HP Application Lifecycle Management 11.00 (HP QC), IBM Rational Clear Case 7.1.2.

Confidential, NY

Sr. Informatica Developer

Responsibilities:

• Involved in the core modules of the project that includes Membership, Usage, and Royalty.
• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Involved in designing the process flow for extracting the data across various systems.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system Teradata by applying business logic on transformation mapping for inserting and updating records when loaded
• Worked withTeradata utilitiessuch asMload, Fast load, tpump, fast exportetc to load or extract tables.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS
• Implemented dimension model (logical and physical data modeling) in the existing architecture using Erwin.
• Designed data model structure and E-R modeling with all the related entities and relationship with each entities based on the rules provided by the business manager using Erwin.
• Used workflow manager for session management, database connection management and scheduled the jobs to run in the batch process.
• Developed Slowly Changing Dimensions for Type 2 SCD.
• Troubleshoot the issues by checking sessions and workflow logs.
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Involved in Design Universe by creating the Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the Objects like Dimensions, Details and Measures, which are grouped into Classes and Checked the Integrity of the Universes.
• Designed and created new report designs using Business Objects XI/R3.1 WebI and Desktop Intelligence as per changing user requirements
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Actively participated in database testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.

Environment: Informatica Power Center 9.1/8.6, Power Exchange 9.1/8.6, BO XI/R3.1, Oracle 11g, Teradata v12, SQL, PL/SQL, Shell Scripts, Export/Import, SQL Developer, TOAD, Autosys, Erwin.

Confidential, MN

Sr. ETL Developer

Responsibilities:

• Used Informatica 8.1.1 to extract, transform and load data from multiple input sources.
• Worked with Business Analyst to gather business requirements and Involved in weekly team meetings.
• Reviewed the business requirements and created internal and external design for Informatica jobs.
• Involved in transfer of data to Connects Promotion Manager.
• Worked with Connect3 support team to maintain the Informatica jobs and Data Analyzer.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files, SQL Server, Excel, DB2 and loading to Oracle target database.
• Extensively used various types of transformations such as Expression, Normalizer, Joiner, Update strategy, Lookup (Connected and Unconnected) to load the data.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Devised extensive PL/SQL Stored Procedures and Triggers to populate the base tables on daily basis and implementing business rules and transformations.
• Used the Power Exchange for Change Data capture (CDC) to capture the data fast without staging the data.
• Performed Mapping Optimizations to ensure maximum Efficiency.
• Involved in Optimizing and Performance tuning logic on targets, sources, mappings, and sessions to increase the efficiency of session and Scheduled Workflows using AutoSys.
• Extensively used the Teradata utilities like BTEQ, Fast load, Multi load, DDL and DML Commands (SQL).
• Implemented complex mapping such as Slowly Changing Dimensions (Type II) using Flag.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.

Environment: Informatica Power Center 8.1.1(Informatica Server, Informatica Repository Server, Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Power Exchange 8.1.1, BO XI/R3.1,Teradata 11, Erwin 4.1, Oracle 10g/9i, SQL Server, DB2,, PL/SQL,, AIX, Flat files, SQL*Loader, Business TOAD, Tivoli, UNIX .

Confidential, Germantown, MD

Informatica Developer

Responsibilities:

• Involved in understanding the business requirements and translate them to technical solutions.
• Worked for preparing design documents and interacted with the data modelers to understand the data model and design.
• Created new mappings and updating old mappings according to changes in Business logic.
• Involved in migrating project from UAT to Production.
• Setting up of the local Informatica environment on the client machines, which included the connectivity and access to the data sources, taking the necessary steps to set up the Relational Connectivity variables in the Workflow manager etc.
• Created XML targets based on various non-XML sources.
• Generated sequence numbers using Informatica logic without using the Sequence generator.
• Used SQL override to perform certain tasks essential for the business.
• Worked with flat file, xml file and SQL server tables as targets.
• Implemented Performance tuning in Mappings and Sources.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and modularity.
• Created and Modified PL/SQL, T-SQL stored procedures for data retrieval.
• Defined Target Load Order Plan for loading data into Target Tables.
• Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Unit testing of mappings and testing of various conditions.
• Developed Unix Shell scripts for customizing the delivery of Flat files to the customer.
• Involved in the documentation of the ETL process with information about the various mappings, the order of execution for them and the dependencies.

Environment: Informatica Power center 7.1.4, Toad, Oracle 9i, Erwin 4.0, SQL Plus, PL/SQL, UNIX, Windows 2003, SQL*Loader, Control M.

Confidential

ETL Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
• Cleanse the source data, Standardize the Vendors address, Extract and Transform data with business rules, and built Mapplets using Informatica Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Implemented slowly changing dimensions methodology and developed mappings to keep track of historical data.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Created universe and reports.
• Extensively involved in capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Involved in creating desktop intelligence and web intelligence reports.

Environment: Informatica Power Center 6.2, Oracle 9i, MS SQL Server 2005, UNIX, PL/SQL, UNIX shell scripting, SQL*PLUS, SQL, TOAD, Reports, MS Excel, MS Access.