Senior Analytics Consultant & SQL/SAS Expert
Resume:
WENDY ERDWURM
**** ******* ***** #***, ****** Village, California 91607 • 314-***-****
PROFILE
Effective and results-driven leader, analyst, and database administrator with many years of successful experience contributing to the IT functions and infrastructure of major organizations. Specialize in SQL, SAS, EXCEL and Tableau as a dedicated subject matter expert. Formal training in Python and Power BI. Exceptional process improvement, complex problem-solving, and team leadership acumen with a talent for mitigating risks, spearheading major projects, and collaborating across business units. Seeking a challenging position to drive results for a progressive organization. Core competencies include:
Analytic Reporting & Insight SAS Expert Data Analysis
SQL Guru Database Administration
Analytical & Technical Acumen Regulatory Compliance
Team Leadership Project & Program Management
Troubleshooting & Issue Resolution Consulting
Professional Credentials:
>Certificate Python Programming, University of Michigan 2026
> SAS Advanced 9 Certification, 2016
> SAS Base 9 Certification, 2013
> Python Programming for Data Science, University of Michigan 2026
> SNOWFLAKE training for SNOWPRO Core Exam
> SNOWFLAKE SQL
> Strong Academic Background in multivariate statistics of the General Linear Model (GLM) Professional Publications:
Storing and Distributing GONG Data:
https://www.aspbooks.org/a/volumes/article_details/?paper_id=12697 National Solar Observatory Digital Library - A Resource for Space Weather Studies: https://www.sciencedirect.com/science/article/abs/pii/S136468260000081X EXPERIENCE
WELLS FARGO, Remote 8/2017–Present Senior Lead Analytic Consultant
(8/2018–12/2025) Diligent leader with accountability for providing dedicated advisory to senior leadership, spearheading complex analytics projects, and developing data-driven solutions for intricate business and technical challenges.
● Translate data into actionable insights, driving high levels of compliance, solutions innovation, and business objective attainment.
● Lead and manage large-scale analytical projects throughout their entire lifecycle with a focus on resolving unique challenges and improving processes.
● Collaborate across business lines to develop risk mitigation solutions and strategies, applying advanced acumen in SAS, Oracle, SQL Server, and Teradata SQL and EXCEL.
● Utilize SAS to perform Extract, Transform, and Load (ETL) processes, merging multiple data sources for output to Teradata tables and for input to Tableau dashboards; create Tableau and SAS Visual Analytics dashboards. Power BI online classes.
● Expert C programmer with formal Python training.
● Serve as the dedicated database administrator for the Analytics and Decision Support Teradata database, as well as a SQL and SAS subject matter expert.
● Work closely with Audit teams to ensure accuracy of reports and data outputs.
● Administer SAS application user production and development UNIX environments.
● Perform peer reviews of colleague SAS and SQL reports; serve as the primary point of contact for advanced SAS and SQL techniques.
● Develop risk exception reports to flag at-risk customer accounts to ensure alignment with regulatory and legal requirements.
● Conduct detailed call center reviews to discover and provide data on review volume, disputes, and associated resolutions.
● Serve as the primary point of contact for pulling and formatting data from Tableau dashboards into easily digestible reports.
● Develop roadmap for converting from SAS to Python Database Analyst V (8/2017–8/2018)
Meticulously performed in-depth database analysis, design, and support, including ad-hoc project management, report development, and data integrity management.
● Troubleshoot complex production and non-production database application issues.
● Provided dedicated assistance with code development and testing to ensure proper functionality within database environments; provided database and code change recommendations to maximize application performance.
● Collaborated closely with application teams by attending load tests and providing insightful analysis; attended SWAT calls to troubleshoot down production systems.
● Implemented new database security requirements that substantially improved risk mitigation efforts. HEALTHNET / CENTENE, Woodland Hills, California / Chestfield, Missouri 10/2015–4/2017 Senior Oracle Database Analyst, Problem Management
Conducted comprehensive root cause analysis for all severity one and two database incidents to promptly address and resolve system outages and performance slowdowns; developed effective remediation plans and supervised implementation.
● Collaborated with application developers and business users to performance tune applications and queries.
● Provided data-backed recommendations for database, operating system, disk configuration, network, and coding improvements with a focus on maximizing database performance and stability.
● Provided training to the application development team on techniques for rewriting high application concurrency SQL code (more than 10,000 lines).
● Revamped a SAN configuration that eliminated RAC node evictions; recommended changes to network and switch configurations to remediate GC lost block issues.
● Received 1500 Spot Award for work above and beyond with business users. WENDY ERDWURM, PAGE TWO
BANK OF AMERICA / TATA CONSULTANCY SERVICE, Agoura Hills, California 5/2015–9/2015 Application Database Analyst
Vigilant analyst with responsibility for troubleshooting production and non-production application issues.
● Collaborated with the development team to increase code efficiency.
● Worked cross-functionally with the quality assurance team and regularly attended formal code reviews and Scrum seminars.
● Implemented interval partitioning for tables containing billions of records; implemented hybrid columnar compression for partitioned tables. HEALTHNET / COGNIZANT SERVICES, Sacramento, California 9/2014–4/2015 Manager, Projects / Oracle Database Administrator
Results-oriented project manager and administrator with accountability for continuously assessing the health and state of databases for the takeover of Healthnet’s infrastructure from IBM.
● Provided recommendations for logical and structural changes to 150 existing databases on improvements to performance and security.
● Supported process improvements impacting SLAs, including change requests, incidents, and service.
● Collaborated with application groups on application SQL and database infrastructure modifications, resulting in substantial enhancements to performance. COVERED CALIFORNIA / ACCENTURE SERVICES, Sacramento, California 7/2013–1/2014 Associate Manager / Lead Oracle Database Administrator Effective leader with responsibility for guiding and supervising a team of database administrators in the tuning, troubleshooting, and maintenance of two node production RAC clusters on EXADATA and ODA, Version 11.2.0.3.
● Suggested SQL and database infrastructure modifications that significantly enhanced performance.
● Provided mentorship, training, and professional development to team members, ensuring they were equipped with the skills, tools, and knowledge necessary to succeed in their roles. KAISER PERMANENTE, Lake Oswego, Oregon 3/2013–7/2013 Oracle DataGuard / RMAN Consultant Trusted consultant with responsibility for architecting and configuring Data Guard and RMAN solutions for a key
disaster recovery project.
● Implemented database rolling upgrades to Oracle Data Guard installations using transient logical standby.
CGI, Tempe, Arizona / Montreal Quebec, California 10/2009–9/2012 Senior Oracle Database Administrator / Oracle Consultant
Dedicated consultant and administrator with accountability for designing, building, maintaining Phoenix Data Center Oracle and SQL Server installations for state, federal, and commercial clients in a 24x7 environment.
● Installed, upgraded, monitored, and maintained Oracle and SQL server installations across multiple versions and operating system platforms.
● Collaborated with Tier 2 application groups on application SQL and database infrastructure modifications to enhance performance; chaired weekly client meetings to review findings. IRIDIUM SATELLITE, LLC, Tempe, Arizona 1/2001–10/2009 Oracle 11i EBS Database Administrator Diligent database administrator with accountability for installing, tuning, troubleshooting, and maintaining an Oracle 11g, RAC 3 node cluster with ASM, a 10g RAC 2 node cluster with ASM, and several 8i and 9i single server 24x7 database installations housed on Solaris 9 and 10 platforms.
● Oversaw production, test, and development instances and provided support for BSCS telecommunications billing, Oracle Portal telecommunications billing, and Oracle 11i EBS.
● Worked closely with IT application programmers to review and recommend database design and code changes to improve performance.
● Patched, upgraded, maintained, and managed operations of Oracle 11i EBS installation.
● Designed and implemented custom reports and queries for receivables, purchasing, and payables operations.
● Contributed to the companywide goal of becoming SOX compliant for a potential public offering. EDUCATION
WESTERN INTERNATIONAL UNIVERSITY, Phoenix, Arizona Master of Business Administration in Finance
WESTERN INTERNATIONAL UNIVERSITY, Phoenix, Arizona Certificate in Accountancy
UNIVERSITY OF TEXAS, Austin, Texas
Master of Business Administration Studies
CITY UNIVERSITY OF NEW YORK / BROOKLYN COLLEGE, New York/Brooklyn, New York Bachelor of Arts in Chemistry, Cum Laude
References & List of Technical Skills Available Upon Request
Contact this candidate