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
• SQL Server v6.5 – v2008: 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, 8i ,9i, 10g, 11g: 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

CERTIFICATION

• Microsoft Certified Professional:

System Administration for Microsoft SQL Server
Implementing a Database design on Microsoft SQL Server

• Siebel Analytics Data Warehouse Developer v7.7
• Informatica PowerCenter v6 and v7 certificates
• Informix-OnLine Certified Database & System Administrator v5.0
• Embarcadero ER/Studio v4.0 certificate
• StarTeam SDLC Revision Control certificate
• Object Oriented programming with MS Visual C++ v6.0 certificate
• ATL v3.0 COM development with MS Visual C++ v6.0 certificate
• Access v2.0 development certificates

WORK EXPERIENCE

Senior Associate
2010 - 2012
Confidential,
Boston, Massachusetts

• 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++ 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.

Data Architect
2007 - 2010
Confidential,
Cambridge, Massachusetts

• 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.

Healthcare Data Analyst
2007
Confidential,
Wellesley, Massachusetts

• 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.

Data Warehouse Consultant
2005 – 2007

Confidential,
Chicago, Illinois

• 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,
Boston, Massachusetts

• 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,
Caguas, Puerto Rico

• 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,
Bellevue, Washington

• 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.

Project Manager
2005
Confidential,
Portland, Oregon

• 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.

Data Architect Lead
2004 – 2005
Confidential,
Aguadilla, Puerto Rico

• Lead teams of 7 to 10 DBAs, Developers, SMEs, & Mathematicians to source & integrate global data for Discovery phase of Data Mining projects.
• Development of BI reporting using Business Objects & Siebel Analytics platforms.
• Development of Siebel Analytics repository to support reporting & marketing segmentation needs.
• Development of Informatica repository for data transformation & warehousing.
• Development of reports for distribution on dashboards.
• Proactively and iteratively looking for performance improvements.
• Development of ETL scripts in Informatica PowerCenter, TSQL, & PL/SQL.
• Build OLAP Data Marts to transition projects from Discovery to Production.
• Work with Data Warehouse team to integrate new data and populate Data Marts.
• Development of SPs & scripts on SQL Server 2000 (16 TB) & Oracle 9i.

Database Architect Lead
2003
Confidential,
Wilsonville, Oregon

• Lead team of 3 data architects to design and model SQL Server OLTP databases for video store retail system using ER/Studio v 5.5 & Repository.
• Lead team of 5 (3 offshore) to develop data migration ETL scripts in Data Junction v 7.5.5, stored procedures, triggers & scripts on SQL Server 2000 & Oracle 8.1.7.
• Develop applications using MS Access 97.

Data Warehouse Project Manager
2001 – 2002
Confidential,
Beaverton, Oregon

• Lead team of 6 developers to upgrade Data Warehouse from AMISYS to Facets.
• Applied iterative and incremental development process, mentored team members.
• Developed Project Plan and executed to meet all milestones and final completion.
• Recruit project team members and conduct interviews and quarterly reviews.
• Conducted bi-weekly code reviews and weekly team integration reviews.
• Develop procedures & standards documents for T-SQL, DTS, and linked servers.
• Prepare data migration map & gap, validation, design, and unit test documents.
• Automate the validation of data migration processes; initial load and incremental.
• Develop T-SQL SPs, Triggers, DTS, and BCP scripts for data import and validation.
• Design and implement Audit process for on-going validation of data transfer.
• Part-time consulting, while working full-time at Intel, included Breast Cancer, Portability and Lung Cancer research. This work received accolades: "best data they have ever received from a health plan or a hospital" from a meeting of Oncologists.

Database Architect Lead
2001 – 2002
Confidential,
Hillsboro, Oregon

• Co-lead project teams of 3 to 12 developers; conducted design and code reviews.
• Administer MS SQL server v 7.0, 2000, Oracle9i: monitor and tune performance, backup and restore, job scheduling, replication, link Oracle and SQL Servers.
• Design OLTP databases for main customer site using ERwin v 4.0 & ER/Studio.
• Develop T-SQL & PL/SQL stored procedures, and triggers for all projects.
• Replaced complex reporting with SQL Server Job scheduling of DTS Packages running T-SQL stored procedures and exporting to Excel spreadsheets.

Database Architect Lead
1999 - 2001
StatiaFX Portland, Oregon

• Lead team of 3 DBAs to conduct stored procedure code reviews for 25 developers.
• Followed Agile process with modified Scrum, Feature Driven, & RUP elements.
• Administer MS SQL server v 7.0, 2000 on Windows 2000; performance tuning, backup & restore; replication; develop DTS packages and BCP scripts.
• Design OLTP databases for e-Finance / e-Business portal using ER/Studio v 4.0.
• Design & implement custom T-SQL based replication for content distribution.
• Develop business layer ATL COM objects in MS Visual C++ v 6.0.
• Automate build process using VB, WSH & VB scripts, SQL-DMF and StarTeam.
• Develop web based reports using Crystal Reports & custom graphing solutions.
• Manage contracts with stock exchanges including NYSE, NASDAQ & AMEX.
• Assist with financial data feed contracts from S&P Comstock, Media General, CSI, BestCalls, EDGAR Online and others.

Database Developer
1997 - 1999
Telegroup, Inc. Fairfield, Iowa

• Import and convert external relational & ISAM data sources to development and production OLTP databases on Oracle v 7.x Solaris using Data Junction & PL/SQL.
• Maintain and upgrade SBT Pro Series Accounting modules, add multi-currency support and automation with external ACH and Credit Card processing entities.
• Integrate MS FoxPro v 2.6 accounting data with customer support website.
• Develop ad-hoc reports using Visual FoxPro v 5.0, PL/SQL & Crystal Reports.

Manager - Product Development & Support
1994 - 1997
Medibill Systems, Inc. Beaverton, Oregon

• Manage customer support department. Built team from 3 to 15 claim specialists. Conduct performance and salary reviews. Implemented Kanban pull techniques using Help Star software and whiteboards to reduce stress and increase efficiency.
• Lead team of 4 developers to design and develop Medical and Dental electronic claims Clearinghouse and Practice Management software. Implemented extreme programming techniques to get clearinghouse up and running, generating income in 3 months with 2 programmers.

Other, non-product related projects included:

• Map & gap analysis of business requirements, model OLTP & OLAP databases, and implement on various database platforms including Informix-on-line v5.0 (Sun OS v4.1.3 & DOS), SQL server v 6.5 (Windows NT v 4.0), and FoxPro.
• Migrate data among SQL server, Visual FoxPro, Informix-on-line server, Access, and hierarchical & ISAM mainframe data using T-SQL & Data Junction ETL tools.

Sr. Systems Analyst
1990 - 1994
NASA - Jet Propulsion Laboratory Pasadena, California

• Lead team of 6 developers to design, implement, and maintain OLTP applications to support High Reliability Electronic Parts section using C++ & btrieve.
• Author software development procedures & standards, conduct code reviews.
• Interface directly with end users and management to identify and define business processes and map & gap data requirements across multiple departments.
• Create custom Data Warehouse and tools to mine electronic parts data at the Project (e.g. Voyager), Subsystem, Assembly, List and Detail Parts levels.
• Eliminated need for IBM mini-computer and support staff by replicating applications’ function, look & feel on existing LAN & converting ISAM data to relational database.

Other relevant projects

• Consulting on Methodology and Process for Database design and development.
• Taught Local Area Network classes at the community college level.
• Offered faculty position, University of Phoenix.

EDUCATION

Airman Certificate - Private Pilot License
PCC - Hillsboro Airport, Hillsboro, Oregon

Business Administration
Concordia University, Portland, Oregon

Electrical Engineering / Computer Science
Massachusetts Institute of Technology, Cambridge, Massachusetts