Data Information Systems

SHONTE APOLINAR

**** ******** ***, ***** **** TX 78664

***.******@*****.***

SKILLS & ABILITIES

Bachelor’s of Science in Computer Information Systems

Vast experience in Microsoft Excel and Word

Experience in using MS Access database

Business Operations and analytic experience

Able to generate and execute SQL and scripts

Experience in executing quarterly, monthly reports and adhoc reporting

Critical thinker

Excellent in a team setting

Experience in research, auditing and troubleshooting billing disputes

EXPERIENCE

Business Intelligence Analyst

Tangoe Inc.

June 2014 – Present

Analyze data for customer issues, defects and/or requests

Gather requirements from internal and external customers for custom reporting and import/export needs

Write queries that are intermediate to complex based on business needs

Validate global financial and invoice reporting

Executing commands and updates to the server using PL/SQL

Executing reports with Crystal Reports XI and Business Objects XI

Identify and create process improvement opportunities

Excel and PowerPoint

Writing process documents and offering training to team members

Reporting Analyst

Cisco Systems

January 2013 – June 2014

Report design and developing using Business Objects Infoview

Troubleshoot data discrepancies on security, finance and metric reports

Analyze contract purchase against invoicing

Device and revenue reconciliation

Launched an intranet website for Business Operations and currently manage the site

Automating reports and automating processes

SQL scripting in Business Objects Infoview and BO 4.0 versions

Data collection from different data sources and vendors to compile audit reviews

Ad hoc report requests and custom report design

Perform proactive billing audits and data reconciliation

Developing macros for automating integrations and formatting in Excel

Business Analyst

Hewlett - Packard

April 2012 – October 2012

Enterprise data harmonization project of database scrubbing 16,000 accounts in Salesforce.com

Vast experience in resolving data issues, contract discrepancies and troubleshooting

Developed multiple reports on a daily basis including active reports for the project team

Assessed report requirements and customized report according to specifications

SQL queries to extract data from multiple tables in SQL Server

Suggested new business processes and new solutions

Creating dashboards in Salesforce

Experience with Excel, SharePoint, Outlook and PowerPoint

Use Demand Tools Mass Effect to perform mass modifications to data sets and records

Data Analyst/DBA

AT&T Global Services

November 2011 – March 2012

Calculated and validated unmet commitment (shortfall) and early termination charges.

Corrected inaccurately billed or inappropriately waived shortfall charges and/or termination charges.

Performed monthly and quarterly reporting reviews to ensure contract compliance

Projection & forecast report customization

Created a customized monthly report of 12,000+ accounts for Sales team to view financial attainment levels

Worked in multiple billing system environments; UNIX, Oracle, Windows

Followed Account Receivable and billing procedures

Experience using Excel macros, formulas, lookups, imports, sorting and filtering, PivotTables

Managed shared mailboxes for Compliance department

Utilized Excel extensively and used macros for mass data exports

Worked in Business Objects, Ms Access, PowerPoint

Applecare Operations Service Data Processor

Apple Inc.

August 2011 – November 2011

Provided backend support to all delivery method changes

Stored and retrieved data from SAP database, record creation

Mitigated problems during major device rollouts by fixings errors in database

Processed change in order requests to delivery carriers

Performed fraud research on all accounts with new delivery requests

Worked in DM, CRM, Toolbox modules

EDUCATION

Bachelor of Science – Computer Information Systems

Friends University

August 2008 – October 2010

Contact this candidate