Resume

Sign in

Data Manager

Location:
Tampa, Florida, United States
Posted:
February 01, 2018

Contact this candidate

David A Hicks

***** ****** **** ***, *****, FL **647

813-***-**** (mobile)

ac4a0k@r.postjobfree.com

Summary

Operations and management professional with over thirty years of progressive management, and business transformation experience with a focus on business and data analysis. Track record of delivering meaningful solutions on time and within budget. Demonstrated ability to identify, plan and deliver business solutions at both strategic and tactical levels.

Skilled in process analysis/modeling and pioneered use of SharePoint as a platform to facilitate project and program improvement. Six Sigma Green Belt with advanced SIPOC and Value Path experience. Responsible for teams of multi-disciplinary personnel to implement technical and business process improvements. Hands-on when efforts required situational or advanced capabilities. Have lead significant projects in the Business Process Analysis and Business Transformation spaces.

Experienced in technology leadership and program management roles with strong negotiation, communication and organizational skills. Demonstrated project intervention and turnaround expertise. Exceptional team developer and resource manager.

Skilled in data analysis and modeling as well as data warehousing, data mining and business intelligence. Recent emphasis in the cloud space including design, implementation, migration, content management and workflow technology to implement business improvements. Financial and operational report development using varied software tools and source systems/databases.

Skilled in topics related to the mobility product development. Initiated mobility architectures and provided liaison for new products between the carrier and the device manufacturers. Have led mobile applications development on multiple platforms.

Education Bachelor of Science

Mechanical Engineering

Kettering University Flint, Michigan

Master of Business Administration

Finance and Operations Research

Wayne State University Detroit, Michigan

Adjunct Professor with DeVry University -- developed and delivered courses in business analysis, data architecture and business transformation.

Professional

Certified Information Management Professional (CIMP) in Data Quality

Certificate in Data Processing (CDP) from the Institute for Certification of Computer Professionals (ICCP)

Former Member of the Project Management Institute (PMI)

Former Board Member of the Manufacturing SIG for PMI

Former Board Member of the Supply Chain Management and Business and Technology Integration Committees of the American Textile Manufacturers Institute

Presenter at International User Groups related to Business, Process and Data Analysis

Helped form two technical user groups in the Tampa, FL community

Volunteer at Moffitt Cancer Center (Tampa, FL) and member of the Patient Advisory Committee

Experience

September 2015 to Present

Lohengrin Enterprises, Inc., Tampa, FL

Consultant

Business Analyst for a significant investment management organization reviewing large operational issues and creating plans for update, improvement and resolution to facilitate complex client interactions and address regulatory compliance issues. Created new approaches to process modelling and systems planning interactions which coordinates multiple simultaneous analytical efforts to leverage the reuse of newly developed business and technical capabilities.

Data Architect providing ETL design and operational review for a large Midwestern hospital system. Combining data from multiple third-party healthcare systems and ensuring data quality through the defined stages of EDW definition, architecture and development. Special emphasis on Cancer Analytics as well as standardization of diagnostic and procedure coding to promote enhanced BI usage.

Data Architect and project manager for a healthcare provider supporting extraction of patient and encounter data from multiple third-party systems, developing a single data source for performance and operational reporting and facilitating the merger of two related companies.

Keywords – BPMN, SQL Server, SSIS, SSRS, VISIO, MS Project, BizTalk, Tableau, MicroStrategy, Erwin, SharePoint, TOGAF, EPIC, Clarity, ETL, Cloud design using Azure and AWS, business transformation, data and process modeling, operations improvement, BI development, R, C# and Python language development.

May 2011 to August 2015

CitiGroup – Corporate Technology Operations, Tampa, FL

Vice President – Data Quality Management

Responsible for design and analysis of information related to the resolution of Data Quality issues identified by federal regulators. Created tools for use by analysts managing large, international data quality improvement projects. Developed processes for data extraction of issue and project management data, consolidation and communization in the warehouse and implementation of tools for reporting to senior management. Implemented Data Quality measurement and reporting processes, procedures, controls and toolsets that supported a dynamic reporting and analysis framework. Responsible for requests from Federal Regulators

Keywords – Data Quality, Data modeling, logical and physical database design, Master Data Services, Erwin, Data Warehouse design and implementation, ETL, SSIS, SharePoint, Data Quality Services, KPI metrics and program dashboards using MicroStrategy, Tableau, HP Quality Center, Business Analysis and Transformation.

March 2009 to May 2011

Lohengrin Enterprises, Inc., Tampa, FL

Consultant

Project leader moving content from Oracle platforms using DataStage and Business Objects to a SQL Server platform using SSIS and SSRS while maintaining the Business Objects investment. Worked under compressed timelines.

Business Analyst and SME on matters related to the management of mobility data and devices for an international airline. Assessed business operations and technology platforms with a focus on implementation of a corporate mobility management platform. Developed and managed the implementation approach.

Business analysis and process modeling for a national hospitality and entertainment organization. Developed roadmap to move from manual reporting to online and SSRS reporting in a SharePoint environment. Defined and lead the development effort.

Data modeler and database architect for a national managed services provider in healthcare. Constructed new data warehouse and worked with development staff to implement shareable database designs and applications related to customer support and managed services.

Keywords – Data and Process modeling, Erwin, SQL Server, SSIS, SSRS, SSAS, SSMS, Visual Studio, SharePoint, Business Objects, Oracle, ETL Integration, MS Project, PlanView, CMDB, Windows Mobile, Mobility Service Management, Asset Management, Infrastructure Management and Configuration, Big Data initiatives including Hadoop, MapReduce, HDInsight, HortonWorks Data Platform.

March 2005 to March 2009

AT&T (AT&T Wireless/Cingular), Tampa, FL

Senior Program Manager

Program manager for new business initiatives in the emerging devices organization. Work with partners to define and develop new devices on the ATT network. Design and implement managed connections between mobile devices and partner data centers. Implemented billing and activation platforms and provided technical design expertise to potential device partners. Included considerations of public requirements such as E911 and NG911. Designed, installed and maintained wired and wireless computer networks to support new products. Monitored software testing and trained Help Desk personnel. Created 1st and 2nd tier help desk and product support structure. Designed, installed and maintained custom private networks. Supported public and private sector customers on Blackberry and Windows Mobile issues. Responsible for project budgets, controls and reporting.

Project Manager for the migration of 6M consumer and business subscribers from AMPS/TDMA to the GPRS network. Developed approach and project plans. Redeployed public capabilities such as E911 to the new network. Identified key metrics and created detailed plans and budgets. Responsible for program and financial reporting to Senior Management.

Managed the migration of 500K wireless subscribers from an analog network to digital (GPRS) network. Established project methodologies, strategies and program tracking metrics. Responsible for 15 or more concurrent migrations.

Program architect for sales support operations. SharePoint environment included 40+ functional sites and interfaced to FileNet (P8) for corporate document management. Created integrated SharePoint/MS Project Server workplace environment. Implemented MOSS Enterprises and created management dashboards with the MOSS KPI web parts. Created prototype environment using DotNetNuke platform. Integrated VoIP messaging into the platform.

Keywords – wireless, voice and data, telecommunications, wireless development, managed connections, asset management, VoIP, APNs, eVPN, MPLS, GSM/EDGE, UMTS, provisioning and activation, SMS, streaming video, E911, NG911, HSDPA, Windows Mobile, Android, Blackberry, SharePoint, Project Dashboards, WSS, MOSS, Workflow development, MS Project Professional, MS Project Server, Primavera PM, Open Workbench, DotNetNuke, use case analysis, BPM, BPR, customer development and CRM, Jasper Wireless, SalesForce.com, product development, device certification, product support, Active Directory, SQL Server, SSIS, SSRS, SSAS, MS Access, ETL Integration, SOA, SAAS, Visual Studio, Teradata, Data Warehousing, Data Marts, Erwin, TOGAF.

February 2001 to March 2005

Lohengrin Enterprises, Inc., Tampa, FL

Consultant

Project Manager for a state department of Civil Service (600K employees) customized PeopleSoft system rewrite and version upgrade. Conducted project triage on the failed predecessor, redefined task plans, aligned resource assignments, conducted code walkthroughs and managed validation. Project had failed twice but this effort was completed on time with first-pass customer acceptance.

Managed a $5M implementation (13 resources) to replace in-house SAP Payroll with ADP (PeopleSoft) Payroll for 16,000 employees under severe time constraints. Implementation included simultaneous conversion of PeopleSoft to Oracle HR. Created and implemented HR support system including design and staffing of the HR help desk. Installed and configured Remedy to support Help Desk operations.

Operations Manager for a $30 million provider of durable medical equipment (DME). Managed a staff of 24 including call center, field service, billing, reporting, collections and process improvement.

Implemented ERP system for a high volume produce packing operation. PLC-based shop floor systems created data which was provided to SQL Server data warehouse. Real-time inventory, shipping and billing systems were implemented.

Designed, developed and deployed a CRM data mart for a multi-site hospital facility. Information from the internet was collected and loaded into SQL Server for reporting to hospital administration.

Keywords – Visual Studio, Visual Basic, PLC, Windows Server, SQL Server, SQL Server Analysis Services, Java, PeopleSoft (Upgrades, Financials, Payroll, HR/Benefits and Health&Safety), ADP, Web Applications, WAN, SAP, Oracle HR, Oracle, PL/SQL, Remedy, T-SQL, SQR, MS Access, Teradata, Data Warehousing, Erwin, Visual Studio, call-center implementation, UAT, Clarity, Financial system integration, TOGAF, Governmental reporting

June 1998 to February 2001

Avondale Mills, Inc., Graniteville, SC

Director of Information Systems

Directed a staff of 125 with an expense budget of $12M and a capital budget of $6M. Reduced technology expense by 20% and headcount by 10% while improving service levels. Integrated the resources from two merged companies and three IS operations Broad experience with data modeling and analysis, logical architecture, physical design, ETL and implementation. Skilled in data modeling, data marts, data warehousing, data mining and business intelligence. Recent emphasis in the SharePoint space including design, implementation, migration, content management, workflow and taxonomy. Financial and operational report development using varied software tools and source systems/databases. and created an effective and responsive IT function.

Developed board-approved IS strategy and managed tactical implementation, major efforts included corporate intranet, migration to server-based operations, network upgrades supporting 34 sites over 6 states, revamp of home-grown ERP system, replacement of all financial, payroll and HR systems.

Integrated shop floor data collection into real-time data for plant operations and management.

Initiated extranet, B2B, supply chain and web efforts. Initiated IT hardware and software asset management using Microsoft products. Implemented automated tools to configure and manage over 2,000 desktops across 34 geographic locations.

Created new technology support organization including design, implementation, staffing and operation of a voice and data communication help desk.

Position keywords – organization development, team building, ERP, Process Control systems, IBM mainframe, AIX, Unix, NT, Windows, Citrix, Sybase, DB2, SQL Server, COBOL, CICS, VM, LAN, WAN, PeopleSoft Financials, Web development, Web site, Payroll, Human resources, Time collection and reporting, Financials (GL, AR, AP, FA), server farms, thin clients, SMS, MS Exchange conversion, budget management, Supply chain development, intranet, Zachman, Visual Basic, MS Access, Erwin.

June 1997 to June 1998

Spectrum Technology Group, Somerville, NJ

Senior Management Consultant

Lead the competitive marketing of a $3M engagement for a consumer goods information provider and managed the project through implementation with a team of 19 full-time and 11 part-time resources across three work teams utilizing three different consulting firms, in-house developers and off-shore developers.

Defined project infrastructure, developed tactical approach and selected staff for the task assignments.

Implemented control and forecasting mechanisms and delivered management reporting to the client.

Engagement keywords – data warehouse design, data architecture, Erwin, team building, project budgets, IBM mainframe, Unix servers, Oracle DBMS, Visual Basic, C, C++, LAN, WAN, data warehousing, multi-dimensional analysis and reporting, off-shore development.

August 1995 to June 1997

AAA Auto Club South, Tampa, FL

Manager of Information Resources

Project Manager, Architect and Designer for the company’s first Data Warehouse. Usage of the warehouse included “relationship marketing” of club membership renewals and product marketing programs.

Created data architecture for a Travel Information System that featured multi-media data replicated to 50+ distributed database instances.

Evaluated packaged solutions for business functions including Help Desk, Real Estate Management, Insurance Sales and Corporate Accounting.

Position keywords – Data modeling, Erwin, data architecture, data warehousing, IBM mainframe, AIX, DB2, COBOL, CICS, PowerBuilder, ETL Integration development, database replication, CRM

February 1989 to June 1995

Tampa Electric Company, Tampa, FL

Principal Data Administrator

Created the Data Administration function, developed data policies and procedures, staffed and mentored Data Administration resources and implemented the use of automated tools.

Participated in migration to an Information based development framework and facilitated Business Requirement and JAD teams.

Lead corporate Business Process Reengineering (BPR) activities. Conducted workshops with executives to define and prioritize strategies.

Position keywords – Data architecture, data modeling, Erwin, Knowledgeware, Bachman Systems, IBM mainframe, Unix Servers, DB2, ADABAS, Oracle, COBOL, CICS, SQL, Methodology development, Business process redesign, Zachman Framework, JAD, facilitation

July 1985 to February 1989

AMD Consulting Services, Tampa, FL

Operations Manager

Responsible for day-to-day management of consulting staff that grew from start-up to 55 consultants on assignment.

Responsible for customer relationship management with and customer business development.

Lead analyst on two mergers.

Position keywords – resource management, CRM, consultant marketing, financials, human resources, payroll, financial modeling, retail order fulfillment systems, telecommunications billing, personal banking services, merger and acquisition feasibility

September 1981 to July 1985

Decision Support Associates, Troy, MI

Owner

Keywords -- municipal police scheduling, municipal financial systems, municipal budget review, hospital patient care systems, manufacturing control systems, expert witness, litigation management systems, time and attendance reporting, health insurance membership systems, HMO operations systems (membership, financials and third-party billing), training system development, financial software product development, online entertainment ticketing systems, hospital laboratory systems.

January 1979 to September 1981

Chrysler Corporation, Highland Park, MI

Manager of Warranty Financial Analysis

Keywords – financial management, dealer warranty fraud analysis, warranty to engineering feedback systems, organizational analysis

January 1978 to January 1979

Ford Motor Company, Dearborn, MI

Supervisor Product Cost Analysis and Control

Keywords – program management, variable cost analysis, fixed cost control, program profitability, feasibility studies, cost tracking systems

June 1975 to December 1978

Touche Ross & Co (now Deloitte and Touche), Detroit, MI

Senior Management Consultant

June 1972 to June 1975

Ford Motor Company, Dearborn, MI

Senior Product Engineer

August 1966 to June 1972

General Motors Corporation, Warren, MI

Product Engineer.



Contact this candidate