We provide IT Staff Augmentation Services!

Resume

Sap-bi Management Consultant Bw Hana Migration Architect And Analyst Pennsylvania, PA

OBJECTIVE:

Aspiring for a challenging and motivating career in Enterprise Resource Planning and to achieve excellence in the field of software consulting and serve the corporate with best of my knowledge, skill and capabilities.

PROFESSIONAL SUMMARY:

  • Overall 13+ years of industry experience with consulting experience across the globe (in United States, Netherlands, United Kingdom, Sweden and India).
  • 13+ years of SAP experience out of which 6+ years as a SAP BW architect and 7+ years Senior BI/BW/BOBJ Techno Functional Consultant with working knowledge in application, integration and implementation and 1.5 years in Core ABAP working exposure.
  • Extensive working knowledge for designing and developing of both BW Front - end as well as Back-end side.
  • Experience on Business Objects, have specialized knowledge on Business Intelligence technologies & tools including Business Objects Administration, Web Intelligence reports, Crystal Reports, Tableau Desktop, Tableau Server, SAP BODS, SAP BI/Bex, SAP HANA, SAP Lumira and SAP Design Studio.
  • Strong knowledge for developing user-specific interfaces for SAP BI/BW including BEx Analyzer, Business Object (Universe Designing) and Data Modeling, Web Reporting (WebI Reports, Crystal Reports, Xcelsius Dashboard, Web Application Reports etc.), handling Back-end Classes and Java Script.
  • Strong knowledge of BEx Query Designer, Calculated & Restricted Key Figures, RRI (Jump Target), Conditions, Exceptions, Infoset Queries, Queries on Multi Providers, Web Application Designer, JavaScript, BEx query performance issue.
  • Hands-on working with SAP BOBI4.X, SAP BODS 4.X, HANA & SAP systems.
  • Working knowledge on CMC and CCM administration.
  • Extensive experience in Customization skills - Data source enhancements, Generic extractors, User Exits configuration and customization, transformations including start, end, expert and individual routines and DTPs, Update/Transfer rules modifications, InfoProviders.
  • Extensive knowledge in ETL area of Business Intelligence.
  • Well versed with the Performance optimization through data modeling changes. Full working knowledge of the administrative process in BW including compression, PSA maintenance, aggregate maintenance, creation of indexes and statistics.
  • ABAP coding experience: user exits, routines, BADI’s custom programs and function modules.
  • Having strong knowledge in Financial Domain (including FI GL/AR/AP, asset accounting etc.).
  • Having good knowledge in SAP HANA (SQL script, CE Script, SLT, BODS, Direct Access etc.) and SDA (Smart Data Access).
  • Having good knowledge in developing tools and system applications using ABAP and well versed with RDBMS like Oracle, SQL.
  • Knowledge on SAP Fiori.

TECHNICAL SKILLS:

ERP: SAP BI 7.4/7.3/7.2/7.1/7.0 , SAP BW 3.5/3.2B/3.1C/3.0, R/3 Version ECC 6.0, 4.6C/4.6B/4.5B,SAP BO 3.x/4.0/4.1, SAP HANA 1.0.5/1.0.6/1.0.9 , SAP Lumira 1.0/1.1, SAP Design Studio 1.2/1.3/1.4, SAP Fiori, Tableau, Cognos.

Languages: ABAP/4, Java 2.0, CE SQL, SQL for HANA.

Databases: Oracle 8i/9i, MS Access 97/2000/XP, DB2, SQL Server

Tools: & Utilities: HP Service Manager, HPQC, JIRA, APSE, Front Page Express, Microsoft Visio 6.0, PowerPoint

Operating Systems: MS DOS, Windows 9x,Windows 2000/XP/NT

PROFESSIONAL EXPERIENCE:

Confidential, Pennsylvania, PA

SAP-BI Management Consultant, BW HANA Migration Architect and Analyst

Environment: (with skill versions)

Software: SAP-BI 3.x/7.4/7.5, BEx, SAP HANA 1.0, BO 4.1, SAP Lumira 2.0

Responsibilities:

  • Worked on BW Technical and Functional migration from 3.x to 7.4 and 7.4 to 7.5 for the BI data model (in different application areas e.g. Procurement, FI, CO, Funds Management, Plant Maintenance, HR, Travel, Treasury, CRM, SRM, FRE etc.).
  • Working on deliveries related to configuration.
  • Worked on Database Migration for SAP BW Landscape from Oracle to SAP HANA using SWPM method and help the client with new BI implementation and validation.
  • Worked on BW LSA/LSA++ data modelling.
  • Working on BI data model designing for new requirements.
  • Translate business requirements into functional and technical design document.
  • Work closely with end users in the development and maintenance of BW Objects.
  • Hands on experience & strong exposure with latest HANA Modelling objects is required (Creation of Composite Providers, Advanced DSO's, Open ODS Views etc.).
  • HANA Architecture experience and Native HANA Modelling Experience.
  • Optimization of the BW on HANA data flows, experience in working with large datasets & developing complex BEx queries.
  • Handled application support tickets and provided with the fix for the operational changes and application issues.
  • The reports are based out of BEx and Business Object (WebI and Crystal) and Lumira.
  • Build Dashboard Reporting Stories on SAP Lumira
  • Worked on Business Object Data Services for data extraction different source and transfer data to different targets. Also use OpenHub for data transfer to other target systems.
  • Working extensively on BI related ABAP work e.g. Routines and enhancing the extractor to achieve the business logic.
  • Perform QA for the deliverables.

Confidential, CA

SAP-BI Management Consultant, BI Architect and Reporting Analyst

Environment: (with skill versions)

Software: SAP-BI 3.x/7.1/7.4, BEx, BO 4.2, SAP Lumira

Responsibilities:

  • Worked on BW Technical and Functional migration from 3.x to 7.1 and 7.1 to 7.4 for the BI data model (in different application areas e.g. SD, FI, Plant Maintenance, HR, SD Billing, Purchasing, Contracting, Sales and Margin Analysis etc.).
  • Working on deliveries related to configuration.
  • Work on ECC EHP 4.0 to EHP 7.0 upgrade and Unicode Migration project.
  • Worked on DB Migration for SAP BI Landscape from Oracle to MS SQL Server and help the client with new BI Greenfield project implementation and validation.
  • Worked on BW LSA data modelling.
  • Working on BI data model designing for new requirements.
  • Translate business requirements into functional and technical design document.
  • Handled application support tickets and provided with the fix for the operational changes and application issues.
  • Help the client to choose the tools for reporting out SAP Lumira and Tableau, based on comparative analysis.
  • The reports are based out of BEx and Business Object and Lumira.
  • Build Dashboard Reporting Stories on SAP Lumira
  • Developed Web intelligence reports on universe on top of Data extracted from BI Cubes/ directly on BEx Queries.
  • Working extensively on BI related ABAP work e.g. Routines and enhancing the extractor to achieve the business logic.
  • Perform QA for the deliverables.

Confidential, TX

SAP-BI Management Consultant and Reporting Analyst

Environment: (with skill versions)

Software: SAP-BI 7.3/7.4, BEx, BO 4.0

Application Areas: FICA, FI, CO, Device Management, Billing, ISU-Electric & Gas Utility.

Responsibilities:

  • Worked on deliveries related to configuration.
  • Worked on BI data model designing for new requirements.
  • Translated business requirements into a technical design document.
  • Client has to provide credit to the customer for the back billing period for which invoices were not been generated for more than 1 month. Worked on the reporting requirements related to Back Billing report and the amount of Credit given to the customer.
  • The reports were based out of Business Object and MS Excel.
  • Developed Web intelligence reports on UNV universe on top of Data extracted from ECC tables.
  • Worked extensively on BI related ABAP work e.g. Routines and enhancing the extractor to achieve the business logic.
  • Performed QA for the reporting deliverables.

Confidential, City of Dallas, TX

SAP-BI/BW Lead and Reporting Analyst, SAP HANA Developer and Admin, SAP BO Administrator

Environment: (with skill versions)

Software: SAP-BI 7.0/7.3/7.4, BEx, BO 4.1

Application Areas: FICA, FI, CO, Device Management, Billing, ISU-Water Utility, S4 HANA.

Responsibilities:

  • Worked on deliveries related to configuration.
  • Worked on BW data model designing for new requirements.
  • Translate business requirements into a technical design document.
  • Worked on Incidents, Change Order and Service Requests.
  • Responsible for Daily, Monthly and Yearly loading activities.
  • Worked on the reporting requirements related to Water Consumption Report, Open Record requests, Security Alarm requests, Sales Statistics Report etc.
  • The reports are based out of Bex queries. Worked with BEx Query Designer, Calculated & Restricted Key Figures, RRI (Jump Target), Conditions, Exceptions, Infoset Queries, Queries on Multi Providers, BEx query performance issue.
  • Developed Web intelligence reports on UNV universe on top of SAP BEx Queries.
  • Worked extensively on BI related ABAP work e.g. Start routine, End routine and enhancing the extractor to achieve the business logic.
  • Perform unit testing, System integration testing for the deliverables.
  • Maintained business intelligence products such as reports, dash boards, Lumira, universes, explorer views, HANA, ETL, portal linkage day-to-day to ensure availability.
  • Developed some Web reports with SAP BO Design Studio on the water consumption and open order requests on disconnection objects.
  • Monitored and tune business intelligence product performance - report, plan, schedule, coordinate, communicate, execute, signify, attest, and test adjustments accordingly.
  • Worked on transporting deliverables to quality and later on production system.
  • Worked on building financial reports and generate the reports useful for company’s financial audit (GL/AR/AP).
  • Worked on the mechanism that posts the financial data to external AMS system by creating JVA file (XML file).
  • Performed Performance optimization through data modeling changes. Worked on administrative process in BW including compression, PSA maintenance, aggregate maintenance, creation of indexes and statistics.
  • Coordinated with end-users for their work support and work on component testing.
  • Worked on EHP 6 upgrade for SAP system landscape and perform the testing of the reports and BI configuration during the post upgraded period.
  • Participated in monthly SAP maintenance activities for BW system for Reorg and Run stat etc.
  • Worked on data ware house, ETL and software development methodologies.
  • Worked on BW archiving and creation of archiving object.
  • Was an active contributor in the Proof of concept on SAP HANA . Worked as a HANA modeller.
  • Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Worked on integration with backend SAP SoH for data extraction and process chain design.
  • Loaded Data into the SAP HANA Database using SLT Replication and BODS. Bringing Data from ECC, Oracle and Flat files, also implemented ABAP Data Flows in BODS.

Confidential, Michigan

SAP-BI/BW Senior Consultant

Environment: (with skill versions)

Software: SAP-BI 7.0, BEx

Application Areas: SRM

Responsibilities:

  • Working on BI deliverables for SRM application area.
  • Working on BW data model designing for new requirements.
  • Translate business requirements into a technical design document.
  • Working on the reporting requirements related to Shopping Cart, Spend analysis Report, Purchasing Report etc.
  • The reports are based out of Bex queries.
  • Worked with BEx Query Designer, Calculated & Restricted Key Figures, RRI (Jump Target), Conditions, Exceptions, Infoset Queries, Queries on Multi Providers, BEx query performance issue.
  • Validate the reports in old version (BW 3.5) with the upgraded version (BW 7.0).
  • Work extensively on BI related ABAP work e.g. Start routine, End routine based on the business logic.
  • Perform unit testing, System integration testing for the deliverables.

Confidential

SAP-BI/BW Senior Consultant

Environment: (with skill versions)

Software: SAP-BI 7.3, BOBJ 4.0

Application Areas: CRB, FICA, FI, CO, Device Management, Billing, ISU-Water Utility

Responsibilities:

  • Worked on deliveries related to configuration.
  • Worked on BW data model designing for new requirements.
  • Define the data model architecture for the sales statistics cube so that the user can check the data for the consumption of water or leak based on the water system (PWSID and PWS Name).
  • Design the solution with respect to BI process.
  • The reports are based out of Bex queries and Business Objects (WebI, Crystal Reports etc.).
  • Developed WebI Reports, Universes on top of Multi providers and on top of BW Query’s.
  • Rationalize and optimize business intelligence products.
  • Develop and Enhance business intelligence products based off demand priorities.
  • Monitor and address system changes affecting business intelligence products
  • Respond to and mitigate business intelligence products incidents and problems and Recommend improvements.
  • Developing Crystal Reports on top of BW Query and Multi providers.
  • Completed data quality management using information steward and did data profiling.
  • Work extensively on Start routine, End routine and enhancing the extractor to achieve the business logic.
  • Perform unit testing, System integration testing for the deliverables.
  • Worked on transporting deliverables to quality and later on production system.
  • Support End users during walkthrough sessions and Work on component testing.

Confidential, NY

SAP-BI/BW Senior Consultant

Environment: (with skill versions)

Software: SAP-BI 7.3, BOBJ 3.0, QlikView

Application Areas: BI Informatics Sales

Responsibilities:

  • Work on deliveries related to configuration.
  • Work on BW data model designing for new requirements.
  • Define the data model architecture for the Re-alignment process which consists of seven modules: Alignment Control, Prescriber Universe, Product Master, Zip to Territory, Deciles and Ratings, Shared Database and Target Panel. The Data here is coming from/extract from the Flat File sources (IMS, SAD and CRM).
  • Help the Business Analyst (Solution Architect) to design the solution with respect to BI process.
  • The reports are based out of Bex queries, Business Objects and QlikView.
  • Developed WebI Reports, Universes on top of Multi providers and on top of BW Query’s.
  • Work extensively on Start routine, End routine and Expert routine to convert the de-normalise structure to normalise structure to achieve the business logic.
  • Perform unit testing, System integration testing for the deliverables.
  • Work on transporting deliverables to production system.
  • Work on Production cut over and perform Dry Run on the Production system.
  • Support developers during walkthrough sessions and Work on component testing.
  • Perform post go-live support.
  • Coordinate with Offshore on the development deliverables.
  • Rationalize and optimize business intelligence products.
  • Develop and Enhance business intelligence products based off demand priorities.
  • Monitor and address system changes affecting business intelligence products
  • Respond to and mitigate business intelligence products incidents and problems and Recommend improvements.
  • Coordinate with Offshore on the development deliverables.
  • Leveraged knowledge of data ware house, ETL and software development methodologies to contribute to the overall planning by recommending approaches and developing timelines

Confidential, PA

SAP-BI Lead

Environment: Software: SAP-BI 7.3, BOBJ 3.1/4.0, Tableau

Application Areas: HCM, FI, CO, MM, SD, APO, SRM

Responsibilities:

  • Work on deliveries related to configuration, Enhancements and defects.
  • Work on BW data model designing for new reporting requirements.
  • Define the data model architecture to extract the LOC sales data from 3 rd party system through XI/PI process and load the data into BI system. Then extract the data to load the APO system from BI to populate the Planning Book and later load the Planning book data to BW to generate different Reports (SNP Audit Report, Audit Comparison Report, Global Sales Report, Product Run Rate Report etc.) to compare APO forecasted sales with ECC Sales.
  • Worked on building financial reports and customization of financial extractors (GL/AR/AP).
  • Working to the small enhancement on the HR reports of Employee headcount and Personal Action, Personal Development areas.
  • Work on technical migration from 3.5 to 7.0 and then upgrade to 7.3
  • The reports are based out of both Bex queries and Business Objects (Web-intelligence Report).
  • Installing, configuring and administering Business Objects XI 3.1 development and production environments and establish and maintain connectivity with SAP data source & Upgraded to latest patch Level SP3.
  • Installed and Configured Crystal Reports 2008 SP3, Xcelsius 2008 SP3,Live Office 3.1,BO Client tools and Integrated with SAP Source.
  • Coordination of security requirements and user administration, rights and user groups supporting as per the client requirement (through CMC).
  • Developed WebI Reports, Universes on top of Multi providers and on top of BW Query’s.
  • Developing Crystal Reports on top of BW Query and Multi providers.
  • Work on Universe creation based on Bex queries.
  • Support developers during walkthrough sessions and Work on component testing.
  • Defect Tracking, Maintaining Development and Enhancement tracker and tracked for closure.
  • Leading SAP-BI team and assigning respective work to them.
  • Coordinate with Offshore on the development deliverables.
  • Work on SRM to extract Vendor Master Information and some minor enhancement.

Confidential, MI

SAP-BI Lead

Environment: (with skill versions)

Software: SAP-BI 7.0, BOBJ 3.1

Application Areas: SCM, Device Management (DM), TA, QM, CRM, FICA, HCM, FI, CO, Billing, ISU-Electric & Gas Utility

Responsibilities:

  • Leading SAP-BI team and assigning respective work to them.
  • Work on deliveries related to configuration, change request and defects.
  • Work on BW data model designing for new reporting requirements.
  • Created Web-intelligence (WebI) report as a final outcome for the reporting requirement.
  • Installing, configuring and administering Business Objects XI 3.1 development and production environments and establish and maintain connectivity with SAP data source & Upgraded to latest patch Level SP3.
  • Installed and Configured Crystal Reports 2008 SP3, Xcelsius 2008 SP3,Live Office 3.1,BO Client tools and Integrated with SAP Source.
  • Coordination of security requirements and user administration, rights and user groups supporting as per the client requirement (through CMC).
  • Developed WebI Reports, Universes on top of Multi providers and on top of BW Query’s.
  • Developing Crystal Reports on top of BW Query and Multi providers.
  • Worked as BI architect for the developing the new reports on Order Business Rule Projects, Sales Stat Project, Gas Leak project etc. to derive the resultant output.
  • Support developers during walkthrough sessions and Work on component testing.
  • Preparation of Daily Status Report and Maintaining Quality Documents.
  • Extracted the Customer data from CRM.
  • Defect Tracking, Maintaining RIA log and tracked for closure.
  • Participate in Customer Meetings and update to Offshore.
  • Extracted data from Oracle Database to BW cube through BODS for Safety and Energy Optimization area.
  • Was an active contributor during the implementation on SAP HANA . Worked as a HANA modeller.
  • Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
  • Loading Data into the SAP HANA Database using SLT and BODS. Bringing Data from ECC, Oracle and Flat files, also implemented ABAP Data Flows in BODS.
  • Extracted Data from all the Relational Databases including oracle, Microsoft SQL server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
  • Worked on data ware house, ETL and software development methodologies.
  • Rationalize and optimize business intelligence products.
  • Develop and Enhance business intelligence products based off demand priorities.
  • Monitor and address system changes affecting business intelligence products
  • Respond to and mitigate business intelligence products incidents and problems and Recommend improvements.

Confidential, MA

SAP-BI Lead

Environment: (with skill versions)

Software: SAP-BI 7.3, BOBJ 3.1/4.0

Application Areas: MM, SD, FI, CO, PS, SCM and SRM

Responsibilities:

  • Leading SAP-BI team and assigning respective work to them.
  • Preparation of Technical Design, Development Unit & Testing.
  • The overall reporting development is in Business Object through Web-intelligence (WebI) report for the dynamic reports and Crystal Reports for the static Reports.
  • To understand the Business requirements along with Functional team, provide adhoc support, and submitting the Technical Design for review.
  • Worked with data profiling tools (SAP Information Steward 4.0) for ongoing project to understand the quality of data before loading into the SAP
  • Work on the Business content installation for the Procurement, SD, FI-GL, FI-AA, FI-AP and FI-AR areas and then enhance the design based on the business requirement.
  • Work on SAP PS (project system) development work for BW area.
  • Preparation of Daily Status Report and Maintaining Quality Documents.
  • Defect Tracking, Maintaining RIA log and tracked for closure.
  • Participate in Customer Meetings and update to Offshore.
  • Worked on Shopping Cart, Global Spend Analysis Report etc. on the SRM application.
  • Worked on Supplier Evaluation on SRM area.
  • Extracted Data from all the Relational Databases including oracle, Microsoft SQL server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
  • Worked on data ware house, ETL and software development methodologies.

Confidential

SAP-BI Lead

Environment: (with skill versions)

Software: SAP-BI 7.0, BOBJ 3.0

Application Areas: HCM, PPM, SRM, CRM, PM

Responsibilities:

  • Lead SAP-BI team and assigning respective work to them.
  • Interact with the client and understanding their requirements.
  • Adhere to entry exit criteria for all requests.
  • Perform requirement analysis and Gap analysis.
  • Manage deliveries related to configuration, change request and defects.
  • Work on enhancement and new adhoc reporting for Personal Administration, Organizational Management, Personal Development, Compensation and Benefits, CAT, Payroll etc.
  • Support developers during walkthrough sessions and component testing.
  • Conducting Functional Design Reviews.
  • Creation of Estimates for the tasks.
  • Work on Defects, Technical enhancement and Application Maintenance.
  • Used SAP Solution Manager for Issue tracking tool, to save the functional and technical design document and for Transport Management system.
  • Worked on SAP Plant Maintenance area.
  • Worked on BW enhancement on SRM side for Contract Management.
  • Worked on BO (Web-intelligence) Reports for some adhoc reporting requirements.
  • Rationalize and optimize business intelligence products.
  • Develop and Enhance business intelligence products based off demand priorities.
  • Monitor and address system changes affecting business intelligence products
  • Respond to and mitigate business intelligence products incidents and problems and Recommend improvements.

Confidential

SAP-BI Team Lead

Environment: Software: SAP-BI 7.0, BEx

Application Areas: SAP Bank Analyzer

Responsibilities:

  • Lead Offshore SAP-BI team and assigning respective work to Off-shore.
  • Provide timely response and solution to Business.
  • Worked as an architect to provide BI deliverables for Basel II Pillar II project to derive the Risk Assessment Reports, Capital Base reports and Capital Floor Reports etc.
  • Adhere to entry exit criteria for all requests.
  • Manage Capacity Planning.
  • Manage deliveries related to configuration, change request and defects.
  • Support developers during walkthrough sessions and component testing.
  • Creation of Functional Design based on the Requirement and also creation of Technical design from the Functional Design.
  • Conducting Functional Design Reviews.
  • Perform Incident management for new defects, incident, and user support.
  • Creation of Estimates for the tasks.
  • Working on Data Modeling and Reporting.
  • Worked on BW archiving and creation of archiving object.
  • Worked on enabling the cube data through BIA/BWA for aggregation.
  • Extracted Data from all the Relational Databases including oracle, Microsoft SQL server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt & .CSV files.
  • Worked on data ware house, ETL and software development methodologies.

Confidential

SAP-BI/BW Senior Consultant

Environment: Software: SAP-BI 7.0, BEx

Application Areas: MM, SD, FI

Responsibilities:

  • Creation of Functional Design based on the Requirement.
  • Conducting Functional Design Reviews.
  • Creation of Technical design from the Functional Design.
  • Understanding Client requirement and work on that.
  • Assigning work to Off-shore.
  • Creation of Estimates for the tasks.
  • Working with SAP BI 7.0 to develop the critical objects.
  • Working on Data Modeling and Reporting.
  • Enable BIA for Cube data for the aggregation and faster query response.
  • Used SAP Solution Manager Transport Management system to transport the request to Production System.
  • Worked on building financial reports in GL/AR/AP area.
  • Worked on data ware house, ETL and software development methodologies.

Hire Now