SUMMARY:

• Extensive experience in Requirement Study, Analysis, Technical Architecture, Designing, Development and Testing of client server as well as web based application systems.
• Extensive experience in database programming and performance tuning using T - SQL and PL/SQL, Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Indexes
• Extensive experience in Agile Software Development using Scrum.
• Excellent communication, leadership & problem solving skills.

TECHNICAL SKILLS:

Technologies/Languages: PowerBuilder, VB.Net, C#, PL/SQL, T-SQL, Classic ASP, JavaScript, Visual Basic

Databases: Oracle with VPD, MS SQL Server, Sybase SQL Anywhere

Version Control Tools: Team Foundation, Microsoft VSS

Other Tools: TOAD, IIS, SQR, MS Project, Citrix, Serena TeamTrack, Wise Installation System, Installshield

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

Technology: PowerBuilder 12.x, MS SQL Server, T-SQL

Responsibilities:

• As a Senior Developer, worked on various aspects of the PowerProfile software including analysis, design, coding and testing.
• Modernized the look and feel of the application by enhancing the user interface.
• Redesigned the security application to have better layouts and built new frontend reports using various datawindow styles.
• Used web services to implement runtime verification from various agencies like SSA, DMV, etc.
• Led the effort to convert a large application from using Oracle PL/SQL to MS SQL Server T-SQL which included rewriting embedded SQLs, triggers, functions and procedures.
• SQL Tuning of large processes for performance improvement.
• Strong working experience in SQL Server and T-SQL in constructing triggers, tables(DDL), joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Developed database triggers to enforce data integrity and additional referential integrity.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Developed various back-end processes that run as daily jobs, such as calculation of statistics, archiving tables, synchronization of duplicate voter record batches etc.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created weekly builds of the project using Installshield.

Confidential

Technology: VB.NET, Oracle PL/SQL with Virtual Private Database (VPD)

Responsibilities:

• As a Senior Developer, was involved in analysis, design and coding for converting a standalone county system into a statewide system that can be accessed over the Internet using Citrix.
• Created weekly builds of the project for QA that included source code and database changes using SourceSafe and Wise Installation System.
• Assisted implementation of Label Based Security that was used to convert the application into a statewide system.
• Written complex stored procedures using PL/SQL as well as analyzing and debugging existing complex stored procedures
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Expertise in creating Oracle objects like Tables, Synonyms, Indexes, Views, Materialized Views and Table Partitions.
• Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT
• Code tuning or Query Optimization done using Explain Plans, Hints
• Provided customer support during critical elections.
• Assisted QA department in regression testing of the application.
• Design & conduct set of application development standards that other team-mates adhere-to.

Confidential

Technology: VB.NET, Oracle, PL/SQL

Responsibilities:

• As a Senior Developer, managed the migration of a Visual Basic application to a VB.NET based solution for the Voter Registration system.
• The Voter Registration system was a decentralized system for various US states based on state laws. It assisted voters for registrations, online verification.
• Using VB Migration tool, the application was automatically migrated from Visual Basic to VB.NET with reasonable success but needed a rewrite of many components to make it compatible with .NET
• Used third party tools like ImageMan for .NET to manage images and SD-Toolkit to automatically scan images, read barcodes and process batches.

Confidential

Technology: Visual Basic 6, Oracle, PL/SQL

Responsibilities:

• As a Senior Developer, provided continuous support for the existing application Confidential that was used by some of the states.
• Managed enhancements of the various requests received from customers from time to time.
• Detailed Impact Assessment was done followed by an estimation; after which the said changes were implemented.
• Managed and maintained various release cycles of the application per client requirements that included customization of various interfaces and reports.
• SQL Tuning of large processes for performance improvements.
• Utilized SQL*Loader to load flat files into database tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Triggers

Confidential

Technology: ASP, Oracle, PL/SQL

Responsibilities:

• As a Senior Developer, provided continuous support for the existing web based application for early voting facility.
• Used ADO.NET to connect with Oracle
• This application was a customized application for various states based on the local laws and requirements; predominantly used by county staff assisting citizens for early voting. It also had the ability to provide citizen’s information along with printing of ballots, search facility, signature verification etc. on the Election Day itself.
• Authentication and authorization was maintained within the application using Hash key algorithms from various APIs.

Confidential

Technology: PowerBuilder 7.x, Oracle, PL/SQL

• worked on various aspects of the PowerProfile software.
• Confidential is a distributed election system used and maintained by various counties of each state. There was a limited level of integration possible via flat file exports.
• Involved in development of the standalone county system based on the application framework.
• Assisted the application framework team for any PFC related changes as and when required.
• SQL Tuning of large processes for performance improvement.
• Writing stored procedures and database triggers using PL/SQL.
• Provided customer support during critical elections.
• Design & conduct set of application development standards that other team-mates adhere-to.

Confidential

Term Deposit

Technology: PowerBuilder 6.5, PFC, Sybase Adaptive Server Enterprise 11.5

Responsibilities:

• As a developer, actively involved in the database design of the application.
• Coded the interface for the Fixed deposit and Re-investment scheme using PFC.
• Written some generic procedures for calculation of TDS, which are being used by most of the schemes.
• Designed the interface for deposit receipt printing and re-printing using PFC.
• Large amount of related information available at one time using tabs.