TECHNICAL SKILLS:

Applications/softwares: Expert in Microsoft Office Application MS word, MS Excel, Access, Outlook, MS Power point, MS Publisher, MS tools; Tableau, SQL, Very good understanding of C#, ASP.NET, ASPX, AJAX, knowledge in, data flow diagrams, case tool analysis, work & process flow diagrams; have knowledge in Corel, Photoshop, HTML, Macromedia Dreamweaver, MS Visio, Visual Basics, Visual Studio, SAP, Business Object (BO), Ezetop system

Systems: PeopleSoft Financial and Student System, Windows OS, Intelliworks CRM, Datapro, Blackboard, SharePoint, Global Innovative Venture Knowledge base System (GIVE System), VACS system (Vocational Adult Community System), ISIS system (Integrated Student Information System), Enterprise Information System (EIS), Health Informatics Systems

Databases: Microsoft SQL Server, PeopleSoft Financial and Student Query Database, Global Innovative Venture Knowledge database, Hoover, Vocational Adult Community Database, Integrated Student Information System Database, MS Access, MySQL database

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

Senior Business Intelligence Analyst

Responsibilities:

• Designed, Implement and maintained BI System. Gatheird and documented procedures and support BI data warehouses (SQL). Data extraction, transformation, mining and loading (SSIS, SSAS, SSRS). Coordinated wif developers and technical team to resolve issues that the business administration may raise or want to implement.
• Provided Executive Team proper analysis and data for major decision making. Coordinated and analyzed KPIs to diminish potential risks or to get approval of future promotions. Provided Senior Operation Managers wif intelligent information to measure past performances and improve future performances to attain targets, budgets and objectives.
• Analyzed and coordinating project plans and product roadmap to identify risks and create mitigation plans. Coordinated wif IT, MIS, Data Warehousing, to obtain relevant data for required analyses and test market application systems for accurate reports.
• Prepared business cases, advised team on better way to attend their targets, monitoring the business and markets KPI’s. Assisted and helped coordinating multiple projects - Ezetop, UQube and applications- MS Office (word, excel), SQL, Google analytics, from the 32 local markets and assuring accuracy of all data for board meetings.
• Supervised closely wif local MIS and IT teams to get local market data from SAP Business Object (BO) system and to gather enterprise business intelligence (BI) on all product lines. Performed modeling and analysis using MS Office application (Word, Excel) and EZTOP system on product/Budget and forecast including variance and trend analysis.
• Prepared weekly and monthly financial reports, detailing product trends, forecasting, and made recommendations on promotions needed to grow the business financially. Ongoing market Analysis of customer preferences, needs, financial and economic trends; served as coordinator wif IT and Finance team in 32 markets to assure accuracy of group’s revenues.
• Developed ongoing analysis on customer profiles and business trends to help the commercial team fine tune their strategies to achieve revenue targets. Analyzed key performance indicators (KPIs) from different reporting systems and financial models to forecast future needs. Trained new comers to be familiarized wif different software systems, applications and the business. Created a Business Intelligence process using SQL and MS Office software applications.

Confidential, Miami, FL

Senior Business Analyst/Project Coordinator

Responsibilities:

• Reported to the Associate Dean of Accreditation; Gatheird requirements for learning outcomes, analyzed student data and provided report for decision making. Extracted data from PeopleSoft and financial system to create several datasets for analysis. Data modeling to create BI dashboard for great views of the student’s learning outcomes.
• Provided system support to the online courses and coordinated system implementation. Designed, tested, reported, implemented and maintained the colege data and created datasets for safe keeping of student information and for reporting student learning outcomes to the States. Served as coordinator for all projects involving the department.
• Worked wif the COB Data Management Director, Program Managers, IT Staffs and other Business unit, UTS, Confidential Online, OPIE, and Technology Center to coordinate the Assurance of Learning (AoL) for the COB Office of Accreditation. Managed AoL website, department financial documents; implemented successfully a new Customer Relationship Management (CRM) system.
• Updated the Associate Dean of Accreditation regarding the AoL process and provided reports and recommendation to improve the registration procedure to enhance the student learning outcomes using CRM Software. Supervised the AoL process documentation and software installations from IT staff; resolved issues, analyzed, and provided potential solutions to implement for improving the undergraduate AoL process. Keep track of the office financial expenses.
• Assisted the Associate Dean wif the COB accreditation reports. Served as liaison between IT, Confidential Online, COB Finance and the colege of business Office’s office of Accreditation. Reconciled finance reports and provided necessary documentations to controller office when asked. Trained and guided new comers, MS Access, MS Office software.

Confidential, Miami, FL

Data Specialist

Responsibilities:

• Assisted the school TEMPPrincipal and Registrar wif Data Management and the center financial operation such as registrations fees, book orders, ID fees, and tuition payment or fee waiver. Alerted the treasurer if their were any transactions that do not comply wif the Miami Dade Publics School’s policies and procedures.
• Kept track of customer information in VACS application (Vocational Adult Community System) and the accuracy of the data. Assisted wif the school’s transaction processing, office administration, and work wif different school projects. Registered, provided IDS and entered customer information in School's Database. Managed and helped ESOL team developing their learning software system to meet client expectations.
• Assisted and enrolled customer into the SAVES Program by checking their eligibility in VACS and ISIS System and wif the state rules, provided reports based on School Database for decision making to the School Administrators.
• Kept track of attendees. Secured the schools information and informed the administration if their was a security concern.

Confidential

Database Administrator

Responsibilities:

• Managed website using Acrobat Macromedia Dreamweaver software, helped IT staff succeeded in implementing a better dynamic system, prototyping, implementation, development, testing, HTML and SQL coding.
• SQL Database maintenance, Manage DB, Query DB using SQL system, keep track of SHACOM Database and Technical documents. Improved SHACOM information system by redesigning the DB tables.
• Worked and contributed to the success of IT and financial projects (Implemented and deployed database and website from MS Front page to Dreamweaver)