Judith A. Ulmer

West Chester, OH ***** adi530@r.postjobfree.com 513-***-****

www.linkedin.com/in/judi-ulmer-data

Data Architect

Design & Implement Technical Data Solutions Addressing Business Needs

Experienced strategic thinker and problem solver adept at improving operational efficiency by integrating technology with business processes. Committed and hardworking professional who works well independently and with others to create effective solutions. Adaptable team player willing to assist with projects in multiple roles to deliver results while maintaining business standards.

Data Modeling

Data Analytics

Database Architecture

Issue Resolution

Technical Skills

Skills:

Data Modeling, Relational & Snowflake, NoSQL, Agile & Waterfall Development

Applications / Languages:

T-SQL, Microsoft SQL Server, JIRA, Power Designer, Erwin Data Modeler, Toad, Java, UNIX, SQL Stored Procedures, Cosmo DB, HTML, IBM Rational Rose, DB2

Training:

Agile & JIRA, Microsoft Azure Fundamentals, Microsoft Azure Databases, Power Designer, AWS Essentials, Business Objects, Cosmos DB

Professional Experience

COGNIZANT TECHNOLOGY SOLUTIONS

Senior Associate 2020 - present

Mapping multiple 834 data streams using the current code set for the development of a new ETL implementation into a Microsoft SQL Server.

ANTHEM INC., Mason, OH

Advisor Data Administration 2001- 2020

Architected data movement, designed data models, maintained metadata for system, ensured data quality in data movement, and assisted with data issues.

Built data delivery of healthcare product, member medical claim, and customer service to Big Data for landing zone, breaking down individual requests and like data to design tables and generate DDL in Power Designer.

oDesigned data delivery to account for varied data availability due to processing requirements.

oCreated user stories and tasks supporting data movement.

Delivered standardized user security database profiles for over 24K variant user’s security configurations, architecting concept of categorizing various testing and production environments.

oDeveloped data flow and modeling of tables, including generating DDL required to support interfaces.

oDevised JIRA user stories and supporting tasks for project.

oCreated and implemented standards with process procedures for test environments.

Functioned as solution lead for new healthcare products, discovering time-saving processes and alternatives to shrink implementation by several months.

oIdentified impact systems and created technical requirements.

Re-designed data conversion process projected at 3.5 months down to 3 weeks by categorizing and prioritizing timing of data conversion based on data dependency and outbound interface impact.

Provided interfaces and on-line extensions, enabling business to request vendor claim recommendations during adjudication and associated payment reconciliation process.

oCreated overall data design for vendor processing and payment recommendations.

oDesigned data models using Star Scheme for reporting and relational modeling for on-line and batch processing needs.

oDeveloped Use Cases and assisted in technical designs.

Established Metadata guidelines, standards, processes, and procedures for table designs and naming conventions used by interfaces, extensions, and mini data marts, organizing information to allow for quick identification and information of processes and their elements to maintain operations effectively.

Designed standards for ETL process for data movement, lessening maintenance costs and enhancing efficiency.

Additional Relevant Experience

ANTHEM INC., Mason, OH

Business Analyst

CLIENT SERVER ASSOCIATES, Cincinnati, OH

Consultant

SUNQUEST INFORMATION SYSTEMS, Tucson, AZ

Program Analyst Consultant

Education

Bachelor of Science (BS), Computer Informational Science, Oakland University, Rochester, MI

Contact this candidate