Developer Sql

EXPERIENCE SUMMARY

Accomplished and result-driven Senior Oracle PL/SQL Developer with 10+ years of experience in Design & Development of N-tier Client Server applications. Expertise in SQL, 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 Framework & JavaScript. Excellent communication and interpersonal skills and team player. Flexible and capable to work in cross platform environments.

SKILLS INVENTORY

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 in as 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 in Business Objects14.0-Crystal Reports.

Experience in trouble suiting the security vulnerabilities the 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, 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, Iterative and 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.

EXPERIENCE HIGHLIGHTS:

Experience in industries such Insurance, Banking, Aviation -Security, Parking & Revenue, Energy -Power Distribution and Public services (State government agencies).

Worked for AAMAS project to customize the base project to the needs of Port Authority of New York and New Jersey (PANYNJ) for Aviation Parking & revenue Control system & OnGuard Security System (CSS).

Worked for ICICI Lombard’s - Path finder System new Insurance development project for Non life-Corporate and retail insurance industry in Asia and India.

Worked for Barcode new development project for Air Port Authority of India (AAI) in New Delhi, India for Export/Import Cargo aviation industry.

Worked for Automated meter reading & Data Analysis (AMR&DA) new development project for North Delhi Power Limited in Power Distribution industry in India, massive revamping 10 years legacy system into web application.

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

Oracle 8i/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/4.5, 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, Solaris 8/9/11

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

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

Role: Senior Database Developer

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, triggers & etc) for Parking & 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, SQL,PL/SQL Developer,SQL Plus, Toad, SQL Developer, FileZilla, SQL* Loader, Solaris 11, Unix,Microsoft .Net Framework 4.0/4.5,ASP.NET,Java Script, SQL Server 2014,,Business Objects 14.0- Crystal Report., Cview Manager, Semantic Net Backup,Window Server 2012,Window 7

ICICI Lombard, Mumbai, India Feb 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 with underwriting, renewals,Endorsements of large number of policies(Fire, Motor,Marine Cargo,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 implemented software 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 Production environments.

Implemented the several highly complex business requirements process in Motor & other module providing 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 security vulnerabilities solutions for the Application, used the Brup suite tool for trouble suiting.

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, India May 2006 – Jan 2007.

Project: Barcode System

Role: Database Developer

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 alphanumeric data 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 Database Developer 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, sql jobs 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, India Jan 2006 – April 2006.

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

Role: Database Developer

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 Database Developer and developed & implemented several business forms(Screen) in waterfall development mode using SQL Server,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, SQL jobs 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.NET 2.0, Java Script, Microsoft Visual source Safe (VSS).Window XP, Window Server2003.

Contact this candidate