SUMMARY

• Organized, goal - oriented, highly motivated Database Developer with excellent analytical, troubleshooting and problem solving skills.
• Extensive experience working with MS SQL / SSRS / SSIS, Complex queries & Stored Procedures.
• Looking to obtain a position where I can utilize my current skill set and to continue to learn new skills/languages in my new role.
• If there is a language that is needed and I do not have it I would take the time off hours to ramp up quickly.

TECHNICAL SKILLS

PROGRAMMING: MS SQL, TSQL, SSIS, SSRS, SQL Server Agent Jobs, Snowflake, Diyotta,, Netezza

SOFTWARE: , Tessitura, Trakit, Confluence, Jira, PLM, Great Plains

PROFESSIONAL EXPERIENCE

Confidential

Data Engineer

Responsibilities:

• Developed and maintained ETL processes using MS SQL, SSIS
• On call support which involved troubleshooting failed SSIS jobs / Diyotta Jobs / SQL Agent Jobs
• Created Job Flow/Data Flows within Diyotta to transfer data to Snowflake
• Worked with project management team to provide enhancements to current processes using SQL, SSIS
• Point person for Technical support for Internal Purchase Order System software as well as PLM and Great Plains. Using SQL, SSRS, SSIS, PLM, Great Plains & Jira
• Designed and developed database objects, tables, stored procedures, views, triggers
• Assist development team with complex query and schema refinement
• Created and modified custom reports for supported systems. Using SSRS, SQL.
• Imported data into various systems using SQL/ SSIS / Diyotta
• Created custom scripts to import various data files into MS Database
• Created test scripts to test ETL loads, data aggregations, data conversions, data extracts
• Diagnosed ETL and database related issues, performed root cause analysis(RCA), and recommend corrective actions to management.
• Created documentation for Internal support staff using Confluence

Technical Environment: Microsoft SQL 2008,2012, 2017. BI - (SSIS, SSRS), Diyotta, Snowflake, PLM, GP, Confluence, Jira.

Confidential

Application Administrator / SQL Developer

Responsibilities:

• Point person for Technical support for Ticketing system (Tessitura). Using SQL, SSRS, Infomaker and Tessitura to create new reports, create customizations, debugging/trouble shooting, custom stored procedures.
• Developed complex SQL stored procedures to implement customized screens and reports.
• Point person for Technical support for Building Permit System (Trakit). Using SQL, Visual Basic, Access and SSRS to create new reports, create customizations, debugging/trouble shooting.
• Developed complex SQL to implement and reports for use within system and outside for public use.
• Developed online report system for Building Permit Department using SQL (oracle) and Apex Software
• Act as the point of contact between the business units and IT
• Coordinated User acceptance testing and developed job aids for the new functionality that was enabled.
• Perform maintenance and develop documentation for customization on programs
• Project Manager on project to purchase all equipment for Building Inspectors vehicles. Included: Research, Request for Purchase and purchase of Toughbook laptops for vehicles as well as the required equipment and installation for vehicles to hold and operate laptops.
• Delivered Technical specifications for new Permit System
• Provided project management and the actual install for Permit System upgrades
• Performed testing and conversion for upgrades on Ticketing System as well as point person for all Technical Support with Upgrades
• Provided training sessions to users
• Developed internal programs to assist with daily functions of the Arts Center. Such as a Volunteer Data Entry program that tied in with the Ticketing system used (Tessitura)
• Implemented new systems such as Email Blast software.

Technical Environment: Microsoft SQL 2005 & 2008, SSRS, Oracle SQL, Access, Tessitura, Permits Plus, Apex)

Confidential

Database Developer

Responsibilities:

• Designed SQL 2005 database structures and internal processing systems to meet corporate and project objectives. Part of a re-engineering effort.
• Developed complex SQL stored procedures and DTS packages to load ICD9 codes into database
• Developed and tracked estimates for project tasks and deliverables.
• Built and maintained database structures, ETL processes, stored procedures, audit reports, data extracts, etc., to meet project objectives.
• Created and maintained documentation and schedules to support developed applications.
• Performed internal QA checks to insure high quality deliverables.
• Loaded, processed and migrated incoming data feeds and create outgoing data extracts.
• Migrated applications and data throughout the development cycle (development, test, stage, production) following proper policies and procedures.
• Supported enhancements and bug fixes following proper scheduling and prioritization guidelines.
• Provided decision support and fulfilled on demand ad hoc requests.
• Utilized SQL SERVER BIDS to create SSRS reports and SSIS packages to migrate/import data.
• Set up and implemented new client data submissions. This involved acting as a project manager as well as a technical lead for the initial set up.
• Created SQL stored procedures/reports for complex query requests for clients and/or internal consultants that involved working with specific diagnoses and procedure codes along with other health/patient detail criteria.

Technical Environment: Microsoft SQL 2005 & 2005. SQL SERVER Business Intelligence Studio (SSIS)

Confidential

Software Engineer

Responsibilities:

• Technical and project management roles for TriZetto which included: implementing Facets on the Payer Integration team i.e. creating/debugging Facets batch jobs within UNIX environment. Utilizing SYBASE to analyze stored procedures and also to run or write queries to obtain pertinent information. Created stored procedures with in Sybase for implementation to assist with specific client specifications such as specific report types. Scheduling production rollouts with client while acting as the project lead.
• Created over 100 Interfaces within an Internal Program (Internet Exchange) on the EDI team to retrieve files via ftp, archive the files, convert the files, upload the files into the Sybase database, run an extract routine against the database then FTP the file back to client’s site.
• Created custom solutions in an effort to support implementation projects. Developed EDI/interfaces, conversion routines, and custom reports using an internal program, XLNT, SQL, HTML, PERL, Visual Basic in accordance with HIPAA guidelines.
• Improved implementations by initiating specification development, testing and bug reporting procedures, and documenting phased deliveries.
• Developed several programs that improved team’s performance/efficiency. Won internal company awards for this effort.
• Improved efficiency of database-driven company intranet application by adding more functionality and improving current processes along with establishing new intranet applications for documentation purposes.
• Researched needs and recommended software design approaches, contributed to design documents, and prioritized software development tasks.

Technical Environment: Java Script, Facets, Sybase, VB Script, HTML, SQL with Classic ASP pages using InterDev/DreamWeaver.