SUMMARY:

• Around 6 years of experience in Business Requirements analysis, Data Analysis, Application Design, Dimensional Data Modeling, Designing, Coding, Development, Testing and implementation of business applications wif RDBMS, Data Warehouse/Data Mart, ETL, OLAP, Client/Server environment applications for Financial, Pharmacy and Insurance Verticals.
• Experience in data extraction, transformation and loading using Informatica PowerCenter 8.6/8.5/8.1.1/7.1.1/7.0 (Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplet Transformation), Informatica Power Exchange and Power Connect.
• Good experience in Dimensional Data Modeling, Star Schema/Snowflakes schema, Fact and Dimension tables, Physical & logical data modeling using Erwin 4.5 /4.x/ 3.0 and Visio.
• Extensive experience wif Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases. Worked on integrating data from flat files, CSV files, and XML files into a common reporting and analytical Data Model.
• Strong understanding of RDBMS concepts and experience in writing PL/SQL and SQL statements in databases.
• Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks
• Automation and scheduling of UNIX shell scripts and Informatica sessions and batches using Autosys.
• Written Test Scripts and Test cases for testing and enhancements which were used by QA for unit testing and integration testing.
• Good experience in using Oracle 10g/9i, DB2 8.0/7.0, MS SQL Server 2008/2005/2000, Teradata 12.0, TSQL, MS Access 7.0/2000, XML, PL/SQL (Functions, Procedures, Triggers and Cursors), SQL*Plus, SQL*Loader.
• Experience in integration of various data sources like Oracle, SQL server, VSAM and sequential files into staging area.
• Worked wif Oracle and SQL Server Stored Procedures, Index, Table Partitions and experienced in loading data into Data Warehouse/Data Marts using Informatica, SQL*Loader, Well Versed wif different tools for accessing Databases and development in databases like TOAD, PL/SQL Developer.
• Developed Slowly Changing Dimension Mappings of type I, II and type III (version, flag and time stamp).
• Used Incremental Aggregation to update teh values in flat table.
• Tuning of SQL Queries, Database leading to significant improvement in system response time and efficiency using Execution Plan and Trace File.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Good Exposure to Reporting tools such as Business Objects XIR3/XIR2.
• Strong Experience to TOAD & ODBC interfaces to Oracle.
• Strong noledge in ODBC Connections to Oracle database and expertise in connecting to SQL server using ADO.NET.
• Proficient in estimation and determination of teh level of effort required for teh implementation and integration testing.
• Excellent in communicating at all levels of management wif experience in coordinating various client meetings, seminars, presentations and group discussions.
• Good team player wif excellent trouble shooting skills.

TECHNICAL EXPERTISE:

ETL Tools: Informatica Power Center 8.6/8.5/8.1.1/7.1.1/7.0, Designer, Repository Manager, Repository Server, Workflow Manager & Workflow Monitor, Informatica Data Quality 8.5,Informatica Data Explorer 8.5,power Exchange8.6.1, Power Connect, Star Schema, Snowflake Schema, OLTP.

Reporting Tools: Business Objects XIR3/XIR2/6.0/5.1/4.1

Data Modeler: ERWIN 4.5/3.0, Visio, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Operating Systems: Windows 95/98/2000/XP/NT/Vista, Unix

Languages: C, SQL, PL/SQL

Databases: Oracle 10g/9i/8i/8.0/7.x,MS SQL Server 2008/2005/2000, SQL*Loader, SQL*Plus, IBM DB2 8.0, TOAD, Teradata 12.0.

Database Tools: SQL,SQL*plus, TOAD for Oracle 10.5, PL/SQL Developer

Packages: MS Office and Front Page 98/2000

FTP tool: Ipswitch WS FTP

Job Scheduling Tool: Job scheduling console 8.3 Fix pack 6

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Informatica Developer

Responsibilities:

• Participated in requirement meetings wif Business Analysts to understand analytical content needs. Assisted in documenting these requirements, resolving ambiguities and conflicts, and ensuring requirements are complete.
• Provided strategic thinking leadership pertaining to new ways of leveraging information to improve business processes.
• Worked wif end - users to halp identify issues and to refine requirements.
• Worked on various projects such as DMI, DW and EDW from scratch to production and supported in production as well.
• Developed detailed ETL specifications based on business requirements.
• Analyzed functional specifications and assist in designing potential technical solutions.
• Identified data sources and works wif source system developers and business owners to define data extraction methodologies.
• Worked wif Data Modeler / Data Warehouse Architect on logical and physical model designs.
• Worked wif Data Modeler to develop data warehouse models, design specifications, metadata process and documentation.
• Utilized teh ETL application and analyze data necessary to resolve issues uncovered and related to source data.
• Defined, developed, documented and maintained Informatica ETL mappings and scripts.
• Created and implemented Informatica work flows in Unix and Windows environments.
• Define, develop, documented and maintain procedural and SQL programs.
• Developed ETL test plans and tested teh ETL code following ETL standards and architecture.
• Actively participated in teh development, execution and documentation of system and integration test plans.
• Performed ETL / Informatica tuning as well as SQL tuning.
• Optimized Informatica code performance and processing methods.
• Performed design validation, reconciliation and error handling in teh load process (initial, incremental).
• Updated and maintained ETL Metadata.
• Provided input into standards and best practices for code development.
• Written technical specifications and updated release documentation to reflect technical modifications.
• Performed impact analysis for systems/database modifications.
• Assisted wif and promoted continuous quality improvement throughout teh lifecycle.
• Worked wif technical and architectural team members across teh technology organization
• Managed individual workload and deliver to agree upon project milestones
• Communicated status / risks to manager regarding delivering solution on timely manner.
• Utilized my skilled to manage database performance factors, monitoring tools and tuning procedures.
• Worked on various Business Applications such as: Billing & Rating, Activation & Provisioning, Inventory Management, Sales & Marketing, Campaign Management, Dealer Compensation/Sales Commission, CRM/Customer Service, Amdocs Ensemble (ABP/CRM/OMS), Portal Infranet.

Environment: Informatica Power Center 8.6, 9.1 and 9.5, Oracle 11g, Teradata, Microsoft SQL, PL/SQL, UNIX Shell Scripting, Business Objects, Power Exchange Cognos 8, Cognos Report net 1.0 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio), Business 2 Business Scripting, MS Visio. O/S & Network: IBM AIX, Sun Solaris, HP/UX.

Confidential, GA

Informatica Developer

Responsibilities:

• Performed data analysis on teh source data coming from point of sales systems (POS) and legacy systems.
• Involved in teh design phase/DATA MODELLING( logical and physical data model)using Erwin
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, filter.
• Involved in designing teh Workflows, Worklets, Mappings, Sessions and configuring teh Informatica Server using Informatica Power Center 8.6
• Experience in optimizing teh Mappings and implementing teh complex business rules by creating re-usable transformations, Mapplets.
• Extensive experience in full cycle implementation of Informatica.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier, joiner on data extracted according to teh business rules and technical specifications.
• Involved Migration activities from development and pre-production environments.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Load balancing of ETL processes, database performance tuning and Capacity monitoring.
• Worked wif teh MLOAD, TPUMP and FASTLOAD utilities of Teradata for faster loading and to improve teh performance.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Transformation Developer.
• Used UNIX to create Parameter files and for real time applications.
• Extensively involved in testing teh system from beginning to end to ensure teh quality of teh adjustments made to oblige teh source system up-gradation.
• Optimized SQL queries using hints and indexes.
• Performed scrubbing and cleaning of teh data.
• Performed Unit Test and Integration Test for teh ETL Processes.
• Integrated query reporting, iterative analysis and investigative workflow were provided to teh end users by using Business objects.
• Generated Reports using BO tool.
• Created sessions and workflows to run wif teh logic embedded in teh mappings using Power center Designer.
• Analyzed business process workflows and assisted in teh development of ETL procedures for moving data from source to target systems.
• Extensively developed Informatica mappings & tuned them for better performance.
• Used Business Objects free hand SQL to generate Adhoc reports.
• Responsible for weekly status updates showing teh progress of teh ETL process.
• Documented Process Flow for mappings and session.
• Improved session run times by partitioning teh sessions. Was also involved into database fine tuning (creating indexes, stored procedures, etc), partitioning oracle databases.
• Developed mappings in Informatica Designer tool to extract data from source system, transform and load to teh data warehouse.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions. This led to better session performance.
• Involved in monitoring teh workflows and optimizing teh load times.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Documenting teh entire process. Teh documents included teh ETL Design Document, Mapping document, unit testing document and system testing document.

Environment: Informatica PowerCenter8.6.1 (Source Analyzer, warehouse designer, Mapping Designer, Maplet Designer and Transformations), Teradata 12.0, Oracle 10g/9i, MS SQL Server 2008, TOAD, PL/SQL, Business Objects XI R3, Erwin 4.5,Windows XP, HP-UX.

Confidential, West Point, PA

ETL Developer

Responsibilities:

• Performed source data assessment and identified teh quality and consistency of teh source data.
• Involved in designing teh procedures for getting teh data from all systems to teh FPM Repository.
• Developed transformation logic and designed various Complex Mappings and Mapplets using teh Designer.
• Worked wif teh connected as well as d unconnected Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure and Joiner transformations in Mapping Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs to be run in teh batch process.
• Worked to Troubleshoot problems by checking sessions and workflow logs.
• Successfully performed performance tuning of ETL processes by considering mapping and session performance issues.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Involved in teh performance tuning process by identifying and optimizing source, target, and mapping and session bottlenecks.
• Successfully performed production support as needed.
• Communicated and discussed wif business users and support team in order to research and resolve issues.
• Responsible for documenting and resolving any production issues.
• Prepared teh Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for teh Maintenance and Operation of teh application.
• Involved in support and troubleshooting of production systems as required, optimizing performance, resolving production problems, and providing timely follow-up on problem reports.
• Extensively worked on understanding teh business requirements and designing Cognos applications.
• Created reports using Cognos and automated scripts to validate teh integrity of teh data based on end user needs.
• Enhanced report performance by refining joins, refining calculations at Report Level and Package level.
• Responsible for migrations of teh code from Development environment to QA and QA to Production.
• Used Cognos extensively for generating a Metric Dashboard showing a glimpse of various business metrics at an instance.

Environment: Informatica Power Center 8.6, Data Stage, Oracle 11g, SQL, PL/SQL, Toad 7.1/4.2,UNIX Shell Scripting, Power Exchange Cognos 8, Cognos Report net 1.0 (Frame Work Manager, Cognos Connection, Report Studio, Query Studio), Business 2 Business Scripting, MS Visio.

Confidential, NY

Informatica Consultant

Responsibilities:

• Worked closely wif teh business experts to understand teh source data in OLTP system.
• Designed Logical and Physical models for staging, transition and production using Erwin.
• Interviewed Subject Matter Experts, Business Managers to understand teh data in OLTP system.
• Designed Star Schema based on data model wif Dimensions and Facts.
• Created reusable mapplets, transformations and mappings using Informatica Designer.
• Optimizing Query Plan, Performance Tuning.
• Designed and developed complex mappings using various transformations in Designer to load data from Flat files, Cobol files in DB2 environment into teh target Oracle 9i data warehouse.
• Extensively used Stored Procedure, Functions and Triggers.
• Worked on performance tuning of teh complex transformation like SCD type 1 & 2.
• Tuned mappings to achieve faster data loads to teh data warehouse.
• Tuned Databases, Stored Procedures, Transformation, Mapping, Sessions and SQL queries to enhance Response Time.
• Created Unix Shell scripting for scheduling teh workflow
• Extensively used debugger to troubleshoot logical errors.

Environment: Informatica PowerCenter 8.5/8.1, Oracle 10g/9i, Erwin 4.1, MS SQL Server 2005/2008, DB2 7.0, Business Objects 6, windows XP, Unix, Erwin.

Confidential, San Francisco, CA

ETL DEVELOPER

Responsibilities:

• Designed and developed SQL and stored procedures/functions in Oracle 10g.
• Designed ETL architecture, data warehouse builder development guidelines and database standards document.
• Designed Integration of SOA Architecture, Data Architecture.
• Modified several of teh existing mappings and created several new mappings based on teh user requirement.
• Development and deployment of various Informatica mappings in runtime Environments.
• Testing teh codes, Workflows, Mappings in Informatica Power Centre.
• Deployment of various Projects according to business requirements.
• Making use of Star Team to keep teh versioning of teh codes.
• Testing teh Application under various Environment using tools like Mercury Quality Centre.
• Developing Perl scripts to handle teh Production jobs.
• Re-plat formed certain existing Assets from SQL Server 2005 to Informatica platform.
• Worked in Oracle 10g DB to re platform certain Assets to Informatica.
• Designing of Star Schema DW, OLAP Modeling.
• Experience wif loading 3NF and dimensional designs.
• Interface wif BI team to develop BI reports using SSRS and updating them in teh Dashboard.
• Define detailed data requirements for teh ETL development, Functional and Testing Teams based on teh business requirements.
• Experience wif Shell Scripting and UNIX Operating System Architecture.

Environment: Informatica v 7.0, Windows, Oracle, Pl/SQL, Perl, UNIX Shell Scripting, SSRS.

Confidential

System Analyst

Responsibilities:

• Worked on several data mart projects wif data warehouse architect, was involved in complete system development life cycle, starting from requirement specifications to delivering teh tested product.
• Designed and developed transformations based on business rules to generate comprehensive data using Oracle Warehouse Builder.
• Data Extraction, Transformation & Loading wif Oracle Warehouse Builder.
• Designed data warehouse and data marts from scratch and fine-tuned existing data warehouses.
• Extensively used all teh features of Oracle Warehouse Builder like Pivot, Unpivot, and Joiner etc.
• Worked extensively wif mappings using expressions, aggregators, filters, lookups, pre mapping and post mapping transformations.

Environment: Oracle Warehouse Builder 8i, Oracle 9i, PL/SQL, SQL*Plus, SQL*Loader, Erwin 3.0, Windows XP Professional.