Post Job Free

Resume

Sign in

Management Analyst: Business Process Improvement

Location:
Houston, TX
Posted:
July 31, 2019

Contact this candidate

Resume:

Professional Experience

Background consists of a diverse career 8 years+ as a resourceful leader in updating SAP configurations, troubleshooting, customizing SAP solutions, training users, and answering to their inquiries, estimating projects, designing project plans, held update meetings with stakeholder and supported teams. Business Analysis; experienced, highly functional SAP Analyst with years of professional expertise in Industry leading companies. Involved in 5 Full Life Cycle Implementations using SAP Methodology, Upgrades & Production Support Projects. Discuss requirements with customers, providing training to end users, assisting technical staff, developing procedures, and writing user manuals. Highly professional and excellent communications, analytical, interpersonal, and presentation skills. I also consider myself an expert multi-tasker who can efficiently execute and manage several projects simultaneously. In-depth knowledge of the processes related to purchase orders, delivery and billing, reimbursements, and business contracts. Expert Customizing SAP FICO modules and sub ledgers: GL, Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA); Treasury, Cash Management, Liquidity Forecasts.

Possess hands-on-experience in using various accounting software and proficient in the use of Microsoft Excel at an advanced level (Data Dumping, Pivot Tables, V-Lookups, and Charts/Graphs). Strong interpersonal skills allowing collaboration between cross-functional teams, Expertise: Financial Analysis, Budget/Forecast with Variance Analysis, Billing, Financial Reporting, understanding of Project Process and ability to analyze problems and identify solutions. Work extensively with the team to meet requirements, create prototypes and analyze workflow.

Principal Areas of Practice and expertise

Concise and clear cross-functional communication skills

Strong ability to quickly identify and resolve issues

Strong ability to work cross-functionally internally with teams, and externally with business clients/partners to gather the requirements and recommend functional or technical solutions

Experienced with working on various versions of SAP Enterprise Resource Planning Central Component [ERP &ECC] systems.

Focused detailed eye for identifying what the team’s needs are and managing the development of functional processes for improvement

Implement business processes, implement changes, and set up system configurations

Provide implementation or project/support to Finance Team

Major Data Management Related Projects

Payroll & Reporting Analysis

Jan. 2013 – Mar. 2019—Creative Technologies, Mar. 2019-Preseny- A3J Services, Houston TX

PT Project Remote Payroll / A/P Analyst for Manufacturing, Insurance, Retail Clients, and Transportation Clients

[Worked virtually while holding Full-Time Project Roles]

Assist with implementing newer version of cloud payroll system and trained end users on application usage, reconciling payroll bi-weekly, processing payroll bi-weekly, and semi-monthly in ADP, Perform Analysis and monthly reporting of company's finances, revenue, expenditures in MS Excel, also used excel for researching data in case of issues; perform filtering, pivot tables, and v-lookups with data. FI- AP Expertise in configuration and usage of automatic payment program, configuration of House Banks & Payment methods at country level, ranking order and account amounts, levels, creation of check lots, defined check lots and void reason codes, payment terms, clearing vendor or customer open items.

Consulted with business managers on improving organizational efficiency and understanding business processes

Developed business solutions and recommend new systems and/or procedures for process changes in the organization

Configured AR/AP for customers based upon interest calculation on items, account balance configuration / validation of substitution rules for documents, recurring entries, taxes, currencies and correspondence

Lead payroll cloud-based system migrations for ADP, OASIS, PayChex, and Payriot Payroll

Collaborated with internal stakeholders (e.g. services teams, product, and management) to improve cross-functional coordination and advancement of the business to support

successful implementations

Coordinated and Direct Cross-Trained over 60+ managers on newly implemented payroll

systems usage; requesting time off, and approving time off

Managed payroll processing via ADP Workforce, Oasis, Paychex, and Patriot Payroll Systems;

Process new hires, input benefit enrollments, salary increases/ bonuses or commissions

Process payroll or salaried and hourly employees of approximately 1,200 in number in [200 multi- state employees are processed for payment within the 1,200] inclusive of payroll deductions, child support court order garnishments, and tax payment garnishments.

Performs HRIS data entry and personnel file maintenance; responsible for the coordination efforts between payroll, human resources, and other departments to ensure proper flow and maintenance of employee data

Establish/maintain employee records; ensure that employee changes are entered correctly and made on a timely basis; review changes for proper authorization and adherence to APA policy including compliance with federal/state/local regulations

Process employee separations, and benefits terminations with insurance companies

Process the required documents through payroll and insurance brokers to ensure accurate record keeping and proper deductions, resolve employee deduction issues

Research/analyze and resolve routine benefit enrollment issues

Process monthly billings from insurance providers inclusive of requesting refunds for all terminated employees

Resolve issues with employee payroll issues inclusive of Time and Attendance for Time Card Submissions [Upload] per Payroll Week

Reconcile payroll prior to final submissions and validate pay register reports inclusive of Local, State and Federal taxes, including quarter and year-end reconciliations and Gross to net calculations reporting, audit, and balancing

Process monthly commissions for the sales team Schedule weekly meetings for HR Director via MS Outlook

Perform various other duties as assigned and necessary

Managed data mining using MS Dynamics; ran reports SAP, BW and export data to

MS EXCELfor cleansing and organizing before presenting to management the cost reconciliation

analysis showing variances per sales division location per BOM.

Achievements:

Wrote manuals for operational procedures on “How To"; ran reports in SAP, and BW, performed comparative analysis of both and spotted discrepancies for management needing corrective action.

Organized Financials in an easy to read and concise manner.

Created ad hoc reports for district sales managers and sales teams showing performance tracker analysis per product, per region, per sales amount, and volume.

Coordinated MS Excel Commissions Calculations Template for the Sales Director

Budgets, Financial Reporting & Job Costing

Mar. 2014 – Jan. 2015 GE Oil & Gas Houston TX

Lead Project SAP Data/Budget Analyst of IT Operations – North America & Hydril Divisions

Managed offshore teams, organized testers, test scripts, and delegated workload. Designed and mapped business processes and business solutions. Presented requirements and solutions to senior management. Cleaned up of accounts from 2012-2014; Managed several cross functional teams, & coordinating day to day duties running of projects assisting IT Product Owners, Project Managers and CIO’s by constructing consolidated weekly forecasts, monthly, quarterly, and annually with variance ($ and %) by account down to GL Line item detail for team members, and constructing (Consolidated Bottom Up Analysis) Source/Vendor down to GL line item detail; applications used to extract data – SAP

Configured the new GL functionality (standard company hierarchy, account groups, accounts for company codes, fiscal year variant, field status variant and posting period variant, implementation of parallel accounting methods and document splitting).

Configured AR/AP for customers based upon interest calculation on items, account balance configuration / validation of substitution rules for documents, recurring entries, taxes, currencies and correspondence.

Provided all fixed-asset product cost reporting, pricing, and reporting for relative to IT

Analyzed and organized data appropriately through anticipating the internal expectations of Product Owners, Project Managers, and CIOs

Coordinated yearly process of $4.5M IT budget with nine (9) departments and forty (40)

cost centers; budget responsibilities also include updating module with monthly monitoring

Drove strategic initiatives in operating performance across departments

Monthly and quarterly conducted Variance vs. Budget and Forecast analysis for the five (5)

departments in relation to IT Project Costs using MS Excel, calculated CAPEX Forecast

only in relations to IT Procurement Projects. Then developed MS

PowerPoint Presentation of those key financials for the Project Manager and CIO.

Actively lead consistent training weekly to improve productivity with Operations Management

Worked closely with NAM, Hydril, Pressure Control, Artificial Lift Teams to drive weekly as well as quarterly/annual forecasting processes

Managed month-end close of IT financials; drafted summary line item detail analysis as

frequently as monthly, quarterly and annually on Power Point by account down to GL, and

Source/Vendor down to GL line item detail with graph for presenting to

Management; Computed balances owed and record billing payments for invoices of

services rendered in MS Excel. Worked with project managers to receive support

documents on any discrepancies or inquiries

Developed and improved financial processes: Finance reporting tools, Management reporting tools, budgeting and estimating processes, etc.à Contributed to developing estimates, operating plans / forecasts / reviews

Developed new reports for process improvements with consistent usage of SAP

Achievements:

Business operations were more efficient and budgets were reduced by 85%, which improved company’s bottom line within 3 months after hire.

Bridged the gap between communication with finance, divisional stakeholders and customers; solved problems where misunderstanding played a strong role

Oct. 2012 – Mar. 2014 United Airlines Inc. Houston TX

Lead Project SAP Fuel Accounting Business Analyst – Canadian Airport Division

Cleanup of accounts after Continental-United merger; Managed many cross functional teams; coordinated day to day running of projects by assisting Senior Department Managers, General Airport Managers, and Ticket Agents by restructured new fuel reporting procedures, assisted airline vendors by performing secured actions for all over-payment resolutions of Fuel invoice error transactions containing billing non-compliance.

Worked as a team member for supporting the SAP operations in CRM. Performed in depth study of the business requirements by office visits and conducting interviews with concerned business users using structured and open questionnaires and recorded and documented the 'As-Is' business process flow.

Was involved in extracting, analyzing, merging data from multiple internal and external sources using SQL

Ran SQL queries to extract fuel data from SHARES System per month per airport then migrate to excel, cleanse, organize, and convert to USD from Canadian dollars and reconcile with SAP Reporting.

Managed month-end close fuel operations financials for over 65+ airports in SAP

Supervised operations for configuring Analysis for Senior Department Managers; secured updates on fuel and tax prices each month in Flimsy’s [Fiscal Fuel Database Management. System] analyzed cost transactions per airline partner

Developed and collaborated communication between General Airport Managers, Divisional Team Leaders, and where applicable with Ticket Agents

Consulted with General Airport Managers and Divisional Team Leaders, and Ticket Agents to define requirements and implement new strategies for submitting monthly fuel usage per airline partner to the Fuel Accounting Department

Directed division wide training for new reporting processes and procedures

Developed and presented reporting process improvements to General Airport Managers, Divisional Team Leaders, and Ticket Agents

Coached and mentored management on reporting processes and procedures to be used going forward

Implemented and enforced new reporting procedure for the Fuel Accounting Department

Achievements:

Business operations were more efficient and budgets were reduced by 50%, which improved department’s productivity within 3 weeks after hire.

Coordinated and promptly resolved GL variance issues with fuel Accruals and Actuals.

Bridged the gap between communication with finance, and divisional stakeholders for Canadian Airport Divisions; Designed technical process documentation in SAP - Wrote a “How To” manual on reconciling Canadian Airport Divisions.

Budgets, Financial Reporting, Payroll & System Implementations

Jan. 2010 – Dec. 2013 Non-Profit Organization - Houston TX

PT Lead Project Budget Manager/Business/Payroll Processor

Coordinated and managed financial operations for all Committee Chairs, and Senior Pastor, and Board Members. Setup new accounting system and trained users on operations. Performed testing of system, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place, performed budget analysis and planning.

Managed $1 Million budget, prepared cost/variance analysis weekly, monthly and quarterly,

prepared financial reports monthly; payables, incurring expenses

Managed and processed payroll for 25 employees inclusive of 5 hourly and 20 salaried by

entering hourly and salaried uploaded, performed payroll reconciliations on a bi-weekly basis

in MS Excel

Downloaded data to Excel and cleansed before coordinated and restructured set up new

fund accounting system; analyzed current system,

recommended necessary changes to be made to all Committee Chairs, and Senior Pastor,

identified impact of new system, implemented new system [ChurchPro]

Restructured new checks and balance tocorrect any mischarges during the month for Finance

Chair.

Achievements:

Coordinated & implemented/designed new fund accounting data input templates, increased cost tracking efficiency by 90%.

Improved operations; installed new accounting systems, policies, and procedures for smooth and effective operations within 1 week of hire.

Trained board members and chairmen on application usage

Fixed Assets Reporting

Jan. 2007 – Dec. 2009 Phillip Services Corporation – Houston, TX

Lead SAP Project Fixed Asset/Data Analyst

Coordinated testing, cutover activities, and managed post go-live support for SAP system. Set up fixed assets with assigned AFEs in SAP. Led accounting analysis and managed the conversion of data and integrated from one system to another in an organized fashion; transferred clean data with 1% error rating while multi-tasking and updated all data to reconcile with the operating system SAP constraints. Served as a liaison between business and IT team, to research, analyze and validate business solutions to support the project objectives.

Experienced in the areas of Sales, Marketing and Service with five years of experience as SAP SD/CRM functional consultant in Sales and Distribution Module and CRM Module with proficiency in all implementation phases right from requirements gathering and analysis to GO-Live/Production implementation.

Explained out-of-the-box use cases and configuration options, document configuration, and

perform fit/gap analysis

Identified product gaps and communication a liaison between the Accounting Department,

and IT Management/Development Teams;

Worked with business partners to schedule data migrations.

Provided extensive data analysis to provide trending and efficiency financial reporting for Fixed Assets

Analyzed processes As-Is and developed To-Be; ensured that the context and implications of change were understood by the clients and the project team.

Achievements:

Developed a system to tracked revenue projections, P&L of each satellite revenue center, commission payments, & financial analysis tools

Coordinated cross-training with accounting staff effectively within 3 days; Served as the role model for the department

Credit & Collections

Jan. 2001 – Dec. 2006 The York Group – Katy, TX

Lead Project Credit & Collections/SAP Business Process Improvement Analyst

Led analysis of data while implementing new organized business processes to electronically keep track of records; tested for internal operative effectiveness of controls with SAP. Ran ageing reports to target/prioritize collection intercompany account process. Used SQL server management studio queries to analyze the data from internal & external sources. Interfaced with internal customers to resolve all issues related to product billings.

Achievements:

Effectively collaborated and harmonized the invoicing, collections and the general billing departments records

Researched then drafted the necessary legal collection documents to clear 100% unpaid accounts.

Achieved 80% of outstanding AR in less than 6 months after hire, increased cashed flow and customer relations

SAP FICO Analyst

Houston, TX 77045

Areas of Practice

Customer Service

Budget/Forecast Analysis

Analytical Thinking

Application Expertise

Implementation of Systems

Technical Manual Drafting

Financial Reporting

Problem Solving

Time Management

Full Cycle Payroll Processing

Corporate Trainer

Industry Lines

Oil & Gas

E-Commerce

Technology

Manufacturing

Non-Profit

Computer Applications

SAP

ADP

OASIS Outsourcing

ChurchPro

MS Excel (Advanced)

MS Word (Advanced)

MS PowerPoint

MS Project

MS Visio

MS Outlook

Programming Languages

SQL

Education/Qualifications

BBA-Business Management

[Minor-SupplyChain Mgmt.]

MBA- Global Management

Professional Memberships

American Payroll Association

Society for HR Management

Fraud Examiners Association



Contact this candidate