Business Analytics Consultant Resume Example
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.
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 |
|
- 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.
- 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.
- 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.
- 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.
Management Information Systems and Marketing GPA: 3.8
Freelance VBA application developer in Finance industry
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
- Completeness
- Word choice
- Length
- Typos
Resume Overview
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
Similar Resumes
