SUMMARY:

• Over 26 years of IT and Project Management experience in the Healthcare, Financial, Media and Transportation industries.
• Technical Program Manager and Certified Scrum Master - PMP, CSM and Six Sigma certified.
• Scrum Master coach and hands-on technical with focus on data architecture and business intelligence projects. PM tools utilized are Jira, Rally and CA Clarity.
• Authored a SDLC Guidelines document for Waterfall and Agile project management frameworks.
• Managed programs and projects with budgets from $1-$15 million. Negotiated RFPs with software vendors for up to $5 million.
• Enterprise Data Architect with focus on integration of Big Data, Data Lakes and relational databases with primary focus on Data Warehouses, Data Marts, Business Intelligence and Analytics
• Ability to perform multiple roles - technical architect, project management and resource management roles
• Have managed teams of up to 40 resources for BI, ETL, Analysts and Project Managers, both onshore and offshore
• Managed the development of data warehouse and analytic platform using EPIC Healthcare data at Confidential
• Current role is of an Enterprise Data Architect at Children’s Confidential for the Analytics team, designing a Data Lake, an Enterprise Data Warehouse and Analytics Platform using Hadoop, Oracle 12c database, ODI, Healthcare Data Model.
• Prior roles were of Project Manager and an Enterprise Architect (EA) implementing the TOGAF framework at Confidential IT with focus on Big Data, Data Virtualization and BI & Analytics. Primary role is to focus on technical business need and recommend solutions, conduct Proof of Technology using new and current technologies to projects. Good working knowledge of products such as Informatica, AbInitio, Oracle, DB2, Erwin, Hadoop, Hive, Pig, Cassandra, HANA, Exadata, NoSQL, Data Virtualization, Data Visualization, ETL, MDM, Metadata and Data Profiling tools. Acted as a senior team lead and project manager on 10-plus data warehouse and analytics projects.
• Other tasks involved setup of an EA Repository based on the TOGAF 9.1 framework, defining and reviewing data architecture solutions for projects. Primary technical products used are: Informatica, Ab Initio, Data Stage, SSIS, Epic Clarity, Teradata, Oracle, DB2/UDB, Sybase, SQL Server, Hadoop, Business Objects, Cognos, Cool:Gen. Knowledge of data integration patterns and SOA.
• Technical Project Manager experienced with Confidential ’s TEAMS, Agile Project Management Delivery and SDLC Framework. Managed 4-5 projects in parallel with budgets ranging from $2 mil to $15 mil with teams of 20-plus members.
• Extensive experience in coordinating multi-disciplinary teams. Implemented PM methodology/deliverables, developed project documents, risk/issue processes, compliance processes, budget/funding plans, change approval board presentations, forecasting and project communications. Strengths in stakeholder and vendor management (onshore and offshore).
• Technical resource manager/lead specializing in Data Warehouse & Business Intelligence Design and Architecture, data warehouse development with onshore & offshore resources.
• Proven skills in people and communication management. Strong executive presentation skills.
• Team motivator with focus on on-time project delivery.

PROFESSIONAL EXPERIENCE:

Confidential,Los Angeles, CA

Enterprise Data Architect 

Responsibilities:

• Senior Manager role working with the Information Management & Information Delivery team to provide end-to-end technology architecture to support the complete data life cycle phases including core functions like Information management, Information delivery & support functions like data governance (data quality, compliance & data security), Metadata Management & Master Data management (MDM). Report to the director of Analytics and work directly with the CIO, as needed.
• Current project is a multi-year effort to develop a Data Lake using Hortonworks Hadoop and an Enterprise Data Repository using Oracle 12c, Oracle Data integrator (ODI), OBIEE, Oracle Master Data Management, Oracle Metadata Management tools, Oracle Healthcare data model. Worked with data on the cloud and on-premise and worked with Amazon AWS Redshift and Quicksight.
• Conducted proof of concepts with vendors for Hadoop using Cloudera, Hortonworks, Amazon AWS, Azure, Oracle 12c, OBIEE and Tableau. Data to be acquired are semi-structured and structured Also participate in weekly Architecture Review Board (ARB) meetings. Plans are underway to introduce the TOGAF Framework and an Architecture Review Board for new projects.
• Some of the data sources for the Enterprise Data Repository are Cerner Clinical, Population Health and McKesson Financial.
• Also supporting ETL code to share clinical data with Keck Medicine of USC for research.

 Confidential,El Segundo,CA 

Data Architect Scrum Master Coach 

• Solution architect with focus on acquiring, storing and consumption of enterprise data in the Teradata, Hadoop and Oracle environments for data warehouses, data marts and business intelligence tools. My role is of architecting the solution for sourcing data from weblogs and machine data using Hadoop in the Cloudera environment and populating an enterprise data warehouse in Teradata. My role also involves architecting data requirements using Informatica ETL for Cognos and Qlikview reports. Architecture tasks include writing SQL queries, report design and coding best practices.
• The project uses data captured using Adobe Omniture and Google Analytics data logs and store then into a Hadoop HDFS environment. The data is copied to/from Hadoop using utilities such as Sqoop, Hive, Impala and Informatica ETL to populate and enterprise data warehouse in Teradata Appliance v14. Currently working on over 5 projects simultaneously with various requirements and timelines. Also, design Data Warehouse BI solutions for all NFL viewership data and promotions tied to AT&T wireless customers.
• Daily interaction with enterprise architects, business users, developers and managers to architect and deliver solutions on a 2-month delivery cycles.

Confidential,Torrance,CA 

Data & Integration Architect

• The project is a replacement of existing mainframe-based (DB2 and VSAM) system for auto loans and leases with a customized product.
• The new project is a multi-year effort that involves designing a centralized operational data store (ODS) with over 1400 interfaces to existing internal and external systems.
• My role is of a technical lead and involves managing teams that gather requirements and design interfaces for real-time and batch interfaces using Informatica and TIBCO.
• Also involved in evaluation and customization of commercial off-the-shelf (COTS) software for interfacing with existing systems.
• Also, assisting the project manager for the Integration team of 17 resources, with primary focus on schedule, scope, WBS and managing resources.

Confidential,Pasadena,CA 

Enterprise Data Architect/Technical Program Manager

• For Kaiser’s Enterprise Architecture (EA) team, led and designed data and BI & Analytics architecture for data warehouses (star and snowflake schema), data marts, business intelligence & analytics systems, including Big Data (Hadoop) Analytics, Data Virtualization (Informatica & Denodo), in-memory databases, mobile applications and B2B data integration concepts and tools. Provided vendor management for on-site proof of concept projects including Request for Proposals (RFP) and Statements of Work (SOW). Also worked on Informatica MDM, IDQ projects and Data Governance policies.
• Scrum Master for several projects ranging from 2 -12 months with teams of 5-7 members.
• Technical Program Manager for Confidential for ETL Development/Data Warehouse projects with >25 developers, SMEs and analysts. Technical leadership, resource management, business requirements, data modeling tasks, application/ETL solution design, performance tuning and resource and daily project management tasks. Major projects include MARC Revenue Cycle (EPIC Clarity). Onelink, National Pricing System (NPS), Concur & KPERS, ABC and Insight. (MVS datasets, DB2, UDB, Oracle, SQL/Server, Teradata, ftp, ETL using Ab Initio 2.14 and Informatica 8.6 - 9.5, ERwin)
• Responsible for project management/communication planning, charter, scope, WBS, estimates/forecasts, status reports, change management, training development for team members, scheduling and tracking project financial goals, business objectives, risk registry, milestones and deliverables.
• Project development planning, working with cross functional teams, managing weekly project team meetings. Project sponsor stakeholder management. Responsible for the communications to all groups (IT and business teams) and overall project status reporting. Escalate and follow-up issues to senior management.
• Managed 4-5 mid-sized projects simultaneously, and also managed 20+ resources onshore and offshore for Data Integration and Data Warehouse/BI projects using ETL tools. Experience includes projects in Revenue Cycle, ICD-9 to ICD-10 conversion, PeopleSoft Onelink implementation, HR, Expense Reporting System (KPERS) and KP.org weblogs capture and analytics.
• Identified major risks, budget, defined requirements and deliverables, developed schedules. Defined testing strategy working with the Testing PM. Coordinated program change control, Risks, Actions, Issues, Decisions (RAIDs), deliverables, and dependencies across multiple work-groups/multiple projects. Utilized guidance and best practices from the PMO team.
• Responsible for team acquisition, team building, and vendor management. Managed recruiting and interviewing of developers and analyst, and maintain resource utilization for the department.

Confidential,Dallas, TX 

Senior ETL Support Consultant & Data Architect

• Provided technical and architectural leadership and mentoring to five different projects (about 25 developers, SMEs, business analysts) in ETL development, QA, and production using Ascential Software’s Datastage Parallel Extender 7 & 7.5 and Datastage Server 7.
• Troubleshoot technical issues including job design and performance. Led all Erwin/DataStage tool-related technical issues including administration, evaluation, installation, testing, vendor communication, and upgrading. Worked with management on architecture and prototyping of Ascential tools.
• Created a User’s Guide that includes Best Practices and Standards for developers. Developed an ETL Project Management methodology. Trained developers on tips and tricks of the tools. Created project migration plans - from development, unit, QA to production. Responsible for rollout of new releases and educating developers of new features, deployment of QualityStage and ProfileStage. Managed Framework Manager & ReportNet (for web-based reporting) and Business Object’s data mining tool BusinessMiner.
• Senior Data Architect for data warehouse and data mart for financial custody transactional data. Warehouse and data mart comprise of over 350 entities each. Maintain logical and physical models for both relational and dimensional (star and snowflake schema) models using Erwin 4. 1 and Modelmart 4.1. Performed data model repository (Modelmart) administrator functions. Supported legacy data model for varying platforms - DB2, UDB, Oracle 8i/9i, SQL/Server, MQ Series (Websphere & Unit of Work), Sequential files, FTP, XML, and Sybase. Converted over 20 models from Cool:DBA and Cool:Gen to Erwin.

Confidential,Dallas,TX 

Senior IEF/Cool:Gen Developer 

• For the Century Telephone C3 project, deployed a Client/Server GUI application up to User Acceptance Test using the Cool:Gen CASE tool. Automated the order processing for residential or commercial phone customers.
• Led and developed online GUI transactions under Windows NT for the clients and UNIX & Oracle for the back-end. System involved interfacing with the legacy system and a telecommunications software called MARTENS. Worked independently and led development work performed by Akili Systems.

Confidential,Pasadena, CA 

Team Lead - Senior

• Foundation Systems Membership Enrollment - Led and facilitated analysis, architecture and design sessions. Extensive involvement with end-users during data-modeling, business rules discussions, prototyping, and introducing GUI design and concepts. Provided training and mentoring to junior developers and analyst.
• Lead developer using Cool:Gen 4.1 GUI Client/Server project for the California Business Systems (CBS) project that to combine and enhance two separate HMO-based healthcare enrollment and membership systems. Developed and maintained several GUI Client/Server, block mode and batch programs. Also developed interface programs where a remote non-IEF program would call an IEF program.
• Lead developer for the Pathfinder project proof of concept using IEF’s GUI and Client/Server. Managed the prototype design, development and executive presentation for the of the membership systems.
• Developed and maintained about 25 GUI Client/Server programs, and have written several batch IEF programs with COBOL II externals, IBM MQM series modules with COBOL II, DB2, and CICS. Staging and compilation was done using Changeman in MVS and debugging using Expeditor in CICS.

Confidential,Forth Worth,TX 

IEF Programmer/Analyst

• Canadian Airlines Frequent Flier System (AURORA Canadian Plus) - supported an IEF based system for partner Canadian Airlines. Three person team responsible for about 275 batch jobs and 100 online IEF/DB2/FOCUS transactions. Most batch Procedures applied database updates and generated extracts for reporting.
• American Airlines Targeting Marketing System (AATMS) - An IEF project used for awarding and tracking AAdvantage frequent flier miles. Coded procedures in Member Inquiry, Member Enrollment, Phone Dial-in Request and Promotions using IEF 5.2. Also coded IEF Batch procedures with IMS GSAM processing and Checkpoint/Restart.
• Worked for Frequent Flier Traveler (FFT) for Multi-host customers & Automated Data Analyst Tool (ADAT). Performed project estimation using the IEF Project Manager and James Martin's FAST Project using a BAA model.
• Generalized Data Streams (GDS) - completed the full life-cycle of a Data Repository system using IEF 5.1. Coded 31 programs including two batch, and also generated some procedures using Procedure Synthesis. Implemented the system into production. Worked as an internal IEF consultant to the Data Management group and its users for eight months to complete this project from BAA through implementation.
• IE Methodology - Authored a reference guide on IE Methodology for the potential customer and the analyst. The guide focused on objectives of every task in the methodology, individual subtasks, and deliverables for every task in the IE life-cycle.
• Centralized Commissions - a member of a five-person team that built a system for paying commissions to travel agents from a centralized location for the CONFIRM reservation system. Utilized all phases of IEF's life cycle including BAA, BSD, Construction, and Testing using IEF 4.2 along with DB2 and IMS. In many occasions loaned to other groups for assistance and in some instances acted as a team leader. Coded and completed 12 transactions, on-line and batch.