We provide IT Staff Augmentation Services!

Sql Server System Data Integrator And Report Developer Resume

South Windsor, CT

CAREER SUMMARY:

I am an accomplished Database and Systems Designer, Data Modeler, Data Analyst, Business Intelligence Specialist, and Report Writer with over 20 years of experience in developing systems for several business sectors in the Connecticut area including Health Care, Insurance, Banking/Financial and Government Contractor firms. I am a dynamic, detail - oriented systems professional known for delivering high quality database and B.I. application solutions and designing and building complex database solutions and multi-dimensional Data Warehouse Systems.

PROFESSIONAL EXPERIENCE:

Confidential 

South Windsor, CT

SQL Server System Data Integrator and Report Developer

I worked as the technical lead and database developer on the "Operational Excellence" computer Inventory and Reporting System. This involved coordinating and integrating data from different Confidential Systems and database into a new database to track, record, and report on computer inventory and software compliance. I also created a new database and tables for this data and wrote ETL (Extract Transform and Load) scripts, as well as creating complex reusable SQL Queries and Report Programs. Software Utilized: Microsoft SQL Server 2012, SSIS, SSRS Access, ANSI SQL, Excel, Microsoft Office Suite

Confidential

Hartford, CT

SQL Server System Data Integrator and Report Developer

I worked as the technical lead on the "Healthiness Together" Employee health incentive system. This involved coordinating and integrating data from different Hartford Hospital Systems into a new database to track, record, and report on Employee's compliance with Wellness incentives and determine qualifications for financial rewards based on the completion of wellness based incentive activities. I wrote extensive ETL (Extract Transform and Load) scripts, as well as creating complex re - usable SQL Queries and Report Programs.

Software Utilized: Microsoft SQL Server 2012, Access, ANSI SQL, Excel, Microsoft Office Suite

Fallon Community Health Plan

Worcester, MA

SQL Server System and Report Developer

  • Met with business users to gather and document their requirements for changes and corrections to production reports that had errors.
  • Corrected Crystal Reports with SQL/Oracle backend databases to correct errors and enhance them according to business requirements.
  • Developed complex SQL and stored procedures to extract data from the databases, and created extract files and reports to deliver data to the business users.

Software Utilized: Microsoft SQL Server 2010, ANSI SQL, Oracle10G, Crystal Reports, Excel, Microsoft Office Suite.

Confidential

East Hartford, CT

SQL Server System and Report Developer

  • Met with business users to gather and document their requirements for data from various sources and systems from within the organization to be and loaded into databases for corporate security analysis and reporting.
  • Created databases, tables, and ETL processes to house corporate data to meet the corporation’s business requirements.
  • Developed complex SQL queries and stored procedures to extract data from the databases, and create extract files and reports to deliver data to the business users.

Software Utilized: Microsoft SQL Server 2005, 2008, 2010, ANSI SQL. Crystal Reports, Excel, Microsoft Office Suite.

Confidential

Bloomfield, CT

Senior Programmer/Analyst

  • Developed complex programs to extract data from DB2 databases, create extract files and Excel files using SAS.
  • Analyzed programs that other programmers wrote and created application design specification documents for the team.

Software Utilized: SAS 9.2, ANSI SQL, Unix, and MS Word.

Confidential

Stamford, CT

Database/Data Warehouse Developer/Analyst

  • Performed database and Database Analysis with large corporate databases.
  • Created complex queries and stored procedures to produce extract files, data feeds, and reports.
  • Met with business users to gather and document new data, report, and cube requirements. Wrote new reports utilizing Crystal Reports, Excel, and SQL.
  • Performed troubleshooting and correcting of data, database, and reporting issues.

Software Utilized: SQL Server 2008, ANSI SQL, Microsoft Query Analyzer, Analysis Manager, SSIS, DTS, Crystal Reports, and Business Objects.

Confidential 

Berlin, CT

Data Warehouse Developer/Analyst

  • Met with business users to identify system and data resources to fulfill business requirements. Conducted requirements gathering sessions, weekly status meetings, and technical walkthroughs with various business and technical team members.
  • Performed database analysis and write complex SQL queries to deliver data to statistical analysts for forecast modeling projects.

Hardware Utilized: IBM UNIX servers, IBM workstations.

Software Utilized: Informatica 9.0.1, MS SQL Server 2005/2008; DTS; SSIS; SSRS; SAS; SQL; ANSI SQL, Oracle, DB2, Transact SQL; AQT; SAS 9.

Confidential

Bridgeport, CT

Senior Database Analyst/Developer

  • Met with business systems users to identify system and data resources to fulfill business requirements.
  • Conducted requirements gathering sessions, weekly status meetings, and Technical walkthroughs with various business and technical team members.
  • Senior Relational Database Designer/Modeler/Programmer for the Everyday Points Multiplier project.
  • Performed database modeling, design, and implementation for the DataMart.
  • Wrote SSIS packages and complex SQL queries to extract and move data in the data warehouse storage facility to provide reports to meet the business partner’s requirements.
  • Produced technical documentation for the project.

Hardware Utilized: IBM UNIX servers, IBM workstations.

Software Utilized: MS SQL Server 2000/2005; DTS; SSIS; SSRS; SSAS; SQL; Transact SQL, ANSI SQL, Toad; SAS.

Confidential

Bloomfield, CT

Database Developer and Data Strategist

  • Lead the QA, testing, and development effort to upgrade a large database application from Microsoft SQL Server 2000 to 2005. This involved converting many complex DTS jobs and stored procedures to SSIS packages as well as converting the data into the 2005 database platform, database testing/quality assurance.
  • Created and executed test plans and test cases as a quality assurance team member. This included Database, Data Mart, and White Box testing.
  • Built and managed test data for enterprise wide database applications.
  • Database design, modeling, and implementation.
  • Developed complex SQL queries/procedures with MS SQL Server.
  • Maintained communications between quality assurance and development teams.

Hardware Utilized: IBM UNIX servers, IBM workstations, 390x mainframes.

Software Utilized: MS SQL Server 2000/2005; DTS; SSIS; SSRS; SSAS; Oracle 8.0; DB2; QMF Mainframe/Windows for DB2; Stored Procedures, PL/SQL, ANSI SQL.

Hire Now