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 werecompleted on time, on budget and desired results.
• Worked with ERP Applications at David Michael Flavors and Tri Ed Distributions (EPICOR), GroceryHaulers, 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, SqlServer 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 ToolsETL(EDI): AltovaMap Force 8.0, Altova Map Force Server, EDI- HQ, TCPX Server, EDIDev Framework.

Mapping Tools: IBM Mainframe 3270 Terminal, IBM Mainframe 5250 Terminal, ADP Reflection

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Power BI was used to develop Marketing Analysis Sales By Zip for Customers,Units Sold,Market Share
• 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
• ManagedProject 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.
• TFS was used and Source Control and Connection String was encrypted
• Used Microsoft SQL Server 2012, created stored procedures, triggers, udf, indexes for optimization of data fetching.
• 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, BPScomplicated 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.
• 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: IBM 3270 Reflection, IBM 5250 Reflection, SQL Server 2012, BPS, ODS Database, Agile Scrum

Confidential

Senior .Net Software Consultant

Responsibilities:

• 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

Senior .Net Developer

Responsibilities:

• 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.
• Developed Smart Inventory Management 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

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 SqlServer.
• 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

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

Confidential

Senior.Net Program (Team Lead)

Responsibilities:

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

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

Confidential

Senior .Net 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
• 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

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

Software Developer

Responsibilities:

• Periodic downloading of the csv file from Metro Fuels and Champlain Fuels.
• Importing the data, cleansing, validation to SqlServer Database (ETL).
• 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
• StoresTime Window 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

Sr. .Net 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.
• 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

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.
• Mainframe Systems Integration was done having - Environment: VB.NET, Oracle 9.0i and Crystal Report as reporting tool.
• Web Recruit and Web FAQ
• This Application was used by Compliance team to create State Fund raisers, Campaign, Call Centers, Recruiting of Operators Module, Campaign Faq., and Assignment of EIS List Modules.
• Role level security was maintained. Visual Source Safe was used for version control.

Environment: VB.NET, Oracle 9.0, Classic ASP, and Crystal Report 9.0

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