Candidates About

 

David Van Wallace

 

SUMMARY

I have over Ten years of experience Programming Databases and Data Modeling using MS-SQL, Oracle, PL/SQL, T-SQL,

NZ-SQL and others.  I have extensive experience in administration and optimization of Oracle and MS-SQL

BI Stack (SSIS/SSAS/SSRS) systems. Use of IBM Netezza 7.0 Pure Data System HA (High Availability MPP Massive Parallel Processing). I have 10 years of experience contracting with multiple Pharmaceuticals including Astra Zeneca, Johnson & Johnson, Quest Diagnostics (GSK), SmithKline Beecham Clinical Labs (GSK) GlaskoSmithKline  

 

EDUCATION

• B.A. – Computer Information Science (in progress) La Salle University
• Corporate Growth Certificate Program, University of Pennsylvania Wharton Business School
• Diploma – Computer Programming, Computer Learning Center 4.0 GPA

 

TECHNICAL SKILLS

Languages/Tools

Visual Basic.Net, C#, ASP.NET, ADO.NET, VB Script, ASP, XML, XSLT, JAVA, JSP, Informix 4GL/ESQL/Online, C/C++, AWK,  VBA, MS Visual Source Safe (VSS), Enterprise PowerBuilder 5.03/6.0/6.5/7.0/8.0, PowerBuilder PFC, Stored Procedures, Oracle Developer 2000, Oracle Forms 6.0, Assembler, RPG II, SAP, Gupta SQL Windows/Centura, Active-X, SAP Crystal Reports, GURU ODBC, Oracle PL/SQL, PL/SQL Developer, Tuxedo, Visio 2000, Delphi 3.0/5.0, CICS, COBOL, Transact-SQL (T-SQL), SQL Triggers, UNIX Shell Scripting, MBNA SDM Training, Crystal Enterprise, SDLC, AppForge for Visual Basic 6.0, VSTO, TELNET, SHIVA Remote, PowerPoint, MS Project, XML, Patriot Officer, CISCO WebEx, GoToMeeting, BCP, CoreFTP, SAP Business Object, SAP Business Objects Universes, Pearl Script in Linux for Autonomous Operation (Machine Learning),

 

Web/Tools

MS-Visual Studio 2005/2008/2010/2013/2015,  AJAX,MS-Web Developer 2008, MS-Visual Interdev 2000/2005/2008, MS Visual Studio 6.0, COM/COM+/DCOM, XML, XSLT, ASP, VSTO, ASP.NET,  ADO.NET, C#, VB Script , Front Page 2000, RDO, DAO, ADO, MS Visual Studio.Net, Web Classes, PERL, Oracle WebDB, DHTML, Cascading Style Sheets(CSS), ColdFusion 4.0/4.5/MX, Homesite 4.0/4.5, JavaScript , JAVA, IIS, MTS, Oracle 9iAS, Dreamweaver Ultradev, Adobe Acrobat , Macromedia Flash 4.0/5.0, Palm Web Clipping,  FTP, TCP/IP, J-Run, J-Runner, PaperFree, AppForge for Palm Development, TOAD, Emc2Documentum, APACHE, TOMCAT, HTML, Photoshop, BizTalk Server 2000, Oracle Application Express (APEX), JWalk, SunGard LDRPS, Tortoise SVN Version Control Software, RedGate SQL Compare/SQL Prompt Tools, Cybermation Agents for Mainframe, Vignette Application and VCM with WebLogic Servers and Windows 2003/2008 Clusters for Web Portal Support, Team Foundation Server (TFS 2013), JIRA/GIT/Confluence tools,

HP PolyServe to Management Multiple Clustered Database Servers for MS SQL Server and Oracle 11g

 

Databases

Oracle 7/8/8i/9i/10g/11i, Oracle 10g Express (Oracle Database XE), Oracle Lite, Oracle OEM/OEM Enterprise Manager Console, MS-SQL Server 6.0/6.5/7.0/2000/2003/2005/2008R2/2012R2/2014, Sybase 10/11, DB2, Sybase EA-Server, Informix, Access 2000/2003/2016, MS AZURE Cloud Platform, Use of Multiple SQL’s (Oracle: PL/SQL, MS SQL Server: T-SQL, DB/2: ISQL, SQL/DS, IBM Netezza: NZ-SQL), MongoDB, NoSQL, MariaDB, Amazon Redshift Database (AWS)

 

Data Warehousing

MS SSIS, SSRS SSAS, MDX, MS-SQL Analysis Services, IMPROMPTU, Cognos QUIZ, Oracle Discoverer 3i/4i/9iAS RELEASE 2, Rational Rose, BRIO, Computer Associates -Erwin 7/9.0, Visio 2013, Informatica PowerCenter, ERD Diagrams, IBM Netezza 7.0 Pure Data System HA (High Availability MPP Massive Parallel Processing), SAS, Aginity Workbench for Netezza 4.1, Netezza Administrator, Informatica Workflows, FISERV, Fiserv InformEnt PowerShare Information Manager / InformEnt Knowledge Share Administrator, Nautilus Client and Pivot Tables, SAS, Tableau 9.0 Desktop, Tableau Online, MS-Power BI Desktop, MS-Power BI Designer, MS-Power BI Analysis Services, NDM Data Transmission, KPI, SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools, Domo Cloud, Cloudera, Qlik Sense Cloud, QlikView Scripts, Qlik Sense Desk Top, Pentaho,

Embarcadero ER Studio Data Architect version 10.0, Pearl Script in Linux for Autonomous Operation (Machine Learning)

 

Environments

SUSE Linux 9.0, UNIX, SCO XENIX, HP/UX, Client Server, AIX, SUN SOLARIS, Data Warehousing, MS/ XP, MS VISTA, Windows 7, MS AZURE Cloud Services, Oracle VM Virtual Box, IBM Netezza Pure Data Systems 7.0, Citrix Xen Desktop Virtual Environment, Amazon Web Services (AWS Cloud Environment), LDAP, SolarWinds DPA for Virtual Environments, Linux

 

 

 

 

 

EXPERIENCE

 

Ballard Spahr LLP, Philadelphia, PA                                                                                                                              04/18 -- Current

Data Modeler/Data Analyst/Reports Developer (Consultant)

I reverse engineered the current MS-Access Database Reports to MS SSRS Reports and reengineered the Access SQL to T-SQL Stored Procedures and Automated the reports to run on a Daily Schedule at 11:00PM and convert it to PDF Files in a dedicated directory for management access for review. Reverse engineered the following report from the ACCESS Reports to SSRS Reports  the Lindquist_Client_Matter_Report, LindquistMatter_Rpt, LSKSMatter_Rpt, LSKS_Client_Matter_Rpt, and associated Stored Procedures, usp_D_Lindquist_Matter_Rpt_GetData, usp_D_Lindquist_Client_Matter_Rpt_GetData, ups_D_LSKS_Matter_Rpt_GetData, usp_D_LSKS_Client_Matter_Rpt_GetData.

Created the Data Modeling structures for the HR Daily Integrations East including:

§  Active_Personnel:      Ceridian Database IntApp_Active_Personnel and Ceridian. dbo.InApp_Active_Personnel_Copy

§  All_Personnel:            Ceridiandb.dbo.InApp_All_Personnel and Ceridian.dbo.InApp_All_Personnel_Copy  

§  Active_Fee_Earners:  pa-iis.dbo.Intapp_Active_Fee_Earners and DW.dbo.Build_Active_Fee_Earners_Table

§  All_Fee_Earners:        pa-iis.dbo.Intapp_All_Fee_ and DW_FIN.dbo.Build_All_Fee_Earners_Tables

IntApp Flow Training for Data Visualization. Will upgrade and migrate all Business Servey Processes to Workday systems

Creating Documentation for all Systems Data Flows for conversion to Visio Data flows.

·         Use of the following Technologies:

o    MS BI Stack SSIS, SSRS, MS SQL Reports Server, MS SQL Server 2016, MS Visual Studio 2016, MS Visio 2016 Professional

o    MS T-SQL, MS ACCESS, MS T-SQL Stored Procedures

o    IntApp Flow Data Visualization Tools

• Performs other job-related duties as required.
• Scrum/Agile Environment

 

LexisNexis (Reed Technology), Horsham, PA                                                                                                                  10/17 – 01/18

BI Developer/SiSense Data Visualization/Data Modeling (Consultant)

I am responsible for the overall data management strategy for the Reed Tech lines of business.  This includes developing and maintaining a formal description of the data and data structures, defining and implementing data quality and security standards, implementing and enhancing business intelligence and analytics initiatives, and overall data governance.  I have reengineered the

SiSense Elastic Cubes structures using SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools to upgrade a very simple Cube structures and Data Modeling using Embarcadero ER Studio Data Architect version 10.0.  With the revised system I created complex Dashboards for the GRDM/Single Source Medical Devices Architect, GRDM Life Science/Single Source Medical Devices and the Patent Office database Architecture Single Source upgrades for complex statistical Dashboards for Medical Devices/Life Sciences patient results from Device usage. Created a new Architecture for the Road Map Project at LexisNexis (Reed Technology). Created a Proof of Concept ODS using a combination of MS SQL Server and Mongo DB as a Data ODS (Operational Data Store) for processing of all Data to increase efficiency of the processes using XML and Flat Files and other Data types.   

·         Use of the following Technologies:

o    MS BI Stack SSIS, SSRS, SSAS, MS SQL Server 2016, MongoDB, NoSQL

o    SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools

o    Data used is for FDA Clinical Medical Devices and Life Science Clinical Medical Devices

o    Created Proof of Concept (POC) for Mongo DB ODS using XML and Flat Files and other Data types

o    Facilitate the Scrum process which includes daily stand-ups, sprint planning, reviews and retrospectives

o    EDI Transactions a Subscription based service

o    High-level data architecture documentation and policy definition;

• Performs other job-related duties as required.
• Scrum/Agile Environment

 

Regulatory Data Corporation (RDC) King of Prussia, PA                                                                           05/17 – 09/17

BI Developer/Data Warehouse Developer/Data Modeling (Consultant)

Engineering of a New Data Warehouse using and evaluating Data Visualization tools to integrate with RDC Dashboards and SSRS Reports.  I have evaluated and configured and tested various products and created Data Warehouse Cubes using SiSense Elastic Cubes and SiSense Data Visualization tools. Use of SiSense Elastic Cubes and Data Visualization Tools to create Dashboards (Reports) for the HSBC Bank and Facebook Data Visualization Project. I am Directly Coordinating with all the vendors of the Software products.  I am creating Proof of Concept (POC) for Hardware and Software including creating environments for the following: SiSense, Domo, Cloudera, Qlik Sense Cloud, QlikView Scripts, Qlik Sense Desk Top, MS-Power BI, Tableau and Pentaho.  I’m evaluating the software products for the most cost-effective product to use for RDC’s Data Visualization integration. I have created reports and Documentation for the Chief Product Officer for the Data Warehousing and how the products that I am testing and reviewing compare in a Cost Analyst to Multi-Million Dollar Big Data Systems.  My research for systems that are compatible with Machine Learning and Amazon Redshift Database (AWS) for future development. My Environment consist of 32GB of Ram and 4TB of storage and creating 64-bit ODBC connections for the Data Visualization Tools and using a Virtual Windows 10 Environment for Testing. 

·         Use of the following Technologies:

o    MS BI Stack SSIS, SSRS, SSAS, MS SQL Server 2016, MongoDB, MariaDB, MySQL

o    SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools

o    Domo Cloud, Cloudera, MS-Power BI, Tableau  

o    Qlik Sense Cloud, QlikView Scripts, Qlik Sense Desk Top

o    Pentaho, Kettle, XML and Flat File loads and other data types.   

o    Created Proof of Concept (POC) trials for Hardware and Software Products

o    Amazon Redshift Database (AWS)

o    EDI Transactions a Subscription based service

 

Kroger (Turkey Hill Corporate Head Quarters) Conestoga, PA                                                        04/16 – 12/16

SSAS/SSIS/SSRS Reports Developer/Data Modeler/BI Developer/SQL Server DBA (Consultant)

Reverse Engineered and Updated multiple (Legacy) Crystal Reports Backlog to MS SSRS reports and created operational reports to work within the Adage ERP Application. Created custom (ETL) Stored Procedures for the Data Warehouse team to use to stabilize nightly SSIS/SSAS Data Loads Jobs into the Data Warehouse (MDX). Use of Microsoft Visual Studio 2008/2012/2016 for development.  Worked with the User Groups to review Daily workloads in conjunction with the coding updates on the Crystal Reports rewrites to MS SSRS Reports.  Created UAT Test Plans and Test Environment for testing all new Reports in ERP Environment. Worked with the IT team on proper configuration of the Citrix Environment Virtual and Physical Environment configuration. Worked with the IT Team on Data Warehouse Development and Disaster recover procedures and Database Systems best practices.  Reverse Engineering of MS Access Database System used to process shipping and deliveries printouts for the Shipping Department.  Created MS-Power BI Proof of Concept (POC) and gave MS-Power BI recommendation for Data Visualization Reports.

Use of the following Technologies:

o    T-SQL 2008, 2014, 2016, NDM Data Transmission with SSIS Packages and Flat File loads and other Data types

o    Use of JIRA/GIT/Confluence tools for version Control Tracking and JIRA Stories for change time estimates

o    MS SQL 2008/MS SQL 2012/ MS SQL 2016, Visual Studio 2008/2016

o    Microsoft SSIS/SSRS/SSAS MS BI Stack Tools, MS-Power BI

o    Creating Custom Stored Procedures for Reports

o    Diagnosis of Virtual System Issues and provide and Resolution to systems issues.

o    Use of Citrix Receiver for Virtual Environments

o    Facilitate the Scrum process which includes daily stand-ups, sprint planning, reviews and retrospectives

• Scrum/Agile Environment

 

ModSpace Berwyn, PA                                                                                                                            01/16 – 04/2016

BI Developer/Virtual Environment Architect/Data Modeler/Business Analyst/MS-SQL Server DBA/Reports Developer (Consultant)

I reengineered the Virtual Environment stabilizing it to a Memory Usage to 55% usage at peak 52% at rest and normal processes from a 98.77% Memory Utilization at peak and 92% peak and normal processes.  Balanced the OS/MS-SQL Server Environments.  Creating MS SSRS Reports and working in the SSAS (MDX)Environment with the SSIS Daily Data Loading Packages (Jobs).  Programming Stored Procedures for processing Data and SSRS Reports. SQL Tuning and Optimization of BI and Virtual Environments also creating of Custom Load Batch files and use of Tortoise SVN for version control.

·         Use of the following Technologies:

o    T-SQL 2008, 2014

o    MS SQL 2008/ MS SQL 2012, Visual Studio 2008

o    Microsoft SSIS/SSRS/SSAS MS BI Stack Tools for Flat File loads and other Data types

o    Creating Custom Stored Procedures for Reports, NDM Data Transmission with SSIS Packages

o    Backup and Recovery of Test and Production Databases to Production or Test Environments

o    Use of Solarwinds Virtual Environment Database Performance Analyzer

o    Microsoft Service Manager 2012 R2 Console to process Change Request and Incident Request

o    Diagnosis of Virtual System Issues and provide and Resolution to systems issues.

o    Diagnosis of issues using System Data Logs and provide document of my resolution.

o    Use of Citrix Receiver for Virtual Environments

 

NContracts   King of Prussia, PA                                                                                                                         12/15 – 01/16

SQL Server Reports Developer Backfill Project/ Business Analyst/Data Modeler (Consultant)

Developed Upgrades to the NContracts contract tracking software using MS SQL Server 2014 to create custom Stored Procedures and custom Functions for dynamic use within the Application Interface (GUI) and report modifications using Telerik Report Designer Tool. Backups and Recovery of Test and Production Databases to Production or Test Environments. Created the following Stored Procedures and Functions for the GUI or Custom Customer Reports Using MS 2014 T-SQL: BCP_PostMortem_Results, BCP_DashboardGetFunctionTestingStatus, BCP_FunctionsGetAll, BCP_FunctionsGetOne, BCP_VendorResilienceQuestionsUpdate, BCP_VendorResilienceQuestionsGetAll, BCP_VendorResilienceQuestionsAdd, BCP_FunctionPlansForPackaging, BCP_FunctionsGetOne, BCP_OrganizationGetOne, BCP_VendorResilienceQuestionsAndChoicesGetAll, FindingsAllDataCustFinding_Rpt_Filter,    FindingsTaskGetAllByReport_Filter2, BCP_VendorResilienceAssociation_Answer_Delete

·         Use of the following Technologies:

o    T-SQL 80, T-SQL 2014

o    MS SQL 2005/ MSSQL 2014

o    Telerik Report Designer Tool /SSRS Reports

o    Creating Stored Procedures and Functions for the Application GUI

o    EDI Transactions a Subscription based service

o    Backup and Recovery of Test and Production Databases to Production or Test Environments

 

Bank of America Pottstown, PA                                                                                                                           09/14 – 12/15

Data Transfer Analyst/Sr.ETL Report Developer/RDBMS Developer/ Business Analyst (Consultant) (Remote Contract)

Use of CISCO WebEx or GoToMeeting for meetings with Line of Business (LOB) for (National or International) daily requirements gathering to create extract task from Netezza Database (ODS). Create and Run various Scripts Update Migrate and Load Databases.  Set User Profiles and ID and Logon’s to Netezza Systems using IBM Netezza 7.0 Pure Data System HA (High Availability). Use Unix/Linux Shell Scripting. Running multiple (ETL/OLTP) using Micro Strategy, Informatica, IBM Cognos, and MS-SSIS Data Flow Task, MS-SSRS, (DDL) (TSQL) (PL/SQL) and use of Aginity Workbench for Netezza Tool and Netezza as data source by Extracting and loading into a Staging Table for Non Netezza reports. Use of Data Modeling for the creation of Explain Plans for Query Diagnosis and Performance tuning of MS SQL Server/Oracle/DB/2 databases. Coordinate with Overseas DBA and LOB to Develop, Test, Deploy and run nzload based loads (DDL, load scripts) for each data source Develop, Test and Deploy NZPLSQL based Admin Utilities/Procedures.

·         Use of the following Technologies:

o    Netezza Database DDL, NZSQL & NZPLSQL

• Netezza SQL Extensions
• Netezza nzload
• Netezza nz* and nz_* commands/utilities
• Unix/Linux BASH Shell Scripting
• Use of Oracle, MS-SQL Server, DB/2, Flat File Loads, NDM Data Transmission 
• Use of the GROOM TABLE command to reclaim disk space from the deleted and outdated rows 
• Convert Multiple SQL’s (Oracle: PL/SQL, MS SQL Server: T-SQL, DB/2: ISQL, SQL/DS) to NZ-SQL
• Use of Dimensional Modeling with Snowflake Schemas to move large amounts of Data (Multi TB)
• Use of the IBM Netezza 7.0 Pure Data System MPP Massive Parallel Processing
• Use of Aginity Workbench for Netezza 4.1

Fulton Financial   St Petersburg, PA                                                                                                                   06/14 – 09/14

Sr. ETL BI/SQL Report Developer/FISERV BI Tools/Business Analyst/Data Modeler (Consultant)

Data Integration of Multiple Banking systems accomplished by Reverse Engineering (SOA Architect) of banking processes to integrate to a common system and correcting Data Migration issues with the acquisitions of 7 Banks. Use of Fiserv InformEnt PowerShare Information Manager/InformEnt Knowledge Share Administrator, and Patriot Officer to check for Money Laundering. Use of Nautilus Client and Pivot Tables created with InformEnt Knowledge Share Administrator to verify ACH transactions. I also validated (ETL/OLTP) MS-SQL Server SSIS, SSRS, Stored Procedures and use of Data Modeling for the creation of Technical Data flows (Data Modeling) Documentation for all the various processes using Visio 2013 and CA Erwin 9.0 Tools for Data Modeling and MS-TFS 2013.

·         Use of the following Technologies:

• Use of Patriot Officer Tool to verify accounts for Federal Money Laundering compliance

o    Use of MDM principals so that no duplicate account are created.

o    Use of TOAD Data Modeling Tools and IBM Cognos for report creation and modifications

o    Use of Fiserv InformEnt PowerShare Information Manager/InformEnt Knowledge Share Administrator which uses an Oracle RDBMS

• Data Modeling of all Process flows to integrate multiple banking systems via acquisition using Visio 2013 and CA Erwin 9.0 Tools, NDM Data Transmission with SSIS Packages

o    Use of Nautilus Client for researching historical data for Data Matching of client transactions from Pivot Tables created

        with InformEnt Knowledge Share Administrator and use of IBM Cognos for Reports

o    Reverse Engineering of SSIS, SSRS packages used in loading data from various bank locations

o    Use of CISCO WebEx or GoToMeeting for meetings with Line of Business (LOB) to get or give daily requirements and Updates.

 

M&T Bank/Wilmington Trust   Wilmington, DE                                                                                            01/14 – 06/14

Technical Lead/Project Manager/Developer/Business Analyst/Data Modeler (Consultant)

Coordinated with the Migration Team to Migrate ~ 40 Windows XP and Vista Applications in an aggressive time line to Windows 7. Migration and use of .Net 3.5 to .Net 4.0. Applications range from vendor supplied to custom in house applications.  Use of Data Modeling with Erwin 9.0 for the Creation of Training Documentation and Test Plans.  Reverse Engineering of multiple Application to prepare for Migration which included MS SQL Server Migration from MS SQL 2005 to 2008/R2. Use of SunGard LDRPS for creating Disaster Recovery Documentation. Created Project Task and weekly Reporting Status Updates to Upper Management and Team with Team Foundation Server (TFS 2013).

Coordinated and managed the implementation of the Lexis/Nexis Juris/Juris Suite with Lexis/Nexis Team and the Database Team including Installation and Disaster Recovery Documentation. I created Data Flow documentation for Bond Master/Cert Master including testing documentation (AWS Application), Sage PFW/Platinum and FRX Reports for Sage Installation and Disaster Recovery Documentation.

·      Use of the following Technologies:

o  LDAP Directory/Active Directory, Amazon Web Services (AWS), SMTP, FTP, Database (proprietary MS SQL Server, SSRS, SSIS) (ETL/OLTP), Team Foundation Server (TFS 2013)

o  Web Services based interfaces, CNAME, DFS, ODBC for Database connections

o  Use of Citrix Xen Desktop Virtual Environment

o  Use of Dimensional Modeling with Star Schemas Use of Computer Associates -ERwin 9.0 and TOAD Data Modeling Tools

o  Use of CISCO WebEx or GoToMeeting for meetings with Line of Business (LOB) to get or give (National or International) daily requirements and Updates.

Astra Zeneca   Wilmington, DE                                                                                                                            08/13 – 12/13

Data Transfer Analyst/Sr. ETL Report Developer/ Business Analyst/Data Modeler (Consultant)

Convert Oracle Data format (PL/SQL) to Netezza Data RWE (Real World Evidence) format for Migration to IBM  

Netezza 7.0 Pure Data System HA (High Availability) from Oracle Databases, MS SQL Server (TSQL), DB2, Sybase, and Flat Files.  Unix/Linux Shell Scripting Reverse Engineer SAS Data to create DDL for loading SAS Data in to (Snowflake Schemas) Netezza using Netezza NZLOAD and NZSQL. Unix/Linux Shell Scripting.  Use of MDM principals. Reverse Engineered XML code from Web Pages to trace Netezza processes. Use of Data Modeling for the creation of Explain Plans for Query Diagnosis and Performance tuning. Creating Information for the New Electronic Medical Records (EMR) System. ETL Tools used in user group after extraction included Informatica, MS BI Tools (SSIS/SSRS), and Brio. Develop, test, deploy and run NZLOAD based loads (DDL, Load Scripts) for each data source. Develop, test and deploy NZPLSQL based admin utilities/procedures

• Use of the following Technologies:

• Netezza Database DDL, NZSQL & NZPL/SQL
• Netezza SQL Extensions, Netezza nzload
• Netezza nz* and nz_* commands/utilities
• Unix/Linux BASH Shell Scripting, EDI Transactions
• Use of Oracle, MS-SQL Server, DB/2, Sybase, SAS, Flat File Loads, NDM Data Transmission
• Use of the GROOM TABLE command to reclaim disk space from the deleted and outdated rows 
• Convert Multiple SQL’s (Oracle: PL/SQL, MS SQL Server: T-SQL, DB/2: ISQL, SQL/DS) to NZ-SQL
• Use of the IBM Netezza 7.0 Pure Data System MPP Massive Parallel Processing
• Use of Aginity Workbench for Netezza 4.1

Lincoln Financial Group   Radnor, PA                                                                                                              11/12 – 07/13

Data Warehouse Systems Migration Project Manager/Business Analyst/Data Modeler (Consultant)

Production Engineer for the Migration of all MS SQL Server 2005/2008 R2 Data Warehouse Systems for all locations. Use of Data Modeling and requirements gathering for creation of Test Plans for the Migration all the Applications to a Windows 7 Environment using Erwin and Visio tools. Team of 10+ Local and International Developers. Created Project Task and weekly Reporting Status Updates for Upper Management and the Team using Team Foundation Server (TFS 2013) Reports 2013.

• Use of Informatica 9.0.1 (ETL/OLTP) for various Data Warehouse functions and converted them to Computer Associates AutoSys Jobs for all the new Environments (DEV/QA/PRODUCTION) which included the Modification and Adding New functionality to the Informatica Workflows.
• Use of CA-Erwin 9.0 for Reverse Engineering of Data Warehouse and RedGate SQL Tools
• Use of SAP Business Object and SAP Business Objects Universes with MS SQL Server and Oracle Databases

·         Use of CISCO WebEx or GoToMeeting for meetings with Line of Business (LOB) to get or give (National or International) daily requirements and Updates

• Use of ARIBA Spend Management System for Ticket Submittal for Security Management including the LDAP Directory/Active Directory
• Use of LDAP Active Directory/MS Active Directories for all Permission Security for the MS SQL Server 2008 R2 Database and Team Foundation Server (TFS),
• Updating and Creating MS SQL Stored Procedures for Linked Tables and Standard Stored Procedures
• Creating Custom code for Data encryption of MS SQL Server Databases (Functions).
• Use of Computer Associates AutoSys for running all MS-SSIS/SSRS (ETL/OLTP) jobs that was converted to new MS SQL Server 2008 Environment
• Use of Dimensional Modeling with Star Schemas

·        Use of Computer Associates -ERwin 9.0 and TOAD Data Modeling Tools

• Use of Actuate (iReporting (.Net Application)) and iCRM (Saratoga (.Net Application)) and JAVA for migration and received Training in Salesforce Applications Development (APEX)
• Use of Tortoise SVN Version Control Software and RedGate SQL Compare/SQL Prompt

 

IMS Health   Collegeville, PA                                                                                                                                08/12 - 11/12

MS SQL DBA/Sr.BI Engineer/Oracle Data Warehousing/Data Modeler (Consultant)

• Production Engineer to evaluated older PPS/PVS ASP.Net 2.0 Web Application for upgrade to ASP.Net 4.0
• Management of all Databases including Oracle 11g, MS SQL Server 2008/2012, and IBM Mainframe
• Used HP PolyServe, MS SQL T-SQL Scripts, 24/7 Support for all Systems, Use of SQL Server Agent to run Automated Jobs
• Used Crystal Reports for Web Portal Applications

·         Support of BizTalk Servers, Onyx Server, Cybermation Agents for Mainframe, Vignette Application and VCM with Weblogic Servers and Windows 2003/2008 Clusters for Web Portal Support and LDAP Directory/Active Directory

• Use of SSIS/SSRS (ETL/OLTP) for conversions from older MS SQL 2000 DTS Packages.  
• Use of HP PolyServe to Management Multiple Clustered Database Servers for MS SQL Server and Oracle 11g

 

 

 

TW Metals   Exton, PA                                                                                                                                            01/12 - 07/12

Senior Client Server Developer/Sr. ETL Data Architect/Business Analyst/Data Modeler (Consultant)

• Reengineered Informatica 8.1.1 System and stabilized the data feeds from IBM AS400 DB/2 System

• Created custom Informatica Report and required MS SQL T-SQL Scripts for background processing
• Creating Updating and Modifying Informatica Workflows
• Tuning of the MS SQL T-SQL and the DB/2 ISQL, SQL/DS Scripts in the Informatica System
• Created the new Metalware Mobile Tablet browser based System /Application with MS C# and ASP.Net for development team and company CA and PA Warehouse locations for Inventory Tracking.
• Development with MS SharePoint 2010 conversion of older web based systems
• Created Migration plan for Migration of Informatica 8.1.1 to 8.6.1 then to 9.1.1(OLAP/ETL/OLTP)
• Created and Migrated DTS Packages to MS-SSIS/SSRS Packages
• Use of Dimensional Modeling with Star Schemas, NDM Data Transmission with SSIS Packages
• Created JWalk forms with SeaGull J Walk Developer to modernized AS 400 Systems to a Graphic User Interface.  
• Tools Used for Development: Visual Studio 2010, SeaGull J Walk, MS SQL Server 2000/2005/2008

 

BNY Mellon/PNC GIS (Global Investment Services) Wilmington, DE                                                       08/09 - 12/11

Senior BI MS SQL Server 2000 - 2008 Developer/DBA/Sr./Visual Basic Client Server Developer/ Business Analyst/Data Modeler

• Created New and Modify Modules in LPS Visual Basic 6.0 Applications and Migrate to C# 4.0 2010 and VB.Net 4.0 2010 and Migrate to new Client Server Environment (NDM/MQ)
• Research and Assist in Implementing Migration of MS SQL Server 2000 to MS SQL Server 2005/2008
• Researched and Created Process to Migrate Older DTS Processes to MS SQL Server 2005/2008 SSIS/SSRS/SSAS/MDX Packages also created Stored Procedures, Triggers, Views, and Functions
• Developed New Strategies for the Migration of All Old Technologies to New Environments and Technologies.  Created Technical Documentation for various systems
• Programmed all new SSIS, SSRS, (ETL/OLTP) and DTS Packages after migration to new environment
• Used Multiple Financial Applications such as: SunGuard Investran, SunGuard Investier, SubChapter-M Application, GWA (Global Web Access uses C#, ASP.NET, Java Script, VB Script, Pearl Script, XML, XSL, IIS and HTML), Netik, Tortoise, MS-WCF, MS-WPF and Microsoft Visual Source Safe, Use of SQL Server Agent to run Automated Jobs. Regulatory & Governance experience (Dodd Frank) with Federal Government and Overseas Accounts.
• Worked with Hedge Funds, Fund of Funds and various other Alternative Investment Types and EDI Transactions
• Researched and Created a MS SQL Azure Cloud Environment for Investment Clients use
• Use of WCP, WFP, and C# for implementation of Cloud Services as well as MS Azure and Azure Application Fabric
• Technical Writer of all Software and Systems Documentation including Training Documentation 
• Engineer and Reverse Engineer VBA Applications u