SUMMARY:

• Earned a Masters of Business Administration with Technical Management, MBA/TM in 2006 from the University Of Phoenix.
• Certified as MCDBA (SQL 2000), MCSD, and MCAD (“Charter Member”, one of the first 5,000 VB.Net developers to get certified)
• Senior Developer / Microsoft Technology Specialist with twenty seven (27) years of hands - on professional experience in all stages of the development life cycle (SDLC).
• Database modeling, designing & developing SQL Server 2012, 2008 R2, 2005 and 2000 database tables, stored procedures, functions, views and triggers, data warehousing, creation of 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, and SQL Server Analysis Services (SSAS) data cube development for use within BI environments.
• Sixteen (16) 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, more recently embarked on 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.

TECHNICAL SKILLS:

LANGUAGES & APPLICATIONS: SQL Server 20 R2), SQL Server 2005, SQL Server 2000, SQL Server BI stack SSAS, SSIS, SSRS, SQL Server DTS. Oracle 11g.Net Architectures, VB.Net ADO.NET, ASP.NET (Visual Studio.Net 2010, 2008, 2005, 2003) Visual Basic 3.0 through 6.0 (Enterprise Editions). Visual Interdev 6.0, HTML, ASP, Perl. Dundas OLAP Charting Reports, SQL Server 7.0 & 6.5, Oracle 8, MS-Access Development (2.0 - XP ), Cognos 8 (Query studio, Analysis Studio), Active Reports, Crystal Reports Enterprise 9.0 (8.5, 8.0).

SOFTWARE / Miscellaneous: Toad (for Oracle), Microsoft Office (Excel, Access, Word, Powerpoint, Project) Team foundation Server (TFS), Rational Team Concert (RTC)MS Visio, CA AllFusion ErWin Data Modeller 7Cognos Impromptu v6, Cognos Powerplay v6Cognos 8.2 Query Studio and Analysis StudioVisual SourceSafe., HomeSite 4.5Wise Install Master 8.1, InstallShield, Quest Spotlight (DB tool), DBArtisan (DB tool).RoboHelp, Transformation Server (DataMirror ETL)iScala (ERP), Epicor/Vantage (ERP).ColdFusion 4.5, VBScript, IIS, MTS, ActiveX, COM, Java, Delphi 3.0 & 4.0, Jam 7.02, SuperBase95, VAX BASIC, Versata Jade 4.0 & 5.0, TOLAS

OPERATING SYSTEMS: Windows Server 2012/2008/2003 (Enterprise 64 & 32 bit), Windows XP Professional, Windows 2000 Server & ProfessionalMS-Windows NT 3.5 & 4.0, Windows 95/98/3.11/3.1 MS-DOS 4.0, 5.0 & 6.0, VMS/RMS, UNIX (some), OS/400 (some).

EXPERIENCE:

Confidential, Rochester, NY

Responsibilities:

• Primary role to provide data modelling duties for the development and maintenance of tables (Fact, Dimension, Reference), views, stored procedures in a dimensional Enterprise Data Warehouse (EDW) and Enterprise Reporting held on an Oracle 11g based environment.
• 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).

Confidential, Rochester, NY

Senior SQL Server Business Intelligence Expert / DBA / Developer

Responsibilities:

• Brought onboard to: provide analysis for and subsequent development of SQL Server Analysis Services (SSAS) Data Cubes, utilize existing warehoused data to derive cube data collection, evangelize the capabilities and advantages of SSAS as a decision support tool, provide report based requests from the executive level.
• Also provided a cube browser based upon the Dundas Software OLAP provider development tools using VB.Net.
• Data 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.
• 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.

Confidential, Rochester, NY

DBA / ETL Data Migration / SSRS Reports Developer

Responsibilities:

• 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 and duration related information are delivered by a daily FTP file drop.
• Provide ETL processes using SSIS.
• Provide various reports designed with SSRS.
• Provide XML formatted information for uploading into a key performance dashboard monitoring service.
• 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 filegroups for separation of data and indexes.

Confidential, Rochester, NY

DBA / SSRS Reports Developer

Responsibilities:

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

Confidential, Rochester, NY

SQL Server Database Developer/SQL 2005 SSAS Data Cube development

Responsibilities:

• 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 at Confidential and Confidential ’s Ortho-Clinical Development Supply Chain Management department. This role was later expanded to include support for the Data Warehouse migration process, 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 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.

Confidential, Manhattan, New York, NY

Database Architect

Responsibilities:

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

Confidential, Geneva, NY

SQL Server DBA / Developer

Responsibilities:

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

Confidential, Seneca Falls, NY

Systems Analyst / .NET Architect / Developer / SQL Server DBA

Responsibilities:

• 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 Confidential -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 Confidential -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 in corporation of newer ADO techniques to upgrade older, and no longer supported, DAO and RDO technology.
• Modified existing code to new standards, including the adoption of ADO.
• Incorporated third-party component upgrades.
• Developed 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.
• Modified and developed reports using Crystal Reports 8.5.
• Developed 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.

Confidential, Genoa, NY

Application Developer/Systems Analyst/DBA

Responsibilities:

• Direct involvement with the initial business analysis of the existing database and business processes.
• Gathering information from Users and Administrators of the existing system on the day-to-day use of the applications, and improvements required for inclusion into the new system.
• Creation and maintenance of the Oracle database, intended for use by the website, including; Oracle Instance creation, tables, views, triggers, sequences, roles, and users as both an adaptation of the existing schema, and inclusion of modifications deemed necessary for the new web site.
• Creation of Perl scripts used to download information from disparate relational database systems into text files. Data subsequently imported into the existing SQL Server database (SQL Server 7.0) onsite again using Perl and application processes developed in Delphi 4.0. Also utilized Visual Basic 6.0 to maintain and develop library routines (DLL) used by ASP (Active Server Page) for database access and web page formatting.
• Used Crystal Reports 8.0 to produce web browser-presented web-based reports, reading the data from a SQL Server 7.0 database.
• Involved with developing Client/Server applications working across the Internet for the Alliance Benefit Group, a major retirement plan corporation. Database (SQL Server) and ASP programs written and maintained using both Delphi 3.0, and Visual Basic 5.0.
• Involved in a Pentagon funded project within Lockheed Martin to help design and develop a web application to enable the monitoring, maintenance and administration of US Air force personnel training requirements. An HTML/Java based application written in Versata 5.0, hosted on IBM Websphere utilizing Oracle 8 databases. Responsible for creation of business rules and design of user interfaces.

Confidential, Rochester, NY

Programmer Analyst/DBA

Responsibilities:

• Involved in updating and modifying an application used to monitor and track compliance to the Y2K project both an international and company-wide basis. Assigned to maintaining, and modifying existing database for the above project, required extensive SQL manipulation, and use of Crystal Reports 5.0 for subsequent report generation.
• Invited to become involved with the Confidential Global Data Warehouse project, converting legacy system and DB2 databases to Oracle 7. Wrote Visual Basic 4.0 applications for enhancing the development process involved in collating data for the Warehouse as well as being involved in the acquisition of data intended for its population
• Invited to join the XMM ( Confidential Management Module) development team to provide specific functionality to the XMM application written in Visual Basic 4.0 Enterprise Development kit.