SUMMARY:

• Senior SQL Developer and DBA seeking to assist an organization that needs skilled technical leadership in administration development configuration and tracking of projects: strategic planning, building and validating automated data ETL and reporting systems.
• Customer focused and inspirational team leader. Ideally suited to direct development and manage information systems and their application to many industries including retail, finance, healthcare and manufacturing.
• To implement projects based on the functional requirements of the users. To inspire IT teams to develop for the database user community systems and applications designed to meet company goals and objectives.
• Worked closely with members of NESQL including Brent Ozar to perfect query tuning, indexing, and performance trouble shooting methodologies.
• Patched together an ERP like system with separate applications using at first flat file interfaces to pass “souce of truth” data to other systems to avoid double entry at Confidential .
• Later built Data warehouse fed from Oracle & SQL by SSIS ETL with Qlikview Front end Dashboard and SSRS reporting server.
• Contracted as SQL Development to fix webservices application at Confidential a Financial Services company in Woburn, MA which specializes in earnings reports and predictions.
• Senior SQL devloper I converted DTS to SSIS monitored and trouble shoot sync between data warehouses and scripted new backup methodoly for 50+ SQL instances.

TECHNICAL SKILLS:

• SQL7/SQL Server 2000/05/08 R2/12/14
• NT/ 2000/2003/2008 R2/2012 MS Office
• ETL DTS & Stored Procedures
• MS Exchange,IBM DB2
• ODBC OLEDB Database connectivity
• JavaScript, HTML,XML,ASP,AJAX
• MS Share Point Web Services & Portal Server
• ASP,VB.NET,C#
• SQL Reporting Services,SSIS,SSAS
• Project management, Web Developer
• Adobe PDF Reports
• Linux Asterisk Trixbox,MySQL,PHP
• Active Directory/Server builds/Virtual
• Oracle 11g DBA/ Developer, APEX

PROFESSIONAL EXPERIENCE:

Confidential, Canton, MA

Senior Data Warehouse and Business Intelligence Developer

Responsibilities:

• This position requires in - depth knowledge of the core concepts of data warehousing and business intelligence reporting and analytics.
• This is an end to end data solutions delivery position which includes hands on ETL development, hands on report development, data analysis and delivery, and production environment management of delivered solutions.
• Updated old data warehouses and incoporated into new 2017 system.

Confidential, Watham, MA

Sr. SQL developer

Responsibilities:

• Developed ETL procedures using SSIS - a very robust and repeatable method of ETL.
• I have built SSIS jobs in organized and disorganized environments in SQL 2008, R2, 2012.
• Developed complex reports using SSRS .
• I worked with many customers to develop SSRS reports to meet all types of delivery, design, security configuration. SQL Query Tuning - regularly used a number of tools from Disk I/O in Perfmon to SQL
• Estimated and Actual Query Execution Plans to Extended events in SQl2 2012.
• Tuned indexes, updated security, and scripted a backup and auto verification of backup files in t-sql (Mass Medical Society)

Confidential, Boston, MA

DBA\Analyst\SQL Architect

Responsibilities:

• Supporting development and operation of 21 production MS SQL/Oracle servers and a SQL data warehouse. 150 databases >1TB total data.Additionally as DBA/Data Warehouse Manager administered 2 Sybase,1SIR,1 PerSe, 3 MySQL Asterisk PBX systems.
• Develop databases and datawarehouse as needed.
• Develop custom web reporting apps for researchers, art curator, locksmith.
• Build and update database applications and interfaces such as Kronos, ADP, ANSOS, Meditech, HRsystems. Manage application vendors and developers.
• Utilized SSIS SSAS and SSRS to move pay dollar and hour reports to intranet secured through active directory.
• Automated the file management, database backups, checkdb, and index rebuilds through sql jobs. Presented “BI on a Budget” at SQL Saturday #71 Boston

Confidential, Hingham, MA

WEB developer

Responsibilities:

• Coded a solution for logging the publics use of a customers webservices in one day and have since been retained by this customer to design and implement a replication solution for their remote hosted SQL servers.
• Assisted another Confidential to Fidelity on Javascript and ASP solutions for a custom web application.
• Built and hosted complete web site for grocery & liquors client
• Speed up a financial services clients web application with cutting edge java applet and SQL stored procedures(4min upload now 17sec), consulted on AJAX and other development issues.
• Worked closely with customer to build custom web based dashboard and reporting system with interfaces to ADP payroll Studio Plus etc
• Built and hosted website for Private Investigator Firm’s online background search tools.

Confidential

Open Source Telecom Engineer

Responsibilities:

• Installed and setup Trixbox Asterisk PBX. Showed Client how to configure SIP phones and ZAP IAX2 and SIP Trunks.
• Expanded Legacy NEC NEAX 2400 PBX using PTR card and T1 Sangoma interface to Trixbox.

Confidential Solutions consulting as

VS.NET developer

Responsibilities:

• Took over development of a kiosk based web application for recording employees work detail.
• I worked out all the bugs added functionality and supported the release of the project.

Confidential

SQL developer

Responsibilities:

• Designed, built, and supported the SQL back-end and XML data connectivity for an online Mastercard survey through 1st release.
• Succesfully finished the project even though key people had bailed out.(Aberdeen)

Confidential

DBA/Web developer

Responsibilities:

• Recently consulted as SQL Architect at major business intelligence firm in Boston and assisted with web application development there.
• The project - a great success - was an online survey that generated a cost savings report from my database.
• I wrote all the logic into SQL stored procedures, some math into calculated columns and some math in triggers.
• I used Macromedia Dreamweaver MX 2000 then half way through the project upgraded to Dreamweaver version 8 to code hidden server side include files in VBscript to call the SQL stored procedures and read from the SQL views.
• I coded some of the client side javascript mostly for URL encryption and number formatting and HTML email generation.
• We were 3 on the team me the backend programmer, an analyst who provided the content in an Excel spreadsheet, and a Flash programmer who coded the UI.
• We all worked hard and got along great and delivered a beta to a happy customer in just 6 weeks.(Aberdeen)

Confidential

SQL 2000 DBA

Responsibilities:

• A customer had a remote hosted SQL Server and needed some databases moved - I scripted them and their data and copied them to a new location then I used a compare tool to check it.
• I made SQL Queries, Views and showed client how to use the SQL Query Analyzer to edit and produce ad hoc reports on their newsletter subscribers’ list. (Aberdeen)

Confidential

ASP.NET developer

Responsibilities:

• Studied ASP that generates PDF forms. Showed a potential client a web page form could take the data entered and generate a PDF with that data and include pictures and fonts links and backgrounds.