SUMMARY:

• Above 13 years of experience in n tier client - server architecture, windows based, handheld, web based business application in confidential, Real Estate, Communications, Video Distribution and Energy Billing Industry.
• Directly involved in design, development and maintenance of web based business application.
• Understanding the client’s requirements and designing database model.
• Implemented ADO.Net Data Access Techniques SQL Connection Objects, SQL Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects using Data Grid, Data List controls.
• Experience in creating content rich Web Forms, Win Forms, and User Controls with Net Advantage Infragistics 2013.
• SQL expertise in database design and database programming (Stored procedures, Triggers, Packages) using MS SQL Server 2012/2008/2005 , Oracle 9i/8i/7.x and MS Access 2000/97.
• Worked with ERP Applications at David Michael Flavors and Tri Ed Distributions (Epicor).
• Experience with Source Control Management tool, Visual Source Safe (VSS), Subversion, Team Foundation Server.
• Financial Domain worked with Budgeting System, Leasing Business and Global Tax Group Solutions.

TECHNICAL SKILLS:

Languages: VS.NET 2013 (.net 4.5/3.5/2.0/1.1 ), MVC (2.0/1.0),MVVM (3.0),VB.NET, ADO.NET 3.5, ASP.NET, C#2010,LINQ, Visual Basic 6.0,Excel, VBA, Java Script, XML, ASP, Visual ASP (Tree, List, Tab Component), Ajax 2.0, Jquery,HTML5,CSS3,Toad for SqlServer 5.7,ORM Tools, Entity Framework.

Scripting Library: Knockout.js, Angular.js

Software: Infragistics Net Advantage 2007, Visio 2003, Appforge, eVB, Erwin3.52, Query Analyzer, Sheridan Controls, True DB Grid Controls, SQL Navigator, PL/SQL Developer, Toad

Databases: MS Access, PL/SQL, T-SQL, Oracle 9.0i, SQL Server (2005/2008/2012 ), CTE,Idera Oracle Utilities, Import/Export, SqlServer Management Studio, SQL Loader, Sql Server DTS

Methodologies: Object Oriented Programming, MVC (2.0/1.0), MVVM (3.0), UML, and ETL, SOA.

Reporting Tools: Crystal Reports (6.5/8.0/10.0 ), SqlServer Reporting Services (2005/2008/2012 )

Servers: Small Business Server, Internet Information Server. 6.0, Share Point Server 2007

Op. Systems: Windows (2012/2008/2003 ) Server, Win XP and Win CE 3.0, Windows Admin, Citrix Servers.

Project Mgt.: (Agile Scrum Methodologies), MDE Project Management Tools

EDI Mapping: Altova Map Force 8.0, Altova Map Force Server, EDI- HQ, TCPX Server, EDI Dev Framework

PROFESSIONAL EXPERIENCE:

Confidential

Lead Programmer

Responsibilities:

• Responsible for developing Exhibits LR6 and LR48 Tax Group as per specification.
• LR6 has Legal Entity, Cycle Year and Scenario Panel for Exhibits was developed.
• Current Exhibit and Comp Exhibit Comparative Panels were developed as per specification.
• Migration of FoxPro Legacy Application to VS.NET 2013 and SQL Server 2012.
• Developed Global Tax Ware House Reports with Container Reports and 9 Sub Reports
• Microsoft Data Access Layer 5.0 was used to develop DAL. Infragistics controls 13.0 were used to develop WebUI.
• T SQL written for Stored Procedures and CTE were used to develop SSRS.Conversion scripts to migrate data from Excel to SqlServer.
• Leading Development Team and periodic meetings with LR6 and LR48 Business Operations Team.
• Team Foundation Studio was used for Source Control.

Environment: VS.NET 2013, ASP.NET 2013, C#2013, SQLServer2012, Infragistics Controls 2013, MVVM, Knockout JS. Microsoft DataAccessLayer 5.0, Visio, Office 2007

Confidential

Technology Team Member

Responsibilities:

• Function as a part of the Global V&A Business Solutions team. Responsible for production of complex and sophisticated appraisal Self Storage templates by eliciting technical requirements using business analysis techniques to ensure published templates adhere to the applicable appraisal standards.
• Developed Win Forms for Property Type Self Storage, Owners Historical, Historical, Expense Comps, Performa, and Cash Flow were developed as per specifications
• Push and Pull to Vantage database was done as per specification (T SQL written Stored Procedure, Tables, Views).
• Designed Database Model, Tuning, and SSRS as per specification.
• Appraiser Word documents were generated and Data Excel Sheets were tested for the data load.
• Onsite Development and Offshore Testing was done as per specifications

Environment: VS.NET 2010, VB.NET2010, SQLServer2008, Visio, Office 2007, Office 2013, Word & Excel Templates

Confidential

Sr. Developer / Business Analyst

Responsibilities:

• Analysis for 811 EDI DataFile, Carrier 811 Guides, Populating the data in Invoice Header and Invoice Details and Staging Table and then Dashboard, Reports for Totals are balancing.
• C# Class Library was developed Carrier: ATT having BDF DataFile.
• C# Class Library was developed Carrier: CenturyLink with Pay Codes 0432,0E00,0W00,0C00 having Edi files
• T SQL Scripts were written to load the data in Carrier: Sprint from Access database.
• C# Class Library was developed for Carrier: Frontier, Granite, Verizon and Scranton having Edi data files.
• Monthly Charges, Non-Recurring Charges, Taxes, Fees data lines were loaded in the database
• Generating Billing Account Number, Reference Number for each Carriers
• HL Loops having TX1 Lines SLN Datalines,IT1 Data lines were loaded in Invoice Header and Invoice Details
• Build Data Access Layer from Inline Sql to Stored Procedure
• SSIS Packages were written for loading 2 months data and building Demo Server, Staging Server for Client: Harland Clarke to San Antonio Texas.
• Carrier Status report was done on Weekly basis for each Carrier

Environment: VS.NET 2010,C# .NET2010, SQLServer2008, SSRS, EDI Dev Framework EDI x64 .NET, Visio

Confidential

Senior Program Analyst

Responsibilities:

• Pricing Reports, CCTV,Data Communication, Hardware, IP Solutions Reports with Pricing(EDI 832) Changes
• Wrote Stored Procedures, Tables, View, CTE in SQL Server 2005 as per Business Specs
• SSRS was used as Reporting Tool, SSIS Packages were written as per Business Process
• Tortoise was used as SVN Control.

Environment: ASP.NET (Web Forms), VS.NET2005, Vb.net, SQLServer2005, SSRS, Java Script

Confidential

Senior Software Developer

Responsibilities:

• Responsible for developing for Inbound/Outbound Libraries for Duke Gas Energy Transactions
• 814 Enrollments Request, Change Request, Reinstate Request, Response Inbound Libraries were developed as per Utility Specific File Formats
• 867 Historic Usage,810 Invoice,820 Payments Inbound/Outbound Libraries were developed
• Developed Stored Procedures, Tables, Views, UDF Functions as per Business Specification
• Define and capture metadata and rules associated with the ETL processes
• Web Forms were used for Screens Design and SSRS as Reporting Tool

Environment: ASP.NET (Web Forms), Vb.net, SQLServer2008, SSRS, Visio.

Confidential

Software Developer

Responsibilities:

• Ajax 2.0 Controls were used for developing Web Forms.
• Tree view, Data Grids, Multiview controls were used develop the Executive Dashboard.
• Report Viewer Control was used to developed the SSRS Reports
• Tables,Views,Stored Procedures were written as per business specification

Environment: ASP.NET, C#2005 (Web Forms), SQLServer2008, SSRS, Toad for SqlServer 5.7, JavaScript, Ajax 2.0

Confidential

Software Developer

Responsibilities:

• Integrating with Web services to periodic download breadcrums for Trip Details.
• Bread Crums has vehicle name, latitude, longitude, eventdatetime, odometer details (ETL).
• Data Mapping and Data Analysis was done with Erwin.
• Stored Procedure was written to assign active route to bread crums.
• Test cases were carried out for 10 Tractors/Trailers and then in production.

Environment: Vb.net 2008, SqlServer2008

Confidential

Responsibilities:

• Responsible for designing the Report Engine from the daily data feed from ADP AIX system.
• Responsible for requirements gathering, preparing functional, technical design documents.
• Operational Reports, Comparative Reports were designed as per specification.
• Created Database, Tables, Stored Procedure, Udf, Views with T- SQL.(ETL Project)
• Reporting Screens, Admin Setup Screens were designed (Web Forms).Ado.net, Dataset, Data Reader; Data Adapters were used to develop DAL.
• System Codes, Batch Reports and Audit Reports were designed to monitor periodic feeds.

Environment: ASP.NET, VB.NET (VS.NET 2005), C#, SqlServer 2005, SqlServer Reporting Services

Confidential

Sr. Developer

Responsibilities:

• Responsible for the design, development, rollout of new modules (Web Forms). Enhance existing systems.
• Developed Web Services to update the Vendor Information, Customer Information.
• Migrated Crystal Reports from Crystal Reports 8.5 to Crystal Reports 10.0.
• Portfolio, Maturity reports and Quote History reports were designed as per requirements.
• Asset Module was enhanced as per requirements.

Environment: ASP.NET, VB.NET (VS.NET 2003), C#, Oracle 9.0, Crystal Report 10.0

Confidential

Sr. Software Programmer

Responsibilities:

• Responsible for gathering requirements, developing flowcharts, system navigation.
• Involved in periodic releases of the different modules.
• Admin module, Client Configuration, Billing and Reporting module were developed.
• Coding Standards were implemented.
• UAT testing and Application Development plans were carried out as per business needs.
• Production support for the application was carried out as per business needs.

Environment: ASP.NET, VB.NET, C#, SqlServer 2k

Confidential

Programmer Analyst

Responsibilities:

• This Application carried out the Business process at their In Bound Call Centers and Out Bound Call centers for all Civic Customers.
• Involved in development of WinUserInterface Layer (Win Forms), Data Access Layer, Exception Handler layer for the roles based Enterprise application.
• Developed Queries Module, Inquiry Module, Action Module, Violation Module, Refunds Module, DNC Module, Letters Module, Playback module and Reports Module.
• Created Refunds Email Alerts and Run Query Windows Services. Developed Auto Updater Block to release the latest updates of the application.
• Compliance Reports, Fundraiser, Campaign wise reports were created using Crystal report 9.0.
• Production support to the application with Citrix Servers and enhanced the application as per new specs Wrote
• PL/SQL procedures, functions, and packages as per business needs.

Environment: VB.NET, Oracle 9.0i and Crystal Report as reporting tool.

Confidential

ASP Web Application Developer

Responsibilities:

• Involved in migrating legacy system to Web based application to carry out the Production with ASP as front end and SQLServer2K as back end.
• Responsible to write Software Requisition Specification, developing prototype and database model using Erwin.
• Developed Production Module, Invoicing Module, Factory Operations Reporting Module as per business requirements.
• Use Case and Test plans were written for stored procedure and ASP page.
• UAT and Application deployment plans were carried out as per business needs.

Environment: Classic ASP, SqlServer 2K

Confidential

Consultant

Responsibilities:

• Designed, coded, tested and implements application systems using programming languages ASP as the front end and Oracle 8.0i at Back end as demanded by the project.
• Enhanced Promotion Module, Seasonal Gift & Collateral Collections modules were developed with best program efficiency, performance, security and time completion.
• Writing stored procedure, views packages to maintain business logic at the back end.

Environment: Classic ASP and Oracle 8.0i

Confidential

Programmer Analyst

Responsibilities:

• Entire application was developed using ASP and Sql Server 2000 as back end using ASP, JavaScript.
• Communicated with the managers and prepared functional requirements. Participated in the entire full-life cycle development process including design, analysis, and requirements gathering technical development.

Environment: Classic ASP, Sql Server 2K, Visual Asp, IIS Server

Confidential

HandHeld Software Developer

Responsibilities:

• Developed customized engineering software used by Mechanical Engineers, Hydraulic Engineers, Machine Design Engineers (13 different Engineering streams) to carry out their daily-complicated Engineering calculation.
• Handled complete design and development of Machine Design "Engg Tools” and Mechanical "Engg Tools" series, a software product for handheld devices (Palm & Pocket PC).
• Developed 50 dynamic database driven forms in Embedded VB and pocket access for entire Mechanical, Hydraulic and Machine Design Tool series.

Environment: Embedded Visual Basic, Pocket Access, Appforge also IPAQ, Handspring Visor

Confidential

Senior Software Developer

Responsibilities:

• Developed Training module, Testing module, Doctor database module, Representative database module and Tour scheduling module, expense recording and master maintenance modules.
• Periodic updating of the doctors database and representative database. Periodic updating of all the new products launched and performs the test required. System was developed using ASP, Visual Interdev 6.0 /Oracle 8.0i, JavaScript

Environment: Visual Basic 6.0/Oracle 8. 0, Crystal Report as Reporting Tool and integrated with Microsoft Outlook

Confidential

Software Programmer

Responsibilities:

• Responsible for development of entire production and dispatch module.
• It keeps the pre-production details for every order with the vendors such as color, size distribution, accessories and packing instruction for every purchase order.
• Exporting the required data to excel sheet and print outs on preprinted stationery.

Environment: Visual Basic 6.0 as front end and Oracle 8.0 as back end and Crystal Report 6.0.