Management Sales

Sandeep Sonkusare

Address: **** **** **., *** # ***, Plano, TX 75093 Phone: 469-***-**** *******.*********@*****.*** LinkedIn: https://www.linkedin.com/in/sandeepsonkusare OBJECTIVE:

Actively seeking a challenging full time opportunity in SAP, Business/Data Analysis or management consulting to achieve business, corporate and career goals.

EDUCATION:

Master of Science, Information Technology Management, University of Texas at Dallas. Graduated: May 2015

Bachelor of Engineering, Computer Science, University of Mumbai, India. Graduated: June 2011 PROFESSIONAL EXPERIENCE:

SAP Test Analyst at Avaya Inc., Coppell, TX Jan. 2015 – Oct. 2015

Automated full cycle of SAP Order to Cash (OTC) process including quote creation, order creation, delivery, baseline and release network order, equipment migration, handling billing blocks, invoice creation, contract creation, running statement process, collecting and applying the payment using SAP TAO.

Worked on various SCM, P2P, LE functions including checking material stock, stock creation, posting of stock, creating schedule lines for material, credit check management, shipping points, routes, goods receipt, goods issue, delivery documents and delivery blocks.

Primary point of contact for SAP Automation. Lead SAP Automation and conducted meetings with SAP teams to devise a strategy for automation testing and implemented regression testing. Reviewed the tests for order to cash, supply chain management and procure to pay modules with offshore team.

Created and documented test plans, business components and test labs for the requirements from different business teams. Assisted in developing test strategy. Gathered the requirements for testing, helped in setting up of testing tools, effectively reduced the manual effort and time by creating automated scripts.

Used HP Quality Center (QC), Quick Test Professional (QTP), Business Process Testing (BPT), and SAP Test Acceleration & Optimization (TAO) tools to create and execute end to end automated testing scripts.

Integrated process flow analysis of various SAP transactions and consolidated them in HP ALM to deliver the automated scripts. Created scripting guides for users and played a major role in maintaining test scripts. Generated reports for testing team consisting of the run results, defects, failed reports and passed reports data from ALM using Oracle SQL server to help understand the efforts of QA team.

Identified and resolved functional, data and tool issues during automation with the help of SAP Business Analysts. Business Intelligence Analyst Intern at Thermo Fisher Scientific Inc., Carlsbad, CA Sep. 2014 – Dec. 2014

Collaborated with senior business analysts to perform Quote to Cash (QTC) analysis on ERP systems for creation and implementation of Corporate Data Warehouse project.

Analyzed and documented customer, product and sales master data, order progression and invoices in various ERP systems. Also, documented critical data objects and data fields generated through QTC.

Analyzed data in all tables associated with customer, product and sales to determine which data should be used in reporting. Understood and determined the usefulness of data by comparing the uniqueness, null values and other redundant data. Maintained the status of the project using Excel and communicated team about the progress.

Assisted EDW data modeler and ETL developers on data extract and ETL development using Informatica. Also, prepared ETL specifications by mapping the source to target fields along with the logic associated.

Performed data profiling using Informatica analyst for various tables associated with ERP systems in order to make important data and statistics available for the data architect.

Performed extensive data validation using Oracle SQL Developer to check data consistency in order to increase the accuracy and reduce redundancy.

ERP Analyst Intern (SAP SD/OTC) at Dart Container Corporation, Mason, MI May 2014 – Aug. 2014

Configured sales order process activities like inquiry, quotation, order entry, outbound delivery documents, picking, packing, goods issue and transportation. Also, configured credit management, incompletion logs, text determination, partner determination and material determination.

Worked on pricing procedures such as condition types, access sequence, condition exclusion and pricing procedure determination and dealt with proforma invoices and e-invoices.

Conducted business process analysis, provided solutions for production support issues, worked closely with ABAP team and business to analyze, gather and verify requirements for customer master in the Order to Cash module.

Designed and developed functional specifications for system enhancements like sales order output or invoice output.

Worked on integration testing and testing of various transactions related to SD module. Assisted in post go live activities, production support and end user training.

Created transports for changes in configuration or enhancements and rigorously tested changes in development, quality and asked for UAT before delivering to production units.

Created reports for open sales order requests and assisted in making training documents and manuals for end users. Assisted SAP BW team in BO and BEx analyzer and query designer. Learnt SAP Lumira as independent study. Associate Consultant (SAP & Data Analysis) at Infosys Limited, Pune, India Nov. 2011 – June 2013

Designed and monitored software modules, objects, reports for P&G, Western Europe as a part of SAP MFG team. Developed objects, generated reports, function modules, form designs and worked on SAP scripts and smart forms. Configured the full array of functional activities for Sales and Distribution module.

Worked in SAP SD/OTC module dealing with Quotation, Inquiry, Sales Orders, Special orders, Contracts, Scheduling Agreements, Deliveries, Shipments, and Billing documents. Collaborated with whole business cycle functions from inquiry generation to invoicing for various business scenarios.

1 full cycle implementation of SD module including business blueprint, realization, testing, go live, production support for various priority tasks and knowledge transfer.

Assisted in various process like pricing, account determination, partner determination, contract creation, output determination, material determination and supply chain management.

Involved in Logistics Execution (LE) Module including shipping points, routes, transportation, goods issue delivery document configuration, delivery item categories, shipping point determination, shipment, picking, packing, delivery scheduling, delivery blocks: at item and header levels, posting goods issue in delivery.

Coordinating with onsite team in day-to-day trouble shooting tickets.

Prepared functional and technical specification documents for the enhancements and new developments. Also, worked on special business processes like Make to order and third party order process.

Performed error reporting, defect monitoring, and error rectifying and resolved complex issues in PTP process. Supported testing activities including test script creation, execution and documentation.

Implemented information management project using MS BI Suite. Accomplished data migration and workflow tasks, deployed ETL routines to cleanse and organize large amounts of data using SQL Server Integration Services (SSIS).

Performed Online Analytical processing using multidimensional cubes to derive cut throat insights using SQL Server Analysis Services (SSAS). Generated reports and interactive dashboards using SQL Server Reporting Services

(SSRS) for top management.

Project Intern (Java and SQL) at Bluestar Limited, Mumbai, India June 2010 – May 2011

Designed and developed ‘Material Coding’ software for Bluestar, India’s largest air-conditioning company.

Generated material codes for the products and added new material codes for the efficiency of the Engineering and purchase teams by using technologies such as Java and MS SQL 2008.

Performed cleaning, extraction, transformation and loading of data (600,000 entries of materials) from Excel to SQL. SKILLS:

Database, Technologies and IDE’s – Java, VB, SQL, Oracle SQL Developer. Business Intelligence – SQL Server Integration Services (SSIS), Analysis services (SSAS), Reporting services (SSRS) using Microsoft BI, SAS Enterprise Miner 9.3, Rapid Miner, Informatica Analyst, Informatica Powercenter 9, Informatica Workflow Manager, Information Analyst, UCINet and Weka, Jaspersoft BI, R programming SAP – SAP SD/OTC, SAP ABAP, SAP BW, SAP ECC 6.0, SAP R/3, SAP Test Accelerator and Optimizer, Net weaver 7.0, Crystal Reports, XCelsius, Dashboards, BEx Analyzer, Functional knowledge of MM, P2P, SCM. Microsoft Office – MS Word, MS PowerPoint, and Microsoft Excel (Advanced), MS Access, MS Project. Testing – HP Quality Center, HP ALM, UFT, QTP, BPT, SAP TAO, uPerform. Independent Study – OBIEE, SAP Lumira, Tableau.

CERTIFICATIONS & EXTRACURRICULAR:

SAS Certified for Business Intelligence and Data Mining – SAS Institute and The University of Texas at Dallas.

Google Analytics Individual Qualification certified – 88%, License No. 02491226.

Volunteer at the ‘Art of Living’ foundation and it NGO. RELEVANT COURSEWORK:

Business Intelligence Software & Techniques, Advanced Business Intelligence, SAP ERP, SAP BW and BI, Supply Chain Management (SAP APO), Web Analytics, Systems Analysis & Project Management, Operations Management, Marketing Management, Quantitative analysis of Risk & Uncertainty, Management & Organizational Consulting. ACADEMIC PROJECTS:

Supply chain software project with Business Cases, UT Dallas, Texas Executed the entire procurement process, created forecasts for finished products in the material planning process, ran MRP profiles to plan the demand, studied SAP APO with DP and SNP & SAP implementation methodology. System Analysis and Project Management for Hertz.com website, UT Dallas, Texas Gathered requirements for improvement of Hertz Car rental Website to improve customer satisfaction. Added functionalities like car availability notification and extensive car comparison. Developed ability to analyze business solutions and design information systems using object-oriented methodologies and project management techniques. Google Online marketing Challenge for Dallas Marketing Services Inc., UT Dallas, Texas Created Ads and ad words, ran ad-campaigns through Google Online marketing challenge, analyzed precise keywords based on the line of business, regularly optimized keywords for Dallas Marketing Services to increase brand awareness and drive more traffic to website. Worked on SEO, tracking & analyzing website traffic and PPC using Google Analytics. Business Intelligence Research Project on Cloud Analytics Server, UT Dallas, Texas Studied the intricate concepts involved in the functioning of Jaspersoft BI (SaaS) as a Cloud Analytics Server available on the Amazon Web Services Marketplace. Demonstrated a demo showing functionality of Jaspersoft. Worked on Jaspersoft analysis software, reporting software, dashboard, integration software, BI platform.

Contact this candidate