We provide IT Staff Augmentation Services!

Senior Database Developer / Oracle Resume

Houston, TX

OBJECTIVE:

To obtain a challenging position, which will utilize my experience in software & database development from concept to completion and expands my skills in database, big data, machine learning and software development.

SUMMARY:

  • Confidential has over 20 years of comprehensive IT experience in database and application development on various platforms for Kiosk, Point of Service (POS), Manufacturing, and Oil & Gas industry.
  • Completed on Big Data and Hadoop and Python.
  • Extensive experience in RDBMS using Oracle 11g, MS SQL Server 2008, Oracle Unifier, DB2, MS Access, Sybase, and DEC - Rdb.
  • Excellent experience in programming using C++, Java, C#, VB, VBA, XML, Visual Studio 2008, Java, hibernate and JDBC using eclipse, and RAD 7.x for Java on Windows and AIX (Unix).
  • Experience maintaining and monitoring of databases for Performance Tuning and Query Optimization recommendations for PL/SQL and Transact-SQL stored procedures.
  • Proficient in writing stored procedures, triggers, views, indexes; using PL/SQL and Transact-SQL, for enforcing referential integrity on SQL Server, and Oracle database; implemented DBMS best practice.
  • Performed database administrator tasks using T-SQL programming on MS SQL Server and Sybase Anywhere Studio.
  • Exceptional problem solving skill, involving languages, batch processing, stored procedures on MS SQL Server 2000 and 2008 database, export, import, DTS, SISS, and VBA code.
  • Excellent experience in maintaining servers locally and remotely using VMWare, remote desktop, and VPN client.
  • Generated adhoc report by connecting remotely to client’s production database servers for management. Involved in late night support for such tasks.
  • Good experience writing Batch scripts, VBScript in Windows and UNIX shell script on AIX Server.
  • Experience on Object Oriented Design and Programming (UML) using Rational Unified Process.
  • Experience with troubleshooting stored procedures, using debugger for stored procedures on SQL Server 2008 and 2000.
  • Installed Oracle 10g and 11g databases on Windows and involved in upgrading Oracle database from 10g to 11g on Windows (production and test) Servers.
  • Using analytical and problem solving skills to resolve low performance issue.
  • Strong working background in System Development Life Cycle (SDLC). Excellent working experience in following SEI CMM level process. Participated in design, coding, unit and integration testing, implementation and maintenance.

TECHNICAL SKILLS:

Hardware and OS: Windows Server 2003/7/XP /2000/x, AIX server, Dec-Alpha, Open VAX/VMS, IBM-3083, MVS/JES2.

Programming Languages: C#, C++ / VC++, Batch script, Java, XML, Visual Basic, VBA, HTML, Transact-SQL, PL/SQL, VB Script, VAX-C, DCL, JCL, TSO, ISPF, Fortran, COBOL, BASIC, IBM Assembler

Databases: MS SQL Server 2008/2000/x, Oracle 11g/x, MySQL, No SQL, Sybase 7.0, MS Access, MS Excel, DEC-Rdb, RDBMS, ISAM, VSAM and DBase.

Software Tools and Technologies: Oracle Unifier, hibernate, Git hub, Maven, RESTful web services, VMWare, Remote desktop, SSRS, SSIS, SSAS, Power Point, VPN, VNC, ETL, WPF, J2EE, Servlet, Struts, EJB, Tiles, Visual Studio 2003, .NET, ASP, Rational Rose, Lotus Notes, Pivot table, Active X, COM, ADO, RDO, Visual Source Safe, PL/SQL, MVC Design Pattern, Tivoli, JSP, Ant, JDBC, RAD 6.0, WSAD 5.0, Eclipse, Web sphere, LDAP, Active Directory, GD Pro, Power Designer, CMVC 5.0, ODBC, ADO, Microsoft Reporting Services, BIRT, Cognos, and Ghost image.

EXPERIENCE:

Confidential, Houston, TX

Senior Database Developer / Oracle

Responsibilities:

  • Developed and maintained few Java based ETL to extract data from CSV file transform into XML BPs and load into Oracle Unifier.
  • These Java based ETLs utilized RESTful web services to process data into Unifier by using eclipse, Git, Maven and Oracle Unifier.
  • Working on JEE, Java, hibernate, web application to develop an integrated solution. It is to develop as an independent product that will help populate the data from one system to Unifier.
  • Involved in performance tuning of MS SQL Server 2008 database for Epoch solution.
  • Involved in Transact-SQL, Stored procedure, batch files to automate the ETL jobs on MS SQL Server 2008 databases. Written batch jobs and stored procedures to support automation of manual steps.
  • Responsible for creating stored procedures and optimization using Transact-SQL programming.

Confidential, Clear Lake, TX

Senior Software and Database Developer

Responsibilities:

  • Written and maintaining object oriented application in C++ for data-mart to generate XML files at Kiosk. Responsible for coding and testing for converting binary transactions data to XML.
  • Maintaining and supporting Java based Application and Web Server using RAD 7.x applications on IBM AIX Servers, and NOC Web application to monitor and view transactions using MVC.
  • Working on C#, and ODAC application to pull data from Oracle Remedy database, zip it and transmit to vendor for generating report. It pulls data periodically.
  • Worked on C#, XML and XML transformation on .NET framework using Visual Studio 2008.
  • Performing part-time database administrator responsibility on MS SQL Server 2000 and 2008 for helpdesk support. Migrated projects from DTS to SSIS during database migration.
  • Involved in Transact-SQL, PL/SQL, SQL*Plus, ad-hoc query, SQL Script coding to loading, extracting (ETL), reporting, stored procedures, triggers for XML activities using SSIS on MS SQL Server, Oracle 11g / 9i, MySQL and DB2 databases.
  • Responsible for Oracle 11g / 10g / 9i database upgrade in production for each software release. Written SQL Scripts for the database upgrade.
  • Performed database administrator task of installing, and PL/SQL programming on Oracle 9i and 10g. Upgrading Oracle 10g to 11g on production and test windows servers.
  • Written and maintaining C#.Net application to process enterprise data on translation server to remotely upload local and national data to each kiosk.
  • Performing weekly system build and packaging for 5 major applications using Python, along with creating ghost image for the development and system team and for distributing to the customer.
  • Developing and maintaining VBA report application for requirement, weekly / monthly revenue transaction metrics and performance reporting for help desk and management. This application written using MS SQL Server 2008, SSIS, ASP, VBA, excel and power point.
  • Analyzed requirements database on MS Access. Rewrite the complete requirement traceability metrics (RTM) procedure and improved the report generation from two days to couple of hours. Used MS Access, Excel, CSV, and Visual Basic.
  • Packaging each store activities in zip file and transmitting them to Retail Data Mart (RDM financial) Server. Used Oracle to extract the data.
  • Developed and maintain the metrics reporting for the management using SSRS, T-SQL, VBA, excel, SSIS and power point. Streamlined the weekly, monthly, quarterly and yearly reporting.
  • Applied analytical and debugging skills to investigate and resolve production issue. Created stored procedure and implemented permanent solution. It improved performance, quality and customer satisfaction.
  • Written and maintaining many batch job, VBscripts, and shell scripts to support Help desk team.
  • Responsible for Recovery Server. Developed and implemented multithreaded application using C++ and PL/SQL in Oracle 11g, recovery process for transaction of data files, to meet 98% success rate.
  • Responsible for OOD and OOP using Rational Rose (UML), C++, java, vi, make file, coding & testing of modules in windows and AIX.
  • Involved in J2EE, Java, JSP, PL/SQL, coding to loading, extracting, reporting, stored procedures, triggers for XML activities using Oracle 9i database under AIX.
  • Responsible for data manipulation operations using T-SQL, CSV, VBA, ODBC and scripts.
  • Responsible for creating stored procedures and optimization using Transact-SQL programming.
  • Implemented, supported and reviewed database change with customer for many software release.
  • Involved in being Moderator and Inspector for any formal code/design/test documents reviews; agile methodologies was followed.

Confidential, San Antonio, TX

BI Developer, Data Warehouse

Responsibilities:

  • Performed the role of data warehouse developer on MS SQL Server 2000, VBA, MS Access, Excel, ODBC, and Windows 2003 Server.
  • Responsible for optimization and SQL programming using Transact-SQL.
  • Responsible for create and maintain ETL process for data loading.
  • Responsible for generating reports using Cognos and Crystal Reports.
  • Worked on Enterprise Manager, Query Analyzer, Reporting Services, DTS designs for ETL process.
  • Responsible for generating reports on Microsoft Reporting Services (SSRS) and Cognos ReportNet using Query Studio and Report Studio.

Confidential, Clear Lake, TX

Database and C++ Developer

Responsibilities:

  • Responsible for maintenance of logical and physical ER diagram using Power Designer.
  • Performed database administrator responsibility for installing, upgrades, performance tuning, optimization and Transact-SQL programming on Sybase Anywhere Studio.
  • Responsible for data manipulation operations using T-SQL, CSV, ADO, VBA, ODBC and scripts.
  • Responsible for creating stored procedures, tables, views, and indexes using Transact SQL.
  • Responsible for OOD and OOP using C++, vi, make file, coding & testing of modules.
  • Analyzed and designed recovery process for the transaction data files and recovered files to meet 98% success. Developed multithreaded utilities in C++ to check more than 6000 sites.
  • Sybase Anywhere Studio, SQL Server 2000, GDPro (UML), Visual Age C++, Transact-SQL, ADO, CMVC, vi, make, VBA, Lotus Notes, Win NT.
  • Involved in being Moderator and Inspector for any formal code/design reviews; waterfall methodology was followed.

Confidential, Houston, TX

Developer, Core Development

Responsibilities:

  • Developed server-side application to authenticate incoming Fax and Email broadcast submission; used Visual C++, VB, Transact-SQL on MS SQL Server 7.0.
  • Developed and maintained DTS for ETL process using MS SQL Server 2000.
  • Worked in a team to develop Convergent Messaging System using VB, Access and SQL Server 7.0 to provide end-users with a single interface that controls multiple forms of communication.
  • Developed server side FAX middleware application to receive the Email with a TIFF and PDF attachment and sends it to the fax machine. Used VB and VC++ multithreaded application.
  • Remediate the entire Application and Database for Year 2000 running on DEC-Alpha using DEC-Basic and Oracle RDB as Database.
  • Responsible for Database design, expansion and performance for Y2K. Carried out implementation and post implementation support at client site.

Programmer Analyst

Confidential, Montgomery, AL

Responsibilities:

  • Converted the UNIX RM-COBOL application to MF-COBOL using MS SQL Server 6.5 as backend.
  • Responsible for conversion of I/O modules from ISAM to Database, written complex Embedded Transact-SQL queries.
  • Performed integration and functional testing.

Confidential

Senior Programming Officer

Responsibilities:

  • Designed, developed and implemented Well Log database application for Geo-scientists.
  • Designed, developed and implemented Natural Resource and Reserve database application.
  • Designed database, user interface & reports by writing complex Embedded SQL queries using Pro-C, Pro-FORTRAN, COBOL, DCL and DEC-Rdb and Implementation on VAX/VMS systems.
  • Involved in tailoring Contouring Package System (CPS) in generating location maps.
  • Worked on Exploration and Production (E&P) database and provided support to geoscientists.
  • Created application to extract ISAM files data from IBM/MVS mainframe using JCL, ISPF transformed them to CSV files and loaded them to the DEC-Rdb relational well database on VAX/VMS system.
  • Generated various reports for Exploration and Production Data Management System to help seismic interpretation.

Hire Now