SUMMARY:

• Over 14 years in SAP functional and technical domain. His consulting experience includes working in diverse business and technological applications.
• Good expertise in Data Warehousing wif well over 12 years in SAP BW and over 6 years in various components of BOBJ suite.
• Expert in core competencies and unique expertise and can provide one stop solutions in the area of SAP HANA, SAP BW, SAP BOBJ, BODS and various aspects of Data Warehousing along wif Data Migration.
• Successful Project Manager and took many Lead positions in past projects and certified PMP (Project Management Professional).
• Trained in Business Planning & Consolidation (BPC) and also in Integrated Planning (IP). He is also a certified Six Sigma Black Belt. Wif exposure to Predictive Analytics and one stop go to person for solutions.
• Strong analytical and business background along wif diverse system understanding, allows him to engage wif the highest levels of the client organization to deploy strategic, operational and technical solutions.
• SAP Certified Consultant for BW and is also a Certified Business Objects Professional.

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/BI/BO HANA EXPERT

Responsibilities:

• Studied and proposed a solution to data issues resulting from incorrect data mapping to derive and report a set of financial KPIs.
• Designed an ETL process to leverage standard extractors in ECC using ODP.
• Designed a new financial datamart for the client to be produced out of data extracted from ECC.
• Defined a reporting strategy wif data from the financial datamart wif multiple reports and self - service approach.
• Assisted in creating training material and defined a training strategy for self-service approach.

SAP BW/BI/BO HANA EXPERT

Confidential

Responsibilities:

• Advised Strategy, roadmap and best practices to achieve a successful deployment of brand new Business Objects reporting solution.
• Defined approach for promotion management, security frame work, report delivery mechanism and training for the users.
• Oversaw development of prototypes to showcase the features of the various tools BOBJ reporting suite.
• Developed a blueprint and assisted in preparing a project plan to realize the design.

Confidential

SAP HANA Solution Architect

Responsibilities:

• Delivered Sales Analytics solution using SAP HANA, integrating data from SAP and non-SAP, involving both SLT and Data Services for Data Provisioning. Reports delivered using BOBJ Toolsets. Work involved functional understanding, current pain points of customer, and deep understanding of “to be” modeled developed in HANA using Attribute, Analytic and Calculation Models. Both SQL and CE functions were used to skim mammoth data.
• In another HANA Project, developed a POC for “BW on HANA” by replacing the underlying database to HANA.
• Mentored team by researching and implementing several SAP notes to resolve issues as and when needed.

Confidential

BI Analytics Lead

Responsibilities:

• Central point of contact for overall execution, control and communication of the project guiding 18 resources from the client and consulting team in a matrix client organization.
• Integrated the heterogeneous environment of client legacy systems, Siebel CRM, SAP Data Services and SAP BW for over all reporting using Business Object toolset to deliver solution for business critical KPI’s and operational reporting.
• Anchored the project since its inception, defining overall BI strategy, business blueprinting, fit-gap analysis, security mapping, end-user training and two successive phased “Go-Lives” covering about 500 plus end-users.
• Deployed a Mobility landscape, making reports available on Mobile devices.
• Advised the client around future data strategy and governance and HANA roadmap.

Confidential

Solution Architect

Technical Environment: SAP NW 2004s, BOBJ XI 4.0, Interactive Analysis, SAP Business Objects Dashboards, Data Services

Responsibilities:

• Engaged as architect and project lead and helped the deployment of a Business Objects solution on top of SAP BW for business critical reporting.
• Established an adhoc environment for client for future analysis and reporting using Interactive Analysis.
• Displayed business critical KPI’s using SAP Business Objects Dashboards.
• Advised a strategy on Data Profiling, cleansing, Governance and a security strategy and also suggested a framework.
• Supervised building a training plan and participated in training sets of users.

Confidential

Solution Architect

Technical Environment: SAP ECC 6.0, SAP NW 2004s EhP1, SAP FI/CO, SCM, HCM, BOBJ XI 3.1, Crystal Reports 2008, WebI, SAP Business Objects Integration Kit 3.1 and Xcelsius 2008, Advanced Analysis 3.0, Business Objects Explorer and Life Cycle Manager.

Responsibilities:

• Participated in discussions wif management to develop implementation and maintenance strategies, processes, procedures and best practices for Business Objects Suite of products.
• Demonstrated the capabilities of different products of BO Suite, building prototypes.
• Presented a solution for the needs wif using products of BO suite.
• Created and presented a high-level implementation roadmap for the above solutions.
• Detailed the roadmap verifying the approach and strategy.
• Designed a best practice BO security solution working wif a recommended framework.
• Assisted in upgrading and configuring BO SW to the latest service pack and fixpacks as needed in order to support the above solutions.
• Assisted in developing test plans and test scripts to validate the solutions and components implemented.
• Assisted in developing a training plan and documentation of the training needs.
• Was the technical GO TO person on the team and trained co-workers.
• Assisted in migrating elements to production using LCM.
• Assisted in integrating the BO reports into the internal portal for access to executives.
• Researched technical issues and resolved those applying necessary SAP notes.
• Assisted in investigating and resolving performance issues.
• Interacted wif SAP in communicating product errors and get fixes issued.

Confidential

Solution Architect

Technical Environment: BOBJ XI 3.1, Crystal Reports 2008, WebI, Xcelsius, SQL Server 2008

Responsibilities:

• Provided vision, expertise and technology-based solutions in long range planning in the area of systems architecture.
• Interviewed personnel, gatheird requirements, drafted and presented a roadmap wif proposed procedures, practices and standards.
• Recommended new initiatives conforming to the firm's long term strategic goals.
• Established good working relationships wif peers and outside organizations.
• Assisted in sizing the environment for Business Objects and made recommendations of Hardware and Software.
• Assisted in installing the software on a sandbox, demonstrated the features and capabilities of Business Objects.

Confidential

BI Consultant

Technical Environment: SAP ECC 6.0, SAP NW 2004s, SAP FI/CO, HCM, BOBJ XI 3.1, Crystal Reports 2008, WebI, SAP Business Objects Integration Kit 3.1 and Xcelsius 2008.

Responsibilities:

• Participated in multiple JAD sessions to gather and document the requirements to develop a solution to produce a Management Cockpit involving multiple dashboards and analytical reports.
• Involved in creating a project plan to outline schedule and resources.
• Involved in building universes from SAP BW queries.
• Built several WebI reports using universes.
• Built multiple dashboards to monitor specific KPIs for specific segments and linked the dashboards to the main cockpit dashboard so as to monitor all from one.
• Other responsibilities included Project Management wifin BI space including resource management and status reporting.

Confidential

BI Lead Consultant

Technical Environment: BOBJ XI 3.1, Crystal Reports 2008, WebI, Xcelsius 2008, SAP BOBJ Integration Kit 3.1, SAP ECC 6.0, SAP NW 2004s, SAP FI/CO

Responsibilities:

• Participated in project planning sessions to analyze business requirements and outline the proposed solution.
• Assisted in installing Business Objects software. Assisted in resolving issues around SSO.
• Built BW queries as needed from several info proviers.
• Build the new universes as per the user requirements from SAP BW queries.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Generated Reports from WebI using the Universe as the main Data provider and also using the personal data files provided by the users.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis.
• Created different reports containing charts showing revenue and operating income by different divisions.
• Created Dashboards for management using xcelsius to monitor specific metrics and planning.
• Using QaaWs pulled data from SAP data providers an produced dashboards for various needs.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Assisted in Implementing Security Features of Business Objects like row level, object level and report level.
• Assiste in providing the security access management by creating users/groups and folders.
• Provided training for end users for generating their own reports using WebI, using Crystal reports and working through Xcelsius dashboards.

Confidential

BI Architect

Technical Environment: BOBJ XI 3.0, Crystal Xcelsius 2008, Crystal Reports 2008, SAP Business Objects Integration Kit, SAP ECC 6.0, SAP NW 2004s, SAP FI/CO, SCM, SAP PS, SAP XI, SAP HR

Responsibilities:

• Drove the BI data architecture for the Project Department’s project implementation.
• Interviewed the client and challenged the assumptions while helping them to understand the business specific practices wif regard to SAP.
• Mapped the business processes to existing BI content and recorded the gaps.
• Presented and successfully defended the design and configuration.
• Drove the technical interfaces wif Development teams
• Assisted in designing a landscape and installing Business objects software for front end.
• Assisted in User Administration, Role Mapping, Migration of user and roles.
• Assisted in setting up business objects security at group level/user-level and Object Level.
• Assisted in Universe designing and report formats. Developed and maintained universes wif necessary classes and objects. Assisted in building Adhoc reports using WebI.
• Using Crystal Reports created several formatted reports using custom functions, crosstabs and sub reports from raw SAP BI queries.
• Assisted in building Dashboard reports for higher management using Crystal Xcelsius.
• Trained co-workers and assisted in documenting the solution.

Confidential

BI-IP Consultant

Technical Environment: SAP ECC 6.0, SAP NW 2004s, SAP FI/CO, SCM, CRM5.0, SAP PS, SAP QM

Responsibilities:

• Participated in Technical Implementation of IP from the functional specifications.
• Created a Real time Data Provider ZIPCO P02 for planning from the Actual DataProvier ZCOOM C02.
• Created a Multi-provider ZIPCO M02 for reporting plan/actual.
• Created aggregation levels based on the need on both ZIPCO P02 and ZIPCO M02.
• Worked extensively on creating filters, Variables, Conditions and Planning sequences.
• Worked extensively on creating Fox Formulae for mass data manipulation to assist planning.
• Created multiple input enabled queries needed for planning and formatted reports wif workbooks for specific planning sequences.
• Created web planning applications for quarterly and annual planning.
• Created process chains for specific Data loading requirements.
• Assisted in resolved several problems, working closely wif Basis, by implementing service packs and OSS notes.

Confidential

BI Lead

Technical Environment: SAP ECC 6.0, SAP NW 2004s, SAP FI/CO, SCM, SRM 5.0, SAP HR . SAP Solution Manager

Responsibilities:

• Acted as liasion between State and Implementation Partner. Assisted in devloping project plan wif deliverables from reporting effort.
• Gatheird all the legacy reporting requirements, segregated and prioritized the deliverables based on the business need. Assisted in developing architecture based on the fit/gap analysis and business need.
• Extensively involved in NW2004s landscape setup and assisted in installation. Assisted Basis in initial configuration like setting up source systems, checking RFc connections etc., and figuring out the right GUI to work wif.
• Resolved several problems, working closely wif Basis, by implementing service packs and OSS notes ensuring stability of the BI 7.0 system.
• Aassisted in smooth implementation of project plan collecting and compiling statuses from team members and monitoring the development effort on a weekly basis. Assisted functional teams in developing functional specifications.
• Performed Data mapping wif assistance from functional teams identifying fits and gaps. Developed technical specifications and established a development strategy.
• Migrated 3.x datasources to 7.0 to avail new features. Created tranformations and converted routines to ABAP OO.
• Acquired needed data from several sources using custom datasources as well as delivered datasources.
• Developed and assisted in development of several custom and delivered reports in functional area like FM, GM, GL, CO, AR, AP, MM and SRM. Developed complex Confidential Financial reports like Cash by Fund using the new GL account structure from the FMGLFLEX table.
• Established delivery methodology for different reports based on the usage and need, configured web delivery and implemented it using Information Broadcasting.
• Utilized Solution Manager to report and track issues.
• Assisted in developing training material for end users and performed several demonstartions of reports.

Confidential

BW Lead

Technical Environment: SAP BW 3.5, SAP R/3 4.7, SAP SEM, SAP FI/CO, SCM

Responsibilities:

• Analyzed the requirements, performed a gap analysis wif respect to the data model needs to cover Profit and Balance sheet Planning.
• Designed planning layout where sales, expenses, capital expenditure, gross profit and balance sheet are defined. Created the necessary planning Folders to suit the need.
• Defined and created required Planning Areas, Multi-Planning Areas, Planning Levels, Planning packages, Planning Layouts, Planning functions, Planning sequences and Planning folders.
• Implemented BPS planning functions like Copy, Formula,Top Down Distribution, allocation, distribution wif reference data, Currency Translation, Depreciation and Revaluation etc.,
• Created Data Slices, characteristics relationships, FOX Formulae and hierarchy variables.

Confidential

BW Consultant

Technical Environment: SAP BW 3.1, SAP R/3 4.7, SAP FI/CO, SCM

Responsibilities:

• Configured profit center accounting cubes.
• Enhanced the InfoCubes by adding custom InfoObjects to reflect modified R3 Business Process.
• Created custom info sources & Info Objects in BW and mapped them wif R/3 fields using transfer rules.
• Extensively used BEx Analyzer to build queries, queries to access data from BW data targets
• Used Aggregates for Reports Optimization
• Tested the Aggregates in development as well in production environment to check the query performance.
• Tested all the queries in Development and Production environment.
• Conducted super user training and Documentation on Best Practices for Support and maintain post go-live system

Confidential

BW Consultant

Technical Environment: SAP BW 3.1, SAP R/3 4.7, SAP FI/CO, SCM, SAP PS

Responsibilities:

• Involved in the design, development, testing and implementation of profitability reporting bringing data from FI and CO enhancing CO-PA extractors.
• Modeled and configured CO-PA cubes.
• Extracted data using R/3 and flat files as data sources. Scheduled and monitored the data loads in production.
• Created user manuals and did knowledge transfer. Trained the end users.

Confidential

BW Consultant

Technical Environment: SAP BW 3.0, SAP R/3 4.7, SAP FI/CO, SCM

Responsibilities:

• Team Lead for BW implementation for the client using ASAP methodology.
• Configured objects to deliver several analytical reports on Sales Overview to meet the business need of the customer.
• Designed process chains for master data loading, delta loading for weekly PSA deletion.
• Extensively used BEx analyzer to define queries and work books. Defined Calculated Key Figures, Restricted Key Figures, variables, filters and exceptions.
• Worked on performance tuning of queries by creating aggregates, indexing and Cube compression.

Confidential

BW Consultant

Technical Environment: SAP BW 3.0, SAP R/3 4.7, SAP FI/CO, SCM, SAP PS

Responsibilities:

• Involved in design and implementation of SAP BW using ASAP methodology.
• Installed and configured various components of business content.
• Designed, Created and maintained InfoCubes, Multi Providers, ODS, Info Objects, Info sources, Update rules & Transfer rules.
• Scheduled data extraction from SAP R/3 Source System and monitored delta loads.
• Maintained extract structures for Purchasing, Inventory, and Shopfloor Control in LO Cockpit: Enhanced extractors & activated the extract structures for the above modules.
• Created User Exit programs to accommodate additional fields in the extract structure of the Data Source.
• Created Process chains to automate the data upload taking into account all performance issues.
• Created Aggregates and Multi Providers for performance and efficient utilization of data.
• Performance tuning to improve query performance using Partitioning, Aggregation and Cube compression.
• Customization of Web reporting, web items and web templates creation using web application designer (WAD) and query designer.
• Developed reports using BEx Analyzer dat had exceptions, conditional formatting, restricted key figures and calculated key figures.

Confidential

SAP FI Consultant

Technical Environment: SAP R/3 4.6C

Responsibilities:

• Worked as a SAP team member for merger and replacement of legacy FI systems and subsystems. Project included significant Organizational Management and Business Process Re-engineering.
• Managed and handled design processes, issue resolutions, change management and resource management using ASAP methodology, ASAP Business Process, MS Project, Excel, Power Point, Visio and Word.
• Conducted business process interviews wif client personnel and summarized findings for use in business process decomposition.