SUMMARY

• Over Twelve years of experience in various phases of software development life cycle, including Designing, Development and Testing of business applications using Oracle 8i/9i/10g/11g.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Proficient in backend programming using PL/SQL and SQL, C, C++, C#. Experienced writing interfaces, triggers, stored procedures and PL/SQL packages to provide database access and manipulate functionality. Created PL/SQL procedures, packages, functions, database triggers and other database objects to generate back end and front - end reports.
• Experience in Application Development using Forms, Reports, Discoverer and Visual Basic.
• Experience in Oracle Application Server 10g administration and installation.
• Extensive knowledge in design and modeling database-using Designer/2000.
• Designed and developed various applications using oracle products/tools for process automations software into database server using, PL/SQL packages, procedures and database triggers based on client/server and multi-tier technologies.
• Experience in using SQL *Loader and External Tables for Export/Import of data and Quest tools (TOAD, Navigator) under UNIX and Windows NT.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Experience in Performance Tuning & Optimization of SQL statements.
• Excellent logical and analytical skills, interpersonal & communication skills and strong ability to perform as part of a team.
• Experience in Shell Scripting, manipulating and managing XML data.
• Experience working on Servers like Solaris and AIX.

TECHNICAL SKILLS

Oracle Tools: PL/SQL Developer, SQL Navigator, SQL*Plus, Reports Builder 9i/10g/11g, Forms Builder 9i/10g/11g, Oracle Discoverer, SQL Loader

Databases: Oracle 11g/10g/9i, Microsoft Access

Programming: PL/SQL, Java, Visual Basic, c, c++, c#, Python

Web Technologies: HTML, XML, CSS, DHTML, VBScript, JavaScript

SCM Tools: SVN, GIT

Operating Systems: UNIX, Linux, Windows 7/XP/2000/NT Toad, Putty, QA Complete, JIRA

PROFESSIONAL EXPERIENCE

Confidential, - Columbus, OH

Programmer Analyst

Responsibilities:

• Analysed the business requirements of the project by going through both Technical and Functional Documents, meeting with managers and users responsible for providing their requirements.
• Creation or Modification of database objects like Tables, Views, Materialized views, Procedures, Packages, Functions, Records and Collections
• Performance tuning and Optimization of Existing SQL Code by using Hints, Advanced Functions etc.
• Creation of New or modification of existing Forms using Oracle Forms 10g.
• Creation of New or Modification of existing Reports using Oracle reports 10g .
• Creation of New .csv Reports and schedule them to run automatically.
• Research Existing Packages, Procedures and find ways to modify them for better performance.
• Prepare Technical Documentation for all the work done.
• Work closely with QA testers and make sure all employees working on the project are on the same page.
• Monitor Job Schedules and support 24*7 support in case of any failures.
• Design Mapping Documents to load External Data into Oracle Database, automate the loading process.

Environment: SQL, PL/SQL, Oracle 10g, SQL Developer, SQL Navigator, SQL*Plus, SQL*LOADER, Reports 10g, Forms 10g.

Confidential, PA

Systems Analyst

Responsibilities:

• Analysed the business requirements of the project by going through the Existing FoxPro application and meeting with managers and users responsible for providing their requirements.
• Supporting the project from analysis, development, testing and implementation.
• Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Prepared program specifications for PL/SQL Procedures and Functions to do the conversion.
• Designed the front-end interface for the users, using Forms 10g.
• Designed Web application for HVN using .NET technologies and Visual Basic.
• Created Hierarchical Tree forms by customizing the built-in Packages.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader .
• Knowledge in Performance Tuning using SQL Trace and TKPROF .
• Developed both paper and web-based reports using Oracle Reports 10g.
• Assisted peers in Development of Food Grading and reporting application using Visual Basic .NET
• Design of User Interface forms for reports to provide user with a selection criterion.
• Built Triggers to handle various parameters of the Interface form in Reports.
• Worked on enhancing both paper and web-based reports to have dynamic parameter form, conditional formatting at the Group or Field Level and adding charts.
• Developed number of Reports using Reports 10g with varying complexity from standard tabular reports, form reports, group by reports, mailing label reports and Matrix reports. Created Custom Report templates.
• Deployed Oracle Reports into the web using Oracle Reports Server
• Created business area, new custom folders, complex folders, summary folder, hierarchies, item classes and list of values using Discoverer 10g.
• Administration of Oracle Application Server 10g .
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan.

Environment: SQL, PL/SQL, Oracle 10g, Toad 8.5, SQL*Plus, SQL*LOADER, Reports 10g, Forms 10g, Discoverer 10g.