SUMMARY

• Professional with over (15) years of experience in application and database development and design. I have excellent experience and knowledge in application development and design using Oracle PL / SQL, SQL Server 12, SSRS, SSIS, Java, JSP, HTML, CSS, JQuery, Oracle 10Gx / 11Gx,, VB/VB script, ASP, VB.NET, ASP.NET, Visual Studio, JavaScript, Perl, Shell scripts, Unix, IIS, Tomcat, Apache, Remedy, Crystal Reports.
• Experience in technical administration, support and documentation, Oracle database migration and administration, software package implementation and installation.

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer / Analyst

Responsibilities:

• Responsible for developing applications and integrations using the Microsoft SQL Server platform that include reports, vendor exports, data warehousing and other data related tasks.
• Develops new SSRS reports for Decision Support Systems.
• Serves as a Business Analyst and SQL Developer for all reporting needs for Decision Support System.
• Creates ad hoc reporting for the CEO, President, Medical Management for decision making purposes.
• Maintain and enhance the data warehouse for Medical Cost Analysis application, exports, and reports for Decision Support Systems.
• Develop new reports and applications for the Medical Cost Analysis Application.
• Develop and enhance Provider Scorecards for different Prospect locations.
• Develop vendor and client exports that meet provided specifications.
• Perform quality checks on reports and exports to ensure exceptional quality.
• Monitor jobs and transfer queues to ensure they are functioning as expected.
• Provide business users the data required for metrics and analysis.
• Develops SSIS packages for data loads from different health plans to our data warehouse database.
• Migrates existing Access applications and reports to SSIS/SSRS.
• Develops Microsoft Access applications.
• Develops and enhances applications using .NET.
• Create and maintain documentation for all projects.
• Microsoft SQL Server 2012 server side development including (SSIS, SSRS)

Confidential, CA

Technical Architect

Responsibilities:

• Develops and designs web - based suite applications using Java, JSP, JavaScript, HMTL, CSS, JQuery, Oracle 9.x/10x, PL/SQL, Apache, Tomcat. Develops and maintains different data loads and interfaces between many Corporate Systems applications using PL/SQL, Shell scripts, Perl, UNIX. Administers Remedy application software using UNIX, Shell scripts.
• Developed and designed a three tier application called “Emergency Accounting for Associate System” using J2EE standards, Java, JSP, CSS, Javascript, HTML, Oracle, LDAP, Crystal Reports. The system collects associate’s information in the event of an emergency. The system uses LDAP for authentication and Oracle as its back-end database.
• Developed and designed another three tier application called “Location Management Information System” using J2EE, Java, JSP,CSS, Javascript, Oracle. The system collects location information from associates and feeds into a space planning software.
• Developed a system Operational Data store that stores all associates, department information using Oracle 10G, PL/SQL. The system pulls information from the PeopleSoft database and then feeds 10 different systems for people information.
• Developed a system Operational Data store that stores all associates, department information using Oracle 10G, PL/SQL. The system pulls information from the SAP and then feeds over 30 different systems for people information. Most interfaces uses PL / SQL for data manipulation and load data while others uses PERL script like the Remedy interface. SHELL scripts are used for jobs execution and error and email handling. The jobs are scheduled nightly through Autosys.
• Developed and designed systems called “Transportation Tracking System” and “Combined Office Services Management System” using Remedy technology.
• Developed various Crystal Reports for corporate systems applications using Crystal Enterprise 10 and dynamic parameters.
• Involved in software package installation, implementation and patching for Remedy Application.
• Technical system administration and production support for Remedy, ODS, LIMS.
• Involved in Oracle 9i upgrades such as determining storage, space and data conversion.
• Involved in research of new technologies such as Oracle XML and Oracle HTML DB.
• Creates Disaster Recovery documentation for the applications that I support (ODS, LIMS) and participates in DR exercises.

Confidential, CA

Software Developer

Responsibilities:

• Develops and designs web-based suite applications using Active Server Pages, IIS, Visual Basic components, COM, MTS, JavaScript, CSS, HTML, Oracle8, ADO, PL/SQL, XML.
• Part of the team of 4 that developed and designed eCharge Labor and Attendance Collection for many AlliedSignal/Honeywell Sites (Torrance, Phoenix, Tempe, Tucson, Toronto, Ohio). eCharge is a web base three tier application that uses MTS, Visual Basic components, COM, ASP, JavaScript, Oracle8, some XML. eCharge is a system that collects engineering labor and employees attendance on-line, store it in the database and extract the information using PL/SQL for costing system weekly. Converted legacy data using PL/SQL to Oracle database.
• Performs DBA duties using Oracle databases associated with internal systems and Intranet applications including installation, configuration and administration in Windows NT Server/2000.
• Responsible for monitoring daily eCharge extract jobs and import jobs.
• Maintenance of the web and database servers through Terminal Services Client.
• Also part of the team that developed eShop Shoporder and Labor collection. eShop is a Visual Basic application with Oracle back - end that collects shop order and Labor entries.
• Developed an intranet E-Learning calendar using ASP, COM, Oracle 8i. The web interface is customized for students and instructor logins. Used ASP mail for class notifications.
• Troubleshoots different issues of the e-Charge software associated with the different versions of Internet Explorer and Netscape.
• Involved in the research of new technologies such as DHTML, XML.
• Involved in the evaluation of different tools such as DreamWeaver, TOAD, Flash, Crystal Graphics.
• Created the e-Charge software User Guide for the different sites for training and categorizing the document by the different users such as labor collection, time and attendance collection and project hours collection.
• Involved in the configuration and implementation of the e-Charge software in different AlliedSignal/Honeywell sites. This includes installation of the different components of the software such as IIS, MTS, Oracle in a Windows NT/ 2000 Server.