Rajesh Kumar Singh

Senior Oracle PL/SQL Developer

EXPERIENCE SUMMARY

Accomplished and result-drivenSenior Oracle PL/SQL Developer with 10+ years of experience in DesignDevelopment of N-tier Client Server applications. Expertise inSQL , Advanced Oracle PL/SQL,Database Performance Tuning &Optimization of SQL, UNIX and Shell Scripting,Vast experience working in Object Oriented Programming, Client/Server and Web based applications using Oracle,Microsoft .NET FrameworkJavaScript.Excellent communication and interpersonal skills and team player. Flexible and capable to work in cross platform environments.

  • Proficient in Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non unique indexes, constraints, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
  • Expertise in creating and maintain stored procedures , Packages ,Triggers ,Functions ,writing complex SQL queries with sub-queries and inline views .
  • Proficient in oracle cursor management & Exception handling, error logs, SQL Jobs& Health checkup Management on transaction Data.
  • Expertise in Database Performance Tuning & Optimization of SQL statements using SQL,PL/SQL Best practices techniques, bulk collect, Oracle Hints ,Explain Plan,Tkprof,SQL*Trace & Table Partitioning.
  • Strong knowledge in Identified the several SQL and PL/SQL bottlenecks using Automatic Workload Repository(AWR) report, explain plan, auto trace ,PL/SQL profiler(package DBMS_PROFILER).
  • Experience inas export, import, retrieving data from external data files & loaded into oracle tables using tools like SQL* Loader and UTL_FILE.
  • Working Knowledge on UNIX, Windows and Shell Scripting.
  • Experience in design and development of window & web based applications using Microsoft .NET Framework(ASP.NET, ADO.NET with C#, VB.NET)JavaScript.
  • Experience in developed the complex & interactive reports inBusiness Objects14.0-Crystal Reports.
  • Experience in trouble suiting the security vulnerabilitiesthe Web based Application developed in Microsoft .NET Framework.
  • Vast experience working in all stages of the project lifecycle from requirements, to development, to implementation in production environments& Production support.
  • Working knowledge of others relational data bases such as SQL Server, IBM DB2, and PostgreSQL.
  • Experience in using various code repository software like (Concurrent Versions System) CVS, Apache Subversion (SVN) & Microsoft Visual Source Safe (VSS)
  • Experience in using different software methodologies e.g. Waterfall, Iterativeand Agile.
  • Self-motivated, able to set effective priority to achieve immediate and long-term goals and meet deadlines.
  • Ability to learn new skills and take on greater responsibilities, excellent organizational, interpersonal,and communications skills with the flexibility and experience required to adjust to rapidly changing schedules and shifting priorities.
  • Experience working as Lead with the onshore and offshore team.

Education:

  • Bachelor of Technology (B.Tech) in Computer Science & Engineering (4 Year Undergraduate Degree in Computer Science)from Uttar Pradesh Technical University, Lucknow, India.
  • Advance Diploma in Software Technology (Microsoft .NET Framework)

Certifications:

  • Oracle Advanced PL/SQL Developer Certified Professional(OCP)in Oracle Database 12c
  • Oracle PL/SQL Developer Certified Associate(OCA)in Oracle Database 9i
  • Microsoft Certified Technology specialist (MCTS) in Microsoft .NET Framework 3.5, ASP.NET Application Development

Honors & Award:

Star of the Month award for best Performance in January -2013((CMC Limited -WR)

Appreciation award for excellence contribution in Database Training in the Year 2013 (CMC Limited -WR)

was the member of project award in Best National Project in the year 2010 (CMC Limited)

was the member of project award in Best National Project in the year 2009 (CMC Limited)

Technical Skills:

Programming Language / SQL,PL/SQL,SQL fine-tuning, Asp.Net 2.0/3.5/4.0,Ado.Net, VB.Net & C#, JavaScript, HTML, CSS,UNIX Shell Scripting, XML
Database and Programming / Oracle8i/11g/12c, SQL Server2005/2014, IBM DB2, PostgreSQL, SQL, PL/SQL
Software Engineering / UML, Design Patterns, Object Oriented Methodologies, Service Oriented Architecture, Test Driven Development ,Waterfall ,Agile
IDEs & Tools / Microsoft .NET Framework 2.0/3.5/4.0, Business Objects 14.0-Crystal Reports ,SQL Plus, Toad,PL/SQL Developer,SQL Developer, Burp suite, SQL*Loader, UTL_FILE,FileZilla, Microsoft Visual Source Safe(VSS),(Concurrent Versions System) CVS, Apache Subversion (SVN)
Web/Application Servers / Window Server 2003/2008/2012, Web logic ,SQL Server 2014,NEC Cluster, Windows Server 2012
Domain / Insurance, Banking, Aviation-Security, Parking & Revenue, Energy -Power Distribution
Operating System / Win NT/2000, Win XP/Vista/7/8/10, Unix, Linux, Android OS, Solaris11

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Port Authority of New York & New Jersey (PANYNJ),New York, U SApril 2013– Till Date.
Project: Aviation Application Management and Administration Systems(AAMAS)

Role: Senior Applications Analyst

AAMAS Project consists of managing the distributed applications for PANYNJ at John F Kennedy & LaGuardia

International Airports in New York & Newark Liberty International Airport in New Jersey .The Applications being managed in the project are OnGuard Security System (CCS) from Lenel Inc. & Parking & revenue Control System (PRCS) from Federal APD. the responsibilities includes providing 24X7 system administrator services and database activates &automated solutions for improving the functioning of the airport.

Responsibilities:

  • Designed, developed& implementation of IT Solutions using Oracle PL/SQL &Microsoft .NET Framework.
  • Designed, developed & managed the Database objects (SQL Jobs,Stored Procedures,Functions,triggersetc) forParking & Parking and revenue control system (PRCS) & Computer Security System (CSS).
  • Working on Database Performance Tuning & Optimization of SQL statements using SQL ,PL/SQL Best practices techniques, bulk collect, Oracle Hints ,Explain Plan, SQL*Trace & Table Partitioning.
  • Identified the several SQL and PL/SQL bottlenecks using explain plan, auto trace, PL/SQL profiler (package DBMS_PROFILER).
  • Developed the process for Data archive & purging for Parking and revenue control system (PRCS) in Oracle Database.
  • Developed the Health Checkup (Basic checks on daily transaction data) jobs for Parking & Parking and revenue control system (PRCS) & Computer Security System (CSS).
  • Developed the complex, interactive, presentation-quality reports in Business Objects 14.0 -Crystal Reports.
  • Generating analysis report for diagnose & manage in various implementations in Parking & Parking and revenue control system (PRCS) & Computer Security System (CSS).
  • Developed the details documentation for all the application activities being performed in the project.

Technologies:Oracle11g ,QL,PL/SQL Developer,SQL Plus, Toad, SQL Developer ,FileZilla, SQL* Loader, Solaris11, Unix,Microsoft .Net Framework 4.0,ASP.NET,Java Script , SQL Server 2014, Business Objects 14.0-Crystal Report, Cview Manager,Semantic Net Backup,Window Server 2012,Window 7

ICICILombard, Mumbai, IndiaFeb 2007 – Mar 2013.

Project: Pathfinder System

Role:Senior Database Developer/Team Leader

Pathfinder Project is a non life policy and claims administration solution delivered in completely Brower-based Microsoft .Net Framework 3.5 & Oracle 12c technology which is accessing the more 25 Thousands underwriter/Agents. It supports full life-cycle policy administration and claims management. The system caters the all phases of proposal processing starting withunderwriting,renewals, Endorsementsof large number of policies (Fire,Motor, Marine Cargo, and Engineering etc.),Claim Processing, Re-insurance & related full accounting & MIS requirements for Divisional office & Branch offices.The system also provide the strong online query facilities. Pathfinder provides integration capabilities to other suppliers and legacy systems. It also provides automated regulatory reporting and document production.

Responsibilities:

  • Designed and implementedsoftware solutions for Non life Fire insurance module in the project(All Phases of Policy like Proposal ,Quotation, Accounting ,Policy generation ,Masters Data & reports ) using Microsoft .net framework3.5& Oracle 11g(Oracle PL/SQL,ASP.NET3.5,JavaScript).
  • Designed the data model and architecture of the application as class diagrams.
  • Designed, developed & managed the Database objects (SQL Jobs, Stored Procedures, functions, triggers, jobs etc) for all Applications.
  • Worked on Database Performance Tuning & Optimization of SQL statements using SQL ,PL/SQL Best practices techniques, Oracle Hints ,Indexes, Explain Plan, SQL*Trace & Table Partitioning.
  • Identified the several SQL and PL/SQL bottlenecks using Automatic Workload Repository (AWR), explain plan, auto trace, PL/SQL profiler (package DBMS_PROFILER).
  • Developed the Health Checkup(Basic checks on daily transaction data) jobs for Pathfinder Project
  • Developed the (Insurance Regulatory and Development Authority of India) IRDA reports &scheduled the jobs in Productionenvironments.
  • Implemented the several highly complex business requirements process in Motor& other moduleproviding the transaction data to third parties application for Accounting and report purpose using database Links, SQL Jobs,Views.
  • Fine-tuned the performance of application by Automatic Workload Repository (AWR), improving SQL queries, adding appropriate indexes.
  • Implements the review process & check list for all new developed /existing database objects.
  • Implemented the several securityvulnerabilitiessolutions forthe Application, used the Brup suite tool for troublesuiting.
  • Worked as Tech Lead and managed a small team in waterfall development mode efficiently and helped team to deliver enhancements and defect fixes to client on extremely challenging deadlines.

Technologies:Oracle11g/12c , SQL,PL/SQL Developer ,Toad, SQL Developer , SQL Plus,SQL* Loader ,Microsoft .Net Framework2.0/ 3.5,ASP.NET 3.5,Java Script , Microsoft Visual source Safe(VSS),Burp Suite, Window Server 2012,Window 7.

Air Port Authority of India (AAI), Delhi,IndiaMay2006 – Jan2007.

Project: Barcode System

Role: Programmer Analyst

Barcode System & its integration ICMS (Integrated Cargo Mgt.System) pertain to processing of cargo in AAI complex with barcode labels on them .Barcode is a technique to capture a limited amount of alphanumericdata within a small time eliminating the need for manually entering the same. The project consist of three modules consisting the cargo operations related to Export, Import& Disposal.

The web application is hosted on web server by AAI .The user on the suitable web browser running on suitable scanner & VMRDT access it. the data from barcode application is saved in the same oracle database as ICMS .Because of absence of bar-coded label information of the commodity ,the commodity is treated on a First In First Out (FIFO)basis, all the packets of consignments are suitably labeled as per IATA 606 standard .The web application's user permission are maintain by ICMS Security tables.

Responsibilities:

  • Worked with Business Architect in collaboration sessions to capture business requirements in the form of Use Cases.
  • Worked as Programmer Analyst and developed & implemented Export module in waterfall development mode using PL/SQL, Aps.net 2.0 and helped Team to deliver the product enhancements on time and in cost effective way.
  • Interaction with client for requirement gathering, scoping, designing and function/technical support.
  • Designed the data model and architecture of the application as class diagrams.
  • Designed, developed & managed the Database objects (Stored Procedures, functions, triggers, sqljobs etc) for all modules.
  • Provided production support by providing emergency bug fixes and data fixes.

Technologies: Oracle 8i , SQL,PL/SQL Developer ,Toad, SQL Developer , SQL Plus,SQL* Loader , ,Microsoft .Net Framework2.0,ASP.NET 2.0,Java Script, Microsoft Visual source Safe(VSS).Window XP

North Delhi Power Limited (NDPL),New Delhi, IndiaJan 2006 – April 2006.

Project: Automated meter Reading & Data Analysis (AM&DA)

Role: Programmer Analyst

Automatic Meter Reading& Data Analysis (AMR&DA) project automatically collect consumption, diagnostic and status data from of electrical meter and then transfer that data to a central database for billing and analysis, collecting the data into different format and is converted into xml format & finally it is used for generation of bill for end users.

Meter readers handle a flood of data every day and entering that data manually can increase the chance for human error. Making sure your data is accurate, on time and analyzed is key to increasing cash flow, not to mention customer satisfaction.

Responsibilities:

  • Worked with Business Architect in collaboration sessions to capture business requirements in the form of Use Cases.
  • Worked as Programmer Analyst and developed & implemented several business forms (Screen) in waterfall development mode using SQL Server, ASP.net 2.0 and helped Team to deliver the product enhancements on time and in cost effective way.
  • Interaction with client for requirement gathering, scoping, designing and function/technical support.
  • Designed the data model and architecture of the application as class diagrams.
  • Designed, developed & managed the Database objects (StoredProcedures,functions, triggers, SQLjobs etc) for all modules.
  • Provided production support by providing emergency bug fixes and data fixes.

Technologies:SQL Server 2005,SQL, Microsoft .Net Framework2.0, ASP.NET2.0, JavaScript, Microsoft Visual Source Safe (VSS).Window XP, Window Server2003.

______

Page 1 of 5