EXPERIENCE SUMMARY:

• 10 years of extensive experience in IT industry mainly in Oracle SQL, PL/SQL, UNIX Shell Scripting
• Oracle Certified Associate 9i
• Expertise in Software Development Life Cycle(SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
• Experience in Waterfall and SCRUM agile methodologies.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i database.
• Good experience in technical documentation and status report preparation.
• Good experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Worked with Collections, Records, Dynamic SQL and Exception Handling.
• Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQL trace and TKPROF.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
• Automating data loading, extraction, reports generation using UNIX Shell scripting.
• Experience in handling very large data files using Export - Import Utilities and SQL*Loader.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production.
• Good understanding of Data modeling concepts like ER Diagrams, Normalization and De-normalization of Tables.

TECHNICAL SKILLS:

Languages: Oracle PL/SQL, SQL, UNIX Shell Script

Operating Systems: UNIX Solaris, HP-UX, AIX, Windows XP

Databases: Oracle 11g / 10g (2) / 9i

Tools: and Software:TOAD, SQL Developer, Control M, Autosys, Crystal Reports 9, Digital

Other Software Tools: Autosys, Ctrl-M, MS Visio 2007, Crystal Reports 9.0

Familiar With: C++, Core Java, Object Oriented Programming

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Developer

Responsibilities:

• Worked as part of the team following SCRUM-Agile methodology.
• Building package which upon execution, generates number of packages with the same line of code but for the different entities.
• Building Meta data for the Package generator package.
• Use of string building and appending functionalities to form code generator statements.
• Use of dynamic sql to execute and create the oracle objects.
• Worked on writing Test scripts which test the data between the two database instances upon refresh from Oracle Golden Gate gateway which helps syncing the two instances by tracking the differences between them
• Writing the Views and Test scripts which validate the changes reflected into the system.
• Writing string operating pipelined functions to return the different result sets containing record primary keys and operation done the records which required being stored in a tabular format for the records which get inserted, updated or deleted.
• Writing Procedures inside stored procedure to call the different Test execution scripts.
• Checking the performance of the data validation and data reflection scripts against the actual data load on production environment.

Environment: Oracle 11g SQL/PL-SQL, Sql*Loader, Oracle 12C Golden Gate, SqlDeveloper, Tortoise SubVersion

Confidential

Lead / Sr. Oracle Developer

Responsibilities:

• Used SQL*loader to load the input files from various external systems into the database staging tables and storing it for further processing.
• Developing the Inbound interfaces using Packages, procedures and supporting functions which work on the data loaded through files according to the business logic implemented.
• Developing Outbound interfaces using Packages which generate the required files and data for the external systems.
• Developing Stored Procedures which are scheduled to run at certain intervals to capture master data changes like, business group changes, products and categories changes, product merge scenarios and reflecting into the SOLA applications.
• Developing Unix shell scripts (Bourn Shell) which control the sequence of operations of
• Calling SQL*Loader Utility to load the data from the flat files provided by external systems and saved at specific locations
• Calling Packages / Stored Procedures which perform the business operations on the raw data provided by the external systems.
• Sending the files generated by the outbound interfaces to the external systems servers.
• Shell scripts are scheduled through Ctrl M utility and dependencies of programs over each other are maintained through it.
• Used features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records..
• Created DB links to establish Materialized Views on external database tables.
• Usage of Analytical and aggregation SQL functions.
• Applying SQL query and PL/SQL performance tuning techniques like Views, temporary tables, DE normalization, selective indexes, hints, pipelined functions, advanced PL/SQL features like pipelined functions and bulk operations to select and process data in large tables.
• Creation of Triggers to maintain audit log/data validation, used flashback utility to restore the table replicas.
• Implementing an effective error pin-pointing mechanism using utility package’s format Error backtrace feature and maintaining error-logs which are sent to users at the end of the day through an Email attachment which also suggest the course of action to be taken by User in case of occurrences of the errors.
• Used Oracle UTL FILE and UTL SMTP UTL MAIL generation functionalities.
• Active participation in release, deployment, Data migration and Production Cut-Over activities work.
• Developed Validation SQL Queries as part of the programs Unit Testing.
• Coordinating with DBA team for the system requirements and to request AWR reports to check system loads
• Coordinating with CTRL-M team to stop, start and changing the order of the cycle of interfaces and jobs to be run depending on the situations.
• Fixing production issues reported by production support team and minimizing the chances of re-occurrences by finding out the root cause.
• Used Microsoft Team Foundation Server for application life cycle management and code version control.

Environment: Oracle Database 11g SQL, PLSQL, Sql*loader, TOAD, SqlDeveloper, Windows 7, UNIX, Toad, UNIX Bash/Korn Scripting, Microsoft TFS, WinSCP, Putty, MS-Visio

Confidential

Sr Oracle Developer / System Analyst

Responsibilities:

• Worked as part of the team of 8 people.
• Practiced SCRUM - Agile methodology for the project.
• Gathering requirements from the Product Owners, picking up Story points and giving the estimates for work completion.
• Was involved in data modelling and table layout changes activities.
• Writing database code modules through Packages, stored Procedures and calling them through PRO*C programs.
• Writing C and PRO*C programs to decode and convert files in the different formats at various workflow stages.
• Writing Triggers for auditing and recording the various levels of Alarms which are the important signals that control the application to take necessary measures in terms of file generations and flows at various stages.
• Writing background packages and stored procedures which are called through the front running Pro*C programs.
• Extensive usage of TOAD for PL/SQL development.
• Maintaining Database Locking mechanisms to control the sequences of operations being performed by the Spawning of Unix processes which are running concurrently.
• Writing SQLs in Pro*C programs and tuning them to efficiently run against multiple tables and process huge data.
• Used features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records..
• Generating High Usage reports and providing the weekly / monthly reports of the call records details and automatically sending them through UNIX scripts which are scheduled through Autosys.
• Using Subversion to maintain various libraries and code modules.
• Solving production support tickets and providing on call support for the services and solving data inconsistency and other issues as part of a “80 Tickets” program.

Environment: Oracle Database 9i / 10g (2), Windows 7, C, PRO*C, UNIX (Solaris), Toad, SQL, PLSQL, UNIX SH /KORN Scripting, WinSCP, Putty, MS-Visio

Confidential

C, UNIX, Linux Developer

Responsibilities:

• Analyzing the code written in C on HP-UX for the changes to be made as required for Linux environment
• Moving the code on Linux environment.
• Changing the Makefiles as per the compiling options available in Linux.
• Changing the C code written on UNIX environment to Linux environment.
• Compiling the code.
• Analyzing the error logs and making the changes to fix and compile.
• Running the module and checking the Run time and correct results.
• Checking the code in Clear Case version control system
• Documenting the changes made from the source code to new destination code.

Environment: C, UNIX HP-UX, Linux, Clear Case.

Confidential

Oracle Developer

Responsibilities:

• Worked as part of Crystal reports development team.
• Building optimized SQL queries to suit the report requirements from multiple tables.
• Used ODBC connecting drivers to connect to the database
• Crystal Reports 9, SQL topics like floor function, temp tables and case SQL statements were utilized.
• Mapping the DB fields on the Crystal report pages
• Building Sub reports and passing data through variables to Main reports
• Building formulae and sub queries behind the mapped fields and sections as per the report complexities.
• Reports testing and quality assurance.
• Enhancements of existing reports as per the new business requirements.

Environment: Oracle Database 8i, Crystal Reports 9, Toad

Confidential

UNIX, Oracle Developer

Responsibilities:

• Working as part of 24/7 production support environment
• Monitoring the UNIX shell scripts running through Autosys and take necessary action in case of glitches.
• Developing new Shell Scripts (Korn Shell) for file movement or text operations on files.
• Interacting with SMEs (Subject Matter Experts) on the system performance and new changes
• Gather and analyze new requirements from SMEs.
• Making changes or implementing new requirements in .SQL files and executing them through Unix Shell Scripts.
• Solving production issues and addressing the tickets raised against various issues.
• Analyzing and providing new solutions against the production tickets on priority basis.

Environment: Oracle Database 8i, UNIX Shell Scripting