PROFILE:

Information technology professional with substantial experience in ad hoc reporting and data warehousing. Expertise in analysis of billing, booking, spend management, supply chain, equipment, policy, claim and relational databases in a business intelligence environment. Demonstrated ability to prioritize and multi - task to best serve corporate business needs. Adapts quickly and works well independently and within a team to achieve goals.

TECHNICAL EXPERTISE:

Hardwares: Dell, IBM and OmniTech PC, HP/Toshiba laptop, XT, AT, PS/2, IBM 3278

Software: SAP Business Objects Enterprise XI (Designer, Infoview, IntelliSpend-Enterprise Reporting Infrastructure, CMC-Central Management Console), Cognos 8/Impromptu, Crystal Reports XI, DbVisualizer Personal, Teradata Sql Assistant, IRIS (Integrated Reporting Is Simple) CRM, AMS (Asset Management System), Dynamex (Delivery Service Transportation - Online Ordering and Tracking System), HRO Maestro (IMS - Invoice Management System), Peoplesoft - Finance ERP 9.0, Ariba/Tigers (Global Indirect Procurement Solution, Charges (Charges Query System), STAR (Policy Admin System), Confidential (Claims), VISTA (Billing System), TCOMS (Total Circuit Order Management System), MARS (Marketing and Revenue System), CARES (Customer Acquisition Retention System), SSMS 2014, TOAD 6.6, SQL Plus, FreshCells - JIRA, Remedy-Action Request Tracking System, Access, Excel 2016, Powerpoint, Lotus Notes, Word, Outlook, Sharepoint, QPulse, Dreamweaver, Frontpage, Documentum, iManage

Languages: SQL, VISUAL BASIC, HTML, PLATINUM, FOCUS, EASYTRIEVE PLUS, COBOL, FOXPRO, C/UNIX, CICS

Operating Systems: MS/PC/DOS, WINDOWS VISTA/XP/NT, JCL, VSAM, NOVELL, TOKEN-RING LAN

PROFESSIONAL EXPERIENCE:

Confidential, Hoffman Estates, Illinois

Lead Generation Representative - Inside Sales

Responsibilities:

• Responsible for working as part of a team to support the Inside Sales Representatives and Account Executives in prospecting and building a pipeline of qualified leads to meet business plans, quotas, and company objectives.
• Placed phone calls to potential clients.
• Performed script (with necessary adjustments) to ensure consistency of sales program.
• Answered potential clients' questions regarding Creditcard Processing specifically security and fraud concerns.
• Generated Factfinders for Phase II Lead Generation Representatives.
• Communicated respectfully and politely with potential customers at all times.
• Ability to cope with rejection on a daily basis.
• Assisted with digitizing the Factfinder questionnaire form into the IRIS CRM system.

Confidential, Bartlett, Illinois

Paraeducator - Special Education

Responsibilities:

• Performed a variety of instructional and/or support duties to assist the school and teachers in instruction, supervision, and education of students with special needs in groups and one-on-one teacher to student situations.
• Assisted the teacher in general daily classroom activities, helped special needs students, and cared for their physical, emotional health and safety, affirmed their abilities, and strived to promote dignity in all relationships.
• Worked with a student on an individual basis as well as small group to complete assigned work.
• Kept students on task.

Confidential, Downers Grove, Illinois

Data Analyst

Responsibilities:

• Processed requests in a quick, competent and solution-oriented manner. Provided reporting for management of IT operations and throughout entire Group.
• Worked with all levels within the organization using Travel Studio, iBuilder, SSMS 2014, Excel and Powerpoint.
• Processed data requests for the following reports: Agent Contact, Booking Analysis, Cost & Usage (package & service), Currency, Price Types, Product Integrity, Agency Commissions, A&K DMC Addresses, Geo Tree Setup, Mapping Sheet MealPlan, Passenger Details, Rating & Facilities, Special Offers, Tax Setup, Title & Gender, and Travel Studio Testing.
• Worked on weekly Audit reports like FBR (Forward Booking Report) for global sales teams, finance and executives which showed revenue differences, EDF (Error Data File) contains services & packages, SOR (Special Offer Report), Group Summary Quote Conversion Report contains iBuilder bookings summary counts, and iBuilder Booking Converted as Confirmed Bookings showed revenue generated.
• Validated daily reports like Daily check for Cube Refresh Progress which ensured central servers were connected and worked properly.
• Provided support for iBuilder, Product Integrity and other projects such as Testing Agency Default Price Type and GeoTree backup.
• Assisted in weekly reporting activities for the Source Market reports assuring critical information existed and accurate.
• Performed additional tasks such as Tailor made - private tours with A&K local guide, TS Master Geo Tree Cleanup - TS Geo Tree to iBuilder Hotspot Mapping continent, country, and hotspot.
• Administrated JIRA - ticket tracking system.

Confidential, Addison, Illinois

Business Reporting Analyst - Operations/Reporting Services

Responsibilities:

• Worked with all levels within the organization, customers, and suppliers.
• Experienced working in a team-based and cross functional environment.
• Prioritized multiple projects using AMS (Asset Management System), Excel, Access, Powerpoint, and Sharepoint.
• Performed the Confidential Operational Tracker daily metrics like UOM, Count of Auths, KPI Checks, Service Failures, Pending Non-Delivered Shipments, Misses, Inventory ITN, Storage, Config Lab, and Audits Cycle Counting.
• Worked on trending metrics performance data such as Confidential (Sprint) Control Tower on the following: POD, Delivery Precision, Sales Order per Hour, Dock to Stock, and 5s. Provided Safety Cross, Incident, Survey Metrics, Delivery Methods and Planning Accuracy figures to management.
• Processed standard reports like Shipping and Receiving Activity, Delivered, On-Hand Detail, and Non-Delivered Shipments for general managers of East and West Coast operations and dashboards like Confidential Executive Summary performances on the following: Total last mile, Ontime deliveries, cancelations, late and issues details by region and markets.
• Pulled Service Failures, Inventory Balancing, OnHand Inventory, Inventory Summary and Inbound for customers.
• Participated in process improvement projects to streamline manual processes and improve productivity in both internal team and corporate departments by assisting in developing an Inventory OnHand Compare (Access vs. SAP).
• Also, created a PTO calendar for entire Confidential Control Tower team, compiled a detailed history of Sales Order, verified warehouse and customized cabinet inventory accuracy.
• Coordinated with IT department then performed quality assurance to ensure accurate information are captured.

Confidential, Hoffman Estates, Illinois

E-Commerce Fulfillment Data Analyst

Responsibilities:

• Maintained and published daily and weekly reports with Sears, Kmart, and MyGofer information products used by the organization.
• Assisted in developing and fulfilling reporting requirements for performance metrics (KPI using Foresee CSAT) and utilized statistical methods within data analysis to produce actionable reports like OTD (OnTime Delivery) and B2B for executives and senior management.
• Analyzed and assisted in developing reporting solutions such as Market Performance graphs to reduce redundancy and improve efficiencies based on analytic findings like MyGofer Express-Dedicated Vehicle Recap and Volume Injection (delivery orders) reporting.
• Leading provider of human capital and management consulting services. It operates 500 offices in 120 countries providing consulting, outsourcing, and insurance brokerage services. Areas of expertise include actuarial science, compensation, employee benefits and compliance, HR information technology, industrial psychology and organizational behavior, and leadership development.

Data/Reporting Analyst

Confidential

Responsibilities:

• Executed by processing the bi-weekly PM scorecards in order to assist the CFMs and CFAs in resolving any client invoicing related issues.
• Revised the PM scorecard procedure document to ensure process efficiency and data integrity.

Confidential, Libertyville, Illinois

Senior Project Management Specialist

Responsibilities:

• Led execution of employee MyExpenses Program by processing data, distributing, diagnosing and resolving process issues revealed on a regular monthly basis according to schedule.
• Updated procedure document and validation process prior to delivering results to ensure minimal impact to Business Units.
• Revised MyExpenses Program in Access to reflect the application changes due to company separation.
• Participated in Asia Response Team support coordination meetings to review MyExpenses inquiries on a quarterly basis.
• Prevented unnecessary inquiries by ensuring Spend Management Communications are handled accordingly.
• Resolved high level issues regarding MyExpenses distribution and supported FAQs communications.
• Tested and executed CostMatters and PolicyMatters targeted emails with cadence to prevent unauthorized and unnecessary spending.

Confidential, Schaumburg, Illinois

Senior Project Management Specialist

Responsibilities:

• Executed MyExpenses Program by processing data, distributing, diagnosing and resolving process issues revealed on a regular monthly basis according to schedule.
• Developed validation process prior to delivering results to ensure minimal impact to Business Units.
• Tested development tool of SAP Business Objects Enterprise XI prior to company split to avoid any system disruption.
• Prevented errors by maintaining process documentation, Compass repository and email rules on a regular basis.
• Created and shared a Business Objects guide for editing and submitting queries through Infoview with colleagues.

Confidential, Oakbrook Terrace, Illinois

Data Analyst

Responsibilities:

• Created numerous ad-hoc reports for internal customers mainly in the Local Marketing business.
• Generated Fiscal Year Budget reporting worth about $5M by media types such as internet, tv, radio and social networking.
• Verified online inquiries were properly tracked for registration purposes.

Confidential, Arlington Heights, Illinois

Data Analyst

Responsibilities:

• Provided weekly, monthly and quarterly OTD (OnTime Delivery), BOUNCE (shipments returned within 180 days), TAT (TurnAround Time), NPF (No Problem Found), Receipts (receive), Backlog (open orders) and GPS (Government Public Safety) Survey results and maintained scorecard reports for internal customers mainly in Home and Operations business.
• Developed an efficient Access reporting tool application for pulling Suppliers.
• Verified calendar and production cycle ship and receive dates were properly being utilized in Cognos to ensure Suppliers, Customers and Business metric reports were accurate according to end users’ requirements.

Confidential, Hoffman Estates, Illinois

Senior Data Analyst

Responsibilities:

• Assisted business end users in providing access to information stored in STAR/ Confidential /VISTA and/or within Business Intelligence’s data warehouse using Business Objects XI, Crystal Reports XI, TOAD, Access and Excel.
• Developed policy and claims detail and summary analysis reports for executives and management mainly in Finance, Underwriting and Operations.
• Administered new and existing users using Central Management Console which allowed users access to Infoview.
• Developed new Confidential claims universe to replace outdated system (STAR) using Business Objects Designer module.
• Analyzed and interpreted information from multiple data sources which ensures data reports are accurate across the organization.
• Investigated and identified data discrepancies which were communicated/escalated to management.

Confidential, Downers Grove, Illinois

Specialist Engineering

Responsibilities:

• Collaborated and worked with business end users in providing access to information stored in TCOMS and/or within Global Network Engineering & Planning’s data warehouse using Business Objects, SqlServer, Access and Excel. Created Ethernet and Ring Route Utilization (node-customer pop and node-node) metric reports with circuit IDs, building and location information for circuit designers.
• Maintained a Capacity Reporting with Network Utilization and VGE reports for trending purposes.
• Provided equipment reports with ring activity such as an inventory of all outdated async and mux systems to be decommissioned and moved traffic for network efficiency and developed Route Optimization report to track teams Equipment Request Log activity.
• Created DXC Optimization (DS1,DS3,oc192 and sonet) ad-hoc reports to reduce number of hops.
• Participated in a special project such as TNT (ring network) to replace an outdated system (ARS).

Confidential, Bensenville, Illinois

Application Analyst - IS/Business Intelligence

Responsibilities:

• Worked with business end users in providing access to information stored in CARES and/or within Business Intelligence’s data warehouse using Business Objects, MARS, TOAD, SQL Plus, Access, and Excel.
• Managed the Remedy-Action Request Tracking System, created ad-hoc reports for executives and analysts and participated in a Roaming Package project. Key accomplishments:
• Created churn activity, retention, and fraud analysis ad-hoc reports for internal customers in Marketing, Operations, Sales, Finance, Engineering and IT and external vendors.
• Managed the departments’ queue in the Remedy-Action Request Tracking System.
• Prepared ad hoc reports and resolved ticket discrepancies to meet the service level agreement.
• Participated in validating Request Central (Remedy-Action Request Tracking System) accessed through the company’s intranet and selected to train peers when the system was rolled out.
• Created a Business Objects guide for submitting a query through Broadcast Agent as a self serve tool.
• Developed, tracked, and published performance metrics from Remedy-Action Request Tracking System for all request categories in the Business Intelligence Team.
• Maintained and updated links and documents for the Cellsite companys’ intranet site using Dreamweaver and Documentum.

Confidential, Chicago, Illinois

DB Analyst/Programmer

Responsibilities:

• Provided users with access to information stored in Cellware, Virtuoso II, and/or within Information Management s data warehouse using Business Objects, FOCUS, Platinum, RiSql, Cognos (Impromptu), Access, and Excel.
• Maintained the Data Dictionary, created ad - hoc reports, and hosted end-user conference calls.
• Documented processes and procedures to ensure knowledge transfer. Key accomplishments:
• Created ad-hoc reports to internal and external customers for churn activity, retention and fraud analysis.
• Participated in testing, development and implementation of Platinum Reporting System, a mainframe based structured query language application.
• Validated the Information Warehouse data for Cellware and Virtuoso II Billing System application.
• Ensured the monthly reports met the service level agreement requirements.
• Created a user guide for the Platinum Reporting application to assist users create queries and forms.
• Created reporting statistics from Remedy-Action Request System to track the helpdesk tickets assigned to the Information Management Group.
• Developed a procedure manual and process flowchart to assist in Technical Support training.
• Designed Excel spreadsheets to track the recurring errors on the Switch to Bills audits.
• Created and maintained FoxPro for Windows databases and reports.