We provide IT Staff Augmentation Services!

Director Of Operations Resume

Columbus, OhiO

SUMMARY:

  • I am currently the Director of Operation for a small, private company.
  • I have over 15 years of experience in data analysis and statistical reporting.
  • I am highly experienced with Teradata, Oracle, Netezza and SQL Server database environments.
  • I possess very strong SQL and MS Office skills and have had multiple project management responsibilities throughout my career.
  • I work with management and users to analyze, design, implement and/or support business applications and systems.
  • I am highly skilled at data analysis, taking a logical and tenacious approach to meet deadlines.
  • Data Analysis (18) inspecting, cleaning, transforming, and modeling data
  • Data Quality/Validation (18) Data defect identification via business rules
  • Data Management (14) data analysis, data modeling, data maintenance, database administration, data access, data security, data cleansing, data mining, data movement, data warehouse
  • Statistical Reporting (16) various daily/weekly/monthly/ad - hoc reports, report automation
  • SQL (15) create\update\append\delete\drop Tables, volatile tables, indexing, partitions, complex joins
  • Teradata (2) SQL, data modeling, indexing, primary/secondary keys, DDL, data dictionary
  • Oracle (3) SQL, data modeling, indexing, primary/secondary keys, DDL, TNSNAMES, data dictionary
  • SQL Server Management Studio (2) Development, views, stored procedures, UDF’s, table definitions, data import\export, table creation, ETL, SSRS, linked servers
  • Visual FoxPro (4) SQL, data modeling, indexing, primary/secondary keys, DDL, forms
  • Data/ Report Visualization (15) PowerPoint, Power Pivot, Pivot Tables, Tableau, BI, trending
  • Requirements Gathering (8) JAD, meetings, documentation
  • MS Access (8) DBA, VBA, Forms, Tables, Queries, Macros, Reports
  • MS Excel (18) VBA automation, Data Normalization, Pivot Charts\Graphs, Data Sources
  • MS Word (18) VBA, create and edit Process Documentation
  • MS Project (5) Project scheduling\completion, project progress, management reporting
  • MS Visio (5) Process Flowcharts
  • MS PowerPoint (8) Presentation for upper management, executive summary
  • MS SharePoint (3) Site design, reporting, surveys
  • Microstrategy (1) design, reports, charts, graphs
  • Programming (12) XML, VBA
  • Capital Expenditures (1) Capital Models, budget & forecasting, P&L, Revenue Summary Reporting
  • SOX Auditing (1) Prepare and submit samples for Sarbanes-Oxley audit
  • SAP - PeopleSoft (1+) Customer validation and update info when necessary
  • UAT Testing (1.5) New product mapping, application development, data validation
  • SDLC (.5) UAT for GUI to .NET interface

EMPLOYMENT EXPERIENCE:

Confidential, Columbus, Ohio

Director of Operations

Responsibilities:

  • Manage weekly production, customer source data, data archive, reporting
  • Pre-production, Production, Post-production process development and improvement
  • Automation of customer and internal reports
  • Development of automating manual processes, data cleansing, audits and error logging
  • Manage and maintain servers and external drives
  • Managing build and migration to MySQL database

Confidential, Columbus, Ohio

Portfolio Coordinator

Responsibilities:

  • PMO Executive reporting - automated manual weekly/monthly reports
  • Create Netezza SQL views for new report visualizations
  • Create new processes for report generation
  • Data Mart source to target mapping, data modeling, ETL
  • DBA for multiple Access reporting databases

Confidential, Hilliard, Ohio

Sr. Data Analyst

Responsibilities:

  • Enterprise release point of sale UAT testing, test case writing, defect tracking via Quality Center
  • Analyze and monitor new promotions and discounts for anomalies and process validation via SQL
  • Created and monitored warehouse inventory reporting for data validation and data analysis.
  • Reconcile customer bill to account credits/debits. Customer billing analysis
  • Developed MS Excel Test Case template with input/edit form and status reporting; uploaded test cases to oracle table

Confidential, Columbus, Ohio

Project Coordinator

Responsibilities:

  • Managed incoming and outgoing hardware in the depot.
  • Partnered with Deployment PM to provide daily metrics for project scope, schedule and status
  • Various ad-hoc reports and duties.
  • Created MS Access script to create Excel book for deployment metrics.

Confidential, Columbus, Ohio

Business Analyst

Responsibilities:

  • Created tables, interactive forms, data modeling and relationships to primary key resolution tables
  • Access VBA scripting
  • Performance and reporting analysis, adminitration
  • JAD sessions with end users

Confidential, Columbus, Ohio

Senior Business Analyst

Responsibilities:

  • Managed weekly scope statistical reporting, application tracking, weekly user migration readiness report, and ad-hoc data retrieval from various data sources (SSMS 2008, Toad, and Web Sources) for ad-hoc reports and data requests.
  • DBA for iSpace database using various data sources for user/application analysis. Conducted performance and reporting analysis.
  • Automated excel-access segmentation process for the creation of 2,000+ migration deployment workbooks. Each individual workbook uploads a user checklist to the database and then refreshes all data in the workbook for new additions/fall-outs.
  • Automation savings: 44 days - $21k @ $60/hr

Confidential, Columbus, Ohio

Data Analyst - Customer Analytics

Responsibilities:

  • Data manager for daily custom Customer Management Action reports.
  • Automated importing the source reports into an Access DB for reporting analysis and data validation.
  • Created VBA scripts to sort the dataset, remove duplicates, recreate missing creation records due to defects, reporting issues and update summary count tables that are combined with a historical product count. Performance analysis was performed on the access db.
  • Deliverables include Creation and Consumption reporting, monthly opening balance, trend analysis, data validation, ad-hoc reports.
  • Ad-hoc Toad PL/SQL in data warehouse for data validation/ad-hoc reporting.
  • Identify process defects and reporting issues with business rules.

Confidential, Columbus, Ohio

Project Coordinator

Responsibilities:

  • Managed the vendor deployment scheduling, daily and monthly statistical reporting to upper management, daily report analysis summary, and branch data validation.
  • Database DBA and created automated daily/ad-hoc reports for management. Performance analysis of database reporting and end user interaction.
  • Assisted Project Manager for the Data & Voice Discovery activity of the project.
  • Implementation of automation features to the database controls and for various Excel forms used by Project Team.
  • Audit branch Data & Voice Discovery survey documents, floor plans and photos.
  • Take customer trouble calls from branches and open Trouble Tickets for irresolvable issues.

Confidential, Dublin, Ohio

Data Analyst - Business Operations

Responsibilities:

  • Reformatted and added four new Divisional Summaries to the Midwest Regional Revenue Summary report, for all business class products.
  • Total Monthly & Yearly Revenue Summary by product, Monthly and Year-To-Date count of new subscribers, total products and disconnects, ARPU (average revenue per user), Better/Worse Outlook, capital expenditures.
  • Data mined via SQL queries in ICOMS, and then normalized in MS Access.
  • Created Business Class Phone Summary template in MS Excel.
  • Created a Fiber and Teleworker Service Code sheet. SQL Case statement to correctly label Service Codes by Division.

Confidential, Dublin, Ohio

Data Analyst - Global Software Maintenance

Responsibilities:

  • Complex data analysis for the consolidation of multiple customer entries found in the financial (PeopleSoft) and product (Vantive) Data Warehouse tables.
  • Management reporting via Crystal Reports.
  • SQL to identify and update cross mismatches and customers with active products not invoiced.
  • Created Data Warehouse tables and SQL for general ledger/data lookups.
  • Prepared maintenance renewal reports for Vice President, Regional Manager, and Sales Reps levels.
  • Created PowerPoint presentations, Visio process flow charts and documentation for VP.
  • Provided project reporting to Upper Management.
  • EOY General Ledger Reporting.
  • Data Warehouse SQL scripts, SSRS packages for SQL Server to perform complex customer data analysis
  • Performed complex manual lookups for missing data on Lexus Nexus website.
  • Access scripts for Data Warehouse table editing/validation.
  • Upsert new customer information into the Data Warehouse PeopleSoft tables.

Confidential, Dublin, Ohio

Financial Analyst - Revenue Assurance

Responsibilities:

  • Daily scheduled audits for billing errors.
  • Lead Analyst for Switch-to-Bill (S2B) and Network Element-to-Bill (NEB) reconciliation and UAT testing.
  • Researched errors and recurring exceptions to find root cause and report to Lead Project Manager.
  • Ad-hoc SQL for customer data validation.
  • Quarterly S2B and NEB SOX audits.
  • Managed S2B, NEB, EDR issues log; report/resolve issues.
  • Reporting to Upper Management during weekly JAD sessions.
  • Monitored trend analysis for S2B, NEB, and EDR (data reader).
  • Managed new product pricing validation/mapping validation.
  • Found multiple $100K overcharges for data usage errors caused by a phone error. The billing department credited the customers for the overcharges.

Hire Now