Director Of Data Architecture & Data Management Resume
Atlanta, GA
SUMMARY:
Innovative and dynamic IT Leader with over 18 years of diverse technology experience in Finance and Insurance, Healthcare, Manufacturing, and Software & Services industries. Proven track record of successfully directing teams to create processes and to build technology infrastructure which enable strategic partners to provide rich data driven insights for effective business decisions across the organization. Leader of development teams with successful delivery of big data systems, applications, mobile application, BI and analytical solutions. IT partner committed to managing change effectively, providing technology solutions to aid business issues, leading multi - year strategic efforts, and successfully leading program execution and managing costs to P&L impact.
EXPERTISE AREA:
- Organizational Leadership
- Project Management
- Big Data Strategy
- Transformation
- Project & Program Management
- Agile Leader
- IT Infrastructure Development
- Organization Effectiveness
- Change Management
- Corporate Budgeting & Cost Control
- Team Building
- Strategic Planning
- Negotiation/Conflict Resolution
- Business Intelligence
- Vendor Management
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Director of Data Architecture & Data Management
Responsibilities:
- Oversaw Data Architecture, Data Management and Data & BI technology infrastructure
- Directed all functions related to data administration, data warehousing, business intelligence reporting, master data management, data integrity, and data access across Confidential
- Tasked to drive tactical and strategic planning for Enterprise Data Strategy
- Led Business and IT planning & development for multi-year Data budgeting and financial planning
- Directly managed 5-million-dollar budget
- Co-managed with business peer(s) 10 plus-million-annual strategic data budget
- Advocated for capital investments in Big Data, Master Data Management and other information assets
- Developed multi-year program road map for the Data Strategy implementation
- Directed consulting engagements with IBM, Deloitte, EY and other consulting companies
- Provided the vision and subsequently designed a robust, flexible and scalable BI, Warehouse and analytic Infrastructure
- Evangelized the use and promoted the importance, of data derived insights, at different units of analysis, to support strategic planning and tactical decisions
- Led efforts identifying data pain points in Customer 360, Sales CRM, Call center operations and other key areas
- Collaborated with C Suite, key business stake holders and analytic teams to identify the limitations of current Business processes and Information infrastructure
- Created a strategy aligning the tactical business priorities and needs with the short and long-term objectives of Confidential
- Chief Evangelist of Enterprise Data Governance
- Influenced the creation Enterprise Data Governance Committee
- Oversaw creation of sub-committees and naming of data stewards for different domains
- Led committee for Information Technology division
- Led research, analysis, acquisition and implementation of
- Informatica’s Master Data Management (MDM) system
- Teradata’s Data warehouse appliance
- Hortonworks Big Data appliance
- Created & led new matrixed data team of 45 professionals/ managers in the execution of the Data Transformation Initiative
- MDM program started, and five domains mastered on new system
- Big Data program - Data Lake, new data warehouse and new integrations created to load & leverage capabilities
- BI and Analytic program
- Managed existing data team of 35 professionals and managers in the maintenance of existing data infrastructure
- Reorganized the teams into Scrum teams (Agile Delivery)
- Conducted performance evaluations
- Trained and mentored all levels of staff
- Provided coaching, direction and leadership
- Stabilized existing infrastructure to achieve 99% uptime for all data and BI infrastructure
- Increased the number of yearly data projects delivered on budget by 15% with an equivalent rate of on time project delivery
- Increased Customer Satisfaction to 95%
- Directly Responsible for data asset compliance to:
- SOX regulations & controls
- Confidential continuity, quality, privacy, legal and ethical standards and polices
- Government and State privacy and legal laws
- Defined new Data standards, frameworks and Big Data patterns
- Data ingestions strategies for legacy systems, 3 rd party integrations and new modern systems
- Auditing, Reconciliation and History Tracking Framework
- Data Lake Patterns
- Created and implemented proper disaster recover strategies for all data assets
- Managed Vendor Relationships
- Managed existing and wrote new service agreements
- Negotiated procurement contracts for hardware/software systems
- Established productive relationships vendor Sr. management
- Tasked to examine new technology options to meet business objectives and goals
- Translated Business rules and strategies into working solutions that were efficient, met the business outcome and delivered value on time
Confidential, Atlanta, GA
IT Information Architect
Responsibilities:
- Accountable for all Data Architecture, Data Management and Data & BI technology infrastructure
- Managed and responsible all functions related to data administration, data warehousing, business intelligence reporting, master data management, data integrity, and data access across Riverstone and ASI
- Liaison with Sr. Management and key stakeholders the limitations of current BI infrastructure and the effect of it on the corporate strategy and goals for business and acquisition data migration
- Developed Data Migration Strategy roadmap for seamless integration of newly acquired businesses into the existing corporate data environment
- Stabilized existing infrastructure to achieve 99% uptime for all data and BI infrastructure
- Analyzed existing data processes, business applications and the business cycle into order to improve quality, security and accuracy
- Performed discover data issues and management problems which hinder or stop the ability to perform effective reporting and analytics
- Responsible for all duties of BI Manager, Data Architect, Database Administrator and ETL Architect including but not limited to the following;
- Requirements Analysis and Detailed Functional Design of Systems
- Design of Logical and Physical Data Models for Systems
- Design of Extraction, Transformation and Load (ETL) processes for Systems
- Review Existing Enterprise Data Services Solutions and Implemented Changes
- New Database Engineering and Security Standards
- Refactor Existing Data and BI Solutions to bring up to standards
- Refine reports, dashboards and other data services delivery methods
- Implement data checks and balances processes to verify ETL completion and data accuracy
- Provide Solutions to complex Data Architecture problems for Enterprise
- Implemented new Data Warehouse
- Implemented new Bond Data Mart
- Created new dashboards, reports and Tableau reports to meet customer needs
- Created Analytic process which automatically preformed actions based on defined data triggers
- Managed existing data team of 8 professionals in the maintenance of existing data infrastructure
- Reorganized the teams into Scrum teams (Agile Delivery)
- Conducted performance evaluations
- Trained and mentored all levels of staff
- Provided coaching, direction and leadership
Confidential, Duluth, GA
Client Service Engineer
Responsibilities:
- Managed team in delivery of analytical marketing solutions to client
- Collaborated with clients to define business, functional and technical requirements for marketing campaigns
- Created consolidated marketing operational databases based on client requirements
- Created Use Case diagrams to model the business and marketing campaign requirements
- Created Object Relational Model (ORM) diagrams to model client data domains
- Performed data discovery on client repositories, data marts, data warehouses and applications
- Identified and documented data quality, data patterns, application data issues and limitation of existing data model
- Transformed ORM and Use Case diagrams into base Entity Relational Data model Diagram
- Designed and developed Data mapping to consolidate all source domains into Data model
- Created data hygiene process to address data quality issues
- Created audit and reconciliations processes to ensure accuracy and system stability
- Developed reports and performed Analysis using Microsoft BI suite of software
- Developed Extract, Transform and Load solutions using Microsoft BI suite of software
- Created and deployed stored procedures, tables, indexes, triggers, alerts, agent jobs, scripts and other database objects in support and implementation of databases and ETL solutions
- Performed duties of:
- Data Architect
- Database Administrator
- ETL Architect
- Technical Project Manager
Confidential, Atlanta, GA
Senior Data Warehouse Developer
Responsibilities:
- Met with key business stakeholders to create a new strategy for data management and reporting
- Socialized the limitations of existing data environment
- Proposed and developed new strategies to overcome the information challenges
- Held meetings with business partners to define requirements
- Collaborated with data warehouse architects to design data model and processes to meet business requirements
- Managed team in project/technical activities for data warehouse, data mining, reporting and BI deliverables
- Led team in creation of new data warehouse, reports, dashboards and other deliverables
- Designed more effective ETL/ELT solutions in various vendor platforms
- Interfaced with various application teams to address data model concerns, submit change requests and recommend model enhancement
- Designed and implemented archiving and data migration strategy
- Executed data mining activities as requested
- Performed the role of Team Lead
Confidential, Alpharetta, GA
Implementation Analyst
Responsibilities:
- Provided consultative services to install Horizon Patient Folder (HPF) Suite of software in 8 major regional hospitals including their satellite hospitals and clinics
- Conducted pre-implementation meetings with Hospital staff to determine appropriate implementation strategy
- Designed data migration strategy for software suite installation
- Created customized Integrations of 3rd party systems to the HPF system
- Created new reports based on client needs and business requirements
- Installed, tested and configured software suite on desktops, laptops and servers
- Discovered and advised application developers of issues related to error or fault operation on the suite of software
- Provided 24-hour support in conjunction with implementation and Go-Live activities
- Managed client’s concerns and expectations throughout the implementation cycle
- Trained client staff on best practices and efficient operation of software suite
- Managed implementation travel budget
- Performed standard SQL Server Developer duties
- Installed and configured Microsoft SQL Server 2000 databases
- Created and implemented data migration strategy by using SQL scripts, ETL/ELT packages
- Created and deployed stored procedures, tables, indexes, triggers, alerts, agent jobs, scripts and other database objects in support and implementation work
- Performed and validated table values, back-loaded data, converted data for database migrations or upgrades
Confidential, Hauppauge, NY
Product Support Consultant
Responsibilities:
- Provided technical and consultative services in order to install, configure and service 990, 1010, and 1020 Ultra Sonic flow computers
- Created implementation plans and schedules
- Interfaced with customers to define requirements and recommend hardware/software configuration to meet, data inputs/outputs, wiring and power requirements for each computer
- Worked with manufacturing to insure timely equipment delivery in conjunction with implementation schedule
- Installed and configured computer system and configured software parameters
- Optimized system performance to meet customer specifications for technical data
- Generated additional sales when more functionality was required outside contract specs
- Trained customers on the installation, calibration, and reconfiguration of system
- Managed client’s concerns and expectations throughout the implementation cycle
- Resolved and managed conflicts, technical issues and risks of implementation
- Interfaced with product engineers to recommended product changes based on reoccurring issues
- Managed travel and expense budget