Professional Summary:

• Over 8+ years of experience in development, administration for Business Objects 4.0,XI 3.1(R3.1)/XIR2/R1/6.x with strong prominence on architectural knowledge.
• Loaded data from various legacy systems to data marts.
• Experience working 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.
• Involved in complete software Development life cycle which includes gathering of requirements, analysis, design, development and testing validation, optimization and maintenance of Business Objects Data Integrator jobs to extract data from various legacy systems to data marts.
• Experience in working with many transform types like Integrator, Quality and Platform.
• Installed the AW0 functions on SAP servers to read and load tables from SAP.
• Experience using 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.
• Worked on Profiling and Auditing in migration.
• Worked with Match transform to get the best golden record
• Worked with Associate transform.
• Worked with USPS and global address cleansing transform to standardize the Addresses
• Worked with the Data cleansing transform to standardize the data.
• Worked with Match and Associate transform to avoid redundancy.
• Worked on Calypso DW to extract the tables in different formats and load them into Landing Zone and Staging Database.
• Implemented slowly changing dimension of Type1, Type 2, Type3 for the history preservation.
• Worked on connecting to various databases of SAP R/3 ,CRM, BI and migration using Data Services.
• Installed & configured Data Services XI 3.2 SP1 in Development & Production Server.
• Used the BO XI 3.1,XI R3/R2 as a reporting tool for Business Warehouse data by creating universes using SAP BW infocubes and BEx querries 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.
• Loaded data into Customer master, Material master, and Vendor master using DEBMAS, MATMAS, and CREMAS IDOCS by referencing SAP AIO jobs.
• Have knowledge in writing various Shell/PERL Scripts for automation and monitoring of databases.
• Have sound knowledge on RDBMS, Data warehousing concepts, knowledge in Data mart development, ER Modelling with SAP MODULES and non-SAP Data Sources like Oracle 11g/10g/9i, SQL Server 2005/2000, DB2.
• Experience in delivering the required reports to the project based on the business and technical requirements by involving in user training.
• Experience in preparing the test scripts and test cases to validate data and maintaining the data quality.
• Have excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.
• Result oriented team player, self-motivated and quick learner of new concepts and technologies.

Technical Skills:

Business Intelligence

Business Objects 4.0/XI 3.1/ XI R2/ 6.5., SAP BI/ BW 7.0/ 3.5, Crystal Reports 2008/ XI, Xcelsius 2008/ 4.5, SAP BI / BW SAP BEx Analyzer/ WAD

Reporting Tools

Business Objects 5.1.5/6.0/6.5, XIR2, XI3.1, Web Intelligence, Universe Designer, Desktop Intelligence, Infoview, CMS, CMC

Data Warehouse/ ETL

Business Objects Data Integrator/Data Services, Data Federator and Informatica 7.1, Calypso Data, Kalido DIW

Database

Oracle 11g/10g/ 9i, Tera Data 6.0, SQL Server 2005/2008/MDX, MS Access, My SQL

Programming Languages

SQL, PL/SQL, C, C++, Java, C # and Objective C

Web Technologies

HTML, CSS, java-script ,PHP ASP and XML

Operating Systems

Windows Server 2003/2000/NT/ XP, Solaris 10,UNIX and Linux

Other Tools

TOAD, MS Office Products (Word, Excel, PowerPoint), Tidal

Education:

• Bachelor of Technology (Computer Science)

Professional Experience:

Client: Confidential, July 12 – Sep 12
Role: ETL /Data Migration Developer
Responsibilities:

• Installed & configured Data Services XI 4.0 SP1 on Windows 2008 R2 in Development Server.
• Prepared Mapping documents by closely involving with Kalido DIW team to meet the business requirements
• Documented the migration checklist and used the same in the migration process.
• Worked on Calypso Data to extract tables and loaded the legacy tables (SQL server 2005 & Calypso DW) into Landing zone database and then into Staging Database by applying Business rules.
• Worked with Kalido DIW team to gather the requirements according to the business needs.
• Involved in weekly and daily Scrum meetings as a part of Data Warehouse team.
• Worked on Validation, Case and Merge transform as a part of Migration process.
• Worked on CDC (Change Data Capture) process while loading the tables from legacy system to landing zone.
• Created tables, Data stores for Landing zone and Staging database.
• Worked on Flat files and Excel work sheets as Source system.
• Developed reports for business needs and involved in scheduling process for generating the same for daily purpose using Cisco Tidal Enterprise Scheduler.
• Scheduled and monitored jobs in Central Management Console.
• Extensively used Business Objects Infoview for accessing reports generated by different tools, managing and scheduling reports, modifying existing objects, exporting documents to excel and setting preferences.
• Worked with QA Analyst’s to ensure proper execution of jobs by writing test cases.

Environment: SAP Business Objects Data Services XI 4.0 SP1, SQL server 2005, BUSINESS OBJECTS XI 3.1 SP2 (Designer, Infoview), Calypso DW, Kalido DIW, Oracle 10g.

Client: Confidential, Pennsylvania Feb 11 – July 12
Role: ETL /Data Migration Developer
Responsibilities:

• Installed & configured Data Services XI 4.0 SP1 on Windows 2008 R2 in Development Server.
• Created the Local Repositories, secured Central Repositories, Profiler Repositories using SQL server 2008 database and configured the Local, Profiler repositories with Job server and Management console.
• Configured the Data services to connect to the SAP R/3 and BI by using transport codes.
• Scheduled the Jobs in Management Console.
• Extensively used Address cleanse, Data cleanse, Match transforms for cleansing the legacy records in customer master, material master, vendor master.
• Used the case, validation, merge transforms in validation process and also worked on enrichment process.
• Prepared Excel sheets (tables for Legacy fields to SAP fields) and worked on those Excel sheets by building logical connection in File formats.
• Exposure to Data services design interface, Data services Architecture, Data services objects, Data stores, File formats, importing metadata.
• Involved in meetings with the SAP functional team to prepare functional mapping and providing suggestions to meet the requirements using data services.
• Prepared the functional mapping to CREMAS, DEBMAS, MATMAS, IDOCS and prepared GAP analysis.
• Created the data stores for SAP and Legacy .
• 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.
• Used the local repository metadata to build a universe (purpose is to generate reports on IDOC status and messages).
• Performed profiling tasks and involved in installation, development work on the Information Steward.

Environment: SAP Business Objects Data Services XI 4.0 SP1 (Designer, Repository Manager, Management Console, Server Manager), SAP ECC 6.0, AS400 (JBA), SQL server 2008, DB2, BUSINESS OBJECTS XI 3.1 SP2 (Designer, Infoview), MS excel 2000, Windows 2008.

Client: Confidential, IL Jan 2010-Jan 2011
Role: Business Objects Data Services Developer

Responsibilities:

• Created Migration check list and followed those steps during code migration.
• Build the STG database for AIO and worked on profiling the data in the STG area.
• Found the anomalies in the source systems and conducted the meeting with the business users to identify the rules to solve the anomalies.
• Developed the STG, Lookup, AIO jobs and worked on the Mapping, Validation, and Enrichments in the AIO.
• Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
• Identified the parts of theSQL, which are repeated and wrote custom functions so that they can be reusable in multiple queries.
• Created derived tables to incorporateSQLfrom the existingMS Access queries.
• Write test-case scenarios, develop test plans and conduct user acceptancetesting & training.
• Forged effective and successful partnership with business and application development teams.
• Documented process flows, created user manuals and trained end users.
• Responsible for the construction and implementation of the Extract, Transform, and Load (ETL) components as well as remaining technical documentation relating to the ETL process.
• Developed SQL scripts to extract data (ETL) from various source systems and load it into the Collections and receivable SQL Server database
• Used Business Objects Web Administrator to schedule and monitor Batch jobs
• Implemented Automation process, Polling, Failure and Recovery Mechanism for ETL Job Execution.
• Used Debugger to troubleshoot the mappings between source and target tables.
• Handled several issues which came under production support.
• Responsible for the design and development of ETL batch load and real time jobs.
• Experience of dealing with multiple source systems ( relational and flat files )
• Contributed to the project planning process by estimating ETL tasks and deliverables.
• Involved in reviews and active participation in weekly meetings.
• Reported Daily and Weekly status to the Team Lead.

Environment:Business Objects data services 3.1 , Designer, Management Console, SQL Server 2005, Windows 2003, Oracle 10g, SQL, ECC 6.0 , BW 7.0 .

Client: Confidential, Irvindale, CA Nov 2008 - Dec 2009 Role: ETL/ Data Migration Developer

Responsibilities:

• Configured the Local, Profiler repositories with Job server and Management console by creating those repositories in Oracle 10g.
• Configured the Data services to connect to the SAP R/3.
• Installed & configured Data Services XI 3.1 SP1 in Development & Production Server.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Extracted the data from IBM Main frames by creating data stores using ODBC connection based on the requirements.
• Worked with Business users in getting mapping done to load Master data such as CREMAS, MATMAS and DEBMAS.
• Created the jobs to load into customer master segments using AIO_CUSTOMER_MASTER_JOB.
• Worked on 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).
• 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 to prepare ETL Mapping documents.
• Using the ABAP dataflow, extracted the data from R3 table and generated the lookup tables.
• Implemented the Data Enrichment step as per the AIO schema.
• Used WE05 transport code to check the IDOC status.
• Created the WEBI reports to generate the status of IDOC using SQL Server database .
• Tuning the queries to improve the performance of the report refresh time.

Environment: SAP Business Objects Data Services XI 3.1 SP1 (Designer, Repository Manager, Management Console, Server Manager), SAP ECC 6.0, Oracle 10g, SQL server 2008, DB2, BUSINESS OBJECTS XI 3.1 SP2 (Designer, Info view), MS excel 2000, Windows 2003 server/XP.

Client: Confidential,MN May 2007-Oct 2008
Role: ETL Developer

Responsibilities:

• Involved in meetings with the Data Analysts to understand the Source data and Business functional rules.
• Installed & configured Data Services XI R2 in Development & Production Server.
• Involved in creating the Local Repositories, Central Repositories, Profiler Repositories in Oracle 10g and configured the same with Job server and Management console.
• Have configured the Data services to connect to the SAP R/3.
• Developed jobs to load the SAP R/3 tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Extracted the data from ECC 6.0 and loaded into BW 7.0 using Data Services XI R2 SP1 as an ETL tool.
• Used Open Hub Services to push data out of SAP BI using Data Services.
• Extracted the data from Legacy systems (SQL server) and loaded into Oracle 10g.
• Used Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality
• Used Data Integrator and Platform Transforms extensively for developing jobs
• Created jobs, Workflows and Dataflow as per the business requirement.
• Used Change Data Capture on both Source and Target level for SCD(Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Involved in moving the projects from DEV to ST, ST to UAT and UAT to Production.
• Scheduled the Jobs in Management Console.

Environment:SAP Business Objects Data Services XI R2 SP1(Designer, Repository Manager, Management Console, Server Manager),SAP BW/BI 3.5, SAP ECC 4.5, SAP Netweaver, Oracle 10g,SQL server, MS Access 2000, Windows 2003 server/XP.

Client: Confidential, India Sep2005-Mar 2007
Role: PL/SQL Developer

Responsibilities:

• Support of Production, Development and Test Environments of Oracle and Sybase Databases for multiple applications.
• Installed database and backup server’s.
• Troubleshooting and Performance tuning of SQL Servers and applications.
• Used Backup and Recovery procedures for Production and Development servers.
• Running DBCC and fixing database consistency & allocation errors.
• Involved in database Design and application programming.
• Creating stored procedures and triggers.
• Integration and System Testing of the application.
• Was involved in quality related activities like defect tracking.
• Writing Database Packages, Stored Procedures and Triggers.
• Support and maintenance of the Application Database.
• Creating databases, tables, indexes, new logins, users etc.
• Monitoring performance of Oracle database.
• Physical resource management: device and segments creation.

Environment: C/C++, Oracle 8i, 9i, Reports2.5, PL/SQL, Solaris 5, Windows 2000/NT