Resume

Sign in

Developer Sql Server, pl/sql

Location:
Westerville, Ohio, United States
Salary:
40/hr
Posted:
October 27, 2018

Contact this candidate

Resume:

James M. McCreery Jr.

U.S. Citizen

Candidates’ Location: Westerville, OH

Available to interview F2F with a 48 hr notice

Available to start with a one week notice

e-mail ac7is9@r.postjobfree.com

Home: 614-***-**** Cell: 614-***-****

Professional Summary

Comprehensive hands-on management and engineering experience in all aspects of information technology and production maintenance.

Successfully managed and/or engineered quality, software development, customer support, help desk, technical training, electrical/electronic maintenance, and production maintenance departments in telecommunication, pharmaceutical, and manufacturing companies.

Autonomous leader with the communication, management, and organizational skills necessary to work well with people at all levels while maintaining business relationships with internal and external customers.

Education

Franklin University, Columbus, Ohio, Bachelor of Science in Engineering Technology – Cum Laude graduate 3.6/4.0.

Technical Skills

Oracle

T-SQL

Microsoft Access

Microsoft Office 2010

Oracle SQL

VBA for Access/Excel

TOAD for Oracle

ODBC

Crystal Reports

Visual Studio 2010

SSRS

SSAS

HTML

Visual Basic

Teradata

Microsoft Excel

SQL Server 2008

SSMS

SSIS

Business Objects

Oracle PL/SQL

Oracle DLM and DDL

Large data

Professional Experience

Molina Health Care, Columbus, Ohio (Contractor, Data Analysis, SQL Developer)

09/2016 to 02/2017

Used Microsoft Access 2010 as the front end to Microsoft SQL Server 2008 and Microsoft SQL Server 2008 as the backend to maintain and enhance Molina’s day-to-day operations supporting doctors, hospitals, and other health care operations.

Used Access, SQL, VBA and SQL Server to design queries, procedures, views, and functions to assist in the day-to-day operations.

Designed Access forms, reports, queries, functions, modules, and export events to Microsoft Excel. Enhanced and maintained the daily updates to the system data.

JP Morgan Chase, Columbus, Ohio (Contractor, Data Analysis, Oracle Developer)

Global Identity Access Management Executive Reporting JP Morgan Chase

09/2015 to 11/2015

Input information into Excel from JP Morgan Chase lines of business (LOB) to create compliance report for upper management.

Used Excel to prepare the spreadsheets for creating a 57 slide Power Point presentation covering Applications, Databases, and Operation Systems using formulas and macros.

Reviewed the Power Point presentation making sure the numbers and charts match the Excel spread sheet from above.

Verizon, Hilliard, Ohio (Contractor, Data Analysis, Oracle Developer)

12/2014 to 02/2015 Responsible for the design of new reports, adhoc reports, as well as modification of existing reports, using Oracle Database, SQL, PL/SQL and the day-to- day PreBill exceptions for the Billing Department. Ran various manual reports daily.

Lockheed Martin, Columbus, Ohio (Contractor, Data Analysis, SQL Developer)

07/2013 to 09/2014

Used Microsoft Access 2010 as the frontend to Microsoft SQL Server 2008 and Microsoft SQL Server 2008 as the backend to maintain and enhance Lockheed Martin Accounts Receivable System.

Used Access, SQL, VBA and SQL Server to design queries, procedures, views, and functions to assist in the day-to-day operations of the AR department’s activities.

Designed Access forms, reports, queries, functions, modules, and export events to Microsoft Excel. Enhanced and maintained the daily downloads from Lockheed Martins’ customers.

JP Morgan Chase, Columbus, OH (Contractor, Data Analysis, Oracle Developer)

07/2012 to 07/2013

Responsible new reports as well as modification of existing reports, using Oracle Database, Toad for Oracle, SAP Business Objects (BO), SQL, PL/SQL, Crystal Reports (CR) and Microsoft Access in the day-to- day reporting requirements for the in-house Escrow Department requested BO, Toad, Access and CR reports for the Escrow Analysis Department.

APS HealthCare Inc, Grandview, OH (Reporting Analyst II, Data Analysis, SQL Developer)

06/2010 to 06/2012

Responsible for the design of new reports, as well as modification of existing reports, using BI, Crystal Reports, Infoview, SQL, WEBI, and Voyager with commands, procedures, and queries against Microsoft SQL 2005 and 2008 databases.

Designed and implemented numerous queries and ad hoc reports used in the day to day operations in support of our Customers; State of Ohio, State of Indiana, and State of Florida in the administration of their employee’s health Insurance.

Designed and implemented many reports used by our customers to reduce health costs and services acquired by the state’s employee.

Vertex Systems, Inc., Westerville, Ohio

Developer II (Reporting Analyst II, Data Analysis, SQL Developer)

06/2007 to 11/2008

Responsible for the design of new reports, as well as modification of existing reports, using Crystal Reports with commands, procedures, and queries, and Dynamics NAV reporting system.

Designed and implemented numerous queries and ad hoc reports using InterBase SQL, Crystal Reports, and Dynamics NAV reports used in the day to day operations of our customers’ businesses (human services).

Designed and implemented many reports used by our customers to report charges and services to the state and federal governments making sure that the reports comply with all state and federal government regulations.

Boehringer Ingelheim Roxane Laboratories, Columbus, Ohio

Supervisor/Application Administrator (Reporting Analyst II, Data Analysis, SQL Developer)

04/2003 to 04/2007

Managed 13 Process Control Systems (PCS) technicians and 4 contract technicians in a three shift operation.

Responsibilities included scheduling, calibration, certification, and repair of instruments and equipment used in the manufacture of pharmaceuticals.

Performed as the Application Administrator for the Computer Maintenance Management System (CMMS) hoc reporting and support for validation, qualification, and testing of new equipment. numerous queries and ad hoc reports using SQL, Crystal Reports, PL/SQL, and Oracle Discoverer; resulting in over 150 ad hoc reports.

US Marine Corps - 1964 -1968, Grade - E4, Fire Control on F4B Phantom Jets, Viet Nam- 1967 – 1968.



Contact this candidate