Web Application Developer Resume

SUMMARY

10+ years of strong SQL & Oracle PL/SQL development experience
Full - stack development experience with Oracle APEX
Understanding of Oracle architecture and DBA experience
Data modeling & schema design practices on database and data warehouse
Unix Shell scripting experience for batch processing
Data analysis and visualization using Python 1 2
Successfully upgraded Oracle 8i on Sun Solaris to Oracle 10g on Red Hat Linux and collocated to Rackspace hosting dedicated servers
Administered relevant database security, managed database backups, and prepared recovery plans against failures using RMAN and Flashback database features
Optimized system configurations & application queries for performance using OEM (ADDM), sQl Profiler, Explain Plan, SQL Tracing with TKPROF
Automated routine database administration and deployment tasks using Unix Shell scripts, cron jobs, Oracle Data Pump (Export/Import) and SQL*Loader
Managed tasks to create, maintain and refresh required Oracle instances/databases for development, QA, staging and production environments
Evaluated and performed a pilot project for Sales data mart using dimensional modeling and Oracle Warehouse Builder

PROFESSIONAL EXPERIENCE

Web Application Developer

Confidential

Responsibilities:

Developed web-based library book rental application system as a full-stack developer (front- end and back-end) using Oracle APEX 3.2 and PL/SQL

Database Developer

Confidential

Responsibilities:

Analyzed business requirements and designed logical & physical database structures through entity-relationship data modeling with normalization theory techniques and practices
Implemented all back-end business logic using Oracle 8i PL/SQL stored procedures, functions, packages, and triggers for J2EE web applications
Designed and configured database replication processes using materialized views between remote master and local database servers
Developed web reporting applications using ASP and Crystal Reports IX

Java Developer

Confidential

Responsibilities:

Developed EJB containers for web-based travel packaging & reservation system using J2EE and implemented SQL queries using JDBC prepared statements
Implemented file I/O user interface using Java Swing, represented application data into XML, transformed to HTML via XSLT for an educational software application

Senior Software Engineer, Consultant

Confidential, Alpharetta, GA

Responsibilities:

Developing and supporting Confidential Total Source PEO (comprehensive HR outsourcing) solution using Oracle 11g PL/SQL and SQR for customized PeopleSoft applications in Agile Scrum team
Implementing basic data analysis and visualization using Python

Senior Software Systems Engineer, Consultant

Confidential, Alpharetta, GA

Responsibilities:

Performed database conversion of stored procedures in Sybase & SQL Server to Oracle 12c for Commission Calculation Reporting System built on .NET frameworks in Agile Kanban team
Supported, enhanced, and implemented enterprise ETL processes and business requirements using PL/SQL codes with GIT and CA Workload Automation ESP(dSeries)

Lead Database Developer

Confidential, Atlanta, GA

Responsibilities:

Was responsible for database applications development and maintenance for merchants’ credit cards payment batch processes (clearing, funding, and billing) running on Oracle 11g
Improved readability and performance of systems by normalizing data model and refactoring codes using advanced PL/SQL features (collections, bulk processing, exception handling, etc.)
Supported and enhanced complex ETL business processes using Unix Shell scripts, PL/SQL program units, and BMC Control-M scheduling
Troubleshot application errors through PL/SQL debugger and resolved performance issues on high-load SQLs using Explain Plan and SQL Profiling techniques
Implemented PL/SQL web service call, introduced SVN version control system, and maintained Oracle APEX financial reports application 2 Involved in designing enterprise data warehouse project, applied dimensional data modeling practices on Oracle 12c, and developed dashboards on Sisense BI tool (similar to Tableau)

Led a team of three in database application development and mentored the team members for high quality software

Sr. Database Developer / DBA

Confidential

Responsibilities:

Performed overall database administration and development role in support of J2EE online travel packaging and reservation applications, built on Oracle and WebLogic servers
Designed, developed, and deployed web-based reporting system using ETL processes, PL/SQL and Oracle APEX 4 on Oracle 10g for internal users