EMPLOYMENT:

Confidential, Miami, FL

Sr.SQL/SSRS Developer

Responsibilities:

• Responsible for analysis, design, development, and deployment of financial reporting for a business software development company with clients in the private equity market. Write complex stored procedures to source reports.
• Troubleshoot performance and other issues with existing reports and stored procedures.
• Work with clients and internal team members to gather requirements and design specifications.
• Utilized skills in SSMS, SSRS, T - SQL, SharePoint, Microsoft Dynamics NAV, and TFS.

Confidential, Hingham, MA

Business Intelligence Developer/Analyst

Responsibilities:

• Responsible for analysis, design, and development of IT infrastructure needed to automate the processing of insurance claims.
• Translate written requirements into effective solutions.
• Communicate questions or issues with team members and business users.
• Unit testing and debugging of advanced project solutions.
• Troubleshoot defects and/or provide modifications to complex scripts involving the processing of Medicare claims.
• Develop enhancements to existing MS Access/VBA applications.
• Become proficient in the business software development processes, rules, and guidelines.
• Development utilized Visual Studio, SSMS, SSIS, SSRS, C#.Net, T-SQL, VBScript, and TFS.

Confidential, Boston, MA

Business Intelligence Developer/Analyst

Responsibilities:

• Develop ETL processes, reports, stored procedures, and scripts for the finance department of a global law firm.
• Build SSIS packages to transform, aggregate, and partition data into staging tables for reporting.
• Debug performance issues with existing SSRS reports by optimizing calculations and data flows.
• Provide the analysis, design, and developments skills needed to translate mock draft business reports into the stored procedures and data sources needed by custom reports and dashboards.

Confidential, Burlington, MA

Business Intelligence Developer/Analyst

Responsibilities:

• Responsible for analysis, design, and development of reporting needs for an industry leading laundry and air vending services company.
• Creation of new reports and enhancements/troubleshooting of existing reports utilizing the Microsoft BI stack (SSRS, SSIS, and SSAS).
• Write, maintain, and provide performance tuning to reporting sources in the data warehouses including parameterized stored procedures from large datasets, T-SQL, ETL processes, VB.Net and multidimensional data models (cubes, MDX queries).
• Use report visualization tools to build maps with account types, sales performance, and locations.

Confidential, Cambridge, MA

Database Developer

Responsibilities:

• Design, develop, and implement database systems using MS Access 2013, SQL Server 2014, VBA, SSIS, and T-SQL.
• Build modules to migrate and reconcile data from third party systems.
• Work with faculty and staff on solutions to various analytics.

Confidential, Hingham, MA

Sr. Systems Programmer/Analyst

Responsibilities:

• Develop, implement, and support database applications using SQL Server 2008-14, Business Intelligence Development Studio, Visual Studio, T-SQL, SSRS, SSIS, MS SharePoint, MS Access, MS Excel, VBA, and VBScript.
• Provide support to business areas companywide in the remediation of MS Access 2000-2003 database applications for an upgrade to Windows 7/MS Access 2013.

Confidential, Hingham, MA

Sr. Systems Programmer/Analyst

Responsibilities:

• Develop, implement, and support databases and desktop applications for health insurance claims operations using SQL Server 2008, T-SQL, SSRS, SSIS, MS Access, VBA, ADO, VBScript, and Visual Studio.
• Worked with business stakeholders and end users to troubleshoot issues.
• Prioritize work on multiple projects and/or issues.

Confidential, Boston, MA

Programmer/Analyst

Responsibilities:

• Develop applications related to workforce/project management using MS Access, MS Excel, MS Visio, VBA, ADO, and SQL which imported data from external sources, automated reporting, and processed user input.

Confidential, Westwood, MA

Sr. Programmer/Analyst

Responsibilities:

• Enhancements to existing application used in the administration of a network of electrical circuits using VB 6.0, Oracle 11, SQL Navigator, and MS Excel.
• Develop an upgrade of the application using VB.NET and ADO.NET.

Confidential, Boston, MA

Programmer/Analyst

Responsibilities:

• Develop applications to import external data into data warehouse, automate financial reporting, and process user input using MS Access, MS Excel, Essbase, VBA, ADO, MS SQL Server, stored procedures/functions, SSIS, VB.NET, ASP.NET, ADO.NET, AJAX, CSS.
• Designed Business Objects universes mapped to the data warehouse to provide end user objects relevant to business environment.
• Developed and published complex BO Web Intelligence reports to analyze data from multidimensional sources.

Confidential, Cambridge, MA

Application Developer

Responsibilities:

• Enhancements and maintenance of existing drug development tracking application using VB 6.0, ADO, MS SQL Server, and stored procedures/functions.
• Work performed on a part time basis.

Confidential, Boston, MA

Sr. Visual Basic Programmer

Responsibilities:

• Develop applications to support the fund reporting of an asset management company using VB 6.0, Visual Source Safe, Active Reports, Eagle Pace, MS Access, DAO, ADO, and SQL.

Confidential, Cambridge, MA

Application Developer

Responsibilities:

• Develop a tracking system to manage projects, activities, and resources related to the preclinical and clinical stages of drug development using VB 6.0, ADO, MS Access, SQL, and Crystal Reports.

Confidential, Boston, MA

Programmer/Analyst

Responsibilities:

• Develop an application to automate the import and export of project tracking report data using MS Access, MS Excel, VBA, SQL, and ADO.

Confidential, Boston, MA

Programmer/Analyst

Responsibilities:

• Analyze existing query application and business needs of a large life insurance company.
• Develop an application to build and execute custom queries using MS Access, VBA, ADO, SQL Server, SQL, and T-SQL.