Sql Server Engineer

Resume

Umesh Mohanlal Joshi

***** * **** *** *** 2083, Phoenix, AZ, 85027

Email Id: ************@*****.**.**

Cell No: +1-201-***-****

PROFESSIONAL SUMMARY:

> 10 years of software experience in system study, analysis,

development, Defect Mitigation and rectification.

> Having experience in ASP.NET, SQL 2000/2005, Sybase,IIS, LINQ To Sql

Classes, OpenXML, Classic ASP,

> Experience in Entity Framework 4, MVC 2.

> Hands on experience in SQL Server Database design, Database

maintenance, developing T-SQL queries, stored procedures, and triggers

using SQL Server 2005/2008.

> Extensive expertise in developing Web Forms Controls using ASP.NET,

AJAX.

> Expert in debugging an application using the debugging tools provided

by the Visual Studio.Net IDE.

> Extensive experience in Banking and Finance Domain.

> Excellent analytical, problem solving and communication skills.

> Strong understanding of Design Patterns and Practices such as Factory

Method, Singleton, Facade

> Experience of working at Client Location.

> Effective in working independently as well as a team player with

problem-solving and troubleshooting capabilities.

> Organization skills and ability to handle work in an efficient and

timely manner.

> Ability to prioritize and to plan, coordinate and monitor work plans.

> Ability to work effectively under pressure.

> Quick learner and a good team player with ability to prioritize tasks,

pay attention to details and meet deadlines.

> Excellent communication and writing skills.

> Flexible in work, ready to take challenges.

> Extremely motivated self-starter and result driven towards good

quality work.

> Effective in working independently and collaboratively in teams

> Excellent analytical, problem solving and communication skills.

> Organization skills and ability to handle work in an efficient and

timely manner.

> Ability to prioritize and to plan, coordinate and monitor work plans.

> Ability to work effectively under pressure.

TECHNICAL EXPERTISE:

Web Technologies : ASP.NET, Classic ASP, AJAX

Other Technologies : Entity Framework, OpenXML, LINQ to Sql Classes,

Crystal Reports.

Languages : C#, VB 6.0

Markup Languages : HTML, DHTML

Scripting Languages : VB Script, Java Script.

Database : SQL Server 2000/2005, Ms Access, SYBASE

Other Tools : TFS, VSS, SOAPUI, JMeter, MKS Source Integrity, Primavera

Dimensions, infoman change management, OPAS.

ACADEMIC QUALIFICATION:

Degree University / Board Year Of

Passing

MBA (Information Sikkim Manipal University 2011

System)

B.Sc (Computer Science) Mumbai 2004

INTERPERSONAL SKILLS:

> Good communication skills.

> Confident, Having team Spirit and a Creative.

> Capable of handling responsibilities & delivering them on time.

> Capable of handling team.

> Excellent at research and development.

> Strong problem solving capabilities.

RESPONSIBILITY HANDLED:

> Requirements gathering, Communication with end users/ customers for

requirements and or discussing project issues.

> Creating prototype, test cases, technical documents as well as project

documents.

> Design, Architect applications/solutions using MS technology.

> Technical development as per requirements.

OTHER ENDEAVORS:

> Certification in Advance Secure Coding (I) at Citi Group.

> Certification in Advance Secure Coding (II) at Citi Group.

PROFESSIONAL EXPERIENCE:

Client: Wells Fargo Home Mortgage

Company Name: Cognizant Technology Solutions.

Designation: Sr. Associate-Project

Duration: Mar 2013 - Till date.

Job Handled:

1) LSA Services: LSA services application exposes services to Phone

Banking department, and is consumed by other application such as CIV and

Retent. It has services which facilitate retrieval of customer account

related data, statement details, profiles etc.

TEAM SIZE: -2

DURATION: - Working till date

LANGUAGE: -.NET 4.0, C#, WCF, SQL, TFS, SOAP UI, JMeter.

2) Retention: Application is used by Wells Fargo Home mortgage bankers

across US to keep their customers accounts with WF by offering better

offers / Rate when a customer is approaching other mortgage company to

switch their account. It uses Salesforce, Pricing engine and various other

internal services to fetch data for the customer account and offers related

data, do calculation and provide for an offer

TEAM SIZE: -5

DURATION: - Working till date

LANGUAGE: - MS Access, SQL server, .NET 4.0, C#.

Client: JPMorgan Chase

Company Name: Cognizant Technology Solutions.

Designation: Sr Associate-Project

Duration: Apr 2012 - Feb 2013.

Job Handled:

1) Eserve Application: Eserve consists of EPI and CPI application,

currently cognizant is executing development task to automate payments sent

through faxes using third party OCR engine Brainware, and rewriting all the

business logic and validation modules in .Net which is used in the legacy

application which was used for manually creating payments by business

users. Upon automation of the fax payments business expect 70% of the

payments to be created through this new ICR Application..

TEAM SIZE: - 7

DURATION: - 10 months

LANGUAGE: - ASP.NET 3.5, C#, SQL, AJAX, Classic ASP.

Client: Moody's Rating Agency

Company Name: Syntel.

Designation: Sr Analyst Programmer (B2, AP3)

Duration: Jan 2012 - Apr 2012.

Job Handled:

1) EPI: EPI is Electronic Publishing Interface consisting of various

applications used to publish article, documents and other news to various

subscribers.

TEAM SIZE: - 2

DURATION: - 4 months

LANGUAGE: - ASP.NET 3.5,C#, SQL, AJAX, Classic ASP.

Client: Moody's Rating Agency

Company Name: Syntel.

Designation: Sr Analyst Programmer (B2,AP3)

Duration: Sep 2011 - Dec 2011.

Job Handled:

1) Addendum Refactoring: Addendum application had some performance issues

and also there were some enhancement which couldn't be implemented without

resolving current performance issues. So we had developed a POC based on

lazy loading concept that would provide all existing functionality with

improved performance.

TEAM SIZE: - 2

DURATION: - 3 months

LANGUAGE: - ASP.NET 3.5,C#, SQL, AJAX.

Client: Moody's Rating Agency

Company Name: Syntel.

Designation: Sr Analyst Programmer (B2,AP3)

Duration: Jul 2011 - Sep 2011.

Job Handled:

2) Addendum: Addendum also known as Moody's Rating Committee Addendum is a

web application used to submit the addendums for ratings related to deals

or action ids. Rating Committee Addendums are currently available for the

SFG (Structured Finance Group) and CFG (Corporate Finance Group) business

groups. In this application, users will be able to review, update or share

the details of a committee, and post the Rating Committee Addendum details

to the appropriate document management system (EDMS). The refactoring of

Addendum involved redesigning of SFG module only which helped in resolving

performance issue and making the SFG module more scalable.

TEAM SIZE: - 3

DURATION: - 3 months

LANGUAGE: - ASP.NET 3.5,C#, SQL, AJAX.

Client: Moody's Rating Agency

Company Name: Syntel.

Designation: Sr Analyst Programmer (B2,AP3)

Duration: Jan 2011 - Jun 2011.

Job Handled:

3) MSRB/EMMA Project: MSRB/EMMA - Electronic Municipal Market Access by

Municipal Securities Rulemaking Board provides comprehensive data for

municipal disclosures, market transparency data and documents about the

municipal securities market in SOAP format. Moody's partners/analysts

wanted to generated reports from this source.

This SOAP message gets updated every one hour like stock exchange index.

Business requirement was to capture this Municipal security flux in every

hour and stored this information in RDBMS with maintaining its history and

then generate reports from this stored data.

Syntel team has worked on prototype for this project in Nov-2010. We

presented POC to client in around Dec-2010, client accepted our POC and

given us the green signal for development. Based on this we got the final

BRD from analyst in Jan-2010. The most important part of this project is

that Syntel team designed architecture, database and work flow without any

help from Moody's developers.

TEAM SIZE: - 3

DURATION: - 6 months

LANGUAGE: - ASP.NET 3.5, LINQ, C#, SQL, AJAX, Sybase, JavaScript, Web

services.

Client: Moody's Rating Agency

Company Name: Syntel.

Designation: Sr Analyst Programmer (B2,AP3)

Duration: Oct 2010 - Jan 2011.

Job Handled:

4) SFG Deal Memo: Worked on project that would generate Deal Memos from the

Word Template document using OpenXML and Microsoft Office Project

(Prototypes and demos are submitted and accepted by client) which would

save lots of time and efforts to create them manually. Thus increasing

productivity and minimizing human errors in Deal Memos

TEAM SIZE: - 3

DURATION: - 4 months

LANGUAGE: - OpenXML, VSTO, ASP.NET 3.5 (C#), Sybase, JavaScript, Web

services.

Client: Moody's Rating Agency

Company Name: Syntel.

Designation: Sr Analyst Programmer (B2,AP3)

Duration: Sep 2009 - Sep 2011.

5) iSFG Tracker: iSFG Tracker was developed to keep track of the deals that

analysts work on .there were several reports that were used to know the

current status of the deals rating process.

TEAM SIZE: - 4

DURATION: - 11 Months

LANGUAGE: - ASP.NET 3.5 (C#), LINQ, SQL server, JavaScript, AJAX, Web

services,jQuery.

Client: Citi Group

Company Name: VIT Consultancy (Chennai).

Designation: Sr. Software Engineer (Consultant at Clients Place Wipro

Technology Services).

Duration: Jan 2009 - Sep 2009.

Job Handled:

1) ARMS (Automated Recovery System) its an internal billing application for

infrastructure used, in Citigroup.

ARMS is an automated tool contains the full suite of functions necessary to

manage Technology Infrastructure recoveries ranging from maintenance of

customer master details through to the generation of (CGICS) billing files

for usage charges. ARMS has the capabilities to compute and report on plan,

forecast and actual charges for services encompassing application hosting,

distributed services and project implementation. ARMS contain flexible

reporting features and will be integrated to the Client Portal for customer

reporting.

ARMS is used to recover service charges and product charges from various

businesses for which the services are rendered by CTI (Citigroup Technology

Infrastructure) EMEA Regions. During starting of financials year, the

business will allocate plan of usage for each business and during course of

months their usages will be calculated and they are charged accordingly.

TEAM SIZE: - 10

DURATION: - 9 months

LANGUAGE: - ASP.NET (C#), SQL server, JavaScript, AJAX, Web services.

Client: Citi Group

Company Name: Nucleus Software Exports Ltd.

Designation: Software Engineer (Consultant at Citi Technology Services

).

Duration: Oct 2007 - Jan 2009.

Job Handled:

1) Storage Management System.

SMS is a tool used by the storage management team of Citi for maintaining

and logging the requests for storage devices like Disks, Luns, and Cables

etc.

1. New disks 2. Assignment, de-assignment and replication of Luns 3.

New Cabling request 4.New Zoning requests once the request is

submitted the managers and the administrators approve and process

the requests. It's a 3 level processing with Requestor, Requestor

manger and Administrators as the actors. The system uses server

configurations and has a module for maintaining these server

information and the Master data

2. We have used Single Sign On for authentication and user groups for

authorization.

a) Raise new requests for any kind of changes related to storage

(LUN Masking, Cabling, Disk Space, and Zoning).

b) Different access level and Different approvals for a request

depending on type of request.

c) Generate reports for the changes.

TEAM SIZE: - 2

DURATION: - 6 months

LANGUAGE: - ASP.NET (C#), SQL server, JavaScript, AJAX, Web services.

2) ETOOLS for raising requests for changes to be done in UAT and

Production servers.

ETOOLS are the tools used by the data center people for recording and

processing the data center activity requests. These are set of 4 tools,

every tool is and application in itself with different processes. ETOOLS

are the combination of following tools:

1. ePjmr: - (Production job Modification Request) this tool is used for

raising requests for running adhoc jobs / scheduling jobs on productions

servers of Mexico. It's a 3 level process with 2 actors

2 eUMR: - (UAT Modification Request) is a tools used for raising requests

for running adhoc jobs / scheduling jobs on UAT servers of Mexico

3. eJob Ticket: - used for raising problem tickets.

4. EMedia: used for movement, installation, de-installation of media.

Thus this one project consists of many subprojects with their own

processes but all are tied up via Login page. Allows the authorized

person to raise and process the request

a) Raise new requests for change to be done.

b) Different access level and Different approvals for a request

depending on type of request.

c) Generate generate reports for the changes

TEAM SIZE: - 1

DURATION: - 10 months

LANGUAGE: - Classic ASP SQL server, JavaScript.

Client: Local & international site owners/company

Company Name: Dot Com Services Pvt Ltd.

Designation: Software Engineer.

Duration: July 2006- Oct 2007.

Job Handled:

1) Web Sites: - Summary of Development in web portals.

LANGUAGE: - ASP.NET 2.0 (C#), Classic ASP 3.0, SQL server, JavaScript,

AJAX

. Product management.

. User management

. Stocks management

. Orders management

. Content management (Edit Html pages in site, news posting, jobs

posting, etc)

. Banner management for individual pages in web site

. Online shopping (With Multi Currency and Dynamic Calculations of

Price According to raw materials used to prepare).

. Photo Galleries.

. Forums

. E learning

. Online test

. Shopping carts with auto calculation of product prices depending

on raw materials and labor charges for product, integration with

FedEx for tracking shipments, multi currency, Payment gateway

(AJAX, consuming web service for shipping rates and tracking

from FedEx).

. Ftp Website for sharing files between user and admin

Few sites developed by me.

1) http://americhoicegifts.com/

2) http://www.elliottco.com/

3) https://www.freight-calculator.com/

4) http://www.jewelrybyhk.com/

2) Smart ID: - this program was integrated with swap card machine; it

extracts in time and out time of each employee from the swap machine.

And generates report based on the same regarding working hours, no of

days preset, putting in late marks after 30 minutes (default which can

be configured), calculating half days for 4 late marks etc.

. User configurable mail servers, manual entry and editing for

attendance records, configurable shift timings and assigning

different shifts to employees, configurable holidays.

. It generates monthly muster report, Calculates total working

hours and difference in working hours for each employee.

. Latecomers, early goers report.

. Sends monthly attendance report to each employee through mail

and a consolidated report to HR.

TEAM SIZE: - 1

DURATION: - 4 months

LANGUAGE: - VB 6.0, SQL

Client: Local clients

Company Name: Vistasofft Information Technology.

Designation: Software Engineer.

Duration: Dec 2004 - June 2006.

Job Handled:

1) Billing: For Print + Company, this company is in to printing work and

gets orders from HDFC bank in form of excel sheet through mail on

daily basis for all branches in India which the program imports and

makes challan by grouping the data based on cost center, destination

for order and branch code.

a) Generate challan report for different destinations.

b) Generate labels for each destination for packaging purpose

c) Generate bills at the end of months based on two specified

dates.

d) Calculation of current stocks of raw material (paper) based

on challans generated by application.

TEAM SIZE: - 1

DURATION: - 4 months

LANGUAGE: - VB 6.0, SQL server

2) Inventory System: this program was For Tel net Engineers, which is in

to manufacturing of high quality intercom they buy raw materials and

then make components according to need and different component are

then assembled to make final product. Also some raw material or

components were sent for painting before the process of assembling.

a) The application used keeps track of opening stock and all stock

transaction occurring due to purchase-sale.

b) Keep track of purchase-sale records, transaction between

supplier, company, and company due to faulty material, challans

for material sent to painter and received for the same.

c) At the same time manipulate stock based on each of above

transaction.

d) Generate stock status report, individual transaction report,

stock valuation report.

TEAM SIZE: - 3

DURATION: - 4 months

LANGUAGE: - VB 6.0, SQL server

Worked On In House Projects for Error Rectification and Maintenance

1) Kurrancy: - this program is an accounting package developed for small

to medium sized traders with multi-company, multi-financial year and

multi-currency support.

a) Addition, deletion of assets, liabilities.

b) Add, edit, and delete transaction entries.

c) Maintain item master (with current rate last rate and run

rate) and stock

d) Generate reports like item report, supplier wise items, item

wise suppliers, transaction type report, individual and group

accounts report, trial balance, balance sheet, fund flow,

balance sheet as on date.

TEAM SIZE: - 1

DURATION: - 7 months

LANGUAGE: - VB 6.0, SQL server

2) Real Estate: - this program was desktop application running over LAN

(Multiple clients) by the Royal House Agency the company which has

corporate client base and they provide properties to the clients

. Can enter property details including rent, sale terms,

inspection and client details.

. Search and export properties, client data in excel format.

. Generate different inspection and property reports and export to

excel.

. Reminders of rent due and expiry of lease period.

TEAM SIZE: - 1

DURATION: - 4 months

LANGUAGE: - VB.NET, SQL server

Made context sensitive help for all the above projects in V.B

PERSONAL DETAILS:

Date of Birth : 14th August 1982.

Sex : Male.

Languages known : English, Hindi, Gujarati, Marwadi.

Marital Status : Single.

Nationality : Indian.

INTERESTS & HOBBIES:

> Reading, music.

I hereby declare that statements given above are true & correct in best

of my knowledge.

Place: Mumbai Yours Sincerely,

Date:

(Umesh MJ)

Contact this candidate