SUMMARY

• Successful information technology professional with more than 16 years of diverse and extensive experience focusing on systems analysis and design, training, documentation and systems migration. Proven achievements in providing hands - on guidance with SAP BW, SAP BI/BO, SAP HANA, data visualization using Tableau and other software applications deployment.
• Strong Knowledge and expertise in SAP HANA, SAP BW 3.5, SAP BI/BW 7.x and Microsoft Dynamics ERP.
• Around 12 Years of experience in SAP BI/BW, 1 Year in SAP HANA and 3 Years in Microsoft ERP. Worked on projects like Implementation, Development, Maintenance and Support projects.
• Extensive knowledge on SAP ISU industry with Billing Pricing and invoicing, device management, meter reading and meter management.
• Expertise in Tableau 7, 8, Business Objects 4.0, 4.1.
• Configured and developed few of the challenging energy accounts like Home energy units for equipment rental, water services like minimum water winter charges. Electricity configuration of distribution and supply accounts.
• Strong knowledge of business processes with strong foundation in Financial Accounting Managerial Accounting and Cost Accounting concepts.
• Provided end user support for all issues pertaining to Finance and Controlling modules & Worked closely with Business Leaders to consult and influence direction of business process.
• 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.
• 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.
• Specialized in evaluating/dissecting existing BI /HANA Data Warehouse architecture and suggesting the right areas of improvements/redesign options/optimization opportunities. Experience in optimizing, performance tuning Native HANA, BW on HANA based on SAPs proven best practices and standard design principles.
• Expert in Data Extraction, Transforming and Loading (ETL) using Business Objects Data Integrator XI (BODI), Data-services xi3.2, 4.0(BODS)
• Expert in design and developing Business Objects Universe and ad-hoc reporting using WEBI and Crystal Reports.
• BW 7.4 on HANA: Open ODS view using Hana tables and virtual tables using SDA, Composite provider, ADSO, Field based and IO based modelling, SAP Hana Live, Migration from LSA to LSA++.
• Experience working on Business Objects 4.0, Releases XI R2/3.1/4.0 SP2, SP4 and SP5 (CMC, CCM, CMS, LCM, Promotion Management, Information Designer tool, Business Intelligence Consumer Services (BICS), Universe Design (Unv and Unx), Web Intelligence 4.0
• Strong Exposure to SQL, PL/SQL, RDBMS, Oracle 8i/9i/10g, Teradata and MS SQL Server 2005.
• Knowledge on Business Objects Designer, Web Intelligence (WEBI) and Dashboard reports.
• Excellent analytical skills for understanding business requirements, system requirements, data related requirements, business rules/processes, and detailed design of the application
• Expertise in software development life cycle (SDLC), requirement gathering, business analysis, system analysis, data analysis, risk analysis, feasibility analysis, impact analysis, gap analysis and process improvements, data modeling and mapping.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

SAP Analyst

Responsibilities:

• Participate in support of reporting solutions within client products, primarily using the SAP Business Information Warehouse (BW) application.
• Utilize ETL processes to extract data from different kinds of source systems into a BW system
• Analyze requirements, evaluate alternate designs and propose solutions in a SAP BI/BO reporting environment
• Work in an onsite-offshore model involving daily interactions with offshore teams to ensure on-time quality deliverables
• Document test plans and complete Unit Testing of development objects and reports. Work with Quality Assurance business resources to complete System and Integration testing.
• Analyze and communicate report development issues, including problems with data integrity, data design, and functional and technical software issues. Prepare project related documentation (object designs, business rules, technical information, etc.) during the different stages of the project.
• Provide support and maintenance of the existing BW environments (development, quality assurance and production.
• Automate the BW Data Load process and work on the performance improvement of overall batch processes.
• Develop, document and revise system design procedures, test procedures, and quality standards.
• Provide business users with assistance solving software and reporting related problems, such as user training, favorites, personalization and data gaps in parameters.
• Review and analyze data modeling errors to locate code problems, and resolve them
• Confer with clients regarding the nature of the information processing or computation needs a computer program is to address.
• Hands on experience in coding Oracle PL/SQL and SQL

Confidential, Kingwood, TX

SAP Analyst

Responsibilities:

• SAP Releases BW 7.4, 7.5 BO 4.1, SLT, ECC 6.0
• Implemented currency conversions techniques to convert the existing EURO reports to USD.
• Involved in BW on HANA migration process.
• Archiving the data in SAP BW by using NLS methodology.
• Design and develop information models attribute, analytical, calculation views on HANA
• Design, trouble shoot and resolve problems related to integration of SAP and non-SAP data in BI
• Integrate the data from non-SAP systems of acquired entities to SAP and maintain the reporting data integrity and security by developing reporting solutions in native HANA and BW on Hana

Confidential, Bellevue, WA

SAP Analyst

Responsibilities:

• SAP Releases BW 3.5, 7.3, 7.4 and BODS 4.2, BO 4.1, SLT, Oracle, ECC 6.0, SAP CRM 7.0
• Established the best modeling and recommended strategies for SAP HANA and BW data modelling.
• Created technical specifications and standard modeling documents for BW powered by HANA and native HANA data modelling.
• Strong experience in carrying functional, integration, latency, performance, reliability testing for various enterprise analytical products.
• Build SD and FI Information Models for user consumption (Attribute View, Analytical View, and Calculation View).
• Worked on SQL script based Calculation Views.
• Extensively used Business Objects Data services to generate files from different sources SAP and Non-SAP and transfer the files to downstream systems like SCOPSBI, TDFADS, ASSURANT.
• Generated Sales equipment files through Business Objects Data Services to Assurant system to track the APPLE CARE coverages.
• Created Variables, Input Parameters and Calculated/Restricted Columns on Calculation Views.
• Imported BW targets from BW application layer into HANA to leverage mix modelling capabilities.
• Connected to Non-SAP Systems like OMNI, EIP, OER, SAMSON, SIEBEL for reporting for various business requirements.
• Build various reports to reconcile the data between ECC-BW, EIP-BW, SAMSON-BW.
• Created Asset reports and reconciled them with ECC reports for Finance teams for audit purpose.
• Converted DSOs and Cubes into HANA optimized.
• Responsible for gathering the Requirements from the users and writing Functional Specifications and Technical Specifications.
• Analysis of customer requirements in preparing the master data for GL accounts, asset masters, Cost centers, Customer masters etc.
• Implemented new BW targets to support LO and FI requirements.
• Defined OLAP connections to extract data from SAP BW sources and developed critical reports like IC Sales Revenue using WebI.
• Created open hubs to provide data to downstream applications
• Created data flows to extract data from POS DM to SAP APO and SAP BW for reporting purpose.
• Developed the Unit Test scripts and deployed them in to the document repository.
• Consumed HANA models into BW application layer and created BEx queries.
• Implemented new BW targets to support LO and FI requirements.
• Involved in HANA deployment and production cutover activities. Transported objects by creating delivery units between SAP landscapes.
• Involved in executive and analytics dashboards design using Design Studio and Dashboards.
• Defined OLAP connections to extract data from SAP BW sources and developed critical reports like IC Sales Revenue using WebI.
• Used BW/BI best practices and standards to maintain stable Business Information environment