C
PAUL FRANCIS
Data Engineer
Tracy,CA
Summary
Ten years of design and development of data management services. The complete ownership of Data Management lifecycle from architecture, ETL, reporting, to advanced analytics in the financial, retail, and health science sectors. Creation of actionable, prescriptive and predictive analytics. Consistent deliverables on schedule, exceeding organizational standards and management expectations.
Overview
33
33
years of professional experience
1
1
Certification
Work History
Lead
- On-shore data engineer for Business Analytics in Retail, CPG, Manufacturing, and Health Provider clients
- Design and create Quality of Service measurement and management systems using Informatica: Ent Data, Hadoop Connector, and Hadoop
- Designed, built and implemented an application to manage the customer quotes for Reynolds Group to increase quote-to-order conversion ratios
- Designed, developed and implemented system to provide accurate measurement of customer profitability by reconciling bad data from Reynold Group
- Built system to help reconcile SAP (Manufacturing and Inventory) and Hyperion (Financial) systems across multiple business portfolios on GL
- Design and implement customer communication plans between customers and delivery teams
- Reporting in HANA in the cloud platform
- Provide feedback to customer leadership on project progress, hurdles, and solutions
Principal Data Engineer
ITC Infotech
San Jose, CA
01.2018 - Current
Principle Data Engineer
CapGemini
San Diego, CA
01.2017 - 01.2018
- On-site client lead for BI-related Application Development and Application Management activities
- Initiated project ideas for clients, built business case decks, provided time and resource estimations, and helped gain governance council approvals in compliance with the client budgeting process
- Created and maintained 12-month resourcing forecasts including technical demands
- Created project plans with resourcing and budgets for approved projects
- Created resource plans with project roll-on and roll-off dates
- Included project documentation and KT reviews and signoffs to minimize disruptions and tribal knowledge risks
- Held weekly project updates with client leadership teams
- Participated in client QBR for updates to 1-year BI roadmap
- Managed data center migration for BI servers with weekly planning sessions with Network and Infrastructure vendors (HCL)
- Planned and managed Day One BI projects for merger with CR Bard Sales into Becton Dickinson Sales
- Facilitated translation of international Sales data into corporate data lake, and data warehouse for reporting
- Implemented InfoSec data security requirements and standards into QlikView, Qlik Sense via Active Directory and Section Access
- Managed flex resources 19 off-shore and 6 on-shore for development and 24x7 platform support for NA, EMEA, APAC, ANZ, and LATAM
Sr. Analytics Software Engineer
Arity, Allstate Insurance
Chicago, IL
01.2016 - 01.2017
- On-site lead for BI-related Product Development for new spinoff from Allstate Insurance
- Developed applications on Hadoop, with resulting in new SQL objects on Hive and in-memory
- Participated in weekly product development sessions
- Created initial products and revenues for Arity.com
- Created backlogs and lead bi-weekly sprints for initial prototype development
- Lead daily scrums for 3 teams in SF, Seattle and Chicago
- Liaison with information brokers and other product customers in shaping of prototypes to final products
- Liaison with other companies looking to leverage information platform consisting of Hive, Impala, on HDFS from AWS
Business Inteliigence Software Engineer
Microsoft Technology Center
Mountain View, CA
01.2014 - 01.2016
- Managed lifecycles for Proof-Of-Concept pilots for BI customers
- Managed securitization, sanitization, transfer, testing, optimization, reporting, visualization and sunset of 11 petabytes of customer data
- Compare customer technology with Microsoft technology for all aspects of advanced analytics
- Create dashboards to compare with existing customer reporting and visualization of POC results with Power BI
- Helped improve BI win rates by demonstrating performance, cost/performance, time to market, infrastructure costs and turnaround, availability, and scalable on-demand infrastructure
- Presented weekly updates and final conclusions to customer CIO’s and Data Architects.
Supply Chain Analytics Software Engineer
Safeway
Pleasanton, CA
01.2011 - 01.2014
- Managed creation of analytical outputs for supply chain leadership
- This included Qlik dashboards, real-time analytics, enterprise integration, ordering automation, labor optimization, cost reduction, flow lane optimization, labor union reporting, fleet optimization management, and change management adoption
- Manage agile team of 13 developers and analysts for distribution, transportation, logistics, manufacturing, and procurement departments
- Agile project management with daily scrums and weekly sprints
- Presented at monthly management reviews and quarterly executive reviews
- Developed new productivity measurements that resulted in reduction of warehouse labor costs and satisfied labor union reporting requirements
- Produced departmental dashboards to measure productivity and costs
- Measured LTL shipping usage and identified opportunities to reduce based on common routes algorithm
- Designed and implemented near-real-time alerts for operational goal posts, to help warehouses and plants meet or beat monthly goals
- Implemented new BI request process to reduce backlogs and turnaround times
- Tool stack included OBIEE, Hyperion, Teradata, Netezza, MicroStrategy, and QlikView.
Business Intelligence Software Engineer
WIPRO
Mountain View, CA
01.2009 - 01.2011
- Provided industrial and user-experience direction for new prebuilt BI applications which significantly improved sales and CSAT’s of prebuilt BI applications
- MicroStrategy dashboards for Inventory On Hand, Shelf and Lane Linear Product Velocity, Competitive Price Landscape by Region and others
- Helped design and build big-endian binary and EBCIDIC conversion applications which allowed visualization and access to legacy data
- This product helped win and grow engagements at Petco, LA County, and other customer sites
- Created new library in cloud for BI sales and consultant staff specifically for Retail, Manufacturing, and Healthcare industries
- Created new training videos and internal blogsites to improve sales ramp-up and consultant adoption
- Doubled average deal size for BI engagements to over $100k in less than 6 months
- And improved BI consulting win rate to over 67%
- Received award for best improved horizontal line of business
- Held daily calls with offshore teams in early morning and at night when initial deliveries were initiated
- Coordinated onshore travel and meetings with customer SME’s for offshore leads and consultants for initial deliveries
- Also, coordinated and accompanied customer travel to India during select deal pursuits which helped win deals.
Sr. Business Intelligence Program Manager
Accenture
San Francisco, CA
01.2004 - 01.2008
- Provided BI and Analytic fulfillment services for clients with on premise and remote delivery teams
- Designed, implemented and measured ongoing compliance of BI related development efficiency, standards, formula libraries, MicroStrategy metadata accuracy, production support, architecture and roadmap
- Generate and present weekly project status, tracking reports, systems/storage capacity planning, dashboards, ETL Data stores, Enterprise Data Warehouse, departmental DataMart’s, analytics and analysis
- Consistently successful in ensuring wide range of projects are completed on schedule and meet client and stakeholder requirements and expectations
- Developed, implemented and reviewed 24-month BI Roadmaps to
- Reduced project rework and improved developer morale by improving business requirements and wire framing, providing better and more data in Dev, creating Entry/Exit criteria for SDLC junctures, and initiating weekly meetings with stakeholders to review projects, prioritization and post Production performance
- Included Production Support input to help improve BI interface, report and application performance and reliability
MSN Business Intelligence Architect
Microsoft
Mountain View, CA
01.2002 - 01.2004
- Designed and developed centralized BI metadata system for automated BI workflow management and job recovery
- Created and loaded more efficient data models for product manufacturing, retail distribution and subscription fulfillments using
- Leveraged BizTalk and M-Queue SOA for external vendor integration to gain production efficiency and increase cost effectiveness
- Developed SOX compliance procedures for data cleanup, removal and encrypting as well as comprehensive data security and privacy protocols.
Principal Data Warehouse Architect
America Online, AOL
Dulles, VA
01.1998 - 01.2002
- Created first multi-terabyte data warehouse with operational data stores and data marts using Netezza, Redbrick and AbInitio
- Grew EDW to 111 TB over 5 years with sub-second SQL response on average
- Designed and managed system processing 600G of data daily for 33 million ISP customers
- International customers included multi-byte Kanji data using Unicode across multiple time zones
- Worked with Marketing, Network Operations, Billing, Partner Relations and external vendors to design new database structures to support reporting, decision analysis and other analysis needs
- Created documentation for data warehouse standards, guidelines, architecture and methodologies
- Provided support for Training department
Senior Data Analyst/Programmer
Fannie Mae, Federal National Mortgage Association, WDC
01.1993 - 01.1998
- On team which created first client-server application
- 4 tier application for banks and brokers to purchase mortgage commitments
- Software development on Sun OS and Sybase t-SQL
dBase Analyst/Programmer
World Resource Institute, WDC
01.1989 - 01.1993
- Created dBase III database on Novell to integrate with Solomon Accounting General Ledger for endowment fund management
- Created sales tracking system with integration to account receivables module in Solomon Accounting
Education
Engineering Degree -
Baltimore Polytechnic Institute
Skills
TECHNICAL SUMMARYPlatformsLanguages and FrameworksDatabasesSoftwareERPSolaris, Linux, Unix, IRIX, AIX, Windows, Red Prairie, JDA, OracleSAS, S, Ruby, C, C, Visual Basic, T-SQL, PL/SQL, Perl, ShellSpring, VICSOracle, DB2, Teradata, Netezza, MySQL, MS SQL, Server, Hyperion Essbase, Sybase, MS AccessAbInitio, Informatica, Trillium, Business Objects, MicroStrategy, DTS, SSIS, DBArtisan, ERwin, MS Project, Visio, VMwareSAP Business Works, Payroll Works, Oracle Financials, CRM, OBI, ODI, BPEL, ESB, OWB, Retek, RMS, RDW, AWB, EM/GC, OBIEECERTIFICATION SUMMARYKimball UniversityIEEESix Sigma
Hardware diagnostics
Technical Writing
Testing
Specification development
Diagnostic procedures
Hardware troubleshooting
Diagnostic skills
System integration
Software
Certification
Python
Timeline
Principal Data Engineer
ITC Infotech
01.2018 - Current
Principle Data Engineer
CapGemini
01.2017 - 01.2018
Sr. Analytics Software Engineer
Arity, Allstate Insurance
01.2016 - 01.2017
Business Inteliigence Software Engineer
Microsoft Technology Center
01.2014 - 01.2016
Supply Chain Analytics Software Engineer
Safeway
01.2011 - 01.2014
Business Intelligence Software Engineer
WIPRO
01.2009 - 01.2011
Sr. Business Intelligence Program Manager
Accenture
01.2004 - 01.2008
MSN Business Intelligence Architect
Microsoft
01.2002 - 01.2004
Principal Data Warehouse Architect
America Online, AOL
01.1998 - 01.2002
Senior Data Analyst/Programmer
Fannie Mae, Federal National Mortgage Association, WDC
01.1993 - 01.1998
dBase Analyst/Programmer
World Resource Institute, WDC
01.1989 - 01.1993
Lead
Engineering Degree -
Baltimore Polytechnic Institute