David Gans

David Gans Email and Phone Number

Data Analytics || SAS / SQL Developer || Python/PySpark || Metadata Expertise @ Capital One
mclean, virginia, united states
David Gans's Location
Greater Chicago Area, United States
David Gans's Contact Details

David Gans personal email

n/a

David Gans phone numbers

About David Gans

I am an experienced Data Analyst with expertise in (Base) SAS and SQL coding to support data infrastructure and Marketing Operations, with emphasis on data governance and risk and regulatory requirements. I deliver efficient coding to provide precise analytics used in business projects and am proficient in bridging the gap between business and technology teams to refine requirements and develop logical and efficient solutions. • SAS/JCL/SQL Programming

David Gans's Current Company Details
Capital One

Capital One

View
Data Analytics || SAS / SQL Developer || Python/PySpark || Metadata Expertise
mclean, virginia, united states
Website:
capitalone.com
Employees:
55043
David Gans Work Experience Details
  • Capital One
    Senior Data Analyst
    Capital One Mar 2017 - Present
    Card Analytics & Infrastructure
    Provide data in the execution of Partnerships’ $5 billion retail portfolio credit card marketing strategies and special projects to develop simple, efficient solutions. Provide data using Pyspark, Python, mainframe SAS, JCL, and SQL to drive sales and revenue through email, direct mail, and in-statement messaging ensuring data is compliant with Federal risk and regulatory standards. Provide detailed analysis to stakeholders.
  • Capital One
    Senior Data Analyst
    Capital One Apr 2014 - Mar 2017
    Card Data Innovation
    Supported Information Data Management policies and controls by implementing data quality checks on high priority usages, ensuring the existence of high quality metadata to enhance usability of data. Investigated data quality issues and partnered with technology teams to eliminate systemic issues. Acted as Database Guardian provisioning data access across platforms in accordance with Federal data sharing regulations.
  • Capital One
    Senior Data Analyst
    Capital One Jan 2010 - Mar 2014
    Card And Retail Data Infrastructure
    Developed and maintained the Card and Retail data infrastructure and validated accuracy of data at all stages in conjunction with data warehouse teams. Researched data variances and identified root cause along with solutions for resolution. Designed and validated code to evaluate customer interest rates and adjusted accordingly per law as part of new acquisition.Worked with business analysts to reduce mainframe computing and charge back costs by redeveloping JCL, SAS and SQL code as part of company-wide platform conversion.Streamlined Bankcard application file creation process by converting from a manual to an efficient batch process by significantly reducing processing time from days to minutes.Partnered with Data Governance to ensure understanding of conversion data.
  • Capital One
    Data Analyst
    Capital One Feb 2006 - Dec 2009
    Card And Retail Data Infrastructure
    Created and maintained SAS datamarts using JCL, SAS and SQL. Identified source data, usage patterns and created robust metadata and validated production processes to support business strategies. Collaborated with Marketing and IT teams to develop and accurately track partnerships' campaign data. Also supported Marketing in the development process of direct mail campaign files and interacted with credit bureaus to resolve issues and ensure processes remained within expected timeframe.
  • Aon Hewitt
    Programmer/Analyst
    Aon Hewitt Jan 1999 - Dec 2004
    Total Benefits Administration (Tba)
    Onboarded clients to Total Benefits Administration system by developing SAS and SQL code to accurately process client data feeds. Enhanced and supported ongoing batch processes and worked with Quality Assurance teams to resolve processing and data issues. Converted pension annuities to lump sum payment options for client and redeveloped annual pension valuation coding process to increase efficiency.

David Gans Skills

Requirements Analysis Business Analysis Data Analysis Sql Analysis Process Improvement Microsoft Sql Server Sdlc Requirements Gathering Visio Mainframe Sas Programming Analytics Sas Jcl Software Development Life Cycle Job Control Language Vendor Management Credit Cards Business Requirements Systems Analysis Business Analytics Teradata Teamwork Ibm Db2 Business Process Improvement User Acceptance Testing

David Gans Education Details

Frequently Asked Questions about David Gans

What company does David Gans work for?

David Gans works for Capital One

What is David Gans's role at the current company?

David Gans's current role is Data Analytics || SAS / SQL Developer || Python/PySpark || Metadata Expertise.

What is David Gans's email address?

David Gans's email address is da****@****one.com

What is David Gans's direct phone number?

David Gans's direct phone number is +170344*****

What schools did David Gans attend?

David Gans attended Dominican University, Northern Illinois University.

What skills is David Gans known for?

David Gans has skills like Requirements Analysis, Business Analysis, Data Analysis, Sql, Analysis, Process Improvement, Microsoft Sql Server, Sdlc, Requirements Gathering, Visio, Mainframe, Sas Programming.

Who are David Gans's colleagues?

David Gans's colleagues are Sean Finnerty, Glenn Luo, Son Mays, Mickey English, Chalise Ray, Cassie Shipley, Anton Aguilar.

Not the David Gans you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.