North Rose NY, 14516
Earned a Masters of Business Administration with Technical Management, MBA/TM in 2006 from the University Of Phoenix.
Certified as MCDBA. MCSD, and MCAD (“Charter Member”, one of the first 5,000 VB.Net developers to obtain certification globally)
Senior Developer / Microsoft Technology Specialist Database modeling, designing & developing SQL Server 2017, 2014, 2012, 2008 R2, 2005 and 2000 database tables, stored procedures, functions, views and triggers, data warehousing, Data Mart, extensive use of SSIS, DTS, and ETL, data migration, Publish and Subscribe strategies, “Brokerage” of data from heterogeneous data sources and downstream delivery. Utilization and development of SQL Server Reporting Services (SSRS) reports. SQL Server Analysis Services (SSAS) data cube development for use within BI environments.
Eighteen (18) years of experience using client/server, n-tier and web technologies developing applications using both Microsoft and non-Microsoft tools. Eleven (11) Years of .NET Architecture, design and development experience using VB.Net, ASP.Net, ADO.Net, C# development.
Able to take on and apply new software development applications providing rapid solution roll out.
Excellent communication skills and interfacing with business users.
LANGUAGES & APPLICATIONS:
SQL Server 2017, 2016, 2014, 2012, 2008 (2008 R2), SQL Server 2005, SQL Server 2000, SQL Server 7.0, SQL Server 6.5
SQL Server BI stack SSAS, SSIS, SSRS, SQL Server DTS, T-SQL,
Tableau 2018, Power BI,
Azure SQL/Azure Migration, PL/SQL (Oracle 11g), PostgresSQL,
.Net Architectures, VB.Net ADO.NET, ASP.NET, C# (some)
Microsoft Visual Studio 2003 – 2017,
Visual Basic 3.0 through 6.0 (Enterprise Editions),
Visual Interdev 6.0, ASP, Perl, Excel PowerPivot, Python,
Dundas OLAP Charting Reports, Oracle 8, MS-Access Development (2.0 – 2010), Cognos 8 (Query studio, Analysis Studio), Active Reports, Crystal Reports Enterprise 9.0 (8.5, 8.0).
SOFTWARE / Miscellaneous:
Toad (for Oracle), Team foundation Server (TFS), Rational Team Concert (RTC), Atlassian (SourceTree/BitBucket),
Microsoft Office (Excel, Access, Word, Powerpoint, Project), MS Visio, CA AllFusion ErWin Data Modeller 7, Cognos Impromptu v6, Cognos Powerplay v6, Cognos 8.2 Query Studio and Analysis Studio,
Visual SourceSafe., HomeSite 4.5, Wise Install Master 8.1, InstallShield
Quest Spotlight (DB tool), DBArtisan (DB tool), RoboHelp, iScala (ERP), Epicor/Vantage (ERP). ColdFusion 4.5, Transformation Server (DataMirror ETL), VBScript, IIS, MTS, ActiveX, COM, Java, Delphi 3.0 & 4.0, Jam 7.02, SuperBase95, VAX BASIC, Versata Jade 4.0 & 5.0, TOLAS
Windows Server 2016/2012/2008/2003 (Enterprise 64 & 32 bit), Windows XP Professional, Windows 2000 Server & Professional, UNIX (some),
MS-Windows NT 3.5 & 4.0, Windows 95/98/3.11/3.1,
MS-DOS 4.0, 5.0 & 6.0, VMS/RMS, OS/400 (some).
Masters of Business Administration with Technical Management, MBA/TM,
University Of Phoenix, USA
Bachelor of Science Degree with Honors in Agricultural Zoology, BS Honors,
University of Newcastle-Upon-Tyne, Great Britain
Microsoft Certified Database Administrator (MCDBA), 2002
Microsoft Certified Solutions Developer (MCSD), 2002
Microsoft Certified Applications Developer (MCAD), 2003
Contract: CooperVision, Victor, NY
Duration: March 2017 – December 2018
Title: ETL SSIS Developer, OneVision/Logility development/maintenance.
Development of SSIS ETL packages, and process improvement of existing packages, in support of a multinational supply chain management and sales history process. The data which is imported from a series of heterogenous data sources (flat file, Oracle, SQL Server) is scrubbed, transformed and processed into data formats specific for loading into a Logility SCM destination. This particular task has been in support of an international multi-year/multimillion-dollar project in its final year and completed successfully.
Development, design, specification realization of the Supply Chain Customer Service DataMart Dimensional database (SQL Server 2016 & 2017). Also involving both the development of SSIS ETL data processing and scrubbing (nightly). Also included SSAS cube development incorporating data collection, scrubbing of data, evaluation of incoming variants and cube creation nightly within the SSIS process. Tableau report server reports, dashboards also created. Involved with specification of and creation, data mart structure creation design.
Employer: Harris Beach Solutions, Pittsford, NY
Duration: Jun 2016 – Feb 2017
Title: SSRS Developer; Affordable Care Act Compliance.
The title of SSRS Developer is somewhat misleading as the particular tasks were more of a full stack SQL developer (SSIS ETL process development, SSRS reports creation and maintenance) coupled to various .Net user interface design and implementations for user entry/import of data. User interfaces have been created to import data directly to the underlying database, or importing data from flat files (tab delimited) with appropriate validation of data for filing compliance (Affordable Care Act compliance and submittal to the IRS). Also developed .Net applications to provide the interface used to guide an SSIS package to be able to locate and perform the bulk loading and validation of data, again from flat tab delimited client created data for subsequent IRS filing. Also included within the daily duties performed are database administration tasks (SQL Server 2014) creation and definition of tables, views, stored procedures, functions, file groups and indexes.
Client: PayChex Inc, Rochester, NY
Duration: Jan 2015 – May 2016
Title: Data Architect/Modeler;
Enterprise Reporting Data Warehouse/Enterprise Data Warehouse (ERD/EDW).
Understanding and subsequent delivery of business domain specific data from the initial data source (core OLTP) via ETL processing and eventual presentation using various reporting strategies for both internal and client facing consumption in an Enterprise Reporting Data warehouse (ERD). This includes the understanding of business data requests, translating those into the delivery and integrated designs to meet these requirements within the business strategy and related business architecture. Required to provide design support and data modelling documentation for Data Quality Assurance (DQA) testing, Test Engineering (TE, regression and change request specific testing) and ETL (Oracle OBIEE) processing. Requires the need to understand logical and physical data modelling at both the macro and micro level data level. Modification to and creation of supporting tables, views and stored procedures, in an enterprise reporting data warehouse environment. Also an understanding in all phases of data modelling from overall design and concept to performance enhancements, tuning and optimization.
Data modelling duties include the development and maintenance of tables (Fact, Dimension and Reference), views, stored procedures in a dimensional Enterprise Reporting Data Warehouse (ERD/EDW) held on an Oracle 11g based environment; update and maintenance of ERD documentation.
Provided the solution to enable the addition of custom field data as an ad hoc inclusion into already established report definitions for client facing data. This required the dynamic creation of SQL statements per report to be generated on request and the subsequent response of the SSRS reports to accommodate the new fields also dynamically.
Provide solutions for specific business requirements and modifications (e.g. Custom Fields addition to existing SSRS reports), and provide solutions to overcome existing issues (incorrect use of CLOB data as a parameter in reports and associated stored procedures).
Provide builds of EDW DDL changes to be incorporated into the overall deployment process per sprint (Agile) across multiple environments (testing N1/N and Production).
Client: PayChex Inc, Rochester, NY
Duration: Jan 2008 – Jan 2015
Title: HRO Dept; Senior SQL Server Business Intelligence Expert / DBA / Developer
Brought onboard to:
oProvide analysis for and subsequent development of SQL Server Analysis Services (SSAS) data mart level Data Cubes.
oUtilize existing warehoused data to derive cube data (data mart) collection,
oEvangelize the capabilities and advantages of SSAS as a decision support tool.
oProvide report based requests from the executive level.
oAlso provided a cube browser based upon the Dundas Software OLAP provider development tools using VB.Net.
oData migration involved the development of SSIS packages for running the SSAS build processes off peak.
Subsequently involved with converting the Crystal Reports based reporting solution to a SQL Server Reporting Services (SSRS) platform. As well as report design, the role also required the construction of a generic stored procedure enabling for dynamic creation of specific T-SQL queries depending upon the requirements of each report. Included in this specification was the capability of causing specific columns to be hidden from user view should a certain level of security be needed in the report/s.
Developed and established an OLAP solution to support the client facing reports as offered by the client. The main intention being to offload reporting performance impact from the OLTP process and improve report delivery.
Involved in the development of SQL Server Integration Services (SSIS) packages to process the auditing of data change capture and reporting from an already existing trigger based solution to one utilizing Change Data Capture (CDC) architectures within SQL Server. This development also required the processing of the already existing historical audit data into the new architecture for continuity of past data changes also utilizing SSIS packages.
Development of SSIS packages to perform Archive/Purge processes on the SQL Server data based upon a four (4) year threshold of data from the “live” data into an archive silo.
Created a process to improve the transfer of data utilizing triggers producing XML placed into a Service Broker queue and consumed by a Web Service (in VB.Net).
Involved in the overall optimization of the existing database, including retuning and redefining indexes for performance.
Involved in BAU (Business As Usual) change requests for the HR Online production system which involved analysis, estimation and coding (written in C#) for the requested modifications to the applications involved, maintenance of SSIS and SSRS elements, DBA duties within certain test environments.
Involved with migrating and validating SSIS packages from SQL Server 2008 R2 to SQL Server 2012.
All while working within an Agile/Kanban software development environment.
Client: OneStream, Rochester, NY
Duration: October 2014 – May 2016
Title: DBA / ETL Data Migration / SSRS Reports Developer
Brought in to set up the ETL processes necessary for importing Excel derived data from third party sources into a SQL Server 2012 database. The files, containing telecom routing, duration, call issue error code related information are delivered by a daily FTP file drop.
Provide ETL processes using SSIS.
Provide various reports designed with SSRS.
Provide DBA duties such as creating and tuning SQL queries, creation of indexes, setting up of database backup processing and SQL Agent scheduled job task creation. Creation of databases including file groups for separation of data and indexes.
Client: Complemar, Rochester, NY
Duration: Periodic, March 2010 – May 2016
Title: DBA / SSRS Reports Developer
Initially brought in to set up and initiate the move to a replication strategy of data between their Rochester and Buffalo sites using SQL Server merge replication. I’ve since been involved in a consultative and advisory role with regards the overall performance of the SQL Server installation and the possibility of moving them to an OLAP/OLTP architecture; facilitating offloading their internal and client reporting overheads and the inevitable effect it is having on their daily transactional process including: query tuning, an improvement of performance with analysis and provision of “missing” Indexing on various tables, and stored procedures. More recently has been the development of new SSRS reports and an ongoing modification and improvement of various pre-existing reports.
Client: Johnson & Johnson Ortho-Clinical Diagnostics, Rochester, NY
(Consultant: Spherion Professional Services, Fairport, NY)
Duration: Feb 2007 – Dec 2007
Title: SQL Server Database Developer/SQL 2005 SSAS Data Cube development
The tasks initially involved the design and development of SQL Server 2005 Analytical Services (SSAS) data cubes to fulfill ongoing reporting and analysis of the Demand Planning Forecasting analysis data mart at Johnson and Johnson’s Ortho-Clinical Development Supply Chain Management department. This role was later expanded to include support for the Data Warehouse/Data Mart migration process, including the migration of Cognos 7 solutions, and SQL 2000 Analysis Services cubes all to the SQL 2005 SSAS (32 and 64 bit environments). The role included analysis of data from business requirements, the development of domain specific data mart level data cubes to replace those existing Cognos 7 solutions, supported data preparation and support of the Cognos 8.2 reporting using Query Studio and Analysis Studio. The process included the creation of SQL Server Integration Services (SSIS) packages to migrate data from J&J OCD data warehouse and data-mart sources to a specific destination for data collation and cube building, including any necessary ETL processes. The project also included evaluation, demonstration and recommendation of various cube presentation methods beyond Cognos 8.2 including ProClarity, Microsoft Excel Pivot Chart presentation, and Dundas reports development.
The engagement extension involved conversion of further Cognos 7 data cube projects, and also included newly defined SSAS data cubes on SQL Server 2005 supporting the Cognos 8.2 presentation platform drawing data from heterogeneous data sources such as Oracle and SQL Server 2000/2005.
Employee: Sterling Testing Systems, Manhattan, New York, NY
Duration: Oct 2006 – Jan 2007
Title: Database Architect
The creation and realization of SQL Server 2005 and SQL Server 2000 databases created from business requirements and system specifications. Ensuring that databases created to support specific applications under development (both in-house and Offshore providers) conform to specific company specifications and standards while being adequately configured for optimal performance.
Client: Zotos International, Geneva NY
Duration: Aug 2006 – Oct 2006; Also Jan 2007, Sept 2007, Jan 2008
Title: SQL Server DBA / Developer
Assisting in the reconfiguration and performance improvement of a SQL Server based Supply Chain Management application (SCM). Also providing a level of new reports for the improvement of the production line lead time and packaging processes.
Also involved with providing T-SQL support for the MOCA scripted reporting needs in a Red Prairie Warehouse Management System (WMS Jan 2007). The support also included the development of a backup strategy for existing databases and ensuring the SQL Server instances were configured in an optimal state.
Client: ITT-Gould's Pumps, Inc., Seneca Falls NY
Duration: July 2001 – October 2006
Title: Systems Analyst / .NET Architect / Developer / SQL Server DBA
Designed and created SQL Server Integration Services (SSIS) strategy for the migration of data from existing SQL Server 2000 and Oracle 8 ERP backend databases to a SQL Server 2005 “Broker”. The data was then passed to SAP for Accounts Payable (AP) financial, Purchase Order and Goods Receipt processing via .Net interfaces posting to WebSphere MQ message queues.
Designed and created .NET and DTS interface strategies for passage of financial and a variety of main reference sources (Vendor, Product Master) data between an Epicor Vantage ERP solution and the corporate data source AS400. This involved an extensive use of DTS and .Net architected interface programming.
Piloted a proof of concept solution to validate SQL Server 2000 Reporting Services and SQL Server Analytical Services (OLAP) as a replacement to existing Cognos implementation. The Reporting Services solution required to operate under Windows 2000 Active Directory defined security, groups and permissions. The subsequent implementation of the proposed solution has saved over $200,000 in Cognos licensing and operating fees
Provided an application to automate the translation of over 150 VAX Basic programs to an equivalent VB.NET/ Visual Basic (6.0) Project. Due to existing staff skill sets the solution was provided in a Visual Basic 6.0 version for ease of future maintenance. Each converted project needed to be complete with forms for user interface, classes and source code modules. Process seen as vital requirement to speed up the delivery and migration away from business critical factory robot processes reliant upon an aging VAX machine
Upgraded, migrated and re-architected existing SQL Server v6.5 production DSS (Decision Support Services) databases (totaling 24) to SQL Server 2000. The project included the extensive use of SQL Server 2000 DTS (Data Transformation Services) to facilitate the daily scheduled import and necessary ETL (Extract Transform Load) of AS/400 hosted DB2 production data into the new DSS environment.
Provided technical support and database integration of iScala 2.1 at the ITT-Goulds assembly warehouse in Chung-Ju, S. Korea. Activity also involved migration of historical data from earlier Scala 5 implementation (BTrieve), the regular import of user defined data, and assistance in creating user defined (Crystal) reports. Also created a mechanism for translating iScala table nomenclature into “English” Level One View definitions for easier analysis of data. The implementation came in on time and under budget.
Designed, maintained and created of the SQL Server 2000 database "backend" for the ITT-Goulds Cognos implementation. The solution included introducing the concept of utilizing the SQL Server 2000 as a "Data Broker". This enabled the presentation of heterogeneous linked server data sources, i.e. Oracle 8, DB2, Hyperion, legacy SQL Server v6.5 data into a centralized, single database platform, (SQL Server 2000), and the DTS migration of data by task and job scheduling.
Provided the daily administration of the existing SQL Server v6.5 DSS (Pre migration Decision Support Services) environment including monitoring the download of AS/400 DB2 held production data. Developed new tables and populated with data from the production AS/400 DB2 data. All DSS data migration from the AS/400 DB2 to SQL Server v6.5 utilized the DataMirror Transformation Server Services.
Involved in the modification and improvement of an existing application written in Visual Basic 6.0. Originally designed and configured as a series of decentralized "local" Oracle databases, the modifications require using a centralized schema and a migration to Oracle 8i. The redesigned version of the Oracle database is now run under UNIX, and the application itself is hosted on a Citrix Server. The project required the incorporation of newer ADO techniques to upgrade older, and no longer supported, DAO and RDO technology.
oModified existing code to new standards, including the adoption of ADO.
oIncorporated third-party component upgrades.
oDeveloped installation scripts for application deployment with upgrades to the new platform (Windows NT 4.0 to Windows 2000 Server) using Wise Install Master 8.1.
oModified and developed reports using Crystal Reports 8.5.
oDeveloped a series of triggers on all update, insert and delete activity for all transactional tables. This enabled the auditing of activity upon the data and thus providing additional security.