Sales Management

OVERVIEW

Results-oriented Business Analyst with over 10+ year track record of successfully improving employer’s competitiveness and performance through collecting, reviewing, and analyzing information. Uses root cause analysis to recognize issues and develop process improvements that lead to cost savings. A team player who is known for excellent verbal and written communication skills.

CORE QUALIFICATIONS

Strong problem-solving, reporting, data gathering, and analytical abilities.

Knowledge of relational database management system, ServiceNow, and Business Objects.

Proficient with MS Office including Excel VBA, PowerPoint, Access, and Word.

PROFESSIONAL EXPERIENCE

HCL America, Inc., at Deutsche Bank, Jersey City, New Jersey

Senior Business Analyst, Apr 2015 – Feb 2017

Created various local and global reports in Access and Excel to enhance management team awareness of ticket and user subscription data with productivity analysis, SLAs, and trending. This includes automating excel reports using VBA macro.

Managed multiple Additional Service Requests (ASRs) contracts by creating statement of work and completion of work documents. This includes follow-up with client to make sure contracts are fully signed to avoid billing issues.

Developed global reports using client based Business Objects and ServiceNow data sources to assist global and regional managers on how to better serve the client.

Developed transaction documentation template to assist technicians on how to provide simple information the client requires for each Desk Side ticket closed in order to simplify and speed up billing process. This implementation helped reduce the amount of time the client spends on reviewing billable tickets and lower the number of monthly disputes by the client averaging between 300-400 tickets down to 30.

Worked directly with client on a global project to locate client’s missing assets within their dataset, as well as, helped to discover issues within client’s global asset inventory system and provide recommendations to correct them.

Assisted management and client with testing of ticket SLAs using ServiceNow UAT ticketing system to ensure client implemented SLAs are functioning properly.

Prepared procedural documentation for all reporting processes.

Prepared monthly invoices to client valuing at approximately $200k.

CompuCom Systems, Inc., at Deutsche Bank, Jersey City, New Jersey

Business Systems Analyst, May 2007 – Apr 2015

Created various reports in Access and Excel to assist management team with productivity analysis, trending, and invoice processing. This includes automating excel reports using VBA macro.

Prepared procedural documentation for all reporting processes.

Managed multiple Additional Service Requests (ASRs) contracts by creating statement of work and completion of work documents. This includes follow-up with client to make sure contracts are fully signed to avoid billing issues.

Prepared monthly invoices to client valuing at approximately $200k.

Becton, Dickinson and Company, Franklin Lakes, New Jersey

Business Analyst, Jan 2005 – Sep 2006

Facilitated the US Sales Organization’s growth and market penetration by designing and developing promotional validation reports.

Assisted Regional Business Managers in determining which sales representatives were the top performers within the company by creating Access databases to query and generate reports based on assigned metrics.

Improved effectiveness and efficiency of various departments by the automation of excel reporting using VBA macros.

Used SAP and Business Warehouse Analyzer to generate data for upper level management.

Utilized Synergy Enterprise Incentive Management software to produce reports for sales performance and compensation analysis.

Prepared procedural documentation for all reporting processes.

Citigroup, Volunteers of America, Jersey City, New Jersey

Analyst, Jun 2003 – Jul 2004

Various consulting projects that utilized my Excel and Access expertise.

Posted journal and general ledger entries.

Prepared monthly budgets.

Generated and automated excel reports using VBA macro.

Supervised work queue requests.

Prepared invoice payments.

Managed client funds.

The Chubb Institute, Jersey City, New Jersey, 2003

Studied full time for web development and business programming.

Nextel Communications, Inc., Rutherford, New Jersey

Corporate Account Analyst, May 2001 – Apr 2002

Developed VBA applications in Excel to generate reports.

Relational database processing using Structured Query Language (SQL) to query reports.

Liaison & single point of contact for the Data Warehouse & Account Management team to provide accurate reporting on revenue, inventory, and service penetration for a portfolio of Fortune 100 customers generating over $100 million yearly.

Performed Database management involving Microsoft Access and Business Objects.

Trained employees on Microsoft Excel and Access.

Used Vantive and Ensemble to assist Corporate Accounts Dept.

Financial/Reporting Analyst, May 1999 – May 2001

Prepared monthly summary variance budgets by department.

Generated reports in Excel and automated data using VBA macros.

Researched and maintained statistical data integrity on the web.

Used Business Objects to run queries and generate reports.

Generated daily reports for upper level and executive management.

Designed flow chart analysis for Human Resource Department using Visio.

Created databases in Access and queried the data to generate reports.

EDUCATION

The Chubb Institute, Jersey City, New Jersey

Diploma in Web Development and Business Programming, 2003; Star Student Program

New Jersey City University, Jersey City, New Jersey

B.S., Business Administration, 1997

Contact this candidate