SUMMARY

• Around 9 years of experience in IT with expertise in Design, Implementation & Maintenance of OLTP & Data Warehouse systems, Data & Technical Architecture, ETL processes, Business Intelligence and Enterprise Application Integration.
• 8+ years of Data Warehousing experience using Informatica Power Center 9.0/8.6/7x and Informatica Power Exchange 8.1.1.
• 2+ years of Business Intelligence experience using Cognos7.0x, OBIEE 10x, SAP AG Business Objects.
• 8+ years of experience using Oracle 10g/9i/8i/8.0/7.0, DB 2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0/6.0, Sybase 12.x/11.x, MS Access Erwin 4.5/4.0/3.5/3. x, SQL, XML, XSL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000, Win 3.x/95/98/2000, Win NT 4.0 and Sun Solaris 2.x.
• Expertise in software development, maintenance, testing and troubleshooting on Master Data Management (MDM), Metadata management, data quality, data integration and Oracle database environment, Informatica Administration, Repository Access, Integration Services.
• InformaticaB2B Data Exchange,Designing and developing B2B transformations for EDI and other formats using InformaticaB2B Data Transformer.
• Extensive knowledge with Teradata SQL Assistant,PUMP, Fast Export, Fast Load, Multiload, BTEQ, Coded complex scripts for the Teradata Utilities and finely tuned the queries to enhance performance.
• Expertise in Change Data Capture (CDC),ODS (real - time data), Meta Data Management (MDM), Incremental Extracts, Slowly Growing Targets.
• Experience in both integration and reporting areas of Data Warehouse using Informatica, Cognos, Business Objects, Teradata and Oracle.
• Expertise in tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power Center to identify bottlenecks, tune and remove bottlenecks.
• Developing several complex mappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files in Mapping Designer using both the InformaticaPowerCenter and IDQ.
• Expertise in developing ETL processes using Informatica, including ETL control tables, error logging, auditing, data quality, data conversion, etc
• Expertise in analyzing and understanding the business requirements and designing the applications based on it.
• Strong knowledge of Normal Forms, Star Schema and Snow Flake Schema.
• Expertise in Developing PL/SQL Packages, Stored Procedures, Functions and Triggers.
• Expertise in UNIX Shell and Perl Scripting.
• Expert-level mastery in designing and developing Complex Mappings to extract data from diverse sources including RDBMS Tables, Flat Files and Legacy System Files.
• Involved in Quality Assurance, bug fixing and testing. Prepared user manuals, presentations and trained user and operators.
• Strong documentation skill using Microsoft Word, Visio and Excel.
• Managed file transfer("MFT") refers to software or a service that manages the securetransferof data from one computer to another through a network (e.g., the Internet). MFT software is marketed to corporate enterprises as an alternative to using ad-hocfile transfersolutions, such as FTP, HTTP and others.
• Strong trouble-shooting, problem solving, analytical and design skills.
• Effective communication, professional attitude, strong work ethic and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x/7.x/6.x/5.x PowerCenter / PowerMart / PowerConnect, WorkFlow Manager, WorkFlow Monitor, Designer, Server Manager, Repository Manager, MDM Informatica,Informatica Power Center9.0.1w/ ILM

OLAP Tools: BusinessObjects XIR2/6.x/5i, Designer, Crystal Reports, Web intelligent, Supervisor, SAP R/3, Oracle Discoverer Administrator/Desktop, OBIEE, IBM Cognos.

Databases: Oracle 10g/9i/8i/7.3, MS-SQL Server 2000/7.0, DB2, Teradata, MS Access 97/2000.

Operating Systems: Windows NT 4.0/2000/XP/98/95, UNIX, OS/390, AS/400.

Languages: C, C++, UNIX Shell Scripts, J2EE, SQL, Transact-SQL, PL/SQL, COBOL, and Visual Basic 6.0/. Net, XML, Java Script and VB Script

Methodology: Ralph Kimball, Inmon

Web Tech: HTML/DHTML, JavaScript, JMS

GUI and Other: Oracle Designer, Reports, PLSQL, TOAD 8.x/7.x/6.x, SQL Loader, Erwin, Crystal Reports, PVCS VM and PVCS Tracker, Pervasive Data Integrator.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Informatica and OBIEE Developer

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively used Teradata utilities like Fast load, Multiloadto load data into target database.
• Extensively worked on Power Center Client Tools like Power center Designer, WorkflowManager, and Workflow Monitor, IDQ
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer..
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• To schedule the Informatica workflows we used DAC.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, dashboards, and star schema modeling.
• Created MUD (Multiple user Development) environment by utilizing projects in OBIEE.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Performed migration and merging of RPD’s in OBIEE.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.

Confidential, Columbus, OH

Sr.ETL/InformaticaDeveloper

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively used Teradata utilities like Fast load, Multiloadto load data into target database.
• Extensively worked on Power Center Client Tools like Power center Designer, WorkflowManager, and Workflow Monitor, IDQ
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer..
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Created Parameter files and validation scripts.
• Created used customMload Scripts from command task.
• Created Process Control and Metadata for informatica jobs.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Extensively worked with various systems like Oracle, Teradata, MS Access, Flat files, XML and Mainframe, SAP BW, SQL Server.
• Assisted with peer code reviews and testing of development team's T-SQL code.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.
• Provided production support for the Executive Management Information System (EMIS), a web reporting portal to informatica and teradata data sources
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document. responsible for developing data ingestion routines, creating standards and reusable code and performing InformaticaData Transformation (B2B) development
• Converting unstructured data into target database with B2B tool of Informatica.

Environment: Informatica Power Center 8.6, Oracle 11g, SAP BW Flat Files, Teradata 13, UNIX, Win XP, SQL * Plus, Transact-SQL, Control-M, Putty, BTE

Confidential, Sterling, VA

Sr Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Analyzed legacy data sources, prepared dataconversion approach.
• Design and implemented conversion environment standards and all supporting documentation.
• Involved in testing data mapping and dataconversionin a server based data warehouse
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Created, Tested and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Used the feature EXPLAIN PLAN to find out the bottlenecks in a given Query, thus improving the performance of the job.
• Involved in Unittesting, User Acceptance testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Involved in production and deployment phase to make sure the job schedules and dependencies are developed in such a way that we are not missing the SLA on a day to day basis.
• To analyze the specifications provided by the client, understanding the business.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Implemented Invoice level security in OBIEE depending on the user level access by integrating with EBS.
• Customized OBIEE Styles, Skins and Messages according to the client requirements
• Developed Customer Hierarchy to generate reports on the Region/Country/Time zone.

Environment: Informatica Power Center 8.6, Informatica ILM Archive,DataQuality(IDQ), Business Objects XI, Oracle 11i/10g, Sybase 12.5, SQL Server, XML Files, TOAD, SQL, PL/SQL, Windows XP, UNIX.

Confidential, Reston, VA

Informatica Consultant

Responsibilities:

• Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
• Interacted with Source system SME’s to analyze how various business processes have been tracked across the source tables.
• Designed Data warehouse target tables by using Dimensional Modeling Techniques - Star and Snowflake Schemas. Created Dimensions and Fact tables using Erwin.
• Extracted data from various data sources such as Oracle, Flat file, XML, DB2 and transformed and loaded into targets using Informatica.
• Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Designed and developed initial and incremental data loads using Informatica.
• Designed and Developed several mapplets and worklets for reusability.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Developed sessions using different types of partitioning techniques like round robin, hash key portioning for better performance.
• Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Created Shell scripts with PMCMD command and scheduled using Maestroscheduler for nightly batch processing.
• Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided Nightly batch loads support and implemented solutions to correct the data issues raised by end user during production support phase of the project.
• UseInformatica B2B data transformation software to extract data from unstructured data sources through PowerCenter Designer unstructured transformation

Environment: Informatica Power Center 8.1, Oracle SQL, Pl/SQL 10g, Toad, Unix Maestro, XML, Flat file, Erwin, AS 400 DB2, Windows XP, UNIX, Shell Scripting.

Confidential, Kansas City, KS

Informatica Developer

Responsibilities:

• Involved in developing mapping from the design documents.
• Worked on InformaticaPowerCenter 7.x tools like Source Analyzer, warehouse designer,
• Mapping Designer, Server Manager, Mapplets, and Reusable Transformations.
• Developed various Mappings, Mapplet and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Used various Transformations like Router, Filter, Joiner, Update Strategy and connected and unconnected lookups for better data messaging and to migrate clean and consistent data using the InformaticaPowerCenter Designer.
• Built Repositories using InformaticaPowerCenterRepository Manager to store Source, Target Transformations, Mapplet and Mappings metadata information
• ModifiedBTEQscripts to load data fromTeradataStaging area toTeradata data mart.
• Created ScriptsusingTeradatautilities(Fast load, Multi load, Fast export).
• Involved in creatingsecondary, join indexesfor efficient access of data based on the requirements.
• Extensively used Multi-Load and Fast-Load utility to populate the flat file data into the Teradata database Worked on performance tuning and optimization of the Sessions, Mappings, Sources and Target Worked with the Business Analysts for requirements gathering, business analysis and testing.
• Created Informatica mappings with PL/SQL procedures/Functions to build business rules to load the data.
• Unix Scripts were written at various situations like event automation and job scheduling.
• Captured the business requirements, worked on gap analysis, and prepared the gap analysis document.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, dashboards, and star schema modeling.
• Created MUD (Multiple user Development) environment by utilizing projects in OBIEE.
• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed the setting up, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Performed migration and merging of RPD’s in OBIEE.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• OBIEE 10.2.3.x/ 11.1.1, Oracle Business Intelligence Admin, Presentation and Publisher.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Oracle 10g, 11g, 9i and 8i, SQL Server 2000/ 2005, My SQL, MS Access
• Informatica, Data stage and Meta Data
• Siebel Analytics 7x (Web, Answer, Dashboards) and Hyperion Systemss
• SQL Developer, Data Warehouse Application Console
• HTML/ DHLTL/ XMS/ XML, UNIX Shell script
• Report to the senior OBIEE consultant with weekly and monthly project status report

Environment: InformaticaPowerCenter 7.x, SQL Server2005, HP-UX, Erwin 4.0, Teradata, Oracle 8i, WINDOWS XP, UNIX

Confidential

ETL/Oracle Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using stored procedures into the database. Involved in Logical and Physical modeling of the drugs database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL*Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Oracle 8i, SQL, PL/SQL, Windows 2000.