Data Developer

Stephen J. Cherin

Los Angeles, California 323-***-**** *******.******@*****.*** LM7C

SUMMARY

A Microsoft SQL database developer seeking T-SQL/DW coding opportunities. Specialized experience includes ETL, data migrations, data normalization, data warehousing, BI, Data Mining, upgrades, troubleshooting and best practices. Expertise in legal discovery, the banking, telemarketing, bookkeeping and accounting sectors.

PROFESSIONAL EXPERIENCE

• 10+ years of design, development and all phases of the software development life cycle

• 10+ years of MS SQL Database/Data Warehouse design and development (OLAP, cubes)

• 10+ years of MS SQL including stored procedures, functions, triggers and ad-hoc scripts

• 10+ years of bookkeeping, banking and legal software design and development

• 10+ years of data conversions and legacy software maintenance

• 10+ years of data and business tier development including multi-tier and OOP

• 10+ years of test driven development

• 10+ years of systems analysis

• 3+ years of C#.NET

• 3+ years of web development

• 2+ years of HIPAA and SOX

• 1 year of Swift (iOS)

TECHNICAL SUMMARY

• SQL Server 2000-2016, SQLite, MongoDB, NoSQL, MySQL, FoxPro/dBase, Caché/(M)

• Visual Studio 2002-2015, Xcode, Powershell, XML/XSL, JSON

• ETL, DTS, CTE, SSAS, SSIS, SSRS, NoSQL, OLAP, Cubes, DMX, Snowflake, Star Schema

• LINQ, Entity Framework, CLR, REST, MVC, JavaScript, ASP.NET, AngularJS, NodeJS, Bootstrap

• TFS, SourceSafe, SharePoint, Project, Enterprise Architect, Visio, Dynamics CRM, Excel

• Windows, OS X, iOS, Ubuntu Linux

• Agile, Scrum, XP, Post Agile, Waterfall, Lean, Use Case, UML, SDLC

September 2016 – Present

Samara (Software Developers) Los Angeles, CA

Position: Programmer & Analyst

Technologies: SQL Server 2014 & 2016, T-SQL, VS.2013 & VS.2015, TFS, Salesforce

Summary: Architect and develop data warehouse, BI, ETL/SSIS, data mining, SSAS and predictive analysis solutions.

• Architect and develop data warehouse (DW) and ETL processes to synchronize DW with source database using a combination of SSIS, stored procedures and jobs

• Architect and develop BI, data mining and predictive analysis of data to extrapolate trends and predict future behavior of tracked entities

• SQL architect/coding of scripts, stored procedures, functions, triggers and jobs

• Test driven development

August 2015 – September 2016

Frontier Communications, Everett, WA

Position: Data Developer

Technologies: SQL Server 2014, T-SQL, VS.2012 & VS.2013, TFS, Dynamics CRM

Summary: Data migrations/SSIS packages, warehousing/SSAS, data mining, scrum master

Frontier purchased telephone properties from Verizon in California, Texas and Florida. These purchases included infrastructure, customers and vendors. I worked on the project that integrated the customer records of these new properties into Frontier’s systems. Specifically, I was part of the team that conducting troubleshooting of data synchronization issues between Verizon’s customers and Frontier’s systems. I fielded over 500 trouble tickets personally.

• Resolved 500+ internal trouble tickets during conversion of Verizon customers

• Developed SSAS data warehouse and data marts

• Developed SSAS data mining, predictive analysis, reporting and debugging scripts

• Developed SSAS cubes and Excel pivot tables

• Troubleshoot SSIS packages and migration procedures

• Document complex SSIS packages and migration procedures

• Scrum master for data migration projects

• Test driven development

January 2015 – August 2015

Samara (Startup Software Developers) Los Angeles, CA

Position: Programmer & Analyst

Technologies: SQL Server 2014, T-SQL, VS.2013 & VS.2015, C#.NET, JavaScript, Xcode, Swift, SQLite, MongoDB, NodeJS, TFS

Summary: Architect and develop expense reporting software for Web & iOS

• Architect and develop full stack website solution for an expense accounting application using C#.NET, JavaScript, AngularJS and Bootstrap for the UI tier; C#.NET, LINQ and Entity Framework for the business tier; and SQL Server for the data tier

• Architect and develop iOS solution for an expense account bookkeeping app using Swift for the business tier; and SQLite for the data tier

• SQL architect/coding of scripts, stored procedures, functions and triggers

• Test driven development

September 2013 – January 2015

Epiq Systems (Class Action Administration) Portland, OR

Position: SQL Programmer & Data Analyst

Technologies: SQL Server 2008R2, T-SQL, VS.2010 .NET, TFS

Summary: Program complex calculations and statistical analysis to determine pro-rated claimant damages and awards; data mining; importing, exporting, cleansing and reporting of data

Epiq is an administrator of class action tort actions. I developed scripts and analytical models based on court orders to determine the valid claimants of a class action and the amount each claimant was eligible to claim from the total award.

• Develop SQL scripts, stored procedures and functions to determine pro-rata claimant awards

• Develop SQL scripts, stored procedures and functions to analyze and cleanse data

• Developed SSAS data mining, predictive analysis, reporting and debugging scripts

• Developed SSAS cubes and Excel pivot tables

• Import data from diverse input sources into standardized tables (ETL/DTS)

• Export standardized table data to diverse 3rd party structures (ETL/DTS)

• Produce Excel reports of relevant data and data analyses to internal and external customers

• Complex data analysis and financial calculations

• Test driven development

• Technical documentation

December 2012 – September 2013

Samara (Startup Software Developers) Los Angeles, CA

Position: Programmer & Analyst

Technologies: SQL Server 2012, T-SQL, VS.2012, C#.NET, JavaScript, ASP.NET, TFS

Summary: Architect and develop electronic invoicing software for the Web

• Architect and develop full stack web solution for an electronic invoicing system using JavaScript and ASP.NET for the UI tier; C#.NET for the business tier; and SQL Server for the data tier

• SQL architect/coding of scripts, stored procedures, functions and triggers

• Data migrations (ETL/SSIS)

• Test driven development

• Technical and user documentation

• Reports (SSRS)

February 2012 – November 2012

EMRlogic (Software Developers) Burnaby, BC

Position: Application Developer Analyst

Technologies: InterSystems Caché/(M) 2009 & 2010, SQL Server 2012, T-SQL, VS.2012, C#.NET

Summary: Develop event logger and error reporting modules; develop interfaces with 3rd party systems

• Develop modules interfacing with 3rd party systems via APIs and WSDLs using Caché

• Develop event logger and error reporting modules in Caché and SQL Server

• SQL coding of scripts and functions

• C#.NET coding of business objects

• Test driven development

• Technical documentation

November 2011 – April 2012

2Paths (Software Developers) Vancouver, BC

Position: T-SQL Programmer

Technologies: SQL Server 2008R2, T-SQL, TFS

Summary: Develop data synchronization between legacy and new payday loan systems

• Code SQL Server triggers to synchronize data between the legacy and new systems

• Code data migration scripts importing, normalizing and cleansing legacy data into the new system (ETL/SSIS)

• SQL coding of scripts, stored procedures and triggers

• Test driven development

January 2008 – November 2011

Newsways Distributors (Magazine Distributors) Los Angeles, CA

Position: Lead Programmer & DBA

Technologies: SQL Server 2008 & 2008R2, T-SQL, VS.2008 & 2010, C#.NET, JavaScript, ASP.Net, FoxPro, SharePoint, Crystal Reports

Summary: Architect and develop back office bookkeeping and inventory system that synchronizes with legacy FoxPro, QuickBooks and Sage AccPac systems

• Architect and develop full stack back office bookkeeping and inventory control system using C#.NET, JavaScript and ASP.NET for the UI tier; C#.NET for the business tier; and SQL Server for the data tier

• Develop data synchronization stored procedures, triggers and functions maintaining up-to-date data integrity between the legacy and new systems

• Develop scripts, stored procedures and functions importing, normalizing and cleansing legacy data into the new system

• Conduct systems analysis with the bookkeeping, sales, warehouse (inventory) and operations departments to architect extensible and robust solutions

• SQL architect/coding of scripts, stored procedures, functions and triggers

• Developed SSAS data warehouse and data marts

• Developed SSAS data mining, reporting and debugging scripts

• Developed SSAS cubes and Excel pivot tables

• Data migrations (ETL/SSIS)

• Test driven development

• Deploy and manage SharePoint Server

• Technical and user documentation

• Reports (SSRS/Crystal Reports)

September 2005 – December 2007

Genesis Software (Computer Consultants) Los Angeles, CA

Position: Lead Programmer & DBA

Technologies: SQL Server 2005, T-SQL, C#.NET, SharePoint

Summary: Develop software to analyze and report on IIS W3C logs

• Coding of data analysis and reporting tools for IIS Server’s W3C logs using C#.NET and JavaScript for the UI tier; C#.Net for the business tier; and SQL Server for the data tier

• Architect/coding of an attendance tracking, student grading, and payment management system using C#.NET for the UI and business tiers and SQL Server for the data tier

• SQL architect/coding of scripts, stored procedures, functions and triggers

• Data migrations (ETL/DTS)

• Visual FoxPro coding of data conversion/import utilities

• Upgraded various Visual FoxPro modules to conform to OOP/multi-tier standards

• Visual FoxPro coding of extensible data entry system

• Deployed and managed SharePoint Server

Contact this candidate