Objective

• Seeking a Senior Programmer Analyst position

• 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.

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

Sr. Application Software Developer, Confidential, Toronto, Canada 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.
• Updated data model as required for CMS tool.
• 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, Toronto, Canada 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, New Zealand 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.
• Created data models and developed stored procedures for the Koru Lounge Application.
• 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 2006

Consultant, Confidential Mae, 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)
(Confidential, 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

• Created 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

Consultant, Confidential, NJ Aug 1999 - Jan 2001

Technical Lead, Confidential, GA (Feb 2000 - Apr 2000)

• Tuned billing processes and screen queries using known techniques and tools including TKPROF/SQL*TRACE, AUTOTRACE, TIMING, EXPLAIN PLAN, hints and other optimizer features for performance.
• Co-ordinated with the DBA on performance tuning, database issues, indexes, and constraints.
• Advised developers on performance issues while coding.
• Executed Load Runs using Maestro to create jobs and schedules.
• Performed Load Analysis using tools such as PerfView and Microsoft Project.

Environment: Oracle 8i

Team Lead, Confidential, PA (Aug 1999 - Jan 2000)

• Designed and developed stored procedures for efficient data access and better performance and extracting data as part of system conversion effort.
• Developed reports (matrix, tabular, master-detail) using Reports 3.0. Used format triggers and GUI interfaces like list boxes. Also used dynamic query parameters in most reports.
• Developed and maintained reports and forms.
• Tuned Forms, Reports and Interfaces.

Environment: Oracle 8i, Developer 2000, Forms 5.0, Reports 3.0

Consultant, Confidential, India Jul 1998 - Aug 1999

Team Lead, Confidential, USA (May 1999 - Aug 1999)

• Validated and verified data mapping documents and source data.
• Created control files to use SQL Loader or used pass-through queries in Access.
• Prepared the Conversion scripts using PL/SQL packages to maintain data integrity.
• Executed testing by identified checkpoints.

Environment: Oracle 7.3, PL/SQL, SQL Server 6.5 and Microsoft Access

Team Lead, Confidential, India (Jul 1998 - May 1999)

• Analyzed, designed, developed, implemented and supported online modules of the Hospital Management System.
• Interacted with users to collect User Requirements and validate functionality.
• Developed DFDs, flowcharts and ER diagrams using Designer 2000.
• Interacted with team members towards the development, testing and debugging of applications.
• Supported research needs with data querying and reporting.
• Prepared and trained the end users.

Environment: Oracle 7.3, PL/SQL and Designer 2000

Programmer, Confidential, India Aug 1997 - Jul 1998

Programmer, Confidential, India Oct 1993 - Jul 1997

Programmer, Confidential, India Jan 1991 - Feb 1993

Programmer, Confidential, India Jun 1989 - Jul 1990

Programmer Jun 1989 - Jul 1998

Worked on various projects such as Production Planning and Inventory Control System, Resume Search System, Sales Order Processing and Invoice Printing, In-House Share Transfer System, Housing Loan Application System, and Hospital DMS and Payroll Systems, amongst others.

• B.Sc.
• Post Graduate Diploma in Systems Management