Data Analyst Quality

John West

ad5sov@r.postjobfree.com • 908-***-**** • Great Meadows NJ

John West has over 15 years in his career delivering IT solutions that optimize efficiency and performance for industry-leading companies, specializing in Data Analytics and Business Intelligence reporting. A Data Analyst, Technical Lead, Architect for several global IT projects using both Agile and Waterfall methodologies. A t ested technical leader who can mentor and coach cross-functional teams to success using best practices across international borders. John has led several Data Quality projects to build Data Analyst organizations offshoore/onshore based on real-world situations and IT best practices. John holds a Bachelor of Science in Computer Science from the New Jersey Institute of Technology and is ITIL certified.

Languages and

Databases:

Google BigQuery, IBM BigSQL (Hadoop), Teradata, Oracle, MS SQL Server, PostgreSQL, MySql, Cassandra, DB2, PL/SQL, SQL, Python, Bash, Windows Shell, XML, JSON, CSV, multi-byte utf-8 and utf-16

Software and

Applications:

MS Office, Oracle SQL Developer, TOAD, Informatica ETL, Cognos, MS SSRS and Crystal reporting, UC4 and Maestro scheduler, ERwin and Power Architect Data modeler, Appfluent database monitor, Epicor ERP, PeopleSoft HR ERP, DataFlux Data Management, HP Quality Center, CA Clarity PPM, SharePoint, Tableau Desktop, Salesforce, Concur, JIRA Hardware: Intel, Sun, PC, Oracle Exadata Appliance Operating Systems: Windows Server, Windows, Sun UNIX, Linux KeyBank - Dec 2020 to present

Software Engineer

Support cloud based data warehouse built on Google cloud platform (BigQuery) • Billions of transactions each month • Data Quality Checks: daily, weekly, monthly • Work with clients and off shore developers to resolve data issues • Assist business analysts to capture requirements, documentation, etc. • Assist developers with testing and provide guidance for best coding practices • Ad Hoc queries and reports • Assisting migrations from Teradata, DB2, IBM BigSQL hadoop to Google Cloud platform and BigQuery LiquidHub, a Capgemini Company – Wayne, PA - Apr 2018 to Sept 2020 Manager II - Liquid Analytics

Data Analyst for specialty pharmaceutical for Amgen and Novatis drug reporting and analytics • Support cloud based data warehouse built on Oracle 11g • Become Subject Matter Expert (SME) across all major Brands • Proactively look for data issues, spikes and dips, referential integrity, etc. • Monitor data extracts • Work with specialty pharmacies and hub data sources and clients to resolve error/failure processing reports for data quality • Work with OPS team to ensure extracts are timely and accurate • Investigate end to end from inbound files to processing to outbound files to resolve data issues • Ad Hoc queries and reports • Analyze data anomalies as requested • Assist business analysts to capture requirements, test changes, documentation, etc. • Participate in weekly code reviews (PL/SQL) • Assist developers with testing and provide guidance for best coding practices Bank of America Merrill Lynch – Jersey City, NJ - Oct 2017 to Apr 2018 Consultant Applications Architect V, Data Architect Group – GMOT Execute GMOT best practices for data quality and data governance • Migration project to move securities data from MS Sql Server to Oracle Exadata Appliance • Re-Model existing HDS repository for over 25 to 30 million trade events each day • Agile scrum methodology using JIRA project tracking software • Exadata Oracle 12c multi-tenant database architecture • Document and support existing data initiatives • Ad hoc query and analysis using data visualization tools like Kibana

Johnson & Johnson / Ethicon - Somerset, NJ - Jan 2017 to Sept 2017 Consultant Data Architect – BUIT

Data Architect for new Ethicon.com website product data model • Responsible for creating Ethicon Product Master Database for the new Ethicon.com website • Agile Scrum development methodology • Hosted by Acquia in Drupal 8 with MySQL back end • Write user stories in JIRA project tracking software Frazier Industrial Inc - Long Valley, NJ - Sep 2015 to May 2016 ERP Data Quality Analyst – IT

Analyst supporting implementation of enterprise Epicor ERP system • Implement best practices for IT service, Change Control and Data governance • Migrated data from various legacy systems to Epicor ERP • Supported all areas of business including Purchasing, Accounts Payable, Accounts Receivable, General Ledger • Developed Epicor reports with MS SSRS reporting from MS Sql Server • Developed analytical Epicor dashboards and data grids with Epicor tools • Ad hoc queries from SQL Server to Excel for analytical reporting • Assist in user acceptance testing and documentation • Supported applications: Salesforce, ADP, Concur Expense and Glovia 1 of 2

John West

ad5sov@r.postjobfree.com • 908-***-**** • Great Meadows NJ Johnson & Johnson / Janssen - Raritan, NJ - July 2013 to Sep 2015 Consultant Data Analyst- IT

Support Open Reporting (Sunshine Act) Enterprise Data Warehouse • A validated system using Oracle 11g, Informatica, and Cognos reporting and analytics • Compile weekly, quarterly, and yearly reconciliation reports using SQL Developer and Excel • Gather and review business requirements for functional and technical specifications • Maintain documentation including process flow and data flow charts in SharePoint • Lead on optimization and auditing projects using CA Clarity PPM, TearaData and Tableau • Assist in user acceptance testing using HP Quality Center Biltmore Technology – Doylestown, PA – Feb2012 to Jul 2013 Database Developer/Architect

Database warehouse developer for multiple hosted pharmaceutical sales and marketing data warehouses • Developed and maintained PL/SQL scripts and data model as needed • MicroStrategy reporting built on Oracle 10g database • Monitored and supported weekly and monthly processing cycles for multiple clients • Gathered requirements from clients and implement enhancements • Generated ad hoc reports for marketing campaigns and decision support using TOAD or SQL Developer • Optimized SQL and PL/SQL stored procedures and packages • Implemented design changes to stored procedures, packages, UNIX shell scripts and job scheduling • Data sources included: IMS Xponent and DDD data, Wolters-Kluwer, and CRM sales force data

Pfizer Inc. - Peapack, NJ - Jan 2009 to Jan 2012

Consultant Data Analyst/Architect, HR Global Data Warehouse, Corporate HRIT Architect responsible for complete redesign of global employee/contractor Master Data model • Agile – Scrum Development methodologies • Proof of concepts with Hadoop and Cassandra • Global HR warehouse re-design and upgrade project and HR data warehouse support Upgraded to Oracle 11g from 10g • Employee/Contractor Master Data serving over 300 global operational applications across 92 countries • Employee/Contractor Master Data contained over 500 standardized attributes • Worked closely with business partners and global standards committee to establish enterprise HR data standards • Established auditing and quality assurance procedures • Migrated procedures and packages from Oracle 10g to 11g • ETL using Informatica and Oracle materialized views and external tables and Cognos reporting

Bristol-Myers Squibb Company – Princeton, NJ - Oct 2007 to May 2008 Consultant Business Analyst, Enterprise Data Architect Group Assigned to Product Hub project, a validated enterprise solution to standardize and integrate product data • Technical lead for functional specification, gathered requirements by coordinating meetings with various organizations including Regulatory and Material Management for the analysis phase • Data analysis and data profiling of product data, identifying data quality metrics, user interface and reporting requirements and mock-ups, data extract requirements, data standardization requirements, data validation requirements, reference data requirements, data hierarchy requirements, process flow charts, and data steward requirements for governance model • ETL with Informatica, data standardization with DataFlux, Java user interface, Oracle 10g back-end database Pfizer Inc. – Peapack, NJ - Apr 1997 to May 2007

Senior Data Analyst/Database Architect, HR Global Data Warehouse, Corporate HRIT Database Architect for Global HR Data Warehouse, originally hired by Warner-Lambert, Inc. merged with Pfizer in 1999 • Originally a Data Warehouse Developer Oracle 9-10, PL/SQL, SQL, ETL, Facts, Dimensions, and reports • Promoted from Database Developer to Employee Master Data Management lead • Worked with internal clients and external vendors to provide and consume HR data • Responsible for new development, maintenance and optimization of facts, dimensions, stored procedures and packages • ETL with Informatica, Oracle materialized views, Oracle loader,

.NET front end user interface • Subject matter expert on Employee Master Data Management projects using Kalido and Hyperion MDM solutions • Compliant for Safe-Harbor, HIPAA and SOX • Appfluent monitoring, Cognos Impromptu, Cognos Powerplay and Oracle products for reporting, and analytical analysis Education: New Jersey Institute of Technology, B.S. Computer and Information Science • ITIL certified 2 of 2

Contact this candidate