Summary:

• 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, Crystal Reports and ETL package design, 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, Mapplet Designer, Transformation developer), Power Designer, Oracle 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, Rational Rose

Reporting Tool

Crystal Reports

Client/Company: Conifdential

Project: Conifdential

Project Duration: April 2011 Till now

Standard Role : Senior Software Programmer

Project Description -
Devon Energy Corporation 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 sources 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 etc.
• Created and configured workflows, worklets & 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.
• Configured sessions using server manager to have multiple partitions Source data & to improve performance.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Extensively worked on the Triggers, Functions and Database Constraints.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Perform process analysis in order to provide detailed documentation and recommendations to the Load forecasting team for future improvements
• Transition support of the Load forecasting applications/tools to an IT support organization and implement standard IT support processes and procedures.
• 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, Autosys, Windows NT, Windows 2000, UNIX, Shell Scripting, TOAD, SAP database.

Client/Company: Conifdential

Project: Athena

Project Duration: Nov2010 -March3011

Standard Role : Senior Software Developer

Project Description
Conifdentialmission is to provide reliable, affordable and clean energy to customers. Duke Energy 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.
• Created 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 Sources to Targets mapping from primarily Flat files to Oracle using Informatica 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 etc.
• Created and configured workflows, worklets & 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.
• Configured sessions using server manager to have multiple partitions Source data & to improve performance.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Extensively worked on the Triggers, Functions and Database Constraints.
• Tuned Informatica Mappings and Sessions for optimum performance.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Wrote pre-session shell scripts to check session mode (enable/disable) before running/ schedule batches.
• Perform process analysis in order to provide detailed documentation and recommendations to the Load forecasting team for future improvements
• Transition support of the Load forecasting applications/tools to an IT support organization and implement standard IT support processes and procedures.
• 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, Autosys, Windows NT, Windows 2000, UNIX, Shell Scripting, TOAD.

Client/Company : Conifdential

Project: Conifdential

Project Duration : Nov.2009 -Oct.2010

Standard Role : Software Developer

Project Description -
Conifdential is a large chemical giant based out of Wilmington, Delaware, USA, 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.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Analyzed and created Facts, Dimension tables.
• Created Stored Procedures for data transformation purpose
• Created Tasks, Workflows, Worklets to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Scheduled to automate the update processes and Informatica Workflows.
• Wrote PL/SQL procedures for processing business logic in the database.
• Tuned SQL queries for better performance.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed various reports using the BI tool to generate reports for the Sales department and Marketing representatives.
• Extensively used Autosys for scheduling of the UNIX shell script jobs.
• Used Informatica as a Data Cleansing tool to correct the data before loading into the staging area.
• Helping 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), SQL server 2000, Oracle 9i, Autosys, Windows NT, Windows 2000, UNIX, Shell Scripting, TOAD.

• B.Sc. with Maths & 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