Summary

• More than 8+ years of IT Experience in Administration, Development and Support in the fields like SAP Business Objects, Data Services and RDBMS
• Over 4+ years of experience in Business Objects Data Services 4.0,3.2,3.1,XI R2
• Over 5+ years of SAP Business Objects Experience (XI 3.1/R3/R2/R1/6.X/5.X)
• Over 6+ years of Database Experience like Microsoft SQL Server 2008/2005, MYSQL, DB2, Oracle 11g, Oracle 10g/9i and Microsoft Access.
• Expertise in Business Objects Data services 4.0 ETL for Data Migration.
• Expertise in Business Objects XI 3.1/R3/R2/R1/6.X/5.X with experience in CMC, Infoview, Desktop Intelligence, Import Wizard, Admin Launch Pad, Supervisor, Designer, Data Integrator, Reporter, Web Intelligence XI/2.5/2.6.1/6.0, Dashboard Manager.
• Implemented 3 full life cycle implementations on SAP Migration projects, starting from Blue printing stage to Production. Experience in migrating all the Master Data Objects (Customer, Material, Vendor) along with transactional data by referencing the AIO Methodologies using IDOCS and LSMW When needed.
• Expertise SAP SD: ABAP Coding, Configuring, installing, customizing, test-qa SAP SD and integrating SD with other SAP and non-SAP systems
• Excellent administration skills to manage the environment, server, users, groups and security setup for BOBJ/DS/DI/DQ tools.
• Developing and delivering, executive level, sales-oriented and technical presentations.
• Experience in data quality and creating the cleansing packages.
• Experience in migrating BO Universe, Reports, Dashboard reports, ETL jobs from one environment to another environment.
• Tested and Validated BODI ETL Jobs, monitored Daily BODS ETL schedules
• Expertise in Meta data, profiling, performed address, dependency and redundancy using information steward 4.0.
• Worked on validation rules, complex validation rules and rule bindings.
• Technical architect on a data warehouse initiative responsible for designing the data warehouse/mart, designing and building the ETL procedures using Business Object\'s Data Integrator
• Expert in delta records on both source and target level CDC (change data capture) on type1, type2 and type3 SCD (slowly changing dimension).
• Strong knowledge in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling, fact tables, dimension tables, Star schema and snow flake schema.
• Data stores creation on sources and targets of ECC, BW and databases.
• Expertise with open hub services to push data out of SAP BI using data services.
• Expertise in installation of SAP rapid mart production planning and plant maintenance rapid marts.
• Besides BOBJ Data Services, I also use SAP Landscape Transformation (SLT) for real time replication.
• Strong knowledge on SAP HANA database architecture.
• Used SAP HANA Studio to Execute SQL and SQLScript Statements.
• Expert in defining data warehouse solution, multidimensional model, logical and physical models design, staging process and its benefits, and different data warehouse design approaches like top-down, bottom-up and schemas (Star, Snow Flakes etc. )
• Strong knowledge on OLAP technology in analyzing the multidimensional model.
• Worked with different types of reporting tools: Excel, BO Explorer, BO Crystal, Webi reports, Reports, and Dashboard.
• Created many Analytic and Calculation views with hierarchies, measures, variables.
• Worked extensively with several SAP Transactions in FICO.
• Hands on experience on SAP Business Objects dashboards. Built several functional, operational, corporate and c-level dashboards and scorecards.
• Working knowledge of Visual Basic and Hyperion Enterprise
• Leverages knowledge of data warehouse and software development methodologies to contribute to the overall planning of projects by recommending approaches, identifying resources, and developing timelines.
• Involved in Deploying Hyperion planning 11.1.1.3 in different environments.
• Worked on creation of users in the management console and in the central management console.
• Experienced in Production Support role 24/7 to resolve the issues.
• Responsible for setting up Development, Test and Production Environment.
• Administering and maintaining BO Data Services management console and repository management.
• Worked on performance tuning using caches, parallel execution, using bulk loading and using dataflow execution
• Good Communication and Interpersonal skills with the ability to interact with end-users, managers and technical personnel. Technically sound, Result-Oriented with strong Problem solving skills.
• Capable of working as a Team Member or Individually with minimum supervision. Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Project Information

Confidential,New Holland, PA
Role: SAP Data Migration Consultant.
Platform: SAP Business Objects Data Services 4.0 SP1(IPS 4.0, D.S 4.0, IS 4.0), SAP HANA,SAP BW/BI 7.0, SAP ECC 6.0, JBA(AS400), Oracle 11g, MS Excel 2000, Windows 2003 server/XP.
Duration: Oct’11 – Till Date
Roles and responsibilities:

• Installed Business Objects 4.0 and information steward 4.0.
• Integrated data services to the frontend BI 4.0.
• Involved in gathering business requirements, functional requirements and data specification.
• Determines the size and scope for a suitable data solution inHANAprojects based on the identified business requirements.
• Created and maintained Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Used SAP Info Steward Data Insight to analyze data quality, data profiling and to define validation rules for data migration in Data services.
• Extensively worked on troubleshooting the errors.
• Data profiling was performed using profiler in Data Services.
• Created local and central repositories.
• Scheduled Batch jobs using Data Services Management Console.
• Created Jobs, Work flows and Data flows according to the Business requirements and implemented the business logic.
• Created the developer, administrator and profiler users.
• Trained small development team on all capabilities within the BODS toolset and the best practices associated with BODS to handle high volumes of data.
• Created the data stores to communicate source and target with BODS
• Worked with different transformations like Map Operation, Table Comparison, Row-Generation, Query, History Generation, Key Generation, Pivot, SQL and Validation.
• Installed the SAP best Practices, ATL files and worked on the AIO jobs.
• Used the SAP inbuilt AIO jobs for customer master, material master, vendor master.
• Developed jobs to load the Legacy system data in customer Master IDOC (CREMAS, DEBMAS and MATMAS) by referencing the SAP AIO job.
• Used the ABAP data flows to read data from the ECC and to load data into the BW.
• Worked on the FICO and HR modules.
• Installed global address cleansing and USA address cleansing packages.
• Performed column, address, dependency, redundancy and uniqueness profiling.
• Created validation rules and rule bindings for data profiling according to business requirements.
• Created Data sources to import data into SAP HANA (imdb database) and modeled data structures to provide hi-performance analytic examples for customer evaluation.
• Loading of data into SAP HANA DB using Data Services 4.0 and Trigger based Replication.
• Worked with Hana Best practices to minimize response times.
• Generated Data quality reports on the dash board for the data analysis purpose.
• Performed CDC source level and target level transforms.
• Used query, match, validate transforms and look up function for data integration purposes. And also break and audit functions to observe the execution.
• Performed address cleansing by using USA address cleanse.
• Worked on loading the data into BW. Used the open hub destination services to read the data from BW and to load the data into the SQL server Database.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics and error) and by examining the target data.
• Worked on the check in and checkout of the objects. Managed the version control.
• Identified the bottle neck of the flows and used different types of performance tuning techniques like source based, target based and degree of parallelism.

Confidential,Chandler, AZ
Role: SAP BI BODS Consultant
Platform: SAP Data Services 3.2, SAP BW/BI 7.0/7.3, SAP ECC 6.0, Business Objects 3.2 Suite, Data Insight 3.0,Teradata v2R6,Oracle 9i, Hyperion Business Performance Management Linux.
Duration: Jan’10-Aug ‘11
Roles and responsibilities:

• Worked on Data Mapping workshops and follow-up-meetings with the client business and IT teams.
• Upgraded Business Objects Data Services from XI 3.1 to XI 3.2.
• Created Local repositories and Central repositories.
• Worked with the basis team to configure BODS with ECC 6.0 and BIBO by importing the transport.
• Perform Unit testing and Document the results of Unit testing and ETL process
• Worked on the POC to load data into BW and to push data from BW using open hub, calling process chain in Data services.
• Worked on the POC to extract data by using standard ECC extractors.
• Worked on a project to load data from various sources like, Lotus notes Web services and Flat files into BW.
• Worked on a project to extract data from BW objects, ECC using extractors and load into SQL server.
• Extensively involved in creating Info objects, Data Store Objects, Transformations, Info cubes, Multi providers. Involved in enhancing the data sources and write the ABAP coding to populate the enhanced fields. Involved in writing routines and customer exits
• Extracted data for various data sources FI-GL, FI-AP, FI-AR data from R/3 to BI.
• Extracted the GL data onto the openhub interfaces which the business uses.
• Extracted data for CB-COPA from R/3 to BI.
• Created Cost Based CB-COPA model.
• Created year specific cubes for CB-COPA for better performance and flexibility. Created Detail, Summary and Super Summary Cubes.
• Worked on GAP analysis and prepared the technical documents
• Involved in creating the queries that meets the customer’s requirements.
• Generated BO exclusive reports in BEx Query Designer using filters, calculated key figures, and restricted key figure.
• Created Universes with hierarchies and Filter.
• Created Objects and classes in Universe which intern used in Webi and Xcelsius.
• Broadcasted reports (Crystal and WEbi) to individual recipients using Info View scheduling functionality
• Developed accounts receivable top 25 customers dashboard using Webi, Live Office and Xcelsius
• Developed complex dashboards using Dynamic Visibility functionality
• Worked with Admin Team to integrate Dashboards into Enterprise Portal for end user access
• Worked extensively in installing and integrating Business Objects with SAP Business Intelligence
• Created Process Chains for all the above data models that I developed to automate the loading process.
• Provided end-user training and knowledge transfer on all aspects on the implementation process.
• Performed Production Support Activities to take care of loading Adjustment files for supporting month end closure. Resolved several production support issues like fixing load failures during the execution of process chains.
• Managed several offshore resources and mentored them with any issues relating to daily ETL failures that are scheduled via Control M.
• Supported the reporting development needs of users with various tools such as Hyperion Report Writer and Hyperion Retrieve.
• Performed account analysis to make certain subsidiary systems are properly reporting results in Hyperion Enterprise and the general ledger.
• Was involved in Restatement effort for restating the Class of Trade Characteristic from one value to other.
• Developed an extensive report distribution scenario with Information Broadcasting.
• Created Technical Design documents and unit test plans.
• Conducted several lunch and learn sessions for knowledge transfer/sharing.
• Performed the Monthly Actuals to Forecast Process which involves copying actuals data to into forecast version.

Confidential,Dublin, OH
Role: ETL Consultant
Platform: SAP Business Objects Data Services XI 3.0 (Designer, Repository Manager, Management Console, Server Manager), Teradata, SQL server-2008, MS Access 2000, UNIX, Windows 2003 server/XP.
Duration: Nov’08-Dec’09
Roles and responsibilities:

• Installed the data cleansing package after the installation of the BODS on Linux server as well as on BODS client machine.
• Worked with Business Analysts and users to clarify requirements and translate the requirement into technical specifications and solutions.
• Developed complex ETL code and modified the existing ETL applications as per the business requirements.
• Understanding the business process, data collection and analysis various source systems.
• Involved in data transfer from OLTP systems forming the extracted sources.
• Performed change data capture (CDC) process using SCD-I and SCD-II implementations.
• Developed mapping to load data into slowly changing dimensions.
• Used different transformations like Query, map operator, table comparison, History preserving, key generation, row generation, pivot, reverse pivot …etc while developing the ETL flows.
• Implemented the Type2 slowly changed dimensions by using history preserving transformation.
• Implemented incremental update and change data capture logic
• Maintained the existing mappings and workflows as per business requirements.
• Extracted data from different source systems like Oracle, sql server, flat files and loaded into the warehouse.
• Responsible for client upgrades.
• Responsible for complete upgrade from DDTS toClearQuestclient education. Design and implementation ofClearQuestto client specifications
• Combined severalClearQuestDB\'s/schemes into single working scheme, added allClearQuest integration/programming for several differing projects.
• Distributed data residing in heterogeneous data source is consolidated into target enterprise Oracle data warehouse and database.
• Extensively used the validation transformation in order to perform any validation rules before we load data into the different RDBMS
• Restructured older processes to allow for changes to newly implemented data model.
  

Confidential,New Haven, CT
Role BO/BODI Developer
Platform: Business Objects 6.5/XI R2, Crystal Reports XI, Crystal Xcelsius 4.5,Oracle8i/9i,PL/SQL Developer, SQL Server 2005/2000, Windows 2000/XP, SAP BO Data Integrator XIR2 , Data Quality.
Duration: Oct’07-Sep’08
Roles and responsibilities:

• Installed and configured Data Integrator, Data Quality, and Business Objects Enterprise suite.
• Created Data Integrator local/central repositories and configured to use different job servers and server groups.
• Work with off-shore SAP Business Objects Data Integrator ETL and development teams to provide source to target mappings as well as ETL specs, and business requirements.
• Generate profiling reports using Data Integrator profiler.
• Developed functional requirements and data specifications for ETL Process.
• Used Data Integrator for migrating data from various OLTP databases to the Data Warehouse.
• Generated Custom variables, groups and formulas in Business Objects.
• Generated Reports on different data sources such as Business Objects Universes, Stored Procedures etc.
• Created user groups and managed access privileges using Business Objects CMC.
• Responsible for Business Objects repository and BO Audit universe and reports.
• Performed release management of Business Objects reports using Broadcast Agent Server.
• Extensively used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects etc.
• Created complex dashboards using Xcelsius professional.
• Developed various Charts, Graphs and drill down reports.