Sardar Khan Email and Phone Number

Lead team of 4 analysts in budgeting, reporting, and forecasting of over $800M in annual revenue.•Supervise monthly Forecasting and annual Budgeting Financial Performance Analysis and Forecasting. •Mergers & Acquisitions. Establish contacts with merger and sale brokers, particularly the ones that specialize in the staffing industry, and obtain information regarding acquisition target companies based on criteria established by the Vice President of Finance and CEO.•Initiated the process and procedures to eliminate the gap between On-shore and off-shore teams for more efficient and effective delivery of our operational and functional tasks/goals. •Working with HR department to streamline the expense allocations process.•Working with IT to create a Master customer list by division to have induvial or combined P&Ls by division/client. •Contracts Administration. Responsible for ensuring the company has processes in place to comply with the requirements of all contracts with its clients, suppliers, and subcontractors. Ensure all contracts, subcontracts, and related amendments are up to date.

Lead team of 2 analysts in budgeting, reporting, and forecasting of over $550M in annual revenue. •Pricing Analysis. As requested by the Vice President of Finance, conduct pricing development and analysis for proposals and other purposes including but not limited to price increase requests, price justification initiatives, and other special purposes.•Mergers & Acquisitions. Establish contacts with merger and sale brokers, particularly the ones that specialize in the staffing industry, and obtain information regarding acquisition target companies based on criteria established by the Vice President of Finance and CEO.

•Monthly Forecasting and annual Budgeting Financial Performance Analysis and Forecasting. •Special Assignments and Process Improvements. As requested by the Vice President of Finance, undertakes special assignments and/or leads process improvement initiatives to improve the company’s processes in specified areas.•Created a new model from scratch for corporate indirect cost to identify the driving variables in P&L and suggested different scenarios to cut down on corporate cost.•Created a highly detailed automated model for operations team which help them improve the productivity of the team, which resulted in increase of revenue and got promoted.

My focus is to provide the financial/Business analysis for Property & Casualty and Employee Benefit insurance. Work very closely with senior management including CFO of the region to facilitate communication, alignment, and execution of key initiatives. •Provide a meaningful and informational summary of monthly financial results to Operational Leaders and Senior Management. Evaluate actual results against expected performance and communicate areas for improvement. •Monthly Forecasting and annual Budgeting. •Generate monthly profit and loss statement and explain the variance on expenses, new business, and lost business.•Analyze change in market and timing of payment process. Forecast the change of market and timing as per the renewal of contracts and policies.•Provide efficient and effective analysis and impact of transfer businesses (in and out) of regions or among producers. •Calculate and review producer compensation, incentive, and bonuses, including impact of new business, lost business, change in market and transfers.•Record keeping of Licenses and permits as required.•Business Trend analysis of trailing twelve months for new/lost business and six months for change in market.•Create and present producer dashboard from databases for leaders to monitor individual producer’s performances. •Account reconciliation for specific client and producers.•Setting targets/goals for unvalidated producer and help them achieve goals by providing them monthly/quarterly performances analysis on their book of business.

As a part of H&A Investment’s team, I lead all aspects of financial services and reporting for five locations in Memphis, TN. My focus is to provide support and direction for the financial activities of field offices. I am responsible for the management of the Financial Controls. Work very closely with senior management team to facilitate communication, alignment and execution of key initiatives. •Prepare, review and analyze forecasts and recommend changes when appropriate. •Prepare monthly financial analysis and operational metric performance for presentation to Senior Leadership team.•Partner with colleagues to develop and analyze business goals and initiatives.•Design, generate, review and communicate P&L statement to key stake holders.•Negotiate pricing with vendors to improve profit margins and reduce cost.•Inventory analysis and management of products as required.•Financial reporting to higher management and be a part of decision-making as per analytical reports. •Manage the financial planning, financial modeling, forecast and budgeting processes and their continued development focusing on maximum company-wide support, efficiency and accuracy.•Responsible of two business types; Food and service, how to find the room for improvement by using different analytical techniques like SWAT analysis etc.•Cost saving and increased profit margin by detailed financial statement analysis with higher management. •Train new team members on tools, procedures, processes, administration and governance with leadership management guidance.•Calculate intermediate figures such as Bonuses, percentages, Strategic Hires, and commissions. Conducts advanced financial analysis.•Verbal and written communication with parallel team and manager.

•Identify opportunities for improvement by and among the company in US, Canada, APAC and EMEA.•Understands and works with scenario planning tools/models.•Designs, generates, reviews and understands reports through SQL queries. Uses aggregate data from multiple sources to assist in creating a complete analysis, improvement and/or recommendation.•Data extraction from several tools such as Business Intelligence, TM1, COGNOS to make reports in Excel, and dashboards in Tableau and PowerBI.•Budgeting & forecasting for Local Market Area as the Real Estate value differs state to state.•Act as a Subject Matter Expert (SME) for key systems/processes in Tableau reporting and its functions.•Reviews the accuracy of information provided and responds to requests from teams in US and Canada.•Prepares and presents results of analysis and reports along with their relative impact(s) to the business to all levels of management. •Acts as project lead, including supervisory and/or managerial activities, in the coordination of the analyst team to successfully complete specified projects between/among different LMA (Local Market Area), business unit, large department or work group.•Leads and facilitates communication of best practices, policies, procedures and initiatives to support field and LMA operations and LOB leadership. •Ensure shared knowledge to implement process improvement and performance improvement in business operations.•Train new team members on tools, procedures, processes, administration and governance. •Calculate intermediate figures such as Bonuses, percentages, Strategic Hires, and commissions. Conducts advanced financial analysis.

•Supports National Operations and Finance teams in creation of ad-hoc reports and analysis.•Collects data for various monthly processes and ad-hoc projects. Consolidates, summarizes and formats data for reporting and presentation to Leadership. Analyzes results as appropriate.•Leverages excel functionality to streamline and automate reports.•Completes detailed monthly and year-to-date financial variance analysis. Reviews actual expenses versus budget performance for revenue and expenses. Analyzes and identifies trends in spending.•Supports National Finance and Operations teams in the review of invoice coding to ensure accuracy.•Develops expertise in various financial systems. Supports National Finance and Operations in researching issues, fixing errors and answering system-related questions.•Communicate effectively with employees from all levels of the organization.

•Data mining, data manipulation, Data modeling and running queries in MS Access.•Customer Master Data cleansing and updating the master record in SAP CRM and build queries through SQL databases.•Extract data from SAP to Excel for manipulation and make models.•Analysis of Master Data with other sources in MS Excel, MS Access and SAP CRM.

• Provide daily support to metrics and reporting and gather business requirements to implement any changes, develop specification for data warehouse design, testing to ensuring data integrity, quality and deployment.• Collaborated with Business Transformation teams to develop Business Case for business transformation project. This includes identifying all benefits, costs and risks related to the project.• Built multiple models in MS Excel to quantify, analyze and forecast future cash flows. • Data Manipulation, Data Segmentation and Summarizing Data for financial reports analysis. • Performed multiple what-if scenario analysis.• Gained agreement with Senior Management and Business Transformation team leads and designate team members on the key performance metrics for the investment.• Collaborated with Business Transformation teams on the Benefits Realization requirements for future state. • Communicated with data technology associates the automated reporting requirements for the investment. • Analyzed the financial results of the investments against the business case and agreed upon performance indicators. • Followed-up on the actual results of the investment facilitating the completion of corrective action steps and documenting successes• Facilitated communication between appropriate stakeholders about the investment results and design the automated reporting functionality based upon the input from these communications during the investments early stages.• Developed and maintained various recurring and ad hoc reports by retrieving data from multiple systems and company’s data warehouse to generate complex Excel spreadsheets. This involved working with business users to identify data, gathering/reporting needs, refining requirements, locating data in the relevant systems, and building needed queries, pivot tables and charts to present the needed information.

• Prepared multiple financial models for inventory management, distribution center and transportation groups.• Reported daily and weekly operating metrics, including Sales, Gross Margin, Contribution Margin and daily census.• Analyzed and Improved commission structure for sales associates and regional sales managers.• Assisted Marketing and finance team with Occupancy analysis, pricing analysis, gross margin analysis, profit and loss Analysis and product line profitability.• Year over year growth analysis by program, Variance analysis of client level data.• Nested statement ( IF AND OR statement) and Bench mark analysis of data for generating reports.• Transformation of given data to required data by using Data formatting, Data filtering, Conditional formatting and Freeze panes.• Researched and solved reporting variances and implementing process controls.• Analyzed training program by conducting ROI analysis.• Provided continuity and accuracy in reporting by testing data for errors.• Developed reporting tools for data analysis.• Prepared financial model for the expansion project for the Port. The model forecasted future cash flows from the project and also calculated NPV and IRR.• Analyzed data to identify trends and forecasted for future.• Interpreted and communicated analytical results in relation to clients' evaluation and research objectives. Identified variables with information requests and associated desired information with the most appropriate available sources of data. • Conducted data set manipulation, extraction, compilation, file merging, and quantitative analysis of data including statistical analysis, cross-validation, and verification of data. • Increased revenue through various marketing techniques including coupons, incentives and cost analysis of products. Revenue increased an average of 20% every month for the first 6 months of business.• Awarded “Best Store of New Albany” in 2013.• Supervised and trained new employees.