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