SHARDUL PRASAD KOTHARE Phone: 270-***-**** SAP Dev Tech Analyst 3 Email:firstname.lastname@example.org
* */*+ years of experience as Sr. Business Analyst/Product Manager in SAP with implementations in R/3, ECC 5.0, and ECC 6.0, SAP BI/BO 7 SAP FS-CD.
I have successfully implemented 2 full life cycle implementations and 2 Upgrade projects in AIG.
Currently implementing 2 full life cycle projects for 2 new initiatives.
Good understanding of SAP R/3 functionality (SD, MM, FI, HR, FS-CD) Standard Business Contents and Data Modeling (star schema, extended star schema, flat structure and multi dimensional data modeling) in SAP. SAP HANA SPS11 and SPS12 concepts and Model creations in the form of views.
Analyzing business requirements, carrying out fit-gap analysis, process design, customization, integration and system testing, key users training, and defect resolution.
An outstanding ability to manage cross-functional deliverables in a fast-paced, global environment. Detailed knowledge of sales processes, a known solution provider with strong trouble-shooting skills. Also worked on with the SAP FI-CO integration with SAP FS-CD.
Specializing in process governance, documentation, complemented by technical writing abilities. Expert in conducting comprehensive investigations. Proven ability to work effectively and handle difficult situations.
Played a key role in identifying and implementing process improvements, standardized policies, and procedures reducing global support costs. Excellent analytical skills and well versed in analyzing data, supporting audits, solid knowledge of finance and sales environments and with a strong manufacturing background in fabrications, assemblies, and processing. Streamlined best business practices with an integrated global solution.
Worked on the AWS services calling SAP End points for real time posting of data.
ERP Versions : SAP ECC 6.0/5.0
Net Weaver Versions: SAP BI 7.0 (NW 2004s) and SAP BW 3.5, CRM 7.1, SAP FS-CD, SAP HANA
Reporting Tools : BEx Suite, WAD, Business Objects 6.5/XIR2 and XIR3.
Web Technologies : HTML, XML, Athena AWS, Error Handling services, Postman tool VB Script, Framework 2.0, AWS services, Recon services
Database : Oracle 9i/10g, DB2, SQL. Learning Python
Bachelor of Engineering: I.T, Mumbai University, India.
Master of Science: Management of Technology, Murray State University, USA
Client: AIG (Parsippany, NJ) July 2013- Till Date
Employer Address: (5 Wood hollow Rd, Parsippany, NJ 07054)
AIG is worldwide Insurance Company having headquarters in US and different location of UK and other Europe countries.
Environment: SAP FS-CD, Accounting Rule engine (ARE concepts), Production Support
Handling various production support issues for FS-CD module like billing, payment methods, Workflow, Dunning, Automatic Clearing, VYSPA Postings, KCLJ errors etc.
Worked on ARE optimization project to give the best performance for monthly batch cycle (month end close).
Also implemented the automated solution for calculating the number of records processed by ARE mass activity for the month end run. Wrote the functional spec and passed it to the development team for implementing the program. This eliminated the manual verification steps and also reduced the efficiency of the month end total end to end cycle.
Involved in rigorous testing for any minor, major enhancements as well as projects for the Production landscape. Was a part of Development, Quality and Regression client testing before moving the changes to Production.
I was able to produce the relevant data for the specific testing in SAP by using specific T-codes. These data was necessary to proceed with the testing in Non-production systems.
Also expertise myself in tweaking the data as a when necessary for relevant test scenarios.
AIG had specially maintained a Recon Dashboard report in SAP which would help the users understand how the flow carried on from the front end systems to SAP file creations. This tool was used to see the difference in the amounts of the policies or claims for a particular Business Partner (End to End flow).
Worked with different offshore teams (India & Manila) and also handing over the roles and responsibilities for Production support. Proper transitioning to offshore with KT sessions and documentations as a when required.
Worked in a Middle Office team coordinating with the business and understanding the business requirements for an enhancement. Creating Financial reports based on the cost centers for the individual groups.
Writing BRD’s with the business requirements and handing over to the Project team for further development.
Involved in creating financial reporting for the business based on the number of enhancements or projects YTD.
Developing Microsoft Visio slides for top management in helping build up the organizations and help them understand the current process flow.
Was also involved in Brazil implementation project which was in the requirement gathering phase.
Also writing functional specs as and when required by the project team.
Implemented EHP6 Service pack 14 upgrade to our production landscape. I was involved in majority of the upgrade project with the required testing in Development, quality, and Regression client.
Successfully implemented the Dunning Project which is totally a new requirement in the FS-CD process flow for UK & NORDIC.
Currently working on the SAP HANA. This includes creation of calculated views which consists of calculated columns in a graphical view. We are eliminating the BWP systems and creating HANA views for reporting purpose. Also working on creating new BEX queries on top of HANA views.
Identify the logic and routines specified in BW and ECC end and replicate the same logic in HANA views in the form of calculated columns or filters expressions.
Have created Procedures in HANA views for complex logics to replicate ABAP logic in ECC side.
Have also created Value helps for all the input parameters in HANA so that users can access it easily at the front end side. Also have created Decision tables in HANA for certain GL accounts for which they run the BW reports.
To improve the performance of the HANA Views, I have analyzed the Visualization plan to decide which node is taking the most time in running.
I have been testing WEB Intelligence report which is built on HANA views for users to access.
I have successfully created a Macro for comparing 2 excel sheets to identify differences between them. This is a tool was created for a specific project and is been used by many teams to validate the results.
I have taken Lead in this project to Manage Scrum meetings through JIRA boards and agile methodology. This helped us to develop, implement and maintain an effective planning and analysis for senior management to measure the performance of the company’s savings annually for costs savings purpose.
Also currently working on clearing project to automate the clearing rules and eliminate manual efforts. This involves new set of clearing rules in configuration.
Leading the weekly Batch monitoring analysis meetings with offshore to identify long running jobs in Production system and to identify errors or issues if any.
SAP Functional Architect with Progressive Experience in SAP (FI/CO)/OpenText VIM/OneSource Designing, Business Process Re-Engineering, Implementing, Customizing, Configuring, Integrating, Upgrading, Go-Live & Supporting with Full Life Cycle Implementations.
Experience in data migration from legacy systems to SAP R/3 by using LSMW & Batch Input Session techniques
Currently in a new project for learning AWS services called S3, Athena, Quick sight reporting tools.
Currently working in the Accounting HUB space for AWS services. Learning Python coding for building and testing services built for sub ledger posting on the fly.
Leading the AWS project from accounting HUB perspective and managing offshore resources as well. Tracking all the development, enhancements, and change requests through JIRA board which is AGILE methodology.
Client: AIG (Parsippany, NJ) Sept 2012- June 2013
Employer: Convergent Consulting, Inc.
Employer Address: (75 S Milpitas Blvd, Suite #220, Milpitas, CA 9 5603)
AIG is worldwide Insurance Company having headquarters in US and different location of UK and other Europe countries.
Environment: SAP FS-CD, Overseas General Insurance system, EDSAT
Involved in to 2 implementation projects for UK and NORDIC countries.
Handling various issues on SAP FS-CD particularly related to OGIS, EDSAT, and QMP etc.
Working on defects pertaining to OGIS, EDSAT and QMP processing.
Generating files in OGIS and EDSAT which could be sent to Intellirisk folks in NY head office.
Writing functional specification whenever Business needs modifications in the existing rule.
Coordinating with the ABAP team in helping them understand the new rule for transformations process of OGIS and EDSAT.
Making configuration in our customizing tables for OGIS and EDSAT if the business requires the new updates.
Worked with DI team in understanding how the front end system is sending data to the SAP systems.
Also ran Pre-processor and KCLJ programs to convert the data from the DI systems to SAP systems.
We would take the dump of the data to prepare a test case and a test plan for relevant scenarios. This would help us to cover up all the necessary scenarios for that particular change/enhancement/Defect etc.
Testing of the defects end to end starting from the pre-processor till extracting of the OGIS files which have to be sent to NY head office.
Adding new value sets to VZ20 & VZ21 config tables which are the main posting area tables for OGIS reporting.
Writing new rules for NORDIC company codes in our OGIS transformation table.
Coordinated with FSRI team for EDSAT processing and to understand how the CD-RI interface works as well as RI-CD.
Also involved in Hyper care issues after Go-live of the projects.
Client: Southern California Edison (Irwindale, CA) March 2011- June 2011 Employer: Convergent Consulting, Inc.
Employer Address: (75 S Milpitas Blvd, Suite #220, Milpitas, CA 95603)
SCE is an Electric company that supplies electrical products which reduces energy.
Environment: SAP CRM 7.1, BEx, BO (XIR 3.1, WEBI (XI R 3.1),
Created new fields as per Business requirements for Service Contracts (SC), Activities, Leads, Opportunities, Service Orders (SO), Service Confirmation, Customer Contacts, Marketing, and campaign.
Provide CRM functional design solutions for customers, including full life-cycle implementation.
Handled different types of Defects on the backend BW, BEx side as well as at the report level (Webi).
Checked whether all the flows are getting populated from the CRM system to BW system with correct data.
Ran Webi reports to check correct data loads from CRM to BW and also checked the filters used in it.
Also checked the correct mapping between Source system and BW system fields and also the custom extractor whether they are populating the data or not.
Coordinated with Tech team if any enhancement was required to custom extractors.
Worked on HPQC for testing and also defect resolving.
Configured SAP CRM products per requirements, including testing, problem solving, and debugging.
Participated in meetings with SME’s and business users to better understand the requirement and the existing infrastructure.
Participated in the business process reengineering workshops for testing the Purchase-to-Pay and Sales Processing cycles with the aim to identify gaps and initiate the construct improvements from an SAP R/3 Inter-company and Intra-company, Tax Account Assignment.
Organized, directed and executed a Pricing data validation program. Created queries and test scenarios to expedite data validation of pricing conversion records.
Developed, End User training materials for SD/MM and Account Receivable processes.
Created and developed Use Cases, created and edited Requirements Traceability Matrices, participated in reviewing and approving functional Test Cases. Ensured required documentation was up to date and accurate.
Also writing test scripts for the Testing purpose for the Business side people to execute the test cases and help them to detect the defects during the flow.
Actively participated in the User Acceptance Test (UAT) Planning once done with ITC phase 3
Designed UA Test scenarios and coordinated the UAT team to execute test cases.
Interfaced with the application development & technical team to resolve the issues/defects.
Identified and documented business processes in CRM for professional services clients.
Identify and administer CRM best business practices per business standards for functional processes.