Jerry Nicholson's Location
Duluth, Georgia, United States, United States
Jerry Nicholson's Contact Details
Jerry Nicholson work email
- Valid
- Valid
- Valid
- Valid
Jerry Nicholson personal email
n/a
About Jerry Nicholson
IT professional with experience in various roles including Programmer Analyst, Systems Analyst, Business Analyst, Unix Administrator, QA Tester, Production Support, Database Administrator (DBA), and Data Modeler. Possess extensive knowledge of Relational and Dimensional databases design. Extensive experience in all phases of the development life cycle - requirements gathering, data modeling, application programming, quality assurance (QA), and production support. Work experience in Telecom, Health Care, Investment Banking, Commercial Banking, Law, Publishing, Real Estate, and Supply Chain.
Jerry Nicholson's Current Company Details
Ibm Watson Health
Senior Business Analyst/Data Analyst at IBM Watson Health
Duluth, GA, US
Jerry Nicholson Work Experience Details
-
Ibm Watson HealthDuluth, Ga, Us
-
Senior Business System AnalystIbm Watson Health Nov 2018 - Present• Responsible for facilitating customer Requirement Analysis Sessions (RAS) with the client and external healthcare Medicaid and State Health Benefit Plans (SHBP) data source vendors.• Worked as a liaison between the Client and the internal IT staff of ETL developers, Data Architects, Data Analysts, Data Modelers, DBAs, and QA, to clarify business requirement and assist with creating testable functional requirements and user stories.• Used JAMA automated software to manage requirements and end-to-end traceability across the development lifecycle.• Worked with subject matter experts to ensure all the proper questions associated with a given data source were identified and answered satisfactorily.• Worked with Data Analysts and Data Modelers in assuring requirements are traceable between the source data and target tables/entities in the respective data model. • Worked with Data Modelers to identify entities, data elements, and their relationships in the conceptual, logical and physical data model • Worked with Agile Scrum teams to create user stories from product backlog that have been targeted for a specific sprint and release• Familiar with the following Healthcare initiatives: HIPAA, MITA, MECT, HL7, X12, EDI transmissions of Healthcare data, NMEH, NIEM, NCPDP, etc.
-
Data ModelerSuntrust Sep 2017 - Nov 2017Charlotte, Nc, Us• Gather and analyze business requirements, and translates them into 3NF logical and physical data models.• Work with business users to enforce naming standards for model names, subject areas, schemas, entities, and attributes.• Served as a communication link between the business, developers, and DBA group.• Used Erwin Data Modeler 9.6, to create models, and manage metadata, and Erwin Model Mart 9.6 to archive models. -
Data Analyst/Data ModelerVerizon Wireless May 2014 - Dec 2016Basking Ridge, Nj, Us• Provided Data Modeling services for Verizon’s Enterprise Rating Group utilizing Erwin data modeling tool.• Responsible for data analysis, and translating business requirements into logical and physical data models.• Conducted joint application development (JAD) sessions with Managers, Business Analysts, Application Developers, and DBAs to ensure that the design meets the business requirements.• Worked with developers to analyze/optimization SQL scripts to improve query performance.• Worked with Business owners, and DBAs to determine the storage requirements, data retention periods, and archive strategy on all new projects.• Enforced naming standards for database objects (tables, columns, stored procedures functions, and packages).• Created and deploy DDL and DML scripts in development, system test, and performance test environments.• Provided technical support during deployment for Enterprise and Maintenance releases on a weekly basis.• Maintain approximately 15 Oracle 12g database schemas across multiple database instances. -
Business Systems AnalystLift361 Nov 2012 - Mar 2014Duluth, Georgia, Us• Worked as technical lead on projects involving the Business Intelligence group, external Clients, and IT.• Responsible for functional aspects of design, development, and system integration for client engagement, from definition phase through implementation.• Responsible for documenting requirements, and functional specifications utilizing predefined document templates, which include data flow diagrams, ER Diagrams, star schemas, and data cleansing rules.• Created new documentation standards to ensure that all client projects are documented consistently.• Worked with external clients, on-shore and off-shore developers, for design, development and functional quality assurance testing• Worked with client IT departments to determine data delivery standards, frequency of data delivery, data security protocols, and file transfer protocols.• Provided Data Modeling services utilizing Embarcadero ER/Studio Data Architect 9.7.• Used Data Warehouse environment MS SQL Server 2012.• Provided ETL services using Microsoft SQL Server Integration Services (SSIS - SQL Server Management Studio, SQL Server Data Tools, Import Export Data, etc.).• Conducted weekly project meetings to keep project stakeholders informed about the status of ongoing projects. -
Senior Systems AnalystNovartis / Ciba Vision Jun 2006 - May 2012Basel, Baselstadt, Ch• Provided application programming services for US Logistics warehouse management system (WMS) using Informix 4gl, SQL, and Informix Dynamic server.• Created user requirement, Use Case, Functional Specification, ER Data Models, Test Case documents, and Standard Operation Procedure (SOP) documents.• Worked with developers (on/off shore) to design, develop and test application enhancements.• Executed test cases in development and QA, and reported results (pass/fail) to business and vendor.• Designed and implemented Audit interface between SAP Order Entry system and Warehouse Management Distribution system.• Extensive use of SQL for ad hoc reporting, and to resolve production issues on a daily basis.• Implemented software rollout in development, QA, and Production.• Executed quarterly SOX compliance testing for US Logistics Warehouse Management System.• Performed routine Oracle DBA tasks (create tables, create indexes, optimize SQL queries, monitor table and index space).• Designed Disaster Recovery solution for US Logistics Warehouse Management System.• Migrated Legacy Informix DBMS with approximately 375 tables to Oracle 10g environment.• Provided 3rd tier support for WMS application (Red Prairie) users during production hours, and off-peak rotating on call support. -
Enterprise Data Warehouse Testing And SupportAt&T Dec 2006 - Jun 2007Dallas, Tx, UsEnterprise Data Warehouse Testing and Support• Used BI Query, Business Objects, and Erwin/Erx in a Data Warehouse (Teradata) environment. • Created Test plans for Daily Sales Reporting (DSR) 2.0 data mart, which included enhancements to capture and report on sales data during the launch of Apple’s iPhone.• Executed test cycles and document results.• Conduct daily team meetings to report bugs and track resolution with the development team during the testing phase.• Provide 3rd. tier technical support for Performance Planning Analysis (PPA) group.• Conduct bi-weekly meetings with PPA team to provide status updates on open issues and concerns.• Attend weekly Change Management meetings as point person for bug fixes, enhancements, and upgrades to the production environment. -
Independent ConsultantThe Home Depot Oct 2003 - Dec 2006Atlanta, Georgia, UsLogistics Technical Support • Provided 3rd party vendor (Catalyst) application support for Domestic Distribution Centers, Product Consolidation Centers, Import Distribution Centers, and Transit Facilities in several cities across the US.• Documented software enhancements using UML Use Case Diagrams, design, and code using Informix 4gl procedural language, SQL, and Unix Shell scripts.• Used Mercury Test Director to create test plans, execute test cases, document errors and communicate results to application programmers and business users.• Provide 24/7 on call support to end users on a wide array of issues (networking, application software failure, server outages, etc.).• Troubleshoot file transfer, and Maestro nightly scheduled batch jobs failures.QA Tester• Worked with QA team to perform end user testing on the Return To Vendor system. • Utilized Test Director to create test scenarios, execute test sets, and document product defects. • Used SQL scripts to validate data integrity. Application Programmer • Created software enhancements to the “Pay Thru Scan” project using Informix 4gl and SQL to identify and remove consignment vendors from physical inventory process. • Worked on the “Return to Vendor” project. The project’s primary objective was to reduce cost associated with processing merchandise returned to the store. • Created Use Case documents. • Performed various application programming tasks using Informix 4gl, SQL, C, and Shell Scripts. -
Senior Technical OfficerChase May 1997 - Aug 2001New York, Ny, UsData Modeler• Provided data modeling services to approximately fifty developers in various locations (New York, Delaware, Tampa, FL, and Tempe, AZ).• Extensive use of Erwin/Erx, Model Mart (model repository), and Web Publisher. • Meet with business users and developers to identify source and target metadata. • Create logical and physical data models for OLTP systems (Informix, Oracle, SQL Server), and dimension models for the data warehouse (DB2/UDB). • Forward engineer schemas (tables, indexes, referential integrity, triggers, and stored procedures) to development, testing, production, and training environments. Database Administrator (DBA) - Oracle, Informix• Installed, configured, and monitored over 20 Informix databases, in five locations with a total of over 2 terabytes of data. The applications support over 4500 users in New York, Tampa, Tempe, White Clay, and Wilmington.• Monitor daily reports (error log files, table and sort space, extents) to access general health of the DBMS • Monitor database growth to verify initial disk estimates and allocate additional disk chunks as needed • Create tables, indexes, triggers, stored procedures, and referential integrity constraints in Development, QA, and Production. • Provide 24 x 7 on call support -
Senior Financial AnalystProskauer Rose Llp May 1996 - Aug 1997New York, New York, Us• Supported 3rd party vendor (Brock Control Systems) legal billing system.• Used IBM/Aix, Informix Dynamic Server, Informix 4gl, Business Objects, and Crystal Report.• Installed and maintained vendor accounting software, and Informix database upgrades.• Performed as IBM Aix System administration for backup and recovery (add / remove users, add disk space, etc.).• Installed and configured Business Objects to provide ad hoc queries to the accounting staff. -
Business System AnalystSmith Barney Jun 1995 - May 1996• Supported 3rd party vendor investment services database.• Worked closely with 3rd party vendors to test and implement product upgrades.• Performed application and Informix DBMS upgrades.• Environment included IBM AIX on RS 6000, Informix Online.
Jerry Nicholson Skills
Systems Analysis
Business Objects
Microsoft Office
Unix Shell Scripting
Oracle Sql Developer
Embarcadero Erstudio Data Architect 9.7
Erwin Data Modeler
Ca Modelmart
Informatica Powercenter
Mercury Test Director
Hp Quality Center
Pl/sql Developer
Microsoft Project
Lotus Notes Developer
Crystal Report Writer
Bi Query
Teradata
Oracle 11g Database Administration
Microsoft Sql Server
Ssis
Informix 4gl
Informix Dynamic Server
Redprairie Warehouse Wms
Catalyst Wms
Ibm Aix
Hp Ux
Sco Unix
Solaris
Use Case
Erwin
Oracle
Integration
Databases
Business Intelligence
Aix
Access
Crystal Reports
Informatica
Ms Project
Jerry Nicholson Education Details
-
Emory UniversityData Analytics -
Pace UniversityManagement Information Systems
Frequently Asked Questions about Jerry Nicholson
What company does Jerry Nicholson work for?
Jerry Nicholson works for Ibm Watson Health
What is Jerry Nicholson's role at the current company?
Jerry Nicholson's current role is Senior Business Analyst/Data Analyst at IBM Watson Health.
What is Jerry Nicholson's email address?
Jerry Nicholson's email address is jw****@****uth.net
What schools did Jerry Nicholson attend?
Jerry Nicholson attended Emory University, Pace University.
What skills is Jerry Nicholson known for?
Jerry Nicholson has skills like Systems Analysis, Business Objects, Microsoft Office, Unix Shell Scripting, Oracle Sql Developer, Embarcadero Erstudio Data Architect 9.7, Erwin Data Modeler, Ca Modelmart, Informatica Powercenter, Mercury Test Director, Hp Quality Center, Pl/sql Developer.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial