SUMMARY

• Over 6+ years of experience in Information technology field with strong emphasis on Data Warehousing and Business Intelligence.
• Over 3 years of experience with Business objects Data Services.
• Experience in extracting data from various source systems to data marts.
• Worked extensively on integration of Business Objects Data Services with SAP MODULES and Non-SAP Data Sources like Oracle 11i/10g/9i, SQL Server 2005/2000, DB2.
• Design, development, optimization and maintenance of Business Objects Data Integrator jobs to extract data from various source systems to data marts/data warehouse various SAP modules through IDOCS.
• Experience in working with many Transform types like Integrator, Quality and Platform.
• Experience in working with ABAP data b-flows and Data transports to extract the data from R3 tables.
• Used Data Services as an external system for ETL between ECC and BI for cleansing the data using Data Quality transforms.
• Experience working with Open Hub Services to push data out of SAP BI using Data Services.
• Over 5 years of experience with Business Objects as an OLAP tool for building report, designing universes and managing user profiles.
• Used the BO XI 3.1,XI R3/R2 as a reporting tool for Business Warehouse data by creating universes using SAP BW info cubes and B Exquerries along with Oracle, DB2, SQL Server and Sybase EDW involving the creation of underlying database structure, resolving the loops, creating classes & objects, conditions & joins and finally testing the integrity of the Universe.
• Created the Local Repositories, Central Repositories, and Profiler Repositories in Oracle 10g and configured the Local, Profiler repositories with Job server and Management console.
• Strong experience in creating jobs and Upgrading Universes & Reports from Business Objects 6.5.1 to XI R3/R2/R1.
• Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.

EDUCATION
Bachelor of Engineering in Computer Science.

SKILLS
ETL Tools: Business Objects Data Services XI 3.2 SP1 (Designer, Repository Manager, Management Console, Server Manager),XI 3.1, XI R2(11.7.2.2)
BI: SAP BI 7.0, 3.5
Reporting tools: Business Objects XI 3.1 (Central Management Console, Desk I, Import Wizard, WebI, Designer, InfoView, Performance Manager, Dashboard Manager), Business Objects Data Integrator, Business Objects 6.5 (Reporter, Designer, Supervisor), Broadcast Agent (Document Agent/Publisher),WebIX1 3.1/XI R2/R1,Crystal Xcelsius 4.5/2008, Crystal Reports XI R2/10.0/9.0/8.0,Live office.
Software/Databases: Oracle 9i/8i/7i,MS Access 97/2000
Data Modeling: Erwin 4.0/3.5, Oracle Designer 2000/6i
Databases, Tools & Utilities: Oracle 9i/8i/8.0.5, SQL Server, DB2, IMS, SQL*Plus
Languages: SQL, PL/SQL, C, C++, Java, HTML, Shell Scripts,
Operating Systems: MS-DOS, Windows XP/2000/NT/98, UNIX
Other Tools: TOAD, MS Office Products (Word, Excel, PowerPoint)

EXPERIENCE

Jan 12 - Till date Business Objects Reporting Developer, Confidential,Jersey City, NJ
Bank of Tokyo is the leading provider of Retail, Business and corporate banking Worldwide. BTMU Investment division launched the Investment transactional Interface product with the objective of making the payments from/to its clients in a single day using single global platform. The objective of this project is to provide complete historic information of Payment Statuses and SLA timelines, in form of ad hoc reports. It includes developing of Universe and Reports for Investment division, Retail division. Reports are developed in Business Objects 6.5 for Inbound and Outbound payments made through this System. As part of the Reporting project, there is a need to extract data from the Investment transactional database, transform and load into the Reporting database which is the data source for Business Objects reports. BO reports are mainly used for Investment division internal purposes.

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects universes and reports.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User.
• Defined Data type, Clustered & Non-clustered Indexes.
• Involved in writing stored procedures and triggers for different tasks.
• Designed, developed and maintained universe.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Crystal reports XIR2.
• Securities for different groups and restricted data to the end users.
• Created different types of reports, like Master/Detail, Cross Tab and Chart using Breaks, Sessions, Alerts, Filters, Sorts, Query Prompts and Drill filters.
• Generated reports using personal data files like MS Excel.
• Prepared Technical design documents, unit & integration test plan and unit & integration test script for quality assurance.
• Created hierarchy and conditions in the universes.
• Scheduled the reports using BCA and distributed it to users.
• Used the Drill Down/up, Slice and Dice features to analyze data.

Environment: Business Objects XI R2, Crystal reports XIR2 Web Intelligence, Oracle 9i, PL/SQL and Windows 2000 Server, Informatica Power Center 8.6.0/8.1.1, UNIX Shell Script, UNIX

Jan 11 – Nov 11 SAP DMC/ETL Developer, Confidential,BUFFALO, NY
This project involved developing the enterprise data warehouse and creating a meta-data layer for M&T Bank to support their business needs across different business units like Account data management, service data and customer and employee data management. Business Objects has been extensively used to manage and access historical data which supported the future decisions and functionality of the enterprise.

• Configured the Data services to connect to the SAP R/3, CRM and BI by using transport codes.
• Move the projects from DEV to ST, ST to UAT and UAT to Production using ATL files.
• Scheduled the Jobs in Management Console.
• Took part in and responsible for complete end to end Mocks and Loads for various domestic and international sites.
• Involved in AIO Methodologies for the Migration process and set up the whole Migration process.
• Participated in meeting with SAP functional team to prepare functional mapping and to give suggestion that, what we can achieve by using data services.
• Created the data stores for SAP and Legacy (by using ODBC connection to underlying legacy data base which is DB2).
• Worked on SAP Data Migration project for the SAP Finance, SD modules and Vendors.
• Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
• Used the platform and data integrator transforms as a part of mapping.
• Worked on Migration Enrichment process to give more detail level data to SAP.
• Worked with new version of Data Services 4.0 and likely have knowledge on Information Steward
• Prepared Excel sheets (reference tables for Legacy fields to SAP fields) and worked on the Excel sheets by building logical connection in File formats.

Environment: SAP Business Objects Data Services XI 3.2 SP1(Designer, Repository Manager, Management Console, Server Manager),SAP BW/BI 7.0, SAP ECC 6.0, JBA(AS400), Oracle 10g, MS Excel 2000, Windows 2003 server/XP.

Oct 10 – Jan 11 ETL Developer/BO consultant, Confidential,Pittsburgh, PA
Millennium Pharmacy is the one of the specialized Pharmaceutical Company in North America. They have a very robust SAP infrastructure and had requirements dealing with SAP BOBJ to Build Universe, Reports, and Dashboards for various department needs.

• Initiated DBA interactions for resource requirements and modifications.
• Created new mappings and updated old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse.
• Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.
• Participated in meeting with SAP functional team and Legacy team for getting the mapping to load the data into Customer Master IDOC (DEBMAS06).
• Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform(to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
• Used the case, validation, merge transforms and lookup function to validate the customer_master basic data(to find whether that record already exist in SAP or not).
• Created Dashboard and web reports in Business Objects Xcelsius Engage to measure the performance.
• Designed & developed several standard Full Client and WEBI reports using different techniques: Slice and Dice, and Drill Down, Merge dimension..
• Created new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI R2.
• Created Web Intelligence documents and published them to corporate documents to share the resources between the user communities.
• Created the WEBI reports to generate the status of IDOCs using SQL Server database(repository tables)
• Environment: SAP Data Services XI 3.1, Business Objects XI 3.1/R3/R2 Suite (Desktop Intelligence, Web Intelligence, Central Management Server, Central Management Console, Import Wizard), Life Cycle Manager, Import Wizard, BOBJ Explorer, BI 7.0, Supervisor, Xcelsius 2008, QAAWS, Designer, Live Office, Crystal Report 2008API, BCA, SAP BW/BI 7.0, SAP ECC, SAP Netweaver, Oracle 10g, MS Access 2000, Windows 2003 server/XP.

Apr 09 – Sep 10 ETL\\BO Developer Confidential,New York City , NY
Sirius XM Satellite radio Network, is a radio broadcasting network dedicated to broadcast Songs all Over the United States. Work included developing Universes, Dashboards, Program Schedules etc. Worked with Data services to move data from legacy systems and enforce quality and reduce redundancy.

• Initiated DBA interactions for resource requirements and modifications.
• Created new mappings and updated old mappings according to changes in Business logic
• Performed major role in understanding the business requirements, designing and loading the data into data warehouse
• Implemented SCD - Type I & II using normal transformations (Other than Table comparison and History Preserving) in Data Integrator to increase performance.
• Implemented Automation process, Polling, Failure and Recovery Mechanism for ETL Job Execution.
• Used Debugger to troubleshoot the mappings between source and target tables.
• Implemented performance tuning logic on Targets, Sources and mappings to provide maximum efficiency and performance.
• Defined Target Load Order Plan for loading data into Target Tables
• Prepared Unit Test Cases.
• Used Data Integrator and Platform Transforms extensively.
• Resolved loops using contexts and aliases to remove the cyclic dependencies.
• Created standard Desktop Intelligence and Web Intelligence reports.
• Created contextual links between Crystal reports and WebI documents using open document feature.
• Worked on Data warehousing concepts including Star, snowflake schema design, slowly changing dimensions.
• Involved in designing Business Objects Queries, and Reports.

Environment: Business Objects Data Integrator XIR2 Accelerated 11.7.2.2,Business Objects XI R2(Supervisor, Designer, Reporter), WebI , Cystal Report 2008API, Xcelsius 4.5,DB2,MS Access, Windows 2000 Server, Unix, Oracle 9i, SQL*Plus, PL/SQL, TOAD, Erwin 3.1.

Oct 08 – Apr 09 ETL Developer/BO Production Support, Confidential,IL
Sears Holding Corporation is one of the leading retail giant with the chain of international department stores. The company operates 3,800 retail locations. Building and Updating Universe’s and Reports based on requirements. Have Developed Monthly, Quarterly Reports as required by the Management.

• Created new mappings and updated old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• Used ETL (Data Integrator) to load data from source to Staging.
• Used Data Integrator client tool for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used Debugger to troubleshoot the mappings.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Created Contexts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created Universes, reports on Business Objects, Web Intelligence and deployed to the different users through Broadcast Agent server.
• Created User Objects including Dimensions, Details and Measures.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerter.
• Created complex Universes and Reports with multiple Master Detail relationship.
• Extensively used Business Objects Web Intelligence 6.1.

Environment: BUSINESS OBJECTS DATA SERVICES 3.2(12.2.2),Sybase,DB2,SAP BW,ORACLE ,SQL Server 2005,Sales Rapid Marts, SSIS 10G,SQL,PL/SQL,UNIX,WINDOWS XP.

Feb 06 – Aug 08 SQL Developer, Confidential,Chennai, INDIA
Citi bank is one of the leading banking sector in India and World Wide. It provides different banking solutions and accounts and technology items. The project involved designing and maintaining of universe, generating webi/ deski reports and scheduling the reports. The project provided users with the ability to make intelligent business decisions, so as to assist in comprehending and predicting the organization growth based on the available historical data. Various reports were developed to analyze consumer behavior of customers.

• Designed and developed primary database objects (tables, views, indexes).
• Created tracking mechanisms to promote database changes from development to testing, testing to production, which saved database promotion time for the customer.
• Design and implemented process for migrating existing data from MS Access to MS SQL Server.
• Recommended improvements to existing application for performance and scalability requirements.
• Analyzed, designed and created reports for users Using Business Objects.
• Going through the clients requirements and coming up with database design and application architecture.
• Involved in building Conceptual and Physical Data Modeling of the application using Erwin.
• Wrote complex stored procedures and triggers using Transact SQL.
• All drilling functionality within the core reporting tool, giving users the ability to easily drill down into greater detail within a report, or up into higher levels of aggregation.
• Got the Corporate training on SAP Business Objects Data Integrator XIR2.

Environment: Business Objects Data Integrator XIR2,Business Objects 6.5/5.1 (Supervisor, Designer, Desk I),oracle8x, MS SQL Server 2000, MS Access 2000, Windows 2000 Server, UNIX