SUMMARY

• Having Around 15 Years of professional IT experience, with over 13 years dedicated to SAP BI/HANA/Informatica/BODS which includes Around 11 Years of US Exp.
• Three full cycle implementations of SAP BW(3.0b, 3.1c, 3.5, BI 7.0),ECC 6.0,SEM - BPS,SAP-IP, Upgrade from 3.5 To BI 7.0
• Strong skills in BW/4 HANA, BW/4 HANA Analytics, S/4 HANA Embedded Analytics, SAP BW 7.3, BW 7.4, BW Powered by HANA, HANA, SAP BO WEBI, BO-DS.
• Strong skills . in SAP HANA data modeling, creating Attribute View, Analytic View and Calculation View and SAP HANA programming including SQL, SQL Script and CE functions, CDS Views, HANA VDM.
• Extensively Worked on Different ETL Tools I.e. Informatica 10.2, SAP BODS 4.2, SAP HANA SDI/SDA,SLT.
• Extensively worked on Various Reporting tools i.e. BW Bex Reporting, SAP Business Objects Web Intelligence, Analysis for Office and Strong Knowledge is Dashboarding tools i.e. Power BI, Tableau.
• Expertise in application specific LOGISTICS cockpit, LIS, CO-PA Cost center accounting analysis, product cost controlling analysis, and sound knowledge on cost center planning FI-SL(Special Purpose ledger), generic data extraction from SAP R/3(SD Order to Cash process, deliveries, MM, FI, PP Application components). And Sound knowledge on FI/CO module.
• Involved in the preparation of business blueprint. Analyzing the business process, interacting with end user, key persons identifying their reporting needs
• Involved in Functional spec designed, Strong experience in converting Functional specs to Technical specs and involved in preparation of business blueprint documentation.
• Load monitoring for master data, transactional data, troubleshooting high, medium, low severity data load issues and aggregates filling, data availability for reporting.
• Strong work experience with Business explorer, BEx Query Designer, Web Application Designer (WAD).
• Well-rounded in Crystal reports, Crystal Enterprise. Experienced in designing and integrating key BW reports to the web environment.
• Expertise in data design models, star schema and extended star schema.

TECHNICAL SKILLS

ERP: SAP S/4 HANA, SAP R/3 (4.6c, 4.7 EE), ECC 6.0, BW- CRM, APO, SRMData Warehousing SAP BW/4 HANA,SAP HANA. AZURE Data lakes

ETL Tools: Informatica 10.2,BODS 4.2, Rapid Marts, Informatica 10.2,Azure Data Factory, VORA,HANA SDI,SDA.

DSS/OLAP TOOLS: SAP Analytics Cloud, Tableau 10.3, Power BI,BI 4.1,Azure Data Brics

Reporting: Bex Reporting, SAP BOBJ WEBI,Analysys for Office, Web Reporting, Report designer (BI 7.O), Information Broad casting, Visual composer, Cognos 8i

Planning: BPC,SEM - BPS,BI-IP,SAP BPC

Utilities: Rational Clear Case, Test Director, Toad 2,HP ALM.

PROFESSIONAL EXPERIENCE

Confidential

SAP Analyst

Responsibilities:

• Interacting with business users to analyze the business requests for system enhancements and/or projects.
• Worked on Creating ADSOs, Composite Provider, Open ODS Views.
• Produce a Functional Specifications, High-level solution design and Detailed design of BOBJ components in IDT, Webi
• Build pre-Load and Post load Business Objects WEBI Reports for Business Validation and Sign off.
• Developed Universes and multiple reports using IDT Universe designer and web intelligence in Business Objects 4.1
• Worked on Building Bex Reports, WEBI,AFO Reporting on BW/4 HANA.
• Created embed Analytics ‘reports based on CDS Views in S/4 HANA HVC, OTC and RTR Space
• Consumed S4 embedded analytical queries in front end tool using Fiori, AFO, WEBI
• Worked on Functional and Technical Design Documents
• Created BW4/HANA models, Bex queries built various WEBI, AFO reports and SAP Analytics Dashboard for West Coast Region AM/PTP Functional area.
• Worked on data provisioning options for SAP HANA and SAP BW4HANA, SLT Replication, SDA or SDI,
• Worked on Redesign BW BCS Consolidation Structures.
• Migrated on BW Bex Consolidation reports from Old Design to new Design
• Developed Profit Center, Cost Center, GL Account Hierarchy extract and build interfaces to Hyperion Essbase System.
• Worked on Realignments and data reloads from BCS to BW.
• Build reconciliation BCS-BW reports
• Developing back end structures by using SAP BI and Customized using ABAP
• Enhancing existing structures to add new functionality based on the end user requirements
• Performing unit testing for all enhancements and projects assigned

Confidential

Lead BI Consultant

Responsibilities:

• Worked on the Inventory Offsite Kit Conversion Aging, intercompany movement elimination Report requirement gathering and designing.
• Worked on ASPAC rollouts, Involved in end to end ASPAC BW Cognos rollout.
• Working on GLOBAL COPA reports enhancements.
• Defining and developing dimensions, applications, calculations, script logic, business rules, Input schedules and reports extraction of data from SAP BW/4 HANA as a source system into BPC applications via data manger packages
• Build Planning layouts, Planning Functions .
• Extensively used Fox formulas.
• Created the local provider based on flat file, also added calculation view to a Composite Provider, developed the planning enabled query,
• Created aggregation levels, and used planning function copying the local revenue and quantity plan data from native HANA table into the plan ADSO
• Enhancement to the CFPM reports.
• Implemented Rebates, Designed Rebate reports, daily sales, and Monthly sales reports.
• Involved in end to end BW CRM Resale, Point of sale Project.
• Addressed MAX Sid issue.
• Designed DB growth Metrics report.
• Designed GTS, NTS reports.
• Designed Billing, Delivery, Pricing and master data interfaces from BW to Cogon’s.