Ileana E. Arroyo

**** ****** ***** ******, *******, Virginia 20171

703-***-**** day, 703-***-**** evening, ac7xtb@r.postjobfree.com

Summary of Experience:

Over 10 years of experience in software development working on applications to satisfy customer needs.

Ability to analyze and migrate data to move legacy systems across databases and system platforms into new or existing applications systems.

Design and develop applications to satisfy user requirements and for ease of use.

Generate requirements, design, and testing documentation to comply with CMM processes.

Ability to understand business processes and apply the knowledge to solutions.

Ability to learn new methodologies and utilities to quickly adapt to different business and process directions.

Computer Skills:

Computer Languages: PL/SQL, SQL, SAS 9.4 (including macros, packages. SQL), Unix shell, Perl, HTML

Databases: Oracle 11g/12c, Microsoft Access

Applications Tools: Oracle SQL Developer, SAS Enterprise Guide, SAS Management Console, Oracle Forms, Oracle Reports, Oracle Financials, Microsoft Excel, Microsoft Word, Microsoft Access

Operating Systems/Platforms: Unix, Windows

Other: Dimensions, Tableau, Jira, Sharepoint, PVCS, SEI/CMM Level-II

Work Experience:

September 1997 – November 2018

1Source LLC., Washington, DC

Database Developer/Analyst

Analyze, design, develop, and test SAS programs to support reporting and visualization of data. Convert existing 500+ Discoverer and Oracle reports to SAS writing macros that consolidated code and using SAS Reports.

Used SAS to create data quality reports from Oracle data into Excel spreadsheets that is emailed to users. The results of the SAS SQL queries were displayed in individual tabs in Excel.

Support and add new capabilities to existing SAS programs and models.

Migrate and support SAS programs, marts, and models to SAS 9.4. Create libraries from SAS data files and referenced from the Oracle database, packages, and consolidate code in support of the migration efforts.

Analyze existing reports and scenarios to create Tableau visualizations based on a Business Layer. Classified data from application logs using SAS programs and use the SAS output in Tableau to create dashboards of user activities.

Write SAS programs to extract a sample of data from Oracle schema tables, keeping the data integrity and exporting to Excel to load into prototypes.

Write and scheduled SAS program to automate system tasks like checking the Object Spawner and starting it if it is down.

Assist the DBA team with user access, DDL and DML scripts creation and deployment, and create logical and physical ERDs.

Design and develop solutions for database modifications and corrections including migration of data across applications.

Data migration and implementation of seven years of legacy data to Oracle HR and Oracle Financials systems including post release support. Responsible for developing the migration of HR data as well as migration of Federal Administrator, Requisitions, and Purchase Order data. Design and created application extensions using PL/SQL Toolkit to facilitate Oracle Financials post release support to comply with user requests.

Analyze, design, develop, and test Oracle Forms and Reports. Design and develop an Oracle Application Server web personnel system to assist the Office of Naval Research (ONR) HR department in the check-in and checkout process that consolidated multiple data sources into an efficient enterprise application.

Perform QA audits and other CMM activities for requirements, design, code walkthroughs and releases.

Technical team lead for conversion effort to Oracle Forms 5.0, Y2K compliance, emergency fixes, post Y2K issues, and new releases projects. Assigning work to developers, coordinating with other development and system administration groups for releases, meeting with the client to determine the immediate needs for deployments, and scheduling testing teams.

March 1991-September 1997

U.S. Geological Survey, Reston, Virginia

Computer Specialist

Design and develop computer programs to migrate the legacy national hydrological databases to a national RDBMS.

Served as onsite contact for migration and DBA support during the initial phases of the conversion to a DBMS and operating system.

Prepared Unix software releases to be distributed nationally.

Design and develop Web pages and CGI/Perl forms to import to Office '97 for user support data, saving time to get the data needed for statistical and planning purposes.

Help desk support for RDBMS and email; aided in the process of configuration management for help desk.

October 1985-March 1991

U.S. Geological Survey, San Juan, Puerto Rico

Computer Programmer

Develop computer programs for statistical analysis and graphical representation of hydrological data.

Develop computer programs for monitoring the operation of the system.

Assist in the collection and analysis of real-time Surface Water hydrological data.

Digitize maps for use in a Graphical Information System.

General help desk for operating system and database administration.

October 1985-March 1991

University of Puerto Rico, Rio Piedras, Puerto Rico

Teaching Assistant

Teach and grade Pre-Calculus, Introduction to Statistics, BASIC and Statistics, and Computer Tutorship.

August 1983-May 1985

Inter American University, Metropolitan Campus, Cupey, Puerto Rico

Professor

Teach and grade Introduction to Computer Science, BASIC, Pre-Calculus, Algebra, and Arithmetic.

Academic:

MS, Applied Mathematics, University of Puerto Rico, Graduate School Mathematics, Puerto Rico

BS, Mathematics, University of Puerto Rico, Graduate School Mathematics, Puerto Rico

Clearances:

Polygraph: July 2018.

Secret (inactive) - Background investigation conducted for position at the Office of Naval Research in 2006.

Top Secret (inactive) - Background investigation conducted for Summer internship at Lawrence Livermore National Laboratories in 1985.

Technical Training:

Data Classification and Machine Learning, September 2017

Big Data Fundamentals, May 2017

11i Extend Oracle Applications: Building OA Framework Applications, Oracle University, Reston, September 2005

Implement Oracle Workflow (E-Business Suite), Reston, August 2003

Oracle eBusiness Implementation, Oracle University, Reston, May 2003

Oracle Financials-General Ledger (GL), Oracle University, Reston, August 2002

Oracle Financials-Public Sector Budgeting (PSB), Oracle University, Reston, August 2002

Oracle Financials-Financial Analyzer (OFA), Oracle University, Reston, September 2002

Hands-On Java Programming, Learning Tree, Reston, September 2001

UML and GDPro Training, Advanced Software Technologies, May 2000

Other Relevant Information:

Languages: Fluent in Spanish and English

Citizenship: U. S. Citizen

Contact this candidate