Stephanie is a lover of logic and existential perplexities.
She is the author of the sci-fi novel, 'Scarlet Begonias', and is a multi-dimensional, database architect for a financial consulting firm in Chicago, Illinois. She lives in the northern suburbs of Chicago with her husband and daughter.
She is the author of the sci-fi novel, 'Scarlet Begonias', and is a multi-dimensional, database architect for a financial consulting firm in Chicago, Illinois. She lives in the northern suburbs of Chicago with her husband and daughter.
Career
Data Warehouse Manager – Technical Financial Analyst
Industry Experience in Financial Investment Consulting, Health Insurance, Employee Benefits,
Telecommunications, Product Tracking & Distribution, Immigration Law, Billing & Collections
-----
Innovative, versatile data warehousing information specialist with over 21 years of technical and analytical experience. Solid knowledge of database design, ETL development, and information analysis. Brings chaos to order, making sense of the most intricate patch-work of databases, data sources, logic and end-user data delivery applications. Comfortable analyzing, manipulating, modeling, and explaining data in multi-dimensional, relational, hierarchical, and flat file formats.
Consistently achieves target goals, approaching projects from initial creative vision to technical design, development, implementation, documentation, and training. Facilitates design coordination with internal and external community. Effectively delivers project solutions within a fixed budget and schedule. Hits the ground running in new situations with very little direction. Quickly assimilates and generates public libraries for database designs, metadata, process flows, program logic, and cross-departmental relationships.
Offers proactive decisions regarding new development, risk minimization, system expansion, redesign, and product enhancement. Understands that well-maintained, easily accessible information is imperative, insuring client contentment, corporate success and longevity in an ever changing business climate.
----
Financial Analyst - Career Accomplishments
- Calculated client portfolio performance using daily transactions and holdings data.
- Researched investment managers and products for client consideration
- Studied cycles, trends and correlations among industries, styles, regions, quality, risk, durations, and allocations
- Used historical asset data to predict future growth and characteristic trends
- Determined and tested portfolio rebalancing strategies
Data Warehousing Manager - Career Accomplishments
- Designed, populated, and maintained multi-dimensional data warehouses (100G – 2TB)
- Investment Management, Product, Index, Mutual Fund Analysis
- Portfolio Allocation & Investment Performance
- Rail Car Tracking (Parts, Repairs, Locations, Customers, Rental Contracts)
- Dental Association (Membership, Products, Payment, Dental School Accreditation)
- Product Distribution (Products, Manufacturers, Clients, Client Relationships, Shipping)
- Insurance Claims (Providers, Services, Products, Claims, Clients, Diagnosis, Eligibility)
- Designed, populated, and maintained relational and hierarchical databases
- Law Firm (Clients, Cases, Case Detail, Forms, Status, Fees, Payment, Scheduling)
- Release Scheduling (Project, System, Resources, Status, Release Dates)
- Co-location Facilities Assignments (Technical Details, Location, Status, Release Dates)
- Telecommunications Resale (Clients, Sales, Orders, Products, Services, EDI Requests)
- Employee Payroll & Disability Tracking
Designed and developed ETL, BI reporting, and analysis programs
Designed and populated metadata repositories
Performed legacy system data manipulation and cleansing
End-User and Technical Training
-----
Professional Experience
Ellwood Associates, Chicago, Illinois 2006 –Present
Data Warehouse Manager, ETL Development, Financial Analyst
GATX Rail, Chicago, Illinois 2001 & 2006 Data Warehouse Specialist,
ETL Development, Metadata Repository Consultant
American Dental Association, Chicago, Illinois 2005 & 2002
Data Warehouse Specialist, ETL & BI Reporting Development, User Training Consultant
Kenneth Geman & Associates (Immigration Law), Chicago, Illinois 2002 - 2006
Client Information Liaison, Office Manager, DBA, Bookkeeper, Paralegal
Talk America (Telecommunication), Chicago, Illinois 2003-2004
IT Release Manager, Technical Business Analyst
Ameritech (SBC), Chicago, Illinois 1997 - 2000
Data Architect / Metadata Repository Design, Technical Business Analyst Consultant
Alliant Food Service, Deerfield, Illinois 1996-1997
Data Warehouse / Metadata Architect, JAD Facilitator, Technical Business Analyst Consultant
Blue Cross / Blue Shield of IL, Chicago, Illinois 1993 -1995
Data Warehouse / Metadata Architect, Database Administrator, JAD Facilitator, Project Leader
Commonwealth Edison Company, Chicago, Illinois 1989 - 1993
Mainframe Developer, JAD Facilitator, Data Architect, Project Leader
-----
Skills / Tools Inventory Titles - Senior Data Administrator, JAD Facilitator, Data Warehousing Specialist, ETL Designer, Data Dictionary Developer, Project Manager, Intranet Developer, Systems Analyst, IMS DBA, Mainframe Programmer, Paralegal, Technical Document Author
Database Management - SQL Server, Informix, Sybase, Oracle, Excel, DB2, IMS DB/DC (DL1), Access, Teradata (DBC1012), VSAM (CICS)
Database Design - ErWin, Bachman, Visio, Cayanne
ETL / BI - Sagent, Group 1 Data Cube, SQL, Informatica, Excel Pivot Tables, Access Pivot Tables, Brio, Business Objects, DSS Agent, Prism
Financial Analysis - Factset (FDS,FQL), Evestment Alliance, Morningstar, S&P, Russell, MSCI, Lehman Brothers, Merrill Lynch,
Google Finance, Yahoo Finance, MSN Money, Advanced Excel
Programming Languages - SQL, GQL, Telon, Cobol, MarkIV, Assembler, JCL, Focus, CLIST, HTML
Windows Based Software (Reporting, Documentation) - Internet, Visio, Project Workbench, Power Point, Word, Excel, Access, Freelance
Operating Systems - Windows (Vista, 2000, XP, 98, 95, 3.1, NT), MVS (TSO/ISPF, CICS), DOS, OS2
Data Warehouse Manager – Technical Financial Analyst
Industry Experience in Financial Investment Consulting, Health Insurance, Employee Benefits,
Telecommunications, Product Tracking & Distribution, Immigration Law, Billing & Collections
-----
Innovative, versatile data warehousing information specialist with over 21 years of technical and analytical experience. Solid knowledge of database design, ETL development, and information analysis. Brings chaos to order, making sense of the most intricate patch-work of databases, data sources, logic and end-user data delivery applications. Comfortable analyzing, manipulating, modeling, and explaining data in multi-dimensional, relational, hierarchical, and flat file formats.
Consistently achieves target goals, approaching projects from initial creative vision to technical design, development, implementation, documentation, and training. Facilitates design coordination with internal and external community. Effectively delivers project solutions within a fixed budget and schedule. Hits the ground running in new situations with very little direction. Quickly assimilates and generates public libraries for database designs, metadata, process flows, program logic, and cross-departmental relationships.
Offers proactive decisions regarding new development, risk minimization, system expansion, redesign, and product enhancement. Understands that well-maintained, easily accessible information is imperative, insuring client contentment, corporate success and longevity in an ever changing business climate.
----
Financial Analyst - Career Accomplishments
- Calculated client portfolio performance using daily transactions and holdings data.
- Researched investment managers and products for client consideration
- Studied cycles, trends and correlations among industries, styles, regions, quality, risk, durations, and allocations
- Used historical asset data to predict future growth and characteristic trends
- Determined and tested portfolio rebalancing strategies
Data Warehousing Manager - Career Accomplishments
- Designed, populated, and maintained multi-dimensional data warehouses (100G – 2TB)
- Investment Management, Product, Index, Mutual Fund Analysis
- Portfolio Allocation & Investment Performance
- Rail Car Tracking (Parts, Repairs, Locations, Customers, Rental Contracts)
- Dental Association (Membership, Products, Payment, Dental School Accreditation)
- Product Distribution (Products, Manufacturers, Clients, Client Relationships, Shipping)
- Insurance Claims (Providers, Services, Products, Claims, Clients, Diagnosis, Eligibility)
- Designed, populated, and maintained relational and hierarchical databases
- Law Firm (Clients, Cases, Case Detail, Forms, Status, Fees, Payment, Scheduling)
- Release Scheduling (Project, System, Resources, Status, Release Dates)
- Co-location Facilities Assignments (Technical Details, Location, Status, Release Dates)
- Telecommunications Resale (Clients, Sales, Orders, Products, Services, EDI Requests)
- Employee Payroll & Disability Tracking
Designed and developed ETL, BI reporting, and analysis programs
Designed and populated metadata repositories
Performed legacy system data manipulation and cleansing
End-User and Technical Training
-----
Professional Experience
Ellwood Associates, Chicago, Illinois 2006 –Present
Data Warehouse Manager, ETL Development, Financial Analyst
GATX Rail, Chicago, Illinois 2001 & 2006 Data Warehouse Specialist,
ETL Development, Metadata Repository Consultant
American Dental Association, Chicago, Illinois 2005 & 2002
Data Warehouse Specialist, ETL & BI Reporting Development, User Training Consultant
Kenneth Geman & Associates (Immigration Law), Chicago, Illinois 2002 - 2006
Client Information Liaison, Office Manager, DBA, Bookkeeper, Paralegal
Talk America (Telecommunication), Chicago, Illinois 2003-2004
IT Release Manager, Technical Business Analyst
Ameritech (SBC), Chicago, Illinois 1997 - 2000
Data Architect / Metadata Repository Design, Technical Business Analyst Consultant
Alliant Food Service, Deerfield, Illinois 1996-1997
Data Warehouse / Metadata Architect, JAD Facilitator, Technical Business Analyst Consultant
Blue Cross / Blue Shield of IL, Chicago, Illinois 1993 -1995
Data Warehouse / Metadata Architect, Database Administrator, JAD Facilitator, Project Leader
Commonwealth Edison Company, Chicago, Illinois 1989 - 1993
Mainframe Developer, JAD Facilitator, Data Architect, Project Leader
-----
Skills / Tools Inventory Titles - Senior Data Administrator, JAD Facilitator, Data Warehousing Specialist, ETL Designer, Data Dictionary Developer, Project Manager, Intranet Developer, Systems Analyst, IMS DBA, Mainframe Programmer, Paralegal, Technical Document Author
Database Management - SQL Server, Informix, Sybase, Oracle, Excel, DB2, IMS DB/DC (DL1), Access, Teradata (DBC1012), VSAM (CICS)
Database Design - ErWin, Bachman, Visio, Cayanne
ETL / BI - Sagent, Group 1 Data Cube, SQL, Informatica, Excel Pivot Tables, Access Pivot Tables, Brio, Business Objects, DSS Agent, Prism
Financial Analysis - Factset (FDS,FQL), Evestment Alliance, Morningstar, S&P, Russell, MSCI, Lehman Brothers, Merrill Lynch,
Google Finance, Yahoo Finance, MSN Money, Advanced Excel
Programming Languages - SQL, GQL, Telon, Cobol, MarkIV, Assembler, JCL, Focus, CLIST, HTML
Windows Based Software (Reporting, Documentation) - Internet, Visio, Project Workbench, Power Point, Word, Excel, Access, Freelance
Operating Systems - Windows (Vista, 2000, XP, 98, 95, 3.1, NT), MVS (TSO/ISPF, CICS), DOS, OS2