I have possesses over 18 years experience in the Information Technology industry. His strengths include data base technologies, data warehousing, master data management, business intelligence solutions and Project Management. He excels in all phases of the systems development lifecycle from gathering requirements and solutions design through deployment and post-deployment operational support procedures. In complementing his architecture and industry knowledge, Confidential’s strong business background enables him to understand, deliver, and deploy high-quality, optimized, and robust systems that allow businesses to store and retrieve information easily and effectively. Technical leadership and managerial experience have prepared Confidential to lead others as well as participate as a team member with a keen appreciation for schedules, budgets, and deliverables.

Methodologies:Dimensional Database Modeling • Entity Relationship Modeling • Physical Database Design • Standard Lifecycle Methodologies • PMP Waterfall and Agile Methodologies • Client Server/N-Tier

Technologies: 

Databases: SQL Server 7/2000/2005/2008 • Oracle 7/8/10g • Teradata 7/12 • MySQL 5/6 • DB2

Design Tools: ERwin Data Modeler • Embarcadero ERStudio • TOAD • Visual Studio • Visio

Development Tools: Oracle Warehouse Builder • Teradata SQL Assist • Business Objects XR2 • Visual Studio 2005/2008/2010 • Toad • Talend Open Source • SQL Server DTS and SSIS

Reporting Tools: Business Objects • Crystal Reports • SQL Server Reporting Services • Knosys ProClarity Analytical platform • Active Reports Pro • Tableau

Languages: PLSQL • SQL • Visual Basic4/5/6 • Visual Basic.NET • C#.Net

Functional Areas:E-Commerce • Finance • Inventory Management Systems • Medical • Pharmaceutical • Mobile Communications • Sales • Marketing • Manufacturing

Industries:Medical • Pharmaceutical • Aerospace • Financial/Banking • Insurance • Automotive/Truck • Mobile Communications • Web 2.0 • Social Media • Retail • Lumber

Education B.A. • Finance and Accounting • Confidential University,

Certification:Project Management Professional (PMP) Certification

Confidential 2010 to current

Position: Solution Architect/ Technical Project Manager (Sr. Consultant)

Confidential performed a detailed analysis of the company’s enterprise architecture. The analysis encompassed the technical aspects of the architecture and the software development lifecycle.Numerous business units were also interviewed to determine how their business processes were shaped by the current architecture and how their needs could better be met.

The findings were presented to senior management along with recommendations for changes to the architecture. The recommendations included the establishment of a Master Data Management repository to consolidate disparate data stores and a Service Oriented Architecture to alleviate point-to-point interfaces.

Confidential was responsible for the designed and implemented of the Master Data Management Architecture which used SQL Server 2008 R2, SSIS and the asynchronous nature of Service Broker for near real time processing. The MDM system integrates with disparate LifePRO Policy Management Systems as well as other information systems needed to satisfy the businesses processing needs. The MDM system consolidates Agent and Agent Policy information which eliminates the companies need for duplicate data entry and also provides a single source of information for reporting needs. Using Agile methodologies, Confidential was also responsible for the coordination and management of the development team’s deliverables and the technical integration with the architect of the Biztalk ESB middleware layer. Confidential was responsible for the coordination and creation of QA test methods and policies.

Confidential was the joint Technical Lead teamed up with an internal GAFRI resource on the Secure Agent Web project. The Secure agent Web Project incorporated .Net 4 web services, SQL Server 2008 R2 and SharePoint 2007. Responsibilities include the integration of SQL Server 2008 Service Broker for near real time processing of disparate data sources which include the LifePRO Agency and Policy Management System, Not in Good Order database repository and the consolidated GAFRI SEEK ODS reporting system. Other duties included the mentoring of GAFRI internal resources and the coordination of ongoing projects such as Agent on boarding and Agent Training which integrates and leverages the previously architected Agent MDM foundation developed and Architected by Confidential.

Confidential 2008 - 2010

Position: Business Intelligence Architect/ Business Objects Team Lead (Sr. Consultant)

NetRX is an Integrated Pharmacy Benefits Management data mart consisting of both Anthem and WellPoint pharmacy benefit/claims data. The Enterprise NetRX Reporting System provides the delivery of internal and external reports, ad-hoc reporting, and dashboard functionality, to their Pharmaceuticals division customers. NetRX uses Business Object XI R2, Crystal Reports and Teradata. The charter was to supply 52 customer reports. The current architecture could not support the 20 largest reports.

Primary responsibilities included:

• Analyze the existing Business Objects XI reporting system from the Teradata data model through the Business Objects Universe and Crystal Reports. Find and recommend performance modifications to the existing architecture. The changes implemented based on our analysis enabled all 52 reports to run. The average increase in performance of the reports was above 40% and closer to 65% for the larger reports. Architectural changes included data modeling enhancements, proper indexing, creation of pre-aggregation tables and performance modification centered around the implementation of row level security.
• Maintain Business Objects delivery schedule within Microsoft Project.
• Coordinate deliverables and maintain project documentation through SharePoint Server 2007
• Responsible for unit testing and test case creation and coordination with QA.
• Responsible for the management and mentoring of the Business Objects development team. This team was responsible for the creation of all DDL scripts related to the Security/reporting performance enhancements as well as the creation and modification of the Business Objects Universe and associated Crystal Reports.
• Responsible for the communication and coordination of reporting deliverables with the dependant cross functional teams, which included the internal Business development group, DBA’s and QA teams.
• Other tasks included coordination with cross functional teams and the prioritization of reporting defects and enhancements.

Confidential 2008 (4 MONTH ASSESSMENT)

Position: Technical Project Manager/Business Intelligence Analyst (Sr. Consultant)

Co-authored a BI capabilities assessment for a Web 2.0 startup company focused on facilitation content sharing across the internet. The assessment laid out the roadmap for establishing a robust and flexible enterprise business intelligence architecture to meet the changing needs of the business as they grow. This also included setting the project work plan, estimating resource needs, and maintaining the project schedule for the development of the “first phase” BI solution for the client to meet their current critical reporting and analysis needs.

Primary responsibilities included:

• Assess the current Sharethis architecture and business systems and lay out a roadmap for establishing a robust and flexible BI solution. This encompassed analysis of the current Sharethis OLTP database system, Web Log’s, Widget Click Stream data and base output reports.
• Create the project work plan and maintain the project schedule in Microsoft Project. This included keeping track of project milestones.
• Development of “first phase” BI solution for the client to meet their current critical reporting and analysis needs.
• Creation of Data Warehouse Dimensional models in Oracle 11g in support of the clients Customer and financial reporting needs. This included creation of Views, Stored Procedures, Triggers and Functions related to the Staging and Data Warehouse database systems.
• Creation of all (ETL) processes using Talend Open Studio to feed the newly created Data Warehouse with data from the 3 disparate Sharethis data sources. Data sources included Customer Web Site log information extracted from Google Analytics in XML format, Widget share and click through data logs extracted from Amazon’s Simple DB (1 Million records hour) and Customer/Publisher registration information from the Sharethis MySQL OLTP database.

Confidential 2005 - 2008

Position: Database Manager/Architect

Led a team of engineers and business analysts to re-design the SQL Server 2005 transactional (OLTP) database and deliver a new Data Warehouse solution using SQL Server Analysis Services (SSAS) for a large lumber trading company. The Lowgrade Lumber (OLTP) database structure supports the internet based order and inventory trading platform. This included the separation and migration of all reporting functions from the Order Inventory transactional database over to the newly created Data Warehouse database. The separation of the databases relieved the transactional system from the Burdon of large running queries and help increase the applications scalability.

Primary responsibilities included:

• Architectural design and development of the OLTP and Data Warehouse Logical/Physical database Schema’s and data dictionary documentation.
• Responsible for database management functions such as database backup/restore procedures and database tuning/optimization processes.
• Responsible for efficiency and development of Database Schemas, Stored Procedures, Triggers and Functions.
• Responsible for database upgrades: Database upgrades from SQL Server 2000 to SQL Server 2005 and associated conversion of (ETL) DTS packages to SSIS.
• Architectural design and development of the Extraction, Transformation and Loading (ETL) system using SSIS 2005. This process feeds our Business Intelligence reporting database.
• Responsible for information gathering and (ETL) migration process of data from and to our corporate accounting system using SSIS 2005.
• Converted all financial and inventory reports from Active Report to SSRS. Also responsible for the design and development of additional reports using SQL Server Reporting Services.

Confidential. 2001 - 2005

Position: Project Manager (Strong Matrix Organization)

Q-Tel Rehabilitation Management System is a shrink rapped application. A-Tel RMS is a class 3 rehabilitation medical data entry and ECG monitoring system. Q-Tel RMS uses a SQL Server 2000 backend with a Visual Basic front end. All critical ECG and real-time Hart monitoring code is written in C and C++. The Q-Tel RMS server base system is built on a Windows XP computer platform and ECG Patient monitoring devices were vendor created firmware.

Primary responsibilities included:

• Personnel budgeting and costs responsibilities related to Q-Tel RMS. This included developer reviews and salary recommendation, and projecting project staffing requirements.
• Set Project work plan, estimates and milestones using Agile methodologies.
• Create and maintain Project schedules in Microsoft project.
• Staff Management of C++, VB, DBA and XML/ASP developers.
• Coordination of development enhancements and prioritization with Sales and Marketing Product Managers.
• Evaluation of external vendors as it related to the Q-Tel RMS application.
• Work with Customer Service Managers to provide routine procedures for product trouble shooting and enhanced development support when needed.
• Work with Quality Assurance Managers to coordinate development schedules, incorporate integrated QA, enhance procedures and set expectations.
• Visit client sites to ensure product satisfaction and obtain customer feedback for future product enhancements.
• Research new technologies for product improvements and lower cost of goods.

Position: Software Manager: Database and Business Objects

Primary responsibilities included:

• High level design overview and management of the database and middle tier Business Objects teams.
• Database design and architecture. This included the design, creation, coordination and optimization of:
• Database Schemas in Erwin.
• Stored Procedure, Trigger and Function creation and maintenance.
• Responsible for the accuracy of data being imported into and exported out of the database structures. This was accomplished through SQL Server SSIS and included data scrubbing, transformation and XML formatting. Import feeds were in XML and HL7 formats.

Confidential. 2000 - 2001

Position: Engineering Manager /Business Intelligence Analyst (Consultant)

The Wavelink.Net product incorporated customer and product account information as well as online internet software licensing and distribution. The Wavelink.Net project was designed to consolidate Wavelink’s disparate information systems into a centralized data repository for reporting and management purposes.

Primary responsibilities included:

• Management of Sr. Wavelink.Net development staff, which includes skills in C++, SQL Server technologies, ASP/HTML and Visual Basic web technologies.
• Architectural design and development of the OLTP Logical/Physical database Schema’s and data dictionary documentation. Design and documentation tool used is Embarcadero’s SQL Designer.
• Architectural design and development of the Extraction, Transformation and Loading (ETL) system using SQL Server DTS packages. This hourly update job transfers the Wavlink.Net transactional database data into the staging database for data scrubbing and then transferred into the Data Warehouse system.
• Architectural design and development of the Sales, Finance and Support/Knowledgebase OLAP Schema’s. This involved analyzing existing corporate information and reporting needs in order to assess the proper granularity levels of information. In addition it provided information necessary for the design and development of the dimension and fact table measures.
• Analysis, selection, and implementation of OLAP front end reporting tool (Knosys ProClarity Analytical Platform 4.0) and Sharepoint through SQL Server.
• Responsible for information gathering and (ETL) migration process of data from desperate legacy data systems into the new central corporate database structure of Wavelink.Net.

Confidential 1998 - 2000

Position: Director Software Development

Web3000.com is an internet advertizing/Ad Networking product that attaches to an end users browser. The product serves up internet banner and popup advertisements. The Web3000 product also provides internet browser acceleration to the end users browser. The product manages customer account and Advertising campaign information. This information is stored in the customer management SQL Server 7 database system. Other transactional log information pertaining to number of Ad’s served and click through information is logged real-time and imported into the SQL Server 7 database through DTS packages. Nightly DTS packages aggregate and scrub the Ad and click through detail information into the Web3000 Data Warehouse reporting system.

Primary responsibilities included:

• Personnel budgeting and costs responsibilities related to Web3000 product development staff. This included developer reviews and salary recommendation, and projecting product development staffing requirements.
• Management of an 18 person development staff consisting of Project Management, C++, Database, ASP and Visual Basic development groups.
• Work with Quality Assurance Managers to coordinate development schedules, procedures and software quality expectations.
• Cross functional communication and coordination with the Sales, Marketing and QA departments.
• Setting the structure and vision for current and future architectural product designs.
• Create procedures in order to organized and manage the process to efficiently accept new product enhancement requests from the business units. This process then prioritized, scheduled and managed the workflow to complete these tasks via the various development units.

Position: Sr. Database Architect (DBA) /Internet Application Group Manager

Primary responsibilities included:

• Managed the database architecture/analyst team, ASP internet and Visual Basic developer teams.
• Creation of database schema’s, Stored Procedures, and Triggers.
• Creation and maintenance of the OLTP and OLAP SQL Server 7 database systems. This included the separation of the legacy database structure into distinct reporting and transactional databases. The OLTP database was designed and optimized for high transactional throughput and scalability. It currently handles 1.5 million transactions a day and 24 million advertising impression transactions daily.
• Design and development of all DTS packages for the purposes of importing and scrubbing advertizing and click through data into the OLTP system.
• Design and development of DTS packages for the purpose of aggregating transactional information through the staging database into the dimensional Data Warehouse reporting database.
• Creation and design of tabular Crystal Reports and Knosys Proclarity Dimensional reporting analysis system.
• Creation and maintenance of Backup, Restore and database tuning routines.

Confidential 1997 - 1998

Position: BI System Architect (Principle Consultant)

Design and implementation of warehouse (Data Mart) project which entailed extracting data using Data Transformation Services (DTS) from two independent Oracle Manufacturing accounting databases. This included importing and massaging the data into a SQL Server 7 Dimensional Data Mart. Project also included the design and development of Intranet reporting and analysis program.

Primary responsibilities included:

• Design and creation of Staging and Dimensional database structures.
• Creation of scheduled extracts from the companies Oracle accounting databases into CSV format.
• Design and development of DTS routines to import CSV files into SQL Server Staging database. This included aggregation of data and DTS routines to load the Dimensional Data Mart database system.
• Design and development of ASP DHTML front end intranet GUI application using Visual Basic COM objects for the Business Rules and data access layer with Data Dynamics Dynacube as the front end report presentation tool.

Confidential 1996 - 1997

Position: Lead Developer (Sr. Consultant)

Analysis and re-design the DCAC/MRM (Define and Control Aircraft Configuration/Manufacturing Resource Management) product. DCAC/MRM (Configurator) helps Boeing configuration engineers more accurately and efficiently configures the new airplanes operators purchase from Boeing. The Configurator reduces the complexity and length of defining the airplane configuration. The Configurator is designed to reduce the flow time to order an airplane including eliminating manual searches for information about airplane options. Configurator enables rapid analysis of all operator-ordered changes to ensure technical compatibility and completeness. The application allows the users to use Visio as the presentation layer to create workflow documents that contain many dependent workflow objects on them. This information is then dynamically stored in the SQL Server database. When a user calls up a Configurator document it then retrieves that information from SQL Server and re-populates the Visio diagram, subsequently all changes to the document are then saved and written back to the database.

Primary responsibilities included:

• Analyze and re-design a prototype Access 7.0 application to a production quality SQL Server 6.5, Visual Basic 5.0 and Visio application.
• Developed Stored Procedures, Views and Triggers in support of the Configurator Application.
• Design and development of middle tier data access layer through the use of Visual Basic 5.0 COM objects and ADO 2.0 as the Data Access layer.
• Development of routines to coordinate inflow and outflow of information from Visual Basic to Visio through OLE automation. These routines and Business Rules are the keys to the automation of document creation, maintenance and change management.
• Coordination of application enhancements and deliverables to the development team.