SUMMARY:

I have extensive experience in Oracle database, data load, triggers, stored procedures, SQL and PL/SQL programing, and some database administration. I worked in all phases of software development life cycle for several automated systems. My experience includes minicomputer applications, workstations, PCS, and client - server environments. I worked in many automated systems that include CRM, Call Center, and Ticket systems. I have deep knowledge in Siebel data model.

HARDWARE AND SOFTWARE SKILLS:

Languages: SQL, PL/SQL, COBOL, JavaScript, HTML, VISUAL BASIC, TCL, CGI, PRO*COBOL

Operating Systems: UNIX, NT, MS-Windows.

Hardware: HP, Sun Solaris, DG, PRIME, PC, IBM mainframe

Database: ORACLE 7/8i/9i/10g/11g/12c, Hyperion Essbase, SYBASE 11, SQL Server, DBASE III

GUI: SIEBEL Tools, DREAMWEAVER, SCOPUS, Developer/2000

Tools: TOAD, SQL Developer, SQL*LOADER, ERwin, DBArtisan, EXCEL, VISIO.

EXPERIENCE:

Software Developer, Principal

Confidential, Fairfax, VA

Responsibilities:

• Primary production support for Siebel modules. Subject matter expert for Qualifications, Claims, and Customer Surveys modules.
• Developed SQL scripts to correct data for Tier 3 tickets from SDDC, TSP, and military families.
• While working tickets, always look beyond the reported issue for any potential impact and apply fixes.
• For example, a customer was unable to see items in one claim and has more than one claim; extra steps are taken to ensure data in other claims is correct.
• Utilized Siebel Tools, SQL, and access ETA to perform extensive troubleshooting login issues.
• Monitored ETL in production on a daily basis. Reviewed logs and identified error when ETL failed due to system or data issues. Corrected errors and restarted as necessary.
• Verified data was correctly imported by EIM (Enterprise Integration Manager)
• Created complex queries to provide statistics for Claim, Loss/Damage, CSS Survey, and Users.
• Provided complex reports to upper management and government whenever there were large data issues that impact users. Recommended approach and applied fixes.
• Provided input for Claims redesign and data migration.
• At the beginning of the project, utilized Siebel Tools to modify Siebel email templates as identified in SPR and supported development with advanced issues.

Senior Software Engineer

Confidential, Fairfax, VA

Responsibilities:

• Primary technical support responsible for Siebel and OBI modules.
• Successfully resolve each ticket in less than 3 days as contractually obligated.
• The application uses Siebel, OBI and JAVA.
• Responsible for triaging complex tickets that covered multiple areas with the respective development teams.
• Developed SQL scripts for fixing Siebel data that cannot be changed by the application.
• Performed extensive troubleshooting for issues related to Siebel modules.
• Utilized Siebel Tools to modify Siebel configuration as identified in SPR.
• Worked in Siebel Tools to configure fixes for tickets
• Trained other resources for fixing commonly occurring issues within application.
• Wrote and ran scripts and SQL to fix data issues in Java databases.
• Verified data was correctly imported by Siebel EIM.

Senior Computer Scientist

Confidential, Fairfax, VA

Responsibilities:

• Production support for Hyperion Essbase and Hyperion Planning systems.
• Analyzed problem and provided resolution for production issues.
• Improved development environment by monitoring the system usage, memory available then recommended management to add memory to the Essbase server.
• That resulted in significantly reduced system down time and improved performance.
• Wrote complex queries to produce weekly executive reports.
• Assisted users with login issues and data flow from PeopleSoft and Costpoint systems to Unanet.
• Conducted system test.
• Used SQL*LOADER and SQL to verify data conversion.
• Responsible for technical support and back-end interface development in Oracle 9i, Siebel, and Windows 2003 environments.
• Developed PL/SQL programs to load data into FSM database using the EIM (Enterprise Integration Manager) process.
• Maintained a complex application that accepted spreadsheet files as attachments then imported data to the database.
• The application consisted of a Visual Basic program, SQL*LOADER, PLSQL programs, Siebel EIM, and batch files.

Oracle Database Administrator

Confidential, Arlington, VA

Responsibilities:

• Installed and upgraded Oracle 9i software
• Set up and monitored database backup, performed database maintenance such as disaster recovery on Windows 2003.
• Created users with appropriate roles, migrated them from development to beta then production.
• Monitored databases and conducted database performance tuning on proprietary applications and Computer Associates Metadata Repository.
• Assisted the development team in the data modeling process.
• Reviewed and applied scripts to create database schemas.
• Modified customer’s Physical Data Model using Erwin.
• Modified ASP and PL/SQL programs.

Senior Oracle Developer

Confidential, Rockville, MD

Responsibilities:

• Designed security module to control access to web pages.
• Wrote stored procedures and packages to generate HTML code and Java Script at run time.
• Performed DBA duties such as Oracle installation, database import and export, and data loading using SQL*LOADER.
• Responsible for table design, and data modeling.
• Maintained and reconciled monthly reports from laboratories and FIS (Financial Information System) for Confidential .