SUMMARY:

• Around 6 years of IT experience in System design, development and maintenance in Business Intelligence field including Technical and Functional experience in Data Warehousing technologies involving ETL tool – Informatica Power Center in conjunction with Reporting tools – Business Objects, Micro Strategy & Hyperion
• Experienced in different stages of ETL processes such as Extraction, Cleaning, Transformation and Loading using Informatica Powercenter (versions 7.x/8.x/9.1) involving wide variety of different data sources/targets - non-relational Databases such as Flat files, Cobol files, and other relational sources such as Oracle, SQL Server, Flat Files, Teradata and DB2.
• Experienced in implementing Data ware house projects involving in variety of roles from ETL developer to System Admin.
• Worked on projects related to system migrations between different enivronments
• Good Understanding and practical knowledge of Business Intelligence & Relational Database Management Systems concepts.
• Proficient in databases including Oracle, SQL server, DB2 & Tera data.
• Exposure to Job scheduling tools like Autosys and Control-M.
• Experience in involving all phases of Software Development Life Cycle (SDLC) - Requirement gathering, Design & Development, Testing & Implementation.
• Performed technical writer duties which include preparing technical specifications and Operational procedures documents adhering to company standards.
• Extensive experience on database development using SQL Scripts (DDL & DML)/Views/Procedures/functions.
• Involved in Monthly/Daily production support duties as required.
• Experienced in writing Unix shell scripts & VB scripts as required.
• Development experience on Windows NT/20XX/XP, UNIX (Solaris, AIX) platforms.
• Excellent communication, verbal and interpersonal skills.

ETL Tools: Informatica Power Center 7.1.3/ 8.5.1/8.6.0/9.1.
Databases: Oracle 9i/10g/11g, DB2, SQL Server 2008, Tera Data
OLAP Tools: Business Objects 6.1, Micro Strategy 8, Hyperion System 9
Data Modeling Tools: Erwin 4.0, Microsoft Visio 2008
Data Processing Tools: SQL *Loader , TOAD 7.6/9.0/10.1.6 ,SQL Plus, SQL Server Mgmt studio 2008.
Job scheduling Tools: AutoSys, Control-M Agent, CA Scheduler
Languages: C, C++, Java, SQL, PL/SQL, Unix Shell / VB Scripting.
Operating Systems: Windows 9x/NT/2000/XP, UNIX, Linux.
Web Development
Skills: HTML, JavaScript, XML, Cold Fusion.
Office Applications: MS-Office 97/2000/03/08, Open Office Suites.

Client: Confidential,San Diego, CA
Position: ETL Developer (Contractor)
Duration: Mar’11 – Present

Confidential,is an operating division of UnitedHealth Group, the largest single health carrier in the United States.It is considered as a recognized leader in the health and well-being industry in striving for improved health care for all Americans by creating products and services that make health care more affordable and use technology to make the health care system easier to navigate. In my tenure at this Insurance company, I was involved as ETL developer in Primary role on several projects.

Responsibilities

• Developed new ETL objects using Informatica Power center 9.1 to build TAS (Transactional Analytics System) Data mart & ADB-Hist (Accounting Data Base) Data mart adhering the general standards and company practices in a Primary developer role.
• Involved in Daily support and Maintenance for Pre-existing Data marts in Enterprise dataware house (EDW) as a part of EDW support team.
• Worked on Microstrategy to generate Monthly Dashboard reports for user groups and for user adhoc requests.
• Working interactively with Analysts and Subject Matter Experts (SME’s) in mapping exercises (Source to target) as part of the requirements gathering.
• Developed Unix Shell Scripts for source file processing and to perform pre and post load validation activities and integrated them in Informatica PowerCenter.
• Extensively worked on Microsoft Visio on preparing data models as part of DB Design process.
• Developed SQL Stored Procedures/Views on Oracle database so as to support Daily Data mart Load validations and to generate daily control reports.
• Prepared technical specification documents as part of TAS project.
• Worked interactively with different work streams during testing phases of project development to ensure data validation successfully.
• Worked on configuring Informatica and file processing Job schedules for CONTROL-M scheduler.
• Documented Process flows as required for cross training/educational purposes.

Environment: Informatica Power Center 8.5.1/9.1, DB2,Oracle 10g/11i, Unix/AIX, Micro Strategy 8,Toad 9.0, Windows XP Professional, Control-M agent, Microsoft Visio 2008, WinSCP.

Client : Confidential,Baton Rouge, LA
Position : Business Intelligence Specialist (Contractor)
Duration : Feb’10 – Jan’11

Confidential,is an operating company of AT&T that serves the southeastern United States. It consists of the former operations of Southern Bell and South Central Bell. BellSouth Telecommunications is a subsidiary of BellSouth Corporation which was acquired by AT&T Inc. and it continues as an indirect subsidiary of AT&T as a direct subsidiary of BellSouth. The primary role at this job is to support Technical Services DW by maintaining and adding enhancements in order to support the Data ware house operations.

Responsibilities

• Developed new ETL constructs and maintained pre existing ETL constructs for Technical Services Data warehouse using Informatica Power center 8.5.1.
• Efficiently worked on Report development using Hyperion Web 9.0 as per user ad hoc requests.
• Created Reporting jobs and schedules using Hyperion Web 9.0 to generate Daily/Weekly/Monthly reports as requested by user groups.
• Performed Job scheduling operations by configuring Informatica Power center schedulers.
• Worked on ISR’s (Individual Service requests) regularly requested by the internal users to add new developments to the pre existing ETL modules to increase additional functionality and efficiency.
• Performed analysis functions to gather requirements and design requirement documents for several ISR’s requested.
• Designed data models using Erwin and working on SQL Server management studio to support database operations.
• Worked on Serena Version manager tool to deploy Informatica objects / Unix shell scripts/ DB Scripts as part of deployments between Development/Test & Production environments.
• Involved in production support on the basis of On – Call rotation as required
• Actively involved in Cross training programs conducted by the other teams during the project tenure.
• Provided efficient Support to the users at technical support role for supported applications as part of the team operations.

Environment: Informatica Power Center 8.5.1, SQL Server 2005, DB2,Oracle 10g, Hyperion Web &
Fat Systems 9.0, Microsoft Visio 2007, Windows NT, Microsoft SQL Server Management studio
9, Serena Version Manager 8.1, Erwin 6.0

Client: Confidential,Houston, TX
Position : ETL Developer (Consultant)
Duration: Nov\'07 – Dec’09

Confidential,to supply chains in some of the world\'s most challenging environments to facilitate trade through innovative supply chain solutions offering unmatched personal service, a global footprint and customized capabilities in developed countries and emerging economies. Agility is one of the world’s leading providers of integrated logistics spread over 100 countries and considered as one of the logistics leader meeting the challenges of global trade. The project that was worked during the tenure is – Migration for ARG Application from Siebel to Oracle DB and involved in the support duties for existing Database application: SIMO

Responsibilities

• Involved in gathering and documenting all necessary requirements for Migration from Oracle to SQL environment.
• Worked with Informatica Power Center 7.1.3 - Mapping Designer for developing mappings consisting of wide range of transformations based on the business logic.
• Extensively worked with Informatica Power Center 7.1.3 - Workflow Manager to create workflows, worklets which consists of different type of tasks available.
• Worked on scheduling operations using AUTOSYS.
• Worked on Performance tuning techniques to optimize the execution time of the Informatica workflows when converted to different environments
• Worked extensively on pmcmd commands for processing workflows.
• Worked on different data sources such as Oracle, SQL Server2000 and Flat Files.
• Worked with PL/SQL to rewrite Stored procedures/Functions as part of migration tasks.

Environment: Informatica Power Center 7.1.3, Cognos(8.3),Oracle 9i/10g, Siebel, Autosys, Windows NT, UNIX,
TOAD 7.6.

Client : Confidential,Charlotte, NC
Position: Data warehouse Developer (Consultant)
Duration: May\'07 – Oct’07

Confidential,is a widely diversified international, sales and marketing organization for America’s leading magazines and specialty products. CMG provides client publishers with comprehensive sales, marketing and promotional services through a network of domestic and overseas sales venues, including mass market, direct to retail and specialty market channels. I worked on POS (Point-Of-Sale) project for Barnes & Nobles book store. My project was involved in building Data mart for Wholesale data coming from the FTP site.

Responsibilities

• Analyzed the requirements and involved in preparing documents containing Functional

and Technical Details of project.

• Worked on Informatica Power Center 7.1.3 to develop various mappings and workflows which

involved in building the fact and dimensional tables for Point-of–Sale data.

• Involved in Data Cleansing by developing various validation techniques during Data staging.
• Developed UNIX shell scripts which were eventually used in workflows serving the purpose to

build the Wholesale Data mart.

• Involved in Performance Tuning – initiated necessary steps to decrease the time in running

workflows.

• Worked on PVCS Version Manager to deploy the necessary code and database archives to

support distributed environment.

• Extensively worked on Business Objects 6.1 to develop reports for end users.
• Involved in Unit testing and developed Unit test documents.
• Involved in end-user training and providing the production system support.

Environment: Informatica Power Center 7.1.3,DB2, Oracle 10g, Business Objects 6.1, Windows NT, UNIX, TOAD 7.6,PVCS Version Manager.

Company: Confidential,AP, India
Position: Oracle Jr. Developer
Duration: Dec’05 – Apr’07

This project is a form based application that facilitates employee details like salary calculation, attendance information, loans information, allowance information, dividends information etc. A number of reports have been written to provide all project related information.
Responsibilities:

• Initial system study and design.
• Normalized the database to remove data redundancy.
• Prepared Entity Relationship diagrams.
• Created tables, views, synonyms and sequences.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Created database objects like tables, views, synonyms, indexes and sequences.
• Extensively used Database Triggers, procedures, functions and packages.
• Used SQL * Loader and Export, Import utilities to load the data.
• Modified existing forms, reports, and graphs as per the enhancement.
• Extensively used Database triggers, PL/SQL procedures, packages and functions while developing the forms and reports.

Environment: Oracle 7.3, Forms 4.5, Reports 2.5, Windows2000/NT, SQL* Loader

EDUCATION: