SUMMARY:

• Project Management, Data Architecture, Database Engineer and Administrator with 15+ years extensive experience designing, Data Modeling, coding, testing and supporting next - generation database solutions with 10 years of SQL Server and MySQL, 7 years of Oracle, 3 year PostgreSQL in an enterprise environment.
• Proficient in an assortment of technologies, including Oracle 8i, 9i, and 10g, 11gR2, MS SQL Server 7 to 2012, including SQL 2012 code named Denali, Access, Sybase, MySQL, DB2, PostgreSQL, JDBC, Visio, Apache Web Server, IIS web Server, Erwin, ER Studio, ModelRight Pro, Oracle’s SQL DataModeler, Navi DataModeler, Toads Data Modeler, Java, C++, Visual Basic, .NET, MVC Framework, SQL, T-SQL, PL/SQL, XML, PHP, Version Control, Windows and Linux OS(RedHat, CentOS, Ubuntu, SuSe, and Fedora).

TECHNICAL SKILLS:

Technology and Tools: MS SQL Server Database Administration Data Security, Backup & Recovery Failover Clustering Setup and Administration Data Modeling and Development SQL Tuning in a MS SQL Server Environment SQL Tuning in an Oracle Environment MS SQL Server Installation and Configuration MS SSAS, SSIS, and SSRS Solutions Development Data Architecture Design and Analysis BI Design and Development Data Warehouse Design and Development. Performance Tuning & Capacity for SQL Server and Oracle Databases Servers Oracle RAC & ASM Administration/Installation Number of RAC installs 4 Number of RAC re - installs 6 Oracle Grid Control Database-Backed Web Solutions Oracle 8i, 9i, 10g, 11gR2 Database Administration Monitoring of Databases Engineering of Environments Development of Triggers and Stored Procedures Database Modeling of OLTP, OLAP, ROLAP, MOLAP, and HOLAP Databases MySQL: Database Administration PostgreSQL Database Administration MySQL Replication and Cluster Project Scoping, Project planning, scheduling, vendor management, risk assessment, budgeting, change management. Business Organizational Skills Business Development Business Communication Business Analysis Business Plan Writing Business Management Application Development Security Business Continuity and Disaster Recovery Planning Cryptography Information Security Governance and Risk Management Legal, Regulations, Investigations and Compliance Operations Security Physical (Environmental) Security Security Architecture and Design Telecommunications and Network Security

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect / IT Consultant

Responsibilities:

• Consulting, Data Architecture, Project Management, Data Modeling, MS SQL Server 2008, 2008R2, 2012 Assessments and Database Administration, Data Warehouse Design and Development, MySQL Database Administration Support, Oracle 11gR2 Database, OBIEE, Warehouse Builder, WebLogic Migration and Support. Project Planning, Project Milestone, Organizing of Project meetings, support and managing SQL BI Developers and Oracle DBA. Support ETL process to and from MSSQL Servers, MySQL in a LAMP Environment to Microsoft Dynamics AX 2012 for Clients. Implementation of Master Data Services for clients. Analysis of clients ETL processes, SSIS, SSRS, Dimension Cubes, SQL code, Oracle PL/SQL code, packages, and processes. Migration Project for a Clients SQL Server and Oracle Database, OWB, WebLogic, and BI Reporting.
• Development Data Models, Data Flows, Data Mapping, BI SSIS Packages, BI SSRS Reporting, BI Analytical Data Model. Developing Data reporting improvement strategies and process for healthcare reform. Creation of Written Proposal for developing BI Data Warehouse for clients Planning and BI Development of Data Warehouse Solution.
• Project Architecture and Design assessment and reviews. Reviewing of Data Architecture project assessment viability and providing recommendation. Reviewing of architectural and design artifacts which included the data models from the concept, data flow, process, logical, physical, client's SOA, ICD's, Sequence Diagrams, Class Diagrams, Data mappings, SQL Server DBMS Architecture, Data Recovery, Security, and Stored procedures. Recommendation for Data Warehouse solution with Data Model design.

Confidential

Data Architect

Responsibilities:

• Data Architecture, Project Management, Data Modeling, MS SQL Server 2008, 2008R2, 2012 Assessments and Database Administration, Data Warehouse Design and Development, MySQL Database Administration Support, Oracle 11gR2 Database, OBIEE, Warehouse Builder, WebLogic Migration and
• Support. Project Planning, Project Milestone, Organizing of Project meetings, support and managing 3 SQL BI Developers and 1 Oracle DBA. Supporting ETL process to and from MSSQL Servers, MySQL in a LAMP Environment to Microsoft Dynamics AX 2012 for InfuSystem Client. Implementation of Master Data Services for clients. Analysis of client ETL processes, SSIS, SSRS, Dimension Cubes, SQL code, Oracle PL/SQL code, packages, and processes. Migration Project for a Client Oracle Database, OWB, WebLogic, and BI Reporting.

Confidential

Data Architect/BI IT Consultant

Responsibilities:

• Development Data Models, Data Flows, Data Mapping, BI SSIS Packages, BI SSRS Reporting, BI Analytical Data Model. Developing Data reporting improvement strategies and process for healthcare reform. Creation of Written Proposal for developing BI Data Warehouse for MarketPoint. Planning and BI Development of Data Warehouse Solution.

Confidential

Senior Database Information Architect/IT Consultant

Responsibilities:

• Improving, Designing, and Migration of Confidential ’s Co. Database Infrastructure Standards for 52 Server MS SQL Server with over 600 Database. Updating and creating of SOP to reflect best practices for use with Microsoft SQL Server. Providing support for all MS SQL Environments, along with cataloging all SQL Server Instances and databases, creating repository of information making recommendation for areas of improvement. Creating database models for so that their DBA team can track how the databases set for and their level of compatibility. Also creating data refresh sync process, deploying reports for Reporting Services.

Confidential

Senior Database Information Architect/IT Consultant

Responsibilities:

• Project Architecture and Design assessment and review for IBM client. Reviewing of Data Architecture project assessment viability and providing recommendation. Reviewing of architectural and design artifacts which included the data models from the concept, data flow, process, logical, physical, client's SOA, ICD's, Sequence Diagrams, Class Diagrams, Data mappings, SQL Server DBMS Architecture, Data Recovery, Security, and Stored procedures. Recommendation for Data Warehouse solution with Data Model design.

Confidential, Louisville, KY

Database Administrator/ Database Developer

Responsibilities:

• Manage Oracle databases environments ranging from 10g R2 to 11g R2 with sizes up to 500gb and above with environment total 4.5Tb +. Assisting with management of PostgreSQL servers, and MS SQL Servers.Developing database solutions for Oracle. Data management for Oracle servers, Data
• Warehouse testing in Green Plum, data manipulation, data exports and imports, Stored Procedure, functions, and triggers. Creating Data Models based on current system and improvement of process. Creating SSRS reports for the Data Services, Infrastructure, Market Intelligence, Data Integrity & Client Services Teams. Helping with development and Implementation of SSIS and SSAS. Fulfillment of support request made by the Data Integrity Teams when clients request for data. Supporting request coming from Application Services Team.

Confidential, Sterling, VA

Database Solutions Consultant

Responsibilities:

• Providing Client side support for HP with their client at Citi Group providing support and implementation of HP D.M.A. product ( Database Managing Automation System). Developing workflows for Database deployments of Oracle 11gR2 and Oracle RAC Implementation, MS SQL Server, and Sybase 15 using Jython, Korn Shell, and Windows Scripting. Creating Korn Shell scripts following Citi Groups DSA Guidelines for auditing, Oracle Security Internal and External hardening. Along with implementation deployment of Virtual system running RedHat, CentOS, Ubuntu, SuSe, Fedora, and Windows Servers for demo to clients.

Confidential, Fort Knox, KY

SQL DBA/Database Engineer

Responsibilities:

• These duties for the Confidential /DOD includes and implementation of database administration maintenance of 50 to 100 database with sizes ranging from 20 to 60Gbs and SharePoint databases equaling 100Gb, SQL job creation, rebuilding indexes and SQL cluster installs on servers and VMware environments. Reverse Engineering of Database Schemas, Data Modeling for new implementation of user database, SQL Policy designing, SSIS package build and developed evaluation SQL code before implementation. Along with creating SQL installation deployment package. SQL Server design and documentation standards. SQL/T-SQL query, SSIS packages and SSRS report for Microsoft SQL Server 2005 & 2008 R2. Also researching Microsoft SQL Server 2011 ‘Denali’ and SQL Azure for future platforms.

Confidential, Cincinnati, OH

Business Partner/ CIO

Responsibilities:

• Databases services including administration, developing, implementing for IT business process for this start-up company using SQL Server 2008 and Microsoft Dynamics 2009 AX for internal systems and MySQL Database. Developed and implemented, and maintenance of companies website and external processes. Creating companies business plans for projects. Setting up of webhosting services for the company, which included email, website, and. Development and administration. Setup of company email accounts, implementation email and database mail rules and services.

Confidential, Cincinnati, OH

Database Engineer/Database Management Systems

Responsibilities:

• Served as DBA or project lead in the completion MS SQL Server migration of 80+ medium- to large-scale implementations and 2008, Assisted with business requirements analysis to solutions delivery and support.
• Assisted with $1.2 million data-integration project for Proctor and Gamble that consolidated information from client information and inventory applications, third-party market data and internal data applications.
• Created and Assisted with Technical documentation for DBMS Team. Creation of Technical documentation for DBMS deployment packages and guides.
• Creation of New Microsoft SQL Server Installation deployment packages
• Developed and tested storage strategies and disaster-recovery plan for Proctor and Gamble operational database, delivering solution that guaranteed recovery performance and high availability.
• Enhanced end users’ understanding of database systems by creating user-friendly walk-through guide materials.

Confidential, Irvine TX

DBMS Database Engineer/DBS

Responsibilities:

• Database Administration of Microsoft SQL Servers 2000 and 2005 database, performance tuning, Maintenance planning, Monitoring, Database Standards planning, and Technical writing. Performing other duties for Oracle Database environment running under HP UX, which included Performance tuning for SQL side along with database system side, Database troubleshooting, database scripting, migrations, and database maintenance for DR.

Confidential, Tampa FL

Oracle DBA/ Applications Support Specialist

Responsibilities:

• Database Application Administration of 15 Oracle 9i Database MS 2000 and 2003 Servers, 18 Database Job Servers. PL/SQL Development and Performance Tuning for Maintenance and application functions for Time Keeping and Payroll management, Work Order, inventory system.

Confidential, Cincinnati, OH

IT Consultant

Responsibilities:

• Project Management for Text Law books Database for Casemaker 2.0. Designed and implemented testing Oracle Database 10g R2, pre-production Oracle 10g R2 Database, and production Oracle RAC 10g cluster database environments. Implementation, configuration, developmental, and deployment of processes for business requirements, business process for development of the new Oracle Database environment. Maintaining the Oracle database environment for the RAC production, pre-production, and testing environment running on Oracle Enterprise Linux. Producing documentation procedures and creation of the installation configuration and development of the RAC production, pre-production, and testing environment.
• Creation of full database models, schema scripts to create each user schema, table schema, and SQL Tuning scripts. Design plans to implement migration between the CaseMaker 1.0 and CaseMaker 2.0 web application from Thunderstone database to oracle. Application development using PL/SQL for Queries, Function calls, Stored Procedure, and Triggers to or data handling and XML outputs interact with website using PHP coding and Ruby on Rails. Performed database development for Oracle Database environment which include data modeling, reverse engineering preparations for data export from Thunderstone database to import to Oracle database environment.

Confidential, Cincinnati, OH

Systems Administrator/Systems Analyst

Responsibilities:

• Creating the new JAVA Interface design and proposal to improve systems cross-platform capabilities
• Assisted with the Development and Implementation 511 IVR Traffic information automated system.
• Created Unix Shell scripts, stored procedures, functions, Visio flowcharts to design and map the layouts of the network, systems processes, system layouts, software interface, GUI layouts, improvements system, database, processes, and database layouts and data Models
• Created replication for data entered in to 511 IVR system between MYSQL and Access for new data entry information and traffic management system reporting
• Created Disaster recovery plan and implemented for traffic management system
• PHP coding updating Artimis’s websites, both internal and external referencing two types of databases under the ARTIMIS System.

Confidential, Hebron, KY

Field Systems Network Engineer

Responsibilities:

• Network installation, implementation, migration, and support for client project: Luxottica/ LensCrafters, and 401 Group.

Confidential, Cincinnati, OH

IT Consultant

Responsibilities:

• Consulting and support of network implementation, migration, and administration of the following products; NT 4.0, Windows 2000 Server and Professional, Exchange 2000, MS SQL Server 7 and 2000, Technical Support, Software Consulting for applications, TimeSlips, and Amicus Attorney. While going to client sites on an as needed.

Confidential, Cincinnati, OH

IT Manager

Responsibilities:

• Database Administration, Network Administration (Windows 2000 Professional and 2000 Server), Web Administration, Software Development, Web and Intranet Site Development, Project Management of Intelli-match. Help developed and test first intelli-match prototype designed using ASP and VB application accessing an Oracle 8i and SQL Server 2000 database over the web. Design second intelli-match layout, prototype, process, plus website design using Visio, which was based on using ASP or JSP accessing XML which indicated COM Objects that would access SQL Server or an Oracle DBS 8i. Management of 5 consultants for the intelli-match project setting up milestones, project scopes, meetings, and testing.
• Testing consisted of ASP and JSP Inputs check points for faults in the code to prevent error occurrences. Performed Database system installs and administration for Oracle running under windows environment. Also performing database systems installs and administration for MS SQL server 2000.

Confidential, Cincinnati, OH

Operations Analyst

Responsibilities:

• Testing and Processing during Priority CS Development of the new billing software that is currently under development. Testing Execution jobs through Event Control Service Manager along with creating batch jobs to execute run jobs for testing. While using Visio designs to understand the processes of the system and what to check if an error had occurred working MS SQL Server 2000.

Confidential, Cincinnati, OH

Remote Support Technician

Responsibilities:

• Providing remote desktop support to G.E. Aircraft Military and Civilian Field Techs, which consisted of laptop hardware upgrades and repairs, OS new installations, upgrades, updates, re-installs, data-recovery, configurations, and troubleshooting.

Confidential, Cincinnati, OH

Support Technician

Responsibilities:

• Project providing to technical support service to the Tri-Health Systems and Software Migration and Upgrade.

Confidential, Cincinnati, OH

Help Desk Technical Support Tier 1

Responsibilities:

• Providing end user technical support on the phone for consumer warranty customers, which consisted of hardware troubleshooting and some troubleshooting.

Confidential, Cincinnati, OH

PC Technician

Responsibilities:

• Information management of Networks, Computer Systems, Software Design, Software Development, Web Design, Web Development, Database Design, Database Development, Database Administration, and Project Management.

Confidential, Norwood, OH

Associates of Applied Science

Responsibilities:

• Area of study included performance tasks associated with the development of wide and local area network capabilities. A wide exploration range of networks platforms through classroom and laboratory experiences, while covering topics about systems integration, network system design, and implementation of network systems.
• Courses in Graphical User Interface Development and Design, TCP/IP, exposure to configuring Cisco routers, WAN Technology, Novell Netware, LINUX, Microsoft NT, Web Server Administration (IIS), Intro to Programming Visual Basic 6.0 and C++, JAVA, PC Support, Technical Writing, Telecommunications, Flowcharting designing schemes using Visio, Project management, and technical writing.