DATA SPECIALIST

Stephen Gregory 949-***-****

Mission Viejo, CA, 92692 ********@*****.***

www.ocsteveg.com www.linkedin.com/in/ocsteveg

DATA SPECIALIST

With this data liaison you get a perfect blend of technical and business experience to bring both

worlds together for a common understanding. An information enthusiast that has helped multiple

organizations in a variety of industries realize their insight value. As well as vast experience in

data lifecycle processes like gathering, transforming, integrating, insights, and presentation.

Major focus in the past 5 years on improving Customer Experience through data and text

analytics. Finding ways to make the customer journey a more enjoyable experience. While

customer is a somewhat generic term, I have managed to help customers, clients, members,

vendors, partners, employees, companies, and brands improve interaction with each other.

Business Intelligence (Descriptive Prescriptive Predictive) Business/Data/Text Analyst

Visual Analytics Line Analyst to C-Level Presentation

Big Data Project/Resource Management

Business/Technical Lead Software Development Life Cycle (SDLC)

.

PROFESSIONAL EXPERIENCE

Oakley, Foothill Ranch, California 2015-Present

Program Manager of Business Information Systems, Quality

Technology Used: Statit e-QC, SQL Server 2012, SSRS, Visual Studio 2010

Conversion project to move reports from the Statit platform to SQL Server Reporting Services.

Daily and weekly status of project progression for this Information Technology Manufacturing group .

Interruption of Statit code, which is a proprietary language that looks like a mixture of C++, VBScript,

and Python.

Multiple report generation within one SSRS report to maintain current deliverable. Stored procedures

and cascading filters are the main process to generate these reports.

Predalytics, Mission Viejo, California 2014-2015

Founding Member

Technology Used: Artificial Intelligence (AI), Predictive Analytics, Machine Learning, Tableau, Talend, SQL Server

2012, SSRS, Visual Studio 2010, Postgres, Excel, PowerPoint

Data specialist that included multiple roles. Subject matter expert, gathering requirements,

interfacing with software engineers, data blending, data integration (ETL), UAT validation,

repository, reporting, and dashboards.

Gathered and help define requirements. Produced input data for artificial intelligence, plus key role in

validating AI output.

Data and repository architect for Artificial Intelligence. Developed and maintain all integration (ETL) to

and from AI. Currently 3 repositories have been developed, SQL Server, Postgres, and Excel.

Developed and maintain all reporting and dashboards. Reporting layer utilizes Tableau, SSRS, Excel,

and PowerPoint.

1

Stephen Gregory ********@*****.*** 949-***-****

CISCO SYSTEMS, Irvine, California 2009-2014

Senior Business/Data/Text Analyst

Technology Used: Clarabridge, Tableau, JMP, SPSS, Verint/Vovici, Cymfony, WebEx, DBVisualizer, Toad,

PostgreSQL, Oracle, Teradata, Siebel Analytics, ETL, Wiki Markup, MS Visio, MS Access, MS Office, SysTrans,

Hadoop, Walker Information

Managed team of 4 analysts. Managed vendor relationship with Clarabridge & Tableau. Adhoc,

monthly, quarterly, and annual insights reporting of customer, partner, and field data to major

stakeholders and executive sponsors.

Key data/text/business analyst on team. Built major reports, dashboards, and presentation

documents for functional analysts, theater operations, management, and executive staff. Reports and

dashboards built using PowerPoint, Excel, Access, OBIEE, Siebel, SPSS, JMP, Clarabridge, and

Tableau.

Responsible for implementation and administration of a text analytics product called Clarabridge .

Lead a proof of concept (POC) effort that included 10 vendors. Clarabridge is fed by customer,

partner, and field survey data, along with customer and partner live listening events.

Key player in the data architecture of a Listening Post repository built in Teradata and PostgreSQL.

The repository brings multiple listening posts into one central spot that can be leveraged by the entire

company within the enterprise data warehouse (EDW).

20th CENTURY FOX, Los Angeles, California 2008-2009

Senior Business Analyst

Technology Used: Siebel CRM, Siebel Analytics, Microstrategy, JDE ERP, Atlas, ETL, Toad, Oracle, MS Visio, MS

Access, MS Office, Harper Collins

Part of the Home Entertainment International Data Warehouse team. Primary business users

were located in United Kingdom, Australia, Japan, and Spain. Gathering requirements,

generating executive presentations, data/system analysis, facilitating global business user

meetings, working with ETL team and adhoc report creation.

Australia business stakeholder project. W orked with Los Angeles & Australia business, United

Kingdom & Los Angeles ETL teams, and 3rd party vendor Harper Collins to determine double

counting of units within the data warehouse.

Benelux Report Grouping project. Worked with Los Angeles & United Kingdom business and United

Kingdom, Spain, & Los Angeles ETL teams to recommend an approach that added new report

grouping to the POS and marketing data warehouse and reporting layer.

FARMERS INSURANCE, Simi Valley, California 2008-2008

Senior Business Analyst

Technology Used: Dunn & Bradstreet, Mapinfo, Marshal & Swift (MVR/SIC), Siteminder, PegaSystems (PegaRules

Process Commander), MS Office, MS Visio, HATS

Liaison of cross-functional collaboration between internal business, IT departments, remote US

locations, multiple consulting firms, multiple product vendors, and development team.

Facilitated and coordinated requirements gathering for a process on a PegaSystem web front end,

back office process, and cross system gathering/update process. Final output was a business

requirements/use case document. Generated presentation documentation of process flow that was

used to bring business and technology to a common understanding of project phases, process flow,

and technical components.

2

Stephen Gregory ********@*****.*** 949-***-****

TELEPACIFIC COMMUNICATION, Los Angeles, California 2007-2008

Senior Business Analyst

Technology Used: Visual Basic, SSIS, SSRS, SSAS, SQL Server 2003/2005, Dundas, ETL, Toad, Oracle, Visible

Analyst, Toad Data Modeler, Windows XP Suite, Quickbase, Business Objects, Crystal Reports

Senior analyst and project manager for a team of 6 contractors and TelePacific subject matter

experts (SME). This was a data consolidation/integration project for silo’d and acquisition data

across the enterprise.

The Sales Entry Application helped reduce the number of man hours required to manually generate

Access reports and spreadsheet reports. The percentage of time saved per person was from 15% to

40%.

The Table Management Application helped maintain dimensional rollup criteria in one location for all

Dashboards and Reports. Replaced multiple spreadsheets and Access tables in multiple functional

areas.

COMPUTER SCIENCES CORPORATION, Simi Valley, California 2004-2007

Senior Business/Data Analyst

Technology Used: IBM OS/390, MVS/ESA, COBOL, Visual Basic, Assembler, EASYTRIEVE, DOCUMERGE,

ELIXIR, DB2/UDB, SQL Server, ETL, Microstrategy, Infomatica, Business Objects, Windows 2000 Suite, Peregrine,

Testdirector

Data liaison between Farmers commercial and Zurich commercial environments. Senior analyst

& data steward for the Farmers Commercial (Property & Casualty) and Workers’ Compensation

data.

Maintaining and reporting on $1.5 billion in Commercial Business premium, plus generating

commissions for 15,000 agents and district managers. Lines of business include Property & Casualty,

W orkers’ Compensation, Reinsurance, Umbrellas, and Bonds. Systems that are also maintained

comprise of Billing, Claims, Agent Profitability Bonus, and Commercial Experience Analysis.

Business Operations process improvement project where analysis, solution designed, process

review, and produced requirements for an integration work stream on a reengineering project that

consisted of converting a mainframe flat file process to a DB2 mainframe data capture process. Also

converting a web screen scraping front-end to a DB2 web based front-end. Stakeholders involved in

the requirement gathering process include business partners, architects, and upper -level

management. Due to my Subject Matter knowledge, other roles on this project include the

development of a metadata repository between two systems and definition of data warehou se

requirements.

ADDITIONAL PROFESSIONAL EXPERIENCE

FARMERS INSURANCE, Business/Data Analyst 1997-2004

Technology Used: IBM OS/390, MVS/ESA, COBOL, Visual Basic, Assembler, EASYTRIEVE, DOCUMERGE,

ELIXIR, DB2/UDB, SQL Server, ETL, Microstrategy, Infomatica, Business Objects, Windows 2000 Suite, Peregrine,

Testdirector

Responsible for software development, production support, and release stage oversight for the

Commercial (Property & Casualty) and Workers’ Compensation systems. Managed team from

10 to 14 in an onshore/offshore model. Designed and implemented two projects that saved a

combined $8 million a year. A Pay As Received commission system ($1 million) for the Workers’

Compensation line of business and enhanced system design to reduce number of manual

reprints and coping of forms ($7 million).

3

Stephen Gregory ********@*****.*** 949-***-****

HOMEBASE, Senior Programmer/Analyst 1995-1997

Technology Used: IBM ES/9000, MVS/ESA, COBOL, CICS, IMS, Micro Focus COBOL, TSO/ISPF, IRIS/INGERAL

Maintained, enhanced, and developed a commission system that was tied to the Special Order

system. The commission system interfaced with payroll to pay commissions on all special

orders, from all stores countrywide. The enhancements improved user through put, increased

customer satisfaction, and generated commissions without missing a pay cycle. Other projects

& systems include Y2K, Advertisement, HR, Marketing, Time Entry, and Warehouse

Operations.

AUTO CLUB of SOUTHERN CALIFORNIA, Senior Programmer/Analyst 1986-1995

Technology Used: IBM ES/9000, MVS/ESA, COBOL, PL/1, DB2, DOCUMERGE, IMAGECREATE, IMAGEPLUS,

TSO/ISPF, UNIX, INTRANS, IEF

Went from Lead Operator to Programmer/Analyst and last Senior Programmer/Analyst. Big

accomplishment was the co-lead implementation of a Customer Service System. Instrumental in

the implementation and maintenance of DocuMerge Image Printing System that automated the

printing and distribution of the insured’s declaration. Other systems of responsibility include

Property & Casualty, Membership, Home, and Auto.

BECKMAN INSTRUMENTS, Lead Operator 1979-1986

Technology Used: IBM Mainframe, MVS, TSO/ISPF, JCL, JES2, UCC7, CA7

Managed a Mainframe operations team of 6. Team responsibilities included, but not limited to

peripheral operation, production support, job stream manipulation, and abend analysis. Also ran

shift in Shift Supervisors absents for this FDA regulated company.

EDUCATION / TRAINING

Specialized Certificate in Data Mining (Attending)

University of Illinois at Urbana-Champaign

Diploma in Computer Programming (1998)

Computer Learning Center, Anaheim, California

Additional corporate/personal training in project management, data/text analytics,

customer experience, data warehouse, and multiple programming languages.

Web client server FTP ETL Data Warehouse Business Intelligence Mainframe Legacy Microsoft Project Excel Word PowerPoint Visio Access Data

Analytics Text Analytics Tableau SPSS JMP R Clarabridge Cymfony DocuMerge Content Management Presentation Software Vovici Verint

Walker SQL Server Enterprise Manager SQL Query Analyzer DBVisualizer Expressor-Qlik Oracle Toad TD Assistant Microstrategy SSIS SSRS SSAS

Dundas Visible Analyst Toad Data Modeler Business Objects DB2/UDB Cubes Infomatica Visual Analytics Sentiment Analysis Solution Design

Data Mining Data Migration Data Integration Root Cause Use Cases Technical Requirements Business Requirem ents Functional Requirements

TRD BRD FRD NPS personal Insurance commercial Insurance P&C Customer Experience Customer Service Insurance Claims

Workers Compensation Retail Network Technology Manufacturing Membership Home Improvement Telecommunications

Entertainment SQL Server 2005 Oracle 10g DB2 Teradata VSAM PostgreSQL SqlLite MySQL Hadoop

4

Contact this candidate