SUMMARY:

• Dynamic, results - oriented leader, MS, MBA, PMP, CISA, CGEIT, ITIL, CobiT, CMMI Dev
• 17+ yrs. experience in Supply Chain, Financial Services/Mortgage/Banking, Business Intelligence, Data Warehousing, Analytics, Governance, BPR, Service Mgmt, Project Mgmt
• Experience in Fortune 200 companies: Confidential, CSC, Oracle, & Confidential .
• Last worked in Confidential as Operational Risk Sr. Data Analyst.
• Previously worked in National Mortgage Insurance as Data Warehouse Project Manager.
• Previously worked in Confidential on Supply Chain Operations Analytics. Realized $2MM in savings by creating dashboards for DCs/warehouses for the first time in its 100 year history.
• Prior to that, worked as a Sr. Manager, Business Process Re-engineering, at CSC.
• Prior to that, worked as an IT Service Manager with the CSC Confidential account.
• BS Thesis focus: Pattern Recognition & Machine Learning using Artificial Neural Networks

TECHNICAL SKILLS:

Languages: JAVA, J2EE, EJB, SOAP, XML, HTML, SQL, Perl, Scala, Go Developer

Tools: Oracle, UML, Rational Rose, ERWIN, SQL Server, ETI Extract, SSIS, ETL, Toad

Business Analytics: Tableau, QlikView, R, Brio, Hyperion, Python, Data Mining, Bio Statistics

Data Modeling: Star Schema/ROLAP, OLAP, MOLAP, Normalization, Kimball

Supply Chain: WMS (Infor), LMS, TMW ServiceCenter, IMS, TMS, RedPrairie

Big Data: HDFS, Hadoop, Hive, Pig, NoSQL, HCatalog, Storm, MapReduce

Machine Learning: Artificial Neural Network (ANN), Back-Propagation algorithm, Artificial Intelligence (AI), Pattern Recognition

Statistics: Hypothesis Testing, Regression, Correlation, Histograms, P value, Standard Deviation, Box Plot, Odds Ratio, Relative Risk, Confidence Intervals

Process Mgmt: Visio, Flowcharts, BPMN, Rummler Brache, CMMI, ITIL, Appian BPM, CobiT

Project Mgmt: Rally, JIRA, Agile/Scrum, MS Project, HP PPM, PMP, PMBOK, Portfolio Mgmt, Program Mgmt, SDLC, SharePoint, Demand & Resource Forecasting

Supply Chain: CPFR, APICS, Transportation, Distribution, Warehousing, Retail, Logistics

WORK EXPERIENCE:

Operational Risk Sr. Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Business Intelligence, Operational Risk Loss Data Management
• Basel III BCBS 239 Compliance - Risk Data Aggregation and Risk Reporting
• Applications Development and Strategy, Tableau Dashboard Visualization
• Key Data Elements (KDEs), Data Science, Data Warehousing, Data Mart Strategy
• Took initiative to lead & implement the Operational Risk Loss Data Management from scratch:
• Collected operational loss events/near miss data from different BUs including Fraud Investigations, Deposit Services, Accounting, Private Wealth Management (PWM), Legal
• Data collected include ATM losses, ACH losses, Trade Errors, Operating Errors, BSA/AML Fraud, Non-Fraud Incidents, Cyber Fraud, Check Fraud, Elderly Abuse, Near Miss
• Mapped data to Basel ABA codes. Developed data model & Data Lineage.
• Loaded Operational Risk Loss Data. Used SQL Server, SSIS, SQL, Python
• Validated loss data against Accounting GL journal entry transactions.
• Submitted internal loss data to ABA Consortium. Obtained external loss data in exchange.
• Flowcharted Operational Risk Loss management processes in partnership with stakeholders.
• Business Value
• External loss data used for DFAST modeling and analytics
• FRB gained good hold on internal operational losses,
• Fraud Investigations to use it for their SOR thereby retiring the usage of spreadsheets.
• BI Reporting, Tableau Dashboards Data Visualization
• Benchmarked internal loss data with external data using Tableau, excel, R, statistics, Python
• Developed Tableau Dashboards for BSA/AML Fraud & Private Wealth Management
• Appian Loss Events Data Entry Application
• Partnered with business units and engineering team to implement a front-end loss events/near miss data entry application using Appian BPM tool
• Developed business requirements specifications, wireframes, application workflow, event approval routing to Data Champions, data quality checks, business rules validation.
• Led the initial release of the Loan Data Mart using SQL Server, SSIS, SSAS
• Developed the architecture and data model. Designed test cases. Coordinated UAT.
• Designed and implemented the write-back functionality.

BI/Data Warehouse Architect/Project Manager

Confidential, Emeryville, CA

Responsibilities:

• Project Management, Requirements Analysis, Data Analysis, Data Modeling, Star Schema
• Outsourcing, Offshoring, Team Management
• Took initiative, formed, led & managed a global team to successfully deliver the Data Warehouse using SSIS ETL, SQL, Star Schema Data Model, Agile/Scrum, Rally, JIRA
• Offshored development of the EDW & ETL to save costs.
• Team composition: 3 offshore SSIS developers, 1 BA, 1 QA, 1 Architect
• Managed Rally project. Monitored iteration burndown charts. Facilitated daily scrums
• Gathered user stories from Finance, Corporate Analytics, Insurance Policy, Loan Servicing
• Sprints include:
• Loan Servicing, New Insurance Written, Loan Origination, Applications, Commitments
• Billings & Payments: Credits, Debits, Apply, Hold Queue, Remittance, Statements
• Designed Star Schema using ERWIN & Kimball methodologies.
• Created Data lineage, Data Warehouse Bus Matrix, Acceptance Test Cases, mapping docs
• Delivered Star Schema performance improvement = %

Supply Chain Sr. BI Analyst, Supply Chain Services

Confidential, Pleasanton, CA

Responsibilities:

• Supply Chain Business Intelligence, Analytics, Modeling, & Optimization
• Project Management, Agile/Scrum, Project Planning, Facilitations, Process Improvement,
• Business Case Formulation, Business Analysis, Requirements Gathering, Cost Savings
• Managed a Distribution Center (DC) Labor Productivity Business Analytics reporting project which realizes $1.5-2MM/year in cost savings across 10 DCs and 48 warehouses.
• Created dashboards, reports, & email alerts for Supervisor, Manager, & Director roles using QlikView, ETL, SQL, Infor WMS. Done for the first time in Confidential ’s 100 year history.
• Gathered business requirements from DC Management, Warehouse Operations Management, Industrial Engineers, Backstage Management
• Interfaced with stakeholders to develop a flowchart for the DC labor exception process.
• Finalized KPI/Metrics with business. Mapping KPIs to WMS tables and fields.
• Metrics include Picks, Shorts, GoBacks, Markouts, Replenishment, Skips, Labor Performance, ROI. Normalized metric counts by cases and assignments. Calculated mean, median, standard deviations of metrics using R, Python.
• Lead cross-functional teams of SAs & IEs for data validation, anomalies, & exceptions
• Partnered with Produce & Transportation stakeholders to conceive, model, gather requirements, analyze data, & successfully identify the following cost savings opportunities:
• Produce LTL Consolidation and Optimization Process: $2-4MM/yr
• Modeled consolidation of LTL loads by ship dates, OD pairs (territory, destination), & temperature to reduce number of loads, flat line haul, & stops charge.
• Optimized routes and loads using Excel within 24 pallet limit, 40K pound loads, flat line haul and additional stops charges.
• Produce Buyer PO Consolidation & Coordination Process: $660K/yr
• Consolidating POs shipped by different buyers with the same ship date, OD pair, and temperature leading to reduced additional stops.
• Transportation Continuous Moves Process
• Modeled the Transportation Continuous Moves & Backhaul process.
• Proved hypothesis by creating views of pallets shipped between Origin territory points & Destination DCs.
• Used SQL, excel, QlikView, R, Python, & MapPoint tool.
• Truck Shop Mechanics Labor Productivity Dashboard: $ K/yr
• Scoped a reporting project to improve labor productivity for high frequency shop repairs
• Unearthed data integrity issues due to absence of process and data governance in shops.
• Prototyped views using SQL, QlikView, excel, TMW ServiceCenter database
• Managed & delivered a reporting project to provide health of 60+ Supply Chain applications:
• Trending of top 5 resolution causes and P2/P3/P4 resolution time in hours
• Breakdown by Incident Priority & Source, Missed SLAs, and Unresolved Incident details.

Senior Manager, Business Process Re-engineering

Confidential, Santa Clara, CA

Responsibilities:

• PMO Governance, Transitions Process Re-engineering, SDLC Processes Deployment
• CMMI L3 compliance and metrics management
• Demand, Supply, & Resource Management
• Gathered requirements from Senior Management to prepare current and future state strategy roadmaps for PMO Governance & Software life Cycle Management
• Lead a global team of 15 resources to institute PMO & SDLC processes, standards, tools, & metrics in account PMOs including DuPont, Textron, Chrysler, Xerox, Zurich, Motorola, GD
• Developed business cases, communication plans. Presented & earned buy-in from accounts
• Tools include MS Project, Project Server, SharePoint
• Program managed the global deployment of process models for all CSC accounts:
• Lead a team of 10 resources, created project definition, project plans, metrics, process
• Partnered with account PMOs to remediate weaknesses for CMMI L3 SCAMPI.
• Facilitations, deploying process models, s, tools utilization, process compliance
• Lead definition of global metrics & communications plan.
• Metrics categories: PM, QA, Defects, Productivity, s, & Process Improvement.
• Member of Steering Committee for improving maturity of Transitions Governance model:
• Deliverables: Governance processes, balanced scorecard, metrics, quality plan
• Lead the effort for improving maturity of Account Management & Governance processes.
• Performed gap analysis between CobiT & Risk IT control practices & existing processes
• Transitioned & integrated Covansys Health Care accounts into CSC’s Demand, Sourcing, and Capability governance business model in accounts including Kaiser, BCBS, Pfizer, Henry Ford Health Systems, Humana, Confidential, Beckman Coulter, NYBC, RMHP.
• Deployed processes, tools, & controls for quality, productivity, and standardization

IT Service Line Manager

Confidential, Menlo Park, CA

Responsibilities:

• Prime responsibilities include:
• Service Delivery & Service Support Management
• Project, Program, Portfolio, People Management
• Successfully formed & led Business Intelligence Global Team (12 members, 40 apps)
• Tools: Hyperion BI v9, Brio, Essbase, SAS, Informatica, ER/Studio, Java, Oracle
• Maintained 100% Green SLAs throughout.
• Stepped up to manage eCommerce Global Team (10 members, 15 applications)
• Tools/Tech: SOA, WebServices, i2 TradeMatrix, J2EE, EJB
• Led turnaround from 90% red SLAs and client ratings to 100% green results
• Managed Contracts First Global Team (10 members, 15 apps)
• Stepped up to form a SOX Support Team (8-14 members)
• Redesigned processes. Cut 30% time spent in monitoring e-mails & 1 HC.
• Implemented processes for 24x7 Shift Hand-over, Incident & Crisis Management
• Member of IT Process Alignment core team for aligning CSC and Sun processes
• Strategies: Communication plans, resourcing, ticket management, ITIL, SDLC, crisis calls, RCA, hardware provisioning & roles

Project Lead/Manager, Business Intelligence & Analytics

Confidential, Menlo Park, CA

Responsibilities:

• Partnered with Field Finance. Managed a team of 4 to design & develop the WorldWide Field Reporting System & Standard Reports and extend it from AMER to EMEA & APAC
• Partnered with FP&A, Network Storage, WWFRM Finance groups to gather requirements for the full life cycle design and development of Reporting Portal sites.
• Led the planning, architecture, design & development of Sales Order Query Web Service
• Used Web/App/Identity Server, SunONE Studio, Java, J2EE, HTML, JavaScript, ETL, Oracle, Data Modeling, Star Schema, ER/Studio, Rational Rose, Core J2EE/GoF Design Patterns, SAS
• Developed, maintained, and sustained Corporate Data Warehouses of Confidential .
• Performed ETL using scripts, ETI Extract, Oracle, SQL, Teradata
• Designed Facts, Dimensions, and Star Schema