SUMMARY:

• 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for HealthCare, Pharmaceutical, Financial, Insurance and Telecom Sectors.
• Data Warehousing ETL experience of using Informatica and Database experience using Teradata V2R5/V2R6, Oracle 9i/8i/7i,DB2, MS SQL Server 6.5/7.0.2000 , MS Access 7.0/2000, Windows 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• Business Intelligence experience in OBIEE 10.1.3, Business Objects 6.0/5.1 (Web - Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), MS Access Reports.
• Expertise in using Teradata utilities BTEQ, MultiLoad, FastLoad, Tpump and FastExport.
• Experience in Data Modeling, Business Data Analysis and design of OLTP and OLAP systems.
• Expertise in writing Stored Procedures/Functions/Packages and Triggers in PL/SQL, T-SQL, Teradata SQL.
• Experience in creating Business Intelligence reports such as Dashboards, Scorecards using Business Objects, OBIEE.
• Experience creating control flow, data flow, error handling components in SQL Server Integration Services (SSIS).
• Experience in Data modeling using Erwin Tool (Erwin 4.0/3.5.)Star Schema/Snowflake Schema.
• Experience in Oracle SQL tuning and Oracle table partitioning and sub partitioning.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Experience in working with large data ware house systems of size more than 100TB.
• Experience fine tuning queries with spooling issues.
• Experience with UNIX shell scripting.
• Provided performance tuning and physical and logical database design support in projects for Teradata systems.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
• Worked closely with the team to review and develop XML data standards and reviewed data exchange or data sharing models.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Assisted the ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Team player with strong communication and interpersonal skills.

TECHNICAL SKILLS:

Date warehousing Tools: Informatica Power Center 9.6.1/9.1.0 , Informatica PowerExchange, Informatica Data Quality (IDQ), Informatica B2B Exchange, Informatica Power Mart, Informatica PowerConnect, Informatica Power Analyzer, SSIS

BI Tools: OBIEE 10.1.3, Business Objects 5.1/6.0.

Databases: Oracle 11g/10g, Teradata, MS SQL Server 2008/2005, DB2, Sybase 12.5.4, MS Access 2000

Programming Languages: SQL, PL/SQL, XML, HTML, UNIX Shell Scripts, Perl Scripting

RDBMS Load Tools: SQL Server Management Studio, SQL Loader, TOAD 9.1

Scheduling Tools: Cronjob, Autosys, Tidal

Operating Systems: Windows 98/2000/XP, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Data Warehouse Consultant

Responsibilities:

• Worked with the SME for requirements gathering, business analysis, testing, and metrics and project coordination.
• Performed extraction, transformation and loading of data Flat File sources using Informatica/BTEQ into Teradata DB in accordance with requirements and specifications.
• High Level and Low Level Design for ETL processes, design load processes, develop source to target mappings, define load schedule and dependencies.
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Used Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Implemented Slowly Changing Dimensions (SCD) for some of the tables as per user requirement.
• Worked closely monitoring/supporting the production jobs, resolving the failures, applying quick fixes and permanent fixes for frequent productions abend.
• Worked on permanent fixes in production with short timelines and implement them as part of planned monthly releases.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, and Tpump), Teradata parallel support and Unix Shell scripting.
• Applying technical knowledge using Teradata Tools (SQL Assistant) and using Teradata Utilities (BTEQ, Fast Load, MultiLoad) for development.
• Optimized database performance by deleting redundant indexes and creating missing indexes.
• Performance Tuning of BTEQ Scripts running long in Production.
• Optimized the Bteq scripts as part of performance tuning as recommended by DBA’s.
• Coordinating with source system owners, day-to-day ETL progress monitoring and maintenance of daily Informatica batch schedule run on a nightly basis.
• Involved in writing Technical Design Documents based on the Business needs.
• Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Written various Unit Test Cases to test the ETL code for both Positive & Negative scenarios.
• Involved in Tuning the Informatica mappings and workflows for optimal load performance.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Regular interaction with Managers, Onsite and Offshore team members to ensure the smooth running of applications.

Environment: Informatica Power Center Designer 9.6.1, Teradata 14, Oracle 11g, UNIX- SunOS, Work load Manager, IBM Clearcase.

Confidential, Trenton, NJ

Senior Data Analyst

Responsibilities:

• Worked closely with the Business Users to gather the requirements.
• Discussing business solutions with application stakeholders, resolving problems and improving the application stability.
• Responsible for converting functional requirement in to technical document.
• Experienced Informatica Power Exchange to extract the data from the Legacy Mainframe Source system to the Staging database.
• Interacting with client technical manager to gather both the business as well as technical requirements and transforming those inputs into computing model for execution of the projects.
• Worked with the Data Analyst in understanding the Business Rules and incorporating the rules while writing the Transformation Logic in the process of developing the Mapping Document.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center Designer created Mappings and Mapplets to transform the data according to the business rules.
• Created mappings in Informatica Developer (IDQ) using Parser, Standardizerand Address Validator Transformations.
• Have used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table.
• Worked on Informatica Data Quality to resolve customers address related issues.
• Created dictionaries using Informatica Data Quality that was used to cleanse and standardize data.
• Used Informatica B2B data exchange to handle Electronic Data Exchange.
• Implemented Slowly Changing Dimensions (SCD) for some of the tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing.
• Written various Unit Test Cases to test the ETL code for both Positive & Negative scenarios.
• Tuned the Informatica mappings and workflows for optimal load performance.
• Involved in Creating the High Level and Low Level Design Document using Microsoft Visio 2003.
• Support the system components during system testing, integration testing and during promotion of these components to production environment.
• Handling all the processes for Production implementation.
• Clarification for the queries raised by business users.
• Created reusable objects like Reusable Transformation and Mapplets.

Environment: Informatica Power Center Designer 9.1.0, Informatica Power Exchange 9.1.0, CDC, Informatica B2B Exchange, Informatica Data Quality 9.1, Oracle 11g, MS SQL Server 2005/2008, Microsoft Visio 2003, Unix- SunOS.

Confidential, Peapack, NJ

DatabaseEngineer

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, XML and Flat Files.
• Extensively used various Active and Passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Solid Expertise in using both Connected and Un-connectedLookup transformations.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Upgraded from Informatica8.6 to 9.1.
• Extensively worked with joiner functions like Inner join, Full Outer join, Master Outer join and Detail Outer join in the joiner transformation.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, and DD REJECT to Insert, delete, update and reject the items based on the requirement.
• Developed Re-usable Transformations, and Re-usable Mapplets.
• Worked with DB2 and SAP Sources.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Developed SCDMappings for Type 1 SCD and Type 2 SCD.
• Extensively worked on Creating UNIX scripts to run them using Cronjob scheduling tool.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Developed logical and physical data models that captured data flows using Erwin.
• Used pmcmd commands for interacting with Informatica, especially to invoke and run sessions.
• Analyzing test results and recommending modifications to the data warehouses to meet project specifications.
• Responsible for month-end data consistency checks and fixes using shell scripts and stored procedures. Also responsible for tuning stored procedures.

Environment: Informatica Power Center Designer 9.1.0, Oracle 9i /11g, DB2 7.2, MS SQL Server 2005, PL/SQL, TOAD 9.1, Unix- SunOS, SAP R/3, Unix Shell Scripting, Cronjob Scheduler, ERWIN Data Modeler r7.

Confidential, Birmingham, AL

Senior ETL Consultant

Responsibilities:

• Used Informatica Power Center Designer 8.5.1 to create source/target definitions, mappings and sessions to extract, transform and load data into data warehouses from various sources like relational databases (Sybase, DB2, Oracle), flat files.
• Worked extensively with mappings using expression, aggregator, filter, lookup, union, xml and stored procedure transformations.
• Worked with PL/SQL to write stored procedures, triggers and packages.
• Worked as administrator, involved in Informatica Power Center 8.6 installation and was responsible to assign privileges to the project members.
• Involved in Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS).
• Used Informatica Power Exchange to source copybook definition and then to row test the data from data files and Worked on Power Exchange for change data capture (CDC).
• Understanding existing SQL Code/Perl scripts/Unix scripts for replacing with mappings and creating Stored Procedures for various business needs.
• Involved in data migration from Informatica Power Center 8.5.1 to Informatica Power Center 9.0.
• Responsible for shell scripting in UNIX environment.
• Used OBIEE 10.1.3 to generate reports for the use of business analysts.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.

Environment: Informatica Power Center Designer 9.0/8.6/8.5.1 , Sybase 12.5.4, Oracle 10g/11g, DB2 8.5.1, TOAD, OBIEE 10.1.3, SQL Navigator5.5, Control M 6.2.01, PL/SQL, Rapid SQL 7.5.

Confidential

Data Consultant

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, and metrics and project coordination.
• Installed and Setup Informatica Client tools on client machines.
• Proficiently managed and created folders and users for ETL development using the Repository Manager module of the Informatica Power Center 7.1.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i RDBMS in accordance with requirements and specifications.
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.

Environment: Informatica Power Center 6.2.1/7.1/8.1 , Business Objects 6.5, Erwin4.5, Oracle 8i/9i, Windows NT, Flat files, SQL, PL/SQL. SQL Loader, UNIX (HP-UX, Sun Solaris, AIX), UNIX Shell Scripts.

Confidential

Oracle Developer

Responsibilities:

• Working as a technical support for a team that involved technical & quality reviews of program codes and PL/SQL blocks for optimization and maintaining standards & guidelines.
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Optimized database performance by deleting redundant indexes and creating missing indexes.

Environment: Windows NT Client/Server, HP-Unix, Oracle 7i/8i, Developer 2000, Forms 4.5, SQL, PL/SQL