PROFESSIONAL SUMMARY:

• Over 10+ years of IT experience in Analysis, design, development, testing and implementation of IT solutions using UNIX shell scripting, Oracle and PL/SQL.
• Extensive working experience in UNIX shell scripting.
• Experience in UNIX shell programming, file transfer Utilities like FTP, SFTP and job scheduling using UNIX Cron.
• Extensive working experience in Oracle Database (12c/11g/10g/9i).SQL Server 2008, SQL, PL/SQL, Stored Procedures, Functions, cursors (Implicit, Explicit, REF), Constraints, Triggers, Indexes, Views, Synonyms Materialized Views, SQL Loader.
• Developed New Batch scripts for validations and intern connect with database to run stored procedures.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Worked in debugging and Tuning the PL/SQL code performance for the Oracle database.
• Experience in Tuning SQL and PLSQL codes using Explain Plan and SQL Trace files.
• Experience on DBMS Profiler.
• Proficient in Oracle tools and utilities such as TOAD, PL/SQL Developer, SQL Developer
• Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.
• Involved in database Migration and gave Support for batch scripts.
• Experience in implementing the changes in existing batch scripts also gave support for data migration.
• Excellent experience in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents
• Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.
• Experience in all phases of the Application Development cycle - Design, Coding, Testing, Maintenance and Documentation.
• Hands on implementation experience in industries like Banking, Telecom domains.
• Worked as lead and as developer.
• Oracle Import/Export Utilities & SQL*Loader.
• Experience on oracle Database Design and Database Modeling.
• Have Knowledge on Informatica.
• Experience in scheduling jobs in Control-M.
• Knowledge of Autonomous Transactions Materialized Views, Bulk Collects and Collections.
• Involved in Unit testing, System testing, Integration testing, Development and Production
• As a professional developer involved in code review of all the team members.
• Strong skills in writing technical and functional documents defined by the business requirements
• Worked in various phases of SDLC involving teams of Team lead, Technical lead, Module lead, Analysist, Developer, Testing teams.
• Working closely with internal and external customers to meet Development, Implementation and Production support objectives by explaining industry best planning practices and processes.
• Worked on Banking and financial/Telecom domain.
• I am inquisitive and a quick learner and have been learning Big Data related Technologies like Hadoop.

TECHNICAL SKILLS:

Databases: ORACLE 11g/9i, SQL Server 2008.

Programming languages: PL/SQL, C, Pro*C, UNIX Shell Scripting. Hadoop.

Operating systems: Windows (NT/2K/XP), Vista, Win 7, UNIX and Mac Os.

Development Tools: TOAD, SQL Developer, PL/SQL developer, SQL*loader, SQL*plus, VM wareWebEx, Vi Editor, Putty.

PROFESSIONAL EXPERIENCE:

Confidential, MN

Technical Lead PL/SQL

Responsibilities:

• Analyzing the new Requirements and preparing the design documents.
• Worked as technical lead, monitoring the on time delivery and resolving the roadblocks.
• Developed new codes for transaction between CI and Confidential (one for sending request from Confidential to CI and 2nd to give response from CI to Confidential ) using C and PLSQL procedures.
• Developed Stored Procedures, Functions, Packages and SQL Scripts for database transactions using PL/SQL.
• Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL.
• Preparation and execution of test plans for unit & system testing.
• Developed the Shell Scripts for generating reports, and did the changes to the existing as per the requirement.
• Monitoring the system performance and tuning the SQL codes by reading the explain plans.
• Moving the changes to one environment to another environment.
• Modified the existing C programs to handle the database transactions.
• Developed and worked with SQL, PL/SQL scripts, and Shell scripts for automation.
• Coordinated with DBA in improving Database Performance.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Involved in Code Review, Code Walk Through, and Unit Testing.

Environment: Oracle 9i/11g, SQL PL/SQL, TOAD, SQL*Plus, C, UNIX. Shell Scripting, Putty, XML, CSV.

Confidential

Responsibilities:

• Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.
• Analyzed new requirements and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of Confidential from billing perspective.
• Developing the Build scripts.
• Preparing the Test plans and executing them for Unit Testing.
• Developing the scripts for Clean-up Activities.
• Provided solutions to billing issues faced during SIT and UAT (User Acceptance Testing).
• Involved in the Triple Play Project and developed Build for Confidential Scripts. In order to implement this requirement I have developed UNIX shell scripts, which will validate the inputs, get the required data by connecting with database, and do the operations.
• I have involved in providing fixes for existing batch scripts to in corporate 3play changes. And provided the design for the same.
• Monitoring the system performance and tuning the SQL codes by reading the explain plans.
• Worked on DBMS PROFILER for monitoring system performance.
• I have involved in modifying the profile files and password files as per the new feature 3play.
• Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Providing support during deployments and got appreciations from the client on Successful deployments into Production Environment.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.
• Involved in Planning, Implementation, Testing, and Documentation.
• Detected and Corrected bugs during system integration and user acceptance testing

Environment: Oracle 9i, PL/SQL, SQL, SQL*Loader, UNIX, Shell Scripting, Kenan FX 12.

Confidential

Pl/SQL Developer

Responsibilities:

• My role mainly involved in supporting Billing, Payments, Collections and batch customizations.
• Worked as Confidential from Onshore and coordinating between onshore and offshore teams.
• Analyzed the frequent accruing issue and identifying the fix and preparing the design documents.
• Developing the code fixes to the batch scripts and stored procedures.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Development of database triggers, cursors, packages, procedure & functions using PL/SQL & SQL
• Analyzed new requirements and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of Confidential from billing perspective.
• Developed the UNIX scripts for batch reports based the given requirements.
• Developed the UNIX scripts that will intern trigger database transactions.
• Providing the testing support during QA and UAT (User Acceptance Testing).
• Preparation and execution of test plans for unit & system testing.
• Owing the billing issues and all kind of batch issues, analyzing the fixing the issues.

Environment: Oracle 9i, PL/SQL, SQL*Loader, UNIX Shell Script, TOAD, Putty, SQL plus, Kenan FX 12, Putty.

Confidential

Pl/SQL Developer

Responsibilities:

• Involved in writing procedural scripts using PL/SQL
• My role mainly involved in preparing the automation scripts for Dispatch area configurations in KENAN/ Confidential and assigning Technicians to the dispatch area in Confidential for Austar Migration using UNIX shell scripting and PLSQL.
• Wrote UNIX scripts to validate the input and call the data base transactions.
• Analysed new requirements and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of Confidential from billing perspective.
• Developing the Build scripts.
• Involved in writing procedural scripts using PL/SQL
• Designed the database and schema objects.
• Development of Database triggers, packages, procedures and functions using PL/SQL & SQL
• Preparing the Test plans and executing them for Unit Testing.
• Developing the scripts for Clean-up Activities.
• Provided solutions to billing issues faced during SIT and UAT (User Acceptance Testing).
• Worked on configuration of dependency and exclusion rules for various Telecom products.
• Proposed solutions to client for various critical issues and got client appreciations for the same.
• Involved in Configuration of Kenan base tables.
• Providing support during deployments and got appreciations from the client on Successful deployments into Production Environment.
• Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.

Environment: Oracle 9i, PL/SQL, SQL*Loader, UNIX Shell Script, TOAD, Putty, SQL plus, Kenan FX 12.

Confidential

Module Lead

Responsibilities:

• My role mainly involved assessing the configuration of different types of Telecom products and related business rules in Billing Systems for Confidential Circles as per CR and as per SSA migration.
• Analyzed new requirements and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of Confidential from billing perspective.
• Worked as Team lead and monitoring the quality of work and on time delivery.
• Provided support to WEST DC team in analyzing the new requirements.
• Automated all types of configurations in Kenan billing (Developed PL/SQL Procedures) and handed over them to client.
• Programmed Stored Procedures, Functions and Package to implement business rules.
• Coordinated with DBA in improving Database Performance.
• Provided solutions to billing issues faced during UAT (User Acceptance Testing) and SIT.
• Provided the CRM mappings for the plans configured through VSS using PLSQL procedures.
• Provide support for billing issues in production environment during scheduled bill runs and clearance of MIU cases.
• Involved in SSA Migration (For all Confidential and Confidential SSAs), provided support to all the teams during the production movement, and solved the issues on priority.
• Providing support to the Migration team, by giving plan mappings for customer dump from earlier billing system ( Confidential ) and configuration of new plans, which are not mapped with the Kenan billing system for each circle.
• Resolved configuration issues at the time of Pre and Post Migration.
• Involved in Code Review, Code Walk Through, and Unit Testing.
• Fixed the Bugs in Production and resolved Production issues on priority
• Proposed solutions to client for various critical issues and got client appreciations for the same.
• Involved in Configuration of Kenan base tables.
• Got appreciations from the client on Successful deployments into Production Environment.

Environment: Windows 2000, PL/SQL Developer, Oracle 10g, Kenan FX 11.7, Oraexcel and UNIX, VSS, Putty.

Confidential, MN

Confidential

Pro C, UNIX and PL/SQL developer

Responsibilities:

• Analyzing the complete Application requirements.
• Developing the both High-level design documents and low-level design documents.
• Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.
• Developed back-end PL/SQL code to implement business rules through triggers, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Preparing the Test plans and executing them for Unit Testing.
• Provided solutions to billing issues faced during SIT and UAT (User Acceptance Testing).
• Detected and Corrected bugs during system integration and user acceptance testing

Environment: Pro C, UNIX and PL/SQL developer, Windows XP, C, Oracle 9i, Toad, Putty.

Confidential, MN

C, PL/SQL developer

Responsibilities:

• Involved in writing procedural scripts using PL/SQL
• Analysed and provided resolution to the service requests of clients in turn adhering to SLA.
• Ensured that the deliverables were defect-free by effective self-review and IMS review.
• Received appreciation from clients for the timeliness and quality of deliverables.
• Focused on discovering customer’s needs and worked to create customer focused services and solutions.
• Documented the experiences, problem faced and their solution with regard to support activities.
• Created knowledge repository on various processes in the project that guided as a ready reckoned.
• Development of Database triggers, packages, procedures and functions using PL/SQL & SQL
• Development of various reports for Material module
• Performed Unit Testing, System Integration
• Testing of system in various cases (Unit testing, integration testing)

Environment: Windows XP, C, UNIX shell scripting, Oracle 9i/10g, Toad, SQL, PLSQL, Putty.