SUMMARY:

• Around 12 years of extensive industry experience in software design and development on a variety of technologies including SAP HANA, SAP Analysis Office, SAP Lumira, SAP BI, SAP Business Objects, SAP ABAP, Java, Oracle and SQL server,
• Extensive knowledge in HANA modelling.
• Have worked on HANA implementation projects starting from requirement gathering, creating HANA views and report creation using SAP Lumira, SAP AO.
• Have worked on modelling various HANA calculation views based on the business requirements for operational reports like Margin Analysis, Market share report.
• Have worked extensively on converting existing SAP BW reports to HANA views for reporting using SAP AO.
• Extensive experience with SAP BW 3.5 and SAP BI.7. Involved in analysis, modeling, implementation, testing and performance tuning of SAP BI/BW applications.
• Involved in SAP BW 3.5 to BI 7.0 technical upgrade project.
• Have knowledge in Business Objects Universe building over the SAP BW info providers.
• Have good knowledge on Java programming, scripts and SQL query.
• Have been a key member in implementing full life cycle BI Project Implementations in Purchasing, Sales and Distribution and Inventory Management and have good working knowledge of LO Cockpit extractors and generic extractors.
• Performed analysis, design, development and implementation of standard/customized Info Cubes ODS Objects, multi providers for CRM, HR FICO, MM, WM and SD modules.
• Have worked in the offshore - onsite model playing the role of offshore team member and also onsite coordinator interacting with the Business Analyst for the functional requirements.
• Strong Organizational, Interpersonal and exceptional Customer Service skills.
• Self-motivated, result oriented and customer-focused with proven ability to understand complex architecture and convey in a way that meets the needs of both business and technical groups

TECHNICAL SKILLS:

ERP Package: SAP Net Weaver 2004s, SAP R/3 4.6,4.7, ECC 6.0

SAP: SAP BI 7.0, BW 3.5, SAP HANA

Reporting Tools: BEx Query Designer, BEx Analyzer, Workbooks, Web Application Designer, WEBI, Lumira, SAP Analysis office

Functional Module: CRM, HR FICO, MM, WM and SD modules.

Languages/Scripts: ABAP/4, PL/SQL, C, C++, Java,HTML

Databases: Oracle, MS SQL Server, MS Access

Operating Systems: Windows 95/98/NT/2000/XP/7, Windows 2000/2003 Server

PROFESSIONAL EXPERIENCE:

Confidential, Milpitas

HANA Consultant (Modeler)

Responsibilities:

• Requirement gathering and analysis of Global sales, service and marketing data for market share metrics
• Discussion with business user to understand the metrics needed to report the revenue and market share for each tool.
• Analysis of the CRM source system tables to integrate the metrics.
• Preparation of technical specification to implement the business requirements.
• Data replication using SAP SLT system for replicating CRM source data to SAP HANA.
• HANA modelling for Creation of Calculation views to include the logic of various metrics.
• Creation of various calculations/formula to derive the metrics.
• Worked with business users to make them familiar with various attributes and measures - calculations/formula created for the reports
• Help business users create AO report on the HANA calculation view created for reporting.

Environment: SAP HANA, CRM, SAP Analysis Office

Confidential, Milpitas

HANA Consultant

Responsibilities:

• Analysis of existing BW and BO reports to understand the existing metrics and underlying data.
• Requirement gathering and analysis of Global sales, service and marketing data for additional metrics.
• Mapping of the BW metrics data with existing HANA views data.
• Analysis of the CRM source system tables to integrate the metrics with backend data.
• Mapping of CRM table data with BW metrics.
• Discussion with business user to map the gap between the BW and CRM data to build the metrics.
• Preparation of technical specification to implement the business requirements.
• Data replication using SAP SLT system for replicating CRM source data to SAP HANA.
• Creation of HANA Attributes views, Analytical views and Calculation views to include the logic of various metrics similar to BW reports.
• Worked with business users for testing the AO reports
• Involved in bug fixes and enhancements based on user testing.
• Worked on conversion of SAP BW financial reports like Margin Analysis to recreate in HANA calculation views.
• Worked on other operational reports for Confidential service to convert to HANA calculation views to be used by/AO reports.
• Worked on creating HANA calculation views for PRT report for showing the DHL data metrics.

Environment: SAP HANA, CRM, SAP Analysis Office

Confidential, San Ramon

SAP BI Consultant

Responsibilities:

• Requirement analysis of the new enhancement for HR, FI and WM team.
• Discussion with respective team to understand the requirements.
• Analysis of the BW system to integrate the new requirement.
• Enhancement of HR reports related to CATS, Compensation, Payroll, Requisitions.
• Enhancement and new development for certain open issues.
• Enhancement to bring few additional fields into from ECC source system.
• Enhancement of FI cost base analysis report.
• Bug fixes for WM Leakage summary report to report the details related to Leakage.
• Development like creation of info object, cubes, multi provider for bug fixing.
• Modification of the existing transformation, start routine, end routine and expert routine logic to fix the issue.
• Interaction with the BO team to update the Universe and Webi reports with new objects.

Environment: SAP BI.7, ECC4.6

Confidential, San Ramon

SAP BI Consultant

Responsibilities:

• Requirements gathering and analysis of Legacy HR data.
• Discussion with Legacy system team members to understand the data and functionality requirement.
• Analysis of existing SAP HR cubes and reports to integrate the Legacy data into SAP HR data.
• Preparation of technical specification to implement the business requirements.
• Preparation of file format to export the legacy data from the legacy system.
• Creation of file extractor to extract and load the legacy data into SAP BW system.
• Creation of DSO and Info cube to load and store legacy data into SAP BW system
• Update the existing multi providers and Bex reports to report both new legacy data and existing SAP HR data in the same reports.
• Interact with BO team to update universe and BO reports to include new objects related to Legacy data.

Environment: SAP BI.7, ECC4.6, Legacy System, BO4.0

Confidential, Milpitas

SAP HANA Consultant

Responsibilities:

• Requirement gathering and analysis of Confidential sales, service and marketing metrics.
• Discussion with Business users to understand the requirement.
• Analysis of the CRM source system tables to integrate the new requirement.
• Preparation of technical specification to implement the business requirements.
• Data replication using SAP SLT system for replicating CRM source data to SAP HANA.
• Creation of HANA Attributes views, Analytical views and Calculation views to include the logic of various metrics like Tool metrics, Contract details.
• Creation of Lumira reports for the Confidential business users.
• Worked with business users for testing the Lumira reports
• Involved in bug fixes and enhancements based on user testing.

Environment: SAP HANA, CRM.SAP Lumira

Confidential, Milpitas

SAP HANA Consultant

Responsibilities:

• Requirement gathering and analysis of Internal Audit reports.
• Discussion with Business users to understand the manual audit process.
• Design discussion for the automation of manual audit process.
• Analysis of the ECC source system tables to integrate the new requirement.
• Preparation of technical specification to implement the business requirements.
• Data replication using SAP SLT system for replicating ECC source data to SAP HANA.
• Replication of ECC tables like payment tables, Vendor master, customer master.
• Creation of HANA Attributes views, Analytical views and Calculation views to include the logic for the audit reports.
• Worked closely with the Webi team for the creation of universe on SAP HANA views and Webi reports.
• Worked with business users and Webi team for testing.
• Involved in bug fixes and enhancements based on user testing.

Environment: SAP HANA, ECC4.6, BO 4.0

Confidential, San Jose

Business Analyst

Responsibilities:

• Discussion with Business users to understand the manual process.
• Preparation of BRD document based on the requirement.
• Discussion with functional team and assist for the preparation of functional specification.
• Coordinate with business users and functional team for the clarification and open questions.
• Coordinate with Business users and functional team for the functional spec reviews.
• Worked with business users for the test scripts preparation based on the requirement.
• Coordinate testing and signoff based on the test scripts Worked closely with the Webi team for the creation of universe on SAP HANA views and Webi reports.
• Worked with business users and Webi team for testing.
• Involved in bug fixes and enhancements based on user testing.

Environment: Cognos, OBIEE

Confidential, San Francisco

SAP BI Lead

Responsibilities:

• Requirement analysis of the new enhancement for Hyperion team.
• Discussion with Hyperion team to understand the requirement and BW was the source data for Hyperion.
• Analysis of the BW system to integrate the new requirement..
• Analysis of the underlying GL balance and COPA BW cubes, DSO and data source to understand the flow of data and root cause.
• Enhancement and new development for certain open issues.
• Enhancement to bring few additional fields into from ECC source system.
• Development like creation of info object, cubes, multi provider for bug fixing..
• Modification of the existing transformation, start routine, end routine and expert routine logic to fix the issue.
• Creation of Bex queries for creating a dashboard to reconcile ECC and BW data, as BW was the source of data for upward systems.
• Creation of BW Analysis process designer for the reconciliation reports
• Creation of variables calculated key figures, restricted key figures, formulas for the reconciliation reports.

Environment: SAP BI.7, ECC4.6

Confidential, Milpitas

SAP BI Lead

Responsibilities:

• Requirement analysis of the new enhancement for Confidential dashboard
• Discussion with Business to understand the requirement.
• Analysis of the BW system to integrate the new requirement.
• Analysis of the BW reports to understand the problem.
• Analysis of the underlying BW cubes, DSO and data source to understand the flow of data and root cause.
• Analysis of the data and understanding of the domain to get the relevant data for the metrics.
• Understanding of the business process business regarding the services.
• Analysis of the cubes and DSO to understand the complete data flow from the ECC or CRM source.
• Involving in requirement gathering for new BW reports.
• Involving in the bug fixing for the open issues with current BW reports.
• Enhancement and new development for certain open issues.
• Enhancement to bring few additional fields into from source system.
• Development like creation of info object, cubes, multi provider for bug fixing.
• Modification of the existing transformation, start routine, end routine and expert routine logic to fix the issue.
• Creation of variables calculated key figures, restricted key figures, formulas for the attrition report.
• Creation of new Bex queries and workbooks.

Environment: SAP BI.7, ECC4.6, CRM, BOBJ 4.1

Confidential, Milpitas

BI Senior Consultant

Responsibilities:

• Involved in User requirements gathering, Business Blueprint, Realization and Testing Phases.
• Requirement analysis of the for Confidential dashboard
• Discussion with Business to understand the requirement.
• Creation of functional and technical spec detailing the requirement.
• Performed analysis, design, development and implementation of standard/customized Info Cubes ODS Objects, multi providers of all service related providers.
• Analysis of the BW system to integrate the new requirement.
• Analysis of the BW reports to understand the problem.
• Analysis of the underlying BW cubes, DSO and data source to understand the flow of data and root cause.
• Analysis of the data and understanding of the domain to get the relevant data for the metrics.
• Understanding of the business process business regarding the services.
• Design Discussions with the KT BW team.
• Analysis of the cubes and DSO to understand the complete data flow from the ECC or CRM source.
• Involving in requirement gathering for new dashboard.
• Enhancement to bring few additional fields into from source system.
• Development like creation of info object, cubes, multi provider for bug fixing.
• Creation of the existing transformation, start routine, end routine and expert routine logic.
• Involved in multi-dimensional data modeling, developing Info Objects, Info Cubes, Aggregates, ODS objects, PSA, Data Source (OLTP Source), Info Source, Communications Structure, Transfer Structure, Multi Providers, and customizing standard Business Content.
• Created Data transfer process to execute the transformations and load the data to the target info providers.
• Scheduling of Extraction Jobs, Monitoring of Transfer and Update for data Loads, Monitoring of Status display and Load Statistics for Update Process.
• Analyzed the business critical extractors for performance optimization.
• Performed optimization, analysis and tuning of the BW environment to improve data load time and query response time.
• Used aggregates where required in cubes to make the reports run faster.
• Performed compression of cubes to improve report performance.

Environment: SAP BI.7, ECC4.6, CRM, BOBJ 4.1

Confidential, Milpitas

BI Consultant

Responsibilities:

• Analysis of the BW reports to understand the problem.
• Analysis of the underlying BW cubes, DSO and data source to understand the flow of data and root cause.
• Analysis of the data and understanding of the domain to get the relevant data for the metrics.
• Understanding of the business process business regarding the services.
• Analysis of the cubes and DSO to understand the complete data flow from the ECC or CRM source.
• Involving in requirement gathering for new BW reports.
• Involving in the bug fixing for the open issues with current BW reports.
• Enhancement and new development for certain open issues.
• Enhancement to bring few additional fields into from source system.
• Development like creation of info object, cubes, multi provider for bug fixing.
• Modification of the existing transformation, start routine, end routine and expert routine logic to fix the issue.
• Creation of variables calculated key figures, restricted key figures, formulas for the attrition report.
• Creation of new Bex queries and workbooks.

Environment: SAP BI.7, ECC4.6, CRM

Confidential, San Jose

BI Senior Consultant

Responsibilities:

• Improve the data quality of the reports of the HR system
• Analysis of current SAP BW HR system to identify the root cause for the issues.
• Analysis of the HR cubes and DSO to understand the complete data flow from the ECC source to till the BW reports.
• Analysis to find the gap in the current BW HR system to that of the end user requirement.
• Involved in the requirement gathering for new BW reports.
• Involved in the bug fixing for the open issues with current HR system.
• Enhancement and new development for certain open issues.
• Analyzed and fixed the issue on few important reports like Promotions Analysis reports, Attrition timeline report
• Enhancement to bring few additional HR fields into the current BW HR architecture from source system ECC.
• Creation of new reports based on the newly enhanced fields.
• Backend development like creation of info object, cubes, multi provider for bug fixing.
• Modification of the existing transformation, start routine, end routine and expert routine logic to fix the issue.
• Enhancement of the standard and custom extractors to bring the data from the source system for the additional fields.
• Creation of user exit to populate data to those fields that are not directly mapped to the ECC source system.
• Creation of variables calculated key figures, restricted key figures, formulas for the attrition report.
• Creation of new queries and workbooks based on the ECC info set query.

Environment: SAP BI.7, ECC 4.6

Confidential, Milpitas

BI Consultant

Responsibilities:

• Analysis of the current Confidential cubes to identify the data for the dashboard metrics.
• Analysis of the underlying BW cubes, DSO and data source to understand the flow of data.
• Analysis of the data and understanding of the domain to get the relevant data for the metrics.
• Understanding of the process business planning of the customer and way of business planning and consolidation of the client.
• Creation of Bex query on top of the Confidential cube based on the metrics.

Environment: SAP BI.7, BOBJ XI 3.1

Confidential, Milpitas

BI Consultant

Responsibilities:

• Integration of SAP BW with Business Objects
• Analysis of current SAP BW system to identify all service related data.
• Analysis of all identified service related cubes.
• Combining the SAP BW info providers related to service to a single SAP BW multiprovider.
• Building Universe over the BW info provider.
• Creation of adhoc query over the universe.

Environment: SAP BI.7, BOBJ XI 3.1

Confidential, San Francisco

Business Objects Administrator

Responsibilities:

• Installation and Configuration of Business Objects XI R3 Maintaining Development and Production Servers for the Company
• Maintained multiple Universes.
• Administering Business Objects and Crystal Enterprise
• Plan the implementation of migration to Business Objects XI.
• Perform configuration and tests to all business objects.
• Administer and supervise configuration of all business objects.
• Assist all SAP Business Objects investment and provide support to business intelligence team.
• Provide support to all SAP business objects and provide appropriate upgrade on environment.

Environment: BOBJ XI 3.1

Confidential, IOWA

BI consultant

Responsibilities:

• As a BI consultant in the Confidential Project, I was responsible for Production Support Activities and the Enhancement activities; this includes small developments to projects both on Front End and Back End level. I have been working both in offshore and onshore. I have been the part of onsite- offshore model. Have worked as both the offshore team member and onsite coordinator for various enhancements.
• Involved in User requirements gathering, Business Blueprint, Realization and Testing Phases.
• BW business content installation, data modeling and designing info cubes with various aggregate levels.
• Worked with mapping the source data (R3/non R3) to target data source in BW.
• Experience in extracting data from SAP R/3 using different data extraction structures such as LIS, LO Cockpit, CO-PA and maintaining delta queues
• Customized standard extract structures and data sources in SD, MM and FI to facilitate data extraction to BW and to report using classification of various data elements.
• In coordination with the basis team, planned and implemented the overall batch load schedule for the data warehouse, including setting up batch jobs, triggering events, use of event chains, Info Package groups, roles, authorization profiles.
• Performance tuning of queries by maintaining aggregates and partition on Info-cube and by making the appropriate settings on Report Monitor.
• Performed analysis, design, development and implementation of standard/customized Info Cubes ODS Objects, multi providers for HR FICO, MM, and SD modules.
• Created data sources using generic and application specific extraction (LIS) for SD and MM modules and loaded the business content.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP systems.
• Performed analysis of info cube design, compression strategy, aggregate usage, delta caching for queries, BW archiving strategy.
• Worked with loading the master data related to SD, FI, CO modules. Developed Info Packages for loading Master data into Info Objects and Transaction data into DSO & Info Cubes with PSA as intermediate staging process.
• Created Info Packages to do Full, Initial, and Delta extraction for both Master and Transaction data.
• Created Data transfer process to execute the transformations and load the data to the target info providers.
• Scheduling of Extraction Jobs, Monitoring of Transfer and Update for data Loads, Monitoring of Status display and Load Statistics for Update Process.
• Analyzed the business critical extractors for performance optimization.
• Analyzed the extractors in detail to identify the root cause of the performance issues covering various stages like extraction from the source system, transfer, update and activation to find the process which was taking time.
• Monitored the extraction in the BW and the source system, captured various traces, identified the root cause and provided recommendations accordingly. Identified expensive SQL access in the source system on certain OLTP tables and provided recommendations to tune the same.
• Monitored, analyzed sales data load process chains sales data load for the month-end data extraction processes and resolved issues to ensure smooth month end process.
• Involved in multi-dimensional data modeling, developing Info Objects, Info Cubes, Aggregates, ODS objects, PSA, Data Source (OLTP Source), Info Source, Communications Structure, Transfer Structure, Multi Providers, and customizing standard Business Content.
• Extraction (ETL) of master data and transaction data from R/3.
• Participated in data transfer from multiple SAP and non-SAP Source Systems through Direct update.
• Creating transfer rules, update rules, enhancing extractors, extract structures (Data Sources/transfer structures), communication structures, Info Packages, created generic R/3 extractors, used PSAs, created/scheduled extract jobs with Process Chains, and monitored data loads.
• Performed tuning of query performance and load (ETL) performance using BW Statistics. Performance analysis of Queries and optimization/tuning through data model, query definition, Aggregates, OLAP Cache, Database Statistics.
• Worked extensively with 2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 11 VASTI, 2LIS 12 VCITM, 2LIS 12 VCHDR, 2LIS 13 VDITM, 2LIS 13 VDHDR extractors.
• Mapped user requirements to fields in the extractors to ensure that the requirements will be met.
• Designed DSOs, cubes in Sales, Billing and Delivery Areas.
• Worked on a function module based custom extractor ZBW NAST DATA to bring in the output sent date for quotations.
• Enhanced 2LIS 02 ITM extractor to bring in first delivery date and original delivery date fields in the extractor and made changes to the corresponding DSO’s and cubes to include these dates.
• Performance Tuning:
• Performed optimization, analysis and tuning of the BW environment to improve data load time and query response time.
• Used aggregates where required in cubes to make the reports run faster.
• Performed compression of cubes to improve report performance.
• Refreshed statistics on cubes to improve report performance.
• Created secondary indexes on DSOs based on the report filter criteria to improve report performance.
• Created secondary index on DSOs based on the select fields in the transformation to improve the data load performance.
• Maintain drop index before cube load and re-create index after cube load in process chain for data load performance and to improve report performance.
• Used SAP INFOCUBE DESIGNS program in se38 to see the ratio of dimension to fact table and change the dimensions as necessary.
• Developed front-end queries and reports with variables for characteristics, CKF, RKF using BEx Analyzer, Bex Browser and Web Application Designer.
• Key Reports include Vendor Spend Report (Summary), Open Purchase Order Item Detail, Open PO Trending and Purchasing Detail Reports.
• Extensively worked with BEX to create queries with variables, filters, formulas, restricted and calculated key figures, conditions and Exceptions.
• Close interaction with the application users to understand and evaluate the reporting requirements - Variables, UOM Conversion Formula Variables, Calculated/Restricted Key figures, etc.
• Modification of queries as per client requirement.
• Worked on creation of queries and views for the client requirements.
• Creation of Web Templates in Web Application Designer for various client specific Dashboards.

Environment: SAP BW3.5, SAP BI.7, ECC 6

Confidential

Software Engineer

Responsibilities:

• Responsible for all aspects of software development including requirements, design, coding, testing and maintenance on multiple platforms using C++ and Java Participated in the development of a Java framework that allows rapid and reliable development of database-centric Windows applications.
• Engineering web development, all layers, from database to services to user interfaces
• Supporting legacy systems with backups of all cases to/from parallel systems
• Analysis and design of databases and user interfaces
• Managing requirements
• Implementing software development life cycle policies and procedures
• Managing and supporting multiple projects
• Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills
• Coded web designed interfaces using Java, XML, XSL, AJAX, and JWS.
• Responsible for end of day modules and system set-up modules for the detailed design of application in UML with 5 other teams working on different parts.
• Created dynamic XSL to transform XML to target platform language such as HTML.
• Developed Notification and Customer Classes.
• Developed server-side code for internal and external web applications.
• Write unit tests, automated regression tests and tracking defects as they occur.

Environment: Java Servlets, HTML, and JavaScript, SQL Server