Experience Summary

• 9 years of experience in System Study, Requirement Gathering, Analysis, Design, Development and Support of Web and Windows based software applications across the Industry verticals including Investment Banking, Insurance and Retail using technologies C , VB.NET, ASP.NET, WCF, MSMQ, WF, SharePoint server, ADO.NET, Entity Framework, MVC, Web Form, LINQ, JavaScript, HTML 5, JQuery, Ajax, HTML, XML, CSS, Windows Forms, Multithreading, Web Services in Framework 1.1, 2.0, 3.5, 4.0 and 4.5.
• Experience in Insurance, Hedge Fund, Private Equity, ETF and Real Estate funds domain.
• Competent in RDBMS Programming using SQL Server 2000-2008, Oracle and DB2 with strong T-SQL, Stored procedures, Functions, Views, SQL Jobs, Linked server, SQL Mail, Cursor, Views, Triggers, performance tuning and Practical Knowledge of NoSQL.
• Experience in implementing several DESIGN PATTERNS like Singleton, Factory, Facade using C and VB.NET.
• Very good experience in creating and consuming Web Services / WCF Services using SOAP, TCP and HTTP protocols.
• Experience in complete SDLC process including Agile XP and Scrum Methodology and experience in preparing.
• Experience in TDD Test Driven Development development approach.
• Having direct interaction with business user on requirement gathering and discussions, estimations and experienced in technical story card creation and prioritization of the task.
• Technical Specification TS . Functional Specification FS and Unit Test plan UTP for the applications.
• Development experience in Reporting Tools like SQL Server Reporting Services SSRS and Crystal Reports 11.0.
• Extensive experience in Integration Tools like SQL Server Integration Services SSIS 2005/2008, Biz Talk Server 2006 and Informatica 8.6.
• Sound practical knowledge of Java, JSP and servlet.
• Experience in using the SCM tools such as Microsoft Team Foundation Server TFS , Microsoft Visual SourceSafe, and SVN.

Technical Experience Summary Table

Confidential

Summary:

• As a member of the TALON Team I have worked on below projects.
• TALONes CONNECT Global Integration Services This project enable TALONes integrations with CONNECT Global is Harley-Davidson's dealer customer relationship management CRM application, based on the Microsoft Dynamics CRM 2011 platform.
• TALONes Standard Interface TALONes Standard Interfaces Windows Service provides the pertinent data from the installed TALONes dealer databases to the Standard Interfaces Web Service.
• TALONes DMS TALONes is a total dealership management solution built using the latest technology including Microsoft .NET and SQL Server.
• I am involved in developing coding standards, design and development methodologies, performing design reviews, assisting with work plan development and work estimates.
• I am responsible for the performance of technical architecture /design, object modeling, data modeling, and development of architecture framework and functional components of DMS and Supporting system.
• Contributions:As a senior Software Developer, I am responsible for design and development of functional enhancement and fixes to a Dealer Management System DMS .
• Interacted with the Business Analyst and Quality Analyst to resolve the requirement gaps.
• Write and maintain technical documentation
• Write automated unit test.
• Skills: Microsoft C 4.5/4.0/3.5, Microsoft Visual Studio 2008/2010/2012, SQL Server 2008, Crystal Reports, Entity Framework, MVC, Windows Forms, Threading, Telerik Controls, Web Forms, HTML5, WCF / Web Services, MSMQ, SQL Service Broker, TFS, Windows Services, Windows Power Shell, JQuery, Azax, ReSharper, Devart Code Review, ANTS Profiler, NUnit, SQL procedure, triggers, functions, and views.

Role: Senior Software Developer

Confidential

• Contributions: Gather, define and prioritize business requirements and functional specifications.
• Document Business requirement / Functional Specifications with Business unit.
• Did estimation and created technical story card.
• Used Agile XP software development methodology.
• Consumed Web Service and WCF services.
• Created Service classes, Utility classes, Adapter Classes and Mapper classes to Map Service response to Cobol copybook.
• Created project in TFS. Created NUnit test cases and SoapUi project to test and validate the service.
• Design, coding, creating test plan, UAT support, production support and post-implementation support.
• Used Agile XP development methodologies.
• Used TDD development approach.
• Skills: Visual Studio TFS, Agile, TDD, Visual Studio 2010, C 4.0, Web Services, log4net, SoapUI, NUnit, Code Coverage Analysis, COM , XML, LINQ, Oracle and WCF.

Role: Senior / Lead Developer

Confidential

Summary:

Confidential is a single user application to support all Basket Creation processes, Management Reports, and dissemination requirements related to servicing all current and future Exchange Traded Funds. It provides an enhanced level of straight through processing for trade execution to the existing and potential sponsors/clients, streamline operations, and enable fund administration through improved reporting and controls for the bank's offerings in Exchange Traded Funds ETFs .

Contributions:

• Gather, define and prioritize business requirements and functional specifications.
• Document Business requirement / Functional Specifications with Business unit.
• Create Design/Technical Specifications Documents.
• Design, coding, creating test plan, UAT support, production support and post-implementation support.
• Mentoring new resources.
• Created SSRS reports and SSIS packages.
• Created ASP.net web pages also used java script and JQuery.
• Worked on SQL procedure, function, views, triggers and performance tuning.
• Used ADO.NET controls like GridVew and CSLA.NET framework.
• Created and consumed WCF services.
• Skills: C 4.0, ASP.NET, SQL Server 2008, WCF, Web Services, CSLA.NET Framework, LINQ, AJAX, JQuery, SSRS and SSIS.

Role: Senior Developer Module Lead

Confidential

Contributions:

• Responsible for all phases of system development lifecycle, from taking requirement from the business, analysis, design, development, testing and production implementation. Development and testing of unit test cases and support the System Testing Regression Testing.
• Skills: C 3.5, ASP.NET, Oracle 10g, JQuery, JavaScript.

Role: Tech Lead L3

5. Confidential

Summary:

Hedge Fund Analysis a web based application that does an analysis on the Hedge Fund and indicate its performance, market value, Peers comparison, underwater. The application allows you to define Fund Manager, Fund associated with manager, Legal Entities associated with Fund and Hedge Fund associated with different legal entity. It also allows you enter Rate of return ROR , Liquidity, Side Pocket, Net Asset value NAV defined for a particular fund.

Contributions:

• Coordination with client for Requirement Gathering, creating functional and technical documents.
• Involved in Requirement gathering, design, coding and testing of application.
• Developed and consumed WCF web service to retrieve the Fund Details like Market Value, NAV, and Commitment.
• Worked on SQL procedure, function, views, triggers and performance tuning.
• Interacted with Business users for UAT of the system and resolving Post Productions issues.
• Worked on Master Pages, Ajax, Web Parts, Linked List programming, XML and LINQ.
• Skills: ASP.NET 3.5, WCF, C , SQL Server 2008, XML, Linq, JQuery, Ajax, SVN and TFS.

Role: Project Engineer

Confidential

Contributions:

• Followed Agile Scrum methodology within the team for development of Business Reports, Datafeeds and Change request.
• Direct Interaction with Business Users for understanding Business process and rules, Requirement Gathering, Finalization of functional specs, System Study and Analysis, UAT, Troubleshooting and resolving system issues.
• Participate in weekly meetings with business users and technology team for status updates on deliverables and setting priorities for new deliverable and participate in agile meetings with technical team.
• Key Member in Data migration and consolidation of old systems data into Equitrak using the ETL tool Informatica 8.6.
• Wrote Windows Service in VB.NET 2.0 to dynamically print the unapproved transactions in word templates.
• Developed and enhanced complex UDFS, Stored procedures, SQL scripts and views for business reports and Data feeds.
• Designed and developed workflows and mappings in SSIS to interface and transform data to other
• Business units and systems like Data warehouse within the CITIGROUP.
• Designed and Developed Complex Business reports using Crystal Report 11.0.
• Wrote SQL scripts for data cleansing request from business reports.
• Working with Vendor for managing the new releases of the Equitrak and troubleshooting application issues.
• Managing daily operations of the project like trouble shooting the application issues raised by business
• Users by coordinating with concerned teams like DBAs, System Admins, Operations team and Vendors etc.
• Managing Defects/Change Requests.

Skills: VB.NET 2.0 / 3.5, Windows Form, Windows Services, ASP.NET, SQL Server Integration Services 2008 SSIS , Informatica 8.6, Crystal Reports 11.0, SQL Server 2005/2008, Jira, Autosys, Microsoft Visual Source Safe and SVN.

Role: Senior Developer

Confidential

Summary:

• Modelware is a proprietary system for meaningful comparative financial analysis.
• This project is used to compare the performance of the private and public companies and helps in investment planning.
• Modelware Web consists of a suite of flexible easy application that let you analyze modelware data and generate insights quickly, according to your own preferences.

Role: Project Engineer

Skills and O.S.: Visual Studio.NET, ASP.NET 2.0, C , Web Services, Securities domain, Windows 2003 Server

Contributions:

• Involved in the enhancement of the project.
• Perform coding and Unit testing

Confidential

Summary:

• This project is a replacement of existing Fiarano integration system with BizTalk Server 2006. This project integrates existing delta system with SAP.
• This project contains various modules like Associate Upload, SAP Vendor Creation, PGI Sales Creation and Purchase order creation.
• Associate Upload Module: Deals with extracting the CSV file from the mail attachments, read the file and insert the file data in to SQL Server database.
• SAP Vendor Creation Module: Receive vendor ID from a HTTP URL, Get the Vendor details from SQL Server and then we create SAP IDOC by passing the vendor details
• Update Vendor IDOC creation status back to the SQL Server.
• PGI Sales Creation Module: Receive inventory ID from a HTTP URL.
• Get the details from SQL Server and call various SAP BAPI's.
• Update the status back to SQL Server.
• Purchase Order Creation Module: Get the order details from DB2 database.
• Fetch the other order details from SAP.
• Create an HTML report and put the reports to AS/400 file system.
• Update the details in DB2.

Role: Programmer

Skills: DB2, SQL Server 2005, BizTalk Server 2006, .NET, SAP, Retail domain ,Windows 2003 Server

Contributions:

• BizTalk installation.
• Created Schemas, Mappings, Pipelines and Orchestrations.
• Worked on various BizTalk Adapters File, FTP, POP3 Mail, SQL, SAP, HTTP and DB2 Adapter.
• Coordinate with the client to get the requirements and understand the existing system.

Confidential

Summary:

• This project deals with the calculation of insurance premium incentive for agents, sales officers and team leaders.
• Insurance premium data comes in excel sheets from various systems and in various formats.
• We validate, filter and upload the excel sheet data in SQL Server using Windows Application and Web Services.
• Process the uploaded data in first week of every month using SQL procedures and functions.
• Created various reports using ASP.NET and SSRS.
• Used Windows Authentication.

Role: Module Leader

Skills and O.S.: C , ASP.NET 2.0, Windows Application, Web Services, WCF, SQL Server 2005, SSRS, SSIS, Insurance domain and Windows 2003 Server

Contributions:

• Interact with client to get project requirements.
• Create and consume the Web Services.
• Created the database tables, written SQL procedure, SQL job and functions.
• Coding of ASP.NET pages, Created SQL Server reports, Unit Testing and deployment of the reports.
• Integrate Web Services with Windows Application.
• Worked on setup and deployment of the project.
• Worked as a Team Leader in the project.

Confidential

Summary:

• This project is a ETL and Reporting project
• Insurance transaction data comes in flat files from two locations.
• We have to get the file, insert in to SQL Server database, encrypt the data and put the encrypted data back to flat file.
• Send the encrypted file to the agent location insert the decrypted data in SQL Server.
• Dynamic report creation and report subscription.

Role: Programmer

Skills and O.S.: SQL Server 2005 Integration Services SSIS ,SQL Server 2005,MS SQL Server 2005 Reporting Services,.NET Framework, Insurance domain, Windows 2003 Server

Contributions:

• Lead the team of two people.
• Created tools exe for dynamic report creation using SSRS web services and to schedule sFTP.
• Help the team in Report creation and SSIS package creation.
• Worked partially on the project.

Confidential

Summary:

• This application manages the creation of deal for insurance agent a MO creates the deal for the agent.
• After creation of deal, deal creation goes to their respective BOPS and COPS officers for approval.
• Bops and Cops may approve or reject the request and the request may be reopen or close.

Role: Programmer

Skills and O.S: SQL Server 2005, ASP.NET 2.0 ,C ,.NET, Web Services, Insurance domain, Windows 2003 Server

Contributions:

• Created project specification documents, design documents and unit test case documents.
• Worked on Requirement gathering, analysis, design, coding and unit testing and deployment of the project.
• Worked on implementation of windows authentication.
• Worked on active directory programing to fetch data from Active Directory using dot net.
• Worked on excel programming to get the data from excel and to write the data in to excel.
• Created database tables, SQL stored procedures, functions and views.
• Created deployment project to deploy the project on client.
• Deploy the project on Client UAT and Production server.
• Interacted with the client for UAT testing and sign off of the project.

Confidential

Summary:

This project contains two modulesResource Management Application RMA and HR Job Post.

RMA:

• In RMA project an employee or his reporting manager can raise the request for any resource like desktop, software etc.
• The request goes to three level of approval Approver canapprove or reject the request.
• If the approver doesn't approve the request with in particular time SLA . Then request will escalate to the particular escalation level approver.
• There are multiple data entry pages for resource entry and employee record entry.

HR Job Post:

• This module contains internal referral job posting and uploading of the resume for particular job vacancy.
• Any employee can apply and upload the resume of his friends.
• Employee can also upload the resume if the vacancy is not available.
• HR can create and close the job vacancy.

Role: Programmer

Skills and O.S.: SQL Server 2005, ASP.NET 2.0, C , Share Point Server 2003, WWF, Windows 2003 Server, Windows Services.

Contributions:

• Created project specification documents, design documents and unit test case documents.
• Worked on Requirement gathering, analysis, design, coding and unit testing and deployment of the project.
• Worked on implementationof windowsauthentication.
• Worked on active directory programing to fetch data from Active Directory using dot net.
• Worked on excel programming to get the data from excel and to write the data in to excel.
• Worked to write files into database and windows directory and downloading of the files.
• Worked on SQL server 2005 Active Directory programming to fetch the data from Linked server.
• Worked on SQL Server programming to send HTML formatted email from SQL server.
• Created database tables, SQL stored procedures, functions and views.
• Created deployment project to deploy the project on client.
• Deploy the project on Client UAT and Production server.
• Interacted with the client for UAT testing and sign off of the project.
• Created Windows Service project to update the employee information in to database from given CSV file.

Confidential

Summary:

This project contains all the activity related to Income tax like application of PAN and TAN, Income Tax Calculation of an employee, company or a group of company.

Role: Programmer

Skills and O.S.: SQL Server 2005, ASP.NET 2.0, C , .NET Framework, Banking Finance and Windows 2003 Server

Contributions:

• Worked on Requirement gathering, analysis, design, coding and unit testing of the client and deduction modules of the project.
• Created database tables, SQL stored procedures, functions and views.

Confidential

Summary:

• This project manage promotion activity of HLL LUX body Wash products.
• This project gives product Sales by area, district, state or region.
• It display product sales report by promoter wise, supervisor wise, product wise and area wise.
• This application reduces time consumption in promotion and removes the inaccuracy in the sales data.

Role: Programmer

Skills and O.S. SQL Server 2000,ASP.NET 1.1,VB.NET ,.NET Framework 1.1, Windows 2003 Server

Contributions:

• Involve in Interaction with the client to get the requirements and understand the functionalities.
• Created project specification document, design document and unit test case document.
• Worked on Requirement gathering, analysis, design, coding and unit testing of the project.
• Created database tables, SQL stored procedures, functions and views.

Confidential

Summary:

• This project contains various modules like Client Events Brief Sheet, Client, Voucher and Attendance Module.
• Client Brief Sheet module contains the entry of brief of events.

Role: Programmer

Skills and O.S.: SQL Server 2000, ASP.NET 1.1, VB.NET, .NET Framework, Windows 2003 Server.

Contribution:

• Worked on analysis, design, coding and unit testing of the Brief Sheet, Client, Voucher and authentication modules.
• Created database tables, SQL stored procedures, functions and views.

Confidential

Summary:

• Mobylog.com is a photo blogging site where we can upload unlimited image and video for any events, promotion or while you are in travel.
• We can also upload images directly by mobile phone using your email.

Role: Programmer

Skills and O.S.: SQL Server 2000, ASP.NET 1.1, VB.Net, .NET Framework, Windows 2003 Server

Contribution:

• Worked on maintenance of the project.
• Created SQL Procedures and functions.
• Worked on designing, coding and unit testing of the asp.net pages.