SUMMARY

• 9+ years of IT experience in Oracle PL/SQL, Data Warehousing and UNIX shell scripting experience in Analysis, design, development, testing and implementation.
• 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.
• Excellent knowledge in DataAnalysis, DataValidation, DataCleansing, DataVerification and identifying data mismatch.
• Developed New Batch scripts for validations and intern connect with database to run stored procedures.
• Experienced with Batch systems scheduling and processing.
• 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/SQLcode 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.
• Extensive working experience in UNIX shell scripting using KSH,AWK.
• Experience in UNIX shell programming, file transfer Utilities like FTP, SFTP and job scheduling using UNIX Cron.
• Worked on DBA activities like creating the database objects (like Tables, Views, Materialized Views, Sequences, Index, Procedures, function, Packages) in diff environments. Moving and executing the Database objects in between the environments.
• Involved in DataMigration 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.
• Have done Unit testing, System Testing, and QA.
• Experience in production support, fixing production bugs and handled continuous enhancements requested from business users.
• Experience in all phases of the Software Development Life Cycle - Requirements Management, Data Modeling, Data Analysis, Data Mapping, System Analysis, Design, Development, Testing and Deployment of business applications, business analysis.
• Hands on implementation experience in industries like Banking, Telecom, and Retail domains.
• Worked as lead and as developer.
• Oracle Import/Export Utilities & SQL*Loader.
• Experience on oracle Database Design and Database Modeling.
• Have experience on Informatica. Working on Source to target mappings and involved in preparing the Migration scripts.
• Experience in Data Warehouse. Worked on data load scripts from Different source systems like SAP, Terradata, SalesForce etc.
• Experience in scheduling jobs in Control-M and AutoSys.
• 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/Retail domain.

TECHNICAL SKILLS

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

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

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

Tools: /Utilities: TOAD, SQL Developer, PL/SQL developer, SQL*loader, SQL*plus, VM ware, WebEx, Vi Editor, Putty, Control M, AutoSys, PVCS, TFS WINSCP, TortoiseSVN, Remedy, Teamtrack, Jiira, TeamTrack, Erwin.

Scheduling: Control-M, AutoSys

PROFESSIONAL EXPERIENCE

Confidential, MO

PLSQL Programmer/Data Analyst

Responsibilities:

• Analyzing the new Requirements (PCR and DBCR) and preparing the design/TechSpec documents.
• Developed new codes for data load and also modified the existing load scripts to load data into Data Warehouse from different sources as per the requirement.
• 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.
• Worked on end to end flow in Data Warehouse.
• Maintain the Packages and Procedures version of changes in TortoiseSVN.
• Documenting the modifications and enhancements made to the application systems and databases as required by the project.
• Prepared Handbooks for the application.
• Preparation and execution of test plans for unit & system testing.
• Analyzing the test results and recommending modifications to the applications to meet project specifications
• Developing and implementing the test validations of the applications specifications
• Wrote efficientstored proceduresfor the optimal performance of the system
• Monitored performance and optimizedSQLqueriesfor maximum efficiency.
• Createdindexedviews, and appropriateindexesto reduce the running time for complex queries
• Monitoring the system performance and tuning the SQL codes by reading the explain plans.
• Experience in scheduling the jobs in AutoSys.
• Coordinating code builds between environments.
• Used ETL to load the data from various sources in to CDW.
• Analyses the warehouse data provided reports for the same.
• Involved in Code Review, Code Walk Through, and Unit Testing.

Environment: Oracle 9i/11g, SQL PL/SQL, TOAD, SQL Developer, SQL*Plus, UNIX. Shell Scripting, Putty, TortoiseSVN, Teamtrack, Remedy, JIIRA, Autosys.

Confidential

Technical Lead

Responsibilities:

• My role mainly involved in supporting Billing, Payments, Collections and batch customizations.
• Analyzed the frequent accruing issue and identifying the fix.
• Developing the code fixes to the batch scripts and stored procedures.
• Preparation and execution of test plans for unit & system testing.
• Providing the testing support during SIT and UAT (User Acceptance Testing).
• Owing the billing issues and all kind of batch issues, analyzing the fixing the issues.
• Programmed Stored Procedures, Functions and Package to implement business rules.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Wrote many database triggers using PL/SQL for validation and business rules.
• Developed and worked with SQL, PL/SQL scripts, and Shell scripts for automation.
• Createdindexedviews, and appropriateindexesto reduce the running time for complex queries
• Monitoring the system performance and tuning the SQL codes by reading the explain plans.
• 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.
• Involved in creation of Implementation and Testing Documentation.

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

Confidential

PLSQL and Informatica Devloper

Responsibilities:

• Developed and modified database triggers, cursors, procedures, functions and packages to meet business requirements.
• Analyzed new requirements (CRs and ACRs) and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of CRs from billing perspective.
• Developing the Build scripts.
• Developing the scripts for Clean-up Activities.
• Worked on Migration scripts and Involved in source to target mapping.
• Provided solutions to billing issues faced during SIT and UAT (User Acceptance Testing).
• Involved in the Triple Play Project and developed Build for Ebill 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.
• Preparing the Test plans and executing them for Unit Testing and System testing.
• Detected and Corrected bugs during system integration and user acceptance testing.
• Performed DatabaseIntegrity Checks, updated Database Statistics and performed Re-indexing.
• 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, Control M.

Confidential

Pl/SQL Developer

Responsibilities:

• My role mainly involved in supporting Billing, Payments, Collections and batch customizations.
• Worked as SPOC from Onshore and coordinating between onshore and offshore teams.
• Analyzed the frequent accruing issue and identifying the fix and preparing the design documents(HLD and LLD).
• 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 (CRs) and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of CRs 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, Control M.

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/WAD and assigning Technicians to the dispatch area in WAD for Austar Migration using UNIX shell scripting and PLSQL.
• Wrote UNIX scripts to validate the input and call the data base transactions.
• Analyzed new requirements (CRs and ACRs) and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of CRs from billing perspective.
• Developing the Build scripts and Rollback 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, Control M.

Confidential

Module Lead

Responsibilities:

• My role mainly involved assessing the configuration of different types of Telecom products and related business rules (like Tariff Plans, Schemes) in Billing Systems for Confidential Circles (SOUTH/EAST zones) as per CR (Change Request) and as per SSA migration (From Dotsoft to Kenan).
• Analyzed new requirements (CRs for SOUTH/EAST zones) and checking the Feasibility and prepared High level and Low Level design documents for each new requirement of CRs 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 SOUTH and EAST 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 (DotSoft) 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

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
• Analyzed 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.