Dedicated IT professional with exceptional data warehouse, database, and business intelligence experience.

• Over 2 years of professional experience working with Accenture.
• Dedicated IT professional with expertise in ETL Tools, Informatica PowerCenter 8x tool, DB2, Oracle and UNIX, data warehouse, database and business intelligence experience.
• Worked on all phases of development lifecycle from business requirements analysis, Application Design, Data Modeling, Development, testing, documentation, implementation and support.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products.
• Demonstrated expertise utilizing ETL tools, Informatica, and RDBM systems like SQL Servers, Oracle, DB2 and SAP database.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Team player with excellent communication and problem solving skills.
• Effective leadership skills with good written and verbal communication, self-motivated .
• Quick learner with excellent communication and presentation skills and has ability to interrelate with people at all levels.
• Possess strong work ethic and team spirit .

• BI - DW Concepts
• BI - Infromatica BI Tools

Training:
Completed Greenfield Training with Accenture on October 2009.

• Tools: Informatica PowerCenter 8x (Source Analyzer, Data Warehousing Designer, Mapping Designer)
• OS: Windows 2003 Server, Unix\\Linux, Windows 9x/NT/2000/ME/XP
• Databases/RDBMS: Oracle 9i/10g, Microsoft SQL Server, Microsoft Access, Flat file systems, MYSQL, DB2, SQL*Plus, SQL*Loader & Developer/2000, Microsoft Access, SAP database
• Languages: SQL, PL/SQL , TSQL, UNIX shell scripts , Visual Basic 6.0, COBOL, Perl, JavaScript, C, C++
• Software: Microsoft Office Suite

Professional Experience:

Client/Company: Confidential
Project: Devon Enterprise Data Warehouse (EDW)
Project Duration: April 2011 - Till now
Standard Role : Senior Software Programmer

Project Description -
Confidential is a leading independent natural gas and oil exploration and production company. Devon\'s operations are focused onshore in the United States and Canada.This project focuses on creating an enterprise data warehouse for synching and collecting data at one place from the different subsystems to help management with reporting and giving an end to end picture of the business. The data is collected from SQL Server 2000/2005, SAP database and Oracle database.

Role Description -

• Involved in Business Analysis and Requirements collection.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management
• Created and designed source to target mapping for SQL Server, Oracle and SAP database using PowerCenter.
• Worked on Informatica PowerCenter 8x tool - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used were: connected & unconnected lookups, expressions, source qualifier, aggregators, filters, sequence generator, normalizer etc.
• Created and configured workflows, sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Troubleshoot problems by checking sessions and error logs.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Prepared Unit test case documents
• Have performed Peer Reviews within the project.

Environment:
Informatica Power Center 8x (Repository Manager, Designer, Workflow Manager), SQL server 2000, Oracle 9i, Windows 2000, UNIX, TOAD, SAP database.

Client/Company: Confidential
Project: Athena
Project Duration: Nov2010 -March3011
Standard Role : Senior Software Developer

Project Description -
Confidential is to provide reliable, affordable and clean energy to customers. Confidential is developing innovative renewable power projects to serve its own customers as well as other utilities, businesses and communities throughout the United States. Athena project focuses on implementing a supported and well documented toolset to support business processes, increase standardization of load forecasting business processes across the Southeast and Midwest, standardize and improve data management processes (i.e. sources, retrieval, storage, backup and archival).


Role Description -

• Involved in Business Analysis and Requirements collection.
• Used Stored Procedures for data transformation purpose.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Data management
• Designed Source to Target mappings from primarily Flat files to Oracle using Informatica PowerCenter.
• Worked on Informatica PowerCenter 8x tool - Source Analyzer, Data warehousing designer, Mapping Designer & Transformations.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used were: connected & unconnected lookups, Expressions, source qualifier, aggregators, filters, sequence generator, normalizer etc.
• Created and configured workflows & sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Troubleshoot problems by checking sessions and error logs.
• Perform process analysis in order to provide detailed documentation and recommendations to the Load forecasting team for future improvements
• Prepared Unit test case documents
• Have performed Peer Reviews within the project.

Environment:
Informatica Power Center 8x (Repository Manager, Designer, Workflow Manager), Oracle 9i, Windows 2000

Client/Company : Confidential
Project: Confidential
Project Duration : Nov.2009 -Oct.2010
Standard Role : Software Developer (Support Project)

Project Description -
Confidential is a large chemical giant based out of Confidential, operating in more than 70 countries offering a wide range of innovative products and services for markets including agriculture, nutrition, electronics, communications, safety and protection, home and construction, transportation and apparel.

Role Description -

• Extensively worked on Informatica to extract data from flat files and Oracle, and to load the data into the target database.
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Scheduled to automate the update processes and Informatica Workflows.
• Tuned SQL queries for better performance.
• Used Informatica as a Data Cleansing tool to correct the data before loading into the staging area.
• Helped team in understanding the business level requirements and guiding technically to provide good optimized code and resolve the issues quicker than usual.

Environment:
Informatica Power Center 8x (Repository Manager, Designer, Workflow Manager), DB2, Oracle 9i, Windows 2000, UNIX, Shell Scripting, TOAD, SAP database.

• B.Sc. with Mathematics & Computer Science.
• MCA (Masters in computer applications).

• Software Engineering
• Computer Graphics
• Compiler Construction
• Computer Architecture
• Microprocessor and Microcontroller Based Design (8086)
• Microprocessor Control Design (8086)
• Database Management System