Muhammad Sohail Email & Phone Number

Menlo Park, Ca, Us

• Created workflows to fetch data from different sources to HDFS using Alteryx• Generated 300+ Customer Agreement reports through MS Excel - Pivot tables, Index & Match, and VlookUp• Implemented VBA - User Defined Functions, Automation Macros, and Error Handling to automate report generation process by over 90% • Consolidated customer reports at divisional and MO level to assess accumulated impact of price changes and identify low margin regions• Developed price reports, using Pivot Tables and Slicers, at divisional and regional levels to assess price variances at customer and material level• Created sites, libraries, and promoted links, built custom workflows, and managed permissions and content for 400 regional and divisional managers in North America• Updated estimated costs and collaborated with Account Managers for upward revision of prices on low or negative margin agreements

Richardson, Texas, Us

• Extracted expense reports, through PL/SQL queries, from PeopleSoft FMS for 14 cost centers for account reconciliation and reporting purposes• Automated manual processes, through VBA led MS-Excel to replace paper work, to improve operation efficiencies by more than 60%• Used burn down graphs, Pivot charts, and geospatial maps for graphical illustration of research funds and scholarships allocated and expensed• Coordinated training activities of 12 consultants on PeopleSoft’s FMS modules General Ledger, Commitment Control, Accounts Payable, e-Procurement, and Project Costing.

Mclean, Va, Us

• Assisted in the implementation of an enterprise software solution for Servicing, Customer Support and Marketing functions. • Facilitated JAD sessions with end-users and business Subject Matter Experts (SMEs) to gather requirements. • Worked with Business Analysts to write Business Use Cases that accurately depict business processes for Loan Origination, Modification, Interest Accrual and Payment, Loan Charge off, Foreclosure and Balance Transfer modules.• Prepared test data, tests, debugs and refines applications software and prepares technical reports and documentation.• Engaged with project managers for setting team goals and targets, allocating resources for each team, determining team deadlines and monitoring team activities through daily scrums and planning sessions;• Tracked, coordinated, and assigned defects identified during the validation phase. This was accomplished using the Atlassian JIRA – an online tool for bug tracking and project management• Communicated outcomes and issues from each module to project stakeholders, including developers and product owners and recommending corrective measures.

•• Recommended working capital improvements to a telecom operator resulting in savings of more than $1 million• Prepared financial forecast and analyzed trends of an international chain of five-star hotels in negotiations of a $117.5 million debt restructuring plan• Performed financial risk analysis and identified key risk areas of an energy entity worth $95 million• Analyzed quality of earnings, working capital, financial forecasts and quality of net assets of acquisition targets to identify and highlight the risks in corporate acquisition deals

Master’S Degree, Management Science

Bachelor’S Degree, Accounting

High School, Advanced Level

High School, Ordinary Level