Data Analyst Consultant, Learning Management System Resume
Miami, FL
SUMMARY:
- Quick learner, self - motivated and results-oriented Professional with exposure to the four fundamental actions of data analysis: Collection, Transformation, Analysis and Presentation and the three stages of the Reporting Life Cycle: Authoring, Management, and Delivery.
- Experience working with and analyzing business intelligence to determine trends and discrepancies for a fast paced, deadline oriented and quality focused environment. Known for ability to be analytical, creative and innovative. Reputation as a self-starter who performs well individually or as part of a team. Interested in a project career opportunity in the field of Information Management - Business Intelligence & Analytics.
TECHNICAL SKILLS:
SOFTWARE/WEB TOOL: Adobe After Affect Adobe Illustrator Adobe Photoshop Business Objects WebIntelligence Constant Contact Crystal Reports XI EventBrite iMovie Keynote Mail Chimp Microsoft Access Microsoft Excel Microsoft PowerPivot Microsoft PowerPoint Microsoft SharePoint Microsoft SQL Reporting Services Microsoft SQL Server Microsoft Word ProDiver rePortal SAP Skillsoft
PROFESSIONAL EXPERIENCE:
Confidential, Miami, FL
Data Analyst Consultant, Learning Management System
Responsibilities:
- Key Role: Assist in the data cleanup of newly implemented Learning Management System, SkillSoft. Partner with LMS System Administrator to gather and analyze requirements for data feed enhancements for over 9,000 records. Analyze data trends and discrepancy utilizing advance Excel skills. Coordinate with SkillSoft Learning Management Systems Administrator to successfully upload scrubbed data records. Troubleshoot data load issues and propose recommendations. Develop custom reports using Skillsoft Report module.
Confidential, Miami, FL
Senior Business Analyst, Human Resources Information Systems
Responsibilities:
- Updated employee data using SAP working with Business Solutions Groups
- Provided HR data for business reviews with the CIO using SAP to pull data
- Worked with business stake holders to consolidate HR Data Elements
Confidential
Senior Business Analyst
Responsibilities:
- Coordinated 2nd Annual Burger King Teacher Appreciation Day, donating over $30,000 worth of school supplies to Title 1 Schools.
- Managed relationships with national organizations and community partners such as Big Brothers Big Sisters, POSSE, National Urban League, EverFi, Habitat for Humanity, Network for Teaching Entrepreneurship (NFTE)
- Successfully designed and rolled out inaugural Confidential Connect Newsletter. A quarterly external communication highlighting Confidential initiatives.
- Placed various Confidential Ads in local and national publications including, Confidential Inc., Confidential, Confidential, Confidential, and Confidential .
Confidential, Miramar, FL
Business Analyst/Systems Analyst
Responsibilities:
- Assisted in trouble shooting and resolving several critical financial reports for the Finance Manager. These reports were high level, high priority reports utilized by our VP level management team as road maps for our company.
- Improved the performance of one of the companies key business report by more than 90% by modifying the SQL query.
- Successfully created a How To Document on using SQL Server Analysis Services via Excel for our senior management team. This document empowers our senior managers to self-service themselves with analytics.
Confidential, Miami, FL
Data Analyst Consultant
Responsibilities:
- Validated over 250 data element conversion rules leveraging Mainframe, SQL, MS Access, and MS Excel to extract and analyze over 3million records of legacy data and by working closely with Business Analyst, Systems Analyst, Software Engineers, Data Conversion Architects, and business users. The conversion validation was in the critical path of the project’s completion.
- Designed and built a database that was used to assist the Business Analyst team in reconciling BRDs to the ERD Model. The reconciliation ensured that each data element had business requirements and would be used in the new system. Database tracked over 1900 data elements and their meta data and over 70 BRDs. The reconciliation further assisted in the team’s mission of promoting data integrity.
- Successfully trained several team members in using Access for data analysis. Items reviewed: Designing Tables, Queries (Join Queries, Action Queries, Sub Queries, Aggregated Queries, and etc...) and forms, filtering data through table/query view, importing and linking external data.
Confidential, Hollywood, FL
Manager of Business Reporting - Report Developer
Responsibilities:
- Successfully developed over 40 plus KPI (Key Business Performance Indicators) Crystal Reports for the executive and operations team.
- Developed an automated senior executive KPI report package that were used for the executive meetings lead by the President of the company. Reports included the following data: sales revenue, sales ranking, sale leads, business operation efficiency, service cancellations, and recur revenue .
- Automated key company reports utilizing SQL to create views, stored procedures, Crystal Reports XI to develop the reports and web base report delivery tool rePortal to publish and schedule reports.
- Delivered several ad-hoc executive reports utilizing SQL and various functions and formulas within Excel(i.e. importing, exporting and manipulating data via pivot tables)
Confidential, Fort Lauderdale, FL
Experienced Internal Operations Coordinator
Responsibilities:
- Increased efficiency and quality of financial reporting systems by coordinating and implementing solutions using knowledge of database design and report design.
- Assisted / influenced management team in making key business decisions by providing essential business intelligence in the format of graphs, charts, data analysis and conclusions for World Wide Quarterly Business Reviews.
- Successfully prepared Business Process Documents for the new LMS system that were reviewed and approved by project stakeholders. Prepared the official new system material for the business users and facilitated several sessions.
- Received Operations for dedication towards department development.
Confidential
Program Developer - Business Analyst
Responsibilities:
- Significantly improved efficiency of reporting system by successfully designing and implementing Phase 1B of the Data Warehouse, which included updating database data model, SQL Data Transformation packages (DTS) and Crystal Reports.
- Improved knowledge base of Data Warehouse by developing accurate documentation on database design, data model, data dictionary and by co-facilitating sessions to bring end users up to speed in utilizing the reporting tool.
- Improved reporting systems efficiency by streamlining several data flow processes and data manipulations utilizing SQL Server DTS packages.
Confidential
Intern
Responsibilities:
- Reduced time of delivery by over 50% for lab servers, software and licenses by streamlining processes and creating standard Symantec Ghost images.
- Enhanced Consulting Lab’s knowledge base by creating multiple FAQ documents and “How To” guides.