SUMMARY

• Versatile and has work experience of 12 Years 2 Months, in the Information Technology industry, in Database related technologies, design and traditional lifecycles. Adept at leading teams and working with business stakeholders. Experience working with globally dispersed teams with specialization in Confidential
• 12 plus years of strong experience in Oracle (8i / 9i/10g/11g) with UNIX environment. Extensive knowledge in design and development of stored procedures / functions / Packages / database triggers. Tuning queries for higher performance (Using Hints, HWM concepts, explain Plan, Tkprof, row - chaining concepts etc). Expertise in different DDL / DML / TCL commands.
• Involved in system study, analysis, design, coding, testing and debugging of software, implementation and training for users.
• Extensive Experience in back end development including Database design, complex stored procedure, Database triggers, functions packages, views, materialized views( using Complete, fast and force refresh), Database links, Partitions, indexes, Synonyms, Dynamic SQL, Merge using ORACLE SQL and PL/SQL.
• Used collections and bulk insert with records, PL/SQL Table, nested table, varrays and bulk collect and forall concepts.
• Extensive use of In-line Views, scalar queries and analytical functions (like row number, lead, lag, max, avg, sum etc).
• Used hierarchical query using connect by prior, CONNECT BY ISCYCLE, SYS CONNECT BY PATH. Also used as recursive function.
• Used Autonomous Transaction for force commit during skipping the oracle exceptions and continue the program.
• Implementation of new 10g features like dense rank, model, nested table (MULTISET UNION, intersect, SUBMULTISET), setting PLSQL WARNINGS, utl mail, recyclebin etc.
• Data Warehouse with extensive experience in developing and testing applications using Oracle.
• In-depth understanding of Oracle architecture, memory and process structures.
• Experienced in writing unit tests for PL/SQL code.
• Strong knowledge in advanced PL/SQL techniques like Cursor management, Exception Handling, Collections like REF Cursors, Sys refcursor, PL/SQL Tables and extensively involved in performance tuning in oracle using Explain plan, Optimization Hints, TKPROF.
• Good work experience in client server architecture
• Analyzing the system performance periodically and work on the showstoppers to automate/streamline thereby reducing the downtime of the applications
• Imparting knowledge to the team and setting up processes to create knowledge pools on the issues faced and methodology used to resolve - Known Error database
• Implementing disaster recovery plans for applications to avoid downtime due to unforeseen issues
• Incident Management, Problem Management and Release Management experience

TECHNICAL SKILLS

RDBMS: Oracle 9i, Oracle 11g, Q DB(exposure)

Languages: MOD PL/SQL, PL/SQL, HTML, JavaScript, C, Pro*C, Shell Script, Perl Script, Q/K++ scripting(exposure) and Q/K++ DB

Tools: SQL Loader, ITRS, Autosys, TOAD, PL/SQL Developer, Informatica, ITRS Geneos, JIRA

Operating Systems: Windows NT/95/98/2000/ME/XP, UNIX/LINUX

Tools: /Utilities: MS Office, MS Excel, MS Visio

PROFESSIONAL EXPERIENCE:

Oracle/PL/SQL Developer

Confidential, NV

Responsibilities:

• Analyze the functional specifications provided by the business analysts, interact with the BAs and development managers to incorporate them into Design Specifications to be implemented into coding
• Come up with design architecture where required for development of new modules and enhancement of new modules in the business process
• Identifying and resolving bugs/errors as stated by Functional specifications, subject them to extensive unit testing, by writing test cases
• Improve performance of existing modules by applying performance tuning methodology, implementation and testing of the same using the technical expertise
• Coding according to Design specifications, following the coding standards and implementing it as per Software Development Life cycle, by unit testing, development review, QA testing, writing build scripts with instructions for deployment into production environment
• Updating the flow and timeline of work in the SDLC management tool aka footprints for tracking

Environment: Oracle 11g/Mod Pl/Sql, HTML, CSS, javascript, Unix

Oracle/PL/SQL Developer

Confidential

Responsibilities:

• Technical lead and support delivery manager delivering on data ware housing applications and SME in Oracle, PL/SQL, Shell Script, Perl Script
• Involved in SQL query tuning to maximize the performance
• Good work experience in client server architecture
• Analyzing the system performance periodically and work on the showstoppers thereby reducing the downtime of the applications
• Managed “Run the bank” team for ETD - Electronic Trading Data, day-to-day activity includes attending to SOD Calls, planning rotation for members in the team, incident management, release management
• Implementation of ITRS/Geneos for ETD applications. ITRS is a monitoring tool used widely in the finance sector for better monitoring of production processes

Environment: Oracle 11g/Pl/Sql, Unix, Shell Script

Oracle/PL/SQL Developer

Confidential

Responsibilities:

• Development and maintenance of Xerox, Royal AHOLD and General Motors applications during my stay at EDS
• Maintenance of Order Status connection tool for XEROX corporation
• Maintenance of large pool of customer data for Xerox. This helps in knowing Xerox’s potential business customer and it’s growth
• Category Management Applications: Maintaining large volume of sales movement data for the retail giant - AHOLD, using SQL loader, minimizing the turnaround time to retrieve the data by optimizing queries to pass the data to front end screens
• Vehicle Order Management Systems: Processing large volume of vehicle specifications, order management, order generation data using shell script and Oracle

Environment: Oracle 9i/Pl/Sql, Unix, Shell Script, Pro*C

Oracle/PL/SQL Developer

Confidential

Responsibilities:

• Oracle 6 - Forms to Pro*C conversion for Citibank India - a migration project involved in creating the front end screens in Pro*C and Oracle 7
• Design, coding, testing and implementation of Authorization module in Credit Cards for Pocket Money Card
• Was instrumental in converting the Diners card policies to flexible parameters that can be stored/changed/altered in the DB tables, thereby reducing the amount of time involved in code releases when there are policy changes
• Built module to authorize transactions received through mobile interface for Citibank credit cards
• Implementation of Citibank World money card and Rupee card, which created great demand in the market for the product
• Implementation of pre-requests automation and reward redemption through Electronic Data Capture machine
• Came up with table partitioning for history tables and archived them for better performance of authorization modules which is time critical

Environment: Oracle 8/Pl/Sql, Unix, Pro*C