TECHNICAL SKILLS:

SKILLS: Business Analysis, Business Process Modeling, and Data Modeling Enterprise Architecture Business Intelligence Analysis and Design Source Data Analysis Database Design Extract, Transform and Load (ETL) Design Metadata Management Master Data Management (MDM) Project Management/Team Leadership and Mentoring

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect and Data Analyst

Responsibilities:

• Identified product attributes to be stored in the Master Data Hub for use in various business applications.
• Met with business representatives to develop conceptual and logical data models for Supplier Quality process flows.
• Worked with business subject matter experts to identify data sources and develop logical and physical Oracle data models for Complaints workflow processes.
• Developed CAPA (Corrective And Preventive Action) conceptual data models

Confidential

Data Architectand Business Analyst

Responsibilities:

• Assisted in the development of an enterprise business intelligence reporting system. Several key reporting projects were vital to the ongoing health of the business, yet the organization lacked the skills and expertise to develop these applications.
• Gathered and modeled business requirements
• Identified source systems for required data
• Designed Netezzadatabase structures for a credit card reporting data mart
• Designed Netezzadatabase structures for a key credit indicator management scorecard mart
• Designed Netezzadatabase structures for a mortgage reporting data mart.
• Modeled and designed a Netezzadatabase for a risk reporting data mart
• Data marts needed to share data, which did not exist in enterprise conformed data structures. Therefore, I worked with the various project teams to not only develop database structures to meet their reporting requirements, but also to use common data structures wherever possible.
• Overcame a challenge as the business groups were driving the technical teams to develop systems quickly, which left little time for system integration work.
• Successfully integrated database structures across the new data marts.

Confidential

Data Architect

Responsibilities:

• Analyzed and designed Mileage Plus reporting upgrades
• Assisted UA staff to build an enterprise information management roadmap
• Examined opportunities to improve the design of the enterprise data warehouse environment, which includes both relational and dimensional structures
• Recommended improvements to be made to the data marts, which consist of both custom - developed and vendor-supplied data structures. These data structures are inconsistent and not well integrated across business areas
• Recommended improvements to integration between the data warehouse and data mart environments as each is redesigned for future growth. Confidential data structures, there was a need to make more consistent use of ETL tool to integrate data movement processes
• Examined ways to in corporate an enterprise metadata repository to assist with impact analysis for system changes, and to position the company to make fuller use of master data management processes and tools
• Optimized reporting structures for reporting tools that include Business Objects, Oracle OBIEE and Brio

Confidential

Senior Data Architect

Responsibilities:

• Designeddatabases for a variety of DB2 OLAP and OLTP systems
• Met with business and IT personnel to conduct business analysis and business modeling. These business models included data and process (behavioral) models
• Designed and implemented databases on DB2 and Oracle
• Played a key role in the high-profile hardware, software and consulting services evaluation of Teradata’s and HP’s Neoview data warehouse solutions.
• Evaluated vendor professional services and products,
• Assessed Kohl’s readiness to embark on an Enterprise Data Warehouse (EDW) re-platform effort.
• Incorporated Kohl’s Item MDM structures in the merchandising warehouse, with MDM project team interaction and validation
• Incorporated Kohl’s Item MDM structures in the merchandising warehouse, with MDM project team interaction and validation.
• Coordinated modeling efforts with data warehouse source data analysis, source-to-target ETL design, and BI report design and implementation (mostly Business Objects, with some Microstrategy)
• Supported data analysis and database design for several projects that use Kohl’s existing merchandising data warehouse (MW) and the newer corporate data warehouse (CW) and associated data marts.
• Designed operational system database structures
• Created conceptual, logical and physical data models and metadata using Embarcadero ER Studio, and managed data models in the Embarcadero model repository.

Confidential

Business Analyst

Responsibilities:

• Gathered and documented requirements for a major overhaul of Confidential ’s agent services website. Documentation included use case scenarios, screen mockups, and business rule text documentation
• Visited insurance agencies, examining competitor offerings, and evaluating commercial insurance carrier software products.
• Positioned Confidential to move past competitors, who, like the insurance industry, have been slow to automate agency and consumer support
• Helped Confidential to move quickly to make their internet presence strong
• Gathered business requirements and wrote up detailed requirements documents
• Created screen and report mockups
• Met with the technical teams to discuss design considerations.
• Trained a full-time employee to assume the role of marketing project analyst.

Confidential

Business Intelligence Consultant

Responsibilities:

• Met with staff personnel to conduct a study of Confidential ’s business intelligence environment.
• Recommended business and technical tools and processes to both improve the existing OLAP reporting environment and set the stage for future growth in business intelligence processes, tools and architecture.
• Met with DSI’s business and technical staff to assess the current situation.
• Assessed the technical situation within the BI environment
• Developed a comprehensive set of recommendations.
• Technologies evaluated included the SQL Server BI toolset.

Confidential

Data Architect

Responsibilities:

• Supported two OLAP data mart projects implemented on SQL Server 2005 using Analysis Services cubes.
• Gathered reporting requirements for a consumer marketing data mart to serve as a basis for comprehensive consumer demographics and purchase behavior data mining.
• Gathered data requirements during multiple work sessions with the consumer marketing data mining team
• Developed logical and physical data warehouse and data mart structures
• Developed data movement (ETL map) designs
• Gathered business requirements, modeled entities and relationships, created detailed data mappings and tables for various employee performance reporting scorecards and executive dashboards
• Supervised the creation of ETL maps for the data warehouse and data mart data movement processes.
• Redesigned the database for the main source system for performance scorecards and dashboards, the Employee Tracking System,
• Ensured that performance metrics would better manage employee performance targets and forecasts
• Ensured that the designs would support better data integration with other application systems.
• Technologies included Business Objects, Informatica ETL, SQL Server Analysis Services and Performance Point BI tools.

Confidential

Responsibilities:

• Team Lead and application and data warehouse Architect for a sales performance dashboard project
• Designed an application that integrates sales reporting across the Confidential sales teams across the division. This included designs of master data structures (MDM) consistent with the corporate EDW model.
• Redesigned both the OLTP and OLAP databases in Teradata
• Redesigned the cube structures in SQL Server Analysis Services.
• Helped develop and analyze user cases
• Designed part of the user scorecard interface.
• Assumed the role of Team Leader and coordinated activities between our onshore client-side development team and the offshore ETL development team.
• Wrote a performance test plan
• Coordinated the writing of test scripts for system and user acceptance tests, and executed many of these tests
• Planned and coordinated performance testing across the multiple server environments (IIS web server, SQL Server Analysis Services, Dundas controls, Informatica ETL, Teradata server).
• Ensured project success, with business users well satisfied with the function and performance of the system.

Confidential

Responsibilities:

• Application Development DataTeam Lead for a large integrated corporate planning system.
• Coordinated design and build activities for the largest portion of this integrated planning system, using an Agile development process.
• Performed as chief data analyst and data architect
• Performed as a team leader of data source systems analysis, database implementation and management, and application development surrounding database access.
• Validated use case scripts against screen mockups and database designs.
• Modeled business data requirements and supported database redesign and tuning
• Conducted business analysis and design with UML modeling tools, as well as data modeling using ERwin.
• Acted as the sole Corporate Data Administrator for transactional and data warehouse systems
• Gathered recorded business data requirements and metadata
• Analyzed and modeled master data (MDM) data requirements in the enterprise conceptual model
• Modeled data requirements in ER diagrams
• Developed database designs for DB2, Oracle and SQL Server databases, and generated the physical databases. The databases included those large transactional systems, end user reporting systems, a sophisticated data warehouse management environment, and data mart reporting systems
• Ensured that data requirements and resulting databases adhered to a formal data architecture for systems across mainframe platforms. The design work involved building numerous normalized staging databases as well as dimensional reporting structures.
• Developed third normal form models for the staging and central data warehouse DB2 databases
• Developed star schema dimensional models for the OLAP data marts
• Mapped data elements from source systems to target data structures.
• Modeled data requirements using ERwin Data Modeler and ERwin Model Manager tools.
• Designed OLAP data warehouse databases to integrate pricing and product information, as well as retail sales.
• Designed a method to migrate operational database data. This method included cleaning and staging data using source system Change Data Capture (CDC) and ETL processes to enterprise data staging databases, which fed a centralized data warehouse database.
• Redesigned parts of the centralized enterprise data warehouse (EDW) database to be used as the source for a conformed dimensional store database, which then fed the ultimate data mart structures
• Examined opportunities to develop object models to integrate existing business data models and application process models together, ensuring better integration across application system.
• Modeled business requirements and designs using Unified Modeling Language (UML) notation. The iterative development process was Agile, similar to Rational Unified Process (RUP).
• Enhanced the process and infrastructure for managing corporate metadata.
• Converted a mainframe data dictionary to ERwin and ModelMart (now called Model Manager).
• Designed and implemented numerous databases in mainframe DB2, Oracle and SQL Server, for applications running in Microstrategy and Cognos BI environments.
• Studied ways to in corporate ontology and taxonomy concepts into Miller’s metadata repository environment

Confidential

Responsibilities:

• Business Analyst, filling in for two business analysts and the manager, that went on scheduled leave.
• Had to quickly learn the funds management business requirements and the associated information systems, including processes and systems of an external funds transfer agency
• Helped integrate Strong Capital Management systems with those of Confidential
• Performed business analysis and systems design for Sybase and Oracle database systems.

Confidential

Responsibilities:

• Data Architect, primarily on OLAP projects.
• Worked with business personnel and various project teams to determine the feasibility of new or follow-on projects that would enhance features present in the data warehouse and data mart databases.
• Gathered business data requirements, modeled these requirements (including the necessary metadata definitions), and implemented designs with physical database enhancements in the OLAP data staging, warehouse and mart databases.
• Studied how best to implement a data model repository (data dictionary) that would better integrate the various project views of the data warehouse databases (these wer not truly integrated, leading to increased potential for duplication of model components and confusion among the users of the models).
• Evaluated ways to implement a broad set of processes to manage metadata Confidential what was already stored in the project data models. This included creation and management of business process models and use case documents, although the initial emphasis was on data model integration.
• Incorporated Customer MDM concepts in the data warehouse and data mart data models and databases
• Worked with modeling tools including Erwin for database design, Informatica for ETL work, and Cognos for reporting.
• Worked within an iterative development approach (Rational Unified Process).
• Created and enhanced databases in DB2, Oracle and Sybase.

Confidential

Responsibilities:

• Coordinated business analysis, design and development for an OLAP data warehouse and data mart project
• Gathered project business requirements, modeled the requirements, designed databases for initial staging, accredited staging, and data warehouse reporting databases
• Wrote detailed data movement specifications for, and implementation of, ETL processes.
• Identified data source systems for each requirement,
• Mapped the movement of data from operational source systems (representing a variety of formats and stored in technologies such as DB2 and SQL Server) to the initial staging database (same formats as the sources, but stored in DB2/UDB),
• Mapped initial staging database data to the accredited staging database (third normal form in DB2/UDB), and
• Mapped the data from the accredited staging database to the data warehouse reporting database (multi-dimensional structures in DB2/UDB). Data mapping included all requirement data movement and transformations, plus recording all metadata that describes the involved data elements.
• Supervised the development and implementation of ETL processes to extract data from the source systems, transform the data, and properly place the data in the various databases.
• Proposed improved data warehouse and data mart designs that would benefit all other projects that used my designed components.
• Ensured that staging database designs were all reusable
• Designed and built conformed (reusable) dimensional data structures where possible.
• Ensured that all data types, names and definitions were present and properly entered in the mainframe metadata repository (data dictionary).
• Supervised the functional aspects of Informatica ETL process development, and worked with the testing team to ensure that the developed ETL processes adhered to the business and technical requirements.
• Worked with developers using Informatica tools for both the ETL processing and Business Objects for report building.
• Worked with the Rational Unified Process (RUP) iterative development process.
• Implemented databases in DB2/UDB, and sourced data from Oracle and Sybase databases.

Confidential

Business Analyst and Systems Analyst

Responsibilities:

• Conducted extensive business analysis and application design sessions with business subject matter experts to develop an entirely new field office management system and a new central office billing system.
• Gathered extensive business requirements and modeled MDM concepts for Customer, Employee and Product(Service).
• Gathered extensive business requirements and created formal requirements models and formal application and database designs. These designs included object models and relational data designs.
• Discovered opportunities to build reusable application modules into the system, matching the enterprise database and systems architectures.
• Supported workstation software development using Delphi, application server development using PL/SQL and Oracle databases, and the central office systems were IBM mainframe and AS/400 systems
• Worked with an iterative design and development approach (proprietary, but very similar to Rational Unified Process).
• Designed databases that were implemented in Oracle, with feeds to AS/400 and IBM mainframe databases and files.
• Supported all aspects of application development, particularly AD/Cycle, IBM's framework for supporting Computer Aided Software Engineering.
• Specialized in business process and information modeling, and relational database design and implementation, including applications using fourth-generation languages.
• Assisted sales teams in business and technical consulting services. T
• Presented both product and services seminars throughout Wisconsin.

Senior Business Analyst

Confidential

Responsibilities:

• Supported, across many client organizations, users of micro and mainframe computers
• Trained end users and developers
• Conducted systems analysis
• Developed end user applications.
• Developed software applications and served on client committees to evaluate mainframe and microcomputer software.
• Serviced clients including law offices, financial planning firms, insurance agencies, medical clinics and manufacturers.
• Assisted the selling of information management consulting services in Milwaukee, Madison, and the Fox Valley.