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

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

Senior Developer

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

Senior Developer

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

Senior Developer

Responsibilities:

• As a Senior Developer, provided continuous support for the existing application MegaProfile 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