SUMMARY:

• Excellent academic knowledge in all functions of management, which includes planning, organizing, leading, and controlling.
• Customer focused attitude and ability to communicate with internal and external customers at all levels.
• Managerial skills needed to perform organizational functions and roles effectively: conceptual, human, and technical skills.
• Knowledge and experience in several divisions of accounting, financial services, merchandising, and logistics.
• Expert knowledge and ability to analyze complicated data sets to find trends and make recommendations of root causes. As well as problem resolution.
• Highly developed interpersonal skills.
• Sufficient knowledge of Object Oriented methodology.
• Excellent system analysis competencies that include the following languages and/or database systems: Java, Visual Basic, VBScript, MS SQL, Oracle, PL\SQL, C++, Visual C++, Unix, and ASP.

PROFESSIONAL EXPERIENCE:

Senior Data Analyst

Confidential - Dallas, Texas

Responsibilities:

• Develop SQL queries using Crystal Reports and MS Access database reporting systems (via ODBC connections to SQL Server and Oracle database tables) that support Oncor’s Field Support, Mobile Support and Service Order Management Teams.
• Develop and maintain several periodic metric reports that contain quantitative information. These reports outline service order volumes, troubleshooting cases reported to the Mobile Support Team, and exceptions worked by the Revenue Management Team.
• Research service orders and billing issues within the ODM (Order Data Management System), CIS (Customer Information System), IS (In Service), and ToolKit data systems to reduce impact of negative affects to customers.
• Troubleshoot urgent system issues swiftly to avoid penalties and out of protocol regulation violations that may be imposed if service orders within the system are not worked within the regulated period of time.
• Develop and update business processes and job aids for field support data management systems - IDispatcher, INet Dispatcher, and Mobile TC.
• Maintain 24/7 availability when needed to develop adhoc queries and/or reports to answer critical time sensitive questions and provide root cause analysis.
• Collaborate with various cross functional teams within Confidential Electric Delivery support groups as needed to ensure efficient software development and implementation of In Service Logistic System and Electrical Smart Grid project.requirements for hand off to programmers for coding.
• Provide technical oversight and project direction for application implementation of Electrical Smart Grid project.
• Troubleshoot database issues as they arise to ensure timely processing of critical data.
• Troubleshoot and maintain MCP and Maximo Database Systems.

Operations Systems Analyst

Confidential - Irving, Texas

Responsibilities:

• Assist with development of system tool and reporting for in-house Network Operations System, using Visual Studio 2005 (VB.NET and ASP.NET).
• Maintain and enhance Oracle database system to increase perform of operations.
• Create statistical adhoc reports as needed using Oracle database tables, SQL queries, MS Access queries, and Excel.
• Create and maintain departmental website using (CCMI Lite) Corporate Content Management Infrastructure.

Merchandising Business Systems Supervisor

Confidential - Dallas, Texas

Responsibilities:

• Supervise a staff of 20 employees that process item data for 7-Eleven’s Merchandising Business Systems department.
• Develop employees my leading and motivating them to expand their knowledge using and goal-setting.
• Perform standard supervisor responsibilities, which include but are not limited to processing payroll, creating performance appraisals, coordinating vacation schedules, and counseling employees that violate set policies (ex. Attendance and tardy issues).
• Encourage excellent work ethics through leading by example.
• Create process documentation for several intricate departmental processes. The documentation is used through out the company and service as guidelines for several related departments
• Act as a liaison for other departments, vendors, and wholesalers to resolve issues with item that are setup or will be set up in the merchandising business system (Item Master).
• Coordinate item set up and problem resolution with field personnel to ensure effective and efficient operations at the stores.
• Manage new item set up for an average of 300 items a week for over 7,000 stores.
• Improved the process in which items are submitted from 7-Eleven’s Canadian stores by creating schedules and timelines to ensure all paperwork is processed accordingly to avoid issues at the stores.
• Extract data by running queries in Access on Item Master tables via ODBC connections to create trend analysis reports that are use to find cost change variances. These reports are used to identify abnormal variations in cost. Based on analysis recommendations are made as to the cause and any corrections if needed.
• Consolidate data from 8-10 different sources (including but not limited to Business Objects, Crystal Reports, Oracle PL/SQL, and Access) to publish weekly, monthly and quarterly metrics for management.
• Utilize MS Excel and Access to analysis and process data received from various sources.
• Extract data from Business Objects to create various adhoc reports.
• Utilize SAP to update and print monthly reports and also to extract data for creating custom adhoc reports that were sent to the accounting and billing department.
• Develop MS Access databases for a variety of reporting and statistical analysis purposes. This includes calculating cost and markup amounts for invoicing.

Master Data Technician

Confidential - Irving, Texas

Responsibilities:

• Work with internal customers to gather needs and requirements for system updates and maintenance for the Great Plains database system.
• Maintain and update costing for thousands of records to ensure accurate sales and bidding information.
• Assist Supply Chain by managing and updating inventory records to reinforce the highest level of product flow and availability.
• Create process and procedure documentation for several interdepartmental functions.
• Consolidate data from 8-10 different sources to publish weekly, monthly and quarterly metrics for management.
• Utilize Crystal reports and Oracle PL/SQL to extract data which was used to create financial and statistical reports for budgeting and forecasting purposes.
• Update data in SAP that was used to create statistical reports.
• Develop and maintain MS Access databases for a variety of reporting purposes which include sales trend analysis, costing, shipping and receiving.

Loss Prevention Reporting Analyst

Confidential - Irving, Texas

Responsibilities:

• Consult with Loss Prevention Manager to prepare preliminary system specification designs.
• Extract data from preexisting Oracle databases via Business Objects (BO) to develop adhoc reports which are use to analysis loss and provide recommendations of possible causes and resolutions.
• Maintain and update preexisting databases for executive and store level reporting.
• Develop MS Access databases for the purpose of sustaining accurate and consistent reporting.
• Track Loss Prevention and Risk Management cases for over 200 stores Nation-wide to identify strengths, weaknesses, and problem areas.
• Assist management with process improvement, which required finding more efficient ways of completing tasks.
• Hold departmental user sessions for all databases and applications created.
• Compose user guides and system documentation.
• Work closely with executives, departmental coordinators, and investigators to gather report specifications to ensure the reports meet the needs of its users.
• Utilize statistical analysis to identify trends in monthly and quarterly reporting.

Billing Analyst

Confidential - Richardson, Texas

Responsibilities:

• Managed billing department by ensuing timely and accurate billing accounts through verification of customer records and maintenance of billing system.
• Promoted communication to manage how individuals and groups cooperate and interact.
• Lead employees to perform at maximum levels of efficiency to achieve departmental and organizational goals.
• Processed information for organizational reporting purposes.
• Generated customized reports using PL/SQL to meet the needs of upper management by making them both informative and comprehensive.
• Convert 1000's of call detail records (CDR's) into exchange message interface (EMI) format that are transmitted to customers via Intra and Internet connections.

Billing Analyst

Confidential - Carrollton, Texas

Responsibilities:

• Research Accounts Receivable and Accounts Payable discrepancies using several in-house database systems, JDEdwards, and SAP to ensure proper billing and accounting practices for external customers.
• Analyze complex telecommunication billing rates and services based on industry standard terminology.
• Work closely with customer service managers to resolve billing and accounting issues to prevent escalations.
• Reconcile discrepancies with internal and external customers.
• Resolutions of Accounts Receivable issues by investigating customer disputes.
• Update and maintain 5 different databases to assure proper billing for up to 500 large multi-sited commercial and industrial customers located across the country.
• Created Dbase and Oracle SQL tables that were linked to 5 different database systems for billing including JDEdwards and SAP.
• Extract files from Dbase and convert into MS Access tables for data manipulation.
• Prepare and update rate and ANI files using Dbase and MS SQL systems.

Confidential - Dallas, Texas

Accounting Research

Responsibilities:

• Reconcile over 500 billing records on unbillable accounts on a daily basis.
• Revised and corrected Excel spreadsheets using various editing and formatting processes.
• Researched accounts using several in-house Oracle and AS400 databases to find general and specific information pertaining to billing discrepancies, which resulted in the recovery of $50,000 weekly.
• Imported Excel spreadsheets into an MS Access database to update reports that were sent to vendors for payment.

Marketing Operations Analyst

Confidential - Dallas, Texas

Responsibilities:

• Created and troubleshot databases and applications.
• Consulted with Program Manager to prepare preliminary system specification designs.
• Created Graphical User Interfaces (GUI's) using Visual Basic, which required an Object-Oriented/Event-Driven (OOED) approach.
• Utilized sequential access data files with Visual Basic for source reporting and data warehousing.
• Compiled and updated database for over 30,000 accounts.
• Implemented strategic plans to achieve operational goals; which increased departmental efficiency by 50%.
• Held departmental user sessions for all databases and applications created.
• Served as Customer Service Liaison between engineers, clients, and technicians.
• Research and analysis demographics and other customer related data to find trends in customer behaviors. These analysis were use to identify target markets, which allowed marketing to offer products and services that meet the needs of the specific demographics.
• Created presentations using PowerPoint for visual aid during sections.