Candidates About

 

Gary Sipman

 

SUMMARY                                                                                                                                                                

 

·         20+ years experience in development and implementation of integrated systems in positions of increasing responsibility and scope from software developer to BI Architect

·         10+ years hands-on experience in BI business process reengineering, automation, and optimization

·         Strong analytical, organizational, and problem-solving abilities

·         Experienced in implementing enterprise-scale Advanced Analytics reporting systems using MS SQL Server and IBM Cognos suite of BI tools

·         Advanced level reporting solutions implementation with expert level relational database development background

 

·         Databases: SQL Server, Oracle, SAP HANA, DB2, Access, FoxPro, dBase

·         Software: Cognos, TSQL, DTS, SSIS, SSRS, SSAS, Power BI, Tableau, Salesforce, SAP Lumira, Crystal Reports, Business Objects, ETL, SharePoint, VB.NET, ASP.NET, JAVA, Visual Basic, Visual FoxPro, C/C++, Visual dBase, VBScript, HTML, ADO, ADO.NET; MS Project, Visio, PhotoShop, MS Power Point, ERwin, Toad, MS Source Safe, PVCS Version Manager, TestDirector, Informatica, MS Access, Excel, WinCross, SPSS

 

WORK EXPERIENCE                                                                                                                                                                                                   

 

SOLUTION JUNCTION, LLC                                                                                                                                                         Philadelphia, PA

Independent IT Consultant                                                                                                                                                             02/2018 – present

·         Provided application support using ASP.NET, VB.NET, and SQL Server

·         Development of data extraction, transformation, and loading processes between Google Analytics, SQL Server, Excel, and flat files

·         Designed and developed integration between Google Calendar, Google Contacts, and Google Tasks with Excel

·         Designed, developed, and implemented databases using SQL Server. Created and modified tables, views, stored procedures, triggers, and SSIS tasks

 

ON CAMPUS MARKET LLC                                                                                                                                                                      Ewing, NJ

BI Consultant                                                                                                                                                                                   08/2017 – 02/2018

·         Identified, analyzed, and defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements

·         Reviewed, compared BI tools (Power BI vs. Tableau) and presented recommendations to senior management

·         Analyzed and converted reports from Hyperion to SSRS and Power BI

·         Generated ad-hoc reports for management utilizing SQL Reporting Services and MS Excel

·         Designed, developed, and implemented KPI dashboard and KPI Demand and E-Commerce reports for finance and marketing departments using SSRS, Power BI, and MS Excel

·         Designed, developed, and implemented SQL Server tables, views, stored procedures, triggers, and SSIS packages

·         Build and optimized SQL stored procedures and views to enhance performance

·         Performed data validation and analysis utilizing TSQL and SQL Reporting Services

·         Developed data extraction, transformation, and loading processes between Google Analytics, MS SQL, MS Excel, and flat files using custom build applications utilizing SQL Server and C#

 

TMNA Services LLC                                                                                                                                                                        Bala Cynwyd, PA

BI Architect/Analyst, Advanced (Predictive) Analytics                                                                                                          01/2014 – 05/2017

·         Led a team of 4 BI Analysts / Statisticians in development and support of Advanced (Predictive) Analytics Reporting system

·         Collaborated with business users to provide best solution and prioritize work effort for timely delivery 

·         Worked with members of ETL, BI, and DBA groups to develop optimal solutions

·         Designed, developed, and implemented SQL Server tables, views, stored procedures, triggers, and SSIS packages

·         Build and optimized SQL stored procedures to enhance performance

·         Designed and developed a Claims Scoring Model (analytical tool for identifying underperforming/high loss accounts for Marketing and Underwriting departments)

·         Designed and developed a Customer Service Scoring Model (analytical tool for Customer Service department)

·         Designed and developed an “Agency Profile” reporting suite (tracking distribution channel partner performance) for mobile devices

·         Designed and developed actionable analytics / data visualization for Customer Service and Agency Management

·         Designed and developed aggregated data sources (ODSs and IBM Cognos Framework Packages) for use in current/future predictive analytics

·         Developed visualization tools (IBM Cognos Active Reports/Workspaces) for direct self-service use

·         Developed proof-of-concept solutions and delivered technical feature demonstrations power users and BI developers

·         Reviewed, compared BI tools (IBM Cognos, SAP HANA/Lumira, Tableau) and presented recommendations to senior management

·         Managed on-shore / off-shore resources

 

PHILADELPHIA INSURANCE COMPANIES                                                                                                                         Bala Cynwyd, PA

BI Analyst, Advanced (Predictive) Analytics                                                                                                                            04/2010 – 01/2014

·         Implemented upgrade Cognos 8.4.1 to Cognos 10

·         Migrated reports and dashboards from Cognos 8.4.1 to Cognos 10 utilizing Lifecycle Manager

·         Administered Cognos including security and change management

·         Designed and developed framework models and packages, scorecards and dashboard reports

·         Collaborated with business users to provide best solution and prioritize work effort for timely delivery

·         Worked with members of ETL, BI, and DBA groups to develop optimal solutions

·         Designed and developed prototypes for Dynamic grouping and sorting in Cognos 10.1 Report Studio

·         Designed and developed Legal department Speed of Service dashboard utilizing Cognos 10.1 Report Studio

·         Optimized IT department Speed of Service dashboard for performance and maintenance

·         Supervised and led development of an “Agency Profile” application in Salesforce

·         Trained to BI Developers on Cognos 10.1 Report Studio and advance reporting techniques

·         Managed on-shore / off-shore resources

 

PHILADELPHIA INSURANCE COMPANIES                                                                                                                         Bala Cynwyd, PA

BI Team Lead                                                                                                                                                                                  05/2009 – 04/2010

·         Led a team of 8 BI Analysts in development and support of Corporate Reporting system

·         Coordinated weekly production releases for entire Corporate Reporting team

·         Created, modified, and deployed reports utilizing SQL Reporting Services

·         Designed, developed, and implemented tables, views, stored procedures, triggers, and DTS/SSIS packages

·         Provided off-hours production support

·         Generated ad-hoc reports for management utilizing SQL Reporting Services and Excel

·         Developed SSIS packages for data extract, transformation, and loading processes between SQL Server 2008, Excel, and flat files

 

SOLUTION JUNCTION, LLC                                                                                                                                                         Philadelphia, PA

Independent IT Consultant                                                                                                                                                           11/2008 – 05/2009

·         Provided application support using ASP.NET, VB.NET, and SQL Server 2000/2005

·         Converted/Reengineered web pages from HTML/JavaScript to ASP.NET/VB.NET solution

·         Development of data extraction, transformation, and loading processes between SQL Server, Excel, MS Access, and flat files

·         Designed, developed, and implemented databases using SQL Server 2000/2005. Created and modified tables, views, stored procedures, triggers, and DTS/SSIS tasks

 

HEFFLER, RADETICH & SAITTA, LLP                                                                                                                                    Philadelphia, PA

IT Consultant                                                                                                                                                                                   01/2008 – 11/2008

·         Identified, analyzed, and defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements

·         Generated ad-hoc reports for management utilizing SQL Reporting Services and MS Excel

·         Created and modified tables, views, stored procedures, triggers, and DTS/SSIS tasks on SQL Server 2000/2005

·         Performed data validation and analysis utilizing Visual FoxPro 9.0, TSQL, and SQL Reporting Services

·         Utilized SQL Scheduler for DTS tasks automation

·         Provided application support for Litigation and Tax departments using FoxPro 9.0, ASP.NET, VB.NET, and SQL Server 2000/2005

·         Developed data extraction, transformation, and loading processes between MS SQL, Visual FoxPro, Excel, and flat files using custom build applications utilizing SQL Server and Visual FoxPro

 

GMAC RESCAP - HOME CONNECTS LENDING SERVICES, LLC                                                                                        Horsham, PA

Technical Lead                                                                                                                                                                                10/2006 – 12/2007

·         Played significant role in project planning, execution, and monitoring

·         Managed team of four in development and automation of manual processes for Un-archiving, Creating, Statusing and Policy Issuance of orders.  Saved over 100,000 man/hours by issuing thousands of policies through process automations

·         Identified, analyzed, and defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements

·         Prepared business specifications including requirements documents, process workflow diagrams, functional specifications/business rules, screen requirements and screen layouts

·         Performed data mining, validation and analysis utilizing Business Objects, SQL Reporting Services, and MS Access 97/2003

·         Generated ad hoc queries and reports from multiple Universes using Business Objects

·         Designed ETL (data extraction, transformation, and loading) between dBase, Oracle, MS Access, and flat files using custom build applications utilizing MS Access 97/2003, MS Visual Basic 6.0, and MS Task Scheduler

·         Streamlined manual process by designing and implementing application for Secure HTTP POSTing of XML files to third party location utilizing Visual Basic 6.0

·         Redesigned and implemented legacy processes in Vision 3.0 using Eclipse 3.0 Java

·         Identified and presented strategic recommendations to Company’s President, CFO, and business partners

 

GMAC RESCAP - HOME CONNECTS LENDING SERVICES, LLC                                                                                        Horsham, PA

Lead Programmer / Analyst                                                                                                                                                          08/2004 – 10/2006

·         Prepared technical documentation based on business requirements and business process workflow diagrams

·         Performed data validation checks in Visual dBase 5.7/7.0, Visual FoxPro 6.0, MS Access 97/2003, SQL Server 7.0, and Oracle 8.0i

·         Designed, developed, and implemented databases using SQL Server 2000, Oracle 8i/10g, dBase 5.7/7.0, MS Access 97/2003. Created and modified tables, views, stored procedures, triggers in SQL Server 2000 and Oracle 8i/10g

·         Performed Oracle database data load from dBase, SQL Server, Oracle, FoxPro, MS Access, and flat files

·         Maintained and modified legacy applications utilizing Visual Basic 6.0, ADO, Visual FoxPro 6.0, MS Access 97/2003, Visual dBase 5.7/7.0, and Crystal Reports

 

DAVID’S BRIDAL                                                                                                                                                                          Conshohocken, PA

Lead Programmer / Analyst                                                                                                                                                          11/2000 – 04/2004

·         Led team of four developers in development of SOHO (Special Orders Home Office) application designed to track and modify special orders throughout fulfillment process, fully integrated with POS (Point Of Sale) system, IRS (Inventory Review System) application, and DBRS (David’s Bridal Reporting System) application

·         Designed and developed DBRS (David’s Bridal Reporting System) using Visual Basic 6.0, Crystal Reports 8.5, and SQL Server 2000

·         Developed applications utilizing Visual Basic 6.0, ADO, DTS, Visual FoxPro 6.0, Crystal Reports, SQL Server 7.0/2000, and DB2 database for Accounting, SOFO, Buying Office, and Transfer Office departments

·         Performed ETL (data extraction, transformation, and loading) between DB2, SQL Server, FoxPro, Excel, MS Access, and flat files using DTS, Informatica, custom build applications, and SQL Scheduler

·         Participated throughout all phases of Systems Development Life Cycle including Change Management

·         Maintained and modified existing applications for SOFO including TODP (Total Orders Demand Pool) application designed as fulfillment process for Special Orders

·         Converted applications from Visual FoxPro 6.0 with FoxPro Reports and SQL Server 6.5 to Visual Basic 6.0 with Crystal Reports and SQL Server 7.0/2000 for maintainability and enhanced security

·         Designed, developed, and implemented databases using SQL Server 7.0/2000 and DB2. Created and modified tables, views, stored procedures, triggers, and DTS tasks

 

FEDERAL RESERVE BANK OF PHILADELPHIA                                                                                                                 Philadelphia, PA

Lead Programmer / Analyst                                                                                                                                                          02/1998 – 11/2000

·         Designed, documented, and managed implementation of AIDE application for Accounting Department, utilizing Visual Basic 6.0, ADO, SQL Server 7.0, and Oracle 8.0

·         Developed applications utilizing Visual Basic 6.0, ADO, Visual FoxPro 5.0/6.0, SQL Server 6.5/7.0, and MS Access for Human Resources, Treasury Direct, and Accounting departments. Designed Check Stock Inventory System for Treasury Direct to control vault inventory of checks

·         Designed, developed, and implemented databases using Visual FoxPro 5.0/6.0, SQL Server 6.5/7.0, Oracle 8.0, and MS Access

·         Performed maintenance and modified existing applications for Accounting Department, including Fixed Assets application designed to track assets depreciation within Bank

·         Converted legacy FoxPro applications to Visual FoxPro 5.0/6.0 and SQL Server 6.5 for Y2K compliance and enhanced security, including Salary Planning System used by top executives and management throughout the Bank

 

DATA BASED INSIGHTS, INC.                                                                                                                                                         Langhorne, PA

Programmer / Analyst                                                                                                                                                                    11/1996 – 12/1997

·         Designed and implemented in-house applications for conducting survey research, including Frequency Report and Cross-Tabulation Report for major companies utilizing various versions of FoxPro and Visual FoxPro

·         Performed data scrubbing/manipulation, analysis of data (t-tests, z-tests, means, standard deviation), and report generation

·         Designed, developed and implemented databases using Visual FoxPro 5.0 and/or FoxPro 2.x

·         Utilized Excel, WinCross, SPSS, and SAS to complete various steps of complex data processing

 

EDUCATION                                                                                                                                                                                                                     

 

Drexel University                                                                                                                                                                                 Philadelphia, PA

Graduate courses in Engineering Management                                                                                                                                                          

 

Drexel University                                                                                                                                                                                 Philadelphia, PA

Bachelor of Science in Computer Science