Sr. Programmer Analyst Resume

SUMMARY:

Dynamic, results oriented and hands - on IT specialist with strong delivery focus and over 16 years of extensive business and technology experience of creating technological solutions for complex business requirements.
Deep knowledge of corporate financial statements/balance sheets/profit and loss structure, well versed with multiple Development Frameworks, SDLC processes, extensive experience of creating complex business requirements, functional and technical documents.
Extensive programming experience as an Oracle Developer in Analysis, Design, Data Modeling, and Development of client/server and multi tired applications using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL, Oracle Developer Forms and Reports.
Good experience of Performance Analysis and SQL query tuning.
Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, Dynamic SQL, cursors, collections, Ref cursors. Tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms.
Extensive experience in Oracle Forms 11g/Reports 11g
Excellent conceptual knowledge of Oracle 10g/11g/12c, PL/SQL and SQL.
Experience in query optimization, performance and tuning using SQL Trace, Explain Plan, Indexing, Hints, Creation of Global Temporary Tables, and Table partitioning.
Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
Keen focus on performance tuning, testing, and quality assurance.
Collaborate well with project management, business analysts, and department management teams.
Strong analytical and problem solving abilities, proficient at identifying and resolving technical problems.
Excellent communication, organizational, and interpersonal skills.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C#, HTML, XML, COBOL

RDBMS: Oracle 11g/10g/9i/8i, DB2

Oracle Utilities: SQL Plus, SQL Loader, SQL Developer, PL/SQL Developer, TOAD

GUI Tools: Oracle Developer Forms 11g/10g/9i/6i, Oracle Developer Reports 11g/10g/9i/6i

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Programmer Analyst

Responsibilities:

Worked on creating complex business requirements, system architecture, designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
Created complex relational database queries/SQL, dynamic SQL.
Built physical data structures like tables, views, constraints & Indexes.
Translated business requirements and software design specifications into Oracle Forms applications.
Designed Oracle Forms/Reports 10g/9i/6i for complex projects.
Participated in System conversion from Oracle Forms environment to ASP.Net.
Conducted unit testing of applications prior to release for user acceptance testing.
Supported members of the testing team through user acceptance testing and pre-production testing.
Prepared applications for release to test, pre-production and production environments.
Researched and resolved production problems, dealt with end users and hosting sites to resolve issues.
Acted as a Confidential for customers and the Project Management Office (PMO).
Provided technical support to end users and other developers.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship