SUMMARY

• Functional BA with high analytical and organizational skills and 10+ years leading end - user training.

TECHNICAL SKILLS

• Excel
• VBA/macros pivot tables
• Power Pivot
• Power BI
• VLOOKUPS
• XLOOKUP
• INDEX/MATCH
• CHOOSE
• ISERROR
• IFERROR
• AML/KYC

PROFESSIONAL EXPERIENCE

Confidential

Business Process Consultant/VBA Developer

Responsibilities:

• Excel/Outlook/Access VBA for automation and tool development; metrics/dashboard/data visualization to measure KPIs, financial forecasts, revenue, sales, reorder points, anomalies; industries: agriculture, advertising, financial, manufacturing

Confidential

SAP Business/Data Analyst

Responsibilities:

• ETL, data mapping, data cleansing, data enrichment, data validation, and data migration for cutovers and go-lives for a project to implement SAP 4/HANA customized bolt-on for metals manufacting
• VBA/user forms to complete objects and deliverables for MDM load; document and report on cutover deliverable progress

Confidential

Business Analyst

Responsibilities:

• Reshaped policies into a comprehensive Global Procurement S2P policy to satisfy audit requirements and align policy with new S2P procedures and objectives (SAP/Ariba)
• Identified S2P compliance risks and metrics; vendor scorecard metrics; automated reports (Excel, VBA)
• Developed and created training scenarios and a communications plan for a mandatory, global S2P policy implementation
• Edited and polished Global Procurement training deck for SAP/Ariba for capital expenses and operational expenses

Confidential

Sr. Business Analyst - IT/Supply Chain

Responsibilities:

• Worked with SVPs, VPs, and on- and off-shore management on an in-process proprietary system (Agile) to ship products from manufacturers to warehouses or customers by planning and executing data migration from legacy systems
• Developed and presented UML for business processes and use cases to senior management, including resource expectations
• Engaged with offshore management and business teams to develop reports (PL SQL) to meet US Customs import requirements (Excel/PL SQL) and identified data anomalies with reports and data gathering process
• Built process improvement tools (Excel VBA/macros/conditional formulas) to: extract data from emails (Outlook/Excel) to identify service gaps; increase team’s QA and substantially decrease errors and turnaround times on order fulfillment
• SAP CRM data cleansing and data enrichment (Excel) to create and cleanse data (ETL) for master data (MDM) upload
• Maintained KPI metrics/dashboard, forecasted sales revenue, shipments, status reports
• Identified defects and workarounds; Go Live support; built Excel tool to audit shipment compliance reports (Excel, VBA)
• Trained and mentored analysts on business processes, proprietary system, and customized tools

Confidential

Business Process Consultant / VBA Developer

Responsibilities:

• Created executive-level KPI dashboard template for multiple projects with a two-shore model using Access/Excel/VBA/Power BI to audit and: measure Service Level Agreement (SLAs) and Operational Level Agreement (OLAs) compliance (Quality Center) identify training gaps and staffing model inefficiencies; identify anomalies, data integrity issues, and redundancies; determine root causes of unexpected outcomes
• Business process modeling UML (Visio) of defect lifecycle, identifying stakeholders and handoffs across internal teams and third-party vendors and to be used as job aids to reduce future data integrity issues

Confidential

Business Process Analyst

Responsibilities:

• UML (Visio) for Process Excellence business process modeling of As-Is and To-Be End-To-End Integration of cross-functional teams (Design-To-Deploy: Create and Maintain Material, Data, Work Centers, Functional Locations
• Developed tool (Excel, VBA) to identify and align use case integration points across six end-to-end business units for multi-site metal and non-metal manufacturing
• Developed tools (Excel VBA) for collection data for SAP Master Data Management (MDM) validating Create/Change/Block Requests for Vendor Master, Material Master, Customer Master, Cost Centers, and Chart of Accounts data

Confidential

Supply Chain Analyst / Business Analyst

Responsibilities:

• Identified and implemented process improvements to create efficiencies between Construction Managers and vendors minimizing 3Way Match exceptions
• Reduced lead times and increased accuracy in ordering parts by developing a tool (Excel VBA) to sanitize 10,000+ new and obsolete parts (in Item Master) to identify correct part numbers and supply chain sources
• Decreased gap between forecasted and actual financial spends by developing a report identifying actions to reduce financial anomalies
• Data analysis and reporting to align project dollars with construction milestones and forecasts (financial forecasts v actuals)
• Disproved a perception of work effort misalignment by developing a root cause analysis report of missed financial forecasts
• Engaged with vendors on understanding and completing new closeout processes for On Air Sites
• Developed integrated reports across: Mobius, CASPR, Oracle, Siterra, Sweettooth, CSS

Confidential

Business Analyst

Responsibilities:

• Developed metrics to drive and measure teh remediation compliance process of borrowers' claims of servicer errors, misrepresentations
• Moderated meetings with a Big 4 consulting firm to manage teh process of complying with Federal Consent Order
• Project status and in-flight analysis (Excel and Business Objects, Deski, Webi) of open and completed items for multiple business units
• Built Excel/Outlook tool to identify electronic file build requirements for six teams and measure progress, team workloads and capacities
• Reduced workload of two analysts by 80% and 40% by automating reporting within data compliance specifications
• Increased efficiency of Default Operations Review by over 100%

Confidential

Reporting Analyst/Project Manager

Responsibilities:

• Helped establish Northeast Regional reporting and project management group processes, including report formats and templates
• Report automation (Excel VBA) and data integration (CASPR, iPlan, POR/POE/POD) - SAO, NSB, LTE, UMTS, ETTCS
• Production, Forecast v Actual spends and builds, Data Integrity, Critical Path, Glide Path, Gap Analysis
• VBA/macros, Confidential -SQL, Microsoft Query and ODBC, SSRS
• Gathered and interpreted report requirements from Regional Project Managers, Area Managers, Directors
• Developed reports through entire SDLC: requirements, specifications and coding, testing, debugging, documentation, maintenance
• Created PowerPoint decks and presentations on report usage and interpretation; maintained SharePoint reports and templates

Confidential

Call Center Director

Responsibilities:

• Established new Call Center for business process support for PA state government enterprise system
• Staffing/Training for proprietary and third-party systems; developed SOPs; workflow and problem-resolution processes
• Developed metrics tool (Excel) to provide analysis, defect tracking, trends, training gaps
• Converted ticket backlog to a First Call Resolution (FCR) average of 94% in four months, with 300 calls/week from 4k+ users
• Identified defects, enhancement opportunities, new requirements; UAT and on-site Go Live support and training; defect resolution signoff
• Collaborated with stakeholders to implement enhancements, new functionality, GUI redesign, and to minimize project risks
• Translated policy and business processes to system processes for users, developers, and call center staff
• Collaborated with developers on defect resolutions
• Led business development workshops resulting in teh start-up or expansion or 24 small businesses (four brick-and-mortar)
• Delivered workshops on personal and business finance for small businesses
• Developed tools (Excel and SQL) to identify and reduce fraud within non-profit programs