Senior Consultant Resume , Franklin, MA - Hire IT People

SUMMARY:

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.
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 within a team environment and individually.
Loaded more than 200 databases per week at Confidential, 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 Confidential, including database backups, software development, support, and implementation.
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 Confidential, netting the company more than $5 million.

TECHNICAL SKILLS:

Databases: Microsoft Access all versions, Microsoft SQL Server 7.0/2000/2005/2008/2012/2014 , Oracle 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

Languages: Visual Basic, Visual C#, VBA, Transact-SQL, Python 2.7/3.4

Integrated Development Environment: Visual Studio (all versions through 2017)

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

CORE COMPETENCIES:

PROFESSIONAL EXPERIENCE:

Confidential, Franklin, MA

Senior Consultant

Responsibilities:

Load more than 200 databases per week, ensuring the data loads accurately and completely.
Automate comparisons of Salesforce data with manually entered data to speed up analysts’ workflow by 1000%.
Design 10 new reports to provide more accurate representations of current business environment and to aid in decision-making activities.
Design, document, and promote security "best practices," policies, standards, and protocols.
Suggest and implement backup strategies to increase overall productivity by 500%.

Confidential, Franklin, MA

Senior Database Administrator

Responsibilities:

Supported more than 50 representatives, including backups, software development, support, and implementation.
Automated partner adjustments process, saving 6 accountants many months of work.
Supported and developed 50 new reports, providing users with drill downs and what-ifs for more targeted reporting.
Developed a 24-hour, totally automated system, a “one-stop shop,” to track deal progress.
Established a more efficient method of discounting deals by converting to database from spreadsheets method of deal negotiation, increasing workflow efficiency by 100%.
Designed a new Data Pump to supply data continuously to a global dashboard.

Confidential, Boston, MA

SQL Database Developer

Responsibilities:

Implemented 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.
Added features to detect tampering or changes to trade-desk-bound spreadsheets to enhance security.

Confidential, Boston, MA

Software Engineer

Responsibilities:

Converted data for analysis by Mutual Funds Department for use in a campaign from a server to a desktop database environment, netting the company more than $5 million.
Developed a custom automated report system for company’s branches to allow tracking of 50 representative metrics, with several versions implemented.
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.