We provide IT Staff Augmentation Services!

Tech Lead And Sr. Software Consultant Resume

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.

Hire Now