-Requested and successfully corrected/fixed ATI and IGT initial implementations that were done incorrectly the first time around. Worked directly with clients to understand the nuances and complexities of their business processes and adjusted transformation code. -Lead efforts to onboard single and multi-property clients by performing source-to-target mapping of gaming (Aristocrat, IGT, Winsys), hospitality (Opera, Agilysys RGuest), food & beverage (Agilisys InfoGenesis) and promotion-loyalty (Trilogy/Everi, Halo/Engage) systems. -Wrote all transformational logic using SQL, validated and verified on source and transferred to staging environments-Main Lead for clients: Rosies/Colonial Downs (Wynsys), Isleta Resort and Casino (IGT), Red Hawk Casino (ATI), Cache Creek Casino (IGT), Cherokee Nation Casinos (IGT), Comanche Red River Casino (ATI), Gold Country Casino (ATI), Prairie Band Casino (ATI)-Main Support for clients: Gun Lake Casino (IGT), Palace Resort Casino (IGT), El Cortez Hotel & Casino (ATI), Silverton Casino (ATI), Graton Casino (IGT), Oaklawn Casino (IGT), Golden Nugget Casino (ATI)-Work with onshore and overseas teams to stage data, identify how source tables function, help to implement custom attributes -Participate in strategy related to enhancement of OPTX product regarding Offer and Promotional/Expenses areasMajor Accomplishments: --Corrected logic pertaining to player profit/loss, expense and offers for IGT & Aristocrat systems--Corrected logic pertaining to lease fee calculations on slot machine data for IGT system--Corrected logic pertaining to win/loss/theo slot machine metrics for Aristocrat system--Corrected logic for live slot floor metrics for Aristocrat system--Transformed the way clients are onboarded--Successfully implemented quality and validation as key components to the processes, significantly improving client outcomes and satisfaction

-Mentor, advisor and counselor to students completing data analytics curriculum programs. -Conduct weekly 1:1 sessions and impart technical expertise in Excel, SQL, Tableau studies. Provide insight and guidance on questions about the field.-Grade student submissions to offer constructive, productive feedback and encouragement to help advance student skill sets.-Perform mock assessments and interviews

--Built data architecture to support Tableau implementation, including nightly job creation in SQL, through use of Linked Servers (SQL Server, Postgres, Excel).  --Coordinated with Tableau to build slot metrics dashboard showing YOY, MOM, WOW, and daily KPIs by floor location, game type and other important classifications. Built player dashboard showing geographical location, type of games played and important gaming KPIs by player.  --Rebuilt monthly financial statements saving hours of processing time for the team by speeding up connection (direct to DB using SQL).--Rebuilt daily financial flash report in Tableau for delivery via schedule.  Improved processing time and eliminated manual compilation.--Rebuilt upsell tracking report for Hotel staff saving hours of time of manual compilation.--Filled in as operational resource to support marketing initiatives:  pulled lists, consolidated scripts, built promotions and drawings.  Created backend support check for ease of quality assurance via SQL scripts.  --Provided analysis on ad-hoc requests from management.--Filled in as Project Manager for Hotel Migration (from Opera to Agilysys) after go-live.

-Responsible for migrating reports from one reporting platform (Oracle Discoverer) to another (OBIEE), for the South America regions while reducing redundancy and engaging end users in testing and efforts. Successfully retired over 25 redundant reports and migrated over 40 reports in a 4 month-span.-Responsible for management of offshore team supporting OBIEE reporting platform and management of contract and SOWs related.-Responsible for RFP process in finding a 3rd party support vendor for end of life Oracle product. Successfully worked with potential vendors and was on committee for final selection.-Responsible for Change Management project process as company moved from one financial ERP (Oracle) to another (SAP). Worked across multiple teams to guide weekly tasks (with use of JIRA) in identifying how processes would change. Trained each individual on use of JIRA, including providing cheat sheets on navigation and functionality. Provided upper level management weekly status updates on progress.-Responsible for managing resource and providing architecture and data flow processing documentation for how month-end close processes functioned. -Responsible for compiling comprehensive analysis of ERP project budget (total: $55M), showing licensing, maintenance, vendor and travel spend per cost category. Responsible for realignment and allocation of budget submissions through Oracle Prism platform.-Responsible for EnableNow captures regarding new reporting platform for training.-Responsible for providing recommendations on future state for global reporting solutions.-Responsible for ad-hoc data pulls and analysis.-Responsible for other consultants as directed.

-Responsible for reverse engineering, documenting and architecting data models against 3rd party system platforms to produce self-service BI reporting in Looker. Two systems completed in 6 months: one relational database, one NoSQL database. -Responsible for various ad-hoc data pulls and analysis of GMV for investor funding and cash flow estimations for securing of capital.

Project based work; consultant/advisory role

-Responsible for generation of daily journal uploads and P/L reporting-Updated all custom stored procedures during Aristocrat system upgrade (40+ scripts and 30+ stand-alone Crystal and SSRS reports)-Produced and provided over 20+ analysis aiding executive management in making important decisions about free play distribution, point multipliers, and comp % earnings -Created custom mapping and reporting of floor areas to facilitate comparisons and aid in new configurations to increase revenues

-Responsible for project delivery of company-wide $3 billion revenue generating process consisting of migration of functionality and data from an on-premise Hadoop system to the Microsoft Azure Cloud Platform.-Lead team comprising of developers, data architects, quality assurance, and analysts to understand requirements and deliver on commitments.-Matured the use of continuous integration tools (VSTS) and Agile Methodology by conducting daily standups, planning sessions, demos, retrospectives and provided cross-functional support where necessary.

https://generalassemb.ly/instructors/jennifer-viola/8551-Created and developed custom curriculum for teaching students Excel and SQL in workshop/bootcamp classes. Delivered exceptional classroom experience and learning to students who took these topics.--Re-wrote and developed new part-time data analytics course curriculum (Excel, SQL, Tableau) resulting in the first successful delivery of the data analytics course in Chicago. Aided main office out of NY in understanding what needed to be changed to make it successful. Averaged 9 out of 10 scoring for every class delivered through exit ticket survey feedback. Achieved highest positive NPS score for the course in Chicago.Oct 2016 --Instructor for SQL Bootcamp (2-day weekend workshop)Sep 2016 --Instructor for Introduction to Data Analytics (2-hour class) --Instructor for Excel Bootcamp (4-hour workshop) --Guest panelist: Introduction to the Chicago Data Community https://generalassemb.ly/education/introduction-to-the-chicago-data-community/chicago/28247 --Guest speaker: Women in Tech https://generalassemb.ly/education/women-in-tech-breakfast/chicago/28259? utm_medium=partner_social_local&utm_source=panelists&utm_campaign=WomenInTech Write Up: http://theideaforge.com/chicagos-women-taking-charge-tech-industry/Jun - Aug 2016 --Instructor for Data Analytics (part-time 10 week course) --Instructor for Intro to Data Analytics (2-hour class) --Instructor for SQL Bootcamp (2-day weekend workshop)May 2016 --Instructor for SQL Bootcamp (2-day weekend workshop)Feb - Apr 2016 --Instructor for Intro to Data Analytics (2-hour class) --Teaching Assistant for Data Analytics (part-time 10 week course)

-Developed and implemented 4 pronged strategy supporting strategic company goals by restoring trust and accuracy, increasing awareness and communication, enhancing existing functionality thereby reducing operating costs and maturing analytics as a discipline.-Saved expense of purchasing 3rd party BI tool (~$30,000) by instead maximizing the reporting functionality in existing systems (Business Objects embedded with Personify) and software (PowerBI through Office365). -Discovered and corrected multi-year membership renewal issue costing the company significant loss in revenue by investigating and discovering the root cause of a website development coding error using complex T-SQL queries. -Improved 3rd party integration SSIS ETL packages supplying campaign management data by figuring out where duplicates were being introduced and eliminating them. Updated tiered matching logic within all the packages and re-architected resulting storage of data in the datamart for easier/timelier/redundant use. Resulted in reduction in member complaints and greatly improved business operations.-Lead effort for consolidation of member products from 200+ down to 5. Created flexible solution (mapping tables) with no hardcoding for renewal of products through a complex set of T-SQL stored procedures and functions.-Updated 42 stored procedures supporting 65 Crystal Reports in support of product consolidation/CRM system upgrade. -Created and distributed a report catalog to aid all areas in understanding the data available for consumption.-Responsible for resolving all data discrepancies and providing new reports using Crystal, Business Objects and/or PowerBI.-Performed list matches from disparate sources using SSIS to find common members with tiered logic including the use of fuzzy matching logic.-Aided in teaching key stakeholders and other key personnel how to maximize the use of Business Objects, PowerBI and Excel to better understand and analyze their data.

-Identified companywide KPIs; built reporting from transactional database to support multi-year tracking to detect seasonality trends -Managed re-implementation project for Omniture/Adobe Analytics, making a $30k/yr. investment valuable again to key stakeholders-Developed key metric dashboards to support sales team personnel for renewing contracts; aided in retaining many clients -Successfully prevented loss of revenue by writing complicated MySQL queries that showed when campaigner logic was not working-Built data model of existing data environment; moved bloated transactional logging to other web platforms (Adobe/Google) -Aided in Proof-Of-Concept for marketing PPC efforts by analyzing keyword data, then structuring and building campaigns-Responsible for company-wide education and training of key personnel and junior-level analysts-Won company-wide award voted on by peers: top impact/performer of 2013; awarded in Dec 2013.

-Responsible for ad-hoc query development using T-SQL and support of key finance personnel -Built 4 new excel templates for ease in data manipulation, saving 1/hr. per job in processing time-Produced business requirement and technical specification coding documents to aid in re-work of nightly query processing-Developed new reconciliation report for caging vendor to independently check different data sources and balance daily-Day to day operational relationship manager for NARFE organization ($11 million dollar lifetime donor group)

-Responsible for creating and reconciling bi-monthly financial reports-Redesigned Project Attribute MS database; eliminated unnecessary data extracts and simplified processing from 4 hours to 1 hour-Developed new data set combining forecast, actuals and budget data to show history and aid in analysis of project performance-Developed 3 new reports for aid in Quality Checks in Forecasted data resulting in 1/hr time saving per job-Prepared analysis on Actuals spend and prediction on future spend

-Responsible for supporting over 75 PeopleSoft reports and queries for 80+ business managers and Regional Finance Directors-Co-Managed a 3 month project consisting of fixes and enhancements to over 20+ queries and reports-Performed analysis on report/query usage and supported testing efforts system-wide and report/query specific-Completed SDLC documentation and assisted in training strategy-Assisted onsite in DC for 2 months during the rollout of the upgraded PeopleSoft system

-Created and Compiled Company-Wide Metrics for all applications regarding prescribing statistics-Built 5 Key Enterprise reports for use within the stand-alone ePrescribe application for external customer use-Built 10 Key Monthly reports for use of internal stakeholders-Performed several key analysis involving modeling scenarios for highly confidential contract negotiations-Responsible for the Financial Reporting of contracts on a monthly basis across all applications-Wrote SDLC documentation as appropriate for various projects

-Major Contributor in building successful data warehouse used by leadership on a daily-basis for critical decision making.-Automated over 20 key business reports, saving countless hours of manual labor -Instituted matchback process to evaluate response rates on direct mail campaigns-Developed consistency in data presentation, report format and delivery for all data warehouse sourced reports-Streamlined numerous data initiatives to satisfy needs of all departments (Marketing, Merchandising, Operations, and Finance)-Performed over 50 ad-hoc analysis for key business owners to evaluate business performance-Developed internal program to train area SME’s in use of Business Objects

-Improved market share reporting analytics by re-designing standard reports and organizing consultations with senior management-Created standardized report to track fee reversals at front line to detect fraudulent activity-Managed network-wide program for New Mover prospect leads; coordinated efforts for standardizing communication, designed new processes for faster delivery of leads, identified new response reporting tactics -Supervised conversion file activities for customer communication on 2 major acquisitions involving over 250,000 customers-Compiled customer communication file for collapsing Harris’ 27 Illinois banking charters and saved over $10,000 in cost by designing a systematic way to identify customers who didn’t need to receive a letter-Steered and supported territorial re-alignment efforts for executive management for all branches -Coordinated and executed all mapping efforts relating to US expansion and acquisitions initiatives

-Prepared, compiled and managed over 50% of all campaign files for customer communication -Designed, implemented and administered 2 databases to support front-line data gathering-Coordinated the list preparation of the Gramm-Leach-Bliley Act Privacy mailing in a cost-saving manner-Innovated new processes to stream-line and fine-tune 5 recurring objectives -Assisted in training all new employees to the area

-Served as the liaison between Technology, Business and Operations teams to build a new online banking reporting environment including developing numerous reports, research tools and database functions-Developed a new intranet site to administer and deliver reports-Prepared all supporting documentation for assistance in training new employees

-Designed new customer enrollment forms for ease of input -Planned, implemented and produced new statistical reporting format for new Bill Payment System-Prepared, organized, created, and compiled test scripts and schedules for user acceptance testing

-Leader of Debit Card Management Area-Responsible for performance reporting of and reconciliation of daily data entry-Provider of customer service to ATM card holders and internal clients-Responsible for data entry of new ATM/Debit cards issued