David Demsky Email & Phone Number

Saint Louis, Mo, Us

Saint Louis, Mo, Us

Saint Louis, Mo, Us

Saint Louis, Mo, Us

Saint Louis, Mo, Us

St. Louis, Mo, Us

- Transformed a spreadsheet financial model into a multiuser Teradata based application by writing business requirements and SQL logic which shortened processing time by 80% and improved accuracy by ~$1.5 million. - Fostered a positive working relationship with developers increasing productivity and trust repairing a rift between business and technical groups - Created custom financial modeling solutions to support the successful multi-million dollar renewal for a complex client - Developed detailed business requirements (that included prototyped code) for numerous large enhancement projects providing innovative solutions - Designed and implemented test plans for all major release to the financial modeling software - Reduced runtime by 20% for a Teradata SQL driven financial model by analyzing runtime statistics and working closely with IT developers to tune performance - Acted as departmental SME on cross-functional initiatives to achieve departmental alignment across multiple financial models and create corporate wide data repositories - Created queries and Excel based analyses for ad-hoc financial reporting and analysis - Provided technical support for 100 users of in-house developed financial modeling software - Served as analyst and project manager for numerous small and mid-sized projects

St. Louis, Mo, Us

Promoted to Financial Analysis Specialist in the same group after 1.5 years

Menlo Park, California, Us

- Managed a small group of consultants that aided with risk assessments for 300+ applications in support of a billion-dollar merger - Supported the Information Security Officer (ISO) group at a Fortune 100 company by providing ad-hoc reporting, performing data analysis, creating process improvement recommendations and performing daily ISO duties - Prepared business requirements for a large online new account opening process for a company in the Financial Services Industry - Created data validation audit tests using SQL to manipulate and analyze data and identify irregularities - Designed, programmed, and maintained MS SQL databases that reduced the cycle time of an invoice by joining, filtering and processing data from multiple systems - Supported a team performing network vulnerability assessments using automated tools to identify vulnerabilities and compliance issues - Wrote policies and procedures surrounding IT functions to bring a company into Payment Card Industry (PCI) compliance - Performed IT Risk Assessment/Audits to verify compliance with industry standards and company policies across various industries (manufacturing, healthcare, retail, financial, construction, communications) - Performed SOX compliance audits for multiple clients - General responsibilities involved: data analysis, presentation creation, drafting memos and agendas, leading meetings, developing client relationships

Columbia, Mo, Us

- Worked independently to create new databases based on departmental needs using MS Access and MS SQL - Maintained existing departmental databases - Performed interviews, developed specifications and built database linked websites using ASP.NET and C# - Developed and implemented database/programming solutions for faculty and staff

Master'S Degree, Mba - Generalist, Mis

B.S., Computer Science