PROFESSIONAL SUMMARY

• Around twelve years of hands on solid experience in Enterprise Desktop / Web-based application development on various platforms using VB.Net/C#/ VB6.0, ASP/ASP.Net, AJAX, VB/VBA Script, Java Script, and HTML with databases such as MS Access, MS SQL Server 2000/2005, Visual Studio 6/2003/2005/2008 and Oracle.

• Around two-four years experience being Analyst/Team lead/Architect responsible for analyzing the business needs of clients and stakeholders to help identify business problems and propose solutions.

• Participated and helped internal auditors to achieve standardization of the SDLC

methodologies/processes within the organization according to the ISO 9000 standards.

• Expertise in component based N-tier applications development using MTS, COM/COM+ in VB6.0 / VB.Net / C#.

• Proficient in development as well as worked on successful conversion of legacy applications in VB6 to .Net 3.5 based C# applications for Winforms.

• Highly competent working on MVC architectural pattern based application design.

• Extensive hands on experience working with ORM using Linq to SQL/Entity framwork designer for ASP.Net MVC application.

• Made appropriate and successful utilization of latest .Net features like GENERICS, Extension Methods, Anonymous Types etc for business objects collections.

• Well versed in Object Oriented Analysis and Design phase of the SDLC using UML.

• Extensive exposure and hands on experience using VBA in order to do automation for different office applications like Ms Word, Ms Excel and integrate those with desktop applications.

• Acquired hands on experience in data modeling tools like Erwin and helped DB designer team to achieve on-time design documents.

• Extensive hands-on expertise designing cross-tab/drill-down/on-demand reports using SQL Server 2000/2005 Reporting services as well as using Business Objects Crystal Reports 6.0/8.0/X/XI/2008.

• Comprehensive experience in development/deployment of .Net Windows Services/XML Web Services/WCF services.

• Sound experience in using Third party ActiveX controls (like Sheridan controls, Visual Components, Apex True DB Grid)

• Highly Proficient in working with T-SQL / PL-SQL for MS SQL Server/Oracle.

• Heavily Explored development for Mobile devices using Microsoft Dot Net Compact Framework in Windows CE 2004 environment while working for an in-house task force.

• Well versed in the working knowledge of ASP.Net MVC 1.0 based applications as well as knowledge about enhanced new features available in MVC 2.0.

• Strong experience in application maintenance areas like code reviews, Quality checking, regression testing.

• Integration between ASP.Net application and QuickBooks 2003/2004 in order to import/export financial data between them.

• Excellent interpersonal and communication skills, both oral and written.

• Sound experience in Project Planning, Time Tracking, Recourse allocation using Microsoft Project.

TECHNICAL EXPERIENCE

• Languages: VB.Net, C#, VB 5.0/6.0, T-SQL, HTML, VB Script, Java Script

• Front End Tools: Visual Basic 5.0 / 6.0, Visual InterDev 6.0 And Front Page

• RDBMS: SQL Server 6.5 / 7.0 / 2000 / 2005, MS Access 7.0

• Technologies : XML Web Services, WCF, ASP.Net / ASP /ASP.Net 3.5/

ASP.NET MVC 1.0, AJAX, ActiveX (COM/DCOM), GENERICS,

LINQ, WinForms, WebForms, .Net Compact, BI Development,

SSIS,

Framework for Mobile devices, ORM (Object relational Mapping), VSS, TFS, Entity Framwork

• Reporting Tools: Business Objects Crystal Reports 6.0/8.0/10.0/XI,

Formula One, SSRS

• Modelling tools: Er-Win, Rational Rose for UML

• IDE: Visual Studio 6, Visual Studio.Net 2003/2005/2008

• Design/Architecture: N-tier Architecture, MVC , SOA

• Project Planning: Microsoft Project, Windows Share Point

Services/Share Point Portal Server

• Financial Tools: QuickBooks 2003/2004

• Defect Tracking: Compuware Track Record©, Test Director

• Testing Tools: SOATest, SoapUI

PROFESSIONAL EXPERIENCE

BMV (Bureau of Motor Vehicles) Feb’10 – To Date

State Government of Indiana

Indianapolis, IN, USA

Senior IT Applications Analyst

BMV has diversified number of departmental applications like Inventory Management/SCM (Supply Chain Management), High Volume Image Retrieval / L1 Photo First, ARP (Automated Replenishment Process), and STARS (State Tracking And Record System) developed and designed using state of the art latest technologies like ASP.Net 3.5, VB.Net, C#, Sql Server 2005, SOA, XML Web Services etc.

Responsibilities:

• Successful development on VSS based ASP.Net application with VB.Net/C# and Sql Server 2005 and extensive usage of TSQL for writing complex stored procedures.

• Participating in the implementation of latest Milestone in AAMVA’s specification for CDLIS/PDPS/NMVTIS so that new ACD Codes can be used and validated/crosschecked on AAMVA/CDLIS/UNI specifications for CDL customers nationwide in order to synchronize AAMVA’s CVP.

• Leading the development of an in-house pilot project for Employees and their related involvement in different projects called Employees-Projects using MVC 2.0, Entity framework, C#, .Net 3.5, SqlServer 2005 and AJAX.

• Lead the whole development life Cycle to introduce new kind of ID in the system for public i.e. Paper Voter-ID. Successfully managed to do analysis/design, development, DB scripts writing and report generation for this new business entity.

• Spearheaded the conversion of Crystal Reports in Excel/Word/PDF format by adding new functionalities in underlying XML Web service for Report viewing and made add-on generic assemblies.

• Added value to the Branch-based application named STARS by successful implementation of BPO (Business Processes Optimization) related to Driver Services for Interim License Issuance.

• Rolled out modifications on revised business rule by State of Indiana Laws in order to add/remove Lien Holders on Vehicle/Watercraft Titles.

• Development of SSIS packages in order to generate triggered emails for different Customers doing online Driver License/Vehicle Registration Renewals as well as modification of an existing SSIS package feeding Branch/County wise financial data to PeopleSoft Financial interfaces for the generation of abstract reports.

• Development of windows based Timesheet for internal projects using C#, WinForms and Sql Server 2005.

• Designed and developed ASP.Net MVC/C# architectural based utility which has been used locally to get the information about customers, updation of its properties and correspondingly updation of its image in the underlying SQL SERVER 2005 DB.

• Utilized SOAPUI (an Open source tool) for unit testing of SOAP based APIs.

………………………………………………………………………………………………………………………

Duke Energy Sep’09 – Feb’10

Plainfield, IN, USA

Senior IT Application Developer/Analyst

Duke Energy is one of the largest electric power companies in the United States. They supply and deliver energy to approximately 4 million U.S. customers. They have approximately 35,000 megawatts of electric generating capacity in the Midwest and the Carolinas, and natural gas distribution services in states of Ohio and Kentucky.

Responsibilities:

• Successfully Converted the whole (front end code, Middle-Layer and Data centric Layer) VB6/COM based legacy applications to .Net 3.5 based C# Win form applications.

• Utilization of Extension Methods, Anonymous Types over LINQ based GENERIC objects collections as well as intrinsic .Net controls.

• Utilized third party software i.e. CYBERMATION ESP for DB/Windows based jobs scheduling.

• Added some of the missing Customer information in online Billing Services web application composed of duke’s diversified mixture of technologies in order to provide online billing services to millions of customers as well as 24/7 support for call center’s IVR applications.

• Designed and developed new ASP.Net MVC 1.0/C# based application having main objective to analyze information passed form another application with updated Credit information in order to let decide business whether new customer has to go through paying deposit to get power connection or not along with some other features.

• Developed new as well as modified existing SSRS reports being specifically developed for business executives in order to provide them abstract picture of overall business process being handled using integrated cross platform advanced tools and technologies as well as back office SSIS packages.

• Created couple of ETLs using SSIS packages in order to transform, delete and backup data among heterogeneous DB systems like SQL Server 2005, ORACLE 10g and Main frame.

• Integration of C# based XML Web services (through VB.Net based bridge application) with legacy VB6 desktop application using COM Interop feature of .Net framework 2.0.

• Lead the development for the conversion of ASP.net application from framework 1.1 to framework 3.5 as well as conversion of singleton components to XML web services.

………………………………………………………………………………………………………………………

BMV (Bureau of Motor Vehicles) Nov ’06 – Sep’09

State Government of Indiana

Indianapolis, IN, USA

.Net Consultant/Sr. Analyst/Architect

Developed and designed multiple systems, including Inventory Management, High Volume Image Retrieval / L1 Photo First, ARP (Automated Replenishment Process), and STARS (State Tracking And Record System)

Responsibilities:

• Participated in Requirements gathering, RFD writing as well as designing module architecture to be integrated with current available business Rule Engine.

• Development using VB.NET/ADO.Net/SQL Server 2000/2005 for web-based ASP.Net applications

• Written lots of complex Stored Procedures / Triggers / UDFs using TSQL for different new modules being incorporated in the application for SQL Server 2000 / 2005.

• Designed layout of monthly as well as weekly Supply Chain Management reports using Crystal Reports X/XI.

• Utilized Track-Record© (A defect tracking system) in order to manage and track existing and new defects being generated by UAT testers.

• Developed process automation to generate License Plates orders for all BMV branches throughout the state of Indiana on the basis of Min-Max attributes setup.

• Designed customer/Transaction based reports using Business Objects Crystal reports X/XI integrated with .net environment.

• Added functionality by consuming L1 Identity Solutions Web Service in order to retrieve last updated image from L1 image server at high volume image Services for Temporary Paper License. It needed DLN of the customer to be passed as parameter and then give back XML serialized object having portrait and other customer’s info to STARS.

• Extensively used Microsoft VSS for source control facilities for DEV, UAT and PRODUCTION PARALLEL environments.

• Participated ORM based module development using Linq 2 Sql designer.

• Participated in the development of different modules of the system like LEGAL Services, DRIVER Services, FINANCE, INVENTORY/SUPPLY CHAIN MANAGEMENT, VEHICLE/WATERCRAFT TITLES and REGISTRATIONS.

• Developed new web site from BMV named http://www.MyBMV.com in order to let customers renew their vehicle registrations/Titles without visiting personally any branch and also let them to see their Driver’s record reports. It is being developed using VS2008, ASP.net 3.5, C#, Sql Server 2005, LINQ to Objects as well as AJAX.

• Lead the development of standard transaction voiding utility providing the facility to CSRs to void an ongoing transaction and make financial trial balance updates by reversing the payment as well as different applicable fee.

• Added new enhancements in INVENTORY module to have different new

functionalities / features like INVENTORY RECONCILIATION with already existing inventory and PHYSICALLY SCANNED FILE, CONFIRMED, EXCEPTION and SHRINKAGE INVENTORY reports, INVENTORY HISTORY BATCH process and reports and INVENTORY PLATES AUTO REPLENISHMENT process.

………………………………………………………………………………………………………………………

Texas Gas Transmission, KY, USA Aug’05 – Nov’06

Net Consultant/Sr. Developer

GasQuest (Interactive Web Site provided by Texas Gas Transmission, LLC )

.

Responsibilities:

• Development using C#/VB.NET/ADO.Net/SQL Server 2000 for ASP.Net web-based application.

• Development of .Net Windows Services which were being used to schedule different reports on different already selected Date/Time using application’s Task Scheduler module.

• Created a couple of office automation related desktop utilities in order to get data from SQL SERVER and dumping it in MS Excel using VBA.

• Used CruisControl.Net for build as well as deployment methodologies.

• Created some of the strategically important reports in Ms Excel using data from Ms Access views as well as SQL Server stored procedures using VBA scripting.

• Written Stored Procedures/Triggers/User-defined Function using T-SQL/PLSQL for different new modules being incorporated in the application for scheduling automation process using SQL Server 2000/ORACLE.

• Utilized SQL Server 2000 Reporting services in order to design and develop business oriented web-based as well as desktop based reports having different methodologies to represent data in different time slices representing reports as web services.

• Reports designing using Business Objects Crystal reports 10.0/XI integrated with .net environment

• Redesigned and developed new versions of Standard, Cross-tab and on-demand sub-reports integrated with .Net assemblies as Data source.

• Developed and used some of the VB6.0 COM compliant components for legacy system and used them as COM–interop in current ASP.Net application.

• Followed SDLC and designed/developed desktop utility using VB.Net in Win Forms having main purpose to generate different kind of generic VB.Net class as well as SQL 2000 Stored Procedure code snippets for reusability for different developers.

• Utilizing the windows SharePoint services to manage, collaborate and share the documents among project team members as well as with other project leads.

• Reports management, deployment and scheduling using Central management Console.

………………………………………………………………………………………………………………………

MendSoft, MD, USA Jun’04 – Jun’05

A US based customized application services provider with Fortune 100 clients like GE Medical and Fujinon.

Sr. Software Engineer / Business Analyst

Responsibilities:

• Started the participation in the project being Business Analyst / Software Engineer and took it to the end of phase one going through all steps of iterative SDLC.

• Spearheaded as a liaison among stakeholders in order to elicit, analyze, communicate and validate requirements for changes to business processes, policies and information systems.

• Interacted and participated with the internal auditors to upgrade the SDLC methodologies within the organization according to the ISO standards and presenting the current project as PILOT PROJECT for ISO 9000 certification.

• Developed Mobile application UI using .Net Compact Framework for PDAs running on Windows CE 4.0 which was being used by local representatives to log their locations, get new assignments, info about client and details of the work order they were going to deal with.

• Designed different analysis report sheets for SMART PHONE, PDAs running on Windows CE.

• Development using ASP.NET /VB.NET /C# /SQL Server 2000/Crystal Reports.

• Analyzing the requirements, FDS writing, DB designing as well as application wide architectural exposure using USE CASES and working with application flow control among the highly qualified professionals.

• Participated in front-end/Middle-layer development using VB.Net for Win Forms in order to generate logical bridging between the status of equipment sent in to the application and different kinds of repairs done on it so that an in-house analysis survey can be done showing the percentage of amount of work to be done yet by the equipment repairing staff.

• Integration utility development between MendSoft and QuickBooks 2003/2004.

………………………………………………………………………………………………………………………

DESCON IT24 /DESCON Engineering Apr ’99 – June’04

Participated in Analysis, development, testing and deployment of different enterprise level web-based and in-house desktop applications like Activity logger to log daily activities, web-based activities logger, financial management system, bidding system as well as an ERP system.

a) Financial management System (DEFines) (Sr. Analyst/Developer)

b) Activity Logger (Technical Team Lead)

c) Cab System (Technical Team Lead)

d) WinBid (A Bidding system) (Sr. Analyst/Software Engineer)

e) SMART (A customizable ERP solution) (Analyst/ Software Engineer)

Responsibilities:

• Customization in the application to make it more scalable, robust and user friendly depending upon requirements using C# coding best practices.

• One of the major responsibilities was to communicate with the client in order to get its requirements as well as analysis/Design of the features to be incorporated in the application.

• Maintenance of the account of different categories Like ASSETS, LIABILITY, INCOME AND EXPENSE as well as preparation of Voucher based on a pre-design process which organization had to follow means that 90 % of error removal.

• Development on daily cashbook routine was also the key feature that report could be taken on any date of financial year as well as development of the system for backdated transaction and posting. Automated posting and different site data conversion. The Automated Expense claim and Medical claim voucher preparation.

• Participated in major Development using Visual Basic 6.0/VB.Net as well as SQL Server for back end proceedings as well as reports designing using Crystal Reports.

• Spearheaded Project Planning along with resource allocation using Microsoft Project.

• Developed a comprehensive tool for cost estimation regarding the procurement, manufacturing and other engineering related activities

• Development of different COM components in order to provide some seamless user related functionalities in order to view different comparison reports and graphs.

• Developed COM-interop for COM components (developed in VB 6) integration with the application for some common functionalities to be provided in the application.

• Analysis and Middle-layer/Back-end development of different enterprise level ERP system modules including Smart Item Coding, Smart MRP (Material Requirement planning), Smart PMS (Procurement Management System), Smart ICON (Inventory control system)

…………………………………………………………………………………………………………………..

GTE Mobile (Houston, TX) Oct’98 - Apr’99

VB 6.0 Developer

Responsibilities:

• Participated in Discussions with various dept.’s / people involved in payments, medicine to finalize the functional Specifications

• Developed couple of new modules in the application using VB6, Ms Access

• Developed CMS and PMS log modules, which showed to the user about the pending or completed faults on different cell sites along with the activities, which were either completed, or to be completed. It also helped the user to find out overall efficiency of a particular cell technician or all of them, using graphs (using First Impression ActiveX control).

• Used Seagate Crystal reports to undertake some business oriented reports. Also got involvement in developing ActiveX controls in VB6.

………………………………………………………………………………………………………………………

Applied Material (Houston, TX) Mar'98 – Oct’98

VB 6.0 Developer

Responsibilities:

• Participated in development of real-time shop floor screen for a discrete assembly line system.

• Utilized third party Graph Designer tool i.e. First Impression in order to generate PRODUCTION based information for Cell Site activities by different cell technicians.

• Designed and created some important critical reports of the system with respect to a specific time frame using Crystal Reports 8.

• Designed different barcode formats for different activities taking place.

• Involved in designing UIs for different other auxiliary functionalities related to optional application parameter values assignment.

EDUCATION

BCS (1995-1998) (Major in Computer Sciences)

Punjab University, Lahore, Pakistan

Punjab Institute of Computer sciences, Lahore, Pakistan (C.G.P.A = 3.30)

B.Sc (1992-1994) (Advanced Mathematics, Physics)

Punjab University Lahore, Pakistan

CERTIFICATIONS

Microsoft Certified Professional (MCP ID: 3057381)

• 70-175 ----- Designing Distributed Applications using VB6.0

• 70-100 ----- Analyzing requirements & defining Solution Architecture

• 70-306 ----- Developing Windows-based Applications with VB.Net

• 70-305 ----- Developing Web-based Applications with VB.Net/ASP.Net

• 70-229 ----- Database designing using MS SQL SERVER 2000

• 70-536 ….. Microsoft .NET Framework, Application Development Foundation using C#

Brain Bench Certified Visual Basic.Net Fundamentals (Transcript ID: 6376692)

Brain Bench Certified ASP.Net (Transcript ID: 6376692)

Brain Bench Certified .Net Framework Fundamentals (Transcript ID: 6376692)

Brain Bench Certified RDBMS Concepts

Brain Bench Certified Visual Basic 6.0 Programmer

Brain Bench Certified C# Programmer (Transcript ID: 6376692)

Brain Bench Certified C# 3.0 Programmer (Transcript ID: 6376692)

Brain Bench Certified Crystal Reports 11 Programmer (Transcript ID: 6376692)

Contact this candidate