Created documentation for Internal support staff using Confluence.Diagnosed ETL and database related issues, performed root cause analysis(RCA), and recommend corrective actions to management.Created test scripts to test ETL loads, data aggregations, data conversions, data extracts.Created custom scripts to import various data files into MS Database.Imported data into various systems using SQL/ SSIS / Diyotta.Created and modified custom reports for supported systems.Assist development team with complex query and schema refinement.Designed and developed database objects, tables, stored procedures, views, triggers.Using SQL, SSRS, SSIS, PLM, Great Plains & Jira
#Tessitura pro software software#
Point person for Technical support for Internal Purchase Order System software as well as PLM and Great Plains.Worked with project management team to provide enhancements to current processes using SQL, SSIS.Created Job Flow/Data Flows within Diyotta to transfer data to Snowflake.On call support which involved troubleshooting failed SSIS jobs / Diyotta Jobs / SQL Agent Jobs.Developed and maintained ETL processes using MS SQL, SSIS.
SOFTWARE:, Tessitura, Trakit, Confluence, Jira, PLM, Great Plains PROGRAMMING: MS SQL, TSQL, SSIS, SSRS, SQL Server Agent Jobs, Snowflake, Diyotta, Netezza
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.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.Extensive experience working with MS SQL / SSRS / SSIS, Complex queries & Stored Procedures.Organized, goal - oriented, highly motivated Database Developer with excellent analytical, troubleshooting and problem solving skills.