Summary

• Around 7 years of total IT experience in the Design, Modeling, Development and Testing of Data warehouse housing and other applications using Object Oriented Analysis, Design and Methodologies.
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Worked in multiple responsibilities including ETL architecture, ETL design, analysis and development, writing technical specifications.
• Knowledge in Planning, Designing, Developing and Deploying Data warehouses / Data Marts with experience of both relational & multidimensional database design using Data Modeling tool Erwin (Physical and Logical data models).
• Strong Exposure to SQL, PL/SQL, RDBMS, Oracle 8i/9i/10g and MS SQL Server 2005.
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica Power Mart and Power Center and Data Integrator.
• Created projects, batch jobs, Real time jobs, work flows and data flows.
• Creating Users, Installing client software on local machines, Creating Profile server, Configuring Web administrators, creating users to monitor Jobs on CMC of ETL tool BO Data Integrator.
• Worked on the DI scripting for different functionalities, including FTP the files to the exchange servers etc.
• Tested data flows and scripts against sample data and real data.
• Possess leadership qualities of leading the team, motivating and inspiring the team by recognizing the work by giving appreciations.
• Experience using, SQL*PLUS, SQL*Loader, TOAD, DTS packages, PL/SQL , Developer 6i, VB6.0
• Extensively utilized Business intelligence Reporting Tools such as Business Objects XI 3.1,Business Objects XI R1/R2,Performance Management XI R2, Business Objects 5.X/6.X, Crystal Reports XI/10/9 and Seagate Info 7.5
• Knowledge in architecture design of Extraction, Transformation & Loading environment using Informatica Power Mart and Power Center and Data Integrator.
• Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts using Accentual Data stage (Manager, Designer and Director

Technical skills:

• BI Tools: Business Objects XI 3.1, R1/R2/R3/, Web-Intelligence, Crystal Reports
• ETL Tools: Informatica 8.6 PowerCenter, BODI Data Integrator (ETL),BODS Xi3.2,4.0
• Platforms: Windows, UNIX, LINUX, Web Sphere, Apache/Tomcat.
• Databases: Oracle 9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5, Access, DB2.
• Languages: C, SQL, PL/SQL, MS.NET

Experience:
Position: Business Objects Data Services Developer/Admin Oct 2011--Present
Company: Confidential,MO
Confidential, which it markets under the Roundup brand. Monsanto is also a leading producer of genetically engineered (GE) seed.

• Created Repositories, Users & assigned the security in the Multi-Team Environment.
• Worked in the BODS4.0 Environment, the entire project implementation was on 4.0
• Worked on the IDOC’S, Batch/ real time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects.
• Worked on the BW open Hub tables to extract the data from the BW.
• Extracted Data from all the Relational Databases including oracle, Microsoft Sql server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
• Worked on the DI scripting & prepared a standard Incremental load template which enables the job failure/success notifications.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put & get the files on the data-exchange servers.
• Worked on all the standards & guidelines Best practices Documentation, and also the functional & Technical design specification documentation.
• Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, & scheduled the jobs as part of the Administrator.
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Provided the technical guidance & knowledge transfer of effectively using BODS4.0

Environment: Business Objects Data services 4.0,SAP, Web Intelligence, Info view,SybaseIq, Oracle 10g,Isql, Toad, SQL, PL/SQL,

Position: Business Objects Data Services April 2011-September2011
Company: Confidential,Marietta

Confidential,is one of the Biggest Carpet Manufacturing Company in North-America, Europe & Mexico.

• Creating Jobs, Work flows, data flows and scripts in Data Integrator to pull data from the legacy systems and load the data into target database. Writing SQL Statements in DI scripts to modify data. Created initial and delta loads.
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implemented in Data Integrator jobs.
• Worked on Source to Target Mapping design.
• As a part of Administration work, created the Users, groups and assigned the security in The Central Management console.
• Installed the client tools on all the developer machines created their local repositories and added them to central repository. Involved in the Check in, Check out, get operations with other local repositories from Central Repositories.
• As a part of database Administrator [Microsoft SQL server 2008] created the users, mapped the users to their respective local repositories and granted the access to their specified groups.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs.
• Involved in knowledge transition to other Developers. Presented a Demo of using all the Platform Transforms, complex functions, look up functions.
• Involved in the production support, and interacted with the Reporting developers to change the code of the Tables based on their reporting requirements.
• Worked on the Universe Design Row- level Security in the Business objects.

Position: Business Objects Data Services October 2010- March 2011
Company: Confidential,, Ohio

Confidential,is the world\'s largesteyewear company. Its best known brands includeRay-Ban, Persol andOakley Inc.

Roles & responsibilities:

• Worked on Source to Target-Mapping for legacy systems (Target SAP RETAIL)
• Worked on transforms, Jobs, Workflows, Data flows, scripts etc in Data Service to extract, cleanse and load into target Data Base.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs
• Gathered requirements from the Business and applied the look-up functions to meet their requirements, used if then else function.
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Involved in Knowledge transfer to certain users, like explaining the functionality of different transforms (merge, validation, key-generation, query) etc.
• Developed number of Complex data integrator Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Loading of Data.
• Used look-up function extensively for source to target mapping scenarios.
• Worked on Data-quality for Global-address cleansing.
• Worked on Data-Quality for Address cleansing, Data-cleanse, Matching, And User defined transforms.
• Prepares charts (for DI job), programs and getting instructions needed to illustrate and explain the implementation of programs and procedures
• Developed number of Complex data integrator Mappings and Reusable Transformations to facilitate Daily, Weekly & Monthly Loading of Data.
• Worked on data-cleansing to standardize the operational data.

Position: Business Objects/ BODI Developer January 2010- September2010
Company: Confidential,Florida

Confidential,is the consumer banking arm of financial services giant Citigroup. Citi-Bank interacts with Financial Investments, Controlling of User Assets and enhancing financial performance, Logical growth, GL Accounts and providing long-term profitable growth for their multi-level Agencies.

Roles & responsibilities:

• Used DI objects like transforms, scripts, Data flows, Work flows in initial load and delta load mappings.
• Worked on transforms like query, table comparison, SQL, CDC, merge, case, key, date generation.
• Worked on Data-Quality for Address cleansing, Data-cleanse.
• Involved in the team of Migration in moving the reports from Development to test and then to production.
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Actively involved in the production support and also transferred knowledge to the other team members.
• Developed complex queries using different data providers in the same report.
• Worked on MQC (Mercury Quality center) as a part of testing the reports to identify the defects.
• As a part of production support, worked on Virtual-tickets (Virtual Tech is a Web based Application available to all Internal Citigroup Employees)

Environment: Business Objects XI /R2/ Crystal reports, Data stage 7.5.1, Web Intelligence, Info view,SybaseIq, Oracle 10g,Isql, Toad, SQL, PL/SQL,

Position: Sr. Business Objects developer/ ETL developer February 2008 – December2009
Company: Confidential,Georgia

Confidential,is a leader in IT and management consulting services. With more than 59,000 people in 30 countries around the Globe, cap-Gemini provides consulting services that contribute to the business transformation and economic performance of organizations, based on depth of knowledge of client industries and processes

Roles & responsibilities:

• Worked on Business Objects Data-Integrator, and used functions like lookup, date, conversions, etc in mappings..
• Responsible for creating mapping and transformation specifications based on the business requirements from various business teams and implement in Data Integrator jobs.
• Used Merge, Merge Join, Union All, Derived Column, Audit etc for transformations & to add columns with lineage metadata and other operational audit data.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs.
• Developed the web-intelligence reports, provided a supporting role in building the universes.
• Enabled aggregate awareness to encompass the aggregate logic using summary tables.
• Worked extensively on the life cycle management, in moving the reports from the environments of developing, testing and production.
• Part of the COE (Center of Excellence) where I was documenting all the standards and best practices documents of business objects XI R3.1 for Coca-Cola.
• Documentation of all the processes involved in maintaining the database for future reference such as: Business Requirement, Functional Requirement, System Requirement, Data Feed Specifications, DI job Documentation, QA template, Run Book.
• Resolved loops by creating alias and contexts to remove cyclic dependencies between the tables.
• Design the dashboard application with multiple dashboards as required as per the security requirements.
• Worked on life-cycle manager for business objects Xi R3.1.
• Worked on X-Celsius, developed dashboards.

Environment: Business Objects XI R3.1life cycle manager, Web Intelligence XiR3.1,Oracle 10g Crystal Xcelsius, Oracle 10g,Sql Server, Data Integrator XI R2,SAP BI,SAP Rapid Marts, Web Sphere, Windows 2003 Server, Solaris

Position: Business objects developer October2006- January 2008
Company: Confidential,Md

Confidential,is available everywhere cable internet and DSL don’t reach. Hughes net offers a suit of connectivity solutions for home, business, enterprise with download speeds ranging from 1.0 mbps to 5.0mbps. HughesNet was fast, simple, and cost effective

Developer responsibilities:

• Migrated business objects 6.5.1 reports to Business Objects Enterprise XI R2
• Directed and implemented entire BO life cycle for migration and Universe & report development.
• Created/Administered users/user groups/Security in Supervisor/CMC
• Modified existing Universes to meet user reporting requirements
• Interacted with Business Objects technical team to get the resolution of problems / bugs in Business Objects
• Met with the Business Analyst, users and business leads to understand their needs. Modified universes and created reports for them accordingly
• Worked on Business views and Universes to Business Objects XI R2
• Defined Business Views and business components with data connections.
• Provide Business Objects technical support to resolve client technical issues
• Wrote functions to reduce code in procedures like Address, Full Name, Active members
• Wrote Formulas to calculated the Percentages and Summaries based on the group levels
• Used Team Track to track the status of the report by developer, state and comments.
• Drill down the Analytics to the detail level data either by another Analytic or by a Web Intelligence Report.
• Involved in the extensive standards & guidelines documentation stuff.
• Recommending the Client of Upgrading to Business Objects XI 3.0 because of many Advantages in Web Intelligence andPerformance Management.
• Design the dashboard application with multiple dashboards as required as per the security requirements.

Environment: Business Objects XI /R2/6.5.1, Crystal Xcelsius, Data stage 7.5.1, Web Intelligence, Info view, Broadcast agent, Teradata, , Oracle 10g, Power Builder, Toad, SQL, PL/SQL.

Position: Business Objects tech lead/developer December 2005-september2006
Company: Confidential,, CA

Confidential,is the world\'s largest supplier of hard disk drives in terms of unit shipments, as well as a leading supplier of workgroup-class networked attached storage devices. Customers and partners include leading computer OEMs, global distributors and systems integrators, and more than 2,000 U.S. retail outlets. Responsibilities:

• Worked with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permission.
• Created Universe Classes, Objects, Measure Objects, Conditions, Joins
• Developed complex queries using different data providers in the same report
• Scheduled pre-canned reports through Broad Cast Agent Publisher for distribution and printing
• Created custom authentication using Lotus Notes database for Web Intelligence using Active Server Pages and Web Intelligence SDK.
• Installed Web Intelligence (Thin Client) and set up in a clustered environment
• Customized configuration of Business Objects - Web Intelligence by fine-tuning and Optimization for good performance.
• Leveraged Explain Plan and TKPROF to improve query performance.
• Designed and developed PL/SQL stored procedures to increase the performance.
• Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports

Environment: Business Objects 5.1.8 (Designer, Supervisor, Web Intelligence 2.7, Broad Cast Agent, Publisher, IIS Server, Webi SDK, BO SDK, ZABO), ASP, ERWIN 4.0, Windows 2003, Oracle 9i, SQL, PL/SQL.

Education: Bachelor of Engineering