SUMMARY

• 13 years of qualitative experience in Telecom and Banking Domain
• Proficient working experience with SQL, PL/SQL Stored Procedures, Functions, Packages, Database triggers
• Analyzed tables and indexes forCost Based Optimization(CBO)for improving performance and work efficiently.
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Extensive experience in developing UNIX Shell scripts
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints and Table partitioning
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL Trace, Tkprof, Oracle hints, DBMS STATS.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Loader, PL/SQL Developer, SQL Developer, External tables and UTL FILE.
• Expertise in Designing Tables Structures, Views, Constraints, Indexes (B Tree, Bitmap and Function Based).
• Performed data Extraction, Transformation, and loading (ETL) from various sources into Data Warehouses.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star and Snowflake schema.
• Good knowledge on Oracle Golden Gate
• Experience with Software Development Life Cycle (SDLC) process, performing detailed analysis, collecting requirement, coding and unit testing, integration and system testing.
• Experience with Client interaction, adherence to client specifications, system enhancements, understanding business data flow, data relations and production system support.
• Experienced in debugging the code and data analysis for various reporting purpose

TECHNICAL SKILLS

Languages: Oracle SQL, Oracle PL/SQL, DB2, UNIX Shell Scripting

Database: Oracle 8i/9i/11g/12c, DB2 9.7 LUW

Tools: TOAD, PL/SQL Developer, Putty, IBM’s Info sphere Design Studio

OS: Unix/Linux, Windows XP/NT/2000

Billing Systems: Arbor Kenan BP

Appliance: IBM Smart Analytics System (iSAS)

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Responsible for giving authorized access to business to view the data based on their roles.
• Created PL/SQL packages to send and receive data from UI using Table Types and Refcursors.
• Interacted with clients during UAT and handled the issues/code fixes on time.
• Provided KT to Support team within the Warranty about the enhancements or fixes that are moved to Production.
• Involved in scheduling jobs in Autosys.
• Works independently to develop, configure, code and test programs from specifications.
• Generated DDL scripts for all database objects like packages, tables, sequences, synonyms, indexes and granting privileges.
• Responsible for migration of code and objects to IT/UAT/PROD environments and maintaining them in GIT Repository
• Followed the process of creating CRs to fix the code in Production

Environment: Oracle 11g, SQL Developer 20.4, Help Central Incident Tool

Confidential

Responsibilities:

• Creating PL/SQL Packages, Stored Procedures, Functions, Cursor and Triggers to implement the Business Logic.
• Created Test environment for data staging using SQL and PL/SQL scripts and optimized critical queries to eliminate Full Table scans and reduce Disk I/O.
• Optimize SQL queries for better performance. Tuning of Oracle stored procedures and developed business logic in database layer using PL/SQL.
• Performance tuned multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.
• Performs technical tasks including estimating, analysis, technical requirements, design, constructions and Unit testing
• Integration testing and UAT testing following Production release code maintenances and support.
• Involved in exhaustive Performance Tuning using Explain Plan, Monitoring and Optimization of PL/SQL blocks
• Batch frame work process in both Development and Production environment for Oracle.
• Handling UNIX/Linux server Oracle database via connecting Putty. Pulling file NAS location to local using WinSCP.
• Works independently to develop, configure, code and test programs from specifications.
• Proficiently developed Design documents (HLD and LLD), Unit Test Cases (UTS) and project documentation (user guides, run book, standard report instructions, demos).
• Analyzed Oracle Objects and Creating Partitions and Compress Tables for very large tables in Production to reduce disk contention and improve performance.
• Generated DDL scripts for new database objects like tables, views, sequences, synonyms, indexes, CDC table and granting privileges.

Environment: Oracle 11g, UNIX, SQL, PL/SQL, UNIX shell script, Toad 12.6, SQL * Plus, PL/SQL Developer, SQL * Loader

Confidential

Responsibilities:

• Importing and exporting the schemas using Datapump and maintained schema objects.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Wrote PL/SQL scripts for bulk data upload, data analysis and correction.
• Automatic email generation was used to monitor various back - end processes.
• Loading the data from large files into Oracle tables using SQL*Loader, PL/SQL.
• Responsible for creating Control files for SQL*Loader.
• Worked on mapping Entities in Siebel to EIM tables.
• Provided better solutions for data migration and incremental loads.
• Creation of Staging Tables for all the entities that needs to be migrated.
• Reviewing PLSQL Packages, Procedures and Control Files for the data population into EIM tables.
• Preparation of IFB files for EIM tasks.
• Performance tuning at PLSQL scripts and IFB’s.
• Responsible for validating the loaded data by cross checking with the source system.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Wrote SQL queries for business teams for reconciliation purpose.
• Developed shell Scripts to automate the Load process.

Environment: Oracle 11g, UNIX, SQL, PL/SQL, UNIX shell script, Toad 12.6, Siebel EIM

Confidential

Responsibilities:

• Responsible for writing PL/SQL Packages, Functions, Procedures and cursors.
• Responsible for creating the Dynamic SQL to load the Data.
• Experienced in Performance Tuning of poor SQL and PLSQL Procedures with the help of Explain Plan and Oracle Optimizer Hints.
• Developed Triggers on tables and handled Mutating errors with the help of PRAGMA AUTONOMOUS Transaction.
• Developed Views, Materialized Views based on the requirement and refreshed them periodically with the help of DBMS Mview.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Experienced in using Oracle Exceptions like SQL Err and SQL MSG to handle exceptions with error number and error messages.
• Developed Various SQL Scripts for Automation Process and AD Hoc Report Generation Process.
• Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN, TKPROF.
• Worked with Business team to gather the requirements.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Generated CSV Files with the help of UTL PACKAGES and placed them into FTP Location.
• Automated routine tasks using shell scripts and created various Shell and SQL scripts according to the Client requirements
• Coordinated and supported the Business users and QA team during UAT (User Acceptance Testing)

Environment: Oracle 11g, UNIX, SQL, PL/SQL, UNIX shell script, Toad 12.6, Clearcase

Confidential

Responsibilities:

• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Hands on experience with oracle Export and Import Utility tools to migrate data through different environments.
• Worked on interfaces in Inventory module
• Developed shell Scripts to automate the Load process.
• Performed Unit and Integration Testing on Interface programs and all the reports developed to maintain consistency and efficiency to meet the user requirement.
• Involved in migration of developed AOL and Non-AOL objects to test and production servers Handled Kintana tool for code migration.
• Kintana tool is a part of HP Portfolio and Project Management
• Coordinated and supported the Business users during CAT (Customer Acceptance Testing) and worked on defects in the developed components

Environment: Oracle 11g, UNIX, SQL, PL/SQL, UNIX shell script, Toad 12.6, Clearcase, Kintana, Oracle E-Business Suite (R12)

Confidential

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Created new database objects like tables, Indexes, Views using DB2 SQL in Development and Production environment.
• Involved with the Performance tuning, Optimization of queries and standardization of the code.
• Used Built in packages like UTL FILE to read the data from flat files and load them into their respective tables
• Developed shell scripts to alert users in the event of failures, to automate jobs and also to perform file extraction/data loading
• Experienced in Handling Exceptions in procedures using Pre defined exception handlers and DML Error Logging techniques.
• Developed Various SQL Scripts for Automation Process and AD Hoc Report Generation Process.
• Responsible for Requirements gathering from the Customer/Business team, also documented the user guide for the system
• Performed technical reviews of code and data for CRs and ARs as well as functional reviews
• Expertise in scheduling and monitoring the jobs in CronTab
• Developed ETL workflows and control flows and deployed them using Design Studio

Environment: Linux, DB2 9.7 SQL/PL, IBM’s Infosphere Design Studio 9.7 ETL, DB2 Command Editor, Command Line Processor, Kenan Billing Product

Confidential

Responsibilities:

• Designed and developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used exception handlers to handle exceptions like no data found, too many rows, dup val on index
• Extract data into Oracle table using SQL Loader and optimized SQL queries for better performance
• Responsible for data analysis, development of SQL, PL/SQL, Shell Script to fix migration issues
• Participated in Debugging critical Production issues by working as a Team.
• Providing fixes and ensuring that adopted fix does not lead to recurrence of the issue
• Ensuring that, the data is always in sync for the applications under consideration
• Identifying the root cause of the issues and rectifying them in collaboration with the concerned teams
• Mentored and assisted new team members as per the requirements

Environment: Kenan Billing Product, Oracle 9i, SQL, PL/SQL, SQL*Loader, Shell script, TOAD 9.5

Confidential

Responsibilities:

• Created and used DB-Links to connect to other local databases
• Developed database objects like Tables, Views, Indexes, synonyms and sequences.
• Involved in importing flat files into Database and validated the data using PL/SQL procedures.
• Handled different errors using Exception handling.
• Loading data through SQL * Loader and UTL FILE.
• Identified, designed and developed oracle PL/SQL stored procedures, Packages, functions, database triggers.
• Importing data from flat files and Excel sheets to Oracle
• Ensuring data integration with all the corresponding modules co-related to billing
• Identifying the root cause for various error cases and coordinated with the Development Team for a permanent fix, ensuring the highest standards of quality
• Providing quick resolution to the billing errors so as to ensure zero loss of revenue to the client

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Shell script, TOAD 9.5, Kenan Billing

Confidential

Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Created database triggers to validate complex integrity.
• PL/SQL Procedures, functions, cursors, triggers and packages were created using TOAD.
• Used Control Structures like IF, CASE, FOR, and WHILE Loops for standard PL/SQL programming.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Responsible for processing raw CDRs in to system readable format
• Conversion of augmented CDRs to Billing formats
• Developed unit test cases and involved in unit testing
• Involved in preparing design documents like High level and Functional Requirements Specification
• Provided hands on support to users and documented the change requests and submitted to change control team

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, Shell script, TOAD 8