Technical Strengths

Project Management Lifecycle Advanced MS Excel Data Mining & Cleansing

High Volume Databases Extract, Transform, Load (ETL) Strong Analytical Skills

Presentations & Promotions Total Quality Management (TQM) SQL Query Optimization

SQL Server Database Management System (DBMS) Data Models

Continuous Process Improvement Team Building, Leadership & Motivation Internet Marketing

Technical Proficiencies

Certifications:

Microsoft Certified Professional; Microsoft 70-461: Querying Microsoft SQL Server 2012; Microsoft 70-462: Administering Microsoft SQL Server 2012; Certified Associate Project Manager (CAPM)

Platforms / OS:

Windows (All); Android

Languages & Frameworks:

HTML; CSS

Software, Tools & Protocols:

WinSearch; SharePoint; SAP; WordPress; SFTP; MS SQL Server 2012; MS Visio; OSIsoft PI Webparts; GIS viewer; PI Manual Logger; Systemigrams; Command Line; MS Office Suite (Access & Advanced Excel); MS Visual Studio; SQL

“…A loyal employee…detail oriented while working with clients…proactive to understand their requirements and assist with troubleshooting any issues…[works] on multiple projects at a time...good at thinking outside of the box.”

~ Supervisor, V12 Group

Professional Experience

PSEG LONG ISLAND – Hicksville, NY Diversified Energy Utility Company 10/2016-06/2017

Analyst (Contract Position)

Hired to develop SharePoint site necessary to report and display PSEG equipment data and specifications to internal end-users. Worked with DBAs to troubleshoot, debug and optimize SQL server and database issues to ensure projects adhered to time / cost / quality constraints.

Key Projects & Accomplishments:

Developed multipage SharePoint site displaying real-time PSEG equipment maintenance data and specifications for use my internal end-users working across multiple teams.

Project entailed SQL querying, writing and troubleshooting stored procedures, functions and queries

Debugging and optimizing queries on a MS SQL Server 2012 database, OSI PI Server and OSI PI Web Parts.

Altered SharePoint site writing code in HTML, JavaScript and CSS.

Ran queries in SAP and MS Access to maintain equipment and create reports for use by management.

Used MS Visio to create 100+ page documentation for SharePoint end-user manual incorporating data flow and process diagrams.

V12 GROUP, INC – Red Bank, NJ Data and Cross-Channel Digital Marketing Services Firm 02/2014-05/2016

Data Analyst

Processed just-in-time (JIT) orders for email marketing campaigns for this data and cross-channel digital marketing services company. Used advanced SQL query techniques on high volume databases in a MS SQL Server 2012 database to support revenue growth, with some accounts in excess of $1M dollars creating Excel and Ad Hoc reports.

Key Projects & Accomplishments:

Played key role optimizing and standardizing order processing by creating SQL scripts using advanced querying.

Enabled client data to be returned in a consistent manner, minimizing end product deviation and increasing quality.

Helped account managers secure accounts valued at $1M+ by providing initial data test sets.

Performed data cleansing of SQL server databases, incorporating over 100 million records.

Executed ETL operations using Microsoft Visual Studio, command line, raw text files and Excel.

ENERGIME Alternative Energy Consulting Firm New York, NY Part-time 08/2012-05/2013

Operations / Sales Analyst

Researched, evaluated and qualified 50-60 client leads daily via phone, email and internet search, through cold calling and sales lead follow up, to increase sales of company’s renewal energy system solutions as well as provided customer service.

COMPLIANCE INSIGHTS, LLC News Aggregator Website New York, NY Part-time 08/2011-05/2012

Database Analyst

Created internet user database from Web research. Maintained Constant Contact database; performed data cleansing. Used MS Excel 2010, Google Analytics and Constant Contact software application to determine user trends and click rates supporting sales and email marketing campaigns.

Key Projects & Accomplishments:

Assembled database of 10,000+ potential customers.

Grew efficiency and revenue by performing data entry, ETL and data cleansing.

WALL STREET OPTIONS, LLC Executive Search Firm New York, NY 09/2008-07/2011

Director of Database Research

Developed Winsearch database to help recruiters find and place candidates. Worked with external IT vendor to support hardware and software equipment and resolve issues affecting database and servers.

Key Projects & Accomplishments:

Increased database size by 100,000+ potential candidates.

Trained and managed 1-6 interns on database, maintenance and research to support recruitment efforts.

Education and Credentials

MBA in Operations Management and Computer Information Systems Baruch College Zicklin School of Business, New York, NY - May 2013

Award for highest GPA in major

Inducted into management honor society

BA in Political Science University of California – los angeles, Westwood, CA - June 2004

Professional Development MCSA Microsoft SQL Server 2012 Oracle DBA Track 11G

Professional Membership Institute of Electrical & Electronics Engineers (IEEE)

Presentation / Publication

Wenger, N. (June 2013). System of Systems Engineering of the International Space Station. Academic paper presented at the IEEE SoSE Conference, Maui, HI. Paper later published and cited in IEEE library

Contact this candidate