SUMMARY:

• Above 13 years of experience in n tier client - server architecture, windows based, handheld, web based business application in Global Tax Group, 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 Warehouse Solutions.

TECHNICAL SKILLS:

Languages: VS.NET 2013 (.net 4.5/3.5/2.0/1.1 ), MVC (3.0/2.0/1.0),MVVM (3.3),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.WCF, Windows Service, Web Services.

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, Telerik/Kendo Controls SQL Navigator, PL/SQL Developer

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, SOUTH AMBOY, NJ

Software Consultant

Responsibilities:

• Developed Marketing DashBoard for Marketing and Sales Operations Team with Kendo UI Chart Controls
• Developed Marketing Overview, Requirements to Achieve SPE, Opportunity, Conversion with Line & Bar Charts
• Marketing Overview has Line Charts for Retails Units Trend, Actual Advertising Spend for Current Year, Last Year.
• Developed Advertising Budget Total Donut chart having traditional, digital and others media
• Requirements to Achieve SPE having Conversion Rates required to Achieve SPE with Bar Charts were developed.
• Opportunity Sales Traffic and Web Traffic Bar in Bar Charts were developed.
• Sales Funnel Chart (Internet and Phone) with Lead, Contacted, Appointment, Show, Closed were developed.
• Entity Framework 4.0 was used to develop data access layer.
• Database Objects Stored Procedures, UDF Functions and views were created as per specification
• SSRS reports were generated as per specification

Environment: VS.NET 2015, ASP.NET 2015, VB.NET2015, SQLServer2012, Kendo Controls, HTML5, CSS3, JavaScript, Entity Framework.4.0

Confidential, EDISON, NJ

Senior Developer

Responsibilities:

• Developed OID Dashboards having Transaction Entry for Account Type, Contra, Transaction Type Tree View, List View, Data Grid Telerik Controls were used to develop dashboards
• Customer position and Transaction (OID,UIT,REM) Files were generated as per mapping diagram.
• Customer position has File Header, Account Demographic Record, Cusip Header, Cusip Account Opening Position Record, Customer Transaction Record, Customer Account Closing Record, Cusip Trailer and File Trailer Record
• Customer Paib and TNC Transaction SSRS reports were developed as per specification.
• Microsoft DAL 5.0 was used to develop DAL.
• Stored procedures, Tables, views, UDF, CTE, Bulk Insert were written as per specification.
• SSIS package were written for bulk load from txt to SqlServer Database
• Unit Testing, Production Testing was done as per specification.
• Developed Smart Loan Inventory Management files for Broadridge.
• C# Class Library developed for Pending Trade File, R-DMaster, Stock Record, Memo Seg Data File.
• C# Class Library developed to build header, detail and trailer data record.
• Data files generated as per mapping files as per specification.
• Database objects Stored Procedures, CTE, Views,UDF Functions were generated as per specifications.
• Team Foundation Studio was used for source check-in and check out.

Environment: VS.NET 2015, ASP.NET 2015, C# .NET2015, SQLServer2012, Telerik Controls, Kendo Controls, HTML5, CSS3, JavaScript, Entity Framework.

Confidential, NEW BRUNSWICK, NJ

Programmer Analyst

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,SSRS

Confidential, EAST RUTHERFORD, NJ

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 TemplatesShare Point Server 2007,SSRS

Confidential, NEW YORK, NY

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
• Summary Grids was built for Dispute Tracker as per Status: Approved, Pending, Disputed and Total
• Dashboards has filters for Carriers, Data Range month, year, quarter, YTD or a specific date range
• Invoice Headers and Invoice Details can be viewed on left Panel
• Grid Dispute Elements: Dispute#, Dispute Amount, Settlement, Savings Amt, Pay Amt Dispute Date.
• Multiple Payments to an open invoice for payment.
• SSRS Reports were developed as per business specifications and TFS was used for Version Control

Environment: VS.NET 2010, ASP.NET 2010, C# .NET2010, MVC2.0, SQLServer2008, Telerik Controls, Kendo Controls HTML5, CSS3, JavaScript, Entity Framework.

Confidential, SYOSSET NY

Senior Program Analyst (Team Lead)

Responsibilities:

• Developing EDI mapping specifications and documentation to perform all EDI processes, Purchase Orders, transmission of ASN, invoices, orders (850,855,856,810) documents as required.
• Testing, implementing and maintaining EDI transactions, developing and maintaining trading partner definitions including relevant translation objects utilizing EDI translation software tools.
• Responsible for processing 850’s, SSRS, contacting purchasing with any EDI issues, and making corrections to orders for vendors.
• Coordinate shipping in accordance with customer specific routing guides & requirements, so that all orders received are in the “Shipping Batch” and ready to ship.
• Support clients and trading partners with their non-standard requests for ad hoc reports, testing analysis and deliverables.

Environment: Tried VAN: Klein Schmidt Trading Partner VAN: Commerce Sterling

EDI Mapping Tools: Altova Map Force 8.0, Altova Map Force Server, TCPX Server

Database: SQLServer2005

Confidential, UNIONDALE, NY

Senior Software Developer (Team Lead)

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
• Responsible for Writing Software Requisition Specification for 248 and 568 (Contract Payments) Transactions for the State of OH,NY,MD as per file formats
• Developed Database Diagrams, Functional Requirements, Screen Designs and Stored Procedures
• Inbound Libraries were developed for processing 248 and 568 Transactions for OH,NY,MD
• Billing, Payments, Meter Readings and Correspondence modules were populates as per business specification
• Test plans were created and testing was done by QC Team
• Complete mapping and transformation documentation from Marketer to UtillBill Database
• Scheduling the data from Excel files to SqlServer Staging Tables
• ETL Meta Data documented (Customers, Service Locations, Meters, Account Balancing, Tax Jurisdiction)
• Stored Procedure, Tables and UDF functions were written as per business specification
• UtiliBill Auto Bill register, Marketer Sync File, Rate Class Module were developed by India Team
• UAT Testing was done onsite and then in production

Environment: SQLServer2008

Confidential, WATCHUNG, NJ

Software Developer

Responsibilities:

• Executive Dashboard for Customer Order, Planned Order, Purchase Order, Purchase Order Line, Late Ordersand Shipment details with C# Web Forms.
• 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
• Provide real time Formula capability to view: Accurate container-based lot inventory Current disposition in terms of status: Available, Allocated, Quarantined, Restricted, Rejected, And Expired
• Automatic generation of Purchasing Requests. The automatic propagation through the QC, Purchasing and Scheduling forms that an item has been received.
• Built database-driven tree menu using C#,ADO.Net objects to access data from SQL Server
• Wrote complex stored procedures, triggers, Queries and fine-tuned the database indexes using SQL
• Created reusable classes to format and validate data on Client Side
• Visual Source Safe was used for Source Control
• Ingredient List, Formula List, Alcohol Drawback Claims Submitted Win forms were developed per specification.
• Responsible for System Analysis, Designing Win Forms in C#, DAL, BO Layer providing training and supports.
• Microsoft Application Data Block was implemented for DAL.
• Formula List, Alcohol Drawback Claims Maintenance, Formula Submitted Not Approved, Log Entries SSRS reports were generated.
• Database Objects Tables, Views, Triggers, Stored Procedures (T-SQL) were developed as per business specification.
• Click Once was used for deployment on Citrix Server and VSS was used for Source Control

Environment: C#2005 (Win Forms), SqlServer 2000, SSRS, Toad for SqlServer 5.7

Confidential, AVENEL, NJ

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.
• Periodic downloading of the csv file from Metro Fuels and Champlain Fuels.
• Importing the data, cleansing, validation to SqlServer Database (ETL).
• Creating a Metrofuels.dat files to import to Shop fax System. Reports were generated to test the imports.
• Trips Tickets, Inbound Inspection, Outbound Inspection, Way Bills, Pay sheet were scanned as per the Act with bar codes implemented on each trip document for tracking.
• Responsible for requirements gathering, preparing functional, technical design documents.
• Defining, designing, and building database schema to address specific business needs.
• Developed a Search engine (Win Forms).document as per Trip Ticket, Location, Trailer, Tractor, Driver and Workday.
• Safety Compliance and Dispatch Operation reports were created with SSRS.
• Email Utility was created to email documents within department with Email Objects.
• SSIS packages were used for Alerts to monitor scanning operation with dispatch operators.
• Stored Procedures, Tables, Views, Triggers and T-SQL were used to design back end.
• SqlServer Reporting Services was used to design the Operation Reports, while MVC 2.0 was used to design Portal.
• Scan Operation Reports, Terminal wise, Dwell Reports, Kiosk Operation Reports
• StoresTimeWindow Reports, Routing Reports were designed as per business needs.
• Stored procedures were written as per business needs for reports. Report Viewer was used as Reporting Services.
• Various Views were created as per MVC 2.0 design pattern.
• Users, User Groups, Roles (Win Forms) were defined Security layer was designed.
• Integrated with Active Directory of Windows 2003 Server.
• GeoFence Layer, Encryption, Load Analysis, ExporttoExcel, ZipCodeLookup, RegexBuilder class library were build.
• Create Read Update Delete (CRUD), Image enhancements, Email Alerts base forms (Win Forms) were designed for master maintenance. Data Access Layer with ADO.NET 3.5 was designed
• File System Access forms were designed.
• 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, HASBROUCK HEIGHTS, NJ

Sr. Developer eLeaseworks

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.
• Involved in Migration of Leaseworks Application from Visual Basic 6.0 to Visual Basic 2005.net.
• Migration from ADO to ADO.NET. Experienced with Microsoft .Net technology (VB.Net) and with actual migration of VB applications to the .Net platform.
• Infragistic Net Advantage 2007 controls are used to develop the Windows User Interface Layers (Win Forms).
• Coordinating with DBA Team and QA team to carry out test transaction.
• Stored Procedures, Views, Tables were created as per specification.
• Communicating with offshore team to carry to migration of different modules.

Environment: VS.NET 2005, VB.NET, Oracle 9.0, Crystal Report 10, Infragistics Net Advantage Control 2007

Confidential, NEW YORK, NY

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