SUMMARY:

• 20+ Years’ experience with database technologies including SQL Server and integration services (SSIS, DTS, ETL and ELT)
• Python programming
• NoSQL databases
• Using Temporal tables in SQL Server to handle Slowly Changing Dimensions more efficiently
• Microsoft Parallel Data Warehouse (PDW) APS technology
• SQL Server Data Warehouse architect
• Azure Blob and Table storage
• MongoDB compass Document storage
• Dimensional Design - Business Process, Granularity, Dimensions, Facts
• Slowly Changing Dimensions to maintain history and provide current analytics
• Populating PDW tables via advanced Stored Procedures using CTAS (Create Table As)
• Reducing long running queries from 30 + hours to less than 12.
• Use SQL Explain plans in XML for Query Tuning
• Refreshing SSAS Cubes with PDW tables.
• Scripting CTAS tables and Distribution on HASH field or Replication
• Converting T-SQL to APS AU5 compatible code
• Data Modeling for Relational Database Design and Data Warehouse Star Schema and Snowflake.
• EDGE server Inbound / Outbound data import via SSIS
• Used XML source and Created XSLT transformation and XSD file to conform data types and reuse XSD for files having the same layout.
• Tableau reporting for advanced analytics
• Geographic mapping displays
• Data Visualization using various reporting tools like Tableau, Excel, SSRS, Qlik, and Power BI
• ALTERYX data analytics
• Created process to compare meta data from client with internal standards while reducing manual effort
• Data Manipulation and Transformation for Analytical apps. Ability to run remotely with XML input parameter file.
• Python programming to condition and de-identify files prior to ETL process.
• Certified Scrum Master. Agile Release Process for Software Development using Sprints
• User Story writing for Cross-Functional Teams to have the same understanding of requirements
• Kanban workflow process. WIP limits based on available resources.
• Dynamic build of table definition from Excel lists to Create Custom Table structure
• Dynamic mapping of input columns to SQL tables
• Using SSIS Script Component to connect to Web Service to get XML data
• Created an XSL style sheet to read from the XML file
• Worked on challenging projects with:
• Data from different systems, structures and file types
• Transformed, Modified and Enhanced Data with SSIS
• Loaded Data to various Platforms for Reporting, Analyzing and Reviewing
• Optimized T-SQL statements to maximize code efficiency.
• Added Parameterized SQL stored procedures to avoid hard coded dynamic SQL statements in SSIS package expressions.
• Implemented SSIS package with XML source to transform relational outputs to load system with XML file with one Root and data pairs including comma delimited fields required for de-normalized Loadable file.
• Designed SSIS event handlers to populate SQL Server tables with Package, Task and Error data for Performance Statistics Reports.
• Recommended Changes to current process within SSIS packages to maximize efficiency by implementing solutions based on the “Write Once, use Many times” theory. Reducing duplicative processes.
• Created Reporting Processes to extract data from SQL sources for SSRS or ProClarity for use in SharePoint as a delivery system.
• Created XML output files from SSIS Control Flow with Script Task component activated by a command line call in an SSIS Expression

TECHNICAL SKILLS:

Applications/Computer Languages: PDW, APS, SQL Server, SSIS, SSAS, SSRS, SAS, ACL, Access, Excel, VBA, MDX, T-SQL, VB.NET, C#, XML, PyCharm

EXPERIENCE:

Confidential, Dresher, PA

BI Developer

Responsibilities:

• Index optimization using query plans and filtered indexs.
• SQL Server data warehouse project for mortgage debt products
• SSIS ETL staging raw data and loading DW tables for data analysts
• Cloud based project using Azure blob storage MongoDB document storage for Asset Backed Securities
• Python ingestion of vendor specific data in nested JSON format
• GIT and Bitbucket used for Source control
• Visual Studio SSDT, Visual Studio Code, Jupyter notebooks

Confidential, Blue Bell, PA

Data Warehouse Architect

Responsibilities:

• Created Data Warehouse for Clinical trial payments
• Indexing for Best query performance
• Visual Studio Data Tools
• SSIS packages to Load and Transform Data
• Project at a Law Firm for Financial Securities Settlements
• SQL Server Management Studio 2017
• SSIS Data Tools with Visual Studio
• Temporal Tables for Current and Historical Dimensional Data
• Complex stored procedures to calculate balances and Running totals
• Data masking for fields having PII or other sensitive data

Confidential, Merion Station, PA

Solutions Architect

Responsibilities:

• SQL Server Management Studio 2014
• Installing and customizing ETL systems for new clients
• Troubleshooting existing ETL for optimization
• Query Tuning and Query Optimization for front end user reports
• Adding Indexes and aggregation solutions
• Planning for current and future tasks identifying priorities and precedence
• Visual Studio Data Tools
• SSIS packages to Load and Transform Data

Confidential, Princeton, NJ

Senior Tech Analyst

Responsibilities:

• SQL Server Management Studio 2012, 2014
• Microsoft PDW APS (Analytics Platform System), Appliance Model for MPP
• Create Table AS (CTAS) Replicated and Distributed Table Design
• Query Tuning and Query Optimization while converting T - SQL Stored Procedures to PDW
• Code Reviews for Local and Offshore developers
• Planning for current and future tasks identifying priorities and precedence
• Visual Studio Data Tools
• SSIS packages to Load and Transform Data
• SSAS Cubes for data analysis
• SQL Server Management Studio 2012, 2014
• Visual Studio 2010
• Alteryx Data Analytics
• Python Scripting
• Quality testing for pre and post Data Warehouse
• Problem Solving data issues
• Code Reviews with other developers

Confidential, Horsham, PA

ETL Developer

Responsibilities:

• SQL Server Management Studio 2012.
• Visual Studio 2010
• Certified Scrum Master with Agile methodology
• User Story writing to help Business team and IT have the same understanding
• Defining Definition of Done and Acceptance Criteria with Development, QA and UAT teams.
• Unit Testing of updated stored procedures in Development and Stage environments.
• Promoted code from Stage to Production according to release schedule
• Finding solutions to long running processes by modifying SQL scripts used for loading Enterprise Data Warehouse.

Confidential, Cedar Knolls, NJ

ETL Developer

Responsibilities:

• SSIS development projects using Visual Studio 2010 and just started using 2013.
• SQL server Stored Procedures
• Tasked with creating efficiencies in current ETL process. Reduced data load times by at least 50%.
• Data Quality improvements resulted from my development efforts.

Confidential, Malvern, PA

ETL Architect

Responsibilities:

• Tableau Reporting
• Analytics based on SQL data sources
• Refreshing Dashboard reports with updated data
• Customizing reports for various departments or end users
• SQL Server
• Team Lead for custom solutions for clients. Worked with Sales teams to help define costs involved with onboarding new clients.
• Creating Stored Procedures to be used in SQL Agent to update SSIS configurations
• Stored Procedures to be used as sources in SSIS Data Flow Tasks
• MERGE statements for Updates, Inserts and Deletes
• One use of this is maintaining Object Library for Tables, Views Stored Procedures and Functions across different databases.
• SSIS
• Dynamic mapping from Source data to SQL tables
• Transfer from Test schema to Stage schema where Stage has actual Column Names
• Transfer from Stage to dbo tables with Proper data types
• Profile data for Integrity checks and finding anomalies
• Data statistics, Percent Null, pattern checks, Top N Values
• Archive data to either SQL tables or Compressed text files
• Collecting data from Web Service sources using Script Component
• XML source to transfer data from one part of the business to another.
• Created XSLT templates to extract specific data from XML file

Confidential, Malvern, PA

Technical Services Analyst

Responsibilities:

• SQL Server
• Creating Stored Procedures
• Used as sources in SSIS Data Flow
• Simplifying Complex routines
• Version control and unit testing
• CTE and Recursive queries
• Web service connections using SSIS for data movement and processing
• Oracle
• PL/SQL using SQL Developer
• Custom functions
• Version control with CSV
• Cognos
• Reports for deployment to client environment
• XML with PL/SQL
• Prompt Pages for user input
• SSIS development
• Item Matching with Fuzzy Lookup
• Framework for ETL operations
• Event Handler code to log variable value changes
• Scheduled package execution using SQL Server Agent
• SSRS
• Custom Report development
• Deployment to Report Server with security
• VBA Excel front end to Access Database for custom solution
• Project and Task Management
• Custom reporting for long term Software Deployment Plan

Confidential, Plymouth Meeting, PA

SQL Developer

Responsibilities:

• Creating and modifying Stored Procedures
• Designing SSIS packages
• Helped Tableau users with SQL Queries to create efficient reports
• Using SCRIBE workbench and Console software
• Running ETL jobs and performing Validation Steps
• Production and Staging processes
• Designing SSIS packages for a Collateral Management Project
• Developed for the conversion to a new Bank Application
• Participated in the Life cycle of the project from Design, Test, QC and Execution.
• Managed Bank Statement Project
• Offshore resources working on Adobe Reports based on queries I designed
• Designed Database structure and SSIS implementation
• Presented results to Business team and coordinated changes with development team.
• Involved in designing ETL Process for New Bank System
• Working with Database team to design Staging, Pre-Processing and Application database
• System will be run overnight each business day to update existing Bank Systems

Confidential, Glen Mills, PA

Contractor

Responsibilities:

• Designing SSIS packages for Data Transformations and Loading Database tables
• Text, XML, ODBC sources
• XML, ODBC and Proprietary Application Destinations
• One of these XML Destinations is used to create the input to the Proprietary Data reporting system for Mutual funds.
• SSIS expressions, VB and C# scripting and T-SQL coding
• Data Transformations in SSIS. Using the Data Flow transformations in SSIS allows the creation of tasks useable in a variety of situations driven by expressions and XML configurations to change Servers and/or Database locations. Write Once, Use Many.
• Custom Script creation and maintenance. Modifying Data in input streams helps to take advantage of the in memory processing in SSIS.
• T-SQL scripts to deploy Databases with necessary objects created with and without Dynamic SQL.
• Deployed Custom ETL process to Testing and Production environments.
• Business units have been able to implement my SSIS solutions with minor changes for re-use for other purposes. For Example, Data Analysts were able to migrate data from the SEC output to another Proprietary Application without using Programming resources. This saves time and effort.

Confidential, Parsippany, NJ

Senior Consultant

Responsibilities:

• Built cubes from SQL databases using Visual Studio 2005 and 2008.
• To Analyze International Tax Data for Past performance and Future Planning.
• Tax Clients would use more than one progression to sample implications of Tax decisions. Our custom products allowed flexibility to make changes and see specific Reports and Charts to help make intelligent decisions.
• Created Reports using SSRS, ProClarity and SharePoint.
• SSRS and ProClarity consume the data from SQL Server and SSAS sources to produce user friendly interactive charts/reports for end users.
• Led a team to create the 50+ basic charts/reports and the many custom ones that were required based on client needs.
• Trained members of the team on how to make connections to SSRS, ProClarity and SharePoint for the purpose of viewing charts/reports by end users.
• Designed custom scripts to move sets of charts/reports to point at different database servers and environments. This allowed us to roll out the system for new clients quickly with minimal re-design or re-creation of the SharePoint objects.
• Used .NET tools to create front ends for processing data input and extraction.
• Used Excel VBA to manipulate PivotTables dynamically to created reports based on more than one pivot table.
• Created Custom Access database solutions for Audit Clients
• Used VBA to run advanced SQL queries to help create standard and custom reports dynamically.
• Created and Maintained Excel workbooks to produce Journal Entry Testing Results and Input Templates
• As a Senior Consultant I ran conference call meetings with audit staff for international clients to discuss and explain the results of the Journal Entry Testing or other Audit Analysis.
• Led team of consultants to perform the SAS or ACL database projects.
• Started as a Consultant, and then was promoted to Senior Consultant, due to outstanding performance.
• Modified and Executed SAS and/or ACL programs to perform Audit functions. Reported to Audit Team as well as Technology Team.

Confidential, Princeton, NJ

Data Analyst

Responsibilities:

• Created performance monitoring applications on MS Query SQL platform, utilizing MS Excel pivot tables
• Mutual Fund data tracking functions to report on the accuracy of automated input and manual input.
• Automated distribution of manager reports via external data connection in Excel.
• Designed and Implemented Replicated Database for global translation team
• Previously the team spent hours in meetings to discuss Bloomberg screen designs
• My implementation allowed managers to see which Labels in which language needed maximum visible width and adjust the label size scientifically and not through discussion
• Saved Translation team many hours and also saved programming resources by reducing the traffic and re-work.
• Created user database to track research items and report on cost of research.
• Access as the front end and back end.
• Excel for the reports to managers.
• Participated in negotiations of contracts for research database usage from information vendors
• Trained Bloomberg reporters on using Lexis-Nexis and helped Reporters find information faster which lead to better performance .
• Used Nexis for research projects to be delivered to Managers, Directors and Sales people within the company.