Objective

• Seeking a Senior Programmer Analyst position

Selected Achievements

• Highly motivated IT professional with over 20 years of experience in designing, developing and implementing large Technology solutions in complex environments.
• Strong functional management and technical lead experience. Experience working with technical and business teams from corporate and government institutions.
• Proven strong leadership, team building and analytical skills.
• Extensive knowledge and hands-on functional and technical experience in the full life cycle methodologies with numerous software development/upgrade projects.
• Time management; Process improvement; managing multiple priorities; Strong visual and presentation skills.
• International experience.

Technical Skills

Operating Systems : HP, Sun Solaris and Windows
RDBMS : Oracle 11g/10g/9i, SQL Server
Languages : SQL, PL/SQL, UNIX shell scripting
Front-End : Oracle Developer 11g
CASE Tools : Designer, ERWin
Utilities : TOAD, PVCS Version Manager, Exceed, Maestro Scheduler,
PerfView, Microsoft Project, McAfee HelpDesk/NT, PL/SQL Developer, SQL 
Navigator, Rational ClearCase and ClearQuest

Professional Experience

Sr. Application Software Developer, Confidential Dec 2010- Feb 2012

• Involved in new product development using Oracle PL/SQL. This is a new application that will build off the existing online trading application (Investorline) allowing users to create their investor profile and optimize their trades accordingly.
• Developed and maintained stored procedures using PL/SQL for efficient data access.
• Performance tuned SQL and stored procedures using hints, bulk collects and global temporary tables.
• Wrote UNIX shell scripts to implement automated batch processes for cron jobs.
• Worked with front-end developers to debug the code.
• Took initiative in leading effort in upgrade and development of reports using shell scripts.
• Involved closely with QA in ensuring that target dates were met.
• Interacted with business users to better understand the processes.

Environment: Oracle 11g, UNIX

Sr. Oracle Developer (Consultant), Confidential Feb 2010- Dec 2010

• Maintained OMERS Pension Administration System using Oracle PL/SQL and Reports. This application allows contributors to view pension information, setup additional voluntary contributions, estimate retirement income and other services.
• Developed and Maintained stored procedures using PL/SQL for efficient data access.
• Performance tuned SQL and stored procedures using hints, bulk collects and global temporary tables.
• Wrote UNIX shell scripts to implement automated batch processes using cron.

Environment: Oracle 11g, Reports 6i, UNIX

Sr. Oracle Developer, Confidential Mar 2007- Dec 2009

• Maintained and Supported Electronic Ticketing and AirNZ Loyalty Applications using Oracle PL/SQL, Forms and Reports.
• Developed Implemented and Supported Period End Financial Reports using Oracle PL/SQL.
• Developed and Maintained stored procedures using PL/SQL for efficient data access.
• Wrote UNIX shell scripts to implement automated batch processes and data synchronization between different applications.
• Supported existing Pro*C programs used to send and receive messages via MQ.
• Created BI Publisher Data Templates to generate the Electronic Ticket Itinerary & Receipt.
• Used Hyperion to develop reports or convert existing ones written in Crystal Reports.
• As part of the Production Support team, responsible for change process, first level of support, coordinated and executed implementation plans, recommended changes to reduce system outages and increase efficiency.
• Interacted with Business Users, Performed unit level testing and peer reviews.
• Documented all new and existing processes.
• Mentored new team members.

Environment: Oracle 9i, Forms 6i and Reports 6i, Oracle BI Publisher, Pro*C, MQ, UNIX, Hyperion

Consultant, Confidential, NJ Aug 2003 – Oct 2006Consultant, Confidential, DC (2006)

• Worked on the Restatement Project and also on the Pricing Data Repository Project.
• Developed and maintained stored procedures using PL/SQL for efficient data access.
• Used SQL*Loader to load flat files as well as XML files. Wrote UNIX shell scripts.
• Was part of the Production Support team.
• Interacted with Business Users to generate scripts using PL/SQL for pricing outputs.
• Performed unit level testing and peer reviews, Mentored new team members.

Environment: Oracle 10g, PL/SQL, UNIX

Consultant, Confidential, MD (2004-2005)
(Dept of Commerce- “Commerce Financial and Enterprise Business Systems”)

• Worked on the Mass Reclassification Project; created stored procedures using PL/SQL and developed Forms and Reports. This enhancement allows bureaus to process global changes to the fund, program and project codes of existing transactions to reflect newly established fund, program and project codes without removing the audit trail of the original transactions.
• Wrote technical assessments investigating new requested features for better coding.
• Developed and maintained stored procedures using PL/SQL for efficient data access.
• Developed and maintained reports and forms.
• Performed unit level testing and peer reviews.

Environment: Oracle 9i, PL/SQL, Forms 6i and Reports 6i.

Consultant, Confidential, MA (2004)
(Direct Energy, CT)

• Created logical as well as physical data models specifying appropriate data types and sizes and followed all the naming conventions. Generated ER diagrams, normalized/de-normalized tables. Used forward and reverse engineering to synchronize models and databases.
• Created process models using Data Flow diagrams, Workflow Diagrams and System Interface Diagrams to represent the business processes.
• Conducted meetings with end users to define requirements, documented the requirements.

Environment: Microsoft Access, Erwin

Programmer/Analyst, Confidential, MA Jan 2001 – Jul 2003

• Participated in the logical and physical data modeling using ERwin. The System included user registration and enrollment, utility supply and purchase management, price plan administration, billing, accounts receivables and collections.
• Created logical as well as physical data models specifying appropriate data types and sizes and followed all the naming conventions. Generated ER diagrams, normalized/de-normalized tables.
• Created process models using DFDs, Workflow Diagrams and System Interface Diagrams to represent the business processes.
• Met with end users to define requirements, documented the requirements. Made enhancements to the logical and physical data models following the necessary data modeling standards.
• Documented data model enhancements as well as definitions of all new data model constructs.
• Created mapping matrix for interface systems and reports to correlate data elements on the reports to the underlying tables/fields in the physical data model.
• Performed analysis to identify exceptions and errors in the data.
• Developed stored procedures, database triggers using PL/SQL, wrote SQL*Loader scripts. Performance tuned applications, developed reports using WebDB and PL/SQL stored procedures.

Environment: Oracle 8i, PL/SQL, Erwin, UNIX

Education

• B.Sc., Confidential University,
• Post Graduate Diploma in Systems Management, Confidential