Kam C. Prajapati Email & Phone Number

Dallas, Tx, Us

Memphis, Tennessee, Us

• Collect information from several sources and update and improve monthly dashboards and KPIs.• Explores diverse data sets from various sources to gather, synthesize, and analyze relevant data and draw conclusions to identify relevant issues and trends.• Finds patterns in the data and finds correlations in related or unrelated variables.• Develop metrics to drive business decisions.• Evaluate trends, develop actionable insights, and provide recommendations to management.• Present the P&L deck to Sr. Management and support the development of the annual plan.

Garland, Texas, Us

•Corrected and normalized data to summarize and group data for reporting, analysis, and dashboards.•Designed and created analysis, reports, identified trends, KPIs, dashboards, and storylines to drive growth and report performance, and guided the sales team in making decisions.•Monitored unstructured data, evaluated data quality and reasonableness, and made corrections to improve data integrity.•Created ad-hoc analysis and business performance metrics for senior management and business unit managers to help make decisions.•Gathered requirements to build custom fields and views for users to collect and organize custom attributes to collect data and improve reporting. •Provided technical support to users by researching and troubleshooting problems to resolve help desk tickets.Project Completed ~ Normalized the three-year historical data of postal addresses to create territory reporting and analysis.

Garland, Texas, Us

•Worked with CFO to create financial models for five business units and forecasted impact on gross margin due to increased tariff rates.•Consolidated five years transaction level data to estimate net increased duty on imported products to estimate the expected liability.•Provided sample data, of the imported items from China, to US customs for reclassification of duty and tariff.•Provide Ad-hoc analysis and reports to Sr. management and business unit managers.

Irving, Texas, Us

•Audited past five months of vendor invoices and recovered $15,000 over billed expenses.•Review invoices, approve and match invoices to purchase order using SAP by design.•Consolidat monthly budget review, analyze, report and update budget in SAP ByDesign.•Provide customer service, support, and training to field marketing team.•Assist in implementing planning and budgeting software Adaptive Insights, and CRM (customerrelationship management) module in SAP ByDesign.•Work with the marketing team and gather requirements for the CRM module, and create abusiness process flow.•Develope test plans for functional and UAT (User Acceptance Test) and help with resolution ofdefects.•Coordinat with the third-party development team including data migration, data accuracy, andtesting.

Burlington, Massachusetts, Us

• Responsible for analyzing, interpreting and determining the Vistex/SAP rebate system solution for more than 30 accounts.• Leverage relationships with customers to improve customer satisfaction while maintaining organizational priorities.• Maintain policies for Vistex/SAP Agreement objects, views and responsible for monitoring and reporting the effectiveness of Rebate administration processes.• Creating and maintaining rebate related agreements by contract including master data and business unit level data as required by the sales contract.• Ownership of rebate documentation; including all supporting data analysis, SOX documentation, and approvals.• Balanced and reconciled the Vistex/SAP System with the financial general ledger and marketing Funds sub-ledger. • Assisted in developing the annual budget for trade spends, generated forecasts, analyzed trends and performance.• Used KAIZEN method to identify root causes, and seek actively for performance improvement opportunities.Marketing Fund Auditor/Rebate Analyst, Dallas Texas • Audited payment request, verified trade spend budget and documentation to meet SOX compliance. • Validated and processed marketing and promotion invoices and volume rebate payments.• Ensure reimbursements are paid correctly and in accordance with GAAP, policies, and procedures.• Worked with a team to design, create, improve and maintain financial systems and models.• Collaborated, identified and raised issues to Field Sales Managers, Finance management or other functional groups to achieve resolution on effectiveness and efficiency of the rebate process.• Assisted during Financial Planning & Analysis process to consolidate data, and verify data integrity.• Utilized Vistex system inputs and validated trade rebate calculations to ensure accuracy.• Written and maintained SOP documentation for process improvement. • Built and managed databases using MS Excel and created reports and trends.

Lewisville, Tx, Us

• Retrieved data using SQL, Pro-clarity, Business Object, and other database applications. • Analyzed data from various sources and built driver models by applying different methods. • Assisted in building a predictive revenue model using drivers for several products and business entities.• Documented method, process, and assumptions for continued improvement by applying best practices.

Dallas, Texas, Us

• Consolidated ten years of historical data and created a meaningful trend analysis. • Performed due-diligence of financial statements of an acquired company.• Forecasted new and existing projects revenue based on the percentage of completion method. • Consolidated projections and monthly income statement of several divisions.• Created a cash flow model for new projects. • Casualty insurance, Bank fee and ad-hoc analysis, and projects upon request.

Slough, Berkshire, Gb

Provided analysis and support for multiple functions: Finance, Treasury, Marketing, Consumer Credit, and Sales support• Increased productivity and Improved process.• Enhanced the sales forecasting, budgeting, and reporting process, resulting in a more accurate forecast.• Assisted VP finance and corporate lawyers in gathering financial and other data to prepare Form-S1 to file with the SEC.Finance• Assisted in developing the annual sales plan, AOP, and rolling twelve-month forecasts. • Generated variance analysis; actual vs. budget, trend, and driver analysis for reporting.• Coordinated publishing of financial reporting packages and profitability reports for management.•Tracked and analyzed material, labor, overhead, and packaging costs for all products.•Produced IRI and CPG market data analysis for Sales, Marketing, and Investor Relations. •Measured the impact of National and Local marketing programs using weekly sales and market data.•Helped execute planning, forecasting, and analysis of Sales and marketing Promotion programs.•Created Pull-Through Production forecasts for the plant to align inventory levels based on product demand and reduce the cost of carrying inventory.•Completed internal and external auditor requests relating to Sarbanes-Oxley and tax reporting.•Supported the accounting department as needed for timely financial reporting.•Provided financial, marketing, and sales forecasts for new products and pricing ad-hoc analysis.Treasury• Provided short and long-term rolling cash/liquidity forecast. • Daily Administration of cash positions, processing wires, ACH, disbursement, and investments. • Executed positive pay and other electronic transactions using online banking service.• Interacted with banks and financial institutions to resolve problems. • Developed and implemented treasury policies and procedures. • Implemented SOX control process.

Slough, Berkshire, Gb

Sales Support / Trade • Forecasted sales annually and monthly based on seasonality and assumptions. • Provides support to trade directors and sales team for national and regional accounts. • Reviewed field sales commission plan annually and implemented changes. • Created detail ad-hoc analysis and presentation for sales and marketing using Nielsen IRI, IMS, CPG network, Retail Link, and other syndicate data. Commercial Credit • Coordinated new account setup and assigned initial credit limit for new customers. • Used Dun & Bradstreet and financial reports of customers, and generated ratios to evaluate financial status.• Consulted with customers to resolve complaints and verify financial and credit transactions.• Communicated with sales and accounting departments regarding past-due accounts.• Assisted accounting department in collecting Account Receivable balances.• Adjusted credit limits based on customer requests, credit reports, additional research, and based on the past payment history.

B.S., Accounting

Data Visulization With Tableau - April 14, 2018

Reports And Dashboard - March 27, 2018

Sql Server 2008, Business Intelligence Development And Maintenance

4 Day Condensed Clarity 7 Training Session By Ibm - Building Templates And Reports

Advanced Excel Pivot Table, V Loolup, Macros, And Access, Advanced Crystal Reports, Comptia A+

Financial Statement Modeling In Excel