Director Of Enterprise Data Architecture And Business Intelligence Resume
Owings Mills, MD
SUMMARY OF EXPERIENCE:
- I have over 20 years of experience in various areas and at various levels in the information technology field.
- My most recent experience has been in Enterprise Data Management, IT leadership, Data Governance, and Business Intelligence.
- In addition, I have previous experience in application and systems design and development, specifically in the areas of business applications for the financial, MLM, insurance and manufacturing industries with a focus on ERP, Accounting, Customer Service and Salesforce automation systems.
- My many years as an independent consultant has given me a unique talent for conveying technical information in a non - threatening manner as well as proficiency in needs analysis and project specifications gathering task when interfacing with clients.
- I am interested in opportunities that will allow me to utilize my varied skill-set and leadership experience in a growing company or established small to mid-size corporation, to help increase growth and efficiencies and provide a challenge to me in my career as a Technology Professional.
DETAILED EXPERIENCE:
Confidential, Owings Mills, MD
Director of Enterprise Data Architecture and Business Intelligence
Responsibilities:
- Set direction and scope for all Data Related projects and initiatives for the entire enterprise.
- Develop and provide leadership to Confidential Data Management team which is comprised of Junior and Senior DBA’s, Database Developers, BI Developers, Master Data Developers and data Warehouse designers in support data driven applications and development projects for new applications, reporting and analytic tools, Business Intelligence and ERP and ecommerce Systems for the enterprise.
- Manage and develop a team of Data Architects and other technical resources responsible for delivery and support of Enterprise Data Models, Business Intelligence Reporting Delivery and Master Data Management standards and processes.
- Design and implement standard processes and procedures (request prioritization, data modeling, design & development review, testing, change management, promotion to production, communication, etc.) and ensure ongoing adherence.
- Define strategy and roadmap for Business Intelligence solutions and products for the enterprise.
- Define strategy, roadmap, principles, vision and standards for data management for the entire enterprise.
- Evaluate business risk, manage change and improve business effectiveness, agility and accountability as related to management, security, governance and privacy of corporate data.
- Ensure system design and data are globally consistent
- Ensure that technical projects, products, and service delivery meet established cost, time, and quality.
- Lead data management groups and established procedures to leverage data assets
- Develop a Data Portfolio Management approach including performance monitoring, alerting and workflows.
- Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
- Worked directly with developers and analyst to resolve data conflicts and inappropriate data usage and retrieval.
- Develop strategies and road maps for data management
- Design and implement disaster recovery solutions for critical systems.
- Ensure high quality periodic executive communication around strategic initiatives
- Proactively identify potential performance and scalability issues by leveraging statistics, infrastructure, and other integrated components and teams.
- Established data governance and master data management standards
- Work closely with IT leadership to create long-term strategic vision for data management
- Make recommendations and approved purchase of DBMS tools and software.
- Establish quotas and auditing for vulnerabilities and regulatory compliance.
- Analyze all informational requirements, and establish standards and best practices for database development, object promotion and access and use.
- Develop database specifications, and enforced all database standards.
- Facilitate discussion of technical issues. Conduct basic negotiations with other departments to achieve project/product goals.
- Provides consistent, timely and effective coaching in an individualized manner and completed thorough and fair performance assessments of staff.
- Development of Corporate Database backup and recovery strategies and Disaster Recovery Planning and Documentation.
- Participation in meetings with stakeholders for all projects related to Database Management Systems.
- Established policies for data governance and security in compliance with SOX and PCI regulations and guidelines and inline with internal audit controls for privacy and access to data as a public company.
- Meets with and advises executive leadership in all areas of Business Intelligence and Data Management and Security.
- Established and managed budget for software, human resources and services related to enterprise data management and all relational database systems and platforms for the enterprise.
Confidential, Owings Mills, MD
Manager of Enterprise Data Architecture
Responsibilities:
- As a Member of Corporate IT leadership assisted in setting of IT policy and vision as it relates to the Enterprise at whole and participated in corporate leadership discussions, round tables and committees.
- Develop and lead a team of DB Developers and DBA's to support data driven applications and development projects for new applications, reporting and analytic tools, ERP Systems and ecommerce Systems for Corporation.
- Managed and develop a team of Data Architects and other technical resources responsible for delivery and support of Enterprise Data Models and Master Data Management standards and processes
- Design and implement standard processes and procedures (request prioritization, data modeling, design & development review, testing, change management, promotion to production, communication, etc.) and ensure ongoing adherence.
- Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
- Worked directly with developers and analyst to resolve data conflicts and inappropriate data usage and retrieval.
- Design and implement disaster recovery solutions for critical systems.
- Proactively identify potential performance and scalability issues by leveraging statistics, infrastructure, and other integrated components and teams.
- Make recommendations and approved purchase of DBMS tools and software.
- Establish quotas and auditing for vulnerabilities and regulatory compliance.
- Analyze all informational requirements, and establish standards and best practices for database development, object promotion and access and use. Develop database specifications, and enforced all database standards.
- Facilitate discussion of technical issues. Conduct basic negotiations with other departments to achieve project/product goals.
- Work closely with the system administrator to perform software installations, and to configure hardware and software so that it functioned optimally with the DBMS. Responsible for the configuration of hardware and software with the system administrator.
- Analyze the data stored in databases and to make recommendations relating to performance and efficiency of that data storage related to more effective use of indexes, enabling "Parallel Query" execution, or other DBMS specific features.
- Provides consistent, timely and effective coaching in an individualized manner and completed thorough and fair performance assessments of staff.
- Management, Performance Tuning and Maintenance of Microsoft Navision (NAV) Enterprise ERP System Database and Security on SQL Server.
- Development of Corporate Database backup and recovery strategies and Disaster Recovery Planning and Documentation.
- Participation in meetings with stakeholders for all projects related to Database Management Systems.
- Established policies for data governance and security and compliance with SOX and PCI compliance.
Confidential, Owings Mills, MD
Senior DBA
Responsibilities:
- Worked with database management systems software in order to determine the best possible way to organize and to store data for Confidential, Inc. a dietary Weight Loss Company.
- Managed/Directed team of two onsite and five off-shore Database Administrators in all areas management to provide 24/7 coverage and support for all DBMS.
- Ensured system design and data were globally consistent
- Lead data management groups and established procedures to leverage data assets
- Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
- Worked directly with developers and analyst to resolve data conflicts and inappropriate data usage and retrieval.
- Develop strategies and road maps for data management
- Identified the requirements of the users, created databases, tested the modifications made and promoted all changes to corporate staging, test and production database systems.
- Established data governance and master data management standards
- Worked closely with IT leadership to create long-term strategic vision for data management
- Made recommendations and approved purchase of DBMS tools and software.
- Manage and develop a team of Data Architects and other technical resources responsible for delivery and support of Enterprise Data Models and Master Data Management standards and processes
- Designed and implemented system security and other security measures.
- Architected Enterprise Data warehouse to persist data from over 20 various sources and systems include Big Data from our various Web Analytic providers.
- Influence vendor roadmaps and direction of vendor products
- Established quotas and auditing for vulnerabilities and regulatory compliance.
- Analyzed all informational requirements, and establish standards and best practices for database development, object promotion and access and use. Develop database specifications, and enforced all database standards.
- Worked closely with the system administrator to perform software installations, and to configure hardware and software so that it functioned optimally with the DBMS. Responsible for the configuration of hardware and software with the system administrator.
- Analyzed the data stored in databases and to make recommendations relating to performance and efficiency of that data storage related to more effective use of indexes, enabling "Parallel Query" execution, or other DBMS specific features.
- Interacted with and coached developers in SQL scripting and best practices.
- Management, Performance Tuning and Maintenance of Microsoft Navision (NAV) Enterprise ERP System Database and Security on SQL Server.
- Development of Corporate Database backup and recovery strategies and Disaster Recovery Planning and Documentation.
- Participation in meetings with stakeholders for all projects related to Database Management Systems.
- Established policies for data governance and security and compliance with SOX and PCI compliance.
Technologies Utilized: SQL Server 2008, SQL Server 2005, SQL Server 2000, Oracle 10g, T-SQL, PL/SQL, ODBC, Windows Server 2008, Windows Server 2003, Windows 2000, Windows Vista, VISIO, SharePoint, MS Access, Business Objects, SSRS, SSIS, MS DTS (Data Transfer Services), SSMS, Query Analyzer, Microsoft Project, Windows Clustering, SQL Server Clustering, NetApp SAN, HP SAN, Embarcadero DB Optimizer and Performance Center, Red Gate SQL Tool Belt, Microsoft Dynamics NAV, Navision 3.7, 4.0, 5.0, VM Ware, Dell Servers, Dell Storage Array design and management, HP Servers, SQL Replication and Log Shipping.
Confidential, Washington, DC
Sr. Database Administrator, Sr. Software Engineer
Responsibilities:
- Database management of all corporate databases
- Systems management and database administration responsibilities for General Ledge Accounting System (MAS 500 / Sage Enterprises Suite), Investment Portfolio Management Systems (Bond Edge, Trade Web, Bloomberg, CAMRA and LMS Software) and (MSHARE)
- Architecture, design and development of all corporate databases
- Management of in-house and out-sourced software development projects
- Management of off-site vendor applications
- Designed disaster recovery plan for SQL Server databases recovery and participated in regularly schedule disaster recovery testing.
- Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
- Worked directly with developers and analyst to resolve data conflicts and inappropriate data usage and retrieval.
- Coordination and design of all data management between vendors, clients and enterprise.
- Testing and review, prototyping, requirements gathering and analysis, documentation development, and systems design and engineering.
- Testing, evaluation and selection of new software for the corporation to include development, desktop, server, help-desk, and monitoring and management software and consoles.
- Design and management of SQL Server Clustered Environment.
Technologies Utilized: SQL Server 2000, SQL Server 2005, Transact SQL, MS DTS, SSRS, SSIS, ODBC, Query Analyzer, Windows Server 2003, Windows 2000, Visual Basic 6.0, Visual Interdev, Visual Basic .NET, ASP, VB Script, Visual Source Safe, VISIO, Windows NT Server 4.0, Windows 2003, Install Shield, MS Access 2003, Crystal Reports, Business Objects, Microsoft Project, CITRIX Meta Frame, MAS 500, Sage Enterprises Suite, LMS, CAMRA, FRx Financial Reporting Tool, Peachtree, Bond Edge, Bloomberg, Trade Web, Virtual PC, Hyena, Microsoft Clustering Services, Dell Servers.
Confidential, New York, NY
Database Administrator, Sr. Software Engineer
Responsibilities:
- Designed data modeling for data-warehouse that consolidated data from three of the company's internal accounting systems.
- Data extraction from Investment and GL systems performed using DTS (Data Transformation Services) Jobs trigger via Visual Basic Code.
- Development of User reporting interface in Visual Basic with Crystal Reports for system generated financial and reconciliation reports.
- SQL Database Administration responsibilities for General Ledge Accounting System (MAS 500 / Sage Enterprises Suite) and three Investment Portfolio Management Systems (CAMRA and LMS by SS&C Software) and (MSHARE) and various custom built client/server applications.
- Sr. Software engineer duties to include requirements gathering, software design and development in visual studio
- Project management for all software development project within organization
- Testing and review, prototyping, requirements gathering and analysis, documentation development, and systems design and engineering
- Internet and Intranet development in Visual Studio
- Report design and development
- Application packaging and deployment
Technologies Utilized: Visual Basic 6.0, Visual Source Safe, VISIO UML Tools, SQL Server 2000, Transact SQL, ODBC, Windows NT Server 4.0, Windows 2000, Install Shield, MS Access 2000, Crystal Reports, MS DTS (Data Transfer Services), Query Analyzer, Visio, Windows 2000 Server, Microsoft Project, CITRIX Meta Frame, MAS 500, Sage Enterprises Suite, LMS, CAMRA, FRx Financial Reporting Tool, Dell .
Confidential, Silver Spring, MD
Software Engineer/Programmer Analyst
Responsibilities:
- Visual Basic and VBA development
- SQL Server Development including Data Architecture, Database Design, and creation of database objects such as triggers, views, and stored procedures.
- Project management, meetings with internal client for requirements determination
- DBA functions for the HSRD info database
- Conducted end-user training
- Complex Query and stored procedure development in SQL Server
- Coordination of all system testing and release milestones
- Design and development of DTS packages to retrieve desired data from various VA SQL Server databases in and around the US via TCP/IP.
- Report design and development
- Application packaging and deployment
Technologies Utilized: Visual Basic 6.0, Visual Source Safe, MS SQL Server 7.0 & 2000, Transact SQL, ODBC, Windows NT Server 4.0, Windows 2000, Install Shield, MS Access 2000, Rational Rose, Clear Quest, Crystal Reports, Rapid SQL, MS DTS (Data Transfer Services), Query Analyzer, Visio, Windows 2000 Server.
Confidential, Baltimore, MD
Consultant, Software Engineer, SQL Server DBA
Responsibilities:
- DBM and DBA tasks of databases from off-site location via checkpoint secure remote connection
- Creation of database maintenance tasks
- Database modeling and table design
- Complex Query development in SQL Server
- Design and development of all database objects such including stored procedures, triggers and tables and views.
- Palm OS development in Visual Studio
- MS Access database and user interface development
- Requirements gathering, testing, prototype development
- Project management
- Report design and development
- Application packaging and deployment
Technologies Utilized: Visual Basic 6.0, SQL Server 7.0 & 2000, T-SQL, DTS, ODBC, Windows NT Server 4.0, Windows 2000, Install Shield, MS Access 2000, Palm Installer, AppForge Booster, Microsoft Project, AppForge Professional for PalmOS and Windows CE, Palm OS Extended Function Library, NS-Basic for Palm, Windows 2000 Server.