Francy L. Roncancio

*** ********** ** **** ******, OH 44202 Cell 813-***-****

acojv5@r.postjobfree.com

OBJECTIVE

Work in an enterprise that recognizes the input and values of professional knowledge, team work,

organization skills, innovative thinking, and driven individuals in the Information Technology field.

EXPERIENCE

Accounting Clerk – Ohio Reformatory for Woman (Contractor)

06/2014-11/2014 Marysville, Ohio

Reconciles bank statements with general ledger.

•

Maintains accounting databases.

•

Verifies financial reports through performance analysis software program.

•

Review, entry and process orders.

•

Track cash account disbursement

•

Prepare cash conciliation and deposit and post appropriate journal entries.

•

Receive, review and entry Court and Child Support cases.

•

Assist in the preparation of financial, accounting and statistical statements; assist accounting staff

•

and departmental management in the preparation of reports.

Perform a variety of general office support function including data entry, filing, record keeping, and

•

report generation.

Review, process and release accounts from the system.

•

Coordinator Contract and Pricing - Cardinal Health (Contractor)

03/2014-05/2014 Dublin, Ohio

• Understands how the system's data elements impact suppliers and customers

• Applies specialized knowledge in processing pricing, contract and financial transactions

1

• Resolves non-routine exceptions

• Prioritizes and organizes own work to meet/exceed personal and work team goals

• Serves as SME on process

• Compares performance against service requirements to identify and resolve moderately complex set-

up and maintenance issues

• Demonstrates advanced knowledge and our customers in problem resolution and participates in LSS

initiatives

• Follows established business rules for process

• Maintains SOPs for process

• Monitors compliance with controls and drives resolution of complex exceptions

• Documents controls around processes

• Demonstrates specialized knowledge of customer set-up and maintenance

Specialist Quality Control - Honda R&D (contractor)

6/2012 – 12/2013 Raymond, Ohio

• Manage company world-wide process of Counter-measure Request Form or CRF between

operations manufacturing and engineering departments.

• Track on-time response and commitments of sensitive and visible production issues directly

affecting the development of new models.

• Manage the process of new/modified components of prototype and mass production effort. Own

Database responsibility of up-keeping. Process includes interacting with engineering, sourcing,

inventory, and manufacturing departments.

• Expedite ad-hoc report from different database sources and application. Conduct the analysis,

design and development of all queries.

• Perform report tracking and forecast of in-process engineering drawings.

• Perform automotive component update and request for purchases in supporting software.

• Train and support engineering staff in quality control process.

2

• Design and implement data collection format using MS.

Bilingual Staffing Specialist - I-Force

8/2011 – 3/2012 Delaware, Ohio

• Manage office-load payroll and data entry activities.

• Support customer inquiries and fulfillment

• Support sales and employee retention activities

• Conduct interviews, hiring/firing, and performance evaluation of associates.

• Perform training of on job expectation and safety procedures.

• Perform performance and financial reports.

• Support/facilitate written and oral translation to enhance communication efforts.

• Support other branches within Ohio.

• Comply and adhere to all federal and state labor laws

• Perform all tasks with the highest ethics and confidentiality that the position demands.

Web Master Manager -Carulla Vivero S.A.

02/2002–04/2006 Bogotá, Colombia

Analyze develop and Implement I-Store using Linux Suse 8.0 and Oracle 8.1.2 platform.

• Design and develop an in-house Web Store applications using Oracle 8.1.2 DB, Linux Suse 8.0

server, UML methodology, Red Hat server application, java and J2EE.

• Design and develop bonus sale application tools for Web Store (B2C).

1. Incremental monthly revenue gained by implementation of Web Store $ 60K

2. Profit Magazine Editor’s Choice Award for best web sales site www.carulla.com; January 19,

2003; San Diego, CA.

Configure and Implement Oracle 11.5.9 applications such as i-Store, Tele-sales, Inventory, Order

Management, and human resources modules.

Design and develop reports for upper management using Oracle Discovery

3

Administrative responsibilities for Linux OS, Oracle DB 9i, Window NT and AVAYA phone systems –

patch upgrades, debug, and diagnose issues.

Develop in-house Call center application using Power Builder

Support all activities for call center – configure, install, monitor and maintain different operations systems,

users, and applications.

Generate Statistical information and reports using Web-trend tools.

Design tools to support Sales and Marketing effort through the analysis of inventory excess and surplus.

Support internal audit to identify and prevent internet fraud activities. Interact and support authorities

throughout entire investigations.

Manage administration of the following company sites: www.carulla.com, www.vivero.com,

www.telleva.com, www.carullavivero.com.

System Engineer- Comcel, S.A.

02/1995–03/2000 Bogotá, Colombia

Analyze, design, develop, and generate reports for accounting department, upper management, and

customer services using UNIX platforms.

Design, develop, and implement ELT process using My SQL.

Analyze, design, develop, maintain, and implement Data-Warehouse and Data-Marts for

telecommunication business using Oracle DB

Develop business matrix decisions for upper management evaluation using Cognos tools.

Design and generate confidential reports for upper management using Impromptu tools.

Develop and implement client profiles (segmentation process) for marketing strategies.

Design, develop, and process the extraction of information from Pre-paid platform for upper

management.

Develop and coordinate customer improvement project – customer retention and tracking tools to

identify customer complaints and field problems.

4

Education/Special Training

BS Computer Science Engineering - 1991–2000

University Distrital Francisco Jose of Caldas - Colombia

Microsoft Vista – 2009

St. Petersburg College, Florida

Health Information Management

Hillsborough Community College 2011-2012

Oracle Professional Certification

In progress - Target for completion 2014

Oracle SQL and PL/SQL

MS SQL server 7.0, Access

Java, J2EE

Power builder

Forest & Trest

Ingress

Cognos BI tools (Cognos and Impromtu)

Oracle applications

Oracle reports, forms, and discovery

Toad

5

SAP

Windows NT/Vista/2000/XP/7

Linux (Suse and Red Hat)

Object-Oriented analysis and design using UML

MS Office

Anti-virus and software computer maintenance

Web-trends

CATIA V5

Cactas

Dots

6

Contact this candidate