Tatsiana Sulkovskaya                                                                      

OBJECTIVE

Seeking a position with a progressive organization where I can use my technical and functional knowledge to enhance and simplify day to day business operations by utilizing information technology

Education

Rutgers University, School of Business

·     Masters of Business Administration – December 2011

Dual Concentration: Global Ecommerce and Management

Rutgers University, College of Arts and Sciences

·     B.S., Computer Science – May 2006

CERTIFICATIONS/TRAINING

PMP Certified by American Management Association (AMA)

Advanced PL/SQL Training by Learning Tree Inc.

Technical Skills

Oracle Standard Processes

ERP Oracle Application Modules

Frameworks

Other Tools

Experience

Oracle EBS Techno Functional Consultant

November 2012 – June 2015

Soda Stream Inc., Mt Laurel NJ

Day to day responsibilities:

·     Serve as a techno-functional lead responsible for requirement gathering and suggesting technical solutions

·     Extend EBS standard and custom functionality using custom and standard APIs, Alerts, Business Events and Oracle Form Personalization

·     Extend seeded workflows and develop new workflows

·     Work with offshore development team to develop and test technical solutions

·     Evaluate and improve business processes

·     Perform production set ups (profiles, transaction types, subinventories, organizations, account aliases , item categories, KFFs, DFFs, BOMs, Oracle Advanced pricing qualifiers and modifiers)

·     Support day-to-day production environment (Oracle supply chain modules and Oracle Financial Modules)

·     Support and improve integration between Oracle and WMS systems (Pick releasing orders to warehouses, receiving and processing ship confirmation files and shipping data from warehouses, receiving and processing inventory adjustments files from warehouses)

·     Set up and configure new inventory organizations (set up new locations, set up new responsibilities, set up organization user, set up shipping network, create organization customer, create subinventories and locators, create account aliases, assign items to new organization, define shipping methods, define organization costing, define carrier shipping methods, create pick release rules, define shipping parameters, set up default sub-inventory for returns utilizing defaulting rules)

Project Work:

·     Served as a Technical Lead in Mercury Gate Transportation Management system implementation

System Analysis:  Performed systems analysis and assisted in business requirements and business rules definition. Documented business requirements (MD050).

System Design:  Designed process flow diagrams based on business rules and requirements.

Development:  Designed and developed new table structures, indexes, views, packages, triggers, objects, records and reports to implement system design.

Created automated TOAD script to execute various actions (verifying existence of files in a particular directory, executing the call to PL/SQL package, extracting XML files as CLOBs from the data base, naming the files and placing files on a local server, Ftp’ing the files to Mercury Gate, archiving the files).

Documented technical design (MD070) of the process including functionality of each object and how and where it fits within the process. Designed code roadmap.

Integration and Testing:  Installed and tested all objects to ensure intended functionality and expected performance. Tested and verified interoperability between Oracle and Mercury Gate.

Documented integration testing (TE040).

Created and executed unit test script (TE020).

Installation and Deployment:  Installed all appropriate objects in production environment and scheduled the process.

Modules Used in the project: Order Management (OM), Inventory (INV)

Oracle Application Version: 11.5.10.2

Database Version: 11g

·     Designed and developed automated discrete jobs custom process

This automated process takes manually created discrete job and after performing various validations pick releases the components required to build the requested item. XML file is generated and Ftp’d to one of the 3PLs. The processes receives and processes discrete  job updates and appropriately updates quantities of items that have been build and have gone through discrete manufacturing process

Modules Used in the project: Work in Process (WIP), Bill of Materials (BOM), Inventory (INV)

Oracle Application Version: 11.5.10.2

Database Version: 11g

·     Developed retest cylinder process

This process moves cylinders that have been shipped to Israel for retesting to a retest sub-inventory. During the move, the retest cylinder item is split into its components. Upon receipt of test cylinders back from Israel, a business event is triggered that scraps certain components and moves the other components into appropriate sub-inventory. An automated email is generated to notify Department of Finance of the quantity and items scrapped

Modules Used in the project: Inventory (INV), Order Management (OM), Purchasing (PO)

Oracle Application Version: 11.5.10.2

Database Version: 11g

·     Perform various Work Flow customizations and updates of order processing to support business order flow utilizing Workflow Builder (Order minimum amount validation, Price doesn’t match price list validation)

·     Performed set ups of Employees, Jobs, Positions, Positional hierarchies, Approval Groups and Approval Assignments

·     Set up and tested drop ship process for international orders (US to Mexico) and for orders originating from Israel to US retailers. Process and testing included:

è  Items definition changes, Sourcing Rules creation, Sales Order Creation, Requisition Import, Purchase Order creation via Auto Create, Purchase Order approval, Inventory Receipt into virtual inventory organization, Auto Invoice

·     Developed  financial and logistics reports utilizing BI (XML) Publisher and Discoverer Reports

·     Personalized variety of Oracle Forms (Order Header Form, Order Lines Form, Discrete Jobs Form)

·     Set up variety of modifiers and qualifiers in Oracle’s Advance Pricing module to support product specials and customer contractual discounts

·     Performed set up and testing of new inventory organizations

·     Assisted Finance and Logistics departments during month end close

Senior Techno-Functional Lead

December 2010 – November 2012

University of Pennsylvania, Philadelphia PA

Day to day responsibilities:

·     Work with stake holders and business users to gather detailed requirements

·     Interact with all levels of Oracle Financial E-Business Suite client base to resolve issues and develop innovative solutions

·     Support Oracle Financial Application suite (GL, AP, FA, PO and IP)

·     Perform set up and testing of new GL feeders

·     Design and develop functional specifications and suggest technical solutions

·     Work on tuning queries for better performance

·     Interact with Oracle support via Oracle Support as needed

Project Work:

     R12 Upgrade

·     Prepared detailed test plans for R12 upgrade

·     Performed system set up for BNE module in R12 – BNE Module

·     Created custom WEB ADI Integrators utilizing Desktop Integration Framework (DIF) in R12 – BNE Module

·     Created components, parameters, style sheets for WEB ADI utilizing R12 Web ADI Wizard – BNE Module

·     Developed automated processes to perform supplier and supplier site cleanup in R12 (TCA – Trading Community Architecture) – PO Module

·     Performed pre-upgrade bank, bank account and bank account uses clean up – AP module

·     Performed pre-upgrade employee cleanup (terminations and updates) – HR module

·     Customized oracle seeded report, Account Analysis Report for the Fixed Assets module to include extra information such as fixed asset number, purchase order number, invoice number and invoice amount – FA module

Modules Used in the project: Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Fixed Assets (FA)

Oracle Application Version: 11.5.10.2 to 12.2

Database Version: 11g

     Concur SAS Implementation

·     Served as a technical lead during implementation of Concur SAS solution

·     Gathered business requirements from the user community

·     Documented requirements utilizing oracle AIM methodology

·     Converted business requirements to functional and technical requirements (MD050/MD070)

·     Designed and developed employee and student records interface, bank account information interface and cost object segments interface from University of Pennsylvania to Concur

·     Developed unit test scripts (TE020)

·     Executed unit test script (TE070)

·     Worked with Concur to resolve any issues

     Other 11i work

·     Worked on importing weekly and monthly bank statements into CM through Oracle open interface

·     Worked on improving the performance of Oracle standard Auto Reconciliation Execution Report

·     Developed an automated process to perform ship-to-location clean up

·     Developed an automated process to perform annual vendor sites and vendor record deactivations

·     Performed BNE module set up

·     Created custom WEB ADI integrators and their components such as LOVs, layouts and mappings

Senior Software Engineer

August 2010 – December 2010

Mission Solutions Engineering - ASRC Federal, Moorestown NJ

·     Performed systems modeling

·     Added code customizations to existing DOD AEGIS system based on the specs provided by the NAVY

·     Developed and presented custom workflow for given specification for approval

·     Designed unit tests of complex software systems

·     Reviewed completion and implementation of technical products

Senior Programmer

June 2005 – August 2010

Subaru of America HQ, Cherry Hill NJ

·     Gathered business requirements and created detailed functional and technical specification documentation using Oracle AIM methodology

·     Automated order processing of SNE and SDC (Subaru’s Independent Distributors) orders via OM Order import

·     Designed and developed Oracle e-Business customizations

·     Defined inventory item templates

·     Performed conversion of master inventory items and item categories via Oracle open interface during 11i upgrade

·     Designed and developed a process for new inventory item creation and template application

·     Worked on adding additional steps to order workflow in OM utilizing Oracle workflow builder

·     Developed Discoverer 10g reports to compare warehouse inventory in Red Prairie with Oracle inventory

·     Provided day to day production support of critical Oracle e-Business systems

·     Interacted with Oracle Support Services through Oracle Support to resolve urgent issues

·     Coordinated code migrations between different environments (i.e., Development, QA, and Production)

·     Designed, developed and deployed training videos for Subaru dealerships utilizing Adobe Captivate

Cost Center Manager

May 2001 – June 2004

Travel Centers of America, Paulsboro NJ

·     Developed and enforced cost center policies in order to minimize shrink

·     Negotiated contracts with local suppliers

·     Supervised and trained 15-20 employees

·     Evaluated and analyzed local market demand for various products

·     Optimized employee labor scheduling based on the sales volume

·     Evaluated employees’ performance on annual basis. Suggested areas of improvement and offered training when and where appropriate

·     Placed purchase orders with corporate suppliers based on lead times

·     Occasionally received and inspected ordered merchandise that met certain criteria (high end, expensive items)

·     At the end of the month performed financial month close and forwarded the reports to the accounting department

·     Performed quarterly inventory counts and reconciliations

·     Assisted in annual inventory counts by an outside organization

Major accomplishments:

è  Minimized shrink from $40K to $2K quarterly through development and enforcement of policies cost center policies. Such policies included the counts of high cost items at the end of each shift and reconciliation between the counts and the items sold during the shift as well as installment of a video security system

è  Put in place reward system that would recognize and encourage employees who sold high end/high profit units

è  Developed a strong team that were working together as a team and cared about the success of the cost center

è  Increased monthly sales and EBITA by 20% through research of the local demand, purchasing some items from local vendors and incentivizing team members for the success of the cost center