SUMMARY:

• Above 15 years of experience in n tier client - server architecture, windows based, handheld, web based business application in Global Brokerage Operations, Banking Mergers and Acquisitions, Global Tax Group, Energy Billing.
• Experience in Brokerage Operation Leadership, Banking Mergers and Acquisitions, EDI Business Operations, Leasing Business, Global Tax Warehouse, Budgeting System
• 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), Grocery Haulers, Advent Car Dealership ERP Application.
• Worked with IBM Mainframe 3270, IBM Mainframe 5250 Terminal Reflection, and ADP Reflection.
• Directly involved in design, development and maintenance of web based business application and 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 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,JSON Library,JSON Mock New

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

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

Methodologies: Object Oriented Programming, MVC (2.0/1.0), MVVM (3.0), UML, 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

ETL(EDI): AltovaMap Force 8.0, Altova Map Force Server, EDI- HQ, TCPX Server, EDIDev Framework.

PROFESSIONAL EXPERIENCE:

Confidential,South Amboy,NJ

Consultant

• Developed Executive Summary,Reporting,Marketing Analysis and Marketing Dashboard with Kendo UI Controls
• Build Total/New/Used Car Sales, Labor Gross, Fixed Operations, Advertising Budget,Traffic ByType were build with Kendo UI Chart Controls having Stack Chart,Line Chart,Area Chart.
• Power BI was used to develop Marketing Analysis Sales By Zip for Customers,Units Sold,Market Share Make, Model, Segment Conquest, Dealer Conquest, Lease VS Finance
• Power BI Experience in ETL, Data Modeling, Data Visualization, Reporting and Analytics.
• Dax queries (Measurements and Calculated Columns) were used to develop Power BI.
• Comparative Reports, Zip Sales, Make Segment Conquest, Conquest Sales with Kendo UI Grid Controls.
• SQLServer 2012 Database Objects such as tables, views, stored procedures and triggers.
• Developed MAPS for Advent Dealer Management ERP Systems for DataFeeds

Environment: VS.NET 2015(.net 4.5), ASP.NET, VB.NET 2015,Kendo UI Control, Angular JS,SQL Server 2012.

Confidential,New York, NY

Brokerage Operation Leadership

• Managed Project of medium to high complexity as per BRD specification.
• Responsible for assembling project plans and teamwork assignments, directing and monitoring work efforts on a daily basis, identifying resource needs, performing quality review; and escalating functional, quality, timeline issues.
• Test driven development for Visual Studio Test Tools NUnit Façade Layer, BI, DAO Layer, Json library,Json Mock, Validation Helper file was developed for Mergers and Acquisitions.
• Wrote Complicated Stored Procedure, Views for Event display for Share Holder Vote, Target Vote.
• Developed Memos in ASP.NET for Conflicts Clearance Memo,Deal Memo, Compliance Review Memo was done
• Client Request (CRQ) were implemented in ASP.NET/C# were implemented. Jenkins for continuous deployment.
• IronWall (Encryption/Decryption) Layer was implemented by Angular JS /MVC pattern.

Environment: VS.NET 2015(.net 4.5), ASP.NET,C#.NET 2015,SQL Server 2012,SSRS Reports COPS Database, AutoSys, HP Application, NUnit Testing 2.8, Jenkins for deployment, Agile Scrum, Microsoft Azure

Confidential,NJ

Brokerage Operation Leadership

• 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),ODS,ICS Database.
• Responsible for developing FINRA Dashboard (WinForms) Count for Asset,Wire,Client Contact, Client Info Change.
• Components build DTO Object, Workflow Components for Line of Business: Asia Pacific, Retail, Scottrade (Email formatters, File formatters).
• Build Vb.Net Class Library Data Access Layer from ODS, BPS complicated query were written in database.
• Build Vb.Net Class Library for ICS Files Header and ICS Files Rows,Email Notifications,BounceBack Emails Files
• Client Info Changes has Name Changes, SSNO, DOB Changes, Collection were build.
• 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.XML has Config Path.

Environment: VS.NET 2015, VB.NET 2015,SQL Server 2012, NLog, BPS, ODS Database, Logger Block,Audit Trail, Microsoft Azure Server

Confidential,IBM

• Data Access Layer to BPS,ODS database for Advisor Boarding Macro.
• Database Objects Stored Procedures, CTE, UDF, Database Triggers, Mapping diagrams were developed.
• VB.NET Class Library were written to build collection for Accounts and branch locater were processed
• BI Files BPS NAD1,BPS CPM1,BPS RELA,BPS TELE(BI)(ETL) Input files were processed.
• Audit Trail, Email Notification, IBM Files, Log files were generated.
• Data Requirements, BPS 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, IBM 5250 Reflection, SQL Server 2012, BPS, ODS Database, Agile Scrum

Confidential,NJ

Senior .Net Software Consultant

• Marketing Dashboard developed for Marketing and Operations Team with Telerik/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.
• 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.
• Telerik Controls UI Controls were used to develop Web UI.
• 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, CTE and views were created as per specification
• SSRS reports were generated as per specification
• Data Feeds from AIX Reflection Mainframe System.

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

Confidential,NJ

Senior .Net Developer

• 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
• Transaction based TNC (T+1,T+0) 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 Sql Server Database (ETL)
• 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

• Developed Confidential files for Broadridge.
• C# Class Library developed for Pending Trade File, R-DMaster, Stock Record, Memo Seg Data File,ACAT 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: VB.NET, VS.NET 2015, ASP.NET 2015, C# .NET2015, SQLServer2012, TFS 2012, Jquery, Telerik Controls, Kendo Controls, HTML5, CSS3, XML, XSLT, JavaScript, Salesforce, Ajax, Entity Framework.

Confidential,NJ

Lead .Net Programmer

• 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. Microsoft DataAccessLayer 5.0, Visio,XML, Office 2007, SSRS.

Confidential,NJ

Lead .Net Developer

• 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),XML

Confidential,NY

Senior.Net Program (Team Lead)

• EPICOR Prophet21 is a Microsoft Windows based /SqlServer Database software for the ERP wholesale distribution
• 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, making corrections to orders.
• 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 & deliverables.
• Wrote Stored Procedures, Tables, View, CTE in SQL Server 2005 as per Business Specs
• Pricing Reports with (EDI 832) Changes were build as per specification.
• SSRS was used as Reporting Tool, SSIS Packages were written as per Business Process

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

Confidential,NY

Senior .Net Developer (Team Lead)

• 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 (WebForms), Vb.net, SQLServer2008, Jquery, SSRS, WCF, Visio.

Confidential

• Responsible for Writing Software Requisition Specification for 248 and 568 (Contract Payments) Transactions for the State of OH,NY,MD as per file formats
• BRD 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, Meter Readings and Correspondence business process workflow were designed.

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

Confidential

• 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, TSQL, CTE, Stored Procedures

Confidential,NJ

Software Developer

• 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, 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: VB.Net, ASP.NET, C#2005 (Web Forms), SQLServer2008, SSRS, Jquery, Toad for SqlServer 5.7, JavaScript, Ajax 2.0, XSLT,XML

Confidential,NJ

Software Developer

• 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, WCF, Web Services