SUMMARY:

• Database professional that has had Secret clearance with over 16 years of architecting and implementing complex database systems.
• Strong communication skills provide good interaction between end - users, development, and management.
• Experience Designing / Implementing Database solutions from end-to-end.
• Experience managing critical applications in a production environment.
• Good leadership abilities to keep project and team focused on providing customers a quality product on time.

TECHNICAL SKILLS:

Operating Systems: Windows, LINUX, UNIX, HP Non-Stop

Databases: Oracle 9i and 10g, MySQL 5.x, SQL Server (2000-2012), Non-Stop SQL, Greenplum, Sybase

Skills/Tools: PowerDesigner, ERWin, Business Objects, T-SQL, SSIS, SSRS, SSAS, Service Broker, Silverrun, Constructa, CoolGen, Control CS, SQLCI, PL/SQL, ODBC, RMAN, Backup, Restore, DBA/M, Golden Gate Replicator, SQL/MX, MS Access.

EXPERIENCE:

Solutions Architect

Confidential

Responsibilities:

• Architected solution to integrate data in near - real time into a normalized ODS database. Completed 4 phases of the project plan using SSIS and SQL Server Service Broker.
• Designed and Implemented Data Warehouse to capture driver trip information in a near-real time environment.
• Performed data analysis on source system for Data Quality checks.
• Created the ETL standards and processes for the ODS environment.
• Constructed ETL packages using SSIS
• Converted Informatica ETL into SSIS ETL packages

Lead Architect

Confidential

Responsibilities:

• Leading team of 12 SSIS developers to Migrate existing Mainframe legacy system to SQL Server 2008 R2.
• Working with business subject matter experts to ensure implementation reflects the needs of the business.
• Managing off - shore 3rd party partner for development.
• Reviewing and advising client on Data Warehouse Architecture deficiencies.
• Rewriting Data Warehouse load routines gaining 1000% performance increases.
• Developing policies and procedures for development for our environment.

Senior Database Architect

Confidential

Responsibilities:

• Review requirements to Architect Data Warehouse solutions for new projects.
• Used PowerDesigner 15 to create Physical Data Models used for the creation of the database, to reverse engineer existing source databases, and create a robust data dictionary for data model reports.
• Implemented PowerDesigner’s Data Repository to track versioning and be used as a Data Base Development tool.
• Created policy and procedures document for best practices in using PowerDesigner and performing Data Modeling Techniques.
• Perform capacity planning and redundancy considerations for Data contingency plans.
• Work with end users to create a flexible and adaptable Data Warehouse model that will grow as the business grows.
• Use SSIS to create Data Extractions to load target databases from multiple data sources including Sybase and Oracle 11g data sources.

Data Warehouse Architect

Confidential

Responsibilities:

• Designed Data Warehouse using PowerDesigner 15 to store project and client data for Lockton Insurance Policies.
• Architected database implementation and capacity planning for new Data Warehouse initiatives.
• Interviewed business users to understand business and create reporting solutions to give flexible answers to their respective Lines of Business.
• Used SSRS and Report Builder to generate reports that were distributed using a Reporting Server.
• Performed Database Administration for backup processes, jobs, upgrades, and configuration of new Database Installations.
• Used SSIS packages to handle the ETL processes.
• Used SQL Server 2008 to create the structures for the data warehouse
• Created Stored procedures to work with the SSIS packages to ensure efficient ETL processes were in force.
• Used PowerDesigner 15 Repository to store meta data about the data model.

Lead Database Architect

Confidential

Responsibilities:

• Reviewed multi-tier Oracle 10g Database for performance and design enhancement possibilities.
• Designed and implemented Oracle 11g R2 Database.
• Worked with facilities management to plan upgrades to the Data Center to accommodate new racks and servers in the Data Center.
• Created and Reviewed PL/SQL routines.
• Used ERWIN to create logical and physical models for new MySQL 5.1 Data Warehouse.
• Interviewed client to gather data requirements.
• Maintained a Meta Data repository using ERWIN.
• Researched latest database technologies such as Oracle Exadata and Greenplum to ensure solutions are technically proficient.
• Evaluated tools to replace Data Access Layer.
• Wrote proposals to upper management to inform of the potential gains and costs associated with enhancements.
• Managed additional resources to work through the plan to implement enhancements.
• Recommended additional tools / technologies to create a cleaner more efficient system.
• Interviewed end-users and business leaders to create BI requirements.
• Evaluated the hardware and disaster strategies and make recommendations to meet customer SLAs.
• Reviewed and mentored other Data Architect’s data models and gave recommendations for enhancements / standardization.

Technical Architect

Confidential, Phoenix

Responsibilities:

• Worked with customer to gather requirements for a web based gaming product.
• Created user stories to enforce the scenarios of the product.
• Documented the data flow of the system.
• Used PowerDesigner to Document the Database Architecture fed from an XML data feed.
• Worked with Solutions Architect to determine the best Hardware / Software solution for long term growth and maintenance.
• Created and maintained a MySQL5.1 database on Ubuntu Linux environment.
• Created a security schema to handle system access.
• Worked with Java Developer to create the web front end.
• Wrote and tuned SQL statements to MySQL 5.1

Sr. Database Architect

Confidential

Responsibilities:

• Designed a POC data warehouse to enhance the reporting capabilities of the current dashboard used to monitor and query metrics on their system.
• Met with developers, business analyst, and management to gather business requirements.
• Worked with customer to determine business intelligence requirements.
• Worked with WebFocus to implement BI solutions.
• Worked with Client to determine the best Hardware solution and setup to accommodate the Dataware house in the Data Center.
• Created a dimensional data model using Power Designer.
• Created a meta data repository.
• Reverse engineered portions of the current OLTP system.
• Performed data profiling of the source data using T - SQL.
• Performed a first pass initial load in SQL Server 2005.
• Demonstrated to the customer the capabilities of the new data warehouse.
• Generated specifications for the ETL team to create SSIS packages.
• Worked on additional projects to Implement Micro-Strategy Reports to satisfy BI use cases.

Database Specialist

Confidential

Responsibilities:

• Troubleshot issues in regards to Confidential database replication environments for multiple customers on multiple platforms.
• Assisted customers in migrating data from legacy applications to relational Databases on SQL Server, Oracle.
• Assisted customers with their Database performance on SQL Server to ensure the replication product was working efficiently with their system.
• Analyzed stored procedures for optimization.
• Assisted customers on the setup of their Disaster Recovery / Hot Site backup systems.
• Created productivity tools to help analyze performance data.
• Created a metrics tool which could be rolled out to customers.
• Trained customers on how to configure and use Confidential in their database environment.

Lead Database Architect

Confidential

Responsibilities:

• Worked with Management team to build Data Center from scratch including Server Acquisition, Backup and Redundancy Plan, Power and Cooling considerations, and Network requirements.
• Migrated One Terabyte OLTP Database from legacy system to new data center in 9 months.
• Led data analysis and design sessions for data conversion and migration.
• Created conversion plans and system cutover plans for the database and supporting files.
• Reviewed all model designs and data model changes for the Data Architecture team.
• Worked with Business Analysts to define changes to a 5 Terabyte Enterprise Data Warehouse.
• Maintained Metadata repository to define data elements and data mappings.
• Took new business requirements and created appropriate changes to the logical data model for enhancements.
• Worked with development group to create Design and Architecture procedures.
• Used SSIS to convert data from the Data Warehouse into smaller reporting databases on SQL server.
• Recommended, planned, and implemented Golden Gate replication to create a seamless migration from legacy system to new Architecture.
• Mentored junior level analysts on methodologies / best practices on Data Architecture for Enterprise Data Warehouse development.
• Developed Disaster Recovery Plan including hardware architecture recommendations.
• Developed and Implemented Security structure for users.
• Reviewed all new applications for SQL optimization issues.
• Used a Master Data Model approach to the OLTP systems to simplify and strengthen the data quality for the ETL processes for the Data Warehouse.
• Performed Capacity planning and created proposals to justify additional DASD when it was required.
• Implemented ODBC and helped maintain robust ODBC environment which was used by Business Objects to mine data from a 5 Terabyte Data Warehouse.

Database Analyst

Confidential

Responsibilities:

• Maintained and supported Tandem S - Series production and development system across 2 nodes that use Golden Gate replication.
• Automated numerous processes using TACL and Netbatch.
• Enhanced disaster recovery procedures.
• Created scripts to perform Enscribe and SQL Database maintenance.
• Installed and deployed Define Management System (DMS).
• Worked with development staff to resolve performance issues.
• Developed scripts to upgrade IDX Lastword from version 5.1.2 - 5.1.4.
• Trained DBA and Systems staff on various Tandem utilities.

Senior Data Architect

Confidential

Responsibilities:

• Team lead for Data Architecture group of 5 DAs supporting development efforts for the Confidential .
• Performed technical review for team members to ensure consistency and accuracy of the data model and Metadata for each development project.
• Prepared status reports for management for Data Architecture team.
• Participated in interview process for new Data Architecture team members.
• Performed product review/comparison between PowerDesigner 9.0 and Rational Rose.
• Created Dimensional Models and added Metadata to a centralized Repository.
• Generated additional use for the Data Architecture team via meetings with development leads.
• Mapped legacy data to the Enterprise Metadata Repository via interviews with the end users.
• Created new OLTP Data Models for new applications.
• Developed and implemented physical database for OLTP system to process Medicaid claims for the state of Texas. The OLTP system was over 1 Terabyte and processed 125,000 claims a day.
• Developed new data warehouse for the State of Texas Medicaid/Medicare Claims Processing. Warehouse was a 4 Terabyte system allowing ad-hoc queries to be performed by the State of Texas Department of Health.
• Worked with business analysts to create database design for a portion of the Data Warehouse.
• Communicated database design enhancements with development architects to generate physical database modifications.
• Developed and implemented procedures for managing the migration of database changes to the OLTP system.
• Reviewed junior and senior level DBA recommendations for the OLTP.
• Analyzed and implemented performance enhancements to the physical database.
• Communicated database strategies for DBA staff to management.
• Sized, partitioned, and implemented over 1000 database objects for implementation of the OLTP and Phase II Data Mart in development, test, stress-test, and production environments.
• Configured and troubleshot ODBC environment.
• Tested new system options for performance improvements.
• Determined cost estimates and resource requirements for Phase II Data Mart and OLTP.
• Created task lists and timelines for implementation.
• Determined index requirements for performance.
• Participated on Data Conversion team to design migration efforts to new OLTP system.
• Worked closely with development and Enterprise Data Warehouse team to ensure data flowed from the OLTP system to the EDW.

Database Analyst

Confidential

Responsibilities:

• Managed call processing environment for Confidential 's prepaid phone card system.
• Distributed database environment consisting of 10 nodes with operating systems ranging from D20 to D45.
• Analyzed business requirements to create a logical models using Silverrun.
• Maintained Meta Data Repository and naming conventions for all Data Elements.
• Created physical design with development design team.
• Reviewed all database designs for new models or enhancements.
• Re - engineered Confidential s prepaid calling card platform. Effort was a four month overhaul to totally revamp how the prepaid calling card platform worked from a data perspective.
• Managed production and development databases.
• Participated in interviewing and evaluating DBA Staff.
• Analyzed and performed database tuning.
• Analyzed and implemented database replication across nodes using Golden Gate