CANDI WESTIN

adcr7m@r.postjobfree.com

720-***-****

OVERVIEW

Highly motivated and solution driven with 20 plus years of experience in IT Industry with experience in ETL architecture, analysis, design, testing, development, production support, data warehouse maintenance, documentation, and implementation of Master Data Managment solutions.

Expertise in providing Business Intelligence solutions using IBM InfoShere Information Server DataStage in Data warehousing and Decision Support Systems.

Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.

Strong knowledge of DataStage Parallel Extender, Server modules, transforms, routines, containers and sequences.

Experience in batching process executions using Kenneth Bland Associates methodologies.

Knowledge in Dimension Data Modeling concepts like Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Extensive experience in ETL concepts. Moving data from various sources into Data Warehouses and Data Marts using IBM InfoSphere Information Server DataStage Designer, Manager, Administrator and Director using Oracle, MS SQL Server, flat files and vice versa.

Highly experienced in troubleshooting ETL jobs, addressing production issues, performance tuning and fixing data issues. With extensive experience in unit testing, functional testing, regression testing, user acceptance and performance testing.

Experienced in generating Simple, Pivot, Detailed, Aggregation of Reports using, Business Objects, Crystal Reports, standardized flat files and MS-Excel.

Expertise in IBM InfoShere Information Server DataStage project administration for software, user profiles, and privileges using IBM WebSphere Integrated Solutions Console and InfoSphere Information Server Console for versions 9 and 11.

Extensive experience in IBM InfoShere Information Server DataStage installations and migrations using version 8.x through 11.x.

Strong experience in coding using SQL. With experience in building Procedures/Functions, and views.

Worked on variety of industry/functional areas including Nurse Advice Line, Disease Management, Claims, Billing, Transportation, Logistics, and Care Management systems.

Technical ETL Team Lead enforcing ETL best practices and distributing work and responsible for providing technical expertise for the design and execution of ETL projects.

Experience developing in an Agile Scrum/Kanban and Waterfall Environment, Experience building Stories, Features, Epics, in an Agile environment and Project Plans in Waterfall environment. Currently seeking certification for SAFe 4 Agilist.

Experience building and extracting data in Expert Systems/Rules Based Systems.

Understanding of Big Data and Hadoop fundamental concepts.

Excellent Analytical, Interpersonal, and Communication skills.

TECHNICAL SKILLS

ETL Tools: IBM InfoSphere Information Server - DataStage 6.X/7.0/8.1/8.5/9.1.2/11.5/11.7 (Designer/Manager/Administrator/Director/WebSphere Integrated Solutions console/InfoSphere Information Server console).

BI Tools: Crystal Reports, Business Objects, Cognos Impromtu, Sagent Design Studio, ProClarity.

Programming Languages: SQL, Batch and Shell scripting

Development Tools: SQL *PLUS, TOAD, SQL DEVELOPER, CoreFTP, PuTTY

Packages: MS Word, MS Excel, Skype for Business, Microsoft Teams, JIRA

Scheduling Tools: Tivoli, ProActive, IBM InfoSphere Information Server

Databases: ORACLE 7.X/8.0/8i/9i/10g/11i/, Sql Server and DB2

Operating Systems: Windows 2000/2008/2007/2005/NT/XP/10 Enterprise, UNIX (RHEL 5, 6,7)

EXPERIENCE

Mitchell Martin, Inc.

MetLife, Inc.

Cary, NC SOFTWARE DEVELOPMENT ENGINEER

Data Warehouse

June 2019 – Present

Project: I am working with the Global Technology Service Performance Management team in collaboration with off-shore team to manage and enhance MetLife's Visibility Data Warehouse which houses financial data, employee/contingent data, Service Level Agreement data, and Performance and Accountability data for stakeholder analytics.

Responsibilities:

Implemented new functionality through data sets into Visibility Warehouse required by the business stakeholders.

Built automated processes through scheduled Materialized Views to collect defined data sets supporting report standards.

Manage scheduled and emergency production releases using ServiceNow and standardized Change Control processes.

Manage Visibility Warehouse daily loads, define, troubleshoot, and communicate incidents to stakeholders.

Partner with ETL team members to define new and changed requirements and timelines for production releases.

Participate in Agile Ceremonies Program Increment planning for the GTS Agile Train Release process.

HGS AxisPoint Health

Westminster, CO - Remote SENIOR LEAD ETL DEVELOPER

June 2015 – May 2019

HGS AxisPoint Health is a population health management company that combines innovative technology with care management services to achieve the Triple Aim of healthcare. Expert care teams leverage predictive analytics, advanced care management software, and consumer engagement technology to guide, impact, and personalize the care experience and make a difference in people’s lives by effectively engaging them to improve their health. I worked with various projects of the care management data warehouse and health data repository.

Responsibilities:

Implemented new Mart for Care Management: This included designed new tables, developed ETL jobs to add new staging tables, dims, and facts for Goals, Barriers, Interventions, and Member Assessments using star-schema principals. The mart was a key success factor in the new Care Management Platform and is used for reporting, operational management, compliance and the Care Management application. Implemented multiple new clients into mart for CarePoint, GuidePoint, Claims fact and dimension tables where applicable.

Built automated processes to support reporting standards for client facing AXIS Data Extracts.

Built reusable processes to load historical eligibility spans for all new client implementations and executed these processes when implementing new clients.

Administered all DataStage projects, added and managed user profiles and privileges, and maintained DataStage software functionality using IBM Websphere integrated solutions console and Infosphere Information Server console.

Installed and implemented DataStage new environment for version 9.1, 11.5, and 11.7.

Upgraded DataStage development environment from 9.1.2 to 11.5 using a dual side-by-side installation to prepare an upgrade throughout all environments to the latest version of DataStage.

Provided production support by troubleshooting and fixing problems in DataStage job executions for data mart loads and data extracts.

Implemented and maintained schedules for job executions using DataStage and ProActive.

Continuously evaluated load methodology to maintain a clean fast running environment. As a result, was able to reduce Mart weekly load times from upwards of 20 hours down to 6.

Manually maintained ETL batch and control files to keep ETL loads running cleanly.

Acted as ETL Team Lead, ensuring remote team was working together on all efforts and properly communicating and following developmental standards and ETL best practices.

Lead multiple IBM InfoSphere Information Server migrations to new data centers from project planning through deployment. Working diligently nights and weekends to ensure we not only met the deadline, but far exceeded it.

Lead multiple IBM InfoShpere Information Server upgrades from project plan to deployment. Including migrating DataStage database stages to database connectors. Making sure we had hardware built for the correct operating systems for desired topology with optimal system requirements.

McKesson Corporation

Westminster, CO – Remote SENIOR ETL DEVELOPER

November 2008 – June 2015

McKesson Corporation is an American company distributing pharmaceuticals and providing health information technology, medical supplies, and care management tools. I worked with the health data repository team to implement new clients and with data warehouse team building new areas of the care management data warehouse to include nurse advice line and disease management.

Responsibilities:

Supported, enhanced, and maintained many areas of the McKesson Data Warehouse to include Disease Management Mart, Claims Mart, and Billing Mart.

Launched a new CISCO Mart for telephony reporting and to support CISCO Auto Dialer to send automated calling information to nurses working on the Disease Management system.

Architected and implemented new subject areas of McKesson’s Data Warehouse to include a triage system for a Nurse Advice Line product.

Participated in an upgrade for IBM InfoSphere Information server from version 8.5 to 9.1.2.

I have driven the implementation of more effective techniques of ETL loading than when McKesson Mart was conceived and brought better performance to the loading process.

Lead my team successfully in fine tuning areas which already existed when I came on board as well as building many new Data Marts and added more functionality through adding new subject areas.

ENVIRONMENT: DataStage 9.1.2/11.5/11.7, Oracle versions 10g/11i, Windows 10, RHEL 7, ProActive.

Emergency Medical Services Corporation

American Medical Response, Inc.

Greenwood Village, CO – Partial Remote SENIOR ETL DEVELOPER

July 2002 – November 2008

Envision Healthcare Corporation, formerly known as Emergency Medical Services Corporation, offers an array of healthcare-related services to consumers, hospitals, healthcare systems, health plans and local, state and national government entities. Envision Healthcare operates American Medical Response, Inc., EmCare Holdings, Inc. and Evolution Health, LLC. I worked on various projects loading data for their data warehouse and OLAP systems.

Responsibilities:

Instrumental in architecting ETL jobs and processes to load information from applications, database, and operating systems for Sarbanes Oxley complacency reporting system.

Built load jobs to run transportation information into a front-end application database for Texas Department of Transportation non-emergency patient records.

Build Star Schema and ETL jobs to load internal departmental work orders, change requests, and help desk support information.

Worked with SME’s from multiple divisions around the United States to extract human resources and financial information thru ETL extracts using IBM Infosphere DataStage from JDE and PeopleSoft for an ERP conversion project.

Involved in company’s corporate Management Information Platform initiative (MIP) by building, maintaining and supporting ETL to load Star Schemas in a Data Warehouse with patient, transportation, and billing information.

Redesigned the Enterprise Dimension feeds to be more modular and feed independent of any other systems.

Built nightly ETL feeds for a front-end application that displays Electronic Patient Care Record.

Developed, maintained, and supported a multitude of automated reporting systems with daily, weekly and monthly ETL loading.

ETL DEVELOPER

September 2000 – June 2002

Responsibilities:

Participated in a team to Architect and Implement AMR’s first Enterprise wide ETL/Business Intelligence solution.

Gathered company data rules and requirements.

Applied internal and external business rules to build the Data Warehouse and Dashboards.

Designed and engineered ETL and ETP plans/jobs that utilize data from disparate data sources

Build structures to enforced data integrity for database loading and data presentation.

ENVIRONMENT: DataStage 6.5 and 7, Sagent Design Studio, ProClarity, MS Access, Microsoft SQL Server

EDUCATION

Leading SAFe 4 Agilist

Agilist training for leading Structured Agile Framework - 2019

IBM

Hadoop and Big Data Foundations Level 1 badges - 2018

IBM Infosphere DataStage Advanced Development for DataStage Server and Parallel - 2017

Business Objects

Business Objects Universe Design

Emily Griffith School of Opportunity

Visual Basic course included application design, coding and deployment of Visual Basic applications.

Regis College and Westnet in association with National Association of Computer Systems Engineers (NACSE)

Associate Webmaster Course

Webmaster course studies included web page design, basic networking, TCP\IP, Internet security and web servers with some exposure to JAVASCRIPT, VBScript, HTML, CGI and PERL, ASP’s, and Cold Fusion.

Guru Software Services,Inc.

Oracle 7.x and 8.0, Developer 2000 (Forms 4.5, Reports 2.5, Graphics 2.5), PL\SQL, and SQL*Plus. Study included the planning, design development and implementation of an activity-status tracking system to manage resource allocation for a large building maintenance company with multiple locations nationwide using Oracle and Developer 2000.

Arapahoe Community College

Advance Adobe Photoshop and Pagemill. Study included web page design, HTML, links, anchors and forms using Adobe Pagemill, advanced graphics, photo manipulation and techniques using Adobe Photoshop.

The Art Institute of Colorado

Associates Degree of Occupational Studies in Advertising Design and Graphics.

Contact this candidate