EXECUTIVE SUMMARY

As a Business Oriented Professional with over Seven years dedicated to full life cycle IT development, expertise includes ODI specialist, IBM Datastage, Integration Analyst, Business Objects, Xcelsius, OBIEE, Oracle Apps Functional, ETL Developer, Data Warehouse Analyst with substantial experience in Telecom, Retail, Manufacture and Distribution Business processes

Summary:

ETL Tools: Sunopsis v 3x, 4x, Oracle Data Integrator 10x, ODI 11g, IBM datastage 8.x

Database: Oracle 10g/9i/8.x/7.x, SQL Server 2000/2005, Apps 12.1.2, 0.4, Netezza 4

Languages: SQL, .NET, PL/SQL.

Reporting Tools: OBIEE, Business Objects 3.1, Excelsius.

O/S: UNIX, Windows 2000/XP/NT

Tools: TOAD, SQL ASSISTANT, SQL Developer

GUI: VB.NET, C , ASP.NET.

WORK EXPERIENCE:

Confidential

• Actively involved in gathering requirements from the users and other source systems for different projects.
• Involved in handling some projects alone and completing them successfully.
• Actively involved in developing ETL jobs using IBM infosphere 8.x for all the ETL projects.
• Actively involved in creating shell scripts for running the job streams manually and automate the process by using them.
• Actively involved in creating the table structures, views, schemas, External tables in Oracle 10g and 11g.
• Actively did the production support for all the applications when carrying the duty pager.
• Automated manual processes for loading the monthly or bi-weekly files into the datawarehouse.
• Involved in creating BO universe objects for business reporting.
• Successfully completed training on IBM Netezza tool and creating and using Netezza tool to a great extent.
• Successfully completed training and creating reports in Xcelsius for Business users.

Environment: IBM Datastage 8.x, Business Objects 3.1, Xcelsius, Oracle 10g and 11g, Netezza

Confidential

• Actively involved in understanding Tibco and Java code for the current business process and rewriting them into ODI objects like interfaces, procedures, variables, functions and packages.
• Created and managed Master and work repositories for all the environments like Dev.
• Created and configured topology manager including data servers, physical and logical schemas, agents, contexts.
• Involved in using ClearCase to do the versioning for all the project objects.
• Created multiple packages with parallel and sequential flows depending on the requirement.
• Customized Emails to send out all the details about every ODI object like interaces, variables and packages with No of inserts, updates, errors and which object errored out for what reason.
• Migrated and Converted the flat source files from multiple sources to ORACLE 11g.
• Developed PL/SQL packages for Customer tracking, summary of sales order, Shipment and invoice, Sales Order information by customer, order, PO number, part number etc.
• Involved in gathering the requirements by conducting meetings and prepared the technical design documents.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, DB triggers, Indexes and Collections.
• Designed, developed ODI objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources.

Environment: ODI 11g, Oracle Golden Gate 11g, GDW, Sybase, Toad, Java, Tibco, Erwin 7.3

Confidential

• Designed, developed ODI formerly known as Sunopsis for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Created and managed Master and work repositories for all the environments like Dev, Test, UAT, Prod.
• Created and configured topology manager including data servers, physical and logical schemas, agents, contexts,
• Installed ODI studio on Citrix windows 2003 server and created privileges to DW team.
• Involved in creating Data warehouse Star schema using Erwin 7.3, with multiple Facts and Dimension tables.
• Involved in using ClearCase to do the versioning for all the project objects.
• Created multiple packages with parallel and sequential flows depending on the requirement.
• Customized Emails to send out all the details about every ODI object like interaces, variables and packages with No of inserts, updates, errors and which object errored out for what reason.
• Migrated and Converted the flat source files from multiple sources to ORACLE 11g.
• Designed and developed the Siebel Analytics Metadata Repository .rpd using Siebel Analytics Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints into
• Physical Layer using connection pool, developing multiple dimensions Drill-down Hierarchies Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Siebel Security Setup groups, access privileges , Metadata objects and Web Catalog objects Dashboard, Pages, Folders, Reports .

Environment: Sunopsis/ODI 11g, OBIEE, GDW, SQL Server, Toad, Erwin 7.3

Confidential

• Involved in design, development of ODI formerly known as Sunopsis for ETL Project, gathering requirement specification documents and presenting and identifying data sources.
• Migrated and Converted the flat source files from multiple sources to ORACLE 9i.
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances. Built transformations, configured servers and established connections to various sources and targets
• Customized Email distributions to get the error messages and out put from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements.
• Created, modified, and administered analytics Intelligence Dashboards with links to web sites HTML text links to documents and embedded content, such as images, text, charts, and tables.
• Worked on Oracle Applications 12.1.2 project from Order to Cash involving mainly in Finance modules.
• Involved in creating and solving Defects and working with Oracle Corp on Oracle SR's for Oracle Apps 12.1.2 AR module.
• Actively involved in validating Finance modules AR, AP, GL user scenarios and upgrading from 12.0.4 to 12.1.2 Oracle Apps Instances.
• Designed and developed the Siebel Analytics Metadata Repository .rpd using Siebel Analytics Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints into
• Physical Layer using connection pool, developing multiple dimensions Drill-down Hierarchies Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Siebel Security Setup groups, access privileges , Metadata objects and Web Catalog objects Dashboard, Pages, Folders, Reports .
• Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters using Siebel Analytics Web. Suppliers are to be defined at instance level and Sites addresses are at Affiliate level.

Environment: Sunopsis/ODI, OBIEE, GDW, Oracle Applications 11.0.4,12.1.2, SQL Server, Toad, Erwin 7.2

ETL Developer Confidential

.

• Involved in design, development of ODI formerly known as Sunopsis for ETL Project, gathering requirement specification documents and presenting and identifying data sources of Oracle 8i to DWH.

• Migrated and Converted the flat source files from multiple sources to ORACLE Staging tables.
• Using ODI Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH.
• Built transformations, configured servers and established connections to various sources and targets.

• Customized Email distributions to get the error messages and out put from ODI PKG run. Modified Knowledge modules to customize it to ETL requirements

• Implemented Security by creating roles web groups, checks with External tables LDAP

• Hands on experience in ETL process using Informatica PowerCenter for various transactions and loading data from various legacy data sources.

• Expertise in debugging and optimizing Siebel Analytics Dashboards / Reports.

• Good understanding of Software Development Life Cycle SDLC .

• Ability and aptitude in scheduling, tracking and prioritizing activities

• Excellent analytical, interpersonal, problem-solving, trouble-shooting skills

Environment: Sunopsis/ODI, OBIEE, Oracle 10g, SQL Server, GDW, Toad, Erwin 3.5

Confidential

Title: Software Developer

Responsibilities:

• Developed C classes and functions for the code behind for retrieving and changing the account/policy information.
• Involved in design of the application.
• Involved in writing Stored Procedures.
• Wrote database components to access Database using ADO.NET.
• Extensively used XML for data manipulation and XSLT for data transformation.
• Extensively worked on creation and consumption of Web Services using C .
• Implemented Customized Paging in the aspx pages with the Data Grid.
• Designed and developed module to provide interface for managing account services.
• Developed ASP.NET front-end for presenting department information, where in extensively used ASP.NET Server Controls HTML controls.
• Created and maintained the student's database in the Department of Computer Science.
• Client side validations were done using JavaScript.
• Deployed applications using XCOPY and CAB
• Worked with Data Sets, Data Tables for population Data Grid.
• Extensively worked with Web Forms and Server Web/HTML , Data Binding.
• Created tables, views, indexes and relations using SQL Enterprise Manager

Environment: ASP.NET, C . NET, ADO.NET, SQL Server 2005, JAVASCRIPT, Visual Studio 2005, Web services, XML, XSLT and Windows 2000.