SUMMARY:

• Over 20 years of IT experience in all phases of Software Development Life Cycle.
• Involved in Design, development, implementation, testing and documentation of business applications using Oracle technologies.
• Strong in using tools such as PHP Admin, PL/SQL developer, VISIO, SQL*Loader, TOAD & SQL*Plus &.
• Proficient in ANSI SQL, MySQL, Oracle 11g/10g/9i/8i, PL/SQL Development Toad, PL/SQL Developer, UNIX, Korn Shell Scripting & .
• Strong Experience in data Maintenance and Support which uses Oracle 9i database, SQL, PL/SQL, SQL* Loader in windows NT and Unix environment.
• Extensively used PL/SQL to built Oracle Packages, Stored Procedures, Functions, Triggers, Cursors, REF Cursors and Views for processing data, enforcing referential integrity and needed business rules.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types and Dynamic SQL.
• Data Modeling, conceptual model to logical model to physical schema using Oracle Designer.
• Involved in creating and maintaining partitioned Tables and Indexes.
• Performance Tuning, Optimization using TKPROF and Cost Based Optimizer
• Experience with FTP Protocol, System Analysis, Business Analysis, Documentation, Implementation, Telecommunications, Windows NT, HTTP, TCP/IP, UNIX.
• Strong working knowledge with EDI transactions 810, 850 and 856.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent analytical, problem solving, communication and inter - personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS:

Operating Systems: HP-UX, RedHat Linux 7.2, Win NT, 2000, XP, Win7, Win8, Win10 & Windows Server from 2005 to 2012

Languages: ANSI SQL, PL/SQL v10g, SQL v10g, Asp.Net 4.5, Pro*C v9i, VB Script, Java and Korn shell

Databases: MySQL, Oracle 8, 8i, 9i, 10g & 11g, MS-SQL Server 2005-2012,Oracle Partitioning, Sybase.

Web: HTML, JS, XML & C#, jQuery

Script Languages: Unix Shell Scripting, Windows Batch File, CRON & Windows Scheduler

Software: Oracle Forms/Report v 4.5-11g, SQL*Plus 3.1-11g, SQL*Import, SQL*Export, Excel, SQL*Loader, Designer v6i, Oracle Internet Application Server v10g, Visio 2005, Microsoft Project 2002, PVCS v6.0, Hummingbird, Toad v9.0, SVN

Tools: Exposure: PHP Admin, Visual Studio 2005-2012, Android Studio, Putty, FTP, WinSCP

Web Services: SOAP, REST, API, XML, JSON

PROFESSIONAL EXPERIENCE:

Project Manager/ Project Lead PL/SQL Developer

Confidential, Tinton Falls, NJ

• Discussing new project requirement coming from new/existing clients.
• Converting the requirement into technical and further discuss to in house and client.
• Communicating with clients to make sure that we have gathered the requirements.
• Mentoring and helping a team of core developers.
• Wrote various Stored Procedures to fulfill the business requirements of the above projects.
• Held regular meetings and solved problems
• Consulted with management and client technical leader to ensure the quality.
• Inspired team to vision big picture of the projects.
• Trouble shooting to the sites to prevent hacking.
• Rewrote the stored procedures to prevent SQL Injection and tested the result using BURP.
• Managing dedicated windows servers and deployed the changes.
• Created test instances of the sites on the server for testing.

Environment: MySQL, Oracle 11g, SQL*Plus, SQL*Loader, PL/SQL, IDS, HTML, JS, Asp.Net 2.0-4.0, MS SQL Server 2012 R2.

Project Lead PL/SQL Developer

Confidential

• Led a team of developers to provide technical support to the client’s various sites in ASP.Net & PHP.
• Trouble shooting to the sites to prevent hacking.
• Rewrote the stored procedures to prevent SQL Injection and test the result using BURP.
• Suggested various technical points to meet their goals.
• Managed their dedicated windows servers and deployed the changes.
• Created test instances of the sites on the server for testing.

Environment: Windows Azure Server 2012 R2, MySql, Oracle 11g, PL/SQL, Asp.Net 4.5, Php 5.0, PHP Admin

Project Lead PL/SQL Developer

Confidential

• Led a team of Android, iOS & BlackBerry and ASP.Net developers to build the mobile solution.
• Fine tuned T-SQL query to get best performance of both MS-SQL and SQ-Lite databases on Mobile
• Worked closely with development and design team to get quality.
• Helped client to promote the apps on their stores.
• Implemented the ASP.Net back end with soap web service on their server.
• Held regular meetings and tracked the progress.

Environment: Windows Server 2008 R2, MS-SQL Server 2012, T-SQL, Asp.Net 4.5, SQ Lite, Eclipse (Android & Black Berry), Flex 4.6

Project Lead PL/SQL Developer

Confidential

• Led a team who migrated the Hospital Management System from Forms/Reports 4.5/2.5 to 10g and Oracle database from 8i to 10g.
• Worked on their existing database objects and using Toad’s Explain plan to get performance tuning.
• Converted their existing stored procedures & functions into package and wrote extra PIN function in each package. Called this PIN functions from each package on database startup script to load the package in SGA to get optimal performance as all object got pre-loaded in the database.
• Developed a custom report viewer to allow printing the old reports on dot matrix printers.
• Hand-picked project teams and trained and motivated and inspired them toward goal completion.
• Monitored progress and tracked the task-completion.

Environment: RedHat Unix, Oracle Application Server 10g, Oracle Database 10g, Oracle IDS 10g, SQL*Plus, SQL*Loader, PL/SQL, Windows Xp.

Project Lead PL/SQL Developer

Confidential

• Led a team of Oracle Developers to migrate their MIS system from Oracle 8i to Oracle 10g.
• Consolidate the Oracle Forms and PL/SQL Reporting queries on a centralize file server, before they were on each client PC.
• Sorted and indentified latest code and fine tuned their stored procedures.
• Converted their existing procedures & functions into package and wrote extra PIN function in each package. Called this PIN functions from each package on database startup script to load the package in SGA to get optimal performance as all object got pre-loaded in the database.
• Fixed affect query changes due to upgrade and verified the results are identical after the upgrade.
• Monitored progress and tracked the task-completion.

Environment: HP-UNIX, Oracle v10g, SQL*Plus, SQL*Loader, PL/SQL, Developer 2000, Windows Xp.

Project Lead PL/SQL Developer

Confidential, Fortlee, NJ

• Led a team of core developers who developed customized applications for many municipalities.
• AIMS - Auto Impound Management System for Impounded vehicles
• PMS - Property Management System for Construction Debris collection
• FMS - Fleet Management System for managing JCIA vehicles
• STAMP - Vehicle Title Management System
• The above applications were developed in Oracle 10g Forms/Reports.
• Wrote various functions & stored procedures to fulfill the business requirements of the above projects.
• Wrote procedures & functions into package and with extra PIN function in each package. Called this PIN functions from each package on database startup script to load the package in SGA to get optimal performance as all object got pre-loaded in the database.
• Later migrated all the above projects under ASP.Net 4.5 and MS-SQL Server.
• Held regular meetings and solved problems
• Consulted with management and client technical leader to ensure the quality.
• Inspired team to vision big picture of the projects.

Environment: RedHat Unix, Oracle 10g, SQL*Plus, SQL*Loader, PL/SQL, Developer 2000, HTML, JS, Asp.Net 2.0-4.0, MS SQL Server 2008.

Sr. Application Designer/Developer

Confidential

North Bergen, NJ

• Led design, development and implemented applications and developed interfaces for Retails, Integration and BI Systems.
• As project leader was responsible for defining the Requirement Scope Definition, analyzing all the RAMS backend processes contention with user access of 20 hours work day from different time zones.
• Created Functional and Technical Design document and present the solution. Created and maintained the project plan and responsible for assigning task and supporting on-site consultants for modifications of around 35 interfaces to and from RAMS, besides modifying the Weekend, Period and Physical Inventory processes.

Environment: HP-UNIX, Windows Xp, Oracle 10g, SQL*Plus, SQL*Loader, PL/SQL, Pro*C, Ids 10g.