Business Analytics Consultant Resume Example Neubrain, LLC

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

Resume Overview

Create a job alert for [job role title] at [location].

About About

Help & Support Help & Support

Languages Languages

Customer Service Customer Service

Business Analytics Consultant Resume Example

Resume Score: 100%