SUMMARY

• Experience in Government, HealthCare & insurance (Diamond), Retail and Garment domains based RDBMS Applications.
• Proficient in PowerBuilder - Accessing Web Service, DataWindow, Window, User Objects, OOPs concepts, PFC, Oracle - SQL, PL/SQL, SQL TUNING, SQL*Loader, ETL, SQL Server 2017, Sybase, SQL and Query optimizer and ArcGIS.
• Good knowledge in UNIX Korn shell scripting with CRONTAB, SED, AWK, GREP and VI editor.
• Extensive experience in Information Systems Analysis, Design, Coding, Testing, Debugging, Code Review, Migration and Implementation.
• Excellent skills in GUI, PC based state of the art client/server development tools and databases.
• Experience in leading and coordinating the team and assigning Task to other developer.
• Strong with RDBMS features like Triggers, Procedures, Packages and Functions in Oracle and Sybase.
• Expertise in using Oracle - External tables, Materialized views, PL/SQL tables, Collections, Triggers, Packages, Procedures, Functions and Partition tables.
• Extensively Used Oracle Cursors, Ref Cursors, Cursor expressions & Exceptions, co-related sub-queries, anonymous blocks.
• Extensive experience in Oracle performance tuning and optimization of PL/SQL scripts and SQL queries using HINTS, EXPLAIN PLAN, TKPROF and Analyze.
• Expertise in Oracle Midlevel-DBA activities creating Indexes, Partitions and Performance Tuning Experience.
• Experience of Tools such as Clear Quest, TOAD, SQL Developer and DBArtisan.
• Knowledge of programming and Design methodologies related to RDBMS Applications.
• Excellent interpersonal, presentation skills, with demonstrable leadership, verbal and written communication skills to maintain effective work relationships with all levels of personnel in a team environment or independently.

TECHNICAL SKILLS

GUI: PowerBuilder (6.5 to 17), Visual Basic (6.0)

RDBMS: Oracle (8i to 12C), SQL, PL/SQL, SQL Server 2017, Sybase 12.5, Sybase SQL Anywhere (5.5)

Languages: C and C++

Web Technologies: XML, WSDL, ASP.NET, C#

Operating System: UNIX (IBM AIX, HP UX), Windows 10.

Tools: Toad, DBArtisan, Oracle SQL Developer, SQL Server Management, SQL*Loader, ETL, Clear Quest, VSS and Peregrine (Diamond), Geographic Information System (ArcGIS) and JIRA.

Documentation Tools: MS Word, MS Excel

PROFESSIONAL EXPERIENCE

TECH LEAD AND SR. SOFTWARE CONSULTANT

Confidential

Technologies: PowerBuilder 17, Oracle 12C, Oracle PL/SQL, SQL Server 2017, JIRA, C#, ASP.Net and Windows 10.

Responsibilities:

• Perform Technical Analysis, Design and Development, Testing, Debugging and Maintaining the HPDInfo Application.
• Analyze the user requirements and prepare technical, functional specifications and test plans for HPDInfo application Housing Quality Standard (HQS) module.
• Creating HPDInfo reports using DataWindow concepts for Confidential -Divisions of DTR and ENS.
• HPDInfo application Production Support: work closely with the business users and give immediate solution when production issue occurs.
• Connecting multiple databases from PowerBuilder using Transaction Objects
• Create PowerBuilder objects using Object Oriented Techniques like Inheritance, Polymorphism and Encapsulation.
• Involved in Performance tuning using SQL trace Utility, Explain plan and TKPROF.
• Create and implement DDL Scripts in Development, QA and Production Environments.
• Create Procedures, Functions, and Triggers using PL/SQL. Work Oracle DBA team closely and maintain database objects including tables, views, stored procedures, Functions, triggers and constraints.
• Create/change Business object (Visual/Non-visual), Windows, DataWindows, functions and menus.
• Supporting application running in SQL Server and send the Unit status data from Oracle.

Confidential

SR. SOFTWARE CONSULTANT

Technologies: PowerBuilder 9, Oracle 10G, Oracle PL/SQL, SQL*Loader, ETL and Windows 2000/XP.

Responsibilities:

• Analysis, Design, Developing, testing and maintaining the PowerBuilder Application.
• Involved in Creating Front End (GUI) Screens for data entry.
• Used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
• Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for weekend batch processing.
• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader - for different cases).
• Used UTL file package scripts to extract data from database based on business requirement.
• Involved in DBA Activities like Index Creation, Script Creation for code migration to Production Servers and SQL Query optimization for the using Explain plan and Auto trace.
• Involved in creating complex queries to generate ad-hoc reports as per client request as a part of production support.
• Used TKPROF (SQL * Trace) tool to analyze and fix multiple time consuming SQL statements that were available in stored packages.
• Created and implemented DDL Scripts in Development, QA and Production Environment.
• Analysis of new projects, estimation, programming and testing of programs.
• Involved in gathering user requirements and preparing functional and technical documents.
• Work with day-to-day issues that are submitted in the form of tri-active tickets.

Confidential

SR. SOFTWARE CONSULTANT

Technologies: PowerBuilder 10.5, Oracle 10G, Oracle PL/SQL, SQL Server 2005 and Windows 2000/XP.

Responsibilities:

• Extremely involved in Analysis, Design, Developing, testing, debugging and support the BBL and OSR Applications.
• Created the new application in PowerBuilder to access the methods in the Accela Automation Web services to migrate the data from BBL to Accela BBL.
• Involved in Creating and Parsing the XML which sending and receiving from Web Service.
• Provides immediate solution when a production issues occur.
• Created Builds and deployed the executables for each modification.
• Used Object Oriented Techniques of PowerBuilder like Inheritance, Polymorphism and Encapsulation.
• Created and implemented DDL Scripts in Development, QA and Production Environment.
• Created and altered tables, views, procedures, functions, triggers and functions in ORACLE and SQL Server.
• Involved in gathering user requirements and preparing functional and technical documents.
• Created/changed Business object (Visual/Non-visual), windows, data windows, functions, menus.
• Created many reports using DataWindow concepts.
• Documenting requirements and business process.