Summary

• Over 8 experience as a project lead, programmer, forensic examiner, technician and web developer with excellent logical and analytical skills, enthusiastic, self-motivated, quick learner and team player with excellent communication, easy to work with, dedicated and interpersonal skills.
• Excellent working and conceptual knowledge of Oracle, PL/SQL, Developer forms and reports, C/C , Java, UNIX Shell scripting, HTML, SAP R/3 and ABAP.
• Proficient in writing packages, stored procedures, functions, views and database triggers using SQL and PL/SQL in Oracle. Wrote UNIX Shell scripting to wrap SQL and PL/SQL code, scheduled archive process, report generation and generating interfaces files for third party systems.
• Extensive experience in performance tuning and optimization of SQL statements using explain plan, hints, SQL trace, DBMS SQLTRACE and TKProf. Worked with DBA's to re-configure and fine tune the development and test databases, also provided guidance and inputs for configuring production database and DBA's related activities.
• Responsible for the whole software development life cycle activities of the system like debugging, testing, and deploying the applications, reviews of gap analyses, functional requirement documents, creation of technical documents, flow diagrams and related test case documents.
• Debugged, analyzed and fixed the issues found when upgrading from Oracle 9i to Oracle 10g and played a key role in production support by performing tests, trouble shooting, bug fixing and scheduling jobs to automate application execution in integrated systems environment.
• Designed, developed and enhanced developer forms and reports as per business functional requirements.
• Understanding and applying of managerial concepts and techniques in areas such as work planning, project management, delegating, coaching, mentoring and evaluating.

Technical Skills

• Operating systems : Windows 98/XP/NT/2000, UNIX, Linux, and Sun Solaris 7.
• Programming Language : PL/SQL, Oracle SQL PLUS, COBOL, C/C , Visual Basic 6.0, Java,
• ABAP /4 and HTML.
• ERP : SAP R/3 4.6C
• Databases : ORACLE 8, 8i, 9i, 10g, MS-Access.
• SQL Utilities : SQL Loader, TKPROF.
• GUI Tool : Oracle Forms and Reports 6i.
• Other Tools : MS-Office, MS-Visio, SQL Navigator, TOAD, Rational Rose, Livelink,
• Migrate Util, Clear Case, MS-Visual Source Safe, Crystal Reports,
• Mercury Test Director, Autosys, UWCC and MS-Share Point Server.

Professional experience

Confidential

Role: Oracle PL/SQL Developer/Programmer

Responsibilities:

• Interacted with client in Agile and supervised in preparation of the technical documentation.
• Generated SQL and PL/SQL scripts to populate datamart on top of the ware house.
• Wrote SP Transformation for different work flows in the ETL processes.
• Enhanced created database objects like tables, views, sequences, synonyms, indexes.
• Extensively worked on Nested Tables, Varrays and PL/SQL records.
• Created Cursors and Ref Cursors to process the required data.
• Used Bulk Collect and FOR ALL to DML multi-row from table.
• Created interactive reports with constraints in APEX for users to manipulate the actual tables in DB.
• Loaded data from various databases using SQL LOADER utility.
• Created UNIX shell scripts and scheduled Cron jobs.
• Modified the Perl Scripts to feed the CGI Scripts which flash the processed data on Web.
• Testing and debugging the existing Procedures, Packages and Reports
• Assisted in documentation for DevTech Approach, UseCase Spec, Effort Estimation and Design Doc.
• Created RPX reports, Stored Procs, Functions, and Packages as per the business need.
• Created automated and manual scripts for satisfying the testing purpose.
• Drill down the root cause of slow running processes provided suitable performance technique.
• Used Oracle packages - DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL MAIL.
• Wrote Dev Test Plan, Design Doc Code Review Doc as part of project deliverable.

Environment: Oracle 11g, IBM AIX 7.1, SQL, PL/SQL, UNIX, MS Office Visio, TOAD 10.6, Putty Beta 0.63, Erwin 8, RPX Report 10g, Oracle APEX 4.2.3, C 11, Rally For Agile, Trizetto's 4.7, WinSCP 5.1

Confidential

Role: Database Developer/Programmer

Responsibilities:

• Was involved in fast paced AGILE Environment.
• Prepared tech documentation for easy understanding by other developers.
• Created stored procedures, packages, generated triggers for security purposes using TOAD.
• Used Wrappers for data security which encrypts the PL/SQL code hide the customer information .
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Created the Temp tables in the stored procedure for different applications.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS.
• Loaded data from flat files into Database using SQL loader.
• Created Unix Shell Scripts for automating the execution process.
• Used DBMS SCHEDULER package for job scheduling.
• Created XML supported document.
• Fine tuned the Java embedded SQL PLSQL.
• Worked on Web application development with APEX.
• Involved in Unit testing, Integration test and writing the Test plan.
• Trained end users on the functionality and operability of the application.

Environment: Oracle 11g, Solaris 5.8, PL/SQL, SQL PLUS 9.2.0.3, TOAD 10.6, SQL Developer 3.1, Oracle Enterprise Manager, HTML 5, Mercury Test Director 9, UML 2.3, MS Visio 2010, Data Stage 8.1.

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Collaborated with management, business units and technical team for gap analysis and gather business requirements to program a system in an effort to maintain a consistent yet flexible architecture.
• Analyzed the existing design re-architect, reverse engineered and re-design data model from existing solution written in Oracle 7 into Oracle 10g that increased efficiency and stability to accelerated production support.
• Responsible for the whole development life cycle activities of the system like client discussions for purposed solution, user acceptance testing, preparation of technical documentation, data flow diagram, business process diagram, chain flow diagrams and flowcharts.
• Debugged, analyzed and fixed the issue found when upgrading from Oracle 9i to Oracle 10g and assisted in production support on an on-going/as-needed basis.
• Analyzed the existing Access system and re-designed it in Oracle 10g by developing data validation and load processes using PL/SQL, stored procedures, functions and triggers to enhance and improve functionality requested by business for reducing their manual processing time.
• Involved in technical analysis of specifications, identification and normalization of data, database setup, optimization and performance tuning to ensure faster response time of data.
• Analyzed, monitoring and modified day-to-day operations on Oracle database and client side code by fine tuning indexes, partitions, tables and SQL statements to improve the performance and enhance parallel processing.
• Responsible for migrating and releasing scripts into different environments along with maintaining and managing the version controlling in Microsoft visual source safe.
• Translation of business requirements into technical design specifications, creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures as per customer requirement to new and existing solutions.
• Involved in data migration and conversion utilizing Oracle utilities such as Oracle SQL Loader, Export/Import and Oracle Data Pump.
• Primarily responsible to monitor and maintain batch jobs and resolve and fix production issues.
• Tested user interface screen-by-screen, Organized and developed training materials and conducted workshops to deliver training to the business users.
• Developed and modified UNIX scripts to wrap PL/SQL code, FTP files, send emails, automate batch processing and upload data.
• Involved in various activities like analysis, database design, performance tuning, batch monitoring, batch redesign, code standardization and documentation.
• Created control files, external tables and used SQL Loader to upload bulk data into Oracle tables.

Environment: Oracle 9i, 10g, Windows 2000/XP, SQL Navigator 5, F-Secure client 5.3 build 25, MS-Visual Source Safe, Clear Case, Migrate Util, e Gate, SQL Loader, UNIX, Shell Scripting, MS-Share Point Server, Livelink, Mercury Test Director and Autosys.

Confidential

Role: Oracle PL/SQL Developer/BA

Responsibilities:

• Creation of stored procedures and embedding of HTML and Java script in PL/SQL program units using HTP package.
• Involved in rebuilding the CSQ website using server-side includes SSI .
• Translated business requirements into technical design specifications.
• Used export/import utility, control files, SQL Loader, SQL plus Copy command and external tables for loading data from different data source into Oracle tables.
• Played a key role in trouble shooting issues affecting production and new development.
• Developed and modified the existing PL/SQL stored procedures, functions, triggers and partitioned tables for better performance and enhanced parallel processing.
• Designed reports output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Involved in database design and monitoring, analysis, code standardization, documentation and performance tuning.
• Developed UNIX scripts to create FTP Jobs, sending notification, distributing reports and data files.
• Used Oracle Metalink for problem resolution and raising TAR.

Environment: Oracle 8i, Oracle forms and report 6i, Oracle Web Server, Metalink, HTML, JavaScript, UNIX and Shell Scripting.

Confidential

Role: Programmer/Developer

Responsibilities:

• Responsible for coding, testing and maintaining Oracle PL/SQL code. Involved in database design, performance tuning, code standardization, and day-to-day activities on Oracle database for better performance in processing time of SQL and PL/SQL statements.
• Used Crystal Reports to create various business reports.
• Developed Master/Detail forms and reports as per business specification requirement.
• Created MDI and business applications by developing parent child menus, ActiveX controls, data controls, OLE objects and data access objects.
• Queried the Oracle database through packages to fetch database records into VB applications and also enhanced the report performance by optimizing queries of the backend PL/SQL code.

Environment: Oracle 8i, Oracle Forms and Reports 6i, Windows NT, Visual Basic 6, Crystal Reports.