Ann Salazkin

*** *** *****, ********, ** *****

952-***-**** (cell)

acr8bi@r.postjobfree.com

Ann is an innovative and professional Application Developer who has 17+ years of progressive experience with software development, database administration and business analysis experience. She has thorough experience with Oracle related tools and software (SQL, PLSQL, ORACLE Forms, ORACLE Reports, DBA activities, Oracle Express, Perl, Java) and has achieved professional Certification – ORACLE PL/SQL and Programming Units, UNIX shell scripting, Healthcare Informatics.

Skills Summary:

Strong in RDBMS and its related tools: Expertise in Oracle 11i/10G/ 9i/8i, PL/SQL, SQL, Forms 10G/ 6i, Reports 10G/6i, Oracle 9iAS, Oracle 10gAS, Web Forms, Web Reports, XML Publisher, Stored Packages/procedures/ Functions, triggers, SQL*Loader, Explain Plan, Tkprof, Database Backup, Recovery, Performance Tuning, Import and Export.

Other tools: TOAD, SQL*Navigator, WinQVT, OEM, JDeveloper, Microsoft Visual Studio 2010, Serena PVCS, Kintana.

Reporting Tools: Oracle Reports 10G/6i/3.0, SQL*Report Writer 1.1, Version Control: PVCS, Visual Source Safe

Operating System: HP- UNIX, Windows 7/XP/2000/NT, Expertise in writing UNIX shell scripts Korn-Shell.

Programming Language: PL/SQL, Oracle Express, Java, Informix, COBOL, HTML, Visual Basic.

Professional Experience

Emerson

Apr.2014 – Aug.2015

Lead Developer

Emerson is a global technology leader in many markets – Network Power, Process Management, Climate Technologies, Industrial Automation, Commercial and Residential Solutions.

Worked with Order Management, Inventory, Project Accounting Oracle modules, in design and development of the custom solutions utilizing Oracle forms, Oracle reports, XML Publisher, Shell scripting, writing PL/SQL procedures, troubleshooting the issues and working on the application performance.

Design and Development: Drop Ship Note Report, Price Transfer Audit Report, PDSL and RDSL JDI Report, SO PO Linking Report, PO Print Report Notification, Sales Report JDI.

Design and Development: Global URD Form, TP1 User Warehouse Form,

Update Transfer Price Form, Lead Time Form.

Design and Development: Schedule Review Lines JDI concurrent program, PA Cross Charge Update Procedure, functions to support defaulting rules for the Order Entries, Create Sourcing Item Category concurrent program.

Support of the Emerson Global Quotes Form and Global Sales Order Form.

Emerson R & D group design solutions such as process flow revision and workflow modification, new JDI sites implementation etc.

Ovation Brands/Buffets Inc. Jun.1999 – Apr. 2014

Application Developer III

Buffets is one of the largest restaurant companies in the country with about 30 000 employees nationwide.

Worked with a large number of different projects within various Oracle modules including Financial Application, Human Resources, Purchasing, Oracle Workflow, Oracle Time and Labor, Portal, Oracle Alerts and numerous Buffets custom applications such as Store Master Application, WOTC application, Oracle Express Web reporting, inbound and outbound interfaces and custom forms.

Supported the In-house product by developing new/modified Oracle 6i Forms/Reports/Graphics, Reports using Report/Forms Builder using Oracle 9IAS (Application Server) as per user requirements.

Portal AS upgrade project – converted the JServ based applications into J2EE container for the Web Reports Viewer Portal application; fixed the issues with the performance degraded Portal applications due to the upgrade of the Portal Application Server from 3.0.9 to 10.1.4 and dbase from 9i to 10g.

Company merge project – wrote inbound conversion programs to load the merging company GL balances, to interface the sales into Oracle GL and then into Buffets Data Warehouse, completed numerous DW web reports for the sales, labor, food cost, call-in variance etc. analysis.

Upgrade of the Oracle Apps from 11.5.3 to 11.5.10 and dbase from 8i to 9i and from 9i to 11g – update of the custom GL, HR, AP, Workflow applications to run within a new version of the application and dbase and to improve the performance.

Oracle HR implementation – wrote conversion and interface programs to load employees/benefits data into Oracle HR, created and supported different interface programs such as BCBS healthcare benefits interface, CIGNA long term disability interface, ProBusiness (payroll company) master and elements extracts, SPECTERA vision interface and numerous Oracle custom reports such as HR Salary Details extract, Employee Assignments Detail extract, Buffets Employee Tenure report, Employee Benefit Letter, Reliance standard eligibility interface, BHI new employee to Oracle HR and CrunchTime interface, producing the reports using different requested formats such as SYLK reports, PDF reports, web reports.

Oracle General Ledger – wrote custom GL Transaction Audit report, GL Corporate Entries and Adjustments report.

Oracle Payables – created Unposted Invoices report, AP to US Bank EFT Interface, AP Prior Period Restaurant Invoice extract.

Oracle Receivables – developed Direct Bill Invoice interface.

Custom Sales system Implementation – development of the Oracle forms such as Sales Account and Threshold Maintenance screens, Weekly Balance Inquiry screen, Daily GL Sales to DW interface.

Oracle Time and Labor Implementation – customization of the employee timecard layouts to implement a cost center, to alter the standard packages to provide additional messaging for the timecard users, creation of the custom program to populate the elements entries in Oracle HR based on the employee break penalty if applied, customization of the missing timecard report.

Data Warehousing – created variety of Web reports based on Oracle Express data – Demographic Marketing Areas (DMA) weekly sales report, Summary of Operating Results reports (Period to Date, QTD, YTD), Food Cost reports, Weekly Flash reports, Guest Count Forecasting project including the loading of the forecasting data cube in DW and a Forecast report, Restaurant Income Statement reports, Restaurant Operating Profit Summary/Details reports, Scheduled Labor Hours report, creation of different interfaces from the outside systems into DW such as Sales data to DW, Daily/Weekly Labor data to DW, Food Cost Call-In data to DW, Weekly Ending Inventory to DW, writing numerous rollup programs to aggregate data within the associated hierarchies; interfacing of the DW Sales and Guest Counts daily data to the outside vendors (Market Force) for further marketing analysis

Oracle Purchase Order implementation – customization of the PO Account Generator for project and non-project related requisitions, customization of the workflow email notification per PO/Requisition approval.

Development and client tools upgrade – Oracle Report/Forms builder upgrades, recompilation of the custom code, installation of the libraries needed.

Wrote PLSQL, SQL code along with restructuring SQL to improve query responses (SQL Tuning).

Involved with the conversion/upgrade/regeneration of application modules from lower versions to higher ones.

Extracted, transformed and loaded data between different systems.

Wrote several interfaces between different systems using database triggers, Procedures, Functions, Packages, Oracle Reports.

Successfully implemented the purging data process from the Oracle Backfeed tables. Saved company tons of money and increased system performance and decreased total used disk space.

Developed and implemented alert mechanism to notify users when certain events happen in HR, Marketing, Daily Sales Statistics.

Regularly participated in implementation team by defining business requirements and writing technical design documents. Researched new technologies and made product development recommendations.

Shell scripting - automated files transfer processing for different vendors (credit cards processing, gift cards transfer, cash paid out data files etc.), data files encryption/decryption processing, DTS Execute utility for the concurrent manager to schedule the DTS to run on SQL server, process driver scripts for the interfacing etc.

CrunchTime Food and Labor implementation - design and development of the interfaces: CT Sales to Oracle GL; CT Sales to ReconNet Cash Management system; Oracle Express GC Forecast to CrunchTime; Corporate GL Entries and Adjustments to CT; Panasonic POS Sales to Oracle GL and CT; Inventory Conversion Programs, CT Recipe extract, Weekly Charges interface to CT

Oracle Property Management - development of the Oracle stored procedures to create SYLK formatted reports such as Lease Milestone Extract, Property Overview Extract etc.

Oracle Inventory implementation - Inventory to Projects Move Order customization; design and development of the custom Inventory Item Lookup Form that includes item master information and a custom view of on-hand quantities while also providing drilldowns to the item cost, cost history and quantity details.

Secure Files transfer automation using Expect scripting

Writing custom reports to provide discrete jobs specifically formatted labor and component information from Oracle Inventory (Bill of Materials, Work in Progress)

Oracle forms Personalization – Discrete Jobs, Submit Request forms

Systematically reviewing/creating technical designs for the development team

Express Scripts/ValueRX Nov. 1997 – Jun. 1999

Programmer

Express Scripts - pharmaceutical benefits company, Plymouth, MN

Responsible for development and maintenance of Client/Server applications utilizing SQL and Informix in a UNIX and NT environment.

Worked on C utilities used for Barcode printing and scanning.

Development in Informix 4GL, UNIX shell scripting to automate production batch monitoring processes.

Development for a variety of internal and external user requests. Modules - benefits eligibility, reporting, claims processing.

State Pedagogical University Sep. 1990 – Jun.1996

Samara, Russia

Instructor, Department of Geometry

Mathematical problem solving courses.

High School #75 Aug. 1982 – Dec. 1989

Samara, Russia

Math Instructor

Education:

Russia, Samara State University

B.S. Mathematics/Physics, Minor Computer Science

4.0 Grade Point Average.

Awards for Academic Excellence

Certificates of Completion:

SQLSchool.com (SSIS, SSAS, SSRS)

Oracle 12 New Features (Financials), Eagan, MN

Hands On Technology Transfer, Inc, Schaumburg, IL; Java Programming

The College of St.Scholastica Duluth, MN; Healthcare Informatics

Oracle University, Bloomington, MN; PL/SQL, Program Units, Oracle Reports

Oracle University, Chicago, IL; Oracle Forms I, II; Build Portals and Portlets

ValueRx University, Plymouth, MN; Informix 4GL, dBase

Euler Solutions, Mpls MN; UNIX OS, UNIX Shell Scripting

Brown Institute, Mpls, MN; Computer Programming

Academy of Business, Russia; Management, Translation

Contact this candidate