Resume

Sign in

Developer Data

Location:
Toronto, Ontario, Canada
Posted:
February 09, 2018

Contact this candidate

Resume:

Gary S. Love

**** **** **** ***** ********, NJ 08512 • 732-***-**** • ac4euz@r.postjobfree.com

CERTIFICATIONS

MCP - Microsoft Certified Professional

MCSA - Microsoft Certified Solutions Associate - SQL Server 2012

PROGRAMMING LANGUAGES

Transact-SQL • Lotus Script • Notes Formula Language • JavaScript • HTML

KEY SKILLS AND COMPETENCIES

Attention to detail and ability to work in a fast, time sensitive environment

Experience with MS-SQL Server Management Studio 2014, Microsoft Visual Studio 2012,

MS-Excel 2007/2010/2013, MS-Word 2007/2010/2013, and MS-PowerPoint 2007

Lead developer for creating and maintaining Lotus Notes Applications from 2008 to 2014

PROFESSIONAL EXPERIENCE

ANGUS ENERGY – Langhorne, PA – SSIS \ SQL Developer Sep. 2017 – Jan 2018

A privately-owned analytics company providing business intelligence solutions for their heating oil customers.

Provided internal and client facing support in revising SSIS packages and utilizing SQL Server Profiler for troubleshooting T-SQL stored procedures.

Optimized T-SQL stored procedures by analyzing execution plans, reevaluating indexes and replacing sub-queries with inner joins as needed.

VETSTREET – Feasterville-Trevose, PA – SSIS \ SQL Developer Jun. 2017 – Sep. 2017

A publicly owned company providing veterinary practices with a better way to communicate with pet owners.

Developed various functions in SSIS using C# coding which applied data transformations from data coming from Postgres tables going to Oracle staging tables.

Created SQL Stored Procedures using Oracle SQL Developer which would copy data from the staging tables to the destination tables during the daily ETL process.

Good understanding of Software Development Life Cycle using Agile Methodologies (JIRA),

ASEMBIA – Florham Park, NJ – SSIS \ SQL Developer \ Data Analyst Nov. 2016 – May 2017

A privately-owned company which develops management solutions for the specialty pharmaceutical industry.

Developed ETL mappings in the form of SSIS Packages to pass parameters to the T-SQL stored procedure which would query specific data from the SQL DB, and then export to Excel for analysis.

Converted FoxPro script to T-SQL stored procedures.

Composed T-SQL scripts which would automate the data cleansing tasks.

Utilized SSIS to create pipe delimited files from Excel files which were used as final reports.

Streamlined the T-SQL stored procedures by utilizing temp tables, then provided a process in SSIS to handle temp tables.

Gary S. Love Page 2

DERMARITE, LLC – North Bergen, NJ – Lead SQL Developer Apr. 2016 – Nov. 2016

A privately-owned manufacturing company providing high quality products for skin and wound care.

Visualized and created a Relational Database Management System (RBDMS) in T-SQL consisting of a 3 schema table structure: Customers, Sales, and Transactions.

Composed multiple ETL procedures using packages created in SSIS which automated the importing, formatting and cleansing of raw data directly from Excel spreadsheets.

Developed Stored Procedures in T-SQL which manipulated and then copied the data from the Staging tables to the Sales invoice table.

Created T-SQL Views which presented current Sales and Customer data resulting from a series of inner and outer table joins.

CHECKPOINT HR – Edison, NJ – SQL Developer \ Data Analyst Nov. 2015 – Mar. 2016

A privately-owned HR consulting company providing benefits management solutions.

Composed and maintained T-SQL scripts, indexes, and complex queries for data analysis and extraction.

Formatted and cleansed the extracted data from the Checkpoint HR data warehouse utilizing the advanced functions of MS-Excel.

BINSKY AND SNYDER, LLC – Piscataway, NJ – SQL Developer \ Data Analyst Jul. 2015 – Oct. 2015

A privately-owned HVAC/Plumbing repair company.

Created a T-SQL View that retrieved job cost and open purchase order values and then designed a user interface in Excel that was connected to the view which utilized the “Index and Match” functions for dynamic lookups.

Created and executed T-SQL query and update statements in the production environment to meet user demands.

Produced interactive dashboard applications using business analytics software: “Qlik Sense”.

Worked with users and the vendor to improve the overall user experience with the relational database system.

EDUCATION

Certificate of Completion 20463: Implementing a Data Warehouse with MS-SQL Server 2014

NetCom Learning, New York City, New York

Certificate of Completion 20462: Administering MS-SQL Server Databases 2014

NetCom Learning, New York City, New York

Certificate of Completion 20461: Querying Microsoft SQL Server 2014

NetCom Learning, New York City, New York

A.A.S. Computer Information Systems

DeVry Institute, North Brunswick, New Jersey

B.S. Industrial Studies and Technology

Montclair State College, Upper Montclair, New Jersey

HONORS

Phi Theta Kappa - September 1997



Contact this candidate