David Stamm Email & Phone Number

St. Louis, Mo, Us

St. Louis, Mo, Us

Develop PostgresSQL and MS SQL Server reports with ODBC connections to AWS and MS Azure Cloud Services. • Create/Support 100 live reports in PowerBI and Microsoft Excel thru a COOP with global Affiliates (1000+ Clients). • Communicate with PAT’s leaders and managers to define concise statements of work for projects. • Implemented Agile software and ticketing system for project management.• Adhere to coding standards, document work, and maintain report inventory list. • Optimized query performance with PostgresSQL EXPLAIN statement. • Implemented a GIT version control system to standardize production process.

Stamford , Ct, Us

Developed an API/C# .Net application for Self-Install Billing Automation orders. Application queried Self Install Order tables for 8 different billers(tables) and flagged orders that had preexisting Unpaid debt and held the orders for research for five days. • Created an array of Order objects to be sent to a REST API Call to check for accounts with unpaid balances. • Inserted Orders with Unpaid debt to a SQL Database holding table and deleted records from Orders tables to allow time for representatives to research the customer’s account. • Updated records in holding table to be released for order processing if debt was cleared or if order was held for more than five days. • Configured C# program to adhere to programming standards and to flow with the Order processing framework for all billers orders. • Inserted contents of API responses to a log file to enhance troubleshooting.

Maryland Heights, Missouri, Us

Supported database apps for healthcare products. Organized projects from PM scrum boards to gather business requirements. Designed and tested software features for 20+ client/database apps focused on healthcare cost and quality analytics.• Developed stored procedures which included T-SQL coding such as dynamic SQL, CTE’s, MERGE, and other CRUD operations to process clients’ data. Designed stored procedures with code for error-handling, status logging, and re-runnable tactics for pre and post deployment scripts.• Reported to scrum team about the project status to discuss how to meet/exceed software release goals. • Monitored client file loads and the code deployments in all env: Prod, Stage, UAT and Dev.• Created Confluence pages documenting how to support the app with tools like Job Activity Monitor, the apps’ audit tables, and other monitoring tools enhancing software quality like Jenkins and Pizza-Tracker.

Stamford, Connecticut, Us

Supported business intelligence (BI) big data projects for call center sales commission reporting. Developed ETL and reporting solutions. Collaborated with other BI teams to design and develop solutions. • Developed stored procedures and ad-hoc SQL programs with Teradata Assistant for ETL and auditing purposes. • Tracked projects with JIRA tickets following Agile methodology. • Supported projects in both UAT and production environments. • Monitored ETL and file generation with OneAutomation and escalated performance problems to higher levels.

St. Louis, Mo, Us

Supported two major projects. Developed software features/enhancements for data warehouse for supply chain management of baking goods. Built standard reports for corporate financials. Collaborated with the Logistics Manager, Accounting and Sales Manager to scope out business requirements for reports and architecture of the data warehouse. Presented project status updates to Director of IT and CFO. • Architected data warehouse solutions including dimensional and fact tables in a star design schema. • Created SSIS packages for an ETL application to transform data between an AS400 mainframe to a Microsoft Azure (cloud services) data warehouse.• Scheduled SSIS packages with SQL Server Agent for daily and monthly reporting cycles. • Utilized Microsoft Visual Studio for version control and deploying changes to Stage and Prod. • Developed and maintained 50 standard reports in SSRS and Power BI. • Administered users on Microsoft SQL Server databases and performed backup /restore procedures.

St. Louis, Mo, Us

Reported to VP of Development Services the project status lists and presented on outstanding and completed projects on a weekly basis. Supported 250 users within department who made database requests. Also provided database related services to all other departments across the organization. Reached and exceeded project deadlines on a weekly basis. • Developed T-SQL programs to support “Leading Together” campaign goals. • Delivered and accomplished 1500+ complex SQL programs that supported ASP.NET applications annually.• Created and updated Temporary tables to assist with data outputs.• Implemented SQL Windows functions to manipulate data to desired results. • Utilized SQL CTE to perform query tasks.• Provided and maintained documentation for system procedures.• Collaborated with an exhaustive surgical reporting campaign. Goals were met and exceeded: endowment rose from $4B in 2008 to close to $8B in 2015.

St. Louis, Mo, Us

Provided database services and technical support for President, CFO, and VP of Sales. Managed SharePoint web portal projects and implemented web page layouts that hosted standard reports. Set up user accounts and managed user roles for a web portal. • Architected single source for IS for marketing and finance managers with reports from an SX Intelligence (Infor) data warehouse utilizing T-SQL, DTS and Entity Relationship Diagrams (ERDs) with MS SQL server platform. • Designed and implemented 50+ Hyperion (BI Software) dashboards that measured sales growth by product lines, sales forecasts, Inventory levels and other exhaustive business performance metrics. • Utilized data stores from Infor Inc’s. ERP to manage accounting, sales, and inventory report projects.• Provided computer support to 120 end users on thin client.• Collaborated with the new BI software implementations. Sales doubled from 2004 to 2008, with gross margins and net income up 100%.

Master'S Degree, Computer And Information Sciences, General

Bachelor Of Science - Bs, Computer Science

Bsba, Business Administration And Marketing