SUMMARY:

• Above 15 years of experience in n tier client - server architecture, windows based, handheld, web based business application in Global Brokerage Operations, Global Tax Group,Communications, and Energy Billing Industry.
• Experience in Brokerage Operation Leadership, Confidential Business Operations.
• Financial Domain worked with Brokerage Operations, Budgeting System, Leasing Business, Global Tax Warehouse.
• Leading Team across technical, financial, business discipline. Tracked the project and ensured project milestones were completed on time, on budget and desired results.
• Worked with ERP Applications at David Michael Flavors and Tri Ed Distributions (Epicor).
• Worked with Confidential Mainframe 3270, Confidential Mainframe 5250 Terminal Reflection.
• 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.
• Working knowledge in configuration and version management using Visual Source Safe (VSS),Clear-Case, Subversion (SVN) and Team Foundation Server (TFS 2008/2010/2012 )
• Experience in creating content rich WebForms, WinForms, 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.
• Experience with Source Control Management tool, Visual Source Safe (VSS), Subversion, TFS( 2008/2010/2012 ).

TECHNICAL SKILLS:

Languages: VS.NET 2015 (.net 4.5/3.5/2.0/1.1 ), MVC(3.0/2.0/1.0),MVVM (3.3),VB.NET (2008/2012/2015 ), 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, Soap, 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

Confidential Mapping: Altova Map Force 8.0, Altova Map Force Server, Confidential - HQ, TCPX Server, Confidential Dev FrameworkIBM Mainframe 3270 Terminal, Confidential Mainframe 5250 Terminal

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

Responsibilities:

• Managed all phases of the software development lifecycle (SDLC).
• Building Team, Organizing Meetings, Project Planning, Resource Allocation,Assiging Task was done
• Guided teams in the development of relational database management systems (RDBMS) for clients Scottrade.
• Database Interface with BPS (Books and Records System),AOM(Order Management),BPSA,ODS,ICS database
• Responsible for building FINRA Dashboard for Record Count for Asset,Wire,Client Contact, Client Info Change
• Components build DTO Object, Workflow Components(Line of Business:AsiaPacific,Retail,Scottrade),Email formatters,FileFormatters
• Build Class Library Data Access Layer from ODS, BPS Acomplicated query were written in database.
• Build Class Library for ICS Files Header and ICS Files Rows,Email Notifications,Bounce Back Emails Files
• Client Info Changes has Name Changes, SSNO, DOB Changes, Collection were build.
• ECM Users for BI NAAUD File updates were processed.
• BI NAAUD Data file having Client Contact Changes has Mailing Address Change, Legal Address Change, Vacation Address Changes, Email Address Changes, Phone Number Change Collection were build
• UAT testing was done by Scottrade Team.

Environment: VS.NET 2012, SQL Server 2012, N Log, BPSA, ODS Database, Logger Block, Audit Trail.

Confidential

Responsibilities:

• Data Access Layer to BPSA,ODS database for Advisor Boarding Macro.
• Collection were build for Accounts and branch locater were updated as per specifications
• BI Files BPS NAD1,BPS NAD3,BPS CPM1, BPS CPD2,BPS RELA, BPS TELE Input files were processed.
• Audit Trail, Email Notification, Log files were generated.
• Data Requirements, BPSA Mapping diagrams and Scottrade Business Specification were implemented.
• UAT Testing was done with Validation of Automation Accuracy.
• Coding Standards were maintained as per Scottrade Business Operations

Environment: Confidential 3270 Reflection, Confidential 5250 Reflection, SQL Server 2012, BPSA,ODS Database, Logger Block

Confidential, SOUTH AMBOY, NJ

Senior .Net Software Consultant

Responsibilities:

• Developed Marketing Dash Board 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.Converted existed ASP.NET MVC business and data layer to the cloud (Windows Azure)
• 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,CTEand views were created as per specification
• SSRS reports were generated as per specification
• Data Feeds from AIX ReflectionMainframe System.

Environment: VS.NET 2015, ASP.NET 2015, VB.NET 2015, SQLServer2012, WCF, Kendo Controls, HTML5, CSS3, Soap, JavaScript, Salesforce Cloud, TFS, JQuery, Entity Framework.4.0, AIX Mainframe, Web Services

Confidential, EDISON, NJ

Senior .Net 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 reportswere developed as per specification.
• Microsoft DAL 5.0 was used to develop DAL.
• Stored procedures, Tables, views, UDF, CTE, BulkInsert were written as per specification.
• SSIS package were written for bulk load from txt to Sql Server Database
• Unit Testing, Production Testing was done as per specification.

Environment: VS.NET 2015, ASP.NET 2015, C#, VB.NET2015, MVC4.5, SQLServer2012, Telerik Controls, Kendo Controls, HTML5, CSS3, JavaScript, Ajax, XML, JQuery, AIX Mainframe, XSLT, Web Services, TFS, Entity Framework.

Confidential, NEW BRUNSWICK, NJ

Lead .Net 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 Sql Server.
• Leading Development Team and periodic meetings with LR6 and LR48 Business Operations Team.
• Team Foundation Studio was used for Source Control.

Environment: VB.NET, VS.NET 2013, ASP.NET 2013, C#2013,SQLServer2012, Infragistics Controls 2013, MVVM, Ajax, KnockoutsJS. MicrosoftDataAccessLayer5.0, Visio, Office 2007, SSRS

Confidential, EAST RUTHERFORD, NJ

Lead .Net Developer

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, Jquery, Office 2013, Word & Excel Templates, Share Point Server 2007, SSRS, Subversion(SVN)

Confidential, NEWYORK, NY

Sr. Developer / Business Analyst

Responsibilities:

• 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
• Developed a web based request tracking system with Silverlight 4.0, WCF, C#.NET, SQL Server 2005.
• 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: VB.NET, VS.NET 2010, ASP.NET 2010, C# .NET2010, MVC2.0, SQLServer2008, TFS, TelerikControls, Kendo Controls HTML5, CSS3, XML, XSLT, JavaScript, Entity Framework.

Confidential, SYOSSET, NY

Senior.Net Program (Team Lead)

Responsibilities:

• Pricing Reports, Confidential, Data Communication,Hardware,IP Solutions Reports with Pricing( Confidential 832) Changes
• Wrote Stored Procedures,Tables,View,CTE in SQLServer 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 (WebForms), VS.NET2005, Vb.net, SQLServer2005, SSRS, Ajax, WCF, XML, XSLT, Java Script

Confidential

Responsibilities:

• Prophet21 is a Microsoft Windows based /Sql Server Database software package for the wholesale distribution
• Developing Confidential mapping specifications and documentation to perform all Confidential processes, Purchase Orders, transmission of ASN, invoices, orders (850,855,856,810) documents as required.
• Testing, implementing and maintaining Confidential transactions, developing and maintaining trading partner definitions including relevant translation objects utilizing Confidential translation software tools.
• Responsible for processing 850’s, SSRS, contacting purchasing with any Confidential 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

Confidential

Responsibilities:

• Developing 832 Send, 850 Receive, 855 Send, 856 Send, 810 Send Mapping specifications and documentation to handle inbound and outbound transactions
• Assist with Confidential / Retail customer setup. Verify customer pricing and program terms on all orders received.
• Monitor the production environment and proactively prioritize, communicate, and resolve any Confidential process issues
• Create SQL Server procedures, SSRS and optimize existing SQL code

Environment: Tried VAN: Klein Schmidt Trading Partner VAN: Easy Link

Confidential, UNIONDALE, NY

Senior .Net Developer (Team Lead)

Responsibilities:

• Responsible for developing for Inbound/Outbound Libraries for Confidential 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 (WebForms), Vb.net, SQLServer2008, JQuery, SSRS, WCF, Visio.

Confidential

Responsibilities:

• Responsible for Writing Software Requisition Specification for 248 and 568 (Contract Payments) Transactions for the State of OH,NY,MD as per file formats
• Inbound File Specification, Outbound File Specification, Mapping diagrams, Data specification were written
• Automation Deployments Plans, Validation of Accuracy, File Backup Procedures were written.
• Developed Database Diagrams, Business Functional Requirements,Screen Designs and Stored Procedures
• Inbound Libraries were developed for processing 248 and 568 Transactions for OH,NY,MD
• Billing, Payments,MeterReadings and Correspondence modules were populates as per business specification

Environment: VB.NET, ASP.NET 2008 (WebForms), SqlServer2008, LINQ, Visio.

Confidential

Responsibilities:

• Complete mapping and transformation documentation from Marketer to UtillBill Database
• Scheduling the data from Excel files to Sql Server 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,TSQL,CTE,Stored Procedures

Confidential, WATCHUNG, NJ

Software Developer

Responsibilities:

• Executive Dashboard for Customer Order, Planned Order, Purchase Order, Purchase Order Line, Late Orders and Shipment details with C# Web Forms.
• Ajax 2.0 Controls were used for developing Web Forms.
• Tree view, Data Grids, Multi view 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: VB.Net, ASP.NET, C#2005 (Web Forms), SQLServer2008, SSRS, JQuery, Toad for Sql Server 5.7, JavaScript, Ajax 2.0, XSLT

Confidential, AVENEL, NJ

Software Developer

Responsibilities:

• Integrating with Web services to periodic download bread crums for Trip Details.
• Bread Crums has vehicle name, latitude, longitude, event date time, 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, WCF, Web Services