SUMMARY

• Having 7+ years of professional experience in Business Intelligence in SAP Business Objects Data Services and SAP Business Objects.
• Experienced in working with BODS (4.2) using different Data Sources (Flat file, relational, extractors etc.). and good understanding of BODS Architecture.
• Created complex Data Integrator mappings to load the data warehouse. The mappings involved extensive use of transformations like Key Generator, SQL, Query Transform, Table Comparison, Case, Merge, Map Operator, lookup function etc.
• Experienced in creating TYPE I, II, III SCD (Slowly Changing Dimensions) jobs.
• Handled Transactional data loading into SAP BW HANA.
• Worked on full life cycle (SDLC) Implementation, Enhancements, Data Migration and Data Cleansing using SAP Best Practice Migration Methodologies
• Experienced in BI 4.2, BO XI R3/R2/6.x/5.0 suite including Central Management Console (CMC), Universe Designer, IDT (Information design Tool), Desktop Intelligence (Deski), Web Intelligence XI R3, Infoview, BI Launch Pad, Import Wizard and Publishing Wizard.
• Experienced in SAP Design Studio & SAP Lumira.
• Worked with different databases like SAP ERP, SAP HANA and Oracle.
• Worked with SAP BW and SAP Hana as source for reporting.
• Good working knowledge in Universe design and worked on SAP BI 4.0 Administration.
• Have worked with DASHBOARDS 4.0 integrated with SAP BW cubes. Experienced in creating and maintaining of SAP BI 7.0 Objects like Info Cubes (types), DSO (types), Transformations and DTP (types).
• Extensive experience in supporting/maintaining/troubleshooting large amount of reports/universes/End user's issues.
• Distinctive knowledge in Optimization techniques both at universe and report level.
• Have done reports on SAP data such as SAP BW cubes, BEX queries and SAP BW multi - providers.
• Extensive knowledge of SQL querying and Excel skills.
• Experience in client interaction for gathering business requirements also
• Bilingual: Fluent in English and completed two levels in French.
• Excellent interpersonal skills and team player

TECHNICAL SKILLS

ETL Tools: SAP Business Objects Data Services 4.2

Reporting Tools: SAP BI 4.2, SAP Business Objects XI 3.1/R2/6.x, Dashboards 4.0, SAP Design Studio, SAP Lumira

ERP: SAP ECC 6.0

Database: SAP HANA, Oracle 11i, MS-SQL Server, MS Access

Management Tools: HP Quality Center, HP Service Center, JIRA

PROFESSIONAL EXPERIENCE

Confidential

SAP BODS Consultant

Responsibilities:

• Strong ETL experience in using legacy source systems like Flat Files, CSV files, Excel workbooks, SAP and Non-SAP systems using SAP Data Services.
• Worked extensively on integration of Business Objects Data services with SAP modules such as SAP ECC, BW, HANA and Non - SAP Data sources like Oracle 11g, MySQL.
• Handled the customer master and material master extractions from ECC systems.
• Have knowledge of handling the Finance and Controlling (FI/CO), Sales and Distribution (SD), Materials Management (MM) data migrations.
• Implemented end to end data migration and data integration projects.
• Expertise in extracting and loading legacy data using SAP BODS to SAP ECC using LSMW tool and IDOCS and using ABAP data flows and Data transports to extract the data from ECC tables.
• Worked extensively with Data Extraction, Data Profiling, Data Cleansing, Data Enrichment with SAP Data Services and Information Steward.
• Hands on experience in creating Projects, Jobs, Data stores, Data Flows, Work Flows, Transforms, and Functions, writing Scripts, defining custom functions and declaring variables.
• Responsible for Scheduling Jobs, Validation, Tracing and debugging Batch jobs using break points and examining the logs and error handling using Try and Catch mechanism.
• Worked extensively on Repository Manager, Server Manager and created local, central and profiler repositories and configured local and profiler repositories with the job server and management console.
• Handled transactional data migration from legacy system to SAP BW HANA.
• Worked on full life cycle (SDLC) Implementation, Enhancements, Data Migration and Data Cleansing using SAP Best Practice Migration Methodologies

Confidential

SAP BODS Developer

Responsibilities:

• Involved in Data Acquisition Process
• Extracted the data from Oracle, transformed and loaded into the target Data Warehouse.
• Used Query, Case, Table comparison, History preservation, Map Operation, SQL, Key Generation transforms.
• Debugging mapping using available test data.
• Involved in Unit Testing.
• Review of Mappings that are developed.
• Involved in Developing Logics for the Transformations used in mapping design.
• 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.
• 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.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs.

Confidential

SAP BODS/BO Developer

Responsibilities:

• Gathering requirements, planning and Designing the architecture of Business Object Data Services4.0 and related Database environment.
• Created multiple local repositories for users and central repository to move the objects from Dev-Test-Prod environments.
• Conducted workshops with business users’/business leaders for gathering the requirement needed for developing the design documents.
• Conduct design reviews and ensures that applications design adhere to architecture standards, overall roadmap, and meet customer requirements.
• Work with SAP ECC source system & CRM target system functional teams for data cleansing, conversion and migration.
• Extracting Customer master data from SAP ECC & CRM systems.
• Worked on SAP BO 4.0 Administrations.
• Worked on Information Designer and Webi.
• Interaction with client design and product reviews.
• Resolving the issues regarding the reports.
• Was leading the team and was assigning the task effectively among the team members for the Successful delivery of the project.
• Built universes using JCO connection on Multiproviders
• Suggested the best templates for the reports to the clients.
• Handled complex KPI’s in the Universe level in BO.
• Have involved in the complete UAT phase and have resolved all the concerned issues.
• Completely familiar with the BO 4.0 architecture.