Sql Server Sales

MICHAEL MILLER

**** ***** **.

Reading, PA *****

Home: 610-***-**** ● Cell: 484-***-**** ● Email: *********@*******.***

__________________________________________________________________

EXPERTISE: SOFTWARE DEVELOPER

Dynamic career designing user interfaces in the manufacturing and consulting industries.

Apply creativity and structural integrity to solve diverse application issues. Excel in team

collaboration and innovative solutions. Strong sense of aesthetics and attention to detail.

Seeking a position in which I can utilize my technical skills in combination with team

leadership abilities. Interested in potential for promotion to supervisory role.

PROFESSIONAL EXPERIENCE

1999 – Present Alcon Research, LTD – Sinking Spring, PA

I.T. SPECIALIST

• Budget / Payroll system for Finance Department:

Employee Salary Header/Detail Entry/Maintenance,

Overhead Analysis Report, Sales Tax Analysis,

Expense Items, Promotion Matrix. Interface this

custom network of programs to the General Ledger.

Business Unit, Object Account, Sub Account.

eWork Order System: subfile Selection of Work Orders, ability to attach alternate Bills of Material and

Routings, Work Order print, use of Trigger Files to capture changes to header and detail information, inventory

and labor transaction processing and inquiries.

Materials Planning: wrote scripts for use on shop floor – CK30 wanding devices generate Material Issue and

Return to Stock transactions. Wrote custom subfile inquiry programs to display and select transactions for

further processing.

Auto Allocation – wrote a system to capture inventory distribution data for Alcon satellites (termed Global

Inventory Repository System) and also to calculate the quantities needed to correctly allocate inventory for

future demand, automatically. This was a major project for the Materials Dept and freed up a lot of time

because it replaced a manual process.

Created Production Requirements data (termed Demand Plan Accuracy) to supply the buyer/planners with up to

the minute information. This was a complex calculation which involved inventory projections and past history

combined.

Auto Attendance – Alcon used a system called DSI to receive attendance and labor transactions generated by

scripts / wanding devices, present data to supervisors who approved said time and labor, and upload the results

to JD Edwards files, ultimately to the GL. When Alcon replaced the attendance process on these wanding

devices (Maxilans) with new time clocks, I had to create an interface which would still create the time and

attendance transactions, based solely on the employee’s labor transactions. This was an extremely complicated

series of programs, and has been in production for a year.

Advance Ship Notice: create formatted transactions and prepare for transmission to vendors, as well as subfile

inquiry and processing programs for this data.

Labor Productivity / Bonus report – written for the Controller, as a tool to measure employee productivity and

calculate bonuses over summer when additional workers were usually hired.

Shop Floor History inquiries / maintenance, and reporting

Shipping Department: Material Issue requests and label generation for miscellaneous items used as sidelines in

making product. Used also to correct errors (discrepancies) between physical and online inventory through

greater control / approval.

Finance: Cost Type breakdown and analysis, inquiry and reporting

JD Edwards system programming and development (RPG) for numerous ad hoc requests

Script programming using DSI Tranbuilder / Trancollector

Microsoft Visual Studio report development (IT metrics) – used by IT Manager to present data to upper

management about service provided by Help Desk

Technical Documentation: program specifications; protocols; test data sheets; requirements matrix; IQ-OQ-PQ;

IT Procedures; Business Procedures

Extensive involvement with WORD formatting

SQL Server programming, light database administration. Wrote Stored Procedures, created Tables, Queries,

linked to Excel Spreadsheets

Help Desk for one year dealing with hardware and software issues facility wide

Classes in PC hardware and light client server involvement

Web page design: Front Page 98. Other packages: Showcase (Query tool), Cognos

1993 – 1999 Computer Aid, Inc – Allentown, PA

CONSULTANT

• Shop Floor Data Entry, Labeling, EDI, Invoicing,

Advance Ship Notice

Y2K COBOL and RPG conversions

Shop Floor Data Collection and Reporting at Heyco Metals

Demonstration of new software; working often with individuals – customer interaction

Berks Products: Quote Entry, Invoicing, Accts Payable and Receivable modules

Account Aging reports

Programs to create Billing Invoices

1992 – 1993 Vanity Fair – West Reading, PA

SR. PROGRAMMER ANALYST

• Programming COBOL in retail sales industry

1986 – 1992 Computer Aid, Morgan Corporation, Woodstream Corporation

• Software Demonstrations, S/36, S/38, and AS/400 RPG

programming/analysis

EDUCATION Certificate, Information Computer Systems Institute – Allentown, PA, 1985

RPG, COBOL, Operations on S/36 – immediate employment as lab instructor

• Additional certification in Plantmetrics, Showcase, JD

Edwards, Core Hardware, Front Page, SQL Server

Programming and database Concepts

DISCIPLINES RPG, Script, SQL Server, HTML, Visual Studio, COBOL, AS/400 Operations,

Utilities

Contact this candidate