SUMMARY:

• 15+ years of IT experience with Business Intelligence and Data Warehousing solutions.
• 10+ years of experience in data architecture and system design.
• Experience withcomplex data integration methods.
• Experience in developing enterprise data models.
• Experience designing/developing complex data pipelines using a combination of standard tools and custom ETL tools.
• Advanced knowledgeof the software development lifecycleprocess.
• Experience in leading multiple projects simultaneously.
• Experience in designing and tuning large database environments.
• Strong verbal and written communication skills demonstrated by effectively communicating with team members and project stakeholders.
• Ability to analyze and solve complex problems and deliver solutions that are efficient and reusable while staying on time and under budget.

TECHNICAL SKILLS:

Technology: SQL, ETL, ORACLE, PLSQL, Cloudera, HIVEQL, Python, Java, C++, Visual Basic, SQL SERVER, SSIS, Cognos, OBIEE, ODI, Oracle Warehouse Builder, SOAP, RESTFUL API s, Informatica, Teradata, BTEQ, Facets, Postgres, Unix, JQuery, AWS, Hortonworks, Amazon Redshift, Hadoop, HIVE, Oozie, Kafka

PROFESSIONAL EXPERIENCE:

Solution Architect

Confidential

Responsibilities:

• Served as the lead architect overseeing the migration of multiple data quality platforms to a single Cloud platform.
• Responsibilities included defining proper data integration methods to migrate to the cloud, defining return data specs and processes, defining data models for analysis components and integrating the application with a separate Cloud vendor for single - sign-on.
• Responsible for assessing the current state data architecture of Confidential ’s EMPCO business unit and assisting in the planning of key initiatives for 2017.
• Provided future state architecture recommendations and roadmaps for 9 initiatives at Confidential .
• These projects focused on aligning multiple data assets with the future state architecture in order to reduce the overall technical debt at Confidential .
• Solution Architect - Land Of Lincoln Health
• Lead data integration architect for automating the processing of pre-authorization data feeds between multiple vendors.
• Land of Lincoln outsourced both claims payment and utilization management functions to 3rd party vendors and needed an automated solution to send data between vendors.
• Architected a solution that integrated provider and member data between the vendors and automatically sent authorization data, and authorization requests (via held claims) between vendors.
• Designed the data model for provider, member, enrollment and claim subject areas as well as built automated processing of files between the vendors.
• Solution Architect - Health Integrated
• Lead data architect for a next generation customer data ingestion platform.
• Responsible for designing an automated data ingestion platform to reduce customer on-boarding time from an average of 6 months per customer.
• Led the design of a data driven framework that automated the data ingestion process as well as fed downstream systems(Azure SQL Server). This included the logical and physical modeling of the metadata repository that drove the code generation as well as writing the templates for loading data, applying business rules and assessing the quality of the data.
• The end state system provided end users with a self-service application in which they could setup new customers and begin processing data in matter of days instead of months, without the need for additional IT development.
• Data Architect - Diamond Foods
• Diamond Foods was upgrading their ERP system from JDE Edwards version 9.0 to 9.1. As part of this initiative they wanted to automate the point-to-point data integration between JDE and Demantra, as well as build out an Enterprise Data Warehouse.
• Led a team of 4 developers building out the data warehouse serving as the Lead Data Architect. Responsibilities included, requirements gathering, designing the logical and physical enterprise data models across all subject and working with the executive team and department leads to ensure analytic requirements were met.
• Was also responsible for build out of metadata repository in OBIEE to enable self-service reporting and the design and buildout of custom reporting dashboards.
• Additionally, served as the lead architect on point to point system integration between the JDE and Demantra applications.
• Solution Architect - OPUS Bank
• Lead Data architect designing the data models for Credit Risk and Analytics business unit. The primary purpose of the project was to reduce the amount of time to produce the monthly Trial Balance reports. Upon completion of the project the required reports could be run daily.
• Worked with executive team to define analytic and reporting requirements and data acquisition needs.
• Responsible for working with customer staff to teach best practices in data modeling, data warehousing and etl design.
• The Data Warehouse covered subject areas for loan delinquency, loan origination, operational risk and loan health trending.

Confidential

V.P. Solution Architecture

Responsibilities:

• Produce roadmaps of current and future state warehouse solutions with explicit links to business strategies.
• Overall solution architecture and architecture treatment for data warehouse and analytic solutions.
• Draft and implement processes to gather functional and data requirements, design considerations and integration rules. This includes project scoping, project planning, resource allocation, data sourcing, report requirements, analytic requirements and business intelligence capabilities.
• Implement strategy for data integration and ETL development.
• Identify appropriate testing strategies and production rollout processes.

Principal Architect

Confidential

Responsibilities:

• Lead the design and implementation of the claims data warehouse and analytics infrastructure.
• Project scoping and planning.
• Requirements including analytics capabilities and data sourcing.
• Data Integration ETL development.
• Implemented data quality rules/process for managing data quality issues.
• Provided guidance and capabilities to support health care analytics and business intelligence functions.
• Solution Architect - BlueCross BlueShield Tennessee
• Developed Logical and Physical Enterprise Data models for Claims, /Enrollment. Provider, contracting, etc. for the Teradata semantic layer.
• Led the design and implementation of the Teradata semantic layer used to support Medical Informatics analytics and Business intelligence capabilities.
• Project scoping and planning, sourcing of resources.
• Requirements including analytics capabilities data sourcing and report requirements.
• Lead the data modeling and architecture design as well as provided leadership for Data Mapping and ETL/BTEQ development.
• Provided support for physical database design and query tuning for complex analytic queries in Teradata.

Confidential, IL

Sr. Data Architect

Responsibilities:

• Ledthe design of the Turn Around Cost Control Application. Primary roles included requirements gathering, developing the data warehouse data model as well as the OLTP data model. Also was responsible for designing ETL processes and data integration routines to integrate data from multiple source systems (Maximo, Primavera and SAP) and leading the ETL development team.. Additionally was responsible for implementing Cognos Framework Manager models as well as producing dashboard reports in Cognos Report Studio.
• Led the design of a data warehouse to be used for KPI reporting. Responsibilities included conducting interviews with business and key stakeholders to design and implement industry standard star schema models for the underlying data warehouse.

Confidential, Health Lisle, IL

Lead Etl Architect

Responsibilities:

• Tuned ETL's in ODS refresh process to meet requirements of nightly refresh. Refresh time was reduced from 5 days to 7 hours. This included multiple ETL's for and assessments that contained 500+ million rows of data.
• Created best practices for ETL design and development as well as best practices for query optimization.
• Design and development of person integration process used to integrate person across various source systems so that they would have a single identifier to tie them across all systems. Data included over 200 million rows of data.

Confidential, Oak Brook, IL

Consultant

Responsibilities:

• Served as the technical and data architect lead on various projects.
• ETL design and development using OWB(Oracle Warehouse Builder).
• Created best practices for ETL design and development.
• Developed dimensional model class for consultants.
• Created the dimensional data model used for BI applications.
• Performed ETL application tuning to ensure quality and timeliness of data.

Confidential, Lisle, IL

Data Architect

Responsibilities:

• Conducted interviews with key stakeholders and subject matter experts to identify the scope and requirements.
• Built Enterprise data model for the clinical ODS which served as the single source of truth for all Confidential t/payer interactions.
• Solutions Architecture - Leading and designing solutions that primarily aimed at integrating data from multiple source systems.
• Conducted data profiling on all incoming sources to ensure they met the intended requirements.
• Mentoring developers in best practices in ETL design, pl/sql design and query writing.
• Designed and developed the integration routines to create amaster person and master customer records.
• Tuning - Performing evaluations on complex queries. Including analyzing explain plans and making changes to the physical database model to improve query performance.
• Analyzing existing warehouse to identify issuesand provide recommendations to reduce loss of data, improve query performance (through improved physical database design as well as query rewrites) and resolve Data Quality issues.
• Provided written documentation artifacts includingconceptual, logical and physical data models, requirements documents, Data Flow Diagrams, ETL mapping specifications, test plans and documentation.

Confidential, Lisle, IL

Sr. IS Analyst

Responsibilities:

• Worked on all facets of an operational data store from conceptual to physical design.
• Performed in depth data analysis on incoming source systems.
• Logical and Physical Data Model design with Star Schemas
• ETL Development using Cognos Decision Stream as well as custom PL/SQL ETL routines.
• Implemented standards for delta management.
• Developed Solutions to solve complex business problems.
• Developed integration routines to create relationships between many unrelated source systems.
• Tuning SQL and PL/SQL programs for optimal performance
• Tuning Cognos Reportnet Reports /Framework Manager for optimal performance
• Architected and developed a SQL generator used to mine and extract data from external data stores.
• Conducted interviews with key stakeholders and subject matter experts to identify thescope and requirements.

Confidential, Lisle, IL

Business Analyst

Responsibilities:

• Conducted interviews subject matter experts to gather project requirements.
• Data profiling and mapping
• ETL Design and Development
• Bi Reports Development usingCognos report net
• Developed Cognos Framework metadata models.
• Requirements Gathering
• PL/SQL Development
• ER designs
• Tuning SQL and PL/SQL programs for optimal performance
• Tuning Cognos Reportnet Reports /Framework Manager for optimal performance
• Experienceusing XML
• Developed MetaData structures used to mine and extract data from external data stores.