• Address: Detroit, MI 48222 (map)
• Date Posted: 10/04/09

Nicholas W. Shephard Sr.
3311 Calvert Ave.
Detroit, Michigan 48206
313-695-3880
Email: shephardfamilyenterprise@hotmail.com


SKILLS: Oracle Forms and Oracle Reports, ORACLE Financials 11 i (11 .5.10.2) - AR, AP, GL, and Cash Management; MSSQL Server and SQL Queries, UNIX shell scripting; Creating Flat Files, Control file scripts, Loader scripts, PLSQL and SQL; JAVA, XML; FTP process; T.O.A.D., GQL; Microsoft Access, Excel, Microsoft Word, PowerPoint, Healthcare knowledge, Claims, implemented Diamond Claims and Membership system from MADS Legacy System that was used to house Membership and Claims data, data conversions, update data in Data Warehouse and used that data in a repository for Manage Care Data Mart for analysis. I have implemented with team members the conversion of Diamond Membership and Claim Systems to Paradigm Membership and Claim Systems. I can use VISIO and currently type 55-65 wpm.

EXPERIENCE

Shephard Family Enterprise
Detroit, Michigan 48202
313-695-3880

(Contractor) Business Consultant/Application Developer April 1985 – Present
Skills:
* ERP Modules : Oracle 11.0.3, 11i (11.5.3/11.5.6/11.5.9/11.5.10/R12.0.4) E-Business Suite Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Purchasing, Fixed Assets, Projects, Inventory, Bom, Wip, Order Management, HRMS, Workflow Costing and System Administration
* Interfacing Tools: Dev. 2000 (Forms 4.5/5.0/6i/9i, Reports 2.5/3.0/6i/9i), SQL LOADER, SQL Navigator, TOAD and Oracle Discoverer.
* RDBMS: Oracle7.x/8.x/8i/9i/10g, and Microsoft Access 97/2000
* Reporting tools: Reports 2.5/3.0/6i/9i, Discoverer 3.1/4i/10g, Crystal Reports 8.0/9.0.
* Languages: SQL, PL/SQL, Shell Scripts, Visual Basic 6.0/5.0/4.0 HTML,VB Script, XML.
* Netware: TCP/IP, Telnet, Netscape, and Internet.
* Operating Systems: UNIX Aix, Linux, Sun Solaris, Windows-9x/XP, Windows-NT
* Managed clients systems by doing system analysis, database configurations, and data conversions.
* Developed Microsoft databases using table structures, query’s and joins then generating reporting tools. Created Excel spreadsheets, mail merge documents to track invoices and receipts.
* Developed marketing strategies for small businesses and presentations; organize computer base training for community users.
* Organized structure for the placement of employees for community services.
* Arranged recruiting methods for entertainers, models, singers, dancers, and other entertainers for the Givenchi and Rawsey’s Entertainment Agency a subsidiary of the Shephard Family Enterprise. Most recruitments were for television commercials, magazines, fashion shows with association and coordination of YSL Advertising Co. in Yamaguchi, Japan.





















Health Alliance Plan - (HAP) Tower14

2850 W. Grand Blvd, Detroit, Michigan 48202
(313) 872-8100



Programmer/Analyst September 1999 – May 2009

Application Development & Support (Financial Management Team)

Responsibilities:
* Involved in design and implementation of the database and GUI, Developed various Forms with Triggers, Alerts, Multiple Canvases, Multiple windows, LOV’s and list items using Forms 4.5, Reports2.5 and Graphics2.5
* Developed custom reports from GL and AR modules using Reports 2.5.
* Planned and designed Flexfields structures, segments and value sets according to user requirements imported data from legacy and feeder systems to Oracle Financials using PL/SQL and SQL Loader.
* Implemented budgetary controls using budget journals data imported from feeder systems.
* Developed concurrent programs using PL/SQL. Registered concurrent programs in AOL.
* Developed interface programs using PL/SQL and SQL Loader.
* Developed concurrent programs using PL/SQL and Shell Scripts these were implemented in AOL.
* Written SQL Loader scripts for the Legacy Data Import. Also Journal Entry Interface through SQL Loader.
* Involved in the System Study, Analysis and collection of information from various user.

* Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Plus and PL/SQL.
* As a part of a team, successfully completed the design, development and implementation of the system.
* Developed control files for SQL Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system.
* Discussed with end user Regarding Master item Details in Inventory.
* Knowledge in new form design and development.
* Designed a custom Application Program Interface (API) to import service requests into Oracle Applications based on events/problems that occur in a HP Open View monitoring system (PL/SQL).
* Imported Regular, Debit memo, Credit memo invoices from legacy system to Oracle Receivables tables using CTL file and Auto Invoice import program.
* Implemented in Purchasing involves accepting purchase requisitions, conversion of completed purchase requisitions to purchase orders. A hierarchy level is maintained in approval process, provided security level access to employees.
* Experience in Implementation of Oracle Financial Modules and Application Tables.
* Experience in using and supporting Web Application Desktop Interpreter (ADI) for front end to perform General Ledger full cycle accounting.
* Experience in Archiving and Purging of Financial Application data.
* Extensive Experience in Designing and Developing of Interface/Conversion Programs using PL/SQL.
* Possesses strong knowledge of the Oracle Open Interface tables. Held positions where major responsibilities included coding, interfaces, conversions, reports, enhancement programs and testing in an Oracle Applications environment.
* Good Functional experience in requirement analysis, design, development, testing and implementation of various Oracle Application Modules with a profound knowledge of AIM methodology.
* Established expertise using Oracle Software for applications design, development in a single and Multi-org, Multi-Currency environments. Upgraded applications from 11.0.3 to Release 11i and participated in all aspects of software development Life Cycle and Production troubleshooting, Software testing etc.
* Technical (developer.) activities: Interacting with users, identifying functional and technical gaps, designing custom solutions, programming, scheduling, documentations, and providing production support.
* Functional responsibilities: Requirements gathering, Functional gap analysis, Application design, Configuration, Module setup, Test script generation, Writing training guides, Training end users, and Production support.
* Extensive experience of programming languages, and relational database systems, including SQL query development.


Health Alliance Plan - (HAP) Corporate Office
Data Coordinator/Data Analyst November 1998 – September 1999
Quality Management Team

* With the guidance of the Project Coordinator input measures set by National Committee of Quality Assurance (NCQA), Healthcare Effectiveness Data and Information Set (HEDIS).
* Documented changes set by NCQA and HEDIS so that health care nurse who conduct on-site inspections of accredited doctors and their offices are in compliance with HEDIS and NCQA measures.
* Special projects consisted of developing a database with Microsoft Access with input screen so that executive secretary can input, monitor, and generate reports for the measures documented for executive staff during healthcare meetings.


Health Alliance Plan - (HAP) Corporate Office
Data Processor Operator 1 August 1997 - November 1998
Computer Operations (Network Operations)

* Responsibility consisted of monitoring several server activities on multiple computer screens; report any abnormal activities which may occur to on-call I.T. personnel responsible for that system activity;
* At designated times spawn/execute JCL code or store programs so that batch sets can be processed and generated for claims, new or updated membership ID cards, monthly billing invoices, billing letters and other special requests to load robotic 9 tapes and cassette drives that pull archived or stored data information for the continuation of batch processing.
* System used: Bull 9000 with dual processors, Oracle 7.3, Sun Solaris, UNIX, GEOAccess, NetWare, FileNet and other database systems or servers as directed.


GM National Benefit Center - MetLife
30300 Telegraph Rd., Southfield, MI. 48086
1-800-828-9236

TDM - Data entry clerk October 1996 - August 1997
Disability Claims

* With the supervision of supervisory nursing staff (Case Managers), input Ford, GM, Chrysler hourly and salary disability employee claims into the PARADOX for windows application.
* Input medical claims into Paradox database system
* Log on EDS database system at designated time to perform such duties as locate medical records for select employees to update disability claims, pull claims for Case Managers using the EDS database system, compute GM National Benefit salary for disability employee’s, as well as fax reports for Extended Disability records.
* Special Project: Created master document generated with Visual Basic as a GUI screen which used Microsoft Access database as a hub for retrieving medical and a personnel department contact records. SQL was used as a source for pulling the data. (Olsten Staffing)


Digitron Packaging Corporation
12350 Sears Dr, Livonia, Mi 48150
734-422-1212

Administrative Assistant August 1996 - October 1996
Plant Operations Chief and Plant Manager

* Responsibly was to conducted a visual and physical on site inventory of all parts and supplies received by Ford Motor Co. and Nissan Corp to be shipped to distributors or manufacture dealerships;
* Document counts, adjust count tabs on location for parts, retrieved documentation and information related to shipping and receiving and input adjusted counts using the Ford Motor Co. UNIX Mainframe for reporting purposes.
* Extra duties include conduct data entry for the Plant Manager then researched computer data by using multiple screens using the AS-400 system for company reports. (Olsten Staffing)


International Specialty Tube
260 S. Crawford, Detroit, Michigan, 48209-3068
313- 923-2015/(313) 297-6738



Annealer Operator/Quality Control Inspector November 1993 - February 1995

* Tester: Catch 20 foot tubing from High-Frequency (HF) cutting mill and test weld for deficiencies such as a “bur” which is a rough weld cut left by the excess steal on the tubing weld join.
* High frequency Annealing Systems: Adjust electric frequency, change coil box, input of codes for tube gage, size, and length print, change guide rolls for tubes so that the anneal system can properly heat tubing so that it can be fashioned and shaped by manufactures for special use. The database systems used on the annealing system was for printing, setting voltage of the different gages of metal used for the automotive industry.

* Quality Control Inspector: Inspection of the TIG Mill, HF Mill, Haven Machine, Annealed system, Brim Cut Mill, as well as on location inspections of Materials prior to shipment. (Man Power Staffing)




United States Marine Corps

Headquarters Marine Corps, 2 Annex, Washington, DC 20380-1774
703-695-6192

Military Occupation Specialty: 3051 June 1982 – March 1992
Warehouse Clerk

* Warehouse Clerk – conducted supply counts, stocked supplies within unit warehouse, packed and stored needed equipment for shipment to deployed units either overseas or within the United States when training operations are conducted and returned supplies to proper location within warehouse with units returned to base. Supply logistics to command units as needed.
* Quality Control clerk – conducted inspections of shelf locations for accurate counts, nomenclature, serial numbers or part numbers, pre-shipment counts requested by other units which may not have on-hand amount available, matching documentation receipts with invoices and part request, report any discrepancies that may have occurred when shipment is received or before shipment.
* Preservation, Packaging, and Packing (P,P&P) - Prepare all equipment and supplies for shipment and storage, for fixed, high output, and materiel preservation. Created and assembled wood box for F16 Fighter Jets drop tanks, used shop heavy, commercial, floor-mounted machinery. Unit is manned by a cadre of experienced civilians and the normal influx of school-trained Marines.

* Marine Corps Security Force Supervisor – Supervised thirty Marine security members, posted security Marines to locations ordered by the Commanding Officer of the Marine Security Force or by order of the Commandant of the Marine Corps that maybe detrimental to United States national security or its allies.




LANGUAGES


Speak fluent Tagalog and some Japanese


Education




New Horizon Learning Center - Project Management Techniques (2 day course)

Health Alliance Plan Tower 14, Southfield, Michigan 48075 2006

Oracle University (Three day Course) 2005
Troy, Michigan - Oracle9i Forms and Reports Developer: Build Internet Applications

Wayne County Community College – Downtown Detroit District 1995 – 1997
Detroit, Michigan
(Two year study in Computer Information Systems)

Business Management, City Colleges of Chicago, Chicago, Illinois 1990 - 1992
(Two Year Study Certificate) - NAS, Bermuda, W.I.

Business Administration, Central Texas College, Killeen, Texas 1986 – 1988
(Two Year Study Certificate) – MCAS, Iwakuni, Japan

General Studies Courses, Coastal Carolina Community College 1984 - 1985
Jacksonville, North Carolina
(One Year Study Certificate) – Camp Lejune, N.C.

Courses in Management, Los Angeles Metro College 1983 - 1984
Los Angeles, California
(One Year Study Certificate) – Camp Kinser, 3rd FSSG, Supply Co. Supply Bn, Okinawa, Japan









Company Base and Self Study Courses






CCC Harvest Training


Health Alliance Plan - Tower-14, Southfield, Michigan 48075




Project Management Techniques

Health Alliance Plan Tower 14, Southfield, Michigan 48075



Computer Base Training (CBT)


Health Alliance Plan - Tower-14, Southfield, Michigan 48075

Unix Fundamentals, Unix Intermediate Topics, Unix Shell Programming, Oracle PL/SQL Basics, Oracle SQL and SQL Plus: Basic Select Statements, Oracle and SQL Plus: Advance Select Statemnets, Oracle SQL: Data Retrieval Techniques, Oracle SQL and SQLPlus and Reporting, Oracle Applications: System Administration, Oracle Cash Management: Reconciliation and Forecasting.





EDS/COe Training

Introductory techniques Using COe 3.0 LAN, Lotus Notes Mail, Network systems, and File Manager systems.
GM National Benefit Center - Southfield, MI.

Micrometer Information Training and Quality Control Techniques
International Specialty Tube Corporation, Detroit, Michigan

Tele-Marketing Training Course
Allnet Communications, Bingham Farms, Michigan


Other technical knowledge:
Time & Labor, Material Resource Planning (MRP), Master Resource Planning (MRPII), Reports, Interface, Conversions, and Extensions (RICE).

Oracle8 Installation, PL/SQL and SQL*PLUS, Oracle Forms - Oracle Reports, Oracle Data
Warehousing, Developer 2000, Oracle Financials Applications, JAVA 2 JDK 5, Flash XML Applications, Agile Development, Business Intelligence.

Eight Courses away from B.A. in Computer Science and Technology – Currently have 92 semester credits.



References Available Upon Request

Print Ad