SUMMARY

• Having 10+ years of experience as SAP BW/BI Consultant, Certified SAP HANA Modeler, expertise in End - to-End Implementation projects, 24X7 Support projects, upgradation and Enhancing existing application projects/sub projects in the areas of SCM, CRM, HCM, Logistics, FICO and SAP industry specific solutions (Retail, Utilities) with good track record of customer satisfaction and experience in Business Objects Suite.
• Worked on complete Life Cycle Implementation Projects, with experience in all areas of SAP BW viz. Data Modeling, Data Extraction, Data Staging, Reporting and ABAP.
• Experience in working with Global Delivery models supporting client systems.
• Worked extensively on AGILE Projects, SDLC and attended Sprint Planning, Scrums and Sprint Review meetings.
• Provided BI services to industry specific SAP clients like IS-Retail, IS- Utilities, IS- Public Sector and other SAP ERP modules
• Ensure that technical solutions maintain design integrity, meet business needs and are SOX compliant.
• Extensive experience in the maintenance of information warehouse and good acumen in maintenance, trouble shooting, and Performance Tuning.
• Worked on various logistics application specific data viz. SD, PP and MM, and financial data (FI) GL, AP, AR, Collections, Profitability Analysis and CRM.
• Expertise in various modeling strategies and involved extensively in implementing standard delivered objects from Business content and experience in using Real-time Data Acquisition.
• Extensive experience in enhancing the data flows and other value adding activities and recovering the history without affecting the work of business users.
• ABAP/4 programming skills involve, excellent debugging skills, enhancing various data sources, enhancing customer extractor programs, preparing various customer-exit variables preparing various objects in customer namespace, developing classical, interactive reports.
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Extensive experience working with Planning and Consolidation tools like, BPS, Integrated Planning, BPC
• Hands on Experience on various components of BEx reporting environment viz. Analyzer, Browser, and Web Application Designer.
• Experienced in SAP BW on HANA and migrating standard SAP models to In-Memory optimized models and Performance testing.
• Hands on experience in working with HANA views and creating SQL procedures and HDB procedures.
• Experience building universes using IDT based on HANA views and non-SAP data (Oracle/SQL server)
• Hands on experience in Design studio, Lumira, Analysis for Office integration with Financial Planning data
• Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, slice and Dice, Alerts for creating Business Objects reports.
• Extensively worked on developing Dashboards, Analytics, and Metrics using Performance Management.
• Experience in creating, organizing, publishing and scheduling reports using CMC and creating reports with Charts (bar, pie etc), cross tabs and sub reports.
• Experience in working with onsite offshore model.
• Good interpersonal skills, effective communication skills with excellent team playing capabilities.

TECHNICAL SKILLS

Data-Warehousing Tools: SAP BW 7.5, 7.4, 7.3, BI 7.0 in NW 2004’s, BW 3.5 and 3.1 C, BO Data Services, SSIS, Pentaho

Reporting Tools: BEX Analyzer, Crystal Reports, Dashboards, Analysis for Office, Design Studio, Lumira, WebI, Web Application Designer SAP BO 4.1, 4.0, XI 3.0/3.1/3.2, TIBCO Spotfire, Tableau

ERP: SAP ECC 6.0/5.0, R/3 4.7

SAP Modules: SD, MM/WM, FI/CO, FICA, COPA, PP, HCM, SCM, SRM, CRM, BPC 7.0, 10.1, SEM-BPS, IP

Languages: ABAP/4, C, C#, Java, Python, SQL, SQLScript, JavaScript, HTML

Operating Systems: Microsoft Windows XP/Server 2003/2008/Linux, Unix

Databases: Oracle, SQL, DB2, HANA and MS-Access

PROFESSIONAL EXPERIENCE

Confidential, CA

SAP BW/IP Consultant

Responsibilities:

• Created Technical specifications and designed the data models for SD, CRM and FI data in BW
• Built solutions for Opportunity Planning in BW using Integrated Planning
• Built input-enabled queries, Web Templates, planning functions (including custom planning functions), planning sequences, aggregation levels, FOX formula codes using Modeler in Integrated Planning (IP)
• Defined Planning functions with different business rules for Sales Revenue such as Equal Distribution, Proportional Distribution, Baseline Sales Quantity
• Worked on building various Sales Planning Applications such as Bottom-up Account Planning, Bottom-up Opportunity Planning and Top-Down Sales Planning
• Developed several Integrated Planning input templates and reports for Sales Team using Analysis for Office in Excel with hierarchies.
• Configured the CRM extractors for Opportunity Line Item level data, Loyalty data and enhanced the extractor by developing BADI implementation class for the same.
• Worked on Error Debugging and rectification, solving issues faced during data loads.
• Created complex Webi reports for Expected Sales volumes per product, Competitor Analysis, Opportunity Discontinuation reason etc.

Environment: SAP ECC 6.0, SAP CRM, SAP EWM, BW 7.4, Business Objects 4.0 (BOBJ),BPC 10.1, Hadoop, JIRA

Confidential

Sr. SAP BW HANA/IP Consultant

Responsibilities:

• Worked with users to gather business requirements and translating them into technical design using SAP BI.
• Involved in end to end implementation of the BNA Depreciation, BNA Property Tax and Power Tax projects using Agile delivery methodology.
• Built solutions for Tax Compliance team in BW and developed several Integrated Planning input templates and reports using Analysis for Office in Excel with hierarchies enabled for Account, Fed Filing Category, Adjustment code etc.
• Automated the Sales Tax Planning process in BW using Integrated Planning functions and BW data modeling and BI reporting features
• Built composite providers, Advanced DSOs and calculation views in HANA for the Sales Apportionment team
• Built reports and publications in Webi for data export to Corptax and other systems
• Developed Schedule L balance sheet reports and dashboards with YoY comparison for Tax Compliance team
• Built BPC reports for Profitability analysis such as Comparative Tax Provision and summary of Tax credits (Actual and Forecast report for TFS data). The reports were based on BPC FINR model and the data was exported to Corptax system

Environment: SAP BW 7.4,7.5, HANA 1.0, BPC 10.1, Business Objects 4.2, SCM, ECC 6.0, GRC 10.x, CRM, JIRA

Confidential

Sr. SAP BI Analyst

Responsibilities:

• Involved in end to end implementation of the Reporting project.
• Conducted end user training sessions demonstrating the capabilities of SAP BI suite
• Developed complex Webi reports with drill down and drill through functionality with Region hierarchy
• Created dashboards with Lumira Desktop acquiring data from universes, prepared the data and created stories with visualizations for tracking the Worker Admin structure changes, and check the number of workers without caseloads.
• Used document linking to drill from summary reports to detail reports and defined input controls, merged dimensions for multiple queries in a report
• Built worker performance summary monthly dashboard which lists the performance metrics of the workers across all regions
• Defined the business logic in BI to retain the worker history even after the location is changed
• Developed Webi reports to display the list of workers who have cases assigned with exceptions
• Built universes in IDT and defined contexts, table aliases to resolve the loops
• Debugged the stored procedures and validated results performing data queries working with multiple data bases
• Created custom audit reports based on the audit universe to capture the system usage
• Maintained user accounts in BOBJ following security guidelines and access requirements.
• Applied trace logs on servers and worked with SAP support for troubleshooting complex incidents
• Defined Cascading prompts in IDT with List of values and used Aggregate Awareness to improve the join performance

Environment: SAP BI 4.1, Lumira 1.31, Mainframe, Oracle 11g, Pentaho, DB2, Microsoft SQL Server 2016