Resume

Sign in

Engineer Developer

Location:
Newton, Massachusetts, United States
Posted:
November 06, 2018

Contact this candidate

Resume:

PETER M. ORKIN

Newton, MA

617-***-**** ac7mga@r.postjobfree.com

LinkedIn: goo.gl/e8GU14

DATABASE ADMINISTRATOR PROJECT MANAGEMENT DATABASE PROGRAMMING

Statistical Analysis Business Requirements Solution Focused

Analytical, detail-oriented Database Programmer highly regarded for requirements gathering, design, and development of applications to support business development initiatives for Dell EMC, EMC, and Fidelity Investments. Recognized as an analytical engineer with a proven track record of excelling at learning new technologies and successfully applying them to develop clean and well-structured code. Experienced at working on projects from initial idea and development phase (vision/analysis), performing all design/architecture work, and delivering the completed product. Known as a self-disciplined, highly organized professional with the ability to thrive in high-paced environments. Outstanding presentation and communication skills, and works exceptionally well individually as well as within a team environment.

SELECTED HIGHLIGHTS

Loaded more than 200 databases per week at Dell EMC, ensuring the data loaded accurately and completely.

Automated comparisons of Salesforce data with manually entered data to speed up analysts’ workflow 1000%

Supported more than 50 representatives while at EMC, including database backups, software development, support, and implementation.

Created a “go to” Tableau reporting display for sales for EMC, including month to date, year to date. TSQL and Sql Server used.

Automated partner adjustments process, saving 6 accountants many months of work.

Converted data for analysis by Mutual Funds Department for use in a campaign from a server to a desktop database environment at Fidelity Investments, netting the company more than $5 million.

CORE COMPETENCIES

Information Technology Conceptual Development Backups/Recovery

Database Language Development Performance Analysis High Availability

Process Improvement Enterprise-Wide Systems Replication

Design Specifications Quality Assurance Strategic Planning

Performance Development Testing Data Analysis

Database Security Technical Integration Project Scope

PROFESSIONAL EXPERIENCE

EMC Franklin, MA 8/2010 – 2/2018

Senior Database Administrator/Developer, Business Operations

Supported more than 50 representatives, including backups, software development, support, and implementation.

Salesforce and SQL Server: Created downloads from Salesforce to feed a daily reporting database, sending reports out to many reps. Attained a Federal clearance to enable access to the Federal side of Salesforce, enabling qualified users to attain Federal reports.

Developed a 24-hour, totally automated system, using the SQL Server ETL tool (SSIS) and TSQL as a “one-stop shop,” to track deal progress. Tableau dashboard published to server.

SME (Subject Matter Expert) on deal discounting universe in SAP Business objects. I created several daily reports for users and made decisions on data modeling in that SAP “universe”.

Established a more efficient method of discounting deals by converting to database from spreadsheets method of deal negotiation, increasing workflow efficiency by 100%, using Oracle 11g, PL/SQL, SQL Developer. Reporting by Tableau.

Designed a new Data Pump to supply data continuously to a global dashboard, to display deal progress to partners using ETL (SSIS SQL Server Integration services). SQL Server 2016.C# Visual Studio.

Designed reports in tableau, with data visualization, using information from Salesforce.

Grantham, Mayo, Van Otterloo and Co. Boston, MA 3/2009 – 8/2010

SQL Database Developer, Shareholder Services

Streamlined workflow to handle wire transmissions in and out of the company, increasing efficiency by 300%.

Created an automated writer to send information to trading desks via spreadsheets, summing dollars from trade desks and enabling the design of an automated writer system. C# used in SQL Server.

Added features to detect tampering or changes to trade-desk-bound spreadsheets to enhance security.

Fidelity Investments Boston, MA 4/1999 – 3/2009

Software Engineer

Converted data for analysis by Mutual Funds Department’s mainframe computer for use in a campaign to Oracle, using PL/SQL to support a sales campaign, netting the company more than $5 million.

Worked in the Call Center for US, creating a tracking program for reps utilizing SQL Server, placing info on sharepoint for managers.

Created an automated “spreadsheet crawler” reading thousands of spreadsheets, converting retirement analytics to a database environment, and prompting the company to advertise a person’s aspects for retirement, which is still shown on TV as an ad.

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

EDUCATION

Tufts University, Medford, MA

Bachelor of Science – Electrical Engineering, Minor in Biology (pre-med)

TECHNICAL SKILLS

Databases: Microsoft Access all versions, Microsoft SQL Server 7.0/2000/2005/2008/2012/2014/2016, Oracle 11g,12c, Mongo DB

Operating System Platforms: Win 7, Win 10

ETL/Reporting: SAP Business Objects, Salesforce, SQL Server DTS, SSIS, SSRS, SSAS, Tableau 9.0, Tableau administrator Power BI, Salesforce, SQL Developer(Oracle), Visio

Languages: Visual Basic, Visual C#, PL-SQL, VBA, Transact-SQL, Python 2.7/3.4, Java, OBIEE,MDX,DAX

Integrated Development Environment: Visual Studio (all versions through 2017), Anaconda(Python), Intellij idea(Java),Toad, SQL Developer

Utilities: Microsoft Project, Microsoft Office (Word, Excel, PowerPoint, Outlook)

ADDITIONAL CREDENTIALS

HONORS AND AWARDS EMC excellence Award (2x Winner)

ORGANIZATIONS IEEE society for Electrical engineers

INTERESTS Golf

Detailed Professional References Available upon Request



Contact this candidate