Project Developer .Net Sql Server Business Data

Professional Experience

*. Designed and Implemented variety of web applications in

2. Created Uml-diagrams

3. created database chemas

4. databsase tuning

5. bulilt webpages

6. used .net visual studio for web,mobile apps

7. experaince with different databases

8. expericance with different frame works

9. .net webservices

10. sql databases and reporting services.

Work Experience

Real Estate Educate

Jun '08 - Till date

Sr. Application Developer

[pic]

Project: Reporting on Real-Estate Agents Network

Description: This Module provides reports for financial institution on real-

estate agents across the country. This module matches agents in client's

network to that of system users based on matching algorithm and provides

different kinds of reports on matched agents to clients.

Responsibilities:

> Gathered requirements from Sales & Business Departments.

> Developed project-plan with phases and time-lines.

> Designed algorithm to match agents.

> Designed and developed Reporting objects using object oriented PHP.

> Implemented multiple Design Patterns using object-oriented design

principles in PHP

> Designed and Developed Database tables in MySql.

> Built complex stored-procedures using MySql.

> Used Database tuning and created Indexes to increase efficiency of MySql

Queries.

> Documented system architecture using UML tools.

> Built unit test cases for matching & reporting objects.

>

> Proposed alternate models for storing matched data.

> Developed web pages for importing and exporting data.

>

Achievements:

> Successfully implemented MVC pattern in PHP

> Implemented Objected-oriented Design Principles and excellent

coding practices.

> Achieved high efficiency and accuracy of reports.

> Implemented PDO with Apache.

> Introduced new open-source data-grid for displaying reports

Project: Advertisements

Description: This project gives ability to affiliates to create, modify,

purchase, renew, and track multiple ads online. Allows administrators

manage advertisement settings and report on impressions and clicks.

Responsibilities:

> Organized Requirement gathering process & finalized requirements.

> Designed & developed

. Database schema

. Advertisement Business objects

. Purchase objects

. Tracking objects

in LAMP environment

> Implemented shopping cart for purchasing ads.

> Designed work-flow for Advertisements processing and publishing.

> Designed Admin web-pages that can create and modify Advertisement

features dynamically.

> Built Virtual terminal, to mimic user action for support team.

> Built reports screens to monitor clicks and Impressions.

>

Achievements:

> Developed a generic purchase object, which can deal with any kind of

purchases & payment vendors.

> Introduced stored-procedures and user-defined functions in MySql.

> Dynamic settings for advertisements.

Project: LMS (Learning Management System)

Description: This project allows agents/users to buy online courses, take

interactive flash courses and get certificates for the courses online.

Gives administrators, access to create courses, and manage courses, their

quizzes, users, their certificates etc. all online

Responsibilities:

> Extensively worked on Enhancements and Maintenance for user module.

> Implemented Virtual terminal for customer support.

> Extensively used Quick-base API's for data importing.

> Implemented System Actions for maintenance and emails.

> Developed Roles module.

> Developed various reports on users, courses, payments.

> Implemented SSL.

> Implemented Dynamic fields for registration.

> Developed Central logging class

> System Migration from Windows to LAMP

> Upgrading from MySql, LAMP and Centos.

> Improved website security by securing user files, secure cookies,

avoiding Sql injections etc.

Achievements:

> Introduced Object oriented PHP programming, MVC Design Pattern.

> Easily got adapted to completely new language, framework and environment

and leaded the project.

> Introduced new features and tools for MySql and PHP.

Environment:

LAMP, Centos 4.0, apache, MYSQL 5.1, PHP 5, HTML,DHTML,XML, CSS,

JavaScript, Ajax, jquery, PDO, Star-UML, Microsoft Visio, SQLyog, NuSphere.

Project: Mark 2 Market

M2M is online portal which is used for mortgage evaluation.M2M has a list

of clients and vendors all over the country, Clients send requests for

property evaluations and M2M assigns these requests as orders to vendors in

that area. The M2M involves in processing clients requests, reviewing the

evaluations and billing clients and vendors, etc.

All these transactions are automated, also involve with data transfer

between M2M and Wells Fargo.

Responsibilities:

> Developed core Business objects which are used across the system.

> Published web-services which processed orders and transported to clients.

> Develop reports in HTML using CSS and using SQL Server Reporting

Services.

> Generated PDF documents for processed orders.

> Used windows services to perform different actions in the workflow.

> Developed stored procedure, triggers and user-function to do core

business logic.

> Extensively used custom and user controls.

> Develop support Scripts

Wells Fargo: Mortgage

Description: Wells Fargo has 4 inter-related web applications to manage

their REO's. Each system does specific processing and forwards the REOs to

other systems to complete the rest of the process until each REO is sold.

Responsibilities

> Tier 2 Support for all the systems, which involves: Gathering Issue from

the client, track, analyze, report and recommend possible solution to the

issue.

> Coordinate issues with client and development team.

> Write scripts to provide solve bugs and provide temporary solutions as an

alternative to development.

> Organize deployments with international teams.

> Documented system design and architecture.

> Develop unit test cases.

> Help and educate end users about the system usage.

Environment: C#, ASP.NET 2.0, IIS, SQL 2005, SSIS,SSRS, Web Services, XML,

XSLT, HTML, CSS, JavaScript, Flash, SVN

Cardinal Health, Dublin, OH

Jan '08 - May 08

Project: ParMed Web Ordering

.Net Developer (Consultant)

[pic]

ParMed is small pharmaceutical company in Niagara which is recently

acquired by cardinal Health. In order to expand ParMed's Business Cardinal

took up this project to make the ordering system online.

Description: ParMed Web ordering system enables its customers to order the

drugs online. It provides features like Accounts, Product search, Order

history, Special offers, Payment Terms etc. This project has multiple

databases which are well synchronized using DTS packages, SQL server Jobs,

Web Services and message broker services. Web Pages are developed to track

and maintain the databases and the transactions between them.

Responsibilities:

> Extensively involved in developing detail design documents for Tables,

Stored procedures, SQL jobs and Asp.Net User Interfaces.

> Designed and developed the Web forms for customer sales representatives

using ASP.Net for Tracking, updating and deleting data.

> Implemented Master pages for easy Navigation.

> Used Ajax and JavaScript to increase Performance of the web pages.

> Used Dataset, Data Adapter, Data Reader and other ADO.NET connectivity

objects.

> Coded the Tracking entity base class (component) using C# language.

> Analyzed business logic written in C# to implement them in the stored

procedures in the transformation layer and other layers

> Used XML and web services to feed data to Message Broker.

> Used Web service to get the data from Legacy systems for tracking.

> Developed and used XML Schemas and XML transformations ie XSLT

> Developed the necessary stored procedures and created complex views using

joins for robust and fast retrieval of data.

> Used SQL 2005 Hashing techniques to detect changes in data

> Used DTS services to automate ETL.

Environment: Visual Studio 2005, ASP.Net 2.0, C#, SOAP, XML, AJAX,

JavaScript, ADO.Net, MS SQL Server 2000/2005, IIS, Microsoft VSS and

Windows 2005,Crystal Reports.

Alton Steels, Alton, IL

Aug 07- Jan 08

Developer

[pic]

Alton steel is a fast growing steel manufacturing company dedicated to

deliver quality steel at low costs. IT department in Alton steel is trying

to develop different windows, web and, mobile applications using .NET in

order to help manufacturing, production, shipping and Marketing

Departments. These applications make efficient use of existing resources,

automate inventory management, shipping system to avoid human errors and

fast processing.

Description: We developed web portal to assist Marketing department. It is

used to create orders, give quotes, produce invoices and track inventory. I

was involved in developing web portal that gives quotes to the vendors

depending upon different credentials, also, involved in developing a web

portal to generate invoices. We also developed mobile applications to scan

barcodes and maintain inventory.

Responsibilities:

> Participated in collating requirements, designing and prototyping the

initial designs.

> Designed and implemented a 3-Tier Application including the Presentation,

Business and Data Access Layer

> The Presentation Layer is implemented in ASP.Net with HTML, Cascading

Style Sheets and Web Controls. The Web Forms are developed utilizing the

C#.

> Implemented the Business Layer for the application using C#

> Developed and used data layer class extensively for database related

operations.

> Data Access Layer for the Application is implemented in ADO.NET for data

input, query, retrieve and management. SQL Server 2005 is utilized as the

data repository.

> Extensively used Ajax Controls to reduce the client server turnaround

time, hence enhancing the performance of the application.

> Created XML and XSL documents

> Implemented Web Services using WSDL and SOAP.

> Stored Procedures and triggers for the data access are implemented in SQL

Scripts and tested SQL Server 2005.

> Designed and created Tables and views in SQL.

> Created various reports using Crystal Reports.

> Used .Net Compact Framework to develop applications on Mobile Devices

like LXE and Symbol.

> Version control for the source code and scripts are managed using Ms

Visual Source Safe.

> Documentation of the Application in accordance to company and client

specification is developed

Environment: Visual Studio 2005 IDE, ASP.Net 2.0, C#, XML,XSLT, AJAX,

JavaScript, ADO.Net, MS SQL Server 2000, IIS, Microsoft VSS and Windows

2003/2005,Crystal Reports.

Virtusa, Hyderabad, India

April 05 - Nov'05

Role: Programmer

[pic]

Project: GUS (General Ledger Utility System)

Description: General Ledger Utility System (GUS) is an in-house developed

Retail Accounting system of ICICI Bank that is used to automate the

reconciling and balancing process of the branch lines. It is an intranet

system which is used by the Bank employees.

Responsibilities:

> Implemented Authentication and Authorization using Microsoft

Authentication.

> Created dynamic GUIs with ASP.Net Web Controls and implemented JavaScript

in web user controls.

> Used ADO.Net Object Model to Database connectivity.

> Implemented data access logic through in-house XML Web Services using C#,

ASP.NET and ADO.NET.

> Extensively used Data Grid controls for various purposes.

> Developed in-house web services.

MASTERS COURSE PROJECTS:

> Implemented Algorithms for Genome sorting, reversals, Motif finding and

Sequence alignment using branch and bound algorithms and dynamic

programming.

> Implemented stable matching problem, Merge sort using doubly linked List,

sequence alignment problems with high accuracy, efficiency and durability

for extremely large data sets

> Designed an ER diagram for an online shipping company, created a database

and implemented all types of queries (Select, Parameter Cross tab, and

Action queries)

> Developed complex programs for finding machine epsilon, ?, ? values and

printing it to at least 16 correct significant digits

> Programs for interval computation method for Newton and iterative

algorithms

> Interval computation for trapezium and Simpsons method of finding

Integrals of functions

Projects in Network Security

> Securing Ad Hoc networks(group project)

> I built ad-hoc network, created traffic, sniffed data.

> I presented a secure routing protocol.

> Attack on HTTP server using ethereal tool

> Security in wireless networks(group project)

> I established a secure wireless network with WEP and cracked WEP key.

> Established WAP secured network, performed Mac Filtering at the source

router.

> Finding WEBGOAT vulnerabilities and attacking it.

> Implementation of FTP Server and Client using VC++.

Contact this candidate