SUMMARY:

• 9+ years of expertise in designing, deploying SAP software such as Business Objects, HANA and BPC.
• Helped various clients lower cost of ownership and make timely and accurate decisions by implementing and designing BI solutions to fit the clients’ requirements and future needs.
• In - depth and hands on technical, functional and management solution expertise in Oil and Gas, Retail, Health care, Manufacturing, Education and Energy Industry.
• 4+ years of experience working with SAP HANA modelling and Development.
• Strong understanding of business analysis, SAP BI applications, and agile development methodologies. Proficiency in the development of Crystal Reports, Web Intelligence Documents, Lumira Stories, Analysis for Office as well as the administration.
• Experience in Developing, Maintaining & Modifying Universes using IDT (information design Tool), UDT (universe design Tool) and Business Objects Designer.
• Strong understanding of SAP Analytics on cloud.
• Lead large scale Cluster Environment installation & Configuration of SAP BI Platform 4.2.
• Expertise in SAP BW and EPM data solutions design and implementing.
• Expertise in BPC Financial and Consolidation models with GL,COPA extractors and integrating FI data
• Extensive design and implementation skills in planning and budgeting data solutions.

TECHNICAL SKILLS:

• SD, MM, PP
• SAP HANA, Business Objects, BPC, BW
• SAP BO - 3.1,4.0, 4.1, 4.2
• Sap HANA Studio
• Web Intelligence
• Crystal Reports
• SAP Lumira Designer
• SAP Lumira Discovery
• SAP BPC NW & MS - 10.1,10.0,7.5, 7.0
• SAP BI-BW - 7.3,7.4 (on HANA)
• SAP Data Services 4.2
• SQL, VBA
• SQL, HANA

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SAP BI Consultant, Atlanta, GA

Responsibilities:

• Architect the solution and proposed high-level design for Sales Outlook integrating BusinessObject data with SAP Analytics for Cloud
• Worked with CFO to develop metrics and visuals critical to the executive team for daily sales reporting and analysis.
• Charted road map showcasing BPC as the to-go tool for Planning and budgeting needs
• Documented the business processes and technical details of the BI solution
• Performed Requirements Gathering and completed the Modelling of Attribute, Analytical, and Calculation Views in SAP HANA
• Designing dimensions and models appropriate for the BPC solution
• Implemented and automated creative solution to rollup the master data to a hierarchy node during the load process
• Write EPM reports and Input enabled templates for data consumption and data input
• Export BPC data to external reporting medium like Qlik view
• Implemented a new method to capture the adjustments by closing the request id in specific time window to safeguard from data contingency
• Conducted trainings for business analysts and Internal BI team
• Providing Steady State Support to all BI related systems including SAP BusinessObjects 4.2 Platform and Client Tools, SAP BusinessObjects Data Services 4.2 and Information Steward 4.2, SAP BW 7.3, SAP BPC 10.0

Confidential

SAP BI/BOBJ Lead, FL

Responsibilities:

• Upgrade large scale Clustered BI system from 3.1 to 4.2
• Installation and Configuration of SAP BI Platform 4.2, SAP Explorer 4.2
• Complete migration of all the security & Content from old environment 3.1 to 4.2
• Prepare test Cases
• Train users on new features
• Conversion of legacy DESKI reports to Web Intelligence
• Provide support to the end user during the UAT phase of the project
• Plan, design, create/build & maintain BusinessObjects universes that respond to identified requirements
• Developed Dashboard on top of newly created universe. This consists of requierment gathering, a design and development phase.
• Managed and gave technical guidance for a support project that consisted of a variety of tasks ranging from building a new Web Intelligence Report, troubleshooting issues with existing Web Intelligence Reports, and showing the business how to use newer BusinessObjects functionality such as Shared Elements.
• Collaborate with Data Architect to improve and/or update available data and data warehouse structure
• Analyze performance issues in WEBI reports and provide/implement solution to improve it.

Confidential

SAP BI Consultant, NewTown Square, PA

Responsibilities:

• Provided technical expertise on SAP architecture and making recommendations to improve performance
• Conduct work effort estimation and develop work plans
• Create, enforce, and adhere to HANA development standards
• Worked with large data volumes including structured and unstructured data
• Performed end to end HANA Reporting and Analytics Implementation
• Developed SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting
• Worked on the Reporting which consisted of performing Requirements Gathering, Development, and Testing with the Business Users on 20 Web Intelligence Reports.
• Developed Sales universe on enterprise data warehouse to meet reporting and dashboarding needs.
• Created multiple ‘heavy-lifting’ Web Intelligence documents that fed data to a Daily Sales Reporting Dashboard via Query as a Web Service connections.
• Developed P&L Reports via WEBI and performed virtual training of both IDT and WebI tools with power users.
• Develop Sales Dashboard in Lumira using HANA views
• Configured system and some reports/analytics to be consumed via mobile device.
• Provide support to their existing WEBI reports which has issues.
• Provide support to users

Confidential

SAP BI Consultant, Atlanta, GA

Responsibilities:

• Upgrade legacy 3.1 system to clustered 4.1 environment
• Migrate all content to the new DEV, QA and PROD environment
• Restructure user security using new features
• Configured WinAD SSO solution
• Performed analysis of existing key Crystal Reports, created 3 Universes in Information Design Tool based of the logic in these Crystal Reports
• Developed new UNX universes, making use of row-level security, to feed converted CR2013 to CR for Enterprise reports
• Developed universes based off of mission-critical Business Views and used to fully replace Business Views.
• Developed new internal production reports and streamlines existing reports for consumption by executive and production team.
• Converted legacy reports for use with newly designed BusinessObjects Universe and supported the development of future business intelligence initiatives within the IT department
• Created 4 Lumira Stories as a POC in Lumira
• Integrate Non-SAP ERP system (Jomer) with SAP BusinessObjects

Confidential

SAP BI Consultant, Charlotte, NC

Responsibilities:

• Built out TEST and PROD environments for new BI 4.1 system
• Closely worked with the Business Analyst, BI lead and the architect in understanding the BRS and SRS documents based on the business requirements
• Performed the gap analysis to understand the feasibility in designing the dashboard layout per business requirement
• Identified the KPIs required in the Confidential dashboard. Extensively worked on the design layout of the DW status and Executive dashboards for the Load status information and the performance information of the Key metrics for the Executives
• Extracted the reports information for the KPIs by using the Live Office connections importing the data connecting to the underlined WEBI and Crystal reports
• Closely worked with the ETL team on the required transformations and scheduled jobs in Informatica design process
• Created the Underlined reports in WEBI and crystal reports using the warehouse relational data and SAP tables as sources
• Worked on imposing dynamic display in the dashboard using the different Confidential components like Combo boxes, Scorecards for the Alerters (based on the threshold) and mapping these components to the data in the Live Office spread sheet
• Worked on planning, designing, developing, distributing and maintaining Universes with SAP BI/BW BEx queries as a data source
• Scheduled the underlined reports in Confidential
• Trained the end users on the detailed design and analyzing the dashboard functionality
• Provided support of their BI systems which includes monitoring schedule jobs, user security and troubleshooting day to day issues.

Confidential

SAP BI Developer, Pleasantville, NY

Responsibilities:

• Responsible for designing and development of Universes from relational database sources
• Interacted with Business users, Business Analyst, gathered business requirements, and presented the proof of concept
• Performing requirements analysis, design, and technical delivery of critical business reports for decision support in the data warehouse sitting on top of Oracle data base
• Designed and built Universes using Designer, created and modified WEBI, Crystal reports from the underlying Oracle and SQL server databases for different business modules
• Designed the logical semantic layer using the Universe designer tool by defining joins, cardinalities between tables and applying contexts and aliases to remove cyclic dependencies (Loops/traps)
• Resolved complex loop issues by creating multiple contexts and aliases to remove cyclic dependencies in the universes
• Applied Row level securities using security restrictions option in the Universe. Created the Object level security in the Confidential
• Handled Embedded BO Functions like @Prompt, @Select, @ Variable, @Where, @Aggregate awareness in the designer to handle user requests for report generators. Set up Aggregate tables to enhance the SQL performance
• Analysed all tables and created various indexes to enhance query performance working with DBAs
• Worked on custom hierarchies in the universe level to enable scope of analysis and various drill options during reporting
• Worked on universe level filters to restrict the data at Universe level. Applied filters on the objects. Created derived objects in the universe
• Created Derived tables for improving performance and used short cut joins to resolve join problems
• Worked on editing the List of Values (LOVS) to create dynamic and cascading prompts
• Worked extensively on the WEBI functions like multiple queries, combined queries, report and block filters, and various reporting cosmetic options like section, breaks, ranking, sorting and formatting options
• Demonstrated the business users the Web I reports and Confidential (admin) functionality in detail

Confidential

BPC Consultant, San Ramon, CA

Responsibilities:

• Designed question tracker for gathering data from various business owners and analysed the responses to build business process model for financial planning
• Key contact between implementation partner and the client
• Part of team preparing the Blue print document of the project
• Migration of 5.1 system to 7.5
• Support end user on day to day basis.
• Develop reports and input forms as requested by the users
• Created the drill through using BPC Admin, to Business Explorer Analyser
• Maintain Dimensions and Hierarchies
• Created business rules and script logic to manipulate the data
• Configure and maintain security.
• Migrate reports from legacy system and modify them according to new functions
• Trained power users on new EPM functionality to help them realize powerful reporting features
• Responsible for the BPC servers
• Responsible for the backups of BPC environments

Confidential

BPC Developer, Maryland

Responsibilities:

• Created Technical Documents (TD) and Functional Documents (FD)
• Responsible for interacting with functional consultants & users to write the technical specifications based on Functional specifications, BPC & BW Development(Modelling, ETL, Reports Generation & Broadcasting) Unit test documentation, Test Cases and test scripts for Integration testing and UAT, KT and giving end user training.
• Extensively used Revenue and P&L Applications used for Revenue and Expense planning.
• Developed a Custom Logic BADI to automate the loading of Data from CONSOL Application to FINANCE Application.
• Extensively used conversion and transformation files for the data management process
• Created Actual Plan comparison reports, Revenue by Customer, Expense by Account and By Site Variance Analysis reports using templates and EVDRE function. Created Flash reports, Trend analysis and consolidated reporting in Group currency - USD and CAD.
• Created Process Chains for Master Data & Transaction Data to run the daily data loads
• Interacted with Power users by providing demo and user training on how to use the various BI reports and BEx tools.
• Worked on go-live cut over plan activities and successfully handled & solved the Post Go Live issues.

Confidential

SAP ECC Developer

Responsibilities:

• Configuration experience in the areas of Order Management, Shipping, Billing, Pricing, Output determination, transfer of requirements, Availability check, Credit Management, Rebate Processing, Batch Management, EDI, Inter Company Business Process, Returns Processing, Procurement, Inventory, MRP.
• Hands on Vistex expertise (transactional/composite) for charge backs, bill backs, sales incentives, customer rebates.
• Experience in the configuration of basic functions including partner determination, output determination, text determination, account determination, material substitution, and free goods determination.
• Hands on experience in IS retail, auto systems.
• Configuration of sales deals, pricing master data management, price uploads, for pricing upload.
• Expertise in the configuration of Confidential (Order to Cash) and P2P (Procure to Pay) .
• Experience in the configuration of stock transfer order, inter company stock transfer orders