Senior Software Developer Resume Profile

Summary

10 years of experience in Oracle PL/SQL and SQL development
Expertise in Procedures, Functions, Triggers, Packages, Cursors, Views, Bulk Collect, Partitions, Indexes and Performance Tuning SQL queries
Expertise in loading data from XML and CSV files into Oracle database
Hands-on experience with large volume of data
Hands-on experience across all stages of SDLC
Expertise in setting up Best practice, designing modules for long term maintenance
Expertise developing application modules using XSL, Java and Python
Expertise with Open source technologies such as Panda, Jenkins, Wild Fly, Fitnesse and GIT
Exposure to ETL tools such as Pentaho and Informatica
Years of experience with both Waterfall and Agile methodology
Hands-on experience writing Technical/Functional design documents
Years of experience with Energy trading applications and deregulated energy markets

Primary Skills

Oracle 11g, PL/SQL, SQL, SQL Plus, SQL Loader, Java, UNIX Shell Programming

Other Tools and Technologies

Developer 2000 Forms 4.5, 5, Reports 2.5 , XSL, Python, PLSQL Developer, SQL Navigator, Eclipse, Toad, Wild Fly, Jenkins, Panda, Fitnesse, XML Spy, Version One, GIT, Pentaho, Informatica, Visual Basic, Visual Source Safe, TFS, Test Director and Microsoft Visio

Professional Experience

Confidential

Senior Software Developer

Develop database modules using oracle stored procedures, functions, triggers and packages
Extensively involved in designing database tables, views and sequences
Performance tuning and optimizing Oracle SQL queries using TKPROF
Develop modules using XSL and PL/SQL to load data from CSV and XML files into Database
Write technical design for new development modules of PL/SQL and XSL
Provide guidance and manage the work of junior team members
Provide SQL queries and guidance to testing and functional team during application testing
Extensively involved in code reviews of other developers
Extensively involved in advising and guiding product support team to resolve client issues
Facilitate Web Ex with clients and trouble shoot technical production issues
Develop modules using Java to load data from xml files into oracle database
Develop modules using Python for settlement calculations
Provide training and share technical expertise with other developers/product managers in the company
Involved in new hire selection process and mentoring new hires

Confidential

Database Consultant

Extract data from people soft HR system, write data into flat file using UTL FILE utility and this flat file is used to feed data into other external systems in the organization
Designed, developed and modified Unix shell scripts for process automation
Extensively involved in writing PL/SQL procedures and packages which are used as interfaces between independent Human Resource systems

Confidential

Team Lead

Managed a team of 5 developers
Developed web enabled reports using PL/SQL cartridge in Oracle web application server
Developed user interface forms using Developer 2000, forms 4.5
Developed database batch process using PL/SQL procedures and packages which are used to update reports database

Confidential

Programmer Analyst

Extensively involved in creating packages and procedures using PL/SQL
Developed SQL plus reports
Converted SQL statements within pro C into stored procedures to improve performance
Developed automated report process using Control-M job scheduler and sql loader
Used UTL FILE utility to write data into flat file from oracle database
Developed procedures and UNIX shell script for automated migration process. These scripts can migrate database objects from development environment to testing environment and then to release environment

Confidential

Programmer Analyst

Extensively involved in system analysis to develop modules in Marketing Analysis System
Extensively involved in Oracle Database and table designs
Developed user interface screens using Forms 4.5
Developed user interface screen using Visual Basic 5.0
Developed reports using oracle reports 2.5

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship