Employment Objectives:

To provide superior skills and knowledge in the areas of Data Integration, Data Architecture, Data Warehouse Architecture, Data Modeling, ETL Architecture, and ETL Development and to provide leadership, training, and management to team members in these areas.

System Knowledge:

Languages/Tools: C, shell scripts, Microsoft Office, SQL, IBM Infosphere DataStage 8.x, ERStudio 7/8, ERWin 7/8, PowerDesigner, SQL Server SPL, DB2 SPL, Oracle PL/SQL

Databases: Microsoft SQL Server 2000/2005/2008, Oracle 10g/11g, IBM DB2 for iSeries V5R4, IBM DB2 LUW 9.x

Classes/Training: Informix Relational Database Design, Managing and Optimizing Informix - Online Dynamic Servers, and Informix-Online Dynamic Server System Administration, Data Warehousing in Depth - Kimball University

Employment History:

Confidential

Responsibilities Consultant: Senior Data Warehouse Engineer

• Provide direction, leadership, and training for a recent installation of IBM InfoSphere DataStage to existing team members.
• Re-configure existing IBM InfoSphere DataStage installation to utilize native Oracle connectivity.
• Request and configure new IBM InfoSphere Services Tier to construct new Test/QA and User Acceptance Testing environments.
• Re-architect existing DataStage jobs to utilize better data flow and increased selection criteria from source DB.
• Educate team members and management on basic Dimensional Modeling principals and the benefits of a true dimensional design.
• Educate team members and management on Data Warehousing Architecture including Data Integration, Data Standardization, Data Cleansing, ETL Architecture, and data flow principals.
• Develop Dimensional Models to replace existing ad-hoc reporting tables/databases to meet business informational needs.

Confidential

Responsibilities Consultant: Lead Information Architect/Data Architect

• Provide assistance and direction on corporate projects to team members for data sourcing, data integration standards, and use of existing data integration services.
• Develop conceptual and logical data models
• Provide direction for Project Data Architects
• Contribute to the team in setting up new procedures and documentation for future evolution of the Data Architecture team.

Confidential

Responsibilities Consultant: Data Architect/Database Analyst

• Design modification to existing transactional database to support application enhancements to the current call center application.
• Design new transactional data model to support new call center application which is integrated into the existing application.
• Provide UI design for new application screens and conduct review meetings with Business Analyst and Business Subject Matter Experts to receive approvals or recommended changes.
• Provide Application Architecture recommendations and best practices to Business Analysts and Business Subject Matter Experts as to how the application should perform in some areas and how it may perform in others using past experience working on similar projects with Application Architects. This function is being provided since an actual Applications Architect was not assigned to the project.
• Provide project Testing Lead with understanding of how the new application is to act and how the enhancements will change the existing application. Assist with providing a direction on how to test the application.
• Evaluate existing Oracle PL/SQL code to determine gaps in data integration with other Medtronic data sources that feed the existing application.

Confidential

Responsibilities Consultant: Data Integration Services Team Lead/Manager/Data Architect

• Lead and manage a group of 7 team members 1 consultant and 6 employees.
• Provide architectural direction for the team within a new strategic plan for Data Integration across the enterprise.
• Provide HR management direction for the team including hiring, approving timesheets, conducting individual weekly meetings, conducting weekly team meetings, and all other HR related items with the assistance of the HR department.
• Provide project management responsibilities, including resource planning, prioritization, and scheduling for projects that are assigned to the team. Average project workload includes 10 simultaneous sub 200 hour projects and 5 200 hour projects including 3 over 1000 hours.
• Assist in the overall resource planning efforts for the Business Applications Division along with other team leaders.
• Provide training to team members on the principles of Data Management, Data Flows, Data Warehousing, and Data Integration.
• Align current team members with new roles to facilitate new team direction in Data Warehousing and Data Integration Data Modeling, ETL Architecture and Development, and BI Architecture and Development.
• Provide solutions for data integration across Private Healthcare business and Medicare business including designing new Operation Data Stores and Self-Service reporting.
• Develop data strategy to support the Patient Protection and Affordable Care Act including healthcare enrollment through the Federally Facilitated Exchange as well as in-house developed member web portals and HIPPA standard X12 EDI file formats.
• Help facilitate cross-team coordination of work on projects where multiple application teams are required and architecture involvement is also needed.

Confidential

Responsibilities Consultant: Data Architect

• Participate in weekly Stakeholder's meeting which includes company VPs and Directors to assist in direction options, project updates, and issue mitigation/resolution.
• Design a new Enterprise Data Warehouse to support Marketing Analytics and Campaign Operations for Lacek's many customers.
• Confidential Responsibilities Consultant: Data Warehouse Architect
• Assisted in the mapping of data from a source Oracle Applications environment to an existing Reporting Data Store.
• Provide leadership and direction to Stakeholders to highlight effectiveness versus costs versus timeline. Manage stakeholder's expectations based on available personnel resources and timelines.
• Provide direction to the business community in proper ways to manage operational system data and the impacts of downstream systems when management practices are not followed.
• Design new operational databases to facilitate the storage of master data to provide efficiency in corporate use as well as to provide accuracy and accountability to Lacek and its clients.
• Initiate and communicate new standards and practices across the organization to facilitate proper data management at all levels.

Confidential

Responsibilities Consultant: Data Architect

• Design and manage the data architecture for a new product, EDPS Encounter Data Processing Services, which will produce data submissions via X12 EDI Interchange with the US Government Agency CMS, providing revenue for OptumInsight in the millions. Top three project within OptumInsight.
• Data modeling to handle inbound and outbound EDI interchange formats/requirements along with handling EDI response files and the content contained within from CMS.
• Train and educate development staff and QA staff as to the data model design
• Provide subject matter expertise as it pertains to the X Claims EDI format to the development staff and QA staff.
• Assist the Application Architect with direction and design as it pertains to the data lifecycle throughout the entire system.
• Provide insight and direction for developing a reporting environment and a Data Warehouse environment.

Confidential

Responsibilities Consultant: Data Architect

• Provide data modeling for on-going projects in the OLTP/transactional realm.
• Provide data modeling for the new BI initiative as well as participate in system architecture discussions to provide ideas and feedback.
• Conduct meetings with business users to gather insight into their current reporting environment.
• Provide analysis from meetings with business as to their reporting requirements as well as analysis of existing reports to help identify information categories, subject areas, etc.

Confidential

Responsibilities: Consultant: System Architect/Data Architect/ETL Developer

• Continue my previous work on the Person -Based Proof-of-Concept System by making the system a live system for use by all courts in the State of Oregon.
• Provided the System Architecture Design for the new Person-Based Operational Data Store
• Provided the Logical and Physical Data Models for the PB ODS as well as the DDL script to generate the environment.
• Assisted in the installation of IBM Websphere DataStage along with other configuration
• Designed and developed all ETL processes for approx. 10 different subject areas in the PB ODS model.
• Designed and developed an incremental load process for batch loads of the PB ODS to keep the data in sync with source system.
• Assisted in data analysis and profiling of source system.
• Continue maintenance of all project documentation pertaining to design and development of the PB ODS including model changes, DDL changes, ETL changes, and a change log.

Confidential

Responsibilities: Consultant: Data Architect

• Create new data model to support the Child, Adult, and Family Self Sufficiency Modernization Program which entails bringing together all current manual processes for applying for benefits into a streamlined web based application with a single centralized data store running in DB2 LUW on an AIX platform.
• Provide leadership and training on database modeling and data analysis.
• Provide database administration responsibilities for development, test, and UAT environments including permissions, database object creation, and data manipulation.
• Work extensively with business leaders in defining data requirements and their relationships with existing data requirements and database structures.
• Provide solutions to design obstacles as it pertains to data and the flow of data through the application.

Confidential

Responsibilities: Consultant: Data Modeler

• Assist in the data modeling effort for a European Solvency project which includes company Assets, Liabilities, and Cash Accounts.
• Provide mapping to generate data feeds to European Headquarters to fulfill government Solvency requirements
• Provide design options for data mapping and storage
• Provide detailed Data Flow Diagrams, detailed ETL Data Mapping documents, and detailed Design documents.

Confidential

Responsibilities: Consultant: DataStage ETL Developer

• ETL Developer for a new web based internal Ingenix/UHG application that provides medical and pharmaceutical information to be used by company actuarial and other business representatives. The application will provide health planning information to determine best outcomes and provide insight into developing new programs for members to participate in.
• Perform data mapping documentation
• Assisted in review and recommendations of current data model
• Provided assistance in developing ETL flow
• Performed DataStage development for all ETL work.

Confidential

Responsibilities: Consultant: Data Warehouse Architect

• Developed an Architectural Roadmap including a 6 month, 1 year, 3 year, and 5 year plan for the State Court's Case Management System showing a unified/consolidated data environment which would utilize future and current external data sources for enhancing system information, as well as defining a new Data Warehouse environment thus allowing analysis to be performed at a state level rather than at an individual county court level.
• Developed a high level data migration plan for the conversion of current systems to a new Electronic Content Management system, a new Case Management System, a new Operational Data Store, and a new Data Warehouse.
• Lead Architect/Designer/Developer on a new Proof of Concept Operational Data Store environment which would provide a person based centralized case management system thereby allowing Judges and other court employees to perform Criminal History reporting.
• Designed/Developed architectural plan for new Operational Data Store
• Designed new Data Model for Operational Data Store
• Helped define business rules for merging/matching individual party records from source into one unique individual record in the Operational Data Store
• Designed/Developed ETL architecture for migrating and converting the source data to the Operational Data Store including initial loads and ongoing incremental loads
• Designed/Developed all stored procedures to implement ETL architecture and design
• Performed Unit and System Level testing with 2 group members.

Confidential

Responsibilities: Consultant: Data Architect

• Assisted in the setup of a new SQL Server/SSIS environment.
• Performed SSIS development for new parent company data feeds.
• Performed database design and SSIS development for new Identity Management system which will be used for managing local and remote employee user access as well as agent and agency access to company applications.
• Provided Data Warehouse training to existing staff.
• Reverse engineered source DB2 AS/400 IBM iSeries V5 OLTP environment.
• Reverse engineered DB2 AS/400 IBM iSeries V5 reporting environment.
• Developed new data models to support new business functionality and increase productivity.
• Developed new Enterprise Logical Data Model to provide data consistency, ease of development projects, future functionality, and the support of new Risk Management Association requirements.

Confidential

Responsibilities: Consultant: Data Modeler/Data Architect

• Design new Enterprise Data Warehouse architecture and structure incorporating some legacy definitions.
• Design new Enterprise Data Warehouse Star Schema data models/data marts following Kimball methodologies.
• Assist in the development of a new data modeling and documentation approach.
• Develop Data Mappings for all new data models generated.
• Provide leadership and knowledge to ETL development team for ETL Architecture and Methodologies for new Data Warehouse.
• Develop new and modify existing transactional system OLTP data models incorporating into existing legacy systems based on project requirements.

Confidential

Responsibilities: Consultant: Lead ETL Developer

• Design a new ETL architecture for all development of an existing Data Warehouse.
• Perform all ETL development for new requirements for the Data Warehouse
• Assist in the training of the new Data Architect employee
• Assist in the data modeling of new subject areas for the Data Warehouse

Confidential

Responsibilities: Data Architect

• Provide sole ownership, knowledge, and reference for the data model of a young 4 years backend equipment leasing application called ProFinia.
• Work directly with Product Managers, Business Analyst, and Application Architects to gather and analyze data and business requirements for impact analysis on the existing ProFinia data model.
• Provide knowledge of future growth possibilities and an enterprise vision of the life of the Product in order to make the correct modeling decisions.
• In charge of designing new functional areas and modifications of existing areas in ProFinia. Changing include new or modified tables, foreign key relationships, indexing, etc.
• Manage numerous data model change requests from a development staff of approximately 65 in two locations: Minneapolis Bangalore India.
• Assist in the training of development staff of relational database design, the importance of correct design, and the enterprise approach.
• Develop standards for the ProFinia data model including but not limited to domains, abbreviations, naming standards, default values, etc.

Confidential

Responsibilities: Senior Programmer Analyst/Data Warehouse Data Architect

• Lead ETL Architect/Developer using Ascential DataStage.
• Lead ETL/Data Architect/Data Modeler for new Data Warehouse initiative including conceptual and physical design of staging and target DW environments and ETL architecture and standards following the Kimball methodology for Data Warehousing.
• Complete data analysis of source systems to facilitate model designs which were appropriate for business use and analysis.
• Conversion of existing Microsoft DTS packages to Ascential DataStage jobs.

Confidential

Responsibilities: Senior Technical Analyst/Database Administrator/Data Warehouse Architect

• Data Warehouse database architect/designer following Kimball methodology.
• Lead Data Warehouse ETL developer using Informix Stored Procedures, C programs, and UNIX shell scripts previously used Ascential DataStage 5.2 for 3 years . Develop and implement ETL jobs to populate new Data Marts, dimensions and facts, based on new business requirements.
• Data Warehouse reporting support for Brio reports including custom designed Executive reports.
• Lead/SR. Informix Database Administrator. DBA duties including database and application maintenance and development, performance tuning, backups, space management, and database design for 3 production, 4 test, and 3 development environments. ERP-Baan, CRM-Vantive, DW on Informix 7.31 Recently taken Lead/Sr. Microsoft SQL Server DBA responsibilities as well for approximately 30 SQL environments.
• Lead UNIX technical resource/programmer involving all UNIX related programming including Korn/C shell scripting, Informix ESQL/C, C, and Informix 4GL programming for business applications and tools.
• Project management involving planning, developing requirements, resource management, development, user acceptance testing, and implementation
• Baan C4 technical/systems analyst.

Responsibilities: Consultant: System Architect

• Converted old SCO UNIX environment to Red Hat Linux. Upgraded outdated Informix-SE system to new LINUX platform. Designed, developed, and implemented new relational OLTP database using Informix-SE and a new Clinical Processing System using Informix-4GL which includes data entry screens, monthly and daily reports, and batch jobs. Helped to design a Web based system for external clients to access their monthly and daily reports.

Confidential

Responsibilities: Lead Programmer Analyst/ Database Administrator

• Lead programmer for online MLS Tax Systems using Informix 4GL under an Informix 5.x and Informix 7.x environment running on Solaris platforms. Duties included client customizations, code reviews, production support, and new development.
• Lead DBA for all OLTP customer systems. Duties included database installations, disk/space management, performance tuning SQL, fragmentation schemes, server parameters, etc.
• Lead database designer for new client systems as well as systems that will undergo upgrades.
• Primary resource for making Informix recommendations to the company for current issues as well as for new product development.

Confidential

Responsibilities: Database Administrator

• Lead DBA on a Global Investments Management database running an OLTP environment with Informix 7.3 on Sun Solaris platforms. In charge of server performance tuning, database size scaling, security, and application SQL recommendations.
• Support DBA on an Imaging and Workflow Utility running an OLTP environment with Informix 5.10 on HP-UX platforms using a remote storage device to store optical images. Assisted lead DBA with database migration, database maintenance, and database performance tuning. Involvement with application group for development of new releases of database.
• Lead DBA on Financial Advisors Sybase SQL Anywhere database. Performed database modifications following quarterly release schedule. Used Installshield 5.0 to package databases for shipment to remote advisor's computers.
• Team member to review and make recommendations on SQL code as well as member of On-call group for environments running in Informix, Sybase SQL Server, Sybase SQL Anywhere, and Microsoft SQL Server.

Confidential

Responsibilities: Information Consultant

• Informix Consultant for a Minneapolis-based Data Warehouse client developed and enhanced 4GL applications and Crystal Reports used to populate client databases made recommendations for system and process improvements ran Solaris on Sun using 5.0 production PC platform and 7.22 versions of Informix Online servers.
• Lead analyst and system administrator as well as database administration on one of 3 projects for a Detroit-based major health care insurer supports team responsible for production maintenance of Informix system and new development projects planning migration from Informix SE 5.x to version 7.x, and hardware and OS upgrade from Dell/SCO to Sun/Solaris
• Consultant for a Minneapolis-based Multiple Listing/Tax Service enhancement and testing of 4GL applications, presented and documented recommendations for UNIX system and Informix database improvements, lead UNIX/Informix system administrator running Informix 5.0 and Informix 7.24 on Solaris 2.5.

Confidential

Responsibilities: Senior Programmer/Analyst

• Creation and modification of client and in-house reports using Informix 4GL embedded with Informix SQL and remote C function calls
• Responsible for the training of new employees/consultants on the existing system
• In charge of all invoicing and balancing of client's claims
• Delegating new task and problem reports to others within the group
• Maintaining reporting task and problem report system
• 24 x 7 on call support
• In charge of production support for all reports. This included the following responsibilities:
• Creation and modification of databases and tables including revising indexing to increase productivity
• Co-project leader on the design and development of new software releases
• Setting up test databases for testing purposes for new releases