We provide IT Staff Augmentation Services!

Database Design Resume

Norwood, MA

SUMMARY

  • Versatile Systems Professional with over twelve years experience within the IT industry.
  • Applies strong analytical skills in performance of Software Development and Business System Analysis functions.
  • Leverages strong software development background to solve business problems.

TECHNICAL EXPERIENCE:

Databases:

SQL Server, Oracle 9i, Sybase Adaptive Server

Languages:

Crystal Reports, SQL Server 2005 Reporting Services (SSRS), SQL Server 2005 Integration Services 2005 (SSIS), SQL Server 2005 Analysis Services, SQL, MS Access, Visual Basic 6, SQL Server Data Transformation Services, VBA

Software:

MS Excel, TOAD, MS Source Safe, MS Visio, MS Project, PVCS

PROFESSIONAL EXPERIENCE:

Confidential, March 2009 – August 2009
Norwood, MA
Database/Report Developer

Department of Transportation, State of MA (Client)

  • Developed stored procedures and reports to compare costs for construction projects that use civilian flaggers versus police officer details and conduct contract bid item analysis.
  • Designed and developed the data model, stored procedures and views for an ad hoc exception reporting solution for the Construction Projects department.
  • Modified an SSIS package to update an MS Analysis Services data cube that displays Federal Reimbursement information for construction projects.
  • Modified an MS Analysis Services data cube to display adjustments for Federal Reimbursement funds for construction projects.
  • Modified data model and built a new ad hoc report model and report for the HR department.
  • Made various fixes/modifications to the data mart nightly load cycle.
  • Created and updated user and technical documentation.

Confidential, June 2008 – December 2008
Woburn, MA
Consultant

Atlantic Trust Private Wealth Management (Client)

  • Managed the creation and execution of test scripts for impacted legacy systems.
  • Created SQL test scripts to verify expected results.

Confidential,Boston, MA January 2007 – June 2008
Officer

  • Wrote SQL queries to validate and stage test data for scenario testing.
  • Reversed engineered test databases to create ER diagrams.

Confidential,Boston, MA May 2004 – November 2006
Consultant

  • Automated and documented workflow of a manual data retrieval process developed for verification of Risk Reporting application calculations resulting in a significant savings of time executing calculations for testing purposes. Developed the process using Excel/VBA and SQL.
  • Created SQL queries and stored procedures to verify test results.
  • Worked with database architect to create new tables and stored procedures for migration to OIR Data Repository.

Confidential,Boston, MA December 2000 – March 2003
Senior Software Engineer

  • Designed and developed new reports for various shareholder reporting functions using stored procedures and Crystal Reports.
  • Developed, tested and implemented new functionality for uploading Excel files into database tables in the Tax Automation System.
  • Documented business requirements, workflow diagrams, coded and tested an interface application that converts and uploads text files for a Fund Reporting system that generates financial statements for mutual funds shareholder reports. Developed the application internally using Visual Basic 6, Excel 2000 and SQL Server 2000 resulting in overall cost savings.
  • Managed major application releases for the Tax Automation System.
  • Designed and implemented an automated SEC filling process for Fund Reporting using Excel and Visual Basic for Applications. This resulted in overall cost and time savings.

Confidential,Boston, MA March 1996 – December 2000
Senior Consultant
John Hancock Funds (Client)

  • Designed and created end-user reports using Crystal Reports and SQL Server 6.0 for an application which processed 401K administration information.
  • Developed reports and stored procedures for a Mutual Fund Compliance System using SQL Server 6.5 and Crystal Reports 6.0. Worked directly with end users to gather system requirements.
  • Developed stored procedures using SQL Server 6.0 for an application that tracked pricing for retirement plans.

State Street Research and Management (Client)

  • Developed an Enterprise-wide system that tracked and reported votes cast by portfolio managers, traders and security analysts. It was developed using SQL Server 6.5, Visual Basic 5.0 and Microsoft Access 97.
  • Designed/developed an application that was used as a research tool for security analysts using Excel 97, VBA and a third party research tool.
  • Migrated an application from Excel 5.0 /Access 2.0 to Excel 97/Access 97. The application updated prices in individual spreadsheets and created reports for security research. Responsible for design, coding and unit testing.

EDUCATION:

  • Masters Degree in Information Technology
  • Masters of Business Administration
  • Bachelor of Business Administration

Hire Now