SUMMARY:

• Successful information technology professional with more than 9 years of diverse and extensive experience focusing on systems analysis and design, testing, system upgrade, training, documentation and systems migration.
• Proven achievements in providing hands - on guidance with SAP BW /BI, SAP BPC, SAP HANA, SAP Business Objects, SAP BODS and other software applications. Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.
• Proven experience working in Onsite-Offshore model. Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization. Extensively involved in training of the end users/business users and creating training documentation.
• Experience with multiple full life-cycle implementations and E2E Testing in SAP BI adopting ASAP Methodologies which involves Requirement Workshops, Gap analysis, Business Blue-Printing, Realization, Data extraction, Data modeling, Data loading, Production Support, Testing, Documentation, Requirement analysis, End user documentation, Reporting and Go-Live Check.
• Experience in Data Extraction from Flat File, CRM and SAP R/3(SD/MM/FI/CO/HR) using extract structures such as LIS, LO-Cockpit, COPA, FI-GL, HCM/HR as well as from other database sources using DB connect. Working knowledge on SAP HR - Payroll & Time Management cubes integrated with SAP BW system.
• Experience in analyzing business specification documents, developing test plans, defining test cases, developing and automating test scripts. Experience on all Quality Center modules like Requirements, Test for Defect Tracking, organizing, managing, planning and executing the Test scripts. Experience in Quality Center (HPQC), JIRA, PIER, Microsoft Visual Studio (VSTF). Experience on process like Change Management, RICEF Management, Document Change Control, Scope Management, Test Environment creation and Intake process.
• Proven experience in managing/leading/coordinating multiple Software SAP Development /QA Testing Resources/Teams, Test activities, and multiple Programs/Projects at multiple geographic Locations.

TECHNICAL SKILLS:

Applications: R/3 4.6C, ECC 5.0&6.0, SAP BW 3.0B, BW 3.5, BI 7.4. SAP BPC 7.5, SAP EPM 10, Business Objects 4.1/4.0/3.1/3.0/ R2, SAP HANA, SAP BODS, SAP FI, SAP CRM, SAP CRM

Databases: MS SQL Server 4.5-7.0; ORACLE 8.0; 7.X.

Reporting Tools: BEx Analyzer, WAD, Xcelsius, Crystal Reports, Information Design Tool, Universal Design Tool, WEBI, MS Office, MS Power BI

Languages: SQL, PL-SQL, C/C++

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

PROFESSIONAL EXPERIENCE:

Confidential, Greater Seattle Area, WA

SAP Business Intelligence - BI HANA Test Lead & Project Coordinator

• Working as an SAP BI Module Lead in an integrated services model where we Develop, Test and Deploy. Attending project review meetings to provide input regarding all system functions and allow for planning of technical design, quality assurance on upcoming changes.
• Working with business and technical specialists to develop and implement new testing tools and methods. Developing, maintaining and executing quality assurance test scripts and checklists, reviews documentation and tracking of rollout activities and reports on status and final results of those activities.
• Majority of the work involves developing/testing SAP BW, SAP BOBJ, SAP BW HANA, SAP BODS and Non-SAP BO reports (Teradata Data Base) modules. Have significant exposure in data load extraction (ETL) from SAP and Non-SAP systems via BODS. Worked in E2E testing environment to ensure data flows from POS to the downstream.
• Executed regression test scripts using WorkSoft Certify from HP ALM. Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan. Responsible for Creating FSD and TD documents. Created Test Plan, Mapped to requirements and created Text Exit Reports
• Actively involved in SAP HANA OS and Technical Upgrade, SAP BW Technical upgrade and BOBJ Version upgrade.
• Created and Tested back-end flow, info providers, Open-hub data in SAP front-end tool. Designed and developed testing scenarios for the integration between different applications.
• Reported bugs through HP Quality Center and interacted with developers to assist in resolving the issues. Performed data quality analysis using advanced SQL skills.
• Responsible for creating BOBJ reports on SAP and Non-SAP systems (Teradata). Responsible for Creating/Testing IDT Universes using Teradata, SQL Server, HANA, SAP BW and HANA views. Responsible for reporting the status to the project manager on weekly basis.
• Actively involved in daily triage meetings, weekly walkthrough meetings, to verify the status of the project effort and the project.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts. Extensively used and developed SQL scripts/queries in backend testing of Databases. Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Led the team of 24 (Onsite-Offshore). Monitored and mentored the team. Assigned and reviewed work done by the team. Actively conducted status call daily to record the project status and updated the same to stake holders and business teams. Conducted defect triage meetings, reported and fixed bugs/defects.

Confidential, Greater Austin Area, TX

SAP Business Intelligence - Module Lead & QA Testing Lead

• Created BI end-to-end data flows for Inventory, Purchasing, Pricing, Billing, and Delivery. Responsible for creating BI end-to-end data flows for above from ECC data sources. Involved in Installation of business content for Info Objects, Info Cubes, and DSO Objects in this process.
• Created both Standard and Customized DSO, Cubes and Multi Providers. Extracted data from SAP ECC using generic and LO extractors. Responsible for creating Technic al Design, code review and UT documents. Worked with end-users to gather and document requirements for a SAP Business Objects reporting solution
• Creation of Universes using Teradata, SQL Server, HANA, SAP BW and HANA views. Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
• Created attribute, analytic and calculation views for Sales and Procurement modules as part of the current POC. Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.
• Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process. Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• 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. Migrating standard Info cubes to In-memory optimized Info cubes using migration Tool. Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool. Importing the BW Models in to HANA using HANA Studio.
• Led the team of 14 (Onsite-Offshore). Monitored and mentored the team. Assigned and reviewed work done by the team. Actively conducted status call daily to record the project status and updated the same to stake holders and business teams.

Confidential

SAP Business Intelligence - Lead Consultant || Senior Software Engineer

• Led SAP BI Development Teams. Created end-to-end data flows for Maintenance orders, Status Objects, Notification items. Involved in Installation of business content for Info Objects, Info Cubes, and DSO Objects in this process.
• Responsible for Creation of both Standard and Customized DSO, Cubes and Multicubes. Extracted data from SAP ECC and SRM using generic and LO extractors. Responsible for creating Technical Design, code review and UT documents. Created Transfer Structure, Update rules, Transfer rules at cube level.
• Designed data flow and loaded data. Migrated 3.x data flows to 7 version. Created DTP, Info Packages, Transformations. Created Process Chains and Test Scripts. Executed Microsoft Visual Studio (VSTF) test scripts for BI data flows. Developed SAP HR integrated with SAP BW cubes such as 0PT C01, 0PY C02, 0HR PA* and 0HR PT*.
• Activated Master Data for data sources. Generated reports using BEX analyzer and Analysis tool.
• Migrated SAP Business Objects XI 3.1 content (users/user groups, Universes, reports) in to SAP Business Objects XI 4.0 environment using the Import Wizard. Also provided all groundwork including installation and upgrade. Interacted with Business Users and Business Analysts to gather and document the requirements and translate these to Technical specifications for designing Universes.
• Delivered Proof of concept to demonstrate Data Cleansing, Matching and De-Duping. Created crystal reports with Standard Cross Tabs and Grouping using Crystal Reports 2008. Involved in creating several Universes using Designer according to the requirement. Involved in updating and maintaining existing Universes based on changes in user requirements and changes in data. Created Transport request and loaded data in the Quality & Production.
• Responsible for creating BPC end-to-end data flows for Fixed Cost, Gross Profit, and Planning Applications. Scheduling Full Optimization to various applications. Involved in Installation of SAP BPC in this process.
• Created reports and Input Schedule using EVDRE, Created Data Manager Packages and Test Scripts. Designed data flow and loaded data through flat files. Created Master Data for different applications. Created script Logic for allocations. Created Business Process Flow for the users to access. Uploaded and downloaded flat files to the server.
• Copy of reports from BPC 7.5 to EPM 10. Migrated reports more than 275 with enabling all the disabled features like VB codes. Codes in VB which has MNUTOOLS EXPAND, MNUTOOLS REFRESH, etc assigned its API and made sure that FPMXL client is checked for every report. Solved issues for reports which show #NoData and #Value.
• Checked hidden sheets of older version, identified EPM unsupported functions like EVENE, EVEXE, etc and wrote EPM supported functions. Added event break codes for the reports which take long time to EXPAND or REFRESH. Reports having EVAPP() functions were replaced with EVMBR() function on client requirement. Migrated Data Manager Packages from BPC 7.5 to EPM 10.
• Performed Peer code review among the team's work. Responsible for assigning task to the team from Project plan. Responsible for issue defect resolution with onsite on daily basis.

Confidential

SAP Business Intelligence - SAP BI Consultant || Software Engineer

• Analyzed business processes and created the technical specifications by closely working with Leads who provides functional specifications of reports to be developed in BI-BO.
• Designing and solutioning based on the functional requirement. Ensure to deliver high quality defect free codes and unit testing for the objects & reports. Co-ordination of team for internal/external reviews and ensuring all follow ups are done to closure.
• Development progress: Monitor development progress to ensure the timely delivery and providing early feedback to team leaders about the development status. Coaching the Junior BI Developers in the team from time to time.
• Finalizing master data and KPI for dashboard. Installation and customization of SAP BI and building of reports. Analysis of Functional Specs of requirement. Gap analysis.
• Created Info cubes, DSO. Used write-optimized Data Store objects as the EDW layer for saving data. Created DTP, Transformation's. Involved in writing complex end routine transformations to get desired output. Designing model to suit client's requirement such that to efficiently use the Master data and other objects to meet the requirement.
• Effective team handling and work management among the team. Created queries with Free Characteristics, Filter, Formula, Conditions, Exception, and Variable. Post Implementation maintenance till hyper care of the projects.