Resume

Sign in

Electrical Engineering Sql Server

Location:
Hopkinton, Massachusetts, United States
Posted:
January 26, 2017

Contact this candidate

Peter Orkin

*** ****** **., ******, ** 617-***-**** acyhri@r.postjobfree.com

Profile

Analytics, technology, database and business professional. Expert knowledge of large dataset management and reporting. Well versed in the entire application lifecycle. Specialist in database design and data modeling.

Computer Skills

LANGUAGES

Visual Studio all versions through 2015, Visual Basic, Visual C#, VBA, Transact-SQL, Python 2.7, Python 3.4

DESKTOP DATABASE

Microsoft Access(all versions through 2016)

ENTERPRISE DATABASE

SQL server(7.0,2000, 2005, 2008, 2012) Oracle 11i, 12c, Mongo DB

ETL/REPORTING:

SAP Business Objects, Salesforce

SQL Server DTS, SSIS, SSRS, SSAS, Tableau 9.0

Experience

SENIOR DBA/DEVELOPER EMC, FRANKLIN, MA. AUGUST 2010-PRESENT

Support 50+ reps, including backups, software development, support, and implementation.

Developed a 24 hour, totally automated system with ETL, TSQL, and SQL Server to create a portal, a “one stop shop” called the War Room to track deal progress.

Created a spreadsheet- centric automated discounter for selling products.

Converted discounter to an Access database used by over 80 people.. Workflow efficiency increased by 50%. This system was developed in Access with VBA utilizing Outlook to automate sending emails.

Created a spreadsheet- centric automated discounter for selling products.

Designed a new datapump to supply data continuously to a global dashboard in Tableau.

SQL DATABASE DEVELOPER-SHAREHOLDER SERVICES GRANTHAM, MAYO, VAN OTTERLOO AND CO.; BOSTON, MA SEPTEMBER 2009-MAY 2010

Developed more efficient workflow to facilitate handling wire transmission in and out of the company.

Developed automated spreadsheet writer to send information to trading desks via Excel spreadsheets, constructed with VBA code to sum dollars from trade desks, enabling design of an automated writer system. Features added to detect tampering or changes to trade desk-bound spreadsheets to enhance security.

SOFTWARE ENGINEER FIDELITY INVESTMENTS, BOSTON, MA 1999-2009

Developed custom automated report system for company’s branches to allow tracking of reps in many different metrics. Several versions have been developed with this process.

Converted data for analysis by Mutual Funds Department from Oracle/TSO databases to Access for use in campaign by reps. This new process netted the company several million dollars.

Created an automated “spreadsheet crawler” reading thousands of spreadsheets, converting FIRSCO Retirement Analytics to a database environment. This development prompted Fidelity to advertise a person’s aspects for retirement still shown on TV as an ad.

Automated the tax withholding process utilizing Python to “read” tax return documents.

PROGRAMMER AND DATA ARCHITECT JOHN HANCOCK FINANCIAL SERVICES/HANCOCK TIMBER RESOURCE GROUP, BOSTON, MA 1994-1999

Simplified the complicated process of pricing property through the use of a simple and intuitive graphical user interface.

Created the industry’s first integrated 50 year discounted cash flow model with Access database system including custom reporting. All acquisitions and owned properties ($6 billion dollars) assessed with this model. Over fifty users.

Education

BACHELOR OF SCIENCE IN ELECTRICAL ENGINEERING, TUFTS UNIVERSITY, MEDFORD, MA

Major: Electrical Engineering

Minor: Biology(premed)



Contact this candidate