Data Sap

Ruchita Parikh Email: *************@*****.***

Marlton NJ Cell: 609-***-**** www.linkedin.com/in/ruchita-parikh5241983a

EXPERIENCE:

Summary:

A strong IT professional with over 12+ years of experience with 10yrs in SAP Business Intelligence, Business Object and BW on HANA.

Experience in full life cycle implementation with ASAP methodology, various enhancements and support/maintenance experience.

Work on different phase of implementation from project preparation, Design, Testing, final preparation, go live and support.

Experience in defining gap analysis, documentation, data integration, user training, testing, data migration, archiving, deployment and post implementation support.

Strong problem solving, and analytical skills coupled with Technical and business knowledge.

Skilled in building relationship with clients and team members.

Good understanding of SAP and non-SAP data.

ACCENTURE FEDERAL SERVICES (AFS), Philadelphia, PA

Client: Dupont

Senior BI/BO Reporting lead and Hana Modeler May 2018 – Present

Assist users to migrate legacy BEx report which built of BW to new environment (Analysis of office) using BWH database.

Create a process to migrate user’s legacy workbook into Analysis of office.

Manage on/off shore development team as it relates to migration of legacy workbooks

Coordinating with on / off shore team on the status of daily development tasks and any issues/impediments.

Develop complex workbook in AO (Analysis of office) as per requirement and get user’s sign-off.

Strong understanding of end-user needs and requirements.

Knowledge transfer and provide training to the client and offshore team in the Analysis of office (AO), BW data validation.

Work as the SME of the Business Object/Analysis of office for client merger project.

Client: US Army Public Health December 2017 – May 2018

Senior SAP Consultant

Gather and analyze business user requirements and translate them into design document.

Modify existing reports and develop new reports by analyzing SQL database, data sources.

Worked in Azure environment to modify crystal report using SQL commands, views, and stored procedures as needed.

Troubleshoot and analyze CR reports using the drill through, slice and dice in starlim system.

Coordinate with change management team to migrate report changes from external environment to production environment.

Create Crystal reports using tables and validate the reports by cross checking and verifying data against the reports generated from the legacy system.

Client: SAP April 2017 – December 2017

SAP Hybris HANA Migration Performance testing lead

Understand the Business requirement, non-Functional and Performance Specification documents.

Create functional test cases, test input data and converted all test cases into test scripts using JMeter (.JMX).

Experience in designing performance test strategy, creating and executing test scripts with correlation, parameterization and error handling.

Execute Test scripts using command line in AWS server.

Independently develop JMeter test scripts according to test specifications /requirements.

Attention to detail with strong interpersonal and communication skills.

Attend daily status meeting with PM, functional coordinators for update and plan for next steps.

Create effective training material for testing tools/process and conduct one - one mentoring to other team members.

Knowledge transfer and provided training to the offshore team in the testing tools and client process.

Client: Defense / Government Agency / Public Sector October 2015 – March2017

Senior SAP BW Data Archiving Lead

Lead standard Data Archiving Process (DAP). Create virtual cubes. Archive / Nearline SAP BI Finance and Procurement DSO / ODS Infoproviders through all development landscapes. Analyzed 18months old data in production environment and create worksheet in excel with Fiscal Years, posting date, Account numbers, purchase order and others required fields with filter on specific data information.

Create effective training materials for BW Data Archiving process. Mentor clients and junior resources for BW archiving process.

Independently worked as the SME of the near lining and archiving data project to recover disk spaces in the client’s storage area network. It includes development, test and migration of special objects that allowed for the transfer of terabytes of data to the near line/ archive storage system.

Create process chain, scheduling loads and monitoring data load for archiving objects.

Coordinate with other team members and worked on end – end process for BW archiving process.

Senior SAP BI/BW/ Business Object (BOBJ) Developer March 2006 -October 2015

Lead the systems development life cycle (SLDC) of business intelligence reporting within the enterprise. Support over 100+ BOBJ reports across the world for internal and external customers.

Lead the upgrade of Enhancement Pack (EHP1) support packages. Supported pre and post upgrade testing. Coordinated user acceptance testing (UAT) and System Testing with IT Project Manager and a user base of over 15 testers.

Lead the migration process for procurement SAP BEx queries to Business Objects (WEBI) including regression testing.

Create effective training materials, conducted one-on-one and live group training. Train end user and other team on SAP BEx Queries creation, SAP Business Objects (BOBJ) functionality, and usage of the Universes Design Tools (UDT / IDT), and ITSM remedy functionality.

Create BW components like Queries, workbooks, Calculated Key Figures, restricted Key Figures, Structures, Variables, Exceptions, Conditions.

Make sure SAP best practices are followed in design and development for optimum performance.

Often worked on many parallel projects that require prioritization and time management.

Work with client, Accenture and teaming partner team members to gather and design technical requirements, BI reports and BW objects.

Monitor daily/weekly/monthly BW data load process chains and resolved any failures as they happen

Analyze data related issue, compare data in source system and BI, resolved data related issue in PSA table.

Coordinate with all levels of the business including process owners, end users, developers and project managers in multiple location for smooth and successful upgrades/enhancement in SAP.

Develop multiple ad-hoc SAP BOBJ Web Intelligence (WEBI) Reports with SAP BOBJ universes using Universes Design Tool (UDT), and used Events Setting for daily /weekly scheduling of SAP BOBJ reports across the enterprise; join external data sources to create complex SAP BOBJ reports. Peer review and optimize Universe construction in Business Objects.

Redesign of the existing universes with Bex Queries and back end BW system

Deploy crystal reports to CMC (Central Management Console) for users to view reports in Infoview and run, schedule them in PDF and Excel formats.

Research on complex issue and create OSS note with SAP if needed.

Perform analysis on ITSM Remedy Tickets and create defects and enhancements for issue that arise. Migrate defects and enhancements from development landscape environment and migrate to Production landscape environment. Ensure peer reviews are performed, and system testing prior to migration into Production.

EDUCATION:

UNIVERSITY OF HOUSTON – CLEAR LAKE, Houston, TX

Bachelors of Science (BS) Major: Computer Science (CS)

Certified Agile Fundamental by ICAgile August 2018

SAP BUSINESS INTELLIGENCE (BI), BUSINESS OBJECT AND REPORTING SKILLS:

Business Objects: Web Intelligence (Webi) Business Explorer: BEx Analyzer and BEx Query Designer Universe Design Tool Crystal Report Analysis of office SAP Analytics

TECHNICAL WRITING SKILLS:

Technical Specification Documentation Technical Mapping Documents Data Flow Diagram (DFD) Creation Document Repository Tools: IBM Rational ClearQuest and IBM Rational ClearCase

OTHER SOFTWARE SKILLS:

BCM Remedy Ticket Tracking Systems Development Life Cycle (SDLC) CMC SQL Programming HTML AWS JMeter Putty Filezilla HPQC

Contact this candidate