James P Hicks Email & Phone Number

Grafton, Ma, Us

Consultant - Business Analyst , Project Management, Data Warehousing , Data Cleansing, Data Base Normalization in the Banking Industry.

•Created Small Business by applying Standard Computing practices to Small Business.•Free Lancing Several Commercial and Personal Web Sites.Utilizing Testing across Browsers.•Testing and QA project management designing and developing the Front End of Web properties from concept to integration into the production environment. Microsoft Access and SQL•Migration and regression testing.•Search Engine Optimization. (SEO).•CSS, HTML and Java and JavaScript.•Designing and developing the Front End of Web properties from concept to integration into the production environment.•Maintenance and Enhancements of Office PC’s and Hardware.

Sr. Implementation Analyst

• Supporting new and existing Clients during implementation, ongoing processing, Upgrades, Annual Enrollment, and Quarter End/Year End Processes on our recordkeeping systems and surrounding applications. This includes strong multi-tasking skills, problem resolution, testing, and communicating effectively. • Monitor their assigned tasks or projects to ensure established SLAs are being met • Provide technical support to all Client users of the business applications within area of expertise • Apply technical knowledge in a specialty area to formulate an approach to a problem. • Uses experience, and analytical skills as a sound basis for decision making and/or programming solutions , SQL• Integrate Quality Assurance processes into all projects

• Liaison between the Finance Office as a client and the technical areas to assess and develop requirements for complex end-user, business, and system needs and procedures. • Work in coordination with Finance Area users to identify business issues and data challenges and ensures they are tracked, reported on, and resolved in a timely manner.•Plan and conduct studies of potential data processing applications and prepares roadmaps to reflect system objectives and the resources required to develop systems that meet Finance Area needs. • Functioning as project manager on assigned projects, to develop project plans, and establish project schedules.• Support of Datatel Colleague.• Project Planning of ImageNow imaging software package and Informer report writing.• Fully responsible for all requirements and test cases in the project and required to collect and validate all sign-offs .• Schedule, lead and document interviews with all the stakeholders and document how the project impacts them and what their needs, concerns and impact is for the project to flush out their requirements. Captures risks and concerns during requirements sessions.• Identifies any missing items through interviews• Created and fully document high level and very detailed requirements, specifications, business process flows for current state business process and future state business process• Documents business, technical, security, risk, standards, and other requirements as applicable.• Creates use cases and test cases for each requirement showing how you will know if the requirement was met • Documents functional and technical specs•Leads testing efforts of requirements and documents full results reporting updates to PM• Ensures issues are identified, tracked, reported. • Identifies critical issues working with PM, stakeholders, PM and Program Manager. • Extensive experience documenting complex business rules.

Achievements:• Producing reports using complex queries for project data analysis for SAP conversion. • Creating Microsoft Access data base to convert text files and Microsoft Excel files SQL Query's into Microsoft Access data base tables. • Conducting Data analysis for manufacturing projects and products for the General Ledger.• Producing Microsoft Access data base tools for client’s analysis.• Converting SAP and Legacy Data files to Microsoft Access data bases. • Designing Microsoft Access Data Bases and Tools.

Achievements:• Production Support • System enhancements • DB2 Project Improvements .SQL• Visual Basic Application Enhancements

Achievements:• Conversion and Implementation of Human Resources and Payroll Reporting systems from SAS and DYL280 to COBOL.• Produced production ready job streams for the scheduling of the reports.• The result is that the Systems department can now maintain the programs within TJX standards. • Programs, Documentation and Procedures utilized Change Management software manage project components.• Sarbanes–Oxley Compliance

Achievements:• Implementation of Major COBOL subsystems enhancements. SQL Query's and reporting/• Creation of Auditing Reporting System sending data from the Mainframe / DB2 to a PC Application. The data base and user interface was created using MS Access.• Adhoc reporting when requested.• Implementation of Client data from Prior Record Keepers to Company format. Verify the data then load it to the production system. Data manipulating using SAS batch and PC SAS.• Created programs used to audit mutual funds in participant data base.• Microsoft Data Base programming and GUI tools.Responsibilities:• Implementation of Client data to Company Format using SAS.• Creation of COBOL, DB2 projects using Company Standard Methodology. Project components maintained and managed using Endevor. • Maintenance of Phone Representatives training data base and enhancements.• Creation and Maintenance of Audit reporting system.• System security representative for our group.• Sarbanes–Oxley Compliance

Achievements:• Development of Financial Transaction System. Responsibilities:• Development of COBOL Batch programs and testing of new systems.

New England Power Service Company

Achievements:• Implemented Major enhancements to Online IMS Wholesale Billing System.• Created automated process for collecting data from substations then passing the data to the Mainframe IMS data base written in COBOL. • Created Flexible billing system for the Rate Department (SAS System).Responsibilities:• Responsible for Mainframe IMS Wholesale Billing system. • Responsible for Maintenance and enhancements of Flexible Rate system.• VAX systems written using Ingres / VMS to keep track corporate Taxes. SQL

Achievements:• Worked on several major COBOL IMS projects.• Created and Developed an Employee reporting system for the corporate office.• Created a data base in using VAX VMS. • Created and Maintained Inventory system for a specific project office.Responsibilities:• Developer for Major projects from Requirements to Implementation.• Implemented enhancements and changes to Engineering Change Order system. • Maintained and Enhanced Logistic tracking system for specific project office.

Six Sigma

Green /Black

Continuing Education – Programming Courses C+,C# And .Net

Major Business Administration

Associate Cis, Computer Information Systems

Major Aerospace Engineering

Education record