Sherwin Manalad

Contact - (Mobile)- www.linkedin.com/in/sherwinmanalad-sm- (LinkedIn) Top Skills Process Improvement Business Strategy Customer Service Sherwin Manalad Senior Lead Analyst at Vertiv Metro Manila Summary Gumptious self-starter with strong knowledge in reporting analysis through MS Office applications with years of hands-on experience in query writing and optimization using MS SQL and Hadoop as well as creating Power BI reporting tools and dashboards. Specialties: • Knowledge in Six Sigma Methodologies • Key Performance Indicators • Report Analysis • Report Automation • Process Improvement • Robotic Process Automation (RPA) • Sales Applications and Products (SAP) • Excel / Access / Outlook • SQL Server 2008 R2 / 2016 • SQL Reporting Services (SSRS) • Power BI DAX and Dashboards • Data mining in data warehouse, be it from Hyperion (Brio), Data Lake through Hadoop, or Oracle cloud applications • Facilitates basic training for SSMS and Power BI Experience Vertiv 3 years 1 month Senior Lead Analyst September 2019 - Present (1 year 1 month) Business Analyst September 2017 - September 2019 (2 years 1 month) * Vetiv is the rebranded name of Emerson Network Power Page 1 of 5 Supports Business and Corporate groups accross the organization with reports analysis, automations, and visualizations through MS SQL, Hadoop (Impala), SSRS, and Power BI. Emerson Network Power 6 years 11 months Business Analyst September 2011 - August 2017 (6 years) NCR - National Capital Region, Philippines Supports Bid Management with reporting and analysis to meet performance objectives. Assist with the preparation of periodic reporting and Key Performance Indicators. Responsible for the preparation of monthly S&OP, POR reviews and attendance at other meetings as required. Creates new reporting tools for analysis and develop metrics to better manage operations. Also perform some one-time reporting/analysis as needed to ensure Bid Management support stability. Anticipate changing demands and circumstances. SCOPE OF WORK  Participate in S&OP (Sales and Operations Planning also known as Forecasting), POR (President’s Operating Review) and KPI (Key Performance Indicators) related reports and analysis  Develop analysis tools through graphical presentation  Develop, maintain, and enhance VBA module and database reporting tools  Contribute tact-time automation for repetitive reporting to maximize efficiency  Document report process steps and other business processes in clear, concise English phrases  Support daily operations, commodity management and other group requests - related to division activities that includes but not limited to • Pricing set up in SAP (Systems, Applications, and Products) for all Customers, VARs, Distributors, and OEMs (Original Equipment Manufacturer) • Distributor Stocking report • End-customer backlog and shipping reports  Other related planned or one-time functions Projects/Contributions:  Automated customer backlog and shipping reports through SQL, Visual Studio, and SSRS Page 2 of 5  Converted various reports into SQL views and procedures that minimizes processing time  Supports Business and Corporate groups accross the organization with reports analysis, automations, and visualizations through MS SQL, Hadoop (Impala), SSRS, and Power BI Skills: • SQL Server Management Studio 2008R2 / 2016 • Hadoop (Hue) • Visual Studio • Power BI • Data extraction in Oracle – CRM on Demand and Sales Cloud CRM Accounts Specialist October 2010 - August 2011 (11 months) Mandaluyong City SCOPE OF WORK Process customer orders via EDI and Manual transactions (requires the use of SAP) Analyze and provide solutions to customer’s invoice dispute and expedite request Generate Shipment History report for customer’s reference to the status of their orders. Provide shipment dates and tracking details of all their orders that shipped. Generate Detailed Backlog Report to review status of open orders. Do follow up for orders that haven’t shipped but are on stock and follow up for those that are delayed. Process other transactions such as RMA, Free of charge Delivery, Credit memo and Debit memo request. Send out order confirmations, copies of invoices, packing list, etc. Received calls from Buyers, answering their questions in relation to pricing inquiries, stock availability, order status, part recognition and other order related questions Communicate directly with Product Managers in relation to pricing. Same with Planners and Shipping officers for order status and expedite request from Buyers. Accenture Accounts Payable Analyst October 2009 - October 2010 (1 year 1 month) Page 3 of 5 Mandaluyong City Freight Analyst : Accountable in generating monthly freight related reports Provides freight payment status to client and client's suppliers through email and/or call Accounts Payable Analysis Team : Provides invoice payment status to client suppliers and document email and/or call logs daily Resolves invoice payment issues that are raised by the client suppliers by coordinating with other teams until payment is made Process past due invoices that are submitted by the client supplier Responsible in analyzing invoice details prior to forwarding to the billing department of clients Provides initiative assistance to colleagues Ensures accuracy in all deliverables Has been a subject matter expert in both analytical post IBM Business Center Associate June 2007 - October 2009 (2 years 5 months) Eastwood, Libis, Quezon City SCOPE OF WORK Responsible team member of the Supplies Inventory Management Team Provides assistance by coordinating travelling employees with the respective agencies Other administrative task supporting internal customers KFC Philippines Service Crew February 2001 - August 2005 (4 years 7 months) Quezon City, Metro Manila, Philippines Food Prep Cook Pantry Counter Inventories Page 4 of 5 Education Far Eastern University Bachelor’s Degree, Business/Commerce, General · (2003 - 2007) Page 5 of 5