David Dougherty Email & Phone Number

Cincinnati, Oh, Us

Cincinnati, Ohio, United States

Cincinnati, Ohio, United States

•Worked in a fully agile team setting and participated in all agile ceremonies (including PI Planning)•Used Rally, draw.io, Miro, Microsoft Office, and Microsoft Loop to document stories and create quality documentation•Wrote source queries in Oracle Database, SQL Server, and Snowflake SQL syntaxes•Used Microsoft SQL Server Management Studio 18, Oracle SQL Developer 17.4.0, and Snowflake to manage database connections and execute database queries•Used Red Gate tools to analyze data and enhance development in SQL Server Management Studio 18•Created tables, views, and other database elements in both SQL Server 2019 and Snowflake environments•Used SQL Server Integrated Services (SSIS) and Informatica Intelligent Cloud Services (IICS) to modify and create packages to populate data mart tables•Used Visual Studio 2019 and Visual Studio 2022 to modify and create SSIS packages•Generated tSQLt tests via the BIML extension in Visual Studio 2019•Tested and implemented database and package changes•Created jobs in UC4 and used them to execute SSIS packages to populate data mart tables•Used GitHub and Team Foundation Server (TFS) to store changes•Used GitHub Desktop, Red Gate SQL Source Control, and the Team Explorer in Visual Studio to properly commit changes•Served in an application support rotation and oversaw weekly support of the data mart once every three weeks

Cincinnati, Ohio, United States

• Used Snowflake and Informatica Intelligent Cloud Services (IICS) to help create a cloud data mart• Migrated data from local SQL server databases to a Snowflake database• Created reports for business users using Cognos 11.1• Managed a GitHub repository and handled code deployments• Worked with other team members to move changes to other environments• Tested and implemented Snowflake database changes

Indianapolis, Indiana, United States

• Assigned as a QA Tester for a platform marketing integration project at Eli Lilly and Company• Documented system requirements and created UAT test scripts in Jira• Worked remotely on a multi-discipline team and participated in regular virtual standup meetings with project stakeholders• Trained a new team member about the client’s quality assurance practices and test writing guidelines

Louisville, Kentucky, United States

• Participated in daily standup meetings and completed tasks for biweekly sprints• Used AWS CloudFormation JSON to create programmatically-instanced AWS CloudWatch Dashboards that monitored appliance and system operational and performance metrics• Used Java in Eclipse to add commands and support for smart dehumidifiers to a company API• Wrote JUnit tests to validate Java code and functionality during API development

Cincinnati, Ohio, United States

• Worked with an offshore team and internal developers to implement UI-compatible form changes• Created and implemented brand new Java reports• Used ReportMill 12 and Eclipse to implement necessary changes to Java report generators and Java report files on the company system and wrote SQL queries to get test data from databases• Wrote test cases to ensure that code didn’t error and helped coordinate testing between two systems

Cincinnati, Ohio, United States

• Used Java, JavaScript, Dojo Toolkit, HTML, and XSLT to implement changes to front-end screens• Created and implemented brand new Java reports• Collaborated with a developer in Wisconsin to make major changes to a front-end screen• Used ReportMill 12 and Eclipse to implement necessary changes to Java report generators and Java report files on the company system and wrote SQL queries to get test data from databases• Wrote test cases to ensure that code didn’t error and helped coordinate testing between two systems

Cincinnati, Ohio, United States

• Used ReportMill 12 and Eclipse to implement necessary changes to Java report generators and Java report files on the company system and wrote SQL queries to get test data from databases• Wrote test cases to ensure that code didn’t error and helped coordinate testing between two systems

Camp Friedlander, Dan Beard Scout Reservation (Dbsr), Loveland, Ohio, United States

• Served as a lifeguard• Taught merit badges and assisted other counselors with instruction• Helped maintain area safety• Kept the area clean and orderly through special maintenance projects• Administered BSA swim tests to arriving campers

Camp Friedlander, Dan Beard Scout Reservation (Dbsr), Loveland, Ohio, United States

• Taught motorboating merit badge and assisted other counselors with instruction• Served as a lifeguard at the lake and helped maintain area safety• Completed BSA Lifeguard, BSA Safety Afloat, and BSA Swim Safe Defense training courses• Completed DAN CPR: Health Care Provider with First Aid certification• Administered BSA swim tests to arriving campers• Awarded Staff Member of the Week and Staff Member of the Year awards

Master Of Science - Ms, Information Technology (It), 3.9/4.0

Activities and Societies: Alpha Phi Omega, Delta Alpha In addition to pursuing my Bachelor of Science in Information Technology (IT), I.

Bachelor Of Science - Bs, Information Technology (It) - Software Development, 3.849/4.0

Activities and Societies: Alpha Phi Omega, Delta Alpha From Fall 2016 to Spring 2021, I pursued a Bachelor of Science in Information.