Cindy Elkins

Cindy Elkins Email and Phone Number

Data Governance Manager at Alliant Credit Union @ Alliant Credit Union
Cindy Elkins's Location
Greater Chicago Area, United States, United States
Cindy Elkins's Contact Details

Cindy Elkins personal email

n/a
About Cindy Elkins

AREAS OF EXPERTISE:- Strong managerial/leadership skills, including strategic roadmap, staffing and employee development/mentorship, management of daily operations, budgeting, supervision of direct and indirect reports.- 20+ years solid experience in data. Areas of focus: data architecture, data modeling, data flow, data analysis, data processes, data integration, data quality, data retention, data as information, data standards (including naming, classification, modeling, defaults, formats), data governance, data storage, data structures and includes the tools used to move and present data. Data structures include: Conceptual, Logical (Entity Relationship Diagram - ERD), Physical (includes Dimensional modeling, OLAP) for BI/DW, DSS, ODS and in-house developed OLTP applications. Experience in both Ralph Kimball and Bill Inmon architectural approaches.- Solid analytical, planning, initiative and organizational capabilities providing vision, strategy and execution were demonstrated in new department start-up and new position development.- Strong consulting (in-house) and training experience, including liaison between business functions and Information Technology, problem investigation, analysis and resolution for business process and technical problems, designed and conducted training. Considered a SME in business, data and architecture.- Comprehensive experience in driving out data requirements and business rules though business engagement and data profiling/analysis.- Extensive ETL involvement (creating/approving ETL specifications, ETL test plans, ETL test cases and ETL processes including scheduling).- Experience with both Agile and Waterfall development methodologies.- Technologies - Databases: Oracle, AS/400, Sybase, SQL Server, Mongo, Azure; ETL tools: DataStage, Informatica; BI/DSS/reporting tools: Cognos, Business Objects, Tableau, Query/400, Siebel Analytics, Andyne GQL, BRIO; Message Brokers: TIBCO, RabbitMQ; ERP/CRM software: J. D. Edwards, BAMS/DCB, Siebel CRM, Salesforce.com; Data Modeling tools: Sybase PowerDesigner, Vertabelo, Erwin; Query Languages: SQL, Easytrieve Plus; Manufacturing Software: Pansophic PRMS, Arista, Systems Management, Inc.; Data Catalog tool: Purview; Unstructured Scanning tool: Varonis.

Cindy Elkins's Current Company Details
Alliant Credit Union

Alliant Credit Union

View
Data Governance Manager at Alliant Credit Union
Cindy Elkins Work Experience Details
  • Alliant Credit Union
    Manager, Data Governance
    Alliant Credit Union Dec 2022 - Present
    Chicago, Il, Us
    - Responsible for maturing Enterprise Data Governance and Data Management.o Implemented the first consolidated Data Inventory for structured and unstructured data. Included in the inventory are Cloud, NoSQL and SQL databases along with sensitive network files and sensitive physical document locations.o Achieved owner adoption and quarterly attestation of the inventory. o Provided Data Classification training.
    View
  • Alliant Credit Union
    Manager, Data Engineering
    Alliant Credit Union Apr 2020 - Nov 2022
    Chicago, Il, Us
    - Managed Enterprise Data Warehouse platform and team.- Managed Business Intelligence (BI Engineering) resources in addition to my team while the Director position was being backfilled- Responsible for the support and enhancement of the Enterprise Data Warehouse that provides integrated data for Business Objects reports, Tableau extracts, Regulatory reporting (ULDD, HMDA, NCUA), business systems and Data Scientists. Support includes monitoring of daily batch processing 7 days/week and Informatica upgrades.- Drove scrum team improvement:o Business value focuso Implement smaller scope incrementso Stabilized Sprint planning and delivery processo Extended resource planningo Prepared scrum processes for inclusion in company-wide Program Increment planning- Initiated and implemented a new parameter driven ETL mapping approach to ingest third party partner data. Features of the new architecture:o Speed to Market - Ingestion of partner data within a fraction of the timeo Integrated partner data available in the lower levels of the DW enabling easier and quicker analyticso Re-use of code for all new partners after a one-time buildo Column order can change every time data is receivedo Dynamic mapping can be done by a non-ETL team member - flexibility with resource constraints- Initiated standard deliverable artifacts (leveraged by Data Governance, BI team, DW team):o Data Profiling metadata (classification, names, definitions, data quality, ranges, population, data type/length) o Source-To-Target mappingso Data Modelo Data Flow Diagram- Simultaneously managed delivery with limited resources across multiple top Enterprise projects of varying complexity and dependencies and Prod Support activities.- Worked with Product Owner to drive data requirements- Championed data driven decision making- Collaborated to decentralize the BICOE (Business Intelligence Center Of Excellence) and empower the business BI leads to self-serve
    View
  • Alliant Credit Union
    Data Warehouse Architect/Modeler
    Alliant Credit Union Jan 2019 - Apr 2020
    Chicago, Il, Us
    - Led DW Data Modeling efforts, including selection and oversight of contracted Data Analyst and Data Modeler- Key member of CCPA regulatory project - includes the design of the Right To Delete process, participation in cross team process development and data catalog vendor selection- Key member of first deliverable showcasing a combined Data Lake/Data Warehouse solution:o Created a Data Flow Diagram to unify and document the solution vision between the DL and DWo Drove enhancement to the current DW architecture- Removed architectural obstacles preventing non-member data from flowing into the DW- Enhanced capability by:• Removing dimension to dimension join and creating appropriate facts that allow analysis across all related dimensions versus only one dimension• Removing the requirement to insert additional fact rows when any one of its’ dimensions change resulting in:o Lower row counto Flexibility for user to select different date criteriao Assisted in driving requirements and issue resolution- Initiated Data Flow Diagrams (DFD) as standard Data Architecture deliverableso Created DFD standards and blank template to start a DFD.- Created a design for the NCUA 10B regulatory requirement. Design includes:o Fully Automatedo Minimal objects and complexity:- 55 template staging tables with only 11 parameter driven ETL mappings- Delete/reload per source and template when new file received (versus ‘versioning’)o Flexible – handles many variations in data timing and re-sends o Scalable – minimal, re-usable objects resulting in ease of adding a new sourceo Efficient Data Delivery – one Informatica workflow from source to target template table enables the creation of an integrated file within minutes of receipt anytime during the day.- Supported quarterly NCUA submissions through data validation and process improvements Technologies: Database – SQL Server ETL - Informatica, BI Tool – Business Objects, Tableau Data Modeling Tool - Erwin
    View
  • Aim Specialty Health
    Senior Data Architect
    Aim Specialty Health May 2017 - Jan 2019
    Chicago, Il, Us
    - Lead Data Architect for the OLTP system that enables AIM to sell a Pre-Authorization service to a variety of insurance companies including our parent company Anthem. The OLTP system is being transformed from a solution redundant Sybase architecture to a microservice, Domain Driven Design (DDD) architecture in MongoDB with Enterprise data in SQL Server Responsibilities/Achievements include:o Managed team of 10 Data Architects (personally hired 7)o Created and implemented one enterprise data naming standard applicable across all data formats (XML, JSON, relational)o Designed flexible ingestion architecture to allow Client supplied data (Provider, Member, Plan) to be received in multiple formats and translated into a common format for internal consumption. This was achieved through flexible staging structures and a metadata driven ETL design.o Created a Code Set Management program roadmap and presented it to the CIO. These are industry standard code sets (ICD, CPT, HCPCS) whose relationship to AIM data is maintained by AIM clinicianso Designed flexible, re-useable treatment code hierarchy structures that enabled maintenance and consumption across the custom solutions within the OLTPo Initiated Data Flow Diagrams as standard Data Architecture deliverableso Created architectural standard for the decision of new JSON collection creation versus augmenting an existing oneo Oversight of the Enterprise Data architecture and modeling efforts for Provider, Member and Reference datao Oversight of the data modeling efforts for the new Insurance Claims Matching serviceTechnologies: Database – Sybase, SQL Server, Mongo ETL - DataStage, BI Tool – Business Objects, Tableau Data profiling tool – Rapid SQL Data Modeling Tool - PowerDesigner, Message Broker – TIBCO, RabbitMQ
    View
  • Accumedix, Inc.
    Contractor: Data Modeler
    Accumedix, Inc. Dec 2016 - Dec 2016
    Grayslake, Il, Us
    - Designed data model for in-house developed OLTP application that creates product labels and ensures FDA labeling requirements are met for medical devices.Technologies: Database – Access, Data Modeling Tool - Vertabelo
    View
  • Baxter International Inc.
    Data Architect (Sr. Business Systems Consultant/Business Systems Consultant)
    Baxter International Inc. Aug 2004 - Nov 2016
    Deerfield, Illinois, Us
    - Primary/Lead DA for Global and Regional Commercial/Financial DW. Resp/Achieve:- Analyzed solution alternatives, weighing pros/cons- Developed deep understanding of business data and processes - Created design for Enterprise Data Architecture that is re-useable, expandable, scalable and supportable. Design includes:-- Ability to handle multiple streams of data, Type 1 and 2 (slowly changing) dims, fact-less facts-- Ability to handle complex hierarchies containing one-to-many or many-to-many relationships -- Agile architecture approach leverages existing facts/dims with new data streams resulting in shorter delivery cycles by eliminating new DDL as part of development, leveraging existing reporting FM/reports- Selection, training, mentoring, oversight of all other Data Architect/Data Modeler hires- Reviewed/performed data modeling for new dev or enhancements to DW or custom in-house OLTP apps, including DDL generation from data model, execution into database- Led/participated in creation of Data Architecture/Data Modeling standards and guidelines- Developed hybrid Agile/Waterfall project approach for improved delivery speed- Key team member of merger/acquisition DW/BI team to integrate into existing architecture- Assisted driving data, business rule, data quality requirements, incl. method/accountability for data governance- Performed data profiling using SQL- Created/approved ETL specs incl. source-to-target mapping, trans. logic- Reviewed/approved DataStage job data flow, logic, business rule accuracy- Created/approved ETL test plan/cases- Reviewed Cognos FM layer for naming and data relationship accuracy- Performed back end data 2nd/3rd level support as SME - Member of tool eval/selection teams for data modeling, reporting and MDM- Led Data Management efforts for packaged software- Led BI Center Of Excellence (BI COE)- Member of Green Belt team for lean IT process improveTech: Oracle, DataStage, Cognos, Oracle Toad/SQL, PowerDesigner
    View
  • Baxter International Inc.
    Data Modeler (Sr. Business Systems Analyst/Business Analyst/Training And Management Consultant)
    Baxter International Inc. Jul 1993 - Jul 2004
    Deerfield, Illinois, Us
    - Primary/Lead Data Modeler for the design of the Commercial/Finance hybrid ODS, custom OLTP application and reporting environment Responsibilities/Achievements include:- Developed and implemented the newly created Data Administration/Data Modeler role and Data Management process for the divisiono Assisting project teams in driving data requirementso Developing deep business, data and design knowledge - considered a SME in these areaso Performed data profiling using Query/400 and Oracle Toad/SQLo Creation/enhancement, within PowerDesigner, of a Logical Entity Relationship Diagram (ERD) Data Model to be used as a first cut Physical Data Model when finalized with DBAso Performed hands-on data naming, data definitions, business rule documentation and data relationships within the Logical Data Model in Third Normal Form (3NF)o Led Data Modeling efforts, including selection and training of new Data Administrators/Data Modelers, for cross-divisional Data Management process. Considered Best Demonstrated Practice for Data Management throughout the companyo PowerDesigner tool administration – Performed all data model consolidations into golden/repository model, license key tracking/generation, invoice approval, tool support- Member of Access Tools Team for the Common Sales Database. Accomplishments included: selection, implementation, training, and on-going supporto Business Objects universe manager responsible for the design of several universes.- Developed newly created Training and Management Consultant position, responsibilities included:o Project manager of sales force computer training for division, including indirect supervision and development of training staffo Designed training materials and delivered training o Managed training and capital expenseso Vendor management of outsourced servicesTech: Oracle, PL/SQL, BRIO and Business Objects, Query/400 and Oracle Toad/SQL, PowerDesigner
    View

Cindy Elkins Skills

Data Warehousing Data Modeling Business Intelligence Sdlc Business Analysis Data Integration Etl Data Warehouse Architecture Database Design Dimensional Modeling Change Control Cognos Sap Master Data Management

Cindy Elkins Education Details

  • Northern Illinois University
    Northern Illinois University
    Operations/Production Management; Mathematics Minor

Frequently Asked Questions about Cindy Elkins

What company does Cindy Elkins work for?

Cindy Elkins works for Alliant Credit Union

What is Cindy Elkins's role at the current company?

Cindy Elkins's current role is Data Governance Manager at Alliant Credit Union.

What is Cindy Elkins's email address?

Cindy Elkins's email address is ci****@****ter.com

What is Cindy Elkins's direct phone number?

Cindy Elkins's direct phone number is +184740*****

What schools did Cindy Elkins attend?

Cindy Elkins attended Northern Illinois University.

What skills is Cindy Elkins known for?

Cindy Elkins has skills like Data Warehousing, Data Modeling, Business Intelligence, Sdlc, Business Analysis, Data Integration, Etl, Data Warehouse Architecture, Database Design, Dimensional Modeling, Change Control, Cognos.

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.