Professional Summary

Over ** Years of Experience in Object Oriented Design, Modeling, Programming, Application Development, Maintenance and Testing in Delphi Applications and Relational databases

Expertise in Developing Object Oriented Delphi applications using all major versions of Delphi ( Delphi 5 to Delphi XE7)

Expertise in Developing windows based and web applications using Microsoft Visual Studio IDE using C#.Net, ASP.Net and VB.net

Experience in creating joins, views, indexes, stored procedures, triggers, functions, constraints at various stages of migration, ad-hoc reports and data validation.

Expertise in scripting languages Java Script, and JQuery.

Expertise in SOAP, MIDAS, Web Services, XML and XSL in .Net.

Experience working on Direct Oracle Access (DOA), Borland Database Engine (BDE) and ActiveX Database Objects (ADO) in SQL Server and Oracle communications to connect Delphi.

New component development, Developing and implementing DLL’s in Delphi, Expertise in Front-end development and efficient Exception handling

Expertise in upgrading the different types Client server, Windows Development and web based Delphi applications to Higher Versions like Delphi2006, Delphi 2007, Delphi2010 and Delphi XE1/2/3/6/7.

Proficiency in developing Delphi Multi-threaded, distributed, multilevel architecture, Client-Server, Multi-tier Applications.

Windows API, COM and DCOM (MIDAS) programming in all Delphi versions.

Experience and working knowledge on Reporting Tools such as Rave Reports, Quick Reports in Delphi.

Over 5+ years of SQL programming experience in Design, Development, Support Of MS SQL SERVER 2005/2000 in development, Test and production environments and over 7 years of experience in Oracle 8i/10g.

Expertise in SQL, T-SQL and PL/SQL development in Oracle.

Good knowledge on C#.net,Asp.net and VB.net

Good knowledge on UNIX.

Expertise in different kind of version control management systems.

Proven ability to learn quickly and adopt the new environment. Expertise in meeting tight deadlines even in the pressured working conditions

Strong Analytical & Interpersonal Communication skills

Experience and Involvement in total development life cycle

Expertise in SDLC methodology and Agile Methodologies.

Proven decision making skills and abilities to lead teams.

Comprehensive problem solving abilities, excellent verbal and written communication skills

Expertise in working and tracking defect management systems Quality center and JIRA.

Expert level skills in Data Extraction, Transformation and Loading (ETL) Using ETL tool DATASTAGE 8.0 and Certified in IBM Data stage 8.0.

Extensive Knowledge of Query Optimization, Performance Tuning and Database Consistency checks

Proven problem-solving and multi-tasking abilities.

Experiences spans over varying database technologies.

Education & Credits

Masters in Computer Applications

Bachelors in Computer application

Technical Skills

RDBMS/DBMS

MS-SQL Server 2008/2005/2000,ORACLE 8i/10g/11

Programming Languages

Delphi5/6/7/2010/XE,Java,C++,VisualBasic6.0,C#.net,Asp.net and UML

ETL

Datastage 8.0

Business Tools

Word, Excel, Power Point, Outlook.

Quality management tools

HP Quality Center, Service Now Change Management and JIRA

Operating Systems

Windows 7, Windows Vista, Windows XP, Windows 2003,Linux

Professional Experience

American Family Insurance May 2013– Till Date

Role: Delphi/Java Developer.

Location: Madison, WI.

Projects:

CACM - Consumer affairs complaint management is system is a legal system which is operated by legal team and several advocates to manage the complaints of the consumers from several location. System maintains controls and reports all the complaints of consumers. This software provides a greater ability to manage all the information of consumers and legal documents of complaints by legal advocates.

GUI Application - Developed in Delphi5,Oracle 10G,Java,JBOSS 5 and Delphi 2010

Batch Processing - Developed in Delphi2010 and Java, Java Script, Workbench, JIRA

CLASS – Commercial Lines Automated Support System is designed and developed to assist with the processing of audit requests and generate different kind of letters for all Physical, Voluntary and Telephone Audits. These systems deals with data of all Policy numbers, Insured details, Line of business being audited.

GUI Application - Delphi XE7, Java and Oracle 11G

Batch Processing – Delphi XE7 and Java.

Software Development Approach - Agile Methodology

Current Achievements:

oSuccessfully upgraded the Delphi versions from Delphi 6 to Delphi 2007 and then to Delphi XE. Successfully rewritten other BASS application (other than my regular job) from Delphi to .Net as requested by the client.

oSuccessfully upgraded File storage system of the CLASS application from EDMS to FileNet.

oSuccessfully integrated Right Fax Components (Internal Fax application provided by Third party vendor) into CACM Delphi com objects.

Responsibilities:

Collecting the new requirements from the business and implement in existing applications using Delphi5, Delphi2007, Delphi2010,DelphiXE7,Oracle and Java coding.

Conducting and attending regular Scrum Meetings.

Design and developing dll’s in Delphi according to the requirement and implement in the application.

Designed & implemented new User interfaces in the Operations Module using Delphi VCL.

GUI/Batch support for all Windows based Developed applications, desktop, Client Server and Web application. Working on Insurance Rate Engines engines.

Writing to COM and DCOM (MIDAS) programming in Delphi2010.

Object Oriented Design, Modeling, Programming of all Delphi applications

Daily bug fixing and meeting all time lines.

Upgrading the Delphi Versions from Delphi 2010 to Delphi XE7.

Creating test case for production releases and responsible for unit testing before moving to QA Environment.

Environment: Delphi5, Delphi2007, Delphi2010, Delphi XE7, Java, Harvest, JIRA and Windows7.

New York Life Insurance Jul 2012– Apr 2013

Role: Delphi/.Net Developer.

Location: Reno, NV.

Project: Field Technology Illustration System

The Field Technology Illustration system (FTIS) is software, which is used by NYL Insurance agents to illustration different kind of policies like life.FTIS Life Illustrations software gives the user the flexibility to create custom illustrations depicting various future scenarios. In addition, many concepts are available for illustration. Some of these concepts include Split Dollar and Buy Term and Invest the Difference. In addition to the benefits of illustrating a life insurance product, it is also required by the company to provide a signed sales illustration with most offered life products.

This software provides a greater ability to sell larger amounts of insurance, relate the product to a concept, and provide future service to your clients via Inforce illustrations.

FTIS Desktop Application - Developed in Delphi 2010

FTIS Web Application- Developer in Asp.net,C#.Net, Java Script, JQuery’s, Microsoft visual studio2010,

Framework 4,IIS server.

Annuities– Developed in Delphi2010

Development Approach - Agile Methodology

. Responsibilities:

Collecting the new requirements from the business and implement in existing applications using Delphi2010, Asp.Net, Sybase, Oracle and XML coding.

Adding and modifying validation in java script and JQuery as required by the business requirements.

Design and developing dll’s in Delphi according to the requirement and implement in the application.

Designed & implemented new User interfaces in the Operations Module using Delphi VCL.

GUI support for all FTIS desktop and Web application. Working on Calculation engine for Annuity products.

Writing to COM and DCOM (MIDAS) programming in Delphi2010.

Reading and writing nodes/data from Delphi to XML as well as from .Net using XSL files.

Object Oriented Design, Modeling, Programming of all Delphi applications

Daily bug fixing and meeting all time lines.

Production release and version controlling using TFS.

Creation of the Technical Specification documents

Creating test case for production releases and responsible for unit testing before moving to QA Environment.

Environment: Delphi2010, Asp.net, Java Script, JQuries, Sybase, Oracle, TFS, Microsoft Visual Studio 2010, and Windows XP.

Blockbuster, LLC. June 2008 – Jul 2012

Role: Senior Delphi Developer.

Location: Dallas, Texas.

Projects:

Revenue share applications:

Blockbuster is the biggest movie and games rental Chain Company and having several stores all over US and international. BBI rents DVD’s, Blue ray and games through these stores. Blockbuster will have legal agreements and contracts with the studios on movies and games. Based on these legal agreements Blockbuster will send remittances reports to studios on their revenue generated by the movies and games which are having contracts with the studios.

In Revenue sharing project daily we will process all transactional data from all Blockbuster stores and calculate the percentages of revenue share by both BBI and studios.

The two main groups of applications are GUI and Batch

All GUI applications are to maintain control information, Hoodwinked for domestic and RS Client and RS Remit for international processes are used for managing the payments due to each studio under Revenue Share contractual agreements. The Oracle database is maintained by CPST transmissions to Dallas from each country but the user is required to set up country specific detail to reflect each studio contract covering film, Processor and accounting information. Additional reports are available from the system to support the management of the process and provide additional control.

The different daily, weekly and monthly batch processes are used to load CPST transactions from the stores to the SQL Revshare tables and to provide daily, weekly or monthly reporting to the studios or their designated processor. Responsible for Extract is the Main batch job which is developed in Delphi and SQL which will process 2 million records of CPST file from several Blockbuster stores on daily.

Point of Purchase (POP):

POP (Point Of Purchase) is merchandising application used by Blockbuster Purchasing Department for creating and tracking Jobs originated by Marketing Department. It’s a critical system used by the Purchase Department for Estimating Jobs, Creating PO’s for multiple vendors and tracking the progress of the Job. There are two parts to POP Process are GUI based Delphi Application for Estimating, Creating and Tracking Job’s and ETL Job for handling Invoices feed from PeopleSoft.

Responsibilities:

Gathering the business requirements from the business, Development Team and Managers to analyze business needs and developed technical specifications.

Analyzed current and Optimized existing code for integration.

Design and developing bpl’s in Delphi according to the requirement and implement in the application.

Designed & implemented new User interfaces in the Operations Module using Delphi VCL.

Responsible for the full life cycle of a variety of applications, from initial design through development, testing maintenance.

Defined check constraints, Integrity Constraints, indexes and views based on business requirements.

Interaction with direct client and providing UAT to the client.

Database design, enhancing the functionalities of the stored procedures and designing the queries to support several reports in SQL2008.

Performance tuning in both Delphi and SQL.

Implementing and developing batch jobs using multi-threading concept in Delphi to post large volumes of data.

Design and develop the logic in Delphi database components - Borland Database Engine (BDE) and ADO to connect SQL 2008.

Interaction with direct client and providing UAT to the client.

Writing Test cases for Tester after Unit testing and flow testing documents.

Production release and version controlling using start team and clear case.

Creation of the Technical Specification documents

Participating in Internal and external studio revshare Audits.

Migrating to the latest Delphi version Delphi XE.

Bug Fixing

Environment: Delphi 2006, MS SQL server, Oracle, Delphi 2006, Delphi 9, Oracle, Windows XP, Clearcase, Windows XP, Rave Reports, Express Quantum Grid, JEDI Components, Clear case, Service now for change management and JIRA.

Software Development Approach – SDLC (Water Fall Methodology)

Efftronics systems Pvt Ltd Feb 2006 – May 2008

Role: Senior Delphi Developer

Location: Vijayawada.

Project: NMDL (Network Management of Data Loggers)

The project is being developed in Delphi, oracle and interbase. Signaling Data Logger is meant for log all information about tracks, point, and signals in that network whenever a train passes in the network. NMDL Receives data from the data loggers in the form of packets and posts the data into the data base. Based up on these data It will prepare concerned reports. Main technology used in this project is serial Port Communication.

Responsibilities:.

Developed database objects such as Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.

Design and Implement the different Standard Protocols.

Migrating Large volumes of data from NMDL database to New NMDL database in SQL server 2000.

Developed serial port communication for data transmission between GUI and data loggers.

Designed & implemented new User interfaces in the Operations Module using Delphi VCL.

Gathering extensive information regarding various types of interlocking Adapted by the Indian railways

Developed serial port communication for data transmission between GUI and data loggers.

Developed decision making reports using third party components Profgrid.

Generating the reports as client required.

Integrating USFD (Ultra Sonic Flaw Detector) With NMDL

Creating dynamic SQL in Stored Procedures to support the dynamic nature of the front end application.

Exception Handling in Delphi and Bug fixing

Environment: Delphi 6/7, SQL Server, Windows XP and HP Quality Center.

Development Approach - Agile Methodology

Efftronics systems Pvt Ltd July 2005 – Feb 2006

Role: Senior Delphi Developer

Location: Vijayawada

Project: Ultra Sonic Flaw Detector (USFD)

The project is being developed in Delphi, SQL Servlets and interbase. USFD Data logger is meant for log all the information about the flaws on tracks. Mainly this data logger contains sensors which are rolled on tracks and detects the flaws. Whenever the flaw is detected, it is logged on the data logger. At which place the flaw is occurred and what is the type of flaw all this information is logged in this datalogger. Once we connected the datalogger to this software. It uploads the data from the datalogger, validates the data and posts into database. By using this we are also able to send the commands to the datalogger. Generated the reports as required by client. Recently we got the RDSO certification.

Responsibilities:

Design and Implement the different Standard Protocols.

Developed serial port communication for data transmission between GUI and data loggers.

Designed and created SQL Database objects like tables, indexes, and views based on user requirements.

Designed &Implemented new User interfaces in the Operations Module using Delphi VCL.

Design and develop the logic in Delphi database components - Borland Database Engine(BDE).

Developed the Modules in Delphi where Validations are takes place, means eliminating the duplicated data and unwanted data before posting data into database.

My work involves Database design, Debugging of stored procedures, enhancing the Functionalities of the stored procedure in SQL. etc.

Writing Test cases for Tester after Unit testing and flow testing documents.

Wrote complex SQL queries with complexity using Inner/Outer joins Union All.

Environment: Delphi 6, SQL Server, Oracle, C#.Net, Windows XP

Development Approach - SDLC

Contact this candidate