SUMMARY:

• I have over 16+ years of experience Programming Databases and Data Modeling using MS - SQL, Oracle, PL/SQL, T-SQLNZ-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) and Snowflake Cloud Data Warehousing and Hadoop DBMS and Apache Spark work with the following Data Warehouse/Visualization Tools: SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools, Tableau 9.0 Desktop, Tableau Online, MS-Power BI Desktop, MS-Power BI Designer, MS-Power BI Analysis Services, NDM Data Transmission, KPI, Domo Cloud, Cloudera, Qlik Sense Cloud, QlikView Scripts, Qlik Sense Desk Top, Pentaho, SAP HANA, Embarcadero ER Studio Data Architect version 10.0, Pearl Script in Linux for Autonomous Operation (Machine Learning)

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 Webb, 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, MS SharePoint, HP PolyServe to Management Multiple Clustered Database Servers for MS SQL Server and Oracle 11g

Databases: Oracle 7/8/8i/9i/10g/11i/12c, 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/2008 R2/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), MS Azure Cosmos DB, HIPAA (Health Insurance Portability and Accountability Act)

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, MS Power BI DAX, 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, SAP Business Objects Data Services (BODS) Embarcadero ER Studio Data Architect version 10.0, Pearl Script in Linux for Autonomous Operation (Machine Learning), Snowflake Cloud Data Warehousing, Hadoop, Apache Spark, SAP HANA, SAP Crystal Reports, PostgreSQL

Environment: s: 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

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia PA

MS-Power BI Architect/SQL Developer/MS SQL Server DBA

Responsibilities:

• Blackbaud Systems
• MS SQL Server 2012, Tableau 9.0 Desktop, PaaS/SaaS
• MS Azure Database, MS Azure Cosmo DBA/MS Azure Data Lake/Warehouse environments
• MS C# Language for writing code to Update the MS Azure Cloud Databases
• MS SQL Stored Procedures, DAX Programming of Forms
• SSIS Data Loading into MS Azure Database Lake/Warehouse Environment
• Training staff of how to create Stored Procedures and Power BI Reports/Dashboards
• Training the staff of how to use the Power BI Systems

Confidential

SSRS Reports Developer/SQL Developer/JD Edwards Developer/Data Modeling (Consultant)

Responsibilities:

• Use of the following Technologies:
• Strong experience developing and using SQL Server Reporting Services (SSRS) reports using SSRS development tool (based on Visual Studio), code behind SSRS reports and Data Models, and associated SQL query creation.
• Use of JD Edwards Systems using an IBM AS400 System Data Source
• Use of MS SQL Server for Development of (Stored Procedures, Queries, Views, Etc.)
• Understanding of Windows Security Principles.
• Good writing skills to help in writing specifications and testing documentation.
• Familiarity with regulated with environment and related validation testing requirements is helpful (such as GxP Manufacturing), but not required.

Confidential, Philadelphia, PA

Data Modeler/Data Analyst/Reports Developer/Workday systems conversions (Consultant)

Responsibilities:

• 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 Survey Processes to Workday systems
• Creating Documentation for all Systems Data Flows for conversion to Visio Data flows.
• Use of the following Technologies:
• MS BI Stack SSIS, SSRS, MS SQL Reports Server, MS SQL Server 2016, MS Visual Studio 2016, MS Visio 2016 Professional, Workday systems conversions
• MS T-SQL, MS ACCESS, MS T-SQL Stored Procedures, MS SQL Triggers
• IntApp Flow Data Visualization Tools
• Performs other job-related duties as required.
• Scrum/Agile Environment

Confidential, Horsham, PA

BI Architect/BI Developer/SiSense Data Visualization/Data Modeling/PaaS/SaaS (Consultant)

Responsibilities:

• Use of the following Technologies:
• MS BI Stack SSIS, SSRS, SSAS, MS SQL Server 2016, MongoDB, NoSQL, MS SharePoint, MS Azure Cosmos
• Qlik Sense Cloud, QlikView Scripts, Qlik Sense DeskTop, MS-Power BI, Paas, SaaS
• SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools
• Data used is for FDA Clinical Medical Devices and Life Science Clinical Medical Devices
• Created Proof of Concept (POC) for Mongo DB ODS using XML and Flat Files and other Data types
• Facilitate the Scrum process which includes daily stand-ups, sprint planning, reviews and retrospectives
• EDI Transactions a Subscription based service
• High-level data architecture documentation and policy definition
• Performs other job-related duties as required including Documentation for New Businesses Processes (Road Map).
• Scrum/Agile Environment

Confidential, Prussia, PA

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

Responsibilities:

• Use of the following Technologies:
• MS BI Stack SSIS, SSRS, SSAS, MS SQL Server 2016, MongoDB, MariaDB, MySQL, MS SharePoint, MS Azure Cosmos DB
• SiSense, SiSense Elastic Cubes, SiSense Data Visualization Tools
• Domo Cloud, Cloudera, MS-Power BI, Tableau
• Qlik Sense Cloud, QlikView Scripts, Qlik Sense Desk Top, PaaS, SaaS
• Pentaho, Kettle, XML and Flat File loads and other data types.
• Created Proof of Concept (POC) trials for Hardware and Software Products
• Amazon Redshift Database (AWS)
• EDI Transactions a Subscription based service

Confidential

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

Responsibilities:

• Use of the following Technologies:
• T-SQL 2008, 2014, 2016, NDM Data Transmission with SSIS Packages and Flat File loads and other Data types
• Use of JIRA/GIT/Confluence tools for version Control Tracking and JIRA Stories for change time estimates
• MS SQL 2008/MS SQL 2012/ MS SQL 2016, Visual Studio 2008/2016
• Microsoft SSIS/SSRS/SSAS MS BI Stack Tools, MS-Power BI
• Creating Custom Stored Procedures for Reports
• Diagnosis of Virtual System Issues and provide and Resolution to systems issues.
• Use of Citrix Receiver for Virtual Environments
• Facilitate the Scrum process which includes daily stand-ups, sprint planning, reviews and retrospectives
• Scrum/Agile Environment

Confidential, PA

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

Responsibilities:

• Use of the following Technologies:
• T-SQL 2008, 2014
• MS SQL 2008/ MS SQL 2012, Visual Studio 2008
• Microsoft SSIS/SSRS/SSAS MS BI Stack Tools for Flat File loads and other Data types
• Creating Custom Stored Procedures for Reports, NDM Data Transmission with SSIS Packages
• Backup and Recovery of Test and Production Databases to Production or Test Environments
• Use of Solarwinds Virtual Environment Database Performance Analyzer
• Microsoft Service Manager 2012 R2 Console to process Change Request and Incident Request
• Diagnosis of Virtual System Issues and provide and Resolution to systems issues.
• Diagnosis of issues using System Data Logs and provide document of my resolution.
• Use of Citrix Receiver for Virtual Environments

Confidential

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

Responsibilities:

• Use of the following Technologies:
• T-SQL 80, T-SQL 2014
• MS SQL 2005/ MSSQL 2014
• Telerik Report Designer Tool /SSRS Reports
• Creating Stored Procedures and Functions for the Application GUI
• EDI Transactions a Subscription based service
• Backup and Recovery of Test and Production Databases to Production or Test Environments

Confidential Pottstown, PA

Data Transfer Analyst/Sr. ETL Report Developer/RDBMS Developer/Business Analyst

Responsibilities:

• Use of the following Technologies:
• 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

Confidential St Petersburg, PA

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

Responsibilities:

• Use of the following Technologies:
• Use of Patriot Officer Tool to verify accounts for Federal Money Laundering compliance
• Use of MDM principals so that no duplicate account is created.
• Use of TOAD Data Modeling Tools and IBM Cognos for report creation and modifications
• 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
• 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
• Reverse Engineering of SSIS, SSRS packages used in loading data from various bank locations
• Use of CISCO WebEx or GoToMeeting for meetings with Line of Business (LOB) to get or give daily requirements and Updates.

Confidential, DE

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

Responsibilities:

• 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

Confidential Radnor, PA

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

Responsibilities:

• 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 and SAP HANA systems
• 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 and Snowflake 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