Data Reporting Analyst Resume
0/5 (Submit Your Rating)
SUMMARY:
- Systems Analyst, Data Reporting Analyst, Software Specialist, Billing Consultant, Application Administrator
- High - energy professional, with15 years experience, applying process, analytics, and technical skills to improve individual team & organizational performance. Successful in partnering with stakeholders, top-level management to evaluate needs, define strategies, and ensure timely delivery of all projects. Display excellent communications, customer service, and problem solving skills. Strong knowledge and experience utilizing excel, vlookups, matches, IF statements, sorting, and filtering.
- An impassioned leader who exhibits the ability to perform well under pressure, able to lead and follow with an ability to build strong, sustainable relationships with internal and external individuals.
TECHNICAL SKILLS:
- MS Windows NT/2000, MS Vista
- Nortel & Cedar Point Network
- R-Studio
- Business Objects Reporting
- Toad DB2 6.1
- Charter Intranet, Web
- Broad Soft Network
- SQL, Visual Basic
- IQ Navigator
- Vividstaff Billing System
- ICOMS Billing System
- Vantage Reports
- CSG Billing System
- SharePoint
- Symantec
- RevGen and ERS
- Data Warehouse/Modeling
- Rumba
- Outlook
- WARP (Web Admin Reporting Portal)
- BackOffice and BDW DB
- Remedy, Lync
- Strong Excel, Access, Word, Outlook
- Macro Programming
- Hex Reader
- Bac
PROFESSIONAL EXPERIENCE:
Data Reporting Analyst
Confidential
Responsibilities:
- Interpret data and analyze results using statistical techniques to create weekly waves
- Interact with FA’s in field to answer any questions related to the segmentation tool process
- Created and maintained activity database for reporting purpose
- Extensive data cleansing and analysis for data validation
- Using pivot tables, formulas (v-lookup and others), to manipulate large amounts of data to perform data analysis,
- Filter data by criteria and priority indicators to locate and correct existing or potential problems
- Work with management to prioritize business and information needs for each wave process
- Responsible for validating good data and purging invalid/bad data.
- Define, document, implement and track process flows for all processes and rules associated with ‘Client Segmentation’
- Interact with cross functional teams to ensure business processes and rules are aligned
- Created reports utilizing vlookup of both internal excel worksheet and external data, as well as multiple worksheets
- Audit and monitored discrepancies between reporting databases
- Acquire data from primary or secondary data sources for uses in analysis and trending.
- Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information
- Monitor and answer questions from field representatives related to segmentation process
- Understand policies, procedures and practices for analysis of business performance and impact
Independent Contractor
Confidential
Responsibilities:
- Manage workflow to ensure payroll transactions are processed accurately and timely
- Reconcile payroll prior to transmission and validate accurate/timely reporting when necessary
- Execute e-Time and attendance data and interface with payroll process
- Answer phone, scheduling and any other basic office need required to assist employees
- Administers Help Desk support via phone, email and in-person requests.
- Composes and types routine correspondence and memos, utilizing clear and concise communication
- Organizes and maintains file system, assist with vendor communications, technology order placement and tracking
Systems Analyst
Confidential
Responsibilities:
- Created, implemented, and managed new/existing data functions for internal operations via BackOffice DB application; including loading, extracting and validation of client data
- Interacted daily with internal/external customers to ensure accurate understanding of application process
- Created, executed, and verified complex test plans for all telephone launches/upgrades utilizing Excel
- Import and scrub data based on specific criteria for AMA or EMI messaging
- Provide data cleansing support and validation of data for use in reporting of information
- Utilized Excel spreadsheets to generate daily trending reports for all DA (Directory Assistance) data
- Performed data collection and analysis of system requirements and displayed strong working knowledge of applications and systems particularly CSG Billing system
- Ran SQL script monthly to determine product code locations
- Ran CSG macros utilizing Vantage or Access database
- Evaluated data trends within AMA/EMI and transformed complex data files into meaningful and presentable reports
- Provide subject matter expertise for support escalations and assist with and mentoring peers
- Utilized understanding of usage (AMA, EMI, and CDR’s) to ensure accurate daily processing for monthly billing.
- Prioritize and identify cross application/system enhancements providing support for field engineers during installations
- Evaluated network software, hardware and communication link, specification and installation
- Extract, load, and reconcile large amounts of data across multiple system platforms
- Interacted extensively with Cedar Point Switch, Nortel switch, and Broad Soft CDR’s.
- Provided first and second tier billing/accounting support to end-users via Remedy tickets.
- Utilized time-management skills, organizational skills, and problem resolution for urgent issues related to usage/billing
- Determine upgrade impacts to current processes and work with engineers and users to ensure accuracy of upgrade
- Resolved customer billing account discrepancies and support users in a helpdesk type manner
- Monitored and submitted department documentation into SharePoint
- Worked proactively, and independently while managing priorities
- Worked all tickets submitted by CSR’s for resolution of billing issues
- Identified barriers and provided resolutions and solutions through customer and coordination
- Ensured MSAG contained in CSG and BO (BackOffice) database is kept current
- Developed and maintained documentation including project plans and documentation specific to usage (AMA and EMI), MSAG, and BackOffice code builds.
Software Support Specialist
Confidential
Responsibilities:
- Knowledge of company supported hardware, software, and operating systems to include configuration and connectivity.
- Partnered with stakeholders, management team, and engineering teams to evaluate needs and define strategies
- Ensured timely delivery of all new and existing launch projects.
- Provided reporting, presentations, and assistance to manager.
- Performed extraction transform and load from database by means of Excel
- Created and executed project work plans and revised as appropriate to meet changing needs and requirements
- Investigated and analyzed information and draw conclusions for client based computers.
- Generated daily/monthly reports from data extracted from switch
- Displayed good process improvement skills while working with multiple business units
- Excellent communication skills verbal and written
- Ran SQL script to determine product code location
- Integral part of “Big Sky” conversion project team when converting customers to new billing system (ICOMS to CSG)
- Worked constantly with external customers and internal customers to ensure accurate implementation of software processes
- Developed and Implemented configuration management plans for complex local area networks and worldwide area networks
- Identified short-term and long-term voice communication issues, gathered and analyzed usage traffic.
- Established and met responsible deadlines and personal work plans
- Profound ability to document coding details and test events
- Created and implemented several reports utilizing Excel
- Extensive experience using data cleansing techniques, Excel pivot tables, formulas, and charts.
- Exercised technical responsibility to all aspects of IT system support
- Provided first and second tier support to end-users via Remedy tickets.
- Evaluated network software, hardware and communication links and provided advisory service to top-level management
Telecommunication Manager
Confidential
Responsibilities:
- Handled planning, organizing, and developing of specifications to support the telecommunications needs of over 8500 employees, located in 35 states across the country.
Support Services Software Specialist
Confidential
Responsibilities:
- Provided first and second level support to corporate personnel and Starmed divisions, providing temporary healthcare staffing to facilities nationwide, aligned the unbranded resources in a Digital Asset Management system for the Field, Brand Teams, Field Leadership and other internal stakeholders
Software Support Trainer
Confidential
Responsibilities:
- Provided to clients for installation/updates of Control Center programs that contained different accounting modules A/P, G/L, A/R, P/R, and Inventory