Sql Server Project

BAL KRISHNA JHA

*************@*****.*** Certifications:

PHONE: 201-***-**** [pic]

SUMMARY Microsoft .NET

Microsoft Certified Professional, with over 8 years of experience Framework

in IT industry with Object-Oriented Design and Development Application

including Software Development Life Cycle (SDLC) from analysis and Development

design to implementation with Microsoft based Technologies. Foundation

Experience in working with Web based applications. Good Skills

understanding of Web development architecture & design. ASP, ASP.NET/C#,

Extensive experienced in Classic ASP (3.0), VB6. ADO.NET,

Hands on experience in using HTML, JavaScript, VBScript, AJAX, ADO, Web

jQuery, CSS and other client scripts. Services, VB 6.0,

Proficient in programming with Ms.Net frameworks/Platforms and T-SQL,

sound knowledge of associated technologies such as ASP.Net, C#, Silverlight,

LINQ, VB, ADO.Net. LINQ, Informatica

Worked on Migration projects from Classic ASP to ASP.NET

Worked extensively on Relational Databases using MS SQL Server

2000/2005/2008, Sybase, MsAccess, and some exposure to Oracle. Scripting:

Well versed in writing of complex Database Queries, Stored Linux, DOS, Java

Procedures, Functions, and Triggers. Script, VB

Proficient in GUI Designing(front end) as per the business Script, AJAX,

requirement taking into consideration, the program optimization. jQuery

Some experience in using image design softwares like Photoshop,

Microsoft Expression tools like Expression Web, Expression Design, RDBMS:

Expression Blend, etc. SQL Server,

Experience in Financial domain and technologies like Autosys, Sybase, Oracle,

Informatica, Linux Scripts, Stored Procedures, TIBCO Business MsAccess

Works, Jira.

Worked on MS Access and VB based Reporting Tools. XML Related:

Exposure to repositories/version control tool like Visual Source XML, XSL, XSLT,

Safe (VSS) and SVN XAML, AJAX, SOAP,

Some experience in using WSDL

Proficient in creating Requirement Analysis and Design documents.

Working knowledge of Model-View-Controller (ASP.NET MVC Framework) Development

Working knowledge of SharePoint Tools:

Experience in designing and layouting of conventional print media VisualStudio.NET,

pages with software like Adobe InDesign. Visual Web

A systematic, organized, hardworking team builder with an Developer, Visual

analytical mind; reliable as a fully contributing, responsible & Studio .NET 2008,

accountable member of task/project teams. Eclipse,

Background and Education Informatica Power

IT work experience since 2003 Center, TIBCO/BW,

Bachelor of Engineering (BE/Computer Sc.) from Shri Govindram

Seksaria Institute of Technology and Science (SGSITS), Indore,

India; affiliated to Rajiv Gandhi Proudyogiki Vishwavidyalaya Content

(University), Bhopal, MP, India. Management

Master of Business Administration (MBA/Marketing Management) from Systems:

GH Patel Postgraduate Institute of Business Management, affiliated WordPress, Mojo

to Sardar Patel University, Vallabh Vidyanagar, Gujarat, India Portal

Application

Servers:

IIS

Version Control:

SVN, VSS

Design S/Ws:

Adobe Flash,

Photoshop,

InDesign,

Expression Blend,

Expression Web

PROFESSIONAL EXPERIENCE

Client: Barclays, NJ/NY

April 2011 - Present/Ongoing

Sr. Developer

Barclays is an investment bank, with its headquarters located in the UK, but having

operations globally.

I am at its Wealth division in NYC, which is engaged in the function that is

responsible for calculation of brokerage, salary, incentive etc for the sales

workforce. The application is called Sales Compensation.

The Sales Compensation application is based around several technologies like ASP, VB6,

JavaScript, jQuery, SQL Server, Sybase, Linux Scripting, Autosys, Java, Ant Scripting,

SVN, Informatica - to name a few. My functional area was development and maintenance

of the application using the mentioned tools/languages.

Responsibilities:

Developing new functionality to the existing user facing application, mostly using

Microsoft based technologies like ASP, VB6, JavaScript, HTML, XML, AJAX, CSS, IIS.

Writing complex Stored Procedures (SP). The main logic like Trade Searches, data

verification and report preparation etc was written in Stored Procedures.

Preparing financial Reports through SQL Server and writing a Java software to convert

it to BLOB object - for easy storing and retrieval.

Writing complex Javascript based AJAX to pull out data through SQL Server Stored

Procedures for multi-level Drill-Down of data in ASP pages.

Use of jQuery to enrich user experience with UI

Migration from Sybase to SQL Server 2008

Maintaining Autosys jobs in Staging environment, and L3 level supporting to Production

issues when necessary

Writing and debugging basic Informatica jobs to capture data coming in through flat

files and converting it to data in SQL Server.

Maintenance and development of their message processing system with TIBCO/Business

Works

Migration of repository from VSS to SVN - writing a Deployment Script using SVN tags,

ANT and DOS script.

Requirement analysis and writing Technical Work Specification for offshore developers

The Version Control was VSS and SVN

Environment: Linux Script, Stored Procedures, Autosys, ASP, ASP.NET, C#, JavaScript,

VB, VB Script, JavaScript, JQuery, SQL Server, Sybase, ADO, CSS, HTML/XHTML,

Informatica, TIBCO/Business Works, Java, ANT Script, SVN, VSS etc.

Client: KPMG, NJ

Jan 2011 - Mar 2011

Dot Net Application Developer

KPMG LLP, the U.S. audit, tax and advisory services firm, operates from 87 offices

with more than 23,000 employees and partners throughout the U.S. It employs a total of

138,000 people.

To cater to the Human Resource related needs of the company, the KPMG has several

applications. The employees, and the partners make use of these applications to manage

and grow and plan their career with the resources offered by the organization. My

project was related to addition of new modules in the already build applications, as

well as maintaining the new ones. The applications were built Classic ASP. Other

languages technologies like C#, VB, VB Script, JavaScript, JQuery, SQL Server, Oracle

Server, ADO, ADO.NET, CDO, Spry, CSS, HTML/XHTML, etc were also used.

Responsibilities:

.Doing additions as per request in existing applications int

.New functionality were to delivered using Classic ASP, VB Script, JavaScripT, ADO,

SQL/Oracle.

.Integrating the front-end designs with back-end database in SQL Server and Oracle and

doing maintenance tasks

.Configuring IIS to manage error pages

.Using Active Directory for extracting enterprise level user data and handling

security

.Use of AJAX (xmlhttp) to manage Asynchronous postings

.Use of jQuery to enrich user experience with UI

.Use of Silverlight in designing interactive UI.

.Use of Web Services in modules to make the modules open for consumption on different

platforms

.Extensive use of CDO (Mail) components to shoot email automatically, depending on

program logic and requirements.

.Developed Stored Procedures to use on MS SQL Server 2008

.Providing concise technical solutions to the team where required.

. Requirement analysis from cross cutting teams

Environment:, ASP, VB, VB Script, JavaScript, JQuery, SQL Server, Oracle Server, ADO,

ADO.NET, CDO, Spry, CSS, HTML/XHTML, Silverlight.

Zenether Technologies, Nepal

May 2010 - Nov 2010

Worked for Zenether Technologies to develop softwares for clients.

Some of the works included:

Design and development of a web based application for a shipping company (Pole to Pole

Shipping Services, Mumbai, India). The project included mapping, distance calculation

through Google maps (scripts), freight calculation, route suggestions, online payment

through major gateways, etc. The application was built with ASP.NET, C#, WPF,

Silverlight, Expression Blend, Expression Web, WCF, Web Services, AJAX, JavaScript and

database as SQL Server.

Designed and developed whole or modules of different websites/web applications. Some

were brand new websites, while some were customized using WordPress, Mojo Portal, and

other CMS systems.

Environment: ASP.NET, C#, WPF, Silverlight, Expression Blend, Expression Web, WCF, Web

Services, AJAX, JavaScript and database as SQL Server; WordPress, Mojo Portal, and

other CMS systems.

International IDEA, Nepal

July 2008 - April 2010

International IDEA is an intergovernmental organization working in the field of

democracy and electoral systems. It works all over the world, with its headquarter in

Stockholm, Sweden. Currently it has 25 member states.

My responsibilities were to create, update, and maintain pages for the organization's

web site (Nepal); assist in designing site pages, layout and design of promotional

materials, including publications; develop internal knowledge database (MsAccess) for

easy access and retrieval; provide technical support for hardware problems, networking

(LAN) and critical site problems and troubleshooting, as needed; collection of

information and documentation of election related developments in Nepal.

Environment: ASP.NET, C#, Silverlight, WPF, ADO.NET, SQL Server, AJAX, CSS, HTML,

JavaScript and XML/XSL, Adobe Indesign, Photoshop, Flash

United Nations Development Programme (UNDP), Kathmandu, Nepal

March 2008 - Oct 2007

Contractor/Project Assistant

UNDP operates in Nepal to promote development in Nepal. It works with various

stakeholders, including Government of Nepal.

I worked as a contractor for one of their projects related to conducting Constituent

Assembly election. My duties were to oversee, maintain and use their software for

creating records of all of the International observers. The software was made in

MsAccess.

BirlaSoft, Noida, India

Oct 06 - Aug 07

Done number of projects for the company, including an onsite task as listed below:

Leave Management System (Internal Application)

The scope of the project was to develop an application that could be used by project

managers to manage leaves of team members. The same software should also be able to

provide summary of leaves in a particular project, or in the whole organization,

categorized by projects, etc.

Responsibilities:

Requirement Analysis from Human Resource Department

Developed a code to Convert Data from MsExcel Sheets to MsAccess tables based on

format

Design of UI using HTML, ASP.NET (.aspx), CSS, Themes and skins

Extensive use of data binding WebControls

Writing queries in MsAccess

Building data reports through queries based on user privileges on SQL Server through

SQL Server Reporting Services (SSRS)

Implementing the application on the organization's intranet using IIS

Giving training to the possible users of the application

Environment: ASP.NET, C#, JavaScript, CSS, IIS, MsAccess, MsExcel

Migration of Website from Classic ASP to ASP.NET and adding Accessibility features

(Client: Royal Bank of Scotland)

The Royal Bank of Scotland (RBS) Group is a Global financial services player with its

operations throughout the world. It operates a wide variety of banking brands offering

personal and business banking, private banking, insurance and corporate finance

throughout its operations located in Europe, North America and Asia.

The RBS maintains a corporate umbrella website through which users can either select

the services they would like to receive, or go to other websites of its subsidiaries.

The scope of the project was to re-write the website written in Classic ASP to

ASP.NET/C#.

Responsibilities:

. Study and analysis of the business layer (/logic) of the previous application which

was written as COM dlls.

. Developed new libraries and components in C#, LINQ for Business Rules/Business

Process based on the functionality provided by the earlier COM objects.

. Writing the HTML within the specifications of W3C's WCAG I & II accessibility

options.

. Writing the XHTML to comply with XHTML 1.0 Transitional requirement.

. Using ADO.NET for creation of Data Access Layer

. Creating complex database queries, stored procedures and functions for MS SQL Server

2005.

. Designing UI with JavaScripts and jQuery for enhancing end-user experience.

. Coordinating with onshore development team, and guiding the offshore development to

meet those requirements

. Facilitating meetings between offshore and onshore teams; and within offshore team

members

. providing concise technical facilitation during design and development phase to the

team

. Reviewing work of the development team, doing code reviews, communicating and

enforcing coding standards by mentoring junior level developers

. The Version Control was done through Visual Source Safe (VSS).

Environment: Classic ASP(3.0), ASP.NET, C#, VB, JavaScript, VBScript, AJAX, XHTML

1.0(T), W3C WCAG-I&II, VSS, SQL Server 2005.

Migration of Website from Classic ASP to ASP.Net (Client: Monster.co.uk)

Monster is the leading provider of online careers and recruitment resources committed

to connecting organisations with individuals. Monster provides platform for both

individuals thinking about a new job, new career, or a new direction; as well as for

employers looking to recruit the most qualified candidates.

The scope of the project was conversion of web application of Monster.co.uk from

Classic ASP to ASP.NET/C#. Our team had access to the site's ASP pages and SQL

Databases and its structures, but had no access to the source code of the COM

components.

Responsibilities:

. Overall study and analysis of the existing application

. Making the Use-Case diagram of the requirement and identifying functions and

modules.

. Study and analysis of the business layer (/logic) of the existing application which

was written as

COM dlls.

. Study of the structure and relationship of the existing database including tables,

stored procedures, functions.

. Extraction of HTML part of the ASP pages to .aspx pages.

. Writing the XHTML to comply with XHTML 1.0 Transitional requirement.

. Used ASP.Net Validation and Custom Controls for validating the data on the client

side.

. Developed new libraries and components in C#, LINQ for Business Rules/Business

Process based on the functionality provided by the earlier COM objects.

. Calling SQL commands from the .net application by use of stored procedures and

parameters

. Improving the Security, Performance and deployment of Web Services that were

developed.

. Developed modules to dynamically consume XML Web Services.

. The Version Control was done through Visual Source Safe (VSS).

Environment: Classic ASP(3.0), ASP.NET, C#, VB, JavaScript, VBScript, AJAX, XHTML

1.0(T), W3C WCAG-I&II, VSS, SQL Server

Windows Application (Onsite client: American Express/Noida, India

Worked onsite on American Express location in Noida, India. American Express calls

itself an engine of commerce that provides innovative payment, travel and expense

management solutions for individuals and businesses of all sizes.

Our project's objective was to create an application to capture the data from its

mainframe, store it into our local system, and then use the data for various

analytical purposes. All this had to be done without having to have a direct access to

the mainframe database. However we had access to a third party front-end application

(.exe) that could pull the data from the mainframe.

Responsibilities:

. Writing complex queries to pull data from multiple tables, based on the requirements

for the analytical tool that we were making.

. Writing an application in VB6 to interface with a third party software that could

convert data written on screen (by any software) to text.

. Filtering (through string operations) the data of your use and extracting it from

the chunk of text files.

. Database structure design in Linked-MsAccess database.

. Writing queries to store extracted data by our software into tables.

. Writing modules to consume the data for various financial analysis.

. Using Crystal Reports and queries, prepared various reports.

. Making the project documentation for this application.

. Preparing documents for filing patents of AMEX's proprietary products.

Environment: VB 6.0, MsAccess, Query Builder, Screen Capture s/w, Mainframe, MsExcel

Professional Computer System, Kathmadu, Nepal

Feb 04 to Apr 04

Client: Ministry of Education and Sports, Nepal

Software Engineer

The Ministry of Education and Sports is the apex body of all educational organizations

is responsible for overall development of education in Nepal. It is responsible for

formulating educational policies and plans and managing and implementing them across

the country through the institutions under it.

Responsibilities:

. Carrying out the requirement analysis for design and development of its web

application

. Building the website using Classic ASP(3.0), HTML.

. Layout and design of website using CSS

. Enhancements in the form of visual effects (Flash Animations, PhotoShop).

. Use of JavaScript for form validations, etc.

. Coordinating with the Ministry's designated focal person on design and requirements

on regular basis.

. Implemented and configured the application on the IIS server of the web host.

Environment: ASP 3.0, VB Script/JavaScript, CSS on IIS using Microsoft Access as

database.

Professional Computer System, Kathmadu, Nepal

Nov 03 to Feb 04

Client: Everest Information Technology, USA

Everest Information Technology was a software development company based in the USA. It

had developed a software called the QuoteMachine that could give the real-time tick of

10 different stock exchanges in the USA, and at the same time, allowing its clients to

trade.

Our project was to build a website for the product to explain about the software, its

promotion and selling the software online.

Responsibilities:

. Designing the UI using HTML, JavaScript, VB Script and CSS.

. Writing application pages in ASP using VB

. Designing Shopping Cart for the software using JavaScript

. Checking to see if the site worked on multiple web-browsers and making changes

to/adding codes to achieve this.

. Integrating the custom shopping cart with Payment Gateway (Verisign)

. Designing databases in MsAccess to store user details including the services

selected, payment details, etc.

. Designing graphical images using PhotoShop

. Designing a tutorial for the QuoteMachine software using Flash and Screen capture

software.

Environment: ASP 3.0, VB Script/JavaScript, CSS on IIS using Microsoft Access;

Photoshop, Verisign Gateway Integration

Contact this candidate