Resume

Sign in

Sql Server Service

Location:
Redmond, Washington, United States
Posted:
February 06, 2018

Contact this candidate

Resume of Shankar Ramaswamy

Phone /Address

***** ******* **-***** ***.

ac4c77@r.postjobfree.com

Summary

** ***** ** ********** ** full life-cycle application development/testing including requirements analysis, software design and testing in Web and Windows based technology using .NET,C#, Azure functions,Web Api, REST,JavaScript, REACT JS, jQuery, MVC,ASP.Net, CSS(SCSS), SASS, LESS, MS-SQL server, Oracle.

Good experience in Web UI & object oriented development

Experienced in test automation/TDD,Database design development and performance tuning

Experienced in Interacting with Clients and understanding their requirements & scoping it. Capacity to learn quickly and deliver under pressure

Skills:

Languages C#,Java Script, MS-SQL, TypeScript,C++

Technologies REACT JS, Redux, Promise middleware, ASP.NET,REST API bootstrap,CSS,SASS,SCSS,LESS,,WebSvc,WCF, Handlebar

RDBMS Azure Document DB(NoSQL),SQL Server, Oracle, Informix

Programming Methodologies Agile-Scrum,TDD, Waterfall model

Case/Test Tools SSIS, SSRS, Nunit,Nant scripts

Tools VS 2017, Resharper, NUnit UI, Rhino mocks,Moles,FxCop,Nant, COM, MTS, GIT, Accurev, TFS, CVS Source Control, SABRE

Installation/Deployer tools VSTS Build/Release, MSI,CI,Octopus, ClickOnce,VS installer, InstallShield, Sql Deployer, TeamCity

Operating Systems MS-Windows/DOS, Unix, Linux

Domain Airline, Telecommunication, Banking/Finance and Retail

Education:

Bachelor of Technology in Electronics, M.I.T, Anna University

MCP in XML Web Services and Server Components with C#.NET

Microsoft Certified Professional in MS-SQL server2000 Enterprise Edition

Project Details

Microsoft Corp,Redmond, WA(Employer: AIC)

Jul 2016 to Jan 2018

SDE

GreenId (MCKP-Microsoft Customer Knowledge Platform Engineering)

C# Web API, REACT, JS, REST,MS-SQL 2014, Visual Studio 2017, Rascal Mini,.Net 4.5, GIT,TFS, Cosmos, Scope,AutoPilot & firefly deployment tools, CodeFlow(CodeReview tool), XTS(Log/machine viewer),Xpert, WebStore DB,SourceDepot, OWIN, Azure Service Fabrics,Asp.net core

Finger printing device info for payment authenticity

Created Azure function to store the SessionInfo into the document DB for sessionId/

DataCenter mapping, so that partners like Risk/Skype can get the deviceForensics data

fast

Web api service in C# and Javascript to develop new features for GreenID project.

.Improved performance with asynchronous coding(Task,Parallel) for Api against different partition of webstore DB.Developed async REST proxy for multiple DC spanning,Wrote Sql proc for retention job of activity table

Using REACT JS & Redux state container created a web site for querying DeviceProfile

data for the given sessionId, used bootstrap for styling

Migrated the Sql server to Azure Document DB(NoSql) for better performance,

Migrating the legacy DeviceForensics app/api to Azure

Used dependency injection for writing to different log targets like Cosmos, flat file

Working on OWIN microservices POC to split the monolithic huge application into

Multiple small micro services for easy deployment and for exposure. Also planning to

use Azure Service Fabrics to build micro services with asp.net core.

Alaska Airlines,Seatac, WA(Employer: AIC)

Oct 5 2015 to May 27 2016 (Email: ac4c77@r.postjobfree.com)

SDE (Desig:-Senior Programmer Analyst)

AlaskaAir.com

REACT JS(JSX),Node JS,Redux,AngularJS2, MVC,MVP,MVVM(WPF), REST WebAPI,Asp.net,C#,J-Query,JavaScript,, MS-SQL 2010,Informix,Oracle, Visual Studio 2013, .Net 4.5, Agile Scrum, Jenkins,Jira,Accurev,GIT Source control, SABRE, MOQ(Mocks)

Creating Flight Anouncement Web App,AlaskaAir.com portal,Code migration

Coding WebAPI REST service as an interface to various clients to communicate

with SABRE service, TDD, MOQ Mocks,Coded REST API LoadCoRecs (Company’s

bulk air tkt purchases (EasyBiz)records for reporting) batch to REST conversion.

Maintaining the AlaskAir.com web site by doing bug fixes and enhancements by

Using MVC,MVP,C#,JQuery,Angular,HandleBar,SASS/SCSS.Fixed Confirmation letter

module of Mexico tax section,Created MSI using mm file and coded nant script.

Coded server warmup for webfarms.Used the REACT JS and Node JS for Internal

web health checker to monitor endpoints like TIBCO, SABRE and other services.

Created the mob programming Dev time switcher app using WPF(MVVM pattern).

Used tools like JIRA for story WF,SABRE emulator,Log4Net,Elma,Sumologic

Microsoft Corporation, Bld 2,Redmond WA(Employer: HCL America Inc)

July 29 2012 to Sep 30 2015 (Email: ac4c77@r.postjobfree.com)

SDE (Desig:-Technical Lead,Software Development Engineer)

Pso Portal(Active Directory C+E)

Asp.net,C#,Linq,AJAX,J-Query, MS-SQL 2008, Visual Studio 2010, .Net 3.5,4.0. Agile Scrum Sprint adopted.

MSODS-OrgID divisions fincance reporting web portal.

Various data pull tools.

Coding new feature request for financial report website using asp.net/C#

and Sql server. Used AJAX with Jquery for parallel asynchronous pull

of data.Developed the presentation view (like PPT) in asp.net, wrote

sql stored procedures/functions to fetch the meta data for manipulating

UI rendering, the Portals menu, pages,reports,metric every thing is

dynmically built at runtime for UI rendering, so no static UI pages, developed

Chantilly web site using Html5,Jquery, JSON Used Created webservice to

return JSON data using Ajax call and used graphic engine to build graphs

at clientside, Used bootstrap for UI layout.

Designing new features of portal and Data-Pull tool and

performance tunning.Avoided DB calls and cached the data in PsoPortal

for frequently used data and metadata, automated the presentation creation

and publish the monthly financial data of the PsoPortal with a click of button.

Did the Web site deployments/service configuration, enabled the asp.net

code for session sharing to be used in NLB/F5 scenarios, Sharepoint maintan

anence and password resets

Bug/break fixing & testing of PsoPortal/Applications

Coding data pull tool IPSL,NovaNetworkHeatMap,MSAsset,MSTicket in C# (win

form app) using C# delegates,PLinQ and asynchronous programming and

scheduling this win app from windows task manager, used Linq/Plinq

extensively for performance boost for the long running data handling methods,

used bulk data insert in C#.

Coding PsoNet web app using html,Silverlight plugin,

Jquery to do the client side feature requests/bug fixes

Bug fixing/feature enhancement in O365 MVC Admin web site Created varous models

Loaded data using SSIS and created report using SSRS, reports

like TFS individual,team,Headcount, expense

Wrote sql stored procedures with parameters for dynamic sql inputs to avoid sql injection

Attacks, gave only execute permission and not delete permission

Microsoft Corporation, Bld 6,Redmond WA(Employer: PeopleTech Group Inc)

Jan 30 2012 to Jul 27 2012(Email: ac4c77@r.postjobfree.com)

SDET (Desig:-Programmer analyst)

Mint migration Test Development(Online Services – eCommerce)

C#,Web services, MS-SQL 2008, Visual Studio 2010, .Net 3.5,4.0. Agile Scrum Sprint adopted.

WTT(Win Test Techno), test automation,Source Depot(Src Ctrl).Product Studio bugger.

Office 0365 (V2),Intune services migrating to Mint(CTP) is to be done by MQR.

Writing automated unit/integration test case/code and implemented methods.

Designing & developing the data validation tool

Creating Virtual machine for testing using every day builds

Automate the test by writing custom tools & raising bugs

Did migration of tenants from MetraTech to Mint systems and analyzed the logs & generated reports

Wrote GUID compare, duplicate finder tools for log analysis

Wrote utility for script creation from xml logs for automating migration.

Regressed bugs

T-Mobile, Bothell WA-98021(Employer: Ciber Inc)

Mar 28 2011 to Jan 28 2012 Desg:Software Engineer

Consultant - App Programmer/Developer

HSO Applications (HandSet Order Applications)

C#,Web services,ASP.Net2.0,J-Query,CSS, MS-SQL 2008, Visual Studio 2010, .Net 3.5,4.0. Agile Scrum Sprint adopted.

Rhino mocks, MVP, NUnit, Moles TDD tools,SOAP UI.

Rally,XPlanner for User story,defects.

Accurev Source control, cmd line build tools, TeamCity( build monitor tools).

All the Upgrades/Exchange Orders are handled via this HSO system.This is down stream for MyTMO and upstream for Tibco services and Samson services.

This is internal web application for T-Mobile CSR’s to create handset exchange and upgrade orders.

Used TDD to implement the functionalities of the user stories & did defect fixing in HSO applications/sytem using C#, ASP.Net,WebServices, JavaScript,jQuery and MS SQL server 2008.

Wrote automated unit/integration test code and implemented methods for every sprint & delivered the user stories, remedy tickets(prod bugs), QAT defects.Used rhino mocks partial/strict mocking & stubbed methods for unit test.Used molesTest to unit test static methods & codes which cannot be edited to add virtual for rhino to work.MVP pattern was used and the mocking classes implemented the interfaces for enabling the unit testing before the actual views were created in TDD approach.

Every sprint of 2 weeks duration, with 1 scrum master

and 5 team members.Used QualityCenter(QC) tool to create

test cases to test in DIT,SIT,QAT environment.Also involved in test plan/matrices creation with other testers.Create CSS pages for GridStyle,Site,Chart and used it in aspx pages.Used SOAP UI to test the SOAP webservices.

Microsoft, Sammamish WA (Employer: Collabera Inc)

Mar 25 2010 to current(Mar 24 2011)

SDE

OEM-EAM tool

C#,WCF,REST,API,ASP.Net2.0,J-Query, MS-SQL 2008, Visual Studio 2008.

This DOC(Digital Operation Center) site is used by agents to order products & get dividens/commission for Original equipment manufactures(OEM).

Internal web tool for MS partners to search and create business for the MS.3 tier architecture with intra and extra net web application with WCF/WebServices & DB.

Implemented new features & fixed the bugs in this EAM tool using C#, ASP.Net, jQuery, WCF/Web application and MS SQL server 2008.Implemented BCDR/hardware resiliency project.

Fixed bugs of REST API’s for WCF downstream services to pull data from the SAP systems into DOC layer. Fixed issues with othe WCF-REST service interface,which is used by agents in their handset devices application. Perfromed regression, performance, compatibility, localization (Canada, United Kingdom, Germany, France, Italy, Japan, and China), functionality and UI testing.

Intel Corp Aloha OR-97007 (Employer: Collabera Inc)

Jan 20 2010 to Mar 2010

Senior Developer

iCost inventory costing project

C#,WCF,ASP.Net2.0,Windows, MS-SQL 2008, Fiddler, Reflector, Octopus, Sql Deployer Visual Studio 2008/5, C#,Silverlight,PrismFramework,Linq to Enity.NET Data Service, TFS, VSTF, FxCop, Fiddler.

iCost web tool is used for calculating the inventory cost for the intels chip/wafer manufacturing units.

Design & Coded web/SQL application using C# in silver light prism framework and the middle tier is WCF service. WCF service uses Linq to Entity ADO.net to connect to the MS SQL server.

Implemented exception handling, logging into EventViewer/SQL & tracing into files

Used Enterprise Library and created Error logging/Exception logging/Tracing library.

Design developed Stored Procedure/functions/Triggers/ Views/tables with proper error handling & logging.

Created Functional spec/TSD/DDD and coded/unit tested it.

Did peer code reviews and added value to TSP/Test cases

Configured the web sites/DB, fixed the FTM not functioning issue in Dev environment.

Used SQL performance tuning advisor & did performance tuning to DB objects by recreating SP’s and brought down the exec time by converting long joins with small joins & with temp table usage.

Used SQL Profiler to debug the SQL objects, Fiddler to debug an app to see how/what url it is calling from a box

Used FxCop to analyze/review the code for coding issues & optimized the code.

Actively participated in Design review inspections/peer review & code complete signoffs with Redmond team

Microsoft India Ltd

Dec 10 2007 to Dec 31 2009 SDE-2 (Full timer,Title:Dev Lead)

RSM products

WCF,ASP.Net 2.0,Windows C#, MS-SQL 2008/5, Fiddler, Reflector, Octopus, Sql Deployer Visual Studio 2008/5, C#.NET, ASP.NET, ADO.NET Data Service, Windows Service, TFS, VSTF, FxCop, Fiddler.

RSM used for managing & releasing products bits to manufacturers. It consists of various sub products, 4 tier architecture application, web based UI, COM+ components in middle tier. Features: -The file upload/download, Vendor management, Ship Info, Health Monitor, Approval Signoffs.RMS web application, it uses DB objects security model, it has activeX ctrls at web pages, windows notification service, and web service for interaction with other system like ROM/ROQ/DS.The DS system used for uploading/downloading the files.ROM used for CD burning, ROQ used for electronic handoff for non exception media.

Architected the Quarterly release FQR for Print Quality check tool using WCF,WPF.

Design & Coded web/windows application and web/Windows services in projects Trinidad,RS2,RALF using SQL2005,ASP,ASP.Net,WCF, XML, C#,.Net 2.0/3.5,JS

Implemented exception handling, logging into EventViewer/SQL & tracing into files

Used Enterprise Library and created Error logging/Exception logging/Tracing library.

Design developed Stored Procedure/functions/Triggers/ Views/tables with proper error handling & logging.

In RS2 project design & coded the DB objects SP/Table. Coded the Windows app (Lab Exp) in RALF project. Design and coded window service (RSMNotifSrvc) using C#.

In NQRROM project Created Web Services (ROMBSCallbackWS) using ASP.Net & C#. Used XSD to create the class from XSL to validate & serialize the input XML into object.

In NQR-ROM project created WCF based web service for Burn system to interface with ROM system, merged 2 windows-services to one using delegates & timer.

Created Functional spec/TSD/DDD and coded/unit tested it.

Did peer code reviews and added value to TSP/Test cases

Configured the web sites/DB, fixed the FTM not functioning issue in Dev environment.

Used SQL performance tuning advisor & did performance tuning to DB objects by recreating SP’s and brought down the exec time by converting long joins with small joins & with temp table usage.

Used SQL Profiler to debug the SQL objects, Fiddler to debug an app to see how/what url it is calling from a box

Understanding the Legacy Systems design, Architecture and documenting it.

Used Reflector to reverse engineer an app for which code is missing

Used FxCop to analyze/review the code for coding issues & optimized the code.

Actively participated in Design review inspections/peer review & code complete signoffs with Redmond team

Conducted the pre Base-line/ Base-line meetings with Redmond team. Interacted with business/SD

Used Sharepoint service 3.0 for developing the internal sites.Architected & developed the Expense managent tool using Sharepoint ( MOSS 2007, infopath)

Responsibilities: Cognizant Technologies Pvt Ltd

June 13 2005 to Dec 2007, Sr.Developer (Techonoloy Specialist:125887)

NexGen

Windows C#(WinForms), MS-SQL 2000 Visual Studio 2003, C#.NET, ASP.NET,ADO.NET Data Service, SQL Server 2003/05, SOAP, Windows Service, TFS (Team Foundation Server), VSTF

The Prolite (project task, activity) is an office plugin to create defect, issue, risk. Supports the conversion of selected comments as defect, issue and risk. Designed & developed the Prolite Helpdesk desktop(win forms) application & the communication was using .net remoting.

Design, Architecture for NexGen tool.

Developed the functional specification for it.

Developed the modules using WinForms(Remoting), ADO.Net, XML, C# and lead a team size of 5 members.

ACE hardwares(Cognizant Technologies Pvt Ltd)

ASP.Net 2.0, WinForms, C#, MS-SQL 2005

ACE websites like AceOnline.com, AceHardware.com is used by the Ace customers for purchasing comodities.AceNet web system is used by the retailers to update about their store info & for making purchase orders, tracking and Billing.

Developed Scoping for new features.

Developed the functional specification for the new projects.

Developed the different requirements using ASP.Net/C#.

Designed & Coded the DB objects.

Mellon Investment Banking(Cognizant Technologies Pvt Ltd)

ASP.Net 1.1, C#, JavaScript, ADO.Net with MS-SQL 2000,VB,C++,COM Visual Studio, C#.NET 1.1,ASP.Net 1.1, MS SQL server 2000

This project involves maintaining the EOS (Employee ownership system) system used by MIS (Mellon Investor services). This Investment banking system is being used to service clients for managing Stock Option, Restricted Stock plans for large corporations. The EOS is built on the Windows platform and consists of components developed in VB, C++. It uses MS SQL server 2000 as the database. The Participant interface (PI) provides the means to view / exercise grants by the employees of participating clients. This interface PI is built on ASP.Net. The PI web is available to Operations and Client Administrators to do various activities of Stock dealing & transactions like issuing grant plan, exercises and setting up different parameters of the stock system. Modules like Beneficiary, LimitOrder Cancellation, Payroll withholding (WPCarry) etc.COM component written in C++ called CBOL is the core API to be called by EPG, PI.

Involved in guiding & coding the various module’s new features.

Helped in team to understand the design pattern & the framework of the system.

Interacting with the Mellon client for understanding the requirements and did module delivery.

Amgen Pharmaceutical(Cognizant Technologies Pvt Ltd)

ASP. Net, C#, ADO.Net with Oracle 9.2

This project is to migrate the current “Project Portfolio Database” used to manage project management information internally by the POQIS department with in Amgen from Access 2000 to Oracle 9.2. and to develop an ASP.NET front end using C# as language of choice. Amgen Management requires greater visibility into projects submitted for implementation at the department, functional area, site, corporate function and global level. Project portfolios at each of these levels draw resources, both financial and FTE from within and across corporate boundaries. Competing requirements for corporate resources require that these portfolios be able to be summarized and analyzed at a global level for prioritization and approval. The current Project Portfolio Management Tool in Access is the application that is used for tracking and prioritization of projects in Process Development, Operations and Quality

Involved in converting the MS-Access pages to the ASP.Net pages.

Helped in improving the performance & executed the Dev Partner & CLR profile tool to analyze the product. Involved in testing & bug fixes also.

Interacting with the client for understanding the Client’s requirements and getting clarifications

Verizon Data Services India Pvt Ltd

Dec 2003 to June 10 2005 as Senior Analyst (Senior Developer/Tester)

IOBI

C#, ASP.Net, XML, ADO.Net with MS-SQL server 2000.Visual Studio,.NET 1.1, MS SQL server 2000

This IOBI call management tool is for Verizon phone customers of USA.It has got Address book, call forwarding, call group management etc.

Worked as Developer in IOBI project using C#, ASP.Net, XML, ADO.Net with MS-SQL server 2000.Visual Studio,.NET 1.1, MS SQL server 2000.

Developed web UI pages for showing call history & address book pages using C# in ASP.Net, defined the controls/menus in xml and used XSLT to transform

the controls defined in xml to the html for to be rendered in web site pages

Created new pages for iFavorites for the IOBI web application, iFavorites data was pulled by calling the web services

Worked in improving the performance of website by adopting caching of data in control, page caching, using user controls, view state disabling, avoiding round trips and doing client side validation, adapting AJAX technique, also improved the data pull query performance tuning, also set the clustered and non-clustered index to the tables, replaced the cursors with update joins for faster performance

Created web services for IOBI client & IOBI web for servicing the call activities

Created Call Analysis tool which gives different chart images by using ChartFx tool bonded to web pages, displayed various graphical reports using the highchart tool engine

Used Java script for client side validation, client side features like showing popup for data inputs and warnings.

CADS Software India P Ltd, Chennai, India.

Sep 2003 to Dec 2003 as Software Engineer

Rebar3D

Rebar3d tool is a structural engineering design tool in AutoCAD.

Worked as Developer in Rebar3D product using AutoCAD & C++

Did coding & developed few modules of the Rebar3D tool

Coded custom entity creation & wrappers to work with core graphic engine, designed the work flow and UI pages for the custom entity creation by understanding the spec of the product requirement using C++ and AutoCAD API,with this page the user can create custom structural engineering modules and save it for construction usage, design developed the C++ classes and methods/properties meeting the OOPS standards and implemented the methods using different design patterns like Singleton, Adapter, Abstract factory and Façade

Read the knowledge sharing documents, attended knowledge sharing live demos and documented the help document for others to consume it during ramp up periods, created the high level design document for feature changes by going through the feature specification document

Tested the usability of the Rebar3D tool for better user experience, cosmetic, ease of use testing using the industry standard black box testing techniques, gave a detail report of the output of testing for the PM’s to convert such into the bugs and feature enhancements of the product

M.K Technologies

Jan 2003 to Sep 03 as Development Engineer

Kuborto Customer support Web application & KCAD tool

Vc++, MFC, AutoCAD, Object ARX, ASP.Net(C#, VB), ADO.Net, XML.

KCAD tool customized AutoCAD tool developed for Kuborto corp. Japan.

Customer support Web application for Kuborto’s corp Japan.

Worked as Developer in Kuborto Customer support web application project using ASP.Net(C#, VB), ADO.Net, XML, Vc++, MFC, AutoCAD, Object ARX

Did coding, testing and Implementation for the KCAD tool customized AutoCAD tool developed for Kuborto corp. Japan.

Developed customer support web application for Kuborto’s corp Japan using ASP.Net

Creating the customer support /sale web site of the Kuborto company

Used ADO.net for storing the request info of the customer into MS-SQL db and XML file

Created new features in KCAD tool using Object ARX library

Clientsoft, USA (Feb 1999 – Dec 2002)

Intel Corp – Sacromento, Folsom CA.

Jan 2002 to Dec 2002 as Developer

Hyper Threading tool (HT) web application

ASP.Net C#, MFC, SQL Server 2000.

HT Desktop Platform verification & Branding Utility tool needs web site interaction

for many activities by the world wide users. Another website (AdminSearch) is for the admin users at Intel Corporation to access the data. The uploaded information is stored in

SQL Server Database. Branding tool works on system reboot & provides splash screen.

So it makes sure that system is in the recommended state with correct chipset, processor etc.

Designed & created the website for the above tool.

Created Encryption & Decryption modules, File upload & download module.

DB access module using ADO.Net.

Used Rational Robot to create test script to test the web site.

Oct`2000 to Dec 2001 as Developer

ECM (Source Control System using CVS)

Intel Corp Hillsboro Oregon (Clientsoft, USA)

VC++ 6.0,Win32 SDK

ECM (EFI Code Manager) tool is using CVS as the base source control. Since CVS is an open source & has many features that VSS doesn’t have like branching etc, ECM uses it and provides user-friendly GUI & change log management (SQL) in an efficient way. ECM also provides cross country access (USA, China, Russia) with the centralized CVS server & Change log Oracle server at USA.

Did coding, testing and Implementation for the ECM Modules.

Have written PL/SQL Stored procedures and packages.

Used Win32 SDK programming to create a diff tool for showing the "project difference".

Used ATL for creating COM Components and used DCOM for communication between ECM clients & server.

Jan 2nd `2000 to October 27th 2000 as Developer

IVR-Wagering System for Horse Race (IVR System)

TVG - Denver CO (Clientsoft, USA)

VC++ 6.0, MFC, Win32 SDK, SQL- SERVER 7.0

System is used for placing bets on horses across USA using client & web applications. It maintains user in its DB.User can subscribe to bet via phone (IVR).

Created new modules, Enhancing & bug fixing in the IVR wagering system by using MFC.

Created multithreaded module for playing acct balance in wagering system and Wait message multithreaded module using MFC.

Made many new modules like storing wagering results & playing customized results, Designed & created the database for storing the "call record activity" of IVR system to log the caller activities.

Created ATL-COM server Alarm module. Created "RegComp" tool to compare different registry settings across machines in network by using Win32 SDK.

Created a "StartOfDay" (MFC) socket module for the IVR app.

Developed web site for CSR access using vbscript with Back end as SQL server 7.0(Designed & created the tables, SP&Trigger).

Created ISAPI filter for user authentication using the MFC ISAPI classes.

Apr `99 to Dec ’99 as Test Developer(SDET)

MSN.COM (APT-Aggregation Propagation Team)

Microsoft Redmond (Clientsoft, USA)

Vc++ 6.0, SQL- Server 7.0, VBScript

MSN.COM has Back end databases CORAL, Atlantis, CORAL/Atlantis IE UI for Managing content operations and with applications like Fetcher & Matchbox.

Developed Load test tools (CoralDataGen.vbs, AUKDataGen.vbs, CitySearchDataGen.vbs) using SQL queries with VBScript for Coral & Atlantis db's.

Also developed Content checking tool by using Vc++ which returns connectivity status about list of URL's given in a text file.

Opened bugs related to Triggers, SP’s in both db's.

Used "PerfMon" & SQL Trace to diagnose the SQL-SERVER 's performance.

Used ASP (VBScript) coding thru Front Page to create Status report about the test servers.

Created Install verify tools (using VB) for the test beds.

Used tools like Performance Monitor, SQL Profiler, Event viewer, RAID, Tactics.system to log the caller activities.

Created ATL-COM server Alarm module. Created "RegComp" tool to compare different registry settings across machines in network by using Win32 SDK.

Created a "StartOfDay" (MFC) socket module for the IVR app.

Developed web site for CSR access using vbscript with Back end as SQL server 7.0(Designed & created the tables, SP&Trigger).

Created ISAPI filter for user authentication using the MFC ISAPI classes.

Feb `99 to March 99 as Developer

Client Internet Reporting tool

Citi Bank, Manhattan New york, USA (Clientsoft, USA)

VC++ 6.0,MFC, ASP, VBScript

This is the CITI Bank product for the CITI bank client to browse their report about their current savings in their account. This browsing of report through Internet is for separate VIP account with very large deposit. This product is only report viewing and it does not allow the checked in user to modify data.

Have involved in creating ATL-COM components for Oracle Database access by using OO4O (Oracle Objects for OLE) classes. These COM components implements methods for SQL access for fetching data for the Internet browsing report system.

Validate the user and allow for report browsing of their details about their account.

Created modules like report generation of balance & Interest

Intelligent Systems India P Ltd, Chennai, India

Dec 97 to Feb 99 as Developer

Fog Detection System for VDOT (Aug 98 to Feb99)

VC++ 5.0.MFC, MS SQL Server 6.5, Win32 SDK.

This Project is aimed at detecting the fog in roads and control the light intensity and displaying sign boards (VMS-Variable Message Sign).It involved a central data acquiring and processing system, which will be based in the server and a data viewing and modifying system that shall be run by the peripheral remote and laptop computers that access the server for any details or processing. The objective of this system was to monitor the visibility condition in a given area, by taking inputs from the visibility sensors and reacting accordingly by increasing the intensity of the street lights and changing the messages displayed in the 'Variable Message Sign device?.

Was involved in designing the UI for VMS and the API library for communicating with display devices through RS-232C port (protocol format).

Have designed various GUI screens and has coded the functionalities for the VMS Module using MFC.

Coded for Tape Backup Module by using Ditto / Seagate Tools, Modem - communication between laptop and Central computer.

Created worker threads for monitoring various alarms and also to create log files

Jun `98 - Jul `98 as Developer

Find Duplicates Tool Creation (OCX-Server) for USPS

VC++ 5.0, MFC, Oracle 7.0

This tool was created mainly to enhance the speed and handling of a very large address database, finding duplicates in the postal address database and removing it. This project was done for the United States Postal Service (USPS) department / agencies, where many agencies were involved in sorting mails to get discounts from USPS.

Designed the GUI screen and coded for finding duplicates for the given table using MFC. Win32 API was used for accessing the table and the user was



Contact this candidate