Summary

Driven IT professional with over 10 years of experience in Oracle Development and Design, seeks new challenges and growth opportunities in Information Technology with an emphasis on Database Analysis, IT Business Analysis or Database Administration. Possess strengths interpersonal skills, communications skills, problem solving skills, team-oriented, highly dedicated, willing to adapt, and flexible. Willing to relocate within Florida or Georgia or Alabama areas and travel up to 25 . Long-term contact or permanent to hire positions preferred.

Qualification Highlights

• Experience in design and development of interfaces of legacy systems to Oracle Applications within state government
• Experience in information gathering and Systems Requirement Specification SRS Development
• Demonstrates attention to detail and collaborative problem-solving skills
• Experience in designing applications that produce accurate reporting results

Technical Expertise

• Software : Oracle 9i, 10g , Oracle Developer Suite 10g Forms Reports , SQL Loader, TOAD for Oracle, Informatics, Putty Emulator , Ultra Edit, Microsoft Visio 2000,
• Business Intelligence Business Objects Reports, JD Edwards Enterprise One
• Systems : Oracle 9i, 10g , Oracle 10g Application Server, DB2, Access, VAX, MVS, AIX, Windows 2007/XP
• Languages: SQL, PL/SQL, Unix Shell scripting, COBOL, ASP

Professional Experience

Confidential

Systems Analyst I/ETL-Oracle-Data warehouse Developer/Data Modeler

• Assist or lead analyst in conversion of legacy data into Oracle. Develop, design, re-engineer, and implement applications within an Oracle capacity using SQL, PL/SQL, and Unix Shell Scripting as development tools, provides application development and support to internal and external users. Develop test scripts to assist in the testing and debugging of vendor's interfaces based on Lottery and GTECH vendor business needs.
• Lead Analyst in gathering Lottery Interface Systems Requirements and liaison between the Lottery and 3rd Party in providing these requirements to be included in their Software Requirements Specifications. Works closely with the Lottery's Quality Assurance Section ensuing that the Lottery's Interface Systems Requirements needs are met and manually test 3rd party interface modifications before each batch release. If necessary, make appropriate program modifications based on requirements in Lottery's Oracle ETL process.
• Design, developed and test Interface Systems Requirements for re-engineering of the Lottery's Accounting System. Implantation includes ensuring that financial elements flow to and from the Lottery's data warehouse to JD Edwards Enterprise One to the appropriate agency outside the scope of the lottery and vice versa
• Lead Analyst in designing new ITVM Instant Ticket Vending Machine Sales system. This system is designed to capture ITVM Sales in Oracle Data warehouse and produces Business Objects Reports for Sales Managers statewide.
• Design and re-developed batch processes for the Lottery Player's Information System to produce data files and reports for Installments payments, Daily and Yearly Taxes.
• Lead analyst for Lottery Misc 1099 Yearly process. Redesigned process by converting legacy data from COBOL to Oracle. This process consists of extracted data from the data warehouse where taxes are greater than 600 or more a year. Produce various reports for accounting to reconcile and approve. Reduced overall processing time by 60 by converting into PL/SQL and incorporating a 1099 forms printing software named W2 Mate for producing tax forms and e-filing data files. Designed procedures and document possible issues for the Misc 1099 process and redesigning W2G's and 1042s data layout for IRS E-filing from re-engineering of the Lottery Player Information Database.
• Lead analyst and main contact for providing, managing, and testing Retailer data for in-house users. Retailer Information Systems consist of various interfaces that are created by the GTECH vendor GUI, FTP to the Lottery's in box, ETL, and stored in the Lottery's Retailer System which provides data daily on retailers for producing criminal and revenue background investigations, certificates, set up or downgrade of terminals, direct deposits, etc. Reports are produces in Oracle Reports and Business Objects Reports.
• Lead analyst for extracting data from data warehouse into the Lottery's Accounts Receivable System for specific retailer incentives. Data provides retailer bonuses on a specific game for a specific period of time.
• Designed a process to imported data from Access into Oracle for Second Change Drawings, which is a Lottery Player incentive draw. This process combines data from a randomly generated system with data entered by lottery players of a non-winning scratch off ticket s into the Lottery's website. The data is then displayed back to the website of winner's of that particular draw.

Confidential

Computer Programmer Analyst II

• Assisted accounting department as programmer/ help desk
• Gathered requirements on accounting business rules on how to improve business functionality.
• Identified existing computer problems and developed solutions to resolve them, by interacting with other IT members.
• Responded to accountants computer issues and needs.

Confidential

Computer Programmer Analyst I

• Developed various processes to serve environmental facilities needs, by in conversion of legacy data into Oracle, designing and writing interfaces, data migration in the Storage Tank Contamination Monitoring System, Compliance and Enforcement Tracking System and Water Assurance Compliance System. Developed training materials and conducted training sessions an application development.
• Assisted in clarifying business requirements, designed processes and system improvements.
• Converted reports form SQLReportWriter to ASP WEB reports.
• Created functional and technical specifications, ER diagrams, and produced physical schema diagrams.
• Provided application support for internal users
• Assisted in program modifications and testing based on needs.