Patrick Watts Email & Phone Number

Santa Clara, California, Us

Chicago, Il, Us

Clarity Insights is the largest consulting company in the US that focuses exclusively on data strategy, engineering, science and visualization. We help our clients—Fortune 1000 companies across multiple industries—leverage data and analytics to find actionable insights that can help them seize new opportunities and solve their toughest business challenges.Entertainment Client• Developed an AWS cloud-based data platform to process customer and fan watching patterns to develop better content and better direct marketing.• Designed the cloud architecture end-to-end including security, network, data ingestion, data transformation, DevOps, and Distaster Recovery• DevOps System included code management, automated testing, and automated code deployment leveraging Infrastructure as Code (IaC) standards.Financial institution• Developed a modern data architecture big data platform for processing various data sources into a Cloudera data lake.• Created a custom Hive SerDe to process EBCIDIC binary packed decimal data files into Hadoop using Apache Spark (Scala).• Took an existing client and increased Clarity's revenue stream by 225%.Insurance Payer• Delivered a Cloud strategy and roadmap to replace their existing Enterprise Data Warehouse (EDW).• The technical platform leverage AWS, Spark, S3, and Oracle.Cable Provider• Technical Lead for Hadoop/Apache Spark data processing system with the intent to remove an existing third party vendor with a reduction of cost of over 2 million dollars a year.• Architected big data system to replace existing ELT Netezza legacy system.• Developed testing strategy leveraging TDD along with Scala-test framework.• Leveraged continuous integration framework of Jenkins with Enterprise Github• Technical Platform – AWS, OpenStack, Apache Spark, HDP, Scala, Teradata, Ambari, Jenkins

Dublin 2, Ie

Major Pharmaceuticals Company• Served as Technical Lead for an implementation of Oracle’s Life Science Data Hub for clinical drug trials.• Managed on-shore and off-shore team of 14+ resources for the development and testing phase of the project.• Managed relationship with the client on all technical matters.• Trained client technical resources in the use of Informatica.• Modeled landing area for an ESB solution.Major Healthcare Insurance Provider• Acted as Test Lead for Consumer Marketing Data Repository (CMDR) and Group Marketing Data Repository (GMDR). • Managed team of on-shore and off-shore resources during testing effort.• Developed general testing strategy for CMDR/GMDR systems.• Delivered all testing deliverables on schedule for deployment.

Major soft drink supplier• Delivered data warehouse solution to support logistical analysis.• Managed client relationship and worked closely with client architecture team.• Architected data warehouse solution for logistics digital dashboard (LDD). • Supervised team of resources in the development and testing effort.• Supported LDD operations during warranty phase of the project.• Produced archiving solution to replace legacy reporting solution, using Informatica 8 and BO XIR2.• Delivered 15 separate data models to support archiving legacy reporting systems and designed ETL processes to load historical data from legacy systems into the archiving solution.

Houston, Texas, Us

Major software vendor• Architect for enterprise level BI software suite to link proprietary software applications.• Created ETL solution to map DB2 and SQL Server data sources to Oracle BI software.• Collaborated with domestic and international business teams for system analysis, as well as coordinated development and testing efforts.Major Insurance Company• Served as Team Lead responsible for project and task management for Home OI data mart. • Created team status report, project plans, and contractor interviewing.• Developed Informatica mappings for Home OI data mart.• Participated in creation of design guidelines, design document templates, unit test plan templates, status report templates, development checklists, code review processes, and design review processes.• Analyzed existing reprocessing code base and determined an enhancement plan to be implemented so BO reporting layer could be rolled out to the business users.Major Insurance Company• Planned system test activities for Financial Close Transformation (FCT) application.• Reviewed FCT and prepared system test strategy, testing all mechanical components of the application, which included Informatica ETL, ABC code base in PERL, and SQL procedures.• Executed system test plan, as well as ran all applicable datasets and validated identified test cases.• Worked on performance tuning Informatica ETL applications and application SQL queries in DB2.

Chicago, Illinois, Us

• Team Lead responsible for project and task management for Key Performance Indicator (KPI) team that included offshore resource management.• Architected ETL solution for business intelligence solutions for KPI.• Constructed shell script backbone of the KPI ETL solution.• Enabled ETL solution using Business Objects Data Integrator BODI.• Designed, developed and tested PL/SQL programs.

Major Cable Television Provider • Managed team of over 6 developers.• Constructed ETL using Informatica 7.x.• Architected CDC solution with Data Mirror TS.• Maintained and enhanced existing shell script control system.• Worked with third party data provider for mass billing ETL solution.Healthcare Information Firm• Created Informatica mappings for multiple releases of ETL applications.• Designed system wide validation processes that validated data at both record level and batch level.• Modeled batch level validation tables into the data model.• Functioned as QA lead during phase 1.4, responsible for automating QA tests and managing QA team.• Tracked and maintained defects during QA testing processes.

Graduate Mathematics

Ba, Physics, Mathematics

Mathematics Advanced Study Semester