Developer Oracle

SANDY SKRBINA

***** **** ******, ***. *** Cellular: 313-***-****

South Lyon, Michigan 48178 Email: ************@*****.***

CAREER SUMMARY

A Systems Designer/Developer professional with over 20 years of experience utilizing industry leading client/server software and database technology. Expert skills in application development and troubleshooting IT projects for continuous process improvement. Technical problems resolved at local, national, and international locations. Ability to acquire new knowledge and skills quickly who also contributes as a dedicated team player.

EDUCATION / TRAINING

Global Information Technology - Lathrup Village, MI. – Oracle DBA Workshop I and II completed March 07, 2012.

Global Information Technology - Lathrup Village, MI. - Java Professional program completed May 16, 2010.

Perl Programming – Troy, MI. - Sun Microsystems instructor led training.

Migrating to Object Oriented technology with Java Programming – Livonia, MI. - New Horizons instructor led training.

Oracle Financial Application Technical Foundation – Orlando, FL. - Oracle Corporation instructor led training.

Oracle Financial Application Boot camp – Redwood Shores, CA. - Oracle Corporation instructor led training.

Ferris State University – Big Rapids, MI. – Bachelor of Science in Computer Information Systems.

CAREER HISTORY

ALLIANCE INSPECTION MANAGEMENT (AiM) – Farmington Hills, MI December 2015 – March 2017

IT Developer – Database Developer

Industry: Automotive

Environment: Oracle RDBMS11i, SQL Developer v4, SQL Server Management Studio 2008, Android Samsung Galaxy S6 active,

SVN version control, Jira Ticketing Dashboard, Agile Methodology

Resolve claims processing errors such as output statement failure and space padded fields needing trim function. Develop application to remove inspection related data based on control table parameters. Develop cross reference tables for Toyota processing that allows the mapping of damage types, areas, and severities between vendors. Resolve inspection request date issue for multiple transactions against the same vin. Authenticate user login to the AiM Schedule Android application by detecting invalid user, null user, and null password entries. Provide context sensitive error messages for an invalid login attempt. Coordinate tasks with BA and QA team members to deploy Jira tickets from development through production instances.

HALOGROUP – Novi, MI March 2014 – December 2015

IT Consultant – Database Developer / Web Developer

Industry: Utilities – DTE Energy

Environment: Oracle RDBMS11i, Toad v9, Forms v6, Pro*C, Clearcase v7, XML and SOAPUI, Agile Methodology

Develop and test utility program enroll and un-enroll xml format output for specific utility services. Maintain legacy Customer Service and Billing application through Forms, Pro*C and pl/sql programming changes. Participate in poker, scrum and design slam meetings for Agile Methodology. Production ticket resolution completed with firekey access by maintaining phone number, email, SSN, and meter read data.

MODIS – Southfield, MI May 2013 – January 2014

IT Consultant – Senior Database Developer and Web Developer

Industry: Manufacturing – Volkswagen Group of America

Environment: Oracle RDBMS 11i, Toad v12, Windows xp, Eclipse Helios and Websphere application server,

HP Service Manager, WinMerge, NotePad++, Dynatrace v4, RumAlerts

Coordinate and process 31 step monthly Market Based Order cycle for six carlines. Work entailed downloading excel spreadsheets into Oracle tables and running verification scripts to ensure accuracy. Web and database server monitoring was conducted during heavy use with Dynatrace and RumAlert tools. Non cycle activity included incidence tracking/resolution through database and web development projects. Modify the Order Generator application to allow 2014 car models to display in the market area configuration panel by modifying xml, jsp, and java files.

MINACS MARKETING SOLUTIONS, INC. – Farmington Hills, MI January 2013 – May 2013

4 GL Developer

Industry: Advertising and Marketing

Environment: Oracle RDBMS 11i, Windows 8, Linux

Tools: Toad v11, Appworx scheduler v6, Remedy Ticketing System

Analysis of functional and technical requirements for Mazda wholesale and retail customer invoice processing. Report on customer comparisons, invoice suppression/rejection, invoice listing for responder customers to recent mailings. Analysis of appworx job chains for weekly and monthly invoice processing.

TEKSYSTEMS, INC. - Southfield, MI May 2012 - December 2012

IT Consultant - Database Developer and Web Developer

Industry: Manufacturing - Cooper Tire and Rubber Company

Environment: Oracle RDBMS 11i, Windows xp, Linux, Internet Explorer v8, Firefox V15

Tools: PL/SQL, TOAD v10, Encore custom application, SAP Netweaver Developer Studio v7

Develop and test pl/sql packages for aps remediation by editing and loading flat file data into an Oracle database.

Add columns and functionality to an existing view that will provide inventory, forecasting, and order summarization data.

Resolve low level defects for the B2B web portal project by making cosmetic changes to jsp, css, and java files. Add day functionality to the jquery datepicker plugin. Differenciate between IE and firefox processing requirements by looking at system variables and processing accordingly. Support the custom legacy Encore application for the user community by updating order data, resubmitting procedures when necessary, maintain user level security, provide ad-hoc query results.

TEKSYSTEMS, INC. – Southfield, Michigan June 2011 – May 2012

IT Consultant - Database Developer

Industry: Manufacturing – General Motors, OnStar Division

Environment: Oracle RDBMS 11G, Windows 7, Linux

Tools: TOAD v8, SQL, Cron job scheduler, shell scripting

Document and maintain the vehicle communication system’s performance metrics through the weekly distributed Flash Report.

Add new hardware types to the report and assist end users in analysis of metric numbers through ad hoc queries. Ensure Flash Report jobs complete successfully by verifying temporary tables used to load mater table. Provide data recovery when necessary by re-running sql scripts. Modify shell scripts by enhancing email subject lines, omitting email attachments where necessary, and streamlining shell script execution for the tweener application.

TEKSYSTEMS, INC. - Dublin, Ohio June 2010 – June, 2011

IT Consultant - Database Developer & Java Programmer

Industry: Banking - JPMorganChase & Company

Environment: Oracle RDBMS 10G, Windows XP, RAD v7 with Websphere Application Server v6

Tools: TOAD v10, Crystal Reports v10, PL/SQL, Java Programming, JavaScript Programming, HTML web development

Oracle database development and unit test of a financial product and service code search facility. Users allowed to search, display, and add products and services to a financial Deal on a proforma basis. Maintain financial analysis reports based on proforma products and services through database pl/sql packages and Crystal Reports.

Java maintenance on a dataload application - new database columns added to getter and setter methods of the Java Bean class and additional validation statements added to the Java Class files. Intranet Deal maintenance - numerous JSP files analyzed to locate the source of front end fields. Database functions and procedures modified and tested for defect resolution. Proforma table maintenance developed and tested as a web based application with the use of Java class files, JavaScript, servlet, and HTML pages.

GLOBAL INFORMATION TECHNLOGY – Lathrup Village, Michigan January 2010 – May 2010

IT Consultant – Student

Industry: Education

Environment: Windows XP Professional, JEE architecture

Tools: Eclipse Java EE IDE for Web Development, MySQL Query Browser v1, Apache Tomcat servlet/jsp container

IT course application design completed with UML diagramming techniques. Course query and maintenance application developed with Java scripts that accept screen and flat file transactions against the RDMS database. Single and multiple books displayed through the use of servlet/jsp/bean web architecture. HTML pages developed and deployed to display generic tag objects and print types.

STRATEGIC BUSINESS PARTNERS – Troy, Michigan December 2009 – April 2010

IT Consultant – Systems Designer/Developer

Industry: County Government – Wayne County Airport Authority

Environment: MS SQL Server 2000, SQL Enterprise Manager v8

Tools: MS Access 97, ProLaw v9, Hummingbird DM v5

Analyzed ProLaw legacy document management application and assisted with data mapping issues to the DM document management application. Developed and tested sql statements to extract legacy data and create meta data flat file. Utilized the Import utility to import profile and documents to the DM application. Began verification process once the documents were converted to the new system.

COMPUWARE CORPORATION - Detroit, Michigan January 2007 – September 2009

IT Consultant - Systems Designer/Developer

Industry: State Government – State of Michigan

Environment: MS Windows XP, Oracle RDBMS 10g

Tools: Oracle Forms 6.0, MS SharePoint Services, Snagit Screen capture utility, TOAD, MS Office

Maintained and enhanced the Michigan Child Support Enforcement System customized Oracle application. Migrated the flow of development tasks from the functional design document to technical design document and unit test document. Created unit test result scenarios with Snagit screen shots. Conducted peer review of developer’s documents and provided feedback on all three document types. Tracked tasks within the Office Project application, uploaded documents to SharePoint for final sign-off, and locate current database objects on the Repository Object Navigator.

Industry: Manufacturing – Haworth Incorporated

Environment: MS Windows XP, Oracle RDBMS 11i, UNIX HP

Tools: PL/SQL Developer, Remedy Action Request System, FTP, Oracle Reports 6.0

Developed a purchasing system extract and flat file creation program eliminating a manual spreadsheet application. Mapped Oracle to SAP data fields and delivered data extract process to the SAP Business Analyst. Resolved Help desk tickets through dynamic SQL queries and DML statements applied to financial modules of Oracle database (AR, AP, INV). Analyzed Oracle Forms and Reports objects for end user queries. Applied Vertex AR sales tax updates monthly. Improved report execution time by using Oracle MetaLink documentation to tune Oracle Report objects with an index hint for an access path solution.

Industry: IT Services – Corporate Staff

Environment: MS Windows Internet Explorer 7

Tools: RedDot 6.0 Content Management System

Developed and modified Compuware intranet web site pages for the J2EE Special Interest Group (SIG). The site covers Java related knowledge-sharing topics such as Presentation, Server Side Technology, SOA, Certifications and Application Servers. Developed a new web page to cover internal and external certification programs. Enhanced current pages to provide ease of site navigation links and to comply with corporate standards for link creation.

Industry: Health Care – St. John Health

Environment: MS Windows XP, Oracle RDBMS 10g

Tools: PL/SQL, MS Visio, Business Objects, TOAD

Reengineered merging script code and functionality together and re-tested all dynamic SQL statements generated for debugging. Diagramed MS Visio Flowchart of two PL/SQL scripts merged together as a documentation deliverable. Integrated history processing functionality into the error handling functionality that merged two scripts into one script producing a consistent level of maintainability and the elimination of duplicate code. Accomplished all scripting work through the TOAD toolkit. Completed script testing by creating and running Business Objects reports to display before and after record contents.

PULTE HOMES, INC. - Bloomfield Hills, Michigan February 2006 – November 2006

Systems Engineer II

Environment: MS Windows XP, Oracle RDBMS 9i, IBM AIX UNIX

Tools: Perl, Lawson Financials, 4D Methodology, Micro Focus COBOL

Generated Oracle Procedures to populate audit tables with row count, hash totals, primary key, and constraint statistics. Used table data for multiple schema comparisons. Gathered user requirements from 4D methodology and verbal clarifications to enhance Lawson’s Statistical Journal Entry Report. Incorporated report changes that accommodated system date display when it ran with specified parameters. Teamed with members of the Enterprise Application Integration project to analyze and modify Perl scripts assuring delivery of files to message broker technology.

FEDERAL-MOGUL CORPORATION - Southfield, Michigan April 2002 – February 2006

Systems Programmer / Analyst

Environment: MS Windows XP, Oracle RDBMS 8i, HP UNIX Servers

Tools: Navigator, MS Access, SAP, SQL*Loader, PL/SQL

Streamlined system reengineering points in a monthly flat file load process by design and development of Oracle procedures. This process loaded multiple source data files into the Oracle database schema. Extracted and loaded SAP sales data into a staging table by stepping through the SAP menu system and retrieving records based on sales division start and end dates. Integrated the staging table into the process flow. Compared current with loaded data numerous times due to the volatile nature of sales data. Fulfilled user requests for production data changes and screen/report enhancements through application maintenance of CPS Rebate System. Enabled job run and post operations to be completed on tight periodic timeframes. Teamed with the Oracle DBA for table space allocation, exceed extent issues and data recovery tasks when disc drives failed to read/write data.

TEKSYSTEMS, INC. - Southfield, Michigan September 1999 – March 2002

IT Consultant – Senior Software Engineer

Industry Utilities – G.E. Power Systems

Environment: MS Windows 95, Oracle RDBMS 8i

Tools: Brio Report Builder, SQR, Navigator

Implemented Maximo asset management and maintenance system that included modules for work orders, preventative maintenance, inventory, equipment, purchasing and labor. Customized manufacturing reporting needs not met by standard software.

Industry: Consumer Marketing – Maritz Research, Inc

Environment: MS Windows NT, UNIX with VI editor, Oracle RDBMS 8i, MS SQL Server 2000

Tools: PL/SQL, TOAD

Migrated Customer Viewpoint Reporting System to a MS SQL Server 2000 application by developing PL/SQL modules to upload and download flat files between Oracle tables. Analyzed and tested legacy scripts done in the Enterprise Manager module of MS SQL Server 2000.

Industry: Staffing/Employment Agency – Phoenix Group

Environment: MS Windows 3, Oracle RDBMS 8

Tools: Oracle Forms

Modified Mercedes-Benz and Mazda screens to add check-box enhancement and alter property items per car dealer. Performed SQL tuning on record group to query car VIN.

Industry: Manufacturing – Huron Valley Steel

Environment: MS Windows NT, Oracle RDBMS 8

Tools: Oracle Forms/Reports, TOAD – Quest Software, MS Access 97, MS Visual Source Safe

Migrated MS Access 97 metal processing application to Oracle toolset by normalizing database schema and developing a new menu, forms, and reports for material and movements inventory system. Built primary key and non–unique constraints into the system as needed to support the application front end. Gathered requirements from IT team members and the user community to re-engineer the legacy system. Completed scripting and ad hoc reporting with the TOAD toolkit.

ORACLE CORPORATION - Troy, Michigan September 1997 – August 1999

IT Consultant – Senior Software Engineer

Industry: Software Manufacturer – Oracle Corporation

Environment: MS Windows NT, Oracle RDBMS 8

Tools: PL/SQL, GOES, Web-enabled architecture

Global Oracle Education System (GOES) migration from version 10.7 NCA to 11.0 web-enabled system. Database object documentation with server side patches and post install scripts applied. Compiled forms and libraries on the MS Windows platform and generated them on UNIX apps server release 11.

Industry: Manufacturing – ALCOA

Environment: MS Windows 95, Oracle RDBMS 7, Unix with VI editor

Tools: EDMS, Oracle Financials 10SC, Oracle AIM, ClearCase

Maintained and documented accounts payable, purchasing, and general ledger interfaces through Oracle data migration application (EDMS).

Industry: Manufacturing – Eaton Corporation

Environment: MS Windows 95, Oracle RDBMS 7, Unix with VI editor

Tools: PL/SQL, AP financial module

Team member of a manufacturing plant rollout scheduled to re-couple accounts payable modules between Oracle sites. Documented project plan and afforded technical assistance to list of tasks. PL/SQL modules were created to load flat file data into AP tables and migrate data between data center sites.

CTG - Southfield, Michigan June 1992 – August 1997

IT Consultant – Senior Software Engineer

Industry: Beverage Manufacturing – Stroh Brewery

Environment: MS Windows NT, Oracle RDBMS 7

Tools: Forms, Pro*C, Oracle Inventory Financial Module

Modified Inventory screens to accept a production date in one of five formats (Oracle, Julian, Gregorian, one position year, and first place). Proper error messaging assisted the user with possible corrections when an invalid date was entered. Modified Inventory report to include an additional table column with Pro*C reporting.

Industry: Cereal Manufacturing – Kellogg Company

Environment: MS Windows 95, Oracle RDBMS 6, Unix

Tools: Forms, Pro*COBOL, Powerbuilder, SQR

Maintained and supported customized Cost Management System by assisting user community with data issues, creating new reports, modifying reports/screens per Technical Service Requests.

Industry: Manufacturing – Howmet Corporation

Environment: MS Windows 95, Oracle RDBMS 6

Tools: Forms, Reports, Menu

Developed a 34-menu cost accounting system to allow user community to execute batch jobs, maintain minor entity tables, and print/view data. Documented the menu application with listings of menu-form-report associations.

Industry: Architecture – HOK Architectural December 1992 – May 1993

Environment: MS Windows 3, Oracle RDBMS 6

Tools: Reports, Oracle AR and AP financial modules

Developed customized reports for multiple applications including payroll, project tracking, labor variance, and accounts receivable. Users verified report output and notified development staff of additional requirements.

Industry: Food and Beverage – Big Boy Restaurants, Inc. November 1987 – June 1992

Environment: IBM Mainframe, VAX mid-range computers, Oracle RDBMS 6

Tools: Forms, SQL *Loader, Pro*COBOL, RPGII, General Ledger Financial module

Designed, maintained, and deployed the customized General Ledger application using Pro*Cobol and Forms tools. Developed Forms to accept and edit user input values, plus provide job status. Developed Pro*COBOL reports for financial statement review: Balance Sheet, Trial Balance, Cash Over/Short, Profit/Loss. Converted data during the initial phase from IBM legacy fixed assets to Oracle technology. Maintained the IBM customized payroll application using RPGII.

Contact this candidate