Sql Server Project Management .Net Developer Service

Amita Vishwakarma

*****.***********@*****.*** / Cell : 932**-*****

PROFILE

- 9 years in the Information Technology industry executing full SDLC for

engagements on Microsoft Platforms and demonstrating my in depth

knowledge of the Service Oriented Architecture (SOA).

- Worked on OSISoft PI Database administration along with PI

API/interface programming.

- I am deeply involved in gathering requirements, designing complex

modules & frameworks, coding core functionalities, testing and

maintaining large and complex projects

- I have deep understanding of energy & utility sector, telecom and

microfinance domain (FSS)

- Executed software projects for Energy & Utility, Telecommunication,

Banking & finance functional domain. Involved in Designing,

architecting and developing .NET base Software Solutions for web and

client server applications for world leading Energy & Utility,

Telecommunication giants & Banking sector domain.

- Understanding of contemporary Internet architectures and offerings

with the ability to integrate these into effective solutions for an e-

Business.

- Have a broad and diverse understanding of Design Patterns and

application frameworks.

- Experience in leading and managing the teams. Handled multiple roles -

Project Lead, System analyst,Technical Lead, Software Developer and

System Analyst. Mentor and coach staff to maximize performance

CERTIFICATIONS

- Microsoft Certified in Designing and implementing Database with

Microsoft SQL server 2000 Enterprise edition

PROFESSIONAL EXPERIENCE

- Hands on experience in leading team and project estimations.

- Hands on experience in diversified fields of application software

architecture, development and testing in Client/Server Environments

and Web applications including Products and Service Oriented

Applications by executing full SDLC

- Expert in developing web applications using C#.Net, VB.NET, ASP.NET,

AJAX, ADO.NET, Web services, XML, JavaScript, JQuery and Extensively

used core .NET technologies like Web Services, ADO.NET, Web Custom

Controls, User Controls, Web Controls, Class Libraries, WinForms and

WebForms

- Extensively worked on JavaScript, XML and AJAX Developed complex

distributed applications using .NET and extensive database programming

using T-SQL and PL/SQL.

- Experience in MS-SQL Server Integration Services and writing complex

stored procedures, functions, Triggers, UDF's, T-SQL queries using

SQL server 2000/2005/2008 and a hands on experience in IBM DB2

- Experience in programming database applications, extensively used

connection objects like SqlConnection and OledbConnection, besides

ADO.NET features like DataReader, Transaction, DataCommand,

DataReader, DataSet, DataAdapter, with OLEDB providers.

IT - Experience

- PSEG Newark NJ, USA - Deputation from IBM India from Feb 2011- Sep

2013

- IBM India Limited, Pune Aug' 2006 - Till date as Associate Project

Manager

- Vinznet Technologies, Pune June' 2004 - June' 2006 as Software

developer

KEY SKILLS

SOA Implementing SOA using web services

Designing Design Patterns, UML 2.0, Microsoft Office Visio

Project Management Project Estimation and planning using Microsoft Office

Project

Technologies OSISoft PI Database, MS .net 2.0,3.5, 4.0 LINQ,

ADO.net,VB 6.0, XML

Web Technologies Asp.net, MVC, Java Script, VB Script, HTML, XHTML,

DHTML, CSS, XSLT, AJAX, JQuery

Other MS VSS, MS VS Team Foundation Server

Tools/Technologies

PROFESSIONAL INDUSTRY EXPERIENCE/PROJECTS

### COMPANY : IBM Global Services, Pune - August 2006- till date

Position: Tech Lead, Microsoft.net

#1. Project Name: Broker Fee Automation & Reconciliation(02/2011-09/2013)

Client: ERT/PSEG US

Team Size: 30

Technology Used: OSISoft PI, PI Interfaces, OPC, icrosoft Entity Framework, ASP.NET Framework, C#.Net SAP Business Objects (BO XI), Oracle PL/SQL,Microsoft Entity Framework, ASP.NET Framework, C#.Net, Devart Ora

Developer Tool, Aligne TRM.

.

Description:

Public Service Enterprise Group (PSEG) is a publicly traded (NYSE:PEG)

diversified energy company headquartered in New Jersey, and one of the ten

largest electric companies in the U.S.PSEG Energy Resources & Trade manages

PSEG Power's generation portfolio and basic gas supply service, the

purchase of fuel, and buys and sells electric and gas commodity. Public

Service Enterprise Group (PSEG) is a publicly traded (NYSE:PEG) diversified

energy company headquartered in New Jersey, and one of the ten largest

electric companies in the U.S.PSEG Energy Resources & Trade manages PSEG

Power's generation portfolio and basic gas supply service, the purchase of

fuel, and buys and sells electric and gas commodity.

This system provides the details of all the commodities traded by the firm

including the trade price, the flow period until which the commodity remain

unrealized/open for trading and the fees/ commission charged on each by the

exchange and broker.The positions is identified as a realized/unralized

position based on different set of rules for future/option products.PSEG

ER&T needs to pay/recieve a margin to/from each counterparty each day.

The margin is based on the deals done with them,the positions realized and

unrealized daily.This system calculates the margin using CME-SPAN as an

interface which provides the risk analysis of each product/commodity.

Module Name: PJM Bill Compiler:

This system compiles data from different sources and creates bill for PJM

ISO by doing different calculations. Implemented MVC architecture in Web

Applications. Designed and developed UI using ASP. NET/MVC, CSS. Developed

Data Access Layer Using Entity Framework.

Module Name: Data Integrator application:

Data Integrator application is the windows & console application which

downloads the data files (CSV, XML and XSL) from the ISO Website and

process the files and stores the data into Database (SQL Server and

Oracle). WPF was used to create UI for this system and some of the modules

used large number of data so we used Informatica for data transformations.

I was involved in creating UI, business classes, new mappings for data

transformations and modifications of existing mapping. Informatica was

hosted in UNIX server and I have experience in UNIX scripts to maintain

this server. I was involved in parallel upgrade of Informatica 8.5.1 to

9.1.

Module Name: Over the Limit:

Over the Limit application is a console/windows applications which

automatically checks the traders who are going beyond their trading limit.

WPF was used to create UI for this and it was a configurable application to

add users or emails recipients whenever required. One module consumed

Market View web service to get daily data for different energy markets.

Module Name: PI (Plant Information) System:

PI system is used to collect real time data from different sources. Project

has interfaces which connect to different sources and created tags which

stores real time information in it. The tags are used to display real-time

and/or historical plant data in PI-Process Book by creating process

graphics, trends, statistical plots and tables.

My Roles:

- Business analyst, System consultant, Technical Lead at onsite client

location.

- Lead and delicate work to team at onsite and offshore.

- Architected and designed components and sub components of the Project.

- Closely worked with clients to understand the Requirements and

developed the Use cases for the new release and advised them the

technical feasibility of the same

- Translated the requirements to LLD and worked with team to have build

deliverable with highest quality by aligning the development with the

QA

- Deeply involved in the technical discussions with the PSEG USA and the

External Consultants to provide techno functional solutions to the

challenges faced

- Prepared Test Strategy for functional and integration testing

#2. Project Name: Vodafone Money Transfer(05/2009-06/2010)

Client: Vodafone, UK

Team Size: 150

Technology Used: ASP.net, .net C# 3.5,MS SQL 2008, XML, HTML,CSS, UML,CSS,

AJAX, JavaScript

PROJECT DETAILS

Vodafone Money Transfer (M-PESA) is the product name of a mobile-phone

based money transfer service which is developed by IBM for Vodafone. The

concept is to create a service which allows microfinance borrowers to

conveniently receive and repay money using the network of a service

provider, say an airtime reseller. The users of the service would gain

through being able to track their finances more easily, sending remittances

home across the country and making payments. The success of M-PESA is due

to the creation of a highly popular, affordable payment service with only

limited involvement of a bank. The technology platform for the service is

provided by Microsoft and was highlighted as a key philanthropic initiative

from Vodafone by Melinda Gates of the Bill & Melinda Gates Foundation at

DAVOS in 2009.

My Roles:

- Acting as a Design lead I architected and designed components and sub

components of the Accounting Processor Engine which is the core

financial transaction framework of the Vodafone Money Transfer.

- Closely worked with clients to understand the Requirements and

developed the Use cases for the new release and advised them the

technical feasibility of the same

- Translated the requirements to LLD and worked with team to have build

deliverable with highest quality by aligning the development with the

QA

- Deeply involved in the technical discussions with the IBM UK, the

Architects and the External Consultants to provide techno functional

solutions to the challenges faced

- Anchored 4 out of 5 sub modules of the Accounting Processor Engine

individually

- Prepared Test Strategy for functional and integration testing

#3. Project Name: Smart Select (08/2008 - 04/2009)

Client: American Express, USA

Team Size: 550

Technology Used: ASP.net, VB.Net 2.0, IBM DB2, XML, HTML,CSS, AJAX,

JavaScript, SVN, Web Services, ADO.Net, IIIS 6.0

PROJECT DETAILS

AMERICAN EXPRESS is one of the largest banks in US that have Business

interest all over the world. AMERICAN EXPRESS uses Smart Select for

executing Card member campaigning. The SMART SELECT user can create and

ship campaigns using information that is stored separately and securely for

all American Express Card members. The user sets up and creates lists of

U.S. Card members based on specific query criteria selected, including data

on how, when and where they spend. The objective of SMART SELECT is to

provide a web application through which the user can easily carry out this

activity.

As a Senior Application Programmer responsible for

- Development

- Knowledge Transition.

- Fixing bugs.

- Coding in ASP.net, C#.

- Code Review.

- Integration and delivery to client.

- Unit Testing

#4. Project Name: TRAMS (12/2006 - 1/2008)

CLIENT - SPRINT, USA

TEAM SIZE - 35

TECHNOLOGY USED - Microsoft.NET, ASP.net, C#.net, ADO.net, HTML, IIS 6.0,

MS-SQL Server 2000, Windows 2003 Server

PROJECT DETAILS

SPRINT is the 3rd largest telecom company in US that has business interest

all over the world. The technical failures in the telecom network are

reported online as tickets. The SPRINT personnel or "technicians", as they

are commonly called, then address these tickets and take it up for

resolution. During its life cycle from generation till resolution, a ticket

typically goes through various stages. Each stage decides the kind of

attention required for it. These are recorded in a mainframe based system

called TRS. Earlier user used to open the TRS system to determine the

status of a ticket and accordingly took the necessary action. The objective

of TRAMS is to provide a web application through which the user can easily

carry out this activity.

As a Developer, is responsible for

- Knowledge Transition.

- Fixing bugs.

- Coding in ASP.net, C#.

- Code Review.

- Integration and delivery to client.

- Unit Testing

### COMPANY : Vinznet Technologies, Pune

# 1. Flex Cost Monitoring System (1/2006 - 07/2006)

CLIENT - Organon

TEAM SIZE - 5

TECHNOLOGY USED - Microsoft.NET, ASP.net, C#.net, ADO.net, HTML, IIS 6.0,

MS-SQL Server 2000, Windows 2003 Server

PROJECT DETAILS

Organon Flex Cost Monitoring System is a web based multi-tiered application

where the Presentation tier constitutes of displaying user interface views

to the end-user through a browser. The business/middle tier handles

requests from multiple clients at any instance and the database tier would

provide support for integrating Flex Cost Monitoring application to the MS

SQL Server.

It's a budgetary system having different Modules: Product manager,

Financial controller, Purchase manager, & Administration,

As a Developer, is responsible for

- Understanding of the Requirement Specifications.

- Prototyping using HTML.

- Coding and peers code reviews

- Manual Testing & apply validations

# 2. Project Management System (8/2005 - 12/2005)

CLIENT - Coast Solution Group-US

TEAM SIZE - 2

TECHNOLOGY USED - Microsoft.NET, ASP.net, C#.net, ADO.net, HTML, IIS 6.0,

MS-SQL Server 2000, Windows 2003 Server

PROJECT DETAILS

Project Management is a web based multi-tiered Project Management tool to

manage the project, time and task allocated to the different developers.

This tool is used to clock the hours against the project allocated. This

tools also allows management to create new roles (Managers, Software

Architect, Engagement managers) and assign particular project to them, then

they keep track of project till its completion.

As a Developer, is responsible for

- Understanding of the Requirement Specifications.

- Assist in Database designing

- Coding and peers code review for Presentation Tier

- Manual/Unit Testing

# 3. Inventory Management (4/2005 - 8/2005)

CLIENT - PN Gadgil, Pune

TEAM SIZE - 2

TECHNOLOGY USED - Microsoft.NET, ASP.net, C#.net, ADO.net, HTML, IIS 6.0,

MS-SQL Server 2000, Windows 2003 Server

PROJECT DETAILS

Inventory Management system is an intranet web based application

specifically designed for Inventory, Invoice and Billing purpose. I worked

on Administration module which includes various forms like Product Group,

Product, Material Price, Order Received, Orders Confirmed, Order Delivered

& Gift Vouchers.

As a Developer, is responsible for

- Understanding of the Requirement Specifications.

- Coding and peers code review for Presentation Tier

- Prototyping using HTML.

# 4. ContractorLive (12/2004 - 4/2005)

TEAM SIZE - 4

TECHNOLOGY USED - Microsoft.NET, ASP.net, C#.net, ADO.net, HTML, IIS 6.0,

MS-SQL Server 2000, Windows 2003 Server

PROJECT DETAILS

ContractorLive a web based application specifically designed for small to

medium sized builders who want to communicate more effectively with

clients, employees and subs-contractors and a central place to share

information about bids, jobs, plans, schedules & payments..

As a Developer, is responsible for

- Understanding of the Requirement Specifications.

- Coding in Presentation Tier

- Static Page designing

# 5. Shopping Cart System (8/2004 - 12/2004)

CLIENT - Website for UK Client

TEAM SIZE - 2

TECHNOLOGY USED - Microsoft.NET, ASP.net, C#.net, ADO.net, HTML, IIS 6.0,

MS-SQL Server 2000, Windows 2003 Server

PROJECT DETAILS

This web site is e-commerce site developed for the online purchase

Cosmetics and Fashionable products.

Industrial Training:

1. Online Examination (Seed Infotech)

Technology Used - VB, Oracle

Role: Programmer

2. Vocational Training in BHEL, Bhopal

Section Covered:

Switch gear, Control gear and Rectifier

Industrial Medium machine

3. Vocational Training in BHEL, Bhopal

Section Covered:

Traction Motors

Transformer

QUALIFICATIONS

June 2003: Bachelor of Engineering in Electrical Engineering Rajeev Gandhi

Technical University, India

Contact this candidate