Sr. Pharmacy Analyst

Responsible for analyze, maintain, develop and design Crystal Reports Xi reports. Using our ARGUS system, Oracle 10g databases, SAS 9, Excel and MS Access. My areas the experience included Pharmacy and Finance the reports are developed to fit the needs of our users. Accomplishment:

• Monthly Dashboards for major customers
• Monthly reports automation
• Automation of CMS MTM selection and report process
• Automation ADD/ADHID HIDIS report
• Developed NPI Prescriber table

Environment: RxFocus, Oracle 10g,  Crystal Reports Xi, MS Access, SAS 9, MS Excel

---

Applications Developer

Responsible for analyze, maintain, develop and design Crystal Reports reports/Crystal Enterprise. Using our CINCOM system under Oracle and MS SQL databases. Our reports are designed with a combination of Views, Functions, Stored procedures and Crystal Features. My area the experience included Procurement, Inventory, Finance, Accounting and Quality. The reports are developed to fit the needs of our users. Accomplishment:

• Finance Project Cost Summary Drilldown
• Bill of Material for the MRP system
• Participation in Report Development Guidelines

Environment: CINCOM, Oracle, MS SQL, Crystal Reports, MS Access

---

Responsible for analyze, maintain, design and develop custom reports for clients in Mexico and Canada. Custom reports are developed to fit the needs of our customers thru the I2 Transportation system with MS Access, Crystal Report 8 and Oracle 8i. Accomplishment:

• Custom reports implementation for two of our major customers
• Design and Implement user’s training for Mexico’ site
• Implementation of MIS to track 100 % shipment activity and cost by each carrier or location.

Environment: I2, Oracle 9, MS SQL 2000, MS Access, Crystal Reports 8.5, HTML

---

Implementations Manager

Responsible to keep updated INDASOL.COM website, Accomplishment:

• Deliver training for groups of students assigned for Dreamweaver / Ultradev
• I implemented FedEx Web API prototype for shipments tracking for the site www.arremate.com with MS Access, VB 6 and Win 2000.
•  I developed student’s transcript for the Medianeira College at www.colegiomedianeira.com.br Saved U$ 20,000 annual by eliminating the need for printing 2,300 quarterly student’s transcripts.
• Developed communication management system file GMC at Norske- Skog for the www.norske-skog.com.br/gmc site.

Environment: TSO, JCL, SAS, MS SQL, VB6, HTML, JavaScript, and Macromedia Flash & Dreamweaver

---

Sr. HRIS Analyst

Responsible for the Integrity and compatibility of the HR information system, as accomplishments:

• Design and implement LAC HR PRISM system New users Training
• I worked on the integration of corporate and international systems Safety Divisional Reporting System that simplified by 70% the process for reporting employee accident and injuries.
• I participated in the development of the Mexico and Brazil payroll system interface; eliminated redundant salary data between local and corporate PRISM systems saved U$ 75,000 annually.
• I Developed and designed the LAC Merit Increase system; saved time of manual calculation by 100%, increased communication by 40%.
• Participate with implementation of the HR LAC intranet web site.
• I participated with the implementation of PeopleSoft HR for The Latin America Division.
• As programmer I participated with the development of the Canadian Payroll Pre-processor for hourly employees.

Environment: IBM Mainframe, HP UNIX, VM, TSO, CMS, COBOL, JCL, C, SAS, Db, Sybase, MS Access, Crystal Reports, HTML, JavaScript

---

Sr. Programmer

Responsible for build test scenarios, perform unit and system test and write programs code.
Accomplishment:

• Implemented Metallurgic Accounting System managed and calculated existing mineral amounts and flags reload order.
•  I implemented reusable system functions of the corporate libraries. Provided Technical assistance to end- users and technical guidance to junior staff

Environment: HP, UNIX, FORTRAN IV, IMAGE Db, Powerhouse 4G