SEARCH

Business Analytics Consultant Resume Example

Resume Score: 100%

Love this resume? Build Your Own Now
BUSINESS ANALYTICS CONSULTANT
Professional Summary

Client service-oriented IT Professional with 15 years of experience in data analysis, data management, development of automated database reporting solutions (SDLC) and turning data into consumable data metrics using BI analytic tools. Expert in VBA and keen eye for detail. Proven fast learner and easily adapt to the ever-changing business and technological needs. Fully committed to the continuous improvement and standardization of processes and procedures. Excellent interpersonal relations and effectively communicate with all levels of management. Adept at quickly changing priorities, completing detailed and demanding work within time frames, and handling workloads with organization, prioritization and recognized attention to detail.

Skills

VBA * Visual Basic * SQL * PL/SQL * VB.NET * JavaScript * HTML * CSS Software: Workday * PeopleSoft * OBIEE | TOAD | BOARD | MS Office (Access, Excel, Word, PowerPoint) TOAD * SQL Server Reporting Services (SSRS) * SQL Server Integration Services (SSIS) * AS / 400 SQL Management Studio * SharePoint * Visual Studio 2010 * Raiser's Edge * Financial Edge * Bulk Mailer
  • Systems Development Life Cycle (SDLC)
  • Data management
  • Self-motivated
  • Process implementation
  • Database design
  • Excellent problem-solving abilities
  • System backups
  • Technical specifications creation
  • Coding and modularization
  • Business process improvement
  • Requirements gathering
  • Iterative development
  • Data analysis
  • Effective multi-tasker
  • Data privacy applications
  • Data backup and retrieval
Work History
Neubrain, LLC Business Analytics Consultant | Rockville, MD | January 2017 - Current
  • Business Analytics, Budgeting, and Performance Management Solutions.
  • Collaborate with team members and work with clients to develop and implement customized BI Financial Management and Budgeting MOLAP and ROLAP analytic reporting solutions using BOARD software for local, federal and state governments.
  • Write/develop Excel VBA applications to extract and transform text file reports for loading into application.
  • Within 1 month of learning BOARD application, selected as lead trainer for multiple client on-site application and report development trainings.
  • Selected as 1 of 3 key consultants to lead a Data Discovery Project for the US Air Force which entails gathering, dissecting and analyze multiple data sources, interviewing Air Force personnel, learning Military Personnel Pay Processing and Budgeting practices and studying data source files in order to extract key components for analysis.
Marsh and McLennan Companies Reporting Analyst | Hoboken, NJ | January 2015 - January 2017
  • Support global reporting needs of over 5,300 HR colleagues by creating a variety of custom HCM reports, dashboards, and optimized SRPs.
  • Perform data audits and collaborate with HR Business Partners and offshores PeopleSoft transactions team to rectify data integrity issues and improve accuracy.
  • Promoted to lead Report Tester within first 6 months for all enterprise-wide deployed data warehouse reporting SRPs, dashboards and all RDP changes.
  • Selected as 1 of 4 report writers to self-learn and develop 650+ custom reports for global Workday rollout and implementation.
  • Appointed Global Corporate Representative on HR Technical Council and Data Integrity Global Forum after exhibiting leadership abilities as a strong communicator with a passion for data analytics.
  • Created data solutions that resulted in reduced report generation time of up to 94%; assessed current processes, determined strategies for transformation, and conducted hands-on VBA coding.
John Wiley and Sons, Inc Business Systems Analyst | Hoboken, NJ | January 2011 - January 2015
  • Lead internal projects related to the development of financial reporting, budget management, and inventory control.
  • Evaluated and analyzed existing data systems and processes, gathering requirements and making recommendations to optimize efficiencies.
  • Built and implemented solutions using available technology resources to keep overhead costs down.
  • Built ETL/data processing applications with multiple data sources and developed intricate ad-hoc reporting solutions using SQL, VB6, MS Access VBA and MS Excel VBA, providing metrics with dynamic customized data.
  • Served as liaison among business units, project stakeholders, end users, and all levels of management to relay technical requirements and communicate needs and project updates.
  • Organized and conducted group and one-on-one training sessions to ensure successful implementation of new systems and processes, ensuring post implementation solution accuracy and effectiveness.
  • Maintained and continually enhanced seven legacy systems; increased reporting accuracy from 87% to 99% by modifying the data model to quantify data at a much more granular level.
Jewish Federation of SPBC Data Services Manager; Applications Specialist | Boca Raton, FL | January 2002 - January 2011
  • Diverse fundraising and outreach organization Managed 2 direct reports and oversaw all reporting for $15 million annual campaign and community outreach fundraising initiatives, including 48 major community events, accounting for $6.5-8 million.
  • Developed financial and campaign analysis reports for Executives and Board of Directors.
  • Performed database segmentation to generate and extract marketing data lists for direct mailings, solicitation mailings, phone solicitations and blast email communications.
  • Provided technical support and annual training, automated daily tasks by developing custom solutions.
  • Promoted in 2006 to Data Services Manager.
  • Create intricate SQL queries, stored procedures, VBA modules and applications to implement business rules, improve business management, and make redundant data processing tasks standardized.
  • Co-led the planning and implementation of entire donor management conversion from Raiser's Edge 6 to Raiser's Edge 7 and Raiser's Edge, data migration from SYBASE to SQL Server and Financial Edge integration.
  • Led project to migrate MS Access reporting "data warehouse" to SSRS, improving reporting and analytics speed by 90% and reducing ETL processing time from 24 hours to one hour, utilizing SSIS packages.
  • Translated business needs into a new data model and reporting structure for implementation of Campaign's New Donor Model targeted to raise $22 million.
  • Formulated and implement database segmentation strategies to generate and extract marketing data lists for direct mailings, solicitation mailings, phone solicitations and blast email communications.
Affiliations
Association of Information Professionals * National Association of Female Executives * Society for Tech Communication
Education
Bachelor of Arts Computer Information Systems and Marketing Florida Atlantic University

Management Information Systems and Marketing GPA: 3.8
Skills
VB.NET, business management, data processing, data migration, data warehouse, Financial Management, financial reporting, fundraising, inventory control, JavaScript, SharePoint, PL/SQL, PeopleSoft, SQL, SQL Server, SYBASE, technical support, Visual Basic, VBA, Visual Studio
Additional Information

Freelance VBA application developer in Finance industry

Build Your Own Now

Resume Overview

Companies Worked For:

  • Neubrain, LLC
  • Marsh and McLennan Companies
  • John Wiley and Sons, Inc
  • Jewish Federation of SPBC

School Attended

  • Florida Atlantic University

Job Titles Held:

  • Business Analytics Consultant
  • Reporting Analyst
  • Business Systems Analyst
  • Data Services Manager; Applications Specialist

Degrees

  • Bachelor of Arts Computer Information Systems and Marketing

Advertisement

Browse All Resumes