Yogendra Khopkar
Our senior.Net Developer is expert in analysis, development, testing and implementation of full software development life cycle for Web based applications. He has extensive experience in Banking ( Credit Card processing), Media, Healthcare and Insurance.
SUMMARY
Worked with .Net technologies – ASP.Net, C#, VB.Net, ADO.Net, and AJAX using VS 2003 /VS 2005 /VS 2008
Experience in developing Web applications and Web Services using Microsoft Technologies
Extensive use of .Net controls like datagrid, gridview. Customizing datagrid control.
Developed XML applications, XSL, XSLT, XML Schema, XPATH
Expert in creating Web Forms, User Controls
Extensive experience in development and implementation of applications using C#, ASP.NET, VB.NET, VB 6 on SQL Server 2000 ,Oracle 9i with HTML, DHTML, CSS, XML, XSLT, ADO.NET, JavaScript, Web Controls, XML Web Service
Having good experience in Writing the SQL Server Stored Procedures, Data Exporting and importing using DTS, Designing the SQL packages for Data transfer
Managing the configuration and controlling the versions of the application under development using Microsoft Visual Source Safe (VSS) SubVersion
Strong database background in SQL Server, Oracle and MS Access
Excellent technical problem solving and code debugging skills
Involved in entire software development life cycle.
TECHNICAL SKILLS
Operating Systems: Dos, Windows 9x/2K/XP/2003
Languages: C#, ASP.NET, VB .NET, ADO.NET, VB6, C++, Java, SQL, T-SQL,
Databases: SQL server 2000, Oracle 9i, MS Access 2000
GUI/Tools: Visual Studio .Net 2008, Visual Studio .Net 2005, Visual Studio .NET 2003, Visual Basic 6.0, SQL Query Analyzer, Enterprise Manager 2000, SQL Server Management Studio, DTS export/import, FTP.
Web Technologies: AJAX, WSS, XML, HTML, CSS, Java Script, VBScript
Middleware: Web Services
Configuration Tools: Visual Source Safe, SubVersion, Tortoise, VisualSVN.
Packages: Microsoft office 2000/2003/2007(Excel, Word, PowerPoint)
PROFESSIONAL EXPEREINCE
Advanced Health Media, VA
Dec 2007 till date as Senior Developer
Project : Web Meeting Scheduler
Environment: .Net2.0, .Net 1.1, C#, Visual studio 2008, Visual studio 2005, Visual studio 2003, SQL
Server 2000, Windows XP
Description: The project presents a web front-end for the representatives of various Pharmaceutical companies for scheduling meetings, programs and lectures. The representative can also use the portal to add new speakers, members to the system.
Assisted in converting the site from .Net 1.1 to .Net 3.5.
Use of Asynchronous method calls for background processing.
Used AJAX framework to improve the user perception of the page.
Designed user interfaces, web pages, web forms using ASP.NET and C#.
Simultaneous use of VS.Net 2.0 and VS.Net 1.1
Extensive use of XML, XSLT and XPath expressions.
Created complex stored procedures using SQL Server 2000.
Interacting with business managers for requirement gathering.
Implemented core modules like Nominations (something like WWF), Contract Management.
Creation and maintenance of DTS packages using SQL Server 2000.
JP Morgan Chase, VA
Feb 2007 – Nov 2007 as Senior Developer
Project : PLTS Card Services
Environment: .Net, C#, Visual studio 2003, SQL Server 2000, VB 6.0, C\UNIX, Informix 10, TSYS,
Windows 2000
Description: The PLTS card services division of JPMC handles the Chase-Circuit City private label credit cards. The project involves the lifecycle of credit card from applying for a new one, customer helpdesk, balance transfer, fee removal, collections, and bankruptcy.
Responsibilities:
Was involved in implementing Business Logic for agent rewards for Credit Card applications, processing and tracking the applications, making changes to the existing logic based on client’s requirement.
Implemented Cryptography and also developed Com Callable Wrapper (CCW) in C# to make use of the same from VB 6.0 applications.
Training the users on the understanding of implemented business logic.
Involved in Change processes, Disaster Recovery, unit testing, SIT.
Getting involved in the training sessions and discussions on applications like RPOS,
Co-ordination with offshore team for knowledge sharing, support activities, connectivity issues.
BlueShield
Aug 2006 - Feb 2007 as Senior developer
Project : HIPAA Role Based Files & Report Project
Environment: C#, ASP.Net, ADO.Net, Oracle 9i, IIS, JavaScript, CSS, Visual studio 2003, Visual source
Safe, Windows XP
Description: The HIPAA (Health Insurance Portability & Accountability Act of 1996) Role Based Files and Reports project is a security project initiated by Blue Shield California (BSC) to address Deloitte and Touche audit findings and to bring BSC into compliance with HIPAA Privacy and Security Standards.
Responsibilities:
Involved in framework development like creation of HTTP Module for authentication and authorization
Guiding a team of 3 freshers. Helping them with code optimization, algorithm, Debugging, tracking their progress. Explaining the business functionality in simpler terms
Designed user interfaces, web pages, web forms using ASP.NET and C#
Used build-in validation controls and custom validation control for front end validations
Worked with User Controls and other inbuilt controls
Used XML and JavaScript
Provided option to customize client side error messages
Used data views for filtering the data
Exceptions are handled while taking inputs from the users
Implemented role based security for the user groups
Implemented Data access layer for data access using C#
Extensively used ADO.Net technology to communicate with the database
Jet Airways (India offshore project)
June 2005 – June 2006 as Senior Developer
Project : Web Portal Development.
Environment: C#, ASP.Net, ADO.Net, Oracle 9i, SQL Server 2000, IIS, JavaScript, CSS, Content
Management Server (CMS) Visual studio 2003, Visual source safe, Windows XP.
Description: This project will implement one portal for Jet Airways for its customer and Admin needs. It will include the content that is present on the current site, as well as integrate several third party applications such as Online Booking, a Frequent Flier Program Application, a chat application, and a newsletter for a more comprehensive user experience. Users will be able to access various parts of the site with a Single Sign On (SSO).
Responsibilities:
Extensive interaction with client for requirement gathering
Designed user interfaces, web pages, web forms using ASP.NET and C#
Involved in developing modules like GroundStaff Personnel, eMagazine, Jet Wallet, Jet Elite
Extensive uses of JavaScript for giving windows application like feel in web pages
Worked with User Controls and other inbuilt controls
Used XML, XSLT and XPATH
Consumed web service from web client
Implemented Application logging using “log4net” framework
Involved in designing database relative to my modules.
Created stored procedures, Views, Cursors and Indexes using SQL Server 2000
Created linked server between Oracle and SQL Server for data communication
Creation of DTS packages using SQL Server 2000.
Cap Gemini
Dec 2004 – May 2005 as Developer
Project : Portfolio Management
Environment: C#, ASP.Net, ADO.Net, SQL Server 2000, IIS, JavaScript, CSS, Visual studio 2003, SQL
Notification Services, OLAP, Visual source safe, Windows XP
Description:
Project in Banking Domain. Front-end was developed on ASP.Net using C#. Portal enables IDBI customers to view the investment as a report. The reports are classified on the basis of the category to which the customer belongs. The project involved gathering live data from share market. It enables subscribed customers to be notified about market changes.
Responsibilities:
Extensive interaction with client for requirement gathering
Designed user interfaces, web pages, web forms using ASP.NET and C#
Worked with User Controls and other inbuilt controls
Used data views for filtering the data.
Exceptions are handled while taking inputs from the users
Involved in managing project using Microsoft Visual SourceSafe 6.0
Implemented role based security for the user groups
Used XML, XSLT and XPATH.
Created stored procedures, Cursors and Indexes using SQL Server 2000
Creation of DTS packages using SQL Server 2000.
Cap Gemini - Meditronic
Oct 2004 - Dec 2004 as Developer
Project : Billing Agency Integration
Environment: C#, ASP.Net, ADO.Net, SQL Server 2000, IIS, JavaScript, CSS, Visual studio 2003,
Visual source safe, Windows XP
Description:
The project involved integration, reporting and transactions between two existing systems one of which was in JDE and the other in Tally. Data from both the systems was consolidated and pulled into SQL Server. Reports were generated using Office as Smart Client (OSC).
Responsibilities:
Involved in the design and development of user controls and web pages in ASP.Net using C#
Involved in database design and developing complex stored procedures in SQL server 2000 for the reports.
Creation of DTS packages for data transfer between JDE and SQL Server 2000.
Cap Gemini
Apr 2004 - Sep 2004 as Developer
Project : AMEngage Web Portal
Environment: C#, ASP.Net, ADO.Net, SQL Server 2000, IIS, JavaScript, CSS, Visual studio 2003, Windows sharepoint services, Visual source safe, Windows 2003
Description: The project provides an alternative electronic means to Capgemini UK to support customer interactions with delivery teams. It is not intended to replace Help Desk or face-to-face delivery interaction of Account or Delivery teams, however it is envisaged that its use could reduce the demand for certain face-to-face customer interactions. The project uses the document sharing feature of WSS for sharing documents between multiple people.
Responsibilities:
Designed user interface screens and implemented application
Extensive use of datagrid control. Customized datagrid to suit the client requirements.
Developed DB Utility libraries using C# and ADO.Net which is used by Business layer for all data manipulation
Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table, stream reader for consistent access to SQL data sources
Developed generic user controls using C# which is used in all modules of the system.
Implemented logging mechanism
Prepare the test cases and reviewed the results
Perform Unit test, integration test and System test
Pepsi Foods, India
Aug 2002 - Mar 2004 as Developer
Project : Reporting Tools
Environment: C#, ASP.Net, ADO.Net, SQL Server 2000, VBA (Excel Macros), IIS, JavaScript, CSS,
Visual studio 2003, Visual source safe, Windows XP
Description: The project offered the management to view reports in OSC (Office as a Smart Client). The OSC enable users to view reports in excel sheets in browser. The data for reports was migrated from existing SAP database to SQL Server 2000. The reporting data stored in SAP database is pulled into SQL Server using linked servers and reports are generated on it. The reports are displayed in Excel format using OSC. OSC software enables the administrators to create and customize reports.
Responsibilities:
Developed macros in VBA for formatting reports in Excel Sheets.
Implementing complex business logic.
Debugging the code using Visual studio 2003 IDE.
Involved in testing of reports for formats and formulas.
Creation of DTS packages for data transfer between SAP DB and SQL Server 2000.
Created Test cases.
Prior experience includes 10 months as a developer on VB.
EDUCATION
Bachelor of Engineering (B.E) in Computer Science
TRAINING
VS.Net 2003 in Capgemini
DotNet 2005(C#, ASP.Net 2.0)