Project Manager Resume
Richmond, VA
SUMMARY
- He is an experienced Database Architect and Database Developer with seventeen years experience in delivering sensible database solutions to meet complex data needs. This includes collecting data requirements and determining system design, data stewardship/metadata maintenance, logical and physical data modeling (3NF and star schema), database creation, extract, transform, and load (ETL/SSIS/DTS) processing, executive - level report design, and post-delivery maintenance and support spanning both operational and analytical data stores.
- He also has experience administering SQL Server databases, creating Business Objects/Oracle Enterprise Reporting/Brio/SQL Server Reporting Services (SSRS)/ and Crystal Reports reporting to user specification, as well as creating and optimizing T-SQL/PLSQL queries to address complex data needs.
- He also possesses a wealth of experience facilitating design sessions between business and technical staff, focusing on being the business/technology bridge and adding real value to meet business needs. He has vast experience gathering requirements, analyzing business rules, and guiding the business community through identification of data and service gaps then determining and providing the most efficient solution.
- He also works very well in either an AGILE or Waterfall development environment.
AREAS OF EXPERTISE
- Business Problem Analysis and Solutions Delivery
- Database System Architecture and Design
- Transactional (3NF) and Dimensional (Star Schema) Data Modeling
- Reporting Systems Design and Creation
- ETL - SSIS/DTS Development
- T-SQL/PLSQL
- .NET Development
TECHNICAL SKILLS
Development Languages: T-SQL (17 years), PL-SQL (12 years), C# (2 years), VB.NET (3 years), Visual Basic (10 years), ASP (5 years), VBA (5 years), Java Script (5 years), VB Script (5 years)
Databases: MS SQL Server 2000/2005/2008 (17 years), Oracle 10g-11g (7 years), MS Access (15 years), Teradata (3 years), IBM DB2 (2 years)
Database Clients and Applications: MS SQL Server Enterprise Manager (17 years), MS SQL Server Management Studio (6 years), MS SQL Server Integration Services (SSIS) (4 years), MS Data Transmission Services (DTS) (10 years), SQL Plus (2 years), MS SQL Query Analyzer (17 years), TOAD (2 years), IBM/DB2 DB2 Command Editor (1 year), Teradata SQL Assistant (3 years), Dataflux (1 year)
Business Intelligence Tools: Hyperion Brio (8 years), Oracle Enterprise Reporting (2 years), SQL Server Reporting Services (SSRS) (2 year), Business Objects (1 year), Crystal Reports (5 years)
Data Modeling Tools: MS Visio (5 years), Erwin (5 years)
Additional Software/Tools: MS Excel (15 years), MS Word (15 years), MS Outlook (15 years), MS Project (2 years), MS Powerpoint (3 years)
PROFESSIONAL EXPERIENCE
Confidential - Richmond, VA
Project Manager
Responsibilities:
- Coordinated multiple simultaneous projects for BP Deep Water Horizon settlement program. This included projects to create new functionality as well as enhance existing capabilities. Responsibilities included gathering requirements, assigning tasks, creating milestone and delivery schedules, performing quality control tasks on deliverables, coordinating user acceptance testing and production release.
- Performed code analysis of SQL Server 2012 and C# objects to provide detailed explanations of process to business customers as well as to prepare code documentation and walkthroughs.
- Mentored junior-level SQL Developers providing insight and direction as well as proofing code to ensure what was created by the development team is what was requested by the user community.
Confidential - Richmond, VA
Senior Database Consultant
Responsibilities:
- Created complete data warehouse systems by gathering user data requirements, developing logical and physical data models in dimensional schema (ERwin), instantiating the physical data model in SQL Server 2008, developing and fine-tuning ETL processes (SSIS), creating a presentation layer to power a suite of end-user reports, and developed those reports in Business Objects and Hyperion Brio.
- Daily creation and optimization of T-SQL and PL/SQL queries within MS SQL Server, Oracle, and Teradata while employing a variety of methods to optimize SQL, including: examining and adjusting query execution plans, designing a sensible, aggressive indexing strategy, manufacturing free-standing aggregate tables where applicable, joining to nested data subsets versus entire tables, and eliminating nested view architecture.
- Daily SQL Server administration responsibilities included monitoring database usage, adding database users and roles, creating and managing SQL Server Agent jobs, job scheduling, alerts, and messaging, monitoring processes and resolving database blocking issues.
- Daily creation and maintenance of database objects such as tables, views, stored procedures, triggers, indexes, constraints, and primary and foreign keys.
- Creating and maintaining large-scale Business Intelligence dashboard reporting solutions and environments in Hyperion Brio, Business Objects, and Oracle Enterprise Reporting. Reporting models typically utilize server-side views and manufactured tables versus creating client-side schemas thereby leveraging database processing power, allowing easier query maintenance whereby a change to a single view or manufactured table can cascade across reports while creating a reusable code base that is easily ported across reports as well as different front-end reporting tools.
- Responsible for defining, designing, and developing incoming and outgoing data access flows using SQL Server Integration Services (SSIS) - including mapping source data to destination targets and conforming data to guarantee dimensional uniformity across several different sources.
- Creating and scheduling SQL Server Agent jobs that would perform a variety of tasks such as initiating SSIS packages, killing unauthorized user sessions during overnight load-time hours, re-indexing database entities, as well as other SQL Server Maintenance tasks.
- Designing logical and physical data models detailing desired logical attributes and entities as well as documenting their relationships within enterprise-wide standards.
- Designing dimensional star schema providing a set of centralized fact tables with relationships to descriptive dimension tables using ER/Win.
- Designing fully-normalized (3NF) physical transactional data models determining attribute data types, entity relationships, primary and foreign keys, indexing strategies, unique and default constraints, and more using ER/Win.
- Actualizing data models into SQL Server data stores using forward engineering functionality within ER/Win.
- Creating and maintaining process flows, data/metadata dictionaries and entity-relationship diagrams which were then stored in centralized repository.
- Work with business user customer base to gather requirements, analyze business rules, and guide the business community through the identification and resolution of existing data reporting gaps.
- Working with business community to identify and define data attributes and entities to be added to IAM Data Mart.
- Determining data architecture processes including type of data store to be developed, data sourcing, mapping and corresponding load process, use of data staging, job scheduling, data security and access providing an organized framework in which to develop.
- Leading data model design reviews guiding participants to an understanding of data definitions, data relationships, and overall architectural structure.
- Ability to identify items for potential improvement or optimization.
- Responsible for guiding customers with regards to data policies such as security, levels of access, and enterprise-wide data standards.
- Responsible for mentoring junior team members assisting their ongoing development with the data warehousing space as well as performing new-hire on-boarding tasks.
- Seamless management of multiple, simultaneous project workflows and timelines with minimal supervision.
Confidential - Richmond, VA
Database Administrator Advisor Senior
Responsibilities:
- Daily SQL Server administration responsibilities including creating and administering file groups, regulating database growth and shrinking, performing backups and restores (LiteSpeed and SQL Server), monitoring database and CPU usage, adding database users and roles, creating and managing SQL Server Agent jobs, job scheduling, alerts, and messaging, monitoring processes and resolving database blocking issues, testing database server clustering and failover.
- Daily creation and optimization of T-SQL queries within MS SQL Server 2000, 2005, and 2008 while employing a variety of methods to optimize SQL, including: examining and adjusting query execution plans, designing a sensible, aggressive indexing strategy, manufacturing free-standing aggregate tables where applicable, joining to nested data subsets versus entire tables, and eliminating nested view architecture.
- Daily creation and maintenance of database objects such as tables, views, stored procedures, triggers, indexes, constraints, and primary and foreign keys.
- Use of SQL Server Profiler to identify, trace and resolve query and database object performance issues.
- Developed SSIS packages to extract and cleanse data from several source systems then load into the automated dialer system.
- Responsible for creating and maintaining SQL Server Reporting Services (SSRS) reports to meet end-user data requirements and specifications.
- Responsible for planning and build-out of SQL Server database clusters. Activities include determining disk requirements for new instances based upon existing database and estimated growth factor and recommending sizing SAN accordingly, configuring and testing failover clusters, performing impact analysis to determine potential effects on existing applications and working to mitigate those effects.
Confidential - Richmond, VA
Senior Database Consultant
Responsibilities:
- Created complete data warehouse systems by gathering user data requirements, developing logical and physical data models in dimensional schema (ERwin), instantiating the physical data model in SQL Server 2008, developing and fine-tuning ETL processes (SSIS), creating a presentation layer to power a suite of end-user reports, and developed those reports in Business Objects and Hyperion Brio.
- Daily creation and optimization of T-SQL and PL/SQL queries within MS SQL Server, Oracle, and Teradata while employing a variety of methods to optimize SQL, including: examining and adjusting query execution plans, designing a sensible, aggressive indexing strategy, manufacturing free-standing aggregate tables where applicable, joining to nested data subsets versus entire tables, and eliminating nested view architecture.
- Daily SQL Server administration responsibilities included monitoring database usage, adding database users and roles, creating and managing SQL Server Agent jobs, job scheduling, alerts, and messaging, monitoring processes and resolving database blocking issues.
- Daily creation and maintenance of database objects such as tables, views, stored procedures, triggers, indexes, constraints, and primary and foreign keys.
- Creating and maintaining large-scale Business Intelligence dashboard reporting solutions and environments in Hyperion Brio, Business Objects, and Oracle Enterprise Reporting. Reporting models typically utilize server-side views and manufactured tables versus creating client-side schemas thereby leveraging database processing power, allowing easier query maintenance whereby a change to a single view or manufactured table can cascade across reports while creating a reusable code base that is easily ported across reports as well as different front-end reporting tools.
- Responsible for defining, designing, and developing incoming and outgoing data access flows using SQL Server Integration Services (SSIS) - including mapping source data to destination targets and conforming data to guarantee dimensional uniformity across several different sources.
- Creating and scheduling SQL Server Agent jobs that would perform a variety of tasks such as initiating SSIS packages, killing unauthorized user sessions during overnight load-time hours, re-indexing database entities, as well as other SQL Server Maintenance tasks.
- Designing logical and physical data models detailing desired logical attributes and entities as well as documenting their relationships within enterprise-wide standards.
- Designing dimensional star schema providing a set of centralized fact tables with relationships to descriptive dimension tables using ER/Win.
- Designing fully-normalized (3NF) physical transactional data models determining attribute data types, entity relationships, primary and foreign keys, indexing strategies, unique and default constraints, and more using ER/Win.
- Actualizing data models into SQL Server data stores using forward engineering functionality within ER/Win.
- Creating and maintaining process flows, data/metadata dictionaries and entity-relationship diagrams which were then stored in centralized repository.
- Work with business user customer base to gather requirements, analyze business rules, and guide the business community through the identification and resolution of existing data reporting gaps.
- Working with business community to identify and define data attributes and entities to be added to IAM Data Mart.
- Determining data architecture processes including type of data store to be developed, data sourcing, mapping and corresponding load process, use of data staging, job scheduling, data security and access providing an organized framework in which to develop.
- Leading data model design reviews guiding participants to an understanding of data definitions, data relationships, and overall architectural structure.
- Ability to identify items for potential improvement or optimization.
- Responsible for guiding customers with regards to data policies such as security, levels of access, and enterprise-wide data standards.
- Responsible for mentoring junior team members assisting their ongoing development with the data warehousing space as well as performing new-hire on-boarding tasks.
- Seamless management of multiple, simultaneous project workflows and timelines with minimal supervision.
Confidential - Glen Allen, VA
Senior Database Analyst
Responsibilities:
- Daily creation and optimization of T-SQL and PL/SQL queries within MS SQL Server, Oracle, and Teradata while employing a variety of methods to optimize SQL, including: examining and adjusting query execution plans, designing a sensible, aggressive indexing strategy, manufacturing free-standing aggregate tables where applicable, joining to nested data subsets versus entire tables, and eliminating nested view architecture.
- Daily SQL Server administration responsibilities included installing SQL Server 2005 software, service packs, and hot fixes, creating and administering file groups, regulating database growth and shrinking, and performing backups and restores, monitoring database usage, adding database users and roles, creating and managing SQL Server Agent jobs, job scheduling, alerts, and messaging, monitoring processes and resolving database blocking issues, creating all varieties of database objects including tables, views, stored procedures, indexes, triggers, constraints and keys, as well as mentoring junior-level database analysts.
- Worked closely with external customer base to identify necessary data attributes organized into logical data models to meet customer needs.
- Created SSRS reports for end-user data delivery within accepted company publishing guidelines and deployed reports to dedicated SQL Server Report Server.
- Determined data architecture processes including type of data store to be developed, data sourcing and corresponding load process, use of staging, system availability, job scheduling, data security and access to provide an organizing framework from which to design.
- Designed physical data models to define transactional (3NF) and analytical (star schema) data stores in SQL Server.
- Responsible for defining, designing, and developing incoming and outgoing data access flows using SSIS/DTS - including mapping source data to destination targets and conforming data guaranteeing dimension uniformity across several different sources.
- Designed fully-normalized (3NF) physical data models determining attribute data types, primary and foreign keys, entity relationships, indexing strategies, and unique and default constraints using Erwin.
- Designed dimensional star schema providing a set of centralized fact tables with relationships to descriptive dimension tables thereby providing efficient and alacritous access to analytical data.
- Created and maintained metadata dictionaries and entity-relationship diagrams stored in centralized repository.
- Responsible for guiding customers with regards to data policies such as security, levels of access, as well as data retention.