SUMMARY

• SAP BODS Consultant - Data Warehousing, BODS, BOBJ/BI 4.0, Technical lead and Managerial Expertise in a career spanning 10 years
• 10 years’ of experience in Information Technology, Software Engineering, Business Intelligence and Data Warehousing Life cycle - Design, implementation, testing and support.
• Analyzed the requirements and framed the business logic for the ETL process.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
• Worked on SAP IS Utilities to help facilitate data migration.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files in LSMW format.
• Experience in Analysis, Design and Development of various Data Warehousing projects using SAP Business Objects Data Services 4.0/XI3.2/3.1.Strong Analytics/Data warehouse experience using SAP Business Objects Data Services/ Data Integrator.
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Created complex Jobs, Work Flows, Data Flows, and Scriptsusing variousTransforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Strong experience in cleansing the data using Data Quality transforms.
• Proficiency in data warehousing techniques forSlowly Changing Dimensionphenomenon, surrogate key assignment and Change Data Capture.
• Extensively used Data Services Management Consoleto schedule and execute jobs, manage repositories and perform metadata reporting.
• Data modeling (Dimensional & Relational) concepts including Star-schema modeling, Snowflakes modeling, fact and dimension tables.
• Experienced with existing Business Objects 6.5 Universe to BO XI/BI 4.0 environment.
• Working knowledge of the Central Management Console (CMC) and general administration of the 4.1 Suite.
• Customer Relationship Management: Quality Assurance on deliverables, Communication
• System Design and Development: Requirement Analysis, Effort Estimation & Scheduling, Design, Development, Testing, Product Release

TECHNICAL SKILLS

Database: Oracle 9i, SQL Server 2005/2008, SAP HANA

Operating Systems: Windows XP, UNIX, Windows 7

Reporting Tools: BO XI, SAP BI 4.0, Web Intelligence rich client, BO BI Platform, UDT/IDT, Dashboards, Explorer, Crystal Reports, Tableau Desktop.

ETL Tools: BODS/ SAP Data Services 4.0, SAP MDG solution for master data governance for Material

Languages: SQL, PLSQL

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills, MI

SAP BODS Lead Consultant

Responsibilities:

• Participate in Data Mapping workshops and follow-up meetings with the client business.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
• Worked on SAP IS Utilities to help facilitate data migration.
• Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Installed & configured BODS XI 4.0 SP1 in Development & Production Server.
• Developed workflows to load data into Customer Master Sales data and Partner roles from legacy systems.
• Involved in setup and Configuration of the new BI 4.0 system
• As a SAP BI Consultant, Providing the SAP Business Intelligence Services like lead and own the technology engagements with customers from designing, developing and implementing complex SAP Business Objects reporting solutions
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files in LSMW format.
• As part of SAP HANA experience was involved in Implementation.
• Experienced in writing complex SQL Scripts, Procedure and CE Script.

Confidential, NJ

SAP BODS Lead Consultant

Responsibilities:

• Interacting with the customer and gathering the requirements for various report templates and enhancements in ETL Process Flow.
• Preparing design and business requirement documents, Designing complete ETL flow for Intraday data execution in Data Services
• Drill down the Analytics to the detail level data.
• Participated in detailed report design and created design specifications documents at report level.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Created new mappings and updated old mappings according to changes in Business logic.
• Installed & configured Data Services XI 3.0 in Development & Production Server.Creating stored procedures
• Designing universes to build web intelligence reports
• Created Reports as per user requirements using BI 4.0
• Integrating BO reports in client CRS application
• Created users and groups in Windows environment, Implemented the security at row level and user level.
• Integrated the Business Objects to SAP.
• Created Complex Reports such as linking of Two Reports, Drill Down and Drill Up.
• Conducted Training Programs to team members, Prepared the Test case and Test Scripts for Unit testing.
• Created Reports using SAP BW data as data source, Created Content plans for Security

Confidential

SAP BO/BODS Consultant

Responsibilities:

• Interacting with the customer and gathering the requirements for various report templates and enhancements in Process Flow.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for the clients depending upon business requirement.
• Developed jobs to load the data from SAP tables into staging area and developed transformations that apply the business rules given by the client and loaded the data into the target database.
• Based on the requirements, extracted the data from IBM Main frames by creating data stores using ODBC connection.
• By referencing CUSTOMER MASTER JOB, created the job to load into customer master segments.
• Used the case, validation, merge transforms and lookup function to validate the Customer Master basic data.
• Created Web Intelligence documents and published them to corporate documents to share the resources between the user communities.
• Moved the jobs into QA and Production.
• Resolving access level issues in business objects production and closing the Incident Tickets
• Setting access restrictions on a universe managing users and logins.
• Checking the business objects production report failures and resoling on SLA basis.
• Interacting with the customer and gathering the requirements for various report templates and enhancements in Process Flow.
• Designed Report Template Design Documents.
• Created Reports as per user requirements using BO XI R2.
• Created Universe connections in CMC level and Proved to other development team.

Confidential

SAP BO/BODS Consultant

Responsibilities:

• Created custom templates and custom lookups and shell jobs and used them in various business needs.
• Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Worked extensively with Sales & Distribution team to design data migration from Legacy system to SAP.
• Installed & configured BODS XI 4.0 SP1 in Development & Production Server.
• Created Local, Central and Profiler repositories in SQL Server 2008 R2 and configured Local and Profiler repositories with Job server and Management console.
• Designing universes to build web intelligence reports, Created repot dashboards using web intelligence and designed interactive desktop intelligence reports
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL.
• Created corporate dashboards with analytics deploying universes, setting access restrictions on a universe managing users and logins.
• Created users, including one user, MD, who has view rights only to the dashboards and analytics in the performance management folder.
• Monitoring execution of SQL jobs & optimizing their performances.
• Checking the session’s failures and workflows and resolving it.
• Resolving, Transferring and closing the Service tickets and Incident Tickets.
• Checking daily jobs are succeeded for particular interfaces. Optimizing the reports performance & reports generation process
• Creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Confidential

SAP BO/BODS Consultant

Responsibilities:

• Participated in detailed report design and created design specifications documents at report level.
• Designed and developed ETL routines in BODS, modified or created new Data Services jobs to meet project requirements.
• Ability to interpret, configure and implement data mapping / transformation business rules into Data Services
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool
• Interacting with the customer and gathering the requirements for various report templates and enhancements in Process Flow.
• Development & distribution of Business Objects reports & dashboards.
• Creation of SSAS cubes, measures groups, dimensions etc. and setting various roles, permissions, hierarchies etc.
• Extensively calculations, named queries, views while developing the reports and cubes.
• Monitoring execution of SQL jobs & optimizing their performances.
• Optimizing the reports performance & reports generation process.
• Designing universe, developing and generating complex, dashboard Reports, List of values along with User Acceptance Test and data accuracy test.

Confidential

SAP BO Consultant

Responsibilities:

• Expertise in fixing production support issues related to multi-provider mapping, data inconsistency, and job failures.
• Installed & configured BODS in Development & Production Server.
• Designing new universes as per the user requirements by identifying the required tables from data mart and by defining the universe connections.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of associates performance and volumes count.
• Creating user defined variables and writing formulas, Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report for the distribution to different locations.
• Created and modified the crystal reports for various financial groups using the Universe as a main data provider.
• Writing manual queries at report level to improve the performance.
• Involved in creation of Filters, @prompts and setup Hierarchies for multidimensional analysis.
• Preparing the test cases and understanding documents to users for future reference
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Migrated & upgraded Business Objects from 6.5 to XI r2 Universe designing and establishing BO environment.
• Involved in designing Universes to build reports using web intelligence. And creating universes to build dashboards.
• Deploying universes, setting access restrictions on a universe managing users and logins.
• Involved in creating various types of reports according to user requirements.
• Created reports using alerts by defining the conditions and formatting to highlight a report results that meets specific business criteria.
• Created the metrics used in creating analytics, and created corporate dashboards with analytics