SUMMARY

• Over 15 years experience in the IT industry, with over 14 years diversified experience in SAP Business Analytics with an emphasis on analysis, design and development of business applications within SAP and Oracle environments.
• Played a key role in Business Requirement Gathering & Analysis, Design, Application Integration, Development and Testing. Successfully customized modules based on business needs and requirements
• Actively participated in Joint Application Development and significantly contributed to user interaction among the technical and business management teams
• Expertise in Business Warehouse Components Extractors, InfoObjects, InfoSources, ODS/DSO Objects, InfoCubes, Update Rules, Transfer Rules Transformation, DTP and InfoPackages
• Expertise working with SAP BW Administrator Workbench and SAP BI Data Warehousing Workbench.
• Technical - Functional consultant, proficient in customization and implementation of SAP BI/BW in versions (/ 3.5 / 7.0 / 7.2 / 7.3 / 7.4 / NetWeaver 2004/2004s, R/3 (4.6C), and ECC 5.0/6.0
• Proficient in Installing and activating Business Contents
• Worked as BI/BW Contractor and as a Consultant, Functional Analyst and a Module Leader.
• Conceptually very strong in Data Warehouse, Database, ERP (Enterprise Resource Planning)
• Effective in executing multiple tasks and assignments ahead of schedule and under budget
• Experience in Design and Development of Reports and Queries using BEx Analyzer and BEx Explorer.
• Proficient in creating stored procedures, triggers, functions and packages in Oracle and SQL and PL/SQL
• Excellent Communication Skills and Coordinated Training for End-Users and handled On Call Support to solve day-to-day BI related issues and reporting requirements.
• Very skillful in handling of Data Modeling, Customizing, Data Loading, Data Extraction, Scheduling and Monitoring of BI components
• Team lead management skills, both offshore and onshore
• Worked in a team lead in a Global Production Support environment
• Team player with good communication skills.
• Very skillful in Finance Modules (FI/CO)
• Very skillful in Logistics modules (Inventory Management, Material Management (MM), Sales and Distribution (SD))
• Very skillful in Order to Cash (O2C) and Procure to Pay (P2P)
• Played a vital key role in Business Objects (Spend Performance Management) installation, customization and resolve of a major role issue affecting reports.
• Created ABAP Dictionary Object, Elementary Search and ABAP Dictionary Search
• Enhancement of custom extractors as per the requirements using CMOD
• SAP Business Objects Web Intelligence (Webi) / Dashboard / Crystal Reports
• SAP Business Objects Analysis Edition for MS Office
• Business Objects - Data Services 4.0
• SAP Business Planning and Consolidation (BPC) - Netweaver 7.5 and 10.0 training.
• SAP Business Objects Universe Designer Tool (UDT) and Information Design Tool (IDT)
• SAP Business Object UMT
• SAP HANA Certified
• Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Experienced in SAP HANA implementation, SAP System Landscape transformation (SLT), SAP HANA data modeling using Attribute View, Analytic View and Calculation Views. Knowledge in using SAP BODS.
• Data Provisioning and replicating data from source system toHANA Database using SLT and Business Objects Data Services.

PROFESSIONAL EXPERIENCE

Confidential, LAWRENCEVILLE, GA

IT Systems Administrator

Responsibilities:

• Engaged as an SAP BI/BW Lead supporting SAP Enterprise Applications.
• Led new Business Analytics initiatives with emphasis on Indebt Analysis, Design, Development and Support of Core Business Applications
• Led every phases of testing, including Unit Testing, User Acceptance Testing, Integration Testing and Regression Testing
• Provided daily and On Call - Rotational support for the BAR team to support the Confidential County customers.
• Developed, maintain and support activities for SAP BI/BW and Business Objects based applications.
• Developed and support of appropriate data sets and applications to support Confidential County.
• Prepared RSD - Report Specification Document for requirement gathering for new or existing initiatives.
• Conducted Business Fit Gap analysis and documented business requirement and technical analysis.
• Supported the Budget Team as needed for requests relating to budget data load and fixes.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Monitored the replication process usingSAPHANAstudio andSAPLT replication serverfor transactional integrity.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Migrated standard Infocubes to In memory optimized Infocubes using migration Tool.
• Migrated standard DSO’s to In-memory optimized DSO’s using migration Tool.
• Imported the BW Models in to HANA using HANA Studio.
• Consumed HANA Models in BW by creating the Transient Providers.
• Used Information Design Tool (IDT) for creation HANA Universe for reporting
• Worked closely with the Basis Team to upgrade the BOBJ System from BO 4.0 to 4.1
• Put a proposal together to upgrade the BOBJ from BO 4.1 to 4.2
• Upgraded SAP Netweaver from SAP BW
• Acted as a BOBJ Admin by bridging the gap between the BAR Team and the Basis Team

Confidential, HARRISBURG, PA

Sr. SAP BW Consultant

Responsibilities:

• Worked closely with the end users and BA to collect requirements
• Enhancement of Budget Period field in ECC with ABAP USER EXITS, using CMOD code
• Modified existing AFY in Start Routine with the new BP code and mapped directly from the source parsed from Fund both in Update Rules and Start Routines.
• Performed data Mapping from source to all finance targets to include the new BP field
• Modified existing BW objects: Transformation, DSO, Cube and Multi Provider to accommodate the new field.
• Made changes to existing Start, End, Field Routines and Update Rules codes both in 3.x and 7.x format to accommodate the new field
• Performed data load to test for new Budget Period field
• Wrote test cases and test scripts
• Performed unit, integration and user acceptance testing
• Transported all affected BW objects across system landscape
• Experience with SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
• Performed Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0
• Experience with SAP ECC table data model and analysis
• Proficient in SAP HANA Data Modeling using Attribute View, Analytic View, and Calculation View
• Experience with SAP HANA Administration including managing schemas, data model objects, import/export content
• Experience with SAP HANA Security including User Management, Roles, and Privileges
• Wrote SAP HANA programming language SQL and SQL Script

Confidential, ATLANTA, GA

Sr. Consultant

Responsibilities:

• Responsible for SAP Business Analytics projects, overseeing the initiatives of new SAP BI/BW implementations.
• Engaging both the onsite and the offshore resources by leading the efforts in the area of documentation, design and implementation of Enterprise wide BI reporting solutions.
• Documented, designed and implementation of Enterprise wide BI reporting solutions.
• Worked closely with business analysts in refining requirements from the end users and helping with the Fit-Gap Analysis. Coordinated efforts of onsite resources
• Worked closely with the Business Analysts in refining the Functional Specifications Documents
• Wrote Functional Specification Documents (FSD)
• Wrote Modular Design Document (MDD) for financial reports
• Wrote Modular Design Document (MDD) for Procurement reports
• Provided all the logics needed for data enhancements and data transformation from SAP ECC to SAP BW
• Built SAP Business Objects Web Intelligence 4.1 (Webi) reports for the procurement and finance team
• Worked on SAP BW 7.3 InfoProviders
• Built SAP Business Objects Dashboard 4.1 for the finance team
• Participated in installation of Business Object (Spend Performance Management 3.0)
• Configured Business Object (SPM 3.0)
• Helped resolved Basis team issue by uploading 2 missing roles in Spend Performance Management (SPM)
• Mapped data from Oracle legacy system to SAP target system
• Participate in identifying gaps from source system to the target system
• Coordinated test and development team activities with respect to defect resolution management
• Team Lead - Confidential AMS Global BW Production Support
• Supported production data loads
• Monitored Process Chain on a daily basis
• Experience in ticket handling through Service Now and change management process
• Effective leader in management of SLA’s for different priorities of tickets.
• Supported user’s workbooks through tickets raised by the help desk
• Upgraded BIAR file from 3.1 to 4.1
• On call rotation supporting Global BW users
• Manage offshore BW team on a global BW support

Confidential, ATLANTA, GA

Principal Consultant

Responsibilities:

• Validated Workbook MD data (Plan/Actual/Last Year) by reconciling BI Production data
• Modified BW objects: DSO’s, Infocubes, Multiproviders and Transformations
• Modified existing BW queries via Query Designer
• Supported workbook users with different issues
• Built workbooks, MD Reports containing five consolidated reports
• Used V-Lookups and Index to refine reports connected to BW server
• Wrote user manual for running consolidated reports
• Coordinated meetings between offshore and onsite teams on a weekly basis.

Confidential, ATLANTA, GA

Principal Consultant

Responsibilities:

• Design of both functional and technical specifications
• Development of Cockpit objects for query analysis
• Wrote and execute User Acceptance Testing (UAT)
• Data Mapping of legacy reports with SAP report
• Created queries in Query Designer and deployed to the Portal.
• Create CKF and RKF as needed
• Maintain and administer Business Intelligence Accelerator (BIA)
• Maintain Admin Cockpit for better performance of the cubes and queries
• Adopt performance on all queries.
• Day to day interaction with the end users collecting information and to further discuss any issues relating to the query performance
• Designed user’s manual for training.
• Designed a Xcelsius dashboard using corporate excel data and SAP BI query
• Wrote ABAP USER EXITS for enhancement of datasource in ECC
• Wrote START ROUTINES and STANDARD for data manipulation
• Analysis of Hyperion reports
• Data Mapping of legacy reports with SAP report
• Created BeX queries to match Hyperion reports as close a possible
• Create Calculated Key Figures (CKF) and Restricted Key Figures (RKF) as needed
• Maintenance of Hierarchies Structures
• Improve performance on all queries on a regular basis.
• Used Query Designer to re-design queries as needed
• Used V-Lookup and Cell Reference for Data Validation in Workbooks
• Conducted Business Fit Gap Analysis on a new NetWeaver 2004s (BI 7.0) implementation.
• Performed migration of the clients Reports from Legacy System to SAP BI.
• Active interactions with the end user on day to day basis to better understand the client’s need and issues.
• Performed Data Mapping from source to target of the replicated Datasource in BI using Transformation.
• Created Queries using the BEx Analyzer and publishing the queries to the user’s role.
• Created Process Chain for BI objects for periodic loads.
• Created InfoCube for replicated DataSource from R/3 and ECC systems
• Experience in SAP related ERP/OLTP and ETL/OLAP systems
• Built Multi-Providers for InfoCubes and a Master Data for the Reporting Analysis.
• Performed Unit and Integrated Testing.
• Validated ECCS Reports - FI, PS, HCM and PM data against BI Master Data and InfoProviders
• Validated PS Budget Planning - Actuals
• In dept Data Validation with the functional consultant and end users.
• Wrote User/Training Manual for the client to use in support of the POST GO-LIFE SUPPORT.
• Created and scheduled InfoPackages for Delta Initialization and Delta Load into InfoCubes via PSA and DSO objects
• Developed custom BEx Queries against InfoCube and ODS objects using BEx Analyzer
• Executed all the required Post Installation steps after completion of Upgrade.
• Developed new BEx Queries, workbooks based on the different InfoProviders
• Organized meetings and sessions for Knowledge Transfer (KT) to the end users
• Produced a POC on a Dashboard using Xcelsius 2008 to consume SAP NW BI Query (Xcelsius Designer 2008 SP2 / SAP EHP1 for SAP Netweaver 7.01 SP5)

Environment: SAP BW 3.5 / 7.0, ECC 6.0 - R/3 4.7, FI, WAD, BEx Analyzer, Query Designer, BOE XI 3.1, Xcelsius Enterprise 2008

Confidential, ELMHURST, IL

Senior SAP BW ETL & Query Developer

Responsibilities:

• Analyzed business requirements and translated them into Multi-Dimensional Data Models using star schema
• Involved in the full cycle of development and implementation of SAP BI/BW
• Activated Business Content InfoSources, InfoCubes, Roles, Queries, InfoObjects and customized Business Content to meet business requirements
• Created Multi-Providers for specific queries
• Incorporated transfer rules for InfoCubes and customized update rules
• Extended standard Business Contents based on client requirements
• Created GL and Vendor Transactional InfoCubes for planning purposes
• Worked extensively with Business Content for modified existing Sales and Financial InfoCubes to meet the End-User requirements
• Involved in creation of Datasource, InfoSources, PSA for Data extraction, transformation and loading from SAP R/3 system to SAP BI/BW
• Designed a Multi-Providers from the existing basic GL and Vendor cubes for reporting purposes

Environment: SAP BW 3.1, SAP R/3 4.6C, ECC 5.0, BEx Analyzer, Query Designer

Confidential, HOUSTON TX

SAP BW Techno Functional Consultant

Responsibilities:

• Conducted Business Fit Gap analysis and Documented business requirement and technical analysis
• Extensively involved in customizing and creating new queries in SAP BW environment on existing INFOCUBES.
• Customization involved adding new Restricted Key Figures (RKF), Calculated Key Figures (CKF) and creating Structures in the Query Designer
• Enhanced the existing BW InfoCubes
• Scheduled InfoPackages to load data into the BW InfoCube via PSA, and also worked with the InfoCube Maintenance functions like Reconstructing Requests
• Wrote Transfer Rules and Update Rules
• Used BW Content Extractors to extract data from SAP R/3 to BW. Also used Generic Extractor in R/3 Data Extraction
• Created and modified InfoSources for Master Data (Attribute and Text) and Transaction Data
• Created, modified and activated Transfer Rules and maintained Communication Structures
• Created and scheduled InfoPackages for Delta Initialization and Delta Load into InfoCubes via PSA and ODS objects
• Set up Update Rules for InfoCube and uploaded data into the Infocube
• Developed ODS objects to load Transaction Data from Infosource and defined Update Rules
• Loaded Transaction Data into PSA and updated data from PSA to ODS and activated ODS for reporting
• Schedule Infopackages to load regularly and also automatically triggering the Attribute Change Run
• Developed Reports in BEX Analyzer and publishing it on the Web using BW Templates
• Developed custom BEx Queries against InfoCube and ODS objects using BEx Analyzer
• Created Drill-Down Reports through queries from summarized InfoCube report to detail ODS data

Environment: SAP BW 3.0B, SAP R/3 4.6C, BEx Analyzer, Query Designer

Confidential, ATLANTA, GA

SAP BW Consultant

Responsibilities:

• Developed ODS object to load transaction data from Infosource and defined update rules.
• Loaded transactional data into PSA and updated data from PSA to ODS and activated ODS for reporting.
• Created InfoPackage to load regularly and also automatically triggering the attribute change run.
• Developed around 40 custom BEx Queries against the InfoCubes and ODS objects using BEx Analyzer.
• Extensively used calculated and restricted Key Figures. Created variables for the queries.
• Created Drill through Queries from summarized InfoCube report to detail ODS data.
• Publish reports on the Web using BW Templates.

Environment: SAP BW 3.0B, SAP R/3 4.6C, BEx Analyzer, Query Designer

Confidential, ATLANTA, GA

SAP BW Analyst/Developer

Responsibilities:

• Functional Study of SD, FICO areas and did analysis for the reporting and analysis requirements.
• Data Extraction, design and development of Infocubes, ODS objects with respect to the business requirements for SD and FICO areas
• Day to Day Management of Info Providers
• Resolved and implement BW Query issues (Day to Day) and change requests.
• Scheduled and performance monitor periodic data loads from SAP R/3 to BW. Advise delta loading and ODS Loading process.
• BEx reporting (Structures, Reports, Adhoc, Advising query writers in performance issues, Quality approaches, enhancements).
• Data modeling in BW (InfoSources, InfoObjects, ODS, Cubes, Transfer/Update rules, process chains).
• Create variables for BW Queries.

Environment: SAP BW 3.0B, SAP R/3 4.6C, BEx Analyzer, Query Designer