SUMMARY

• Around 9 years of total IT experience in teh Data Warehousing and Database business systems for several domains.
• Strong experience in Data Warehousing and ETL using Informatica Power Center 9x/8.6/ 8.1/ 8.0/, Power exchange, Warehouse Designer with oracle and Sybase database as an Infa Administrator and senior developer.
• Strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Data modeling experience using Star Schema Modeling, Snowflake modeling, FACT and Dimensions tables, Physical and logical data modeling.
• Strong Business Intelligence experience using Business Objects 6.5/ 6.0/ 5.1/ 5.0 , Cognos Series 7.0, Data Reports, Seagate Crystal Reports 6.x/5.x/4.x/3.x, OBIEE, Developer 2000, MS Access Reports
• Strong Database experience on Oracle 11i/10g/ 9i, Sybase, DB2, MS SQL Server 2000/ 7.0/ 6.5 , MS Access 7.0/ 2000, SQL, PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Sun Solaris 2.x, Confidential Informix db.
• Proven skill in leading teh team from offshore as well as from onsite.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experienced in Performing Unit testing, system testing, regression testing, smoke testing and system integration testing.
• Experience includes thorough domain knowledge of Business Financial system, Banking, Healthcare information technology and Insurance Industry.
• Has excellent written and oral communication skills with teh ability to communicate appropriately in business and technical situations at all levels.

TECHNICAL SKILLS

Data Warehousing concepts & tools: Data mart, OLAP, OLTP, ETL, ELT Transformations, Autosys Scheduling Tool

ETL Tools: Informatica Power Center, Power exchange 9x/ 8.6.1/8.5.1/8.1.1/8.0 , Informatica Designer, Workflow Manager, Workflow Monitor, SQL*Plus, SQL*Loader, TOAD

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Oracle Designer, Visio and Sybase Power Designer

BI Reporting Tools: Business Objects 6.5/ 6.0/ 5.1/ 5.0 (Web - Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Cognos Series 8.4/8.1/7.0/6.0 , OBIEE 10.3.1.x, Developer 2000 (Forms 4.5/5.0, Reports 2.5/ 3.0), MS Access Reports

Databases: Oracle 11i/10g/ 9i/ 8i/ 8.0, Confidential DB2 UDB 9.5/ 8.2/ 7.0, MS SQL Server 2005/ 2000/ 7.0/ 6.0 , Sybase 12.x/ 11.x, MS Access, Informix db

Programming GUI: SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, Informix.4gl, Powerbuilder 9.0, Visual Basic.Net 6.0/ 5.0, Java, J2EE, HTML, DHTML, C, C++, Unix Shell Scripting Programming

Operating system: Sun Solaris 2.6/ 2.7/ 2.8/ 8.0 , HP-UX 10.20/ 9.0, Confidential AIX 4.2/ 4.3, MS DOS 6.22, Novell NetWare 4.11/ 3.61, Win 3.x/ 95/ 98, Win NT, Red Hat Linux, Sun-Ultra, Sun-Spark, SCO Unix, Win 2000, Win XP

PROFESSIONAL EXPERIENCE:

Confidential, OH

Sr DTW & Informatica Developer

Responsibilities:

• Performed setup and configureInformaticadomains, services (repository, Integration, Metadata manager, Data Analyzer, Data Integration, Model Repository etc).
• Coordinated with various teams (DBA/UNIX/Support) to handle teh Informaticaserver related issues, outages and maintenance activities.
• Maintain ownership of release activities interacting with ETL projects.
• Worked with teh business to cleanse teh source data for Human Resources objects to help better cleanse data that can be loaded on target Oracle database.
• Worked in Confidential and Finance system and converted various complex objects on Organizational Structure, Addresses, Time, Basic Pay, Bank Details, Communications, Recurring Payments, Tax assignment, Insurance Plans, Payroll etc.
• Worked on de-dup process to cleanse teh corporate data for payroll and controlling objects to help better cleanse data that can be loaded on tables.
• Leading 4 member’s team and assisting teh team in understanding teh requirements and technical assistance when and where required.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in teh central oracle database
• Used Informatica Power Center 9x for extraction, transformation and load (ETL) of data in teh data warehouse
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure.
• Setup and configureInformaticadomains, services (repository, Integration, Metadata manager, Data Analyzer, Data Integration, Model Repository etc).
• Coordinated with various teams (DBA/UNIX/Support) to handle teh Informatica server related issues, outages and maintenance activities
• Worked closely with implementation partners TCS, IGATE and teh client GE.
• Developed complex mappings in Informatica to load teh data from various sources
• Extensively used Informatica debugger to figure out teh problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Extensively used Toad for SQL scripts and worked on SQL for enhancing teh performance of teh conversion mapping.
• Used teh PL/SQL Procedures for Informatica mappings for truncating teh data in target tables at run time.
• Designed teh custom error control logic with in teh pipeline to capture and load teh bad records to a control table, and recover teh workflow in teh event of failures.
• Worked closely with PST load team for Data load into HR tables (Direct Load Method)
• Knowledge on HR load program and was working with creating batch sessions to run teh objects in different environments.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with teh logic embedded in teh mappings.
• Created procedures to truncate data in teh target before teh session
• Created deployment groups, migrated teh code into different MOCK environments
• Written documentation to describe program development, logic, coding, testing, changes and corrections
• Followed Informatica recommendations, methodologies and best practices.
• Achieved 100% conversion rate for all teh objects for HR for all teh Mock conversion levels.
• Instantaneously attended teh defects and provided solutions in quick turnaround time.
• Once teh application is gone live, created teh Reconciliation reports to make sure that teh necessary data is loaded into HR tables without fail.
• Created Dashboards to present teh reconciliation data to teh Human Resources director and other resources of teh client.
• Created a list of teh inconsistencies in teh data load on teh client side so as to review and correct teh issues on their side.
• Provided support during various phases of project and plan teh E&T process.
• Was involved in production support to make sure all issues are fixed in teh respective turn-around times.

Environment: Informatica Power Center 9x, Oracle 10g/ 9i, MS-SQL Server, AS400, Toad, HP Quality Center, Tidal, and MS Office Suite, Putty, Winscp, GE Support central.

Confidential, Cincinnati, OH

Sr. Informatica Developer/Admin

Responsibilities:

• Coordinating with various teams (DBA/UNIX/Support) to handle theInformaticaserver related issues, outages and maintenance activities.
• Updating patches and resolving issues.
• Responsible for Installation and configuration ofInformaticaPower Center in Grid and High availability environment on UNIX (AIX,Solaris).
• Source date is received from ERP application as XML data and loaded into teh target Oracle db.
• Involved in requirement Gathering and analysis of source data as data comes in from different Source systems.
• Leading team members and assisting teh team in understanding teh requirements and technical assistance when and where required.
• Involved in eight releases to successfully lead teh deployment process.
• Record Count Verification DWH backend/Reporting queries against source and target as an initial check.
• Validation after isolating teh driving sources.
• Data integrity between teh various source tables and relationships.
• Check for missing data, negatives and consistency. Field-by-Field data verification can be done to check teh consistency of source and target data.
• Development of ETL using Informatica 8.6.
• Applied slowly changing dimensions like Type 1,2,3 effectively to handle teh delta Loads
• Worked extensively on PL/SQL as part of teh process to develop several scripts to handle different scenarios.
• Prepared various mappings to load teh data into different stages like Landing, Staging and Target tables.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing teh Mapping.
• Tuned teh performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing teh run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned teh tables in Oracle for optimal performance.
• Prepared teh error-handling document to maintain teh Error handling process.
• Created Test cases for teh mappings developed and then created integration Testing Document.
• Involved in teh Defect analysis call for UAT environment along with users to understand teh data and to make any modifications if suggested by teh user.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored teh results using workflow monitor.
• Developed reconciliation scripts to validate teh data loaded in teh tables as part of unit testing.
• Prepared SQL Queries to validate teh data in both source and target databases.
• Prepared scripts to email teh records that do not satisfy teh business rules (Error Records) to teh uploaded business users.
• Prepared teh UNIX Shell Scripts to process teh file uploads, one of teh SOURCE for teh data that process teh uploads into different stages (Landing, Staging and Target tables)
• Extensively worked on teh AS400 scheduling tool.
• Prepared code for teh new workflows that are created as a part of business requirements.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Involved in teh Repository administration like Backup and restoration process when required.
• Supported teh applications in Production on rotation basis and provided solutions for failed jobs.
• Actively attended teh production support calls and Pagers at all times and answered teh business questions.
• Prepared Game Plans for teh Deployment of Informatica Code.
• Prepared Change Request's, Work Order's, Problem Ticket's, and Work Request are for teh deployment process.
• Prepared teh recovery process in case of workflow failure due to Database issues or Network issues.
• Involved in teh network analysis of workflows that see less through put.

Environment: Informatica Power Center 8.6.1, Windows XP, Oracle 10g/ 9i, SQL*Loader, SQL Navigator, SQL, PL/SQL, Unix Shell scripting, SQL Server 2005/2000, WIN SCP, Toad, MS-Office Tools, Tables and Flat Files

Confidential, Schaumburg, IL

Informatica Developer

Responsibilities:

• Implement procedures to maintain, monitor, backup and recover operations for ETL environment.
• Conduct ETL optimization, troubleshooting and debugging.
• Maintain ownership of release activities interacting with ETL projects.
• Create and maintain data models working with teh Data Architect.
• Created mapping documents for data mart deliverables.
• Involved in using Framework Manager to build models, packages and publish packages to teh ReportNet Server
• Attended business meeting with teh end clients and vendor's to analyze teh scope of teh project developement and teh project life cycle from end to end process.
• Created teh Data flow Diagrams for teh full run and teh reprocess partial run for teh workflows to be created in Informatica taking into point teh dependencies using Microsoft Visio.
• Maintained mapping documents throughout development lifecycle.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Developed mapping to load teh data in slowly changing dimension. Teh unconnected store procedure for look up on target table. Used Router, Normalizer, Aggregator, Expression, lookup, update strategy, router, and rank transformation.
• Wrote UNIX shell scripts for Informatica ETL tool to run teh Sessions.
• Extensively migrated teh Informatica code from teh version 7.1.4 to 8.1.1 and did testing to maintain its results.
• Worked on Dimensional modelling to design and develop STAR schemas using ER-win 4.0, Identifying Fact and Dimension Tables.
• Created teh Data flow Diagrams for teh full run and teh reprocess partial run for teh workflows to be created in Informatica taking into point teh dependencies using Microsoft Visio.
• Analyzed data relationships graphically and changed displays using Cognos PowerPlay functionality by means of drill down, slice and dice, rank, sort, forecast, and nest information to gain greater insight into trends, causes, and effects.
• Loaded consolidated data using SQL*Loader in parallel and direct mode.
• Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.
• Implemented best practices in ETL Design and development and ability to load data into highly normalized tables and star schemas.
• Identified all teh confirmed dimensions to be included in teh target warehouse design and confirmed teh granularity of teh facts in teh fact tables.
• Translates business and technical requirements into application modules Contributes significantly to teh development of information models. Scheduled walkthroughs of mapping documents, specifications, code, etc. as appropriate throughout project lifecycle.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Involved in creation of Informatica users and repository backup using Server Manager.
• Generated reports for end client using various Query tools like Cognos.
• Developed Cross tab reports, graphical reports, list reports using teh report studio in teh Cognos 8, including blank report for teh new look of teh Invoice involving different filters, prompts.

Environment: Informatica Power Center 8.1.1/ 8.1/ 7.1/ 6.2 , PowerBuilder 9.0, Oracle 10g,Sybase 10.5, Oracle SQL Developer, Cognos 8, Quest-Toad, Siebel, Shell Scripts, SQL*Loader, UNIX ( Confidential -- AIX, Solaris), DB2 UDB, and Windows 2000.

Confidential, Schaumburg IL

Oracle/Informix Developer

Responsibilities:

• Business Analysis and Requirements Gathering.
• Designed and developed SQL Stored Procedures.
• Used Informix.4gl programs to generate various forms to users.
• Developed Oracle forms screens for entering teh customer data.
• Designed and developed UNIX shell scripts and Crontabs to automate.
• Extensively worked on SQL*LOADER, import and export utilities.
• Scheduling jobs and to keep track of teh jobs and bug fixes.

Environment: Informix.4gl, Unix shell scripting, Informix db, MS office, Informix database, SQL, PL/SQL, Sun Solaris, and Windows NT.