SKILLS:

Database Architecture / Development

• RDBMS logical and physical modeling, design, data migration, T-SQL and PL/SQL generation, ER/Studio v4.0 v7.1, DBArtisan, ERwin v4.0 r7.1, TOAD v11.6
• SQL Server v6.5 v2012: OLTP and OLAP database design, modeling, warehousing, development, administration, tuning T-SQL stored procedures, triggers, SSIS, DTS packages, BCP scripts, SQL-DMO OLAP Services, SSRS
• Oracle 7-11g Vertica 6.1: OLAP OLTP database design, modeling, warehousing
• ETL development with Informatica PowerCenter v6 7, DTS, SSIS, Data Junction

Software Development Methodologies

• Agile: Scrum, Kanban, Feature Driven, RUP, XP Iterative, Waterfall, Code Fix
• Corporate wiki, Trac, and Subversion SDLC management tools, in house hosted

Ancillary

• Siebel Analytics Data Warehouse Dashboard Development v7.7 on Oracle 9i
• Informix On-Line v5.0 on Sun OS v4.1.3, Teradata V2R6.1, Access v2 2007
• FoxPro v2.5 6.0, Oracle Financials, Crystal Reports, SBT, CYMA

WORK EXPERIENCE:

Confidential

Data Architect

• Lead architecture and design of company data processing, warehouse and analytics initiatives
• Responsible for design, planning, execution, monitoring, and improvement of data processing and analytics, including the tool selection, processes and approach, management, scheduling, and infrastructure
• Responsible for defining standards, governance and metadata management of data assets
• Responsible for the architecture of data warehouse, including modeling, data extract and load processes, optimization, and change management
• Collaborate with product management, operations, sales, customers, and external partners to understand target market segments and business use cases
• Design, document, and evangelize architecture standards and policies which enables business agility through the sharing of data sets software intellectual property
• Create white papers, technical documentation, wiki entries, and make presentations to colleagues throughout company. Promote the leverage and reuse of proprietary technologies and architectural frameworks

Confidential

Senior Associate

• Developed strategic plan with newly formed central team to support and facilitate global management consulting projects, applying analytics for sales forecasting, vendor negotiations, pricing, and other planning requirements.
• Introduced reusable software frameworks, leveraging best practices and iterative methods for rapid implementation on new and existing projects. Dynamic DDL, Power Shell scripts, Bulk Insert, and custom C .NET Extended Stored Procedures on SQL Server formed the basis of this approach, essentially augmenting and replacing some of the complexities and drawbacks of SSIS.
• Developed algorithms to efficiently analyze terabytes of data and produce workable concentration curves and other trend and pattern metrics.
• Mentored analysts, applied modified Agile methods using hosted wiki and Trac.
• Customers included the largest retail chains in North America, Europe, and global players including WalMart. The datasets typically ran into the 100s of millions to billions of records and 100s of terabytes in size.

Confidential

Data Architect

• Design Airline Reservation Departure Control System OLTP OLAP databases.
• Work with application development team leads to design new tables, views, keys, indexes, and constraints to support new or revised functionality.
• Write PL/SQL DDL DML SPs Triggers in support of Application Development.
• Work with application developers to translate complex business logic into structured query language through in-line PL/SQL, stored procedures, and triggers where appropriate.
• Manage Oracle 11g database models using ERwin v7.1.2.
• Managed all database design initiatives and changes through ERwin data modeling tool and repository.
• Changes originated in the model and were driven forward through ERwin's DDL generation features.
• Strict adherence to Agile Scrum process using in house wiki, Trac, Subversion
• Support internal SQL Servers 2005 2008 for project management department.

Confidential

Healthcare Data Analyst

• Enterprise Logical and Physical Data Modeling for Healthcare Integration project.
• Worked with data modeling team to maintain and improve the enterprise data model by translating analysis discoveries into model elements.
• Platforms include Oracle, Teradata, SQL Server, AMISYS, and Oracle Financials.
• Work with Business Analysts to Map Gap Data Warehouse and ODS processes, objects, and data to Oracle Financials and the Enterprise Logical Data Model.
• Reverse engineered data warehouse and ODS processes by analyzing legacy stored procedures and triggers.
• These processes were then used to map the data structures from the data warehouse and ODS to the Oracle financials data structures.
• Gap analysis was then preformed to track unsustainable data structures.
• Finally, these newly documented processes and data structures were translated into the enterprise data model.
• Model Financial Integration Gateway database including transient, persistent, code set reference, drill back, reporting, view, audit, control, and error schemas.
• Data was moved from the data warehouse and ODS systems to the Oracle financials system through an interim data structure, the financial integration gateway.
• The financial integration gateway was designed to facilitate data conversion and cleansing and to maintain data integrity.

Confidential

Data Warehouse Consultant

• Design Develop SQL Server 2005 Tax Data Mart for H R Block partners.
• Met with stakeholders to define requirements for a tax data mart to support the integration, aggregation, BI reporting etc. of data from multiple H R Block supported tax packages for partner groups.
• Performed all phases of design, development, testing, implementation, and on-site training of the tax data mart.
• Produced data models using ERwin data modeling tool.
• Wrote mapping documents for each source system to the data mart.
• Developed ETL in both SQL Server 2000 DTS packages and SQL Server 2005 SSIS packages to support multiple customer platforms.
• Wrote stored procedures to support business intelligence reporting.
• Implemented tax data mart system at customers' locations.
• Trained database support personnel and provided ongoing support.

Confidential

• Define Methodology and Processes for OLTP and OLAP Database Design.
• Defined approach to design by analyzing data patterns and access algorithms and frequency to drive design decisions.
• Evaluate Databases and Data Warehouse for Performance and Scalability.
• Using methodology, analyzed existing data warehouse for performance bottlenecks.
• Improved OLAP design to support existing reporting requirements.

Confidential

• Define Standards, Methodology and Processes for OLTP Database Design and Development and integrate with Quality Assurance Processes.
• Defined approach to design by analyzing data patterns and access algorithms and frequency to drive design decisions. Integrated with QA to validate performance metrics.
• Evaluate databases for Performance and Scalability Define Tuning process.
• Using methodology, analyzed existing data warehouse for performance bottlenecks.
• Educate and institute database best practices using ER Studio and DB Artisan.

Confidential

• Administer SQL Servers during peak tax season for independent clearinghouse.
• Resolve resource blocking and deadlocks in Production OLTP SQL Servers.
• Reduced daily batch processing time from over 24 to fewer than 8 hours.
• Educate and institute best practices for OLTP and Data Modeling.
• Plan migration from SQL Server 2000 to SQL Server 2005.

Confidential

Project Manager

• Manage unified reporting project team of 5 through definition phase of SDLC. Lead weekly meetings w/ VPs Marketing Product Managers. Develop Project Plan.
• Produced Requirements, Functional, Architectural, Traceability specifications.
• Map Gap Analysis of data from multiple relational and hierarchical platforms.
• Developed a Virtual Data Layer across product lines for use with Composite EII.
• Investigated and recommended road map for future integration technologies.
• Conducted on-site prototype demonstrations of appropriate technologies from leading BI, ETL, EII, Reporting vendors including Cognos, Business Objects, Crystal Reports, Informatica, Composite, Avaki MetaMatrix.