Objective: To be able to provide innovative Business Intelligence solutions in various decision support environments. Lead projects to a success

Summary:

• Over 15 years of IT industry experience
• 10 Years of hands on experience in developing ETL process using Informatica-
• Strong working experience in building and managing various data warehousing/data marts using Informatica products such as PowerCenter, PowerAnalyzer,
• Strong working experience in Large Data warehouse environments
• Strong technical hands on experience in Oracle 10g/11g databases
• Providing ETL solutions for various business units as per the requirements
• Excellent working knowledge with BI reporting tools using Business Objects, Cognos
• Excellent analytical, problem solving, communication and interpersonal skills, with an ability to interact with individuals at all levels.
• Participated in full Software Development Life Cycle SDLC of the data warehousing project project planning, business requirement analysis, data analysis, logical and physical database design, setting up the warehouse physical schema and architecture, developing reports, security and deploying to end users.
• Strong logic and analytical skills and Solid business acumen.
• Extensive work exposure in Unix Korn Shell scripting
• Effective troubleshooting skills.
• Ability to manage time spent on multiple projects to meet deadlines.
• Proficient in Oracle PL/SQL programming, writing Stored Procedures, Functions, Database Triggers etc

Technical Expertise:

• Informatica: PowerCenter 9.5/8.6 PowerConnect tools for SAP, Mainframes, PowerAnalyzer, Metadata Exchange for Data models.
• RDBMS: ORACLE 10g/11g, DB2, SQL SERVER 2000/7.0/6.5, Sybase,
• Business Intelligence: Business Objects, Cognos
• Other Tools/Methodologies: Data modeling, Star Schema, Snowflake Schema,
• O/S: UNIX HPUX, IBM AIX, Sun Solaris , Windows 2003/XP/2000/NT, Scripting
• Scheduling Tool: TWS, Autosys, Cron

Project Management Experience:

• Involved in working with teams at onsite/offshore model
• Managing teams at onsite and offshore
• Resource, Schedule and budgetary planning
• Coordinating with the Functional/Business owners and IT Managers for defining the project lifecycle deadlines and ensuring the consistency in delivery
• Building an effective team by working with the marketing/recruitment teams and getting the best resources available in the market
• Supporting the organization in the presales department, by working with new clients for business improvement in the BI sector.

Work History:

Confidential

ETL Architect

Responsibilities:

• Re-design an existing DWH environment
• Design reusable ETL components to be used by the development team
• Optimize/ Performance Tune the ETL processes developed in Informatica /SQL
• Design Autosys Job for nightly batch
• Sprint planning work with the product owner in creating stories for each sprint
• Develop ETL process for external integrations.

Confidential

OBIEE ETL Lead/Architect

Responsibilities:

• Design the CRM Integrations for loading the Customer Information into the CRM system from various vendors.
• Support the OBIEE environment and design the physical and logical models for Siebel Analytics.
• Design/Develop Data Marts and ETL process for the Hyundai Motors Group
• Work with Business Analysts to understand business requirements and convert then to technical specs and work on developing the ETL process
• Design ETL processes for the MDM implementation at Hyundai Capital
• Infrastructure redesign for ETL related environments
• Develop integration between legacy systems and Siebel CRM system

Environment: Informatica 9.5.1/8.6, Oracle 9i/10g, Linux Red Hat,Solaris, Windows batch script, Unix Shell Scripts, OBIEE, DAC

Confidential

DWH ETL Consultant

Responsibilities:

• Work with Business Analysts to understand business requirements and convert then to technical specs and work on developing the ETL process
• Part of Data modeling team, which design the new models based on the new requirements. Exposure to Snowflake and star schema models
• Used Autosys for scheduling jobs
• Design an Proceses for data Integration/Migration. This is being done as one of the projects is moving from Siebel to SalesForce.Com
• Work in SCRUM/AGILE environment for the salesforce.com project
• Work with existing Siebel CRM team and understand the functionality, design and develop ETL process for one time migrations and ongoing integrations from/into SalesForce.com from various applications.
• Work with salesforce data loader utility

Confidential

Informatica/OBIEE Architect

Responsibilities:

• Design the ETL processes for loading the Siebel base tables from 2 legacy source systems
• Configure the OBIEE environment and design the physical and logical models for Siebel Analytics.
• Trouble shoot the analytics reports
• Work with Business Analysts to understand business requirements and convert then to technical specs and work on developing the ETL process

Confidential

Informatica Consultant

Responsibilities:

• Set up the Informatica Environment in a new data center
• Install Informatica 8.6 AE PowerCenter, Data Analyzer and Metadata Manager
• Setup a 3 tier environment
• Working with Linux Shell Scripts, needed to automate the weekly maintenance schedule
• Document the data flow within the Organization.
• Design a generic ETL framework for a data migration/integration.
• Develop ETL mappings to create extracts required by external client to Tickets.com
• Work with Business Analysts to understand business requirements and convert then to technical specs and work on developing the ETL process
• Convert existing Sagent ETL process to Informatica ETL Processes.

Environment: Informatica 8.11/8.6, Oracle 9i/10g, Linux Red Hat, MKS version control, Shell Scripts

Confidential

Sr. Informatica Administrator

Responsibilities:

• Analyzed the different source system data to be use in building the datamart and gathering functional requirements from the Business Analysts and designing the ETL framework and getting it approved
• Designing/developing ETL processes for various DM on the EDW
• Assign the ETL designs to the offshore team and track the process and report to the management,
• Extensive usage of powercenter tools/transformation in the development process of ETL both 7.14 on AIX and 8.6 on Linux Red Hat for various Data Marts
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems
• Working on upgrading powercenter from version 7.14 to 8.6.

Environment: Informatica 7.1.4/8.6 ,Oracle 9i/10 g , IBM AIX, Linux Red Hat, IBM Mainframe , MKS version control, TWS Scheduler /Autosys,SQL Server 2000, TWS Scheduler, Shell Scripts

Confidential

Technical Architect

Responsibilities:

• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Analyze existing oracle procedures, functions, packages and design informatica mappings.
• Provide solutions for data migration projects
• Design ETL framework for Data migration projects
• Capacity planning on these environments
• Maintain all necessary updates and/or patches for the ETL environment.
• Code/folder migration from one environment to another as part of release management
• Develop utilities using Informatica command line utilities

Environment: Informatica 7.1.4, Oracle 9i, Sybase, HP-UX, Autosys Scheduler , SQL Server 2000

Confidential

Senior Informatica ETL Architect/Administrator

Responsibilities:

• Worked as Sr. Informatica 7.1.4 Administrator for ODS/EDW, CDW and ICRS Integrated credit Information system
• 24 7 Production Primary support for ODS/EDW and CDW/ICRS and Production Parallel Environment
• Capacity planning on these environments
• Setting up standard for the developers to follow the Procedures, naming conventions, standards and Regulations.
• Informatica migration on Development, Test and Production environment.
• Involved in the Informatica7.1.4 installation on AIX environment and applied patches.
• Created meta- data repository queries to know the Workflow status, Error finding and to know the statistics.
• Wrote UNIX shell scripts and Awk programs for file manipulation
• Shell Scripting to Automate OS Backup through Cron in AIX / Configuring production job scheduling, maintenance and alert system.
• Automate and manage repository administration tasks using shell scripts.
• Training and pair programming to get the teams up to the speed.
• Provided various suggestions for best practices for the development, and improving the performance and tuning of current slowly running jobs.

Environment: Informatica 7.1.4 ,Oracle 9i , IBM AIX,IBM Mainframe, MKS version control, TWS Scheduler ,SQL Server 2000, TWS Scheduler, Shell Scripts

Confidential

Informatica Architect/Technical Lead

Responsibilities:

• Gather Functional requirement from the various source system owners
• Manage projects for onsite/offshore models
• Responsible for developing development standards, common re-useable Informatica mapping templates, migration procedures, error handling process design and implementation.
• Responsible for developing best practices for Informatica server installations, administration and maintenance, high availability HA and disaster recovery DR .
• Also involved with checking the server resource utilization and providing recommendations for faster performance.
• Work with IT teams of the respective source systems to get the legacy data/interfaces extracts created.
• Design a generic Informatica process to read various source systems data and load to SAP clients
• The data resides in various platforms like oracle, Sybase, DB2, and VSAM etc.
• The current scope of the project is to load the SAP R/3 tables and SAP BW.

Environment: Informatica PowerCenter 7.1.4/6.2.1/6.1/5.1, Business Objects, Informatica ,PowerAnalyzer, ER Win, Oracle 9.x/8.x, DB2, , PL/SQL, UNIX Shell Scripting, PVCS, MS SQL Server 2000, IBM AIX

Confidential

Informatica Power Center 6.1 Administration

Responsibilities:

• Worked on Informatica PowerCenter upgrade, implement server grid manually and performance tuning of the server as well as various maps and sessions.
• Extensively worked on planning and upgrading all their Informatica servers from 6.x to Informatica 7.1.4.
• Worked on performance tuning of various slowly running jobs.
• Worked on designing the server architecture and implementation of PowerAnalyzer installations and configurations.
• Configuration of Informatica Server
• Automate application install, uninstall and application enhancements through shell scripts
• Programs created using Unix shell scripts for system management and monitoring.
• Implemented and Managed Secure file transfer and secure shell based server access
• Writing Shell scripts Ksh for generating reports and automating tasks
• Develop and automate a number of ETL processes which involves developing Unix shell script, NT batch scripting

Environment: Informatica PowerCenter 7.1.2/7.1.1/6.2.1, Oracle applications, PowerAnalyzer, Erwin, Oracle 10g/9.x/8.x, PL/SQL, , UNIX Shell Scripting, MS SQL Server 2000, SUN Solaris, Unix/Solaris, Citrix ICA client, DB2 Connect, Sybase

Confidential

Informatica/ETL Developer

• Confidential is engaged in the Reinsurance business and is affiliated to Confidential.
• Development and loading of the Confidential. The data comes from different Confidential systems like Confidential database or in the form of Excel sheets. These are loaded into in Oracle Data Marts.

Responsibilities:

• Responsible for analyzing the existing system to re-engineer their reporting applications.
• Responsible for complete design of the architecture for re-engineering and developing whole new application with a separate stage, ODS and a Datamarts.
• Business Objects is the business intelligence tool used for reporting.
• Shell scripts for automated installations and extracting logs
• Development of Informatica mappings/sessions to load the data in Life Data Mart.
• Providing support to the Life Data Mart design team.
• Developing Unix Shell scripts for automating the loads, by scheduling the sessions using Unix shell scripts and tuning the mappings/sessions to get the maximum output from them.

Environment: Informatica PowerCenter 7.1.1/6.2.1/6.1/5.1, Business Objects, Cognos, Informatica Metadata Reporter PowerAnalyzer, Erwin, Oracle 9.x/8.x, PL/SQL, UNIX Shell Scripting, PVCS, Cron, Auotsys, MS SQL Server 2000, HP UX, Sun Solaris,

Confidential

BO Universe Design

Responsibilities:

• Worked extensively on databases such as Oracle Metadata during the ETL processes development
• Extensive involvement in the design aspects and involved in developing various prototypes and testing them thoroughly.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, known as 'Mapplets' using Informatica PowerCenter Designer.
• Databases include Oracle 8i, SQL Server, Access, Excel, flat files etc.
• To analyze the Informatica Meta Data exchange views MX views in Oracle 8.0.
• To develop/design the universe on MX views to develop reports on Meta Data created by Informatica in the Repository.

Environment: Informatica PowerCenter 4.7/5.1, Oracle 8i, Teradata, , Oracle Financials, Shell Scripting, PL/SQL Programming, Sybase 11.2.9, Business Objects, Cognos, ER Win 4.5, Windows NT, IBM AIX

Confidential

This project was an analysis project. It involved identifying and documenting the entire process flow of data coming into the warehouse from various legacy and transaction systems.

Responsibilities:

• Trace the jobs to final tables used in the data warehouse. This includes the datasets used on the mainframe, which were used as a source for the data extracts feeding the data warehouse. This was to be done in a graphical format using flowcharts .
• Describe the calculations done on various columns to arrive at the final values used in the data warehouse. This was done in a flowchart as well as pseudo code.
• Create a document describing the process flows of the jobs. This would be in a flowchart. It would differ from the job trace in that it would contain the processing logic carried out if any by the job on each data set before it reaches the final ORACLE tables. This would also contain the logic used to enrich the columns of the tables.

Environment: ORACLE 7.3, UNIX, COBOL, PL/SQL and EASYTRIEVE

Confidential

Claims Automated System

This project involved re-engineering of the existing Death Claims and Matured Endowments applications on the mainframe onto a Client / Server environment with new enhancements.

Responsibilities:

• Design of the target database in Oracle, based on the existing COBOL file layouts
• Analyzing the existing system
• Generating program specification and flowcharts
• Prototyping and developing various forms and report modules for the system.

Environment: COBOL, CICS, EASYTRIEVE, CP01 Infront , MVS JCL,VSAM , ORACLE 7.3, Developer 2000 Forms 4.5,Reports 2.5 , PLATINUM Erwin 3.5.2 and Win'95

Confidential

SMT System

This project was a CONFIDENTIAL Impact Analysis project. The project's main aim was to find out the number of lines effected for making the application CONFIDENTIAL compliant.

Responsibilities:

• Tabulate the software, language wise complexity wise.
• Complexity factors are - Total LOC, Impacted LOC, Number of Subroutines COPY MODULES.
• If more than one person is working on the estimation, cross verify the estimates
• Time estimation to obtain the time required to convert programs of a complexity type.
• Document analysis results.

Environment: COBOL, CICS, EASYTRIEVE, MVS JCL, VSAM , SEEC TOOL

Confidential

CONFIDENTIAL Conversion.

• JCL flow analysis and Cross Reference Analysis
• This project is a CONFIDENTIAL conversion project. The application had a code of 3.75 MLOC. The technique used to make this system CONFIDENTIAL compliant is data expansion.
• Coding Bridge programs for data conversion.

Environment: COBOL, CICS, EASYTRIEVE, MVS JCL, VSAM , SEEC TOOL