SENIOR PROGRAMMER Resume BROCKTON, MA - Hire IT People

SUMMARY

Accomplished Database Developer with experience supporting the full systems development life cycle (SDLC).
Proficient in Relational Database design and development (Oracle and SQL Server) including SQL Queries, PL/SQL, Packages, Functions, Procedures, Triggers, Views, Indexes, Interfaces and Data Conversion.

TECHNICAL SKILLS

DBMS: MS SQL Server 2008/2012/2014 , Oracle 9i/10g/11g, DB2, Access

TOOLS: SQL Plus, SQL*Loader, Toad, SQL Query Analyzer, Crystal Reports, Management Studio (SSMS), Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), Visual Studio, ETL, Excel

LANGUAGES: SQL, T - SQL, PL/SQL, HTML, XML, C#, Java, Shell Script

PROFESSIONAL EXPERIENCE

Confidential - BROCKTON, MA

SENIOR PROGRAMMER

Responsibilities:

Mapped and imported data from various clients into MySQL. Created extracts and Crystal Reports.
Developed new reports and report enhancements using Crystal Reports integrated within their E2 ERP application.
Created stored procedures from ERP database on SQL Server 2014 for Crystal Reports data source.

Confidential - NEEDHAM, MA

DATABASE DEVELOPER/CONTRACTOR

Responsibilities:

Maintained SSIS ETL and monitored data loads of EHR healthcare data from various sources for the Revenue Cycle in the Affiliated Physician’s Group (APG).
Created stored procedures and SSRS reports to summarize EHR healthcare and financial data using SQL Server 2008.
Wrote DDL to generate database tables, relationships, and triggers on SQL Server 2012, along with participating in database design for development of Application Management System which will maintain information to monitor and communicate results of custom applications.

Confidential - MARLBOROUGH, MA

SQL REPORT DEVELOPER/CONTRACTOR

Responsibilities:

Created both the stored procedures and SSRS web-based dashboard reports with embedded matrixes, sub reports, chart reports, graphs, drill down and drill through functionality. The dashboards reflect summarized rolling MTD data from their newly implemented Infor SyteLine ERP application.
Generated the rolling MTD Sales Dashboard which summarizes sales data for each sales representative at various levels across multiple locations. Embedded graphs reflect breakdown by location with drill-through to sales representatives MTD, including drill-down to sales representative detail by day and by sales order.
Generated the rolling MTD Production Dashboard which summarizes orders, work-in-process, total jobs costs with sales data across multiple locations. Embedded graphs reflect breakdown by location with drill-through to job costs MTD, including drill-down to order and work-in process detail by day and by job order.

Confidential - WATERTOWN, MA

SQL DATABASE DEVELOPER/CONTRACTOR

Responsibilities:

Configured and maintained ETL packages for Enterprise Technical Solutions group using SQL Server 2008, SSIS and SSRS. Created corresponding schedules on SQL Agent.
Developed and maintained stored procedures and functions on SQL Server 2008.
Designed and developed database and procedures to import resale invoices from third party, generate EDI X12 payment file by due date, and report on current activity and balances. This used SQL Server, SSIS, and SSRS.
Designed and developed initial database releases of both Broadband application and Sales Leads Portal on SQL Server which entailed Physical and Logical Designs, including development of Database Schemas, Entity Relationship Diagrams, Table Normalization, Data Modeling, Data Mapping, Table Creation, Stored Procedures, Functions, Constraints, Indexes, Views and complex SQL statements.
Coded database enhancements for Rocklog and Cornerstone applications, along with various portals, on SQL Server and Oracle RDBMS.

We provide IT Staff Augmentation Services!

Senior Programmer Resume

Brockton, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship