Post Job Free

Resume

Sign in

.Net Sql Server Management Project Data Sales

Location:
Albany, NY, 12204
Posted:
June 27, 2011

Contact this candidate

Resume:

Summary:

. Over * plus years of professional experience in information

technology including 7 years extensively in ASP.NET, VB.NET,

ADO.NET, C#, Threading, Crystal Reports, and 5 years in Web

Services, and COM.

. Extensive experience in designing, development, coding,

debugging, testing, implementation and maintenance of multi-

tier web and client-server applications.

. Expertise in VBA, ASP, Visual Basic, HTML, XSL, XML, VBScript,

JavaScript, AJAX, MS SQL Reporting Services 2008, SharePoint

services and Design 2007, SQL Server Integration Services

(SSIS) 2008, ViewPoint - 6.3.1.

. Strong experience of .NET Framework 3.0/3.5/4.0 application

development including front end designing in Microsoft

Expression Blend and backend programming in Microsoft Visual

Studio 2005, 2008, 2010 utilizing WCF, WF and WPF/XAML, MVVM.

. Strong command and experience in database applications design

and implementation with SQL Server 7/2000/ 2005 (T-SQL,

Stored procedures, DTS packages), Oracle 8i and MS Access.

Experience in maintaining and designing database diagrams,

setting table relationships and indexes.

. Designed and developed Win Forms and Web Forms.

. Experience in the development of database applications using

DAO, RDO, ADO and ADO.NET.

. Strong command in design and development of client-server

applications using Object Oriented Methodologies.

. Experience in developing applications using COM with VB, MTS and

IIS.

. Hands on experience in Software Development Life Cycle and

writing use cases using MS Visio and Rational Software.

. Work experience with Health Care Management System, FACETS -

Data Model, Data Dictionary, Table Structure, Database Object

Naming Conventions, Database procedures, Database triggers,

Referential Integrity, Batch System Architecture.

. Experience in developing Cross Browser Compatibility Applications.

. Possess good communication skills, adept at learning new

technologies and ability to work under pressure individually and

/or in team.

Technical Skills:

Operating Systems: Win XP Professional, Win 2000, WIN 98/95 AND WIN

NT4.0

Languages: C, C++, C#, VB.NET, UML, SQL T-SQL, PL/SQL, SQL, AJAX and JAVA.

GUI: VB.Net 2010, VB 6.0 / 5.0, CRYSTAL REPORTS 10, MS SQL Reporting

services, SSIS.

Scripting tools: VB Script & Java Script.

Internet/Intranet: ASP.NET, ACTIVE X, Web services, .NET Remoting,

IIS5.0, MTS, HTML/DHTML, XML, COM+, DCOM, Visual Interdev, ADO,

ADO.NET, WPF/XAML, WF, WCF and Crystal Server Pages.

RDBMS: SQL Server 2000(T-SQL, Stored Proc, DTS), Server 7.0 / 6.x, MS

Access and Oracle.

Source Code Control: Visual Source Safe, Wincvs 2.0, Serena Dimensions,

Team Foundation Server 2010.

Education: M.S., Computer Science, Lehman College, City University of New

York, NY, 2004.

Certifications: Microsoft Certified Application Developer (MCAD) in .NET

o Designing and Implementing Web Applications with Visual C# .NET

and Visual Studio. NET.

o Developing XML WEB Services and Server Components with Microsoft

Visual C # and Microsoft .NET Framework

o Designing and Implementing Databases with Microsoft SQL Server

2000 Enterprise Edition.

Work Experience:

Unistress Corp, Pittsfield, MA

Sept 2010 - Present

Description:

Designing, Developing and Maintaining SharePoint Server Infrastructure.

Implemented Custom .NET Development - Web Parts, Application

Pages, Service Applications, Custom Actions, Site and List Definitions;

Master Page Customization and Design. Content Structure Design. Workflow

Design and Management. Utilizing MOSS, InfoPath Forms Services, SQL

Reporting Services and SSIS. Gathered requirements from various users on

projects, documented design work and provided multiple templates.

Implemented software development life cycle policies and procedures.

Responsibilities:

. Developed critical data management systems to construction logistics

utilizing SharePoint 2007 and other technologies to enhance the

functionalities. Incorporating advanced security technologies ensuring the

encryption mechanisms of the data and high availability in the event of a

regional disaster or a system failure.

. Support, configure, and maintain SharePoint 2007 farms for the company

website. Implemented customized project management system utilizing

SharePoint portal and integrating it with .NET applications, web services

and Microsoft Project Server 2003. Provide end-user support and training.

. SQL and SharePoint-based solution to synchronize the channel line ups for

each area served from the design, scheduling and staging in each location.

Data is organized and optimized to display Estimating and Design, Sales,

Bid Results for Projects etc., on the SharePoint website.?

. Created SSIS packages for data movement, database maintenance and

Vacation Tracking application.

. Developed full scale reporting solutions using SQL Server 2008 and SSRS

2008 which included the

design and development of a sales and estimating projects database.

Environment: Visual Studio 2008, C#, SQL Server Reporting Services (SSRS)

2008, SQL Server Integration Services (SSIS) 2008, SharePoint 2007,

InfoPath 2007, SQL Server 2008, Viewpoint - 6.3.1.

Capital District Physicians' Health Plan, Albany, NY

August 2008 - Dec 2009

Description:

As part of the BTI team which implemented a new core system, Facets, to

handle all claims processing, membership and eligibility, provider

management, billing, utilization management, and service functions.

Responsible for requirements analysis, technical architecture, design and

development.

Responsibilities:

. Done extensive analysis around FACETS Data Model to cater the

requirements for providers, Common practitioners, Practitioner, Providers

Groups, IPAs, Facilities and with provider's payment methods fee-for-

service, capitation or both and tax data with C# Developed /

modified packages to extract/upload in to the FACETS Oracle Database

Tables.

. Developed use cases, workflow, screen mock-ups, and conversion

requirements using SharePoint. Conducted risk engineering to derive and

execute action plans on time.

. Designed and developed web applications with ASP.NET, JavaScript and C#

for Provider and Group to ensure there is only one provider ID and Group

ID with different pricing, relationships, and remittance information per

location.

. Worked on the integration of the external services within the

Facets Health web for physicians and employers throughout U.S.

. Involved in designing and development of SOA services using Web Services/

WCF service for securely adding new practitioners to the health website.

. Configured single sign on solutions for Practitioners Management

information System.

. Developed several WPF-based components to verify valid values and

relationships for Facets database.

. Wrote Oracle Stored Procedure to extract Subscriber Family data and

Uploaded into various database tables of FACETS via MMS (Membership

Management Subsystem).

. AJAX sign-up / sign-in process related to edit Health Web profile pages.

. Initial registration of Facets members utilizing the Facets integrated

member functionality in Health Insurance Portability & Accountability Act

(HIPAA) and involved converting and migrating data from existing systems

and validating to ensure data integrity using CA Identity Manager.

Environment: Visual Studio 2008 Team System Suite ASP.NET 3.5, C#, ADO.Net,

JavaScript, AJAX, Oracle10g, WPF, WCF, Web services, Facets 4.51,

SharePoint 2007, Serena Dimensions.

Fannie Mae, Herndon, VA

October 2006 - July 2008

Project: Purchase Adjustments

Description: Purchase Adjustments web forms keep track of all the different

monitory / non-monitory changes for loan by Business Analysts/Lenders.

Project: Pool Level Adjustment Audit Trial

Description: Pool Level Adjustment Audit Trial identifies selected types of

pool level data adjustments specifically changes are made by the analysts

in ADM Investor Reporting (IR), Exception Transaction and Management (ETM)

and Securities Management Team (SMT).

Project: Pool PTR

Description: Pool PTR (Pass through rate) provides pool level data as per

pass through information. Pools that don't come under PTR will be treated

as Pools out of tolerance.

Project: Hard Rejects

Description: The number of hard rejected loans that are assigned /

processed by the analyst will be viewed by the analyst immediately after

logging into the application.

Project: ARMAT/WACWAM

Description: Maintains Exceptions tracking database for pool level data as

per weighted adjusted coupon and weighted adjusted maturity.

Responsibilities:

. Designed business requirements and validation documents for application.

. Developed Submitter, Approver and Keyed Information Entry web pages with

ASP.NET, JavaScript, and VB.NET to add a new request and to update data

elements related to approval team and to enter keyed data information.

. Developed, implemented, and maintained an asynchronous, AJAX based rich

client for Business Analysts/Lenders.

. Coordinating with 4 different teams performing tasks related to all

layers of application. Web UI, WCF Web Services and SQL Server 2005

database.

. Developed several WPF-based components for SMT, ETM and IR database.

. Created ASPX pages with server controls and in-built user validations

using ASP.NET.

. Upload multiple files using the html Input File control to load servicer

details.

. Developed functionality for Individual, Selective and Bulk updates for

approval and processed teams.

. Implement data conversion through XML and XSL. Loaded an XML file with

XML HTTP for first, second and third business day's servicer's data.

. Developed use case with UML for new product functionality. Worked with QA

team to design test plan and test cases for User Acceptance Testing (UAT).

. Coordinated work plans between project manager and client using MS

Project.

. Ensure unit testing of application development work is correctly

completed.

. Performed validations with asp.net checking for accuracy and correctness

of the entered data.

. Writing stored procedures, understanding capacity planning, user

management, storage management and data analysis in SQL Server 2005. Also

used XML and XSLT for GUI functions.

. Generated reports for Submitter, approver, keyed data details, Month End

and trending data using Crystal Reports.

Environment: Visual Studio. NET 2005, ASP.NET 2.0, VB.NET 3.0, AJAX,

JavaScript, Wincvs 2.0, CSS, XML, XSLT, WPF, WF, WCF, SQL Server 2005, MS

SQL Reporting services 2005.

Elephant Group, Plainfield, NJ

May 2006 - September 2006

Project: Order Processing Web Application.

Description: Designed and developed the large mission critical "Upload

Order Processing" web application. The objective of the complex n-tier

client/server web application is to create strategic alliances to increase

brand recognition and revenue utilizing marketing Performance Based

Marketing model. The application was designed using ASP.NET User Interface.

Web browser control is used to navigate through the web application from

ASP.NET forms. Generated web reports using crystal reports 10.

Responsibilities:

. Involved in Design of Upload specifications and preparing design

documentation with SDLC model.

. Created sophisticated SQL Server 2005 database to responsively handle

complex queries (T-SQL, stored procedures, functions, optimization) and

.NET data access components

. Implemented business logic as .NET framework assemblies' C#.

. Envisioned and built front-end for the site written in ASP.NET, Web

Forms, C#, HTML, Java Script.

. A web service was developed (on the sending and receiving end) to send

the updated XML dataset information from the Order Processing application

to the company's clearinghouse provider.

. Created parameterized Crystal Reports 10 and customized existing reports

for presentations using cross-tab reports, sub-reports, running totals,

sorting, alerting, and visual basic syntax to create formulas for the

reports.

. Implemented MS SQL Reporting services to provide critical reports for

senior management as well reporting to partners.

. Developed web reports using crystal reports 10 and published them using

crystal report viewer (ASP.NET, C#, HTML).

Environment: Visual Studio. NET 2005, C#, ASP.NET, Web Forms, VB.NET, Java

Script, Visual Source Safe and SQL Server 2005, Crystal Reports 10, MS SQL

Reporting services.

TD Waterhouse, NY, NY

Jan. 2006 - April 2006

Project: OATS- Order Audit Trail System

Description: OATS is an Order Audit Trail System creates quality custom-

tailored transactions to help optimize client capital structure. Rework TSE

job to speed up processing and separate OATS submission.

Responsibilities:

. Migrated OATS application from VB6 to VB.NET.

. Migrated MS Access OATS database to SQL Server 2000 using DTS package.

. Created tables and stored procedures to archive TSE Data using TSE

Prices, TSE Imports, Arc_TSE Prices and Arc_TSE Import tables.

. Used C#, Win Forms to archive data to Arc_TSE Prices and Arc_TSE Import

tables.

. Used UML Class Diagrams for business object and logical data models.

. Tested applications required for OATS system and Batch Test.

. Designed and developed WPF-based components for Order Audit Trail

System database.

. Designed and created reports with tables, graphs with data extracted from

the database using Ms SQL Reporting services for detailed analysis of OATS

resources.

. Involved in the document preparation for Application Center 2000.

Environment: Visual Studio. NET, VB.NET 3.0, C#, Win Forms, MS Access, SQL

Server 2000, Application Center 2000, Visual Source Safe, WPF, MS SQL

Reporting services.

Project: Security Management

Description: Involved in design and development of an intranet site using

Microsoft .NET framework for business analysts of the trading department.

This project was re-architectured and rebuilt using .Net framework that

includes exposing COM Components to the .NET framework, Web Services, and

ASP. Net, VB.Net, ADO.NET and C# with an intension to serve various clients

Responsibilities:

. Development of Web Forms for Client-Server interaction.

. Developed screens in ASP.NET, ADO.NET to display latest news & bid/ask

rates.

. Created web services using C# and exposed them through SOAP to

Authenticate, Lookup and Retrieve data from SQL 2000

. Development of prototypes using various tools that run under .Net

Framework.

. Developed a Portfolio Tracker System using ASP.NET and VB.NET that can

maintain and allow users to analyze it against the current market prices.

It also shows the profitability across portfolios. It has options to

modify/delete the entries, to view the cash flow position and to export

the entire portfolio into XML

. Developed holiday query screen using ASP.NET to view list of holidays for

trading.

. Responsible for writing a number of sophisticated Data Transformation

Services (DTS) in T-SQL and VBScript in SQL Server.

. Involved in creating tables, stored procedures, functions, views and in

SQL Server 2000.

Environment: Microsoft .NET Web Services, Visual Source Safe, ASP.NET(C#

.NET), VB.NET, SQL Server 2000, Windows 2000 Server, Java Script, HTML,

DHTML, XML and XSLT.

Loy Taubman Inc, NY, NY June

2005 - Dec. 2005

Project: OEMS- Order Entry Management System

Description: OEMS provides both end user and management all the tools

required to increase productivity and to negate erroneous billing. It

involves functionalities like a wizard based order entry process for front

desk, order tracking, completion, billing and account management for back

office, reporting/analysis of information for sales and accounting teams

and integration with intuit Quick Books Enterprise Edition accounting

package.

Responsibilities:

. Developed web interfaces using ASP.NET Web Forms, User Controls, VB.NET

and C#.

. Used OOAD concepts in designing classes.

. Developed highly useable templates for Use Cases and Use Case

tracking.

. Used .Net frame work class library, develop front-end skins using ASP.NET

Web forms that separated application logic from presentation code and

handled events in Code Behind.

. Wrote business logic in C# and handled transactions from and to database

using ADO.NET objects such as Datasets, Data Adapters and Data Readers.

. Used Multithreading at various places for better performance in the

application.

. Extensively used data validation controls for Client Side validation and

Java Script, VB script for opening different applications on the client.

. Created User Controls (.ascx), Custom Controls to reuse throughout the

Application like Address Control, Date Control, combo box control,

dynamic menu bar etc.,

. Developed Customizable Reports using Crystal Reports. Net, ADO.NET

objects

. Used SOAP to communicate with web services from Office.

. Used Forms Authentication for setting up Custom user Registration

. Involved in creating tables and writing Database Triggers, complex Stored

Procedures to extract data for reporting requirements and Views.

. Individually designed MS SQL Server 2000 database, coded stored

procedures (T-SQL).

. Extensively Used ADO.NET Transactions

. Wrote XML documents and XSL templates to send as an input to

Accounting software.

. Created Assemblies for CAP modules using VB.NET.

. Developed WCF service and services integrated in User Interface using MVP

Pattern.

. Created the logical and physical data model of the proposed database.

. Implemented the COM components by registering them on the multiple web

servers.

. Creating Indexes, Triggers, Views and Stored procedures on various

business rules.

. Created various Complex reports using Crystal Reports 9.0.

. Imported XML output to SQL Server 2000.

Environment: Visual Studio. NET, VB.NET 3.0, C#, Visual Source Safe, WCF,

SQL Server 2000, Oracle 8i, Crystal Reports 9.0, XML/XSL, QuickBooks

Enterprise Edition 5.0, Data modeling with ERwin3.0/Visio, and MS SQL

Reporting services.

.

Techorbit Inc., Dallas, Texas. Sep.

2004 - May 2005

Project: OREMS- Office of Real Estate Management System

Description: OREMS is an intranet web application provides a well-

structured graphical user interface to provide extensive support to the ORE

division in their daily business activities like acquiring real estate and

provide real estate services for the State Highway Administration projects

in a timely, effective and customer-oriented manner.

Project: Lawyers Information System.

Oct. 2001 - March 2002

Description: Developed an application for a law firm using VB, VB.NET, C#,

ADO.NET and MS SQL Server 2000. This application consists of database of

over 440,000 lawyers' bio and firms by location, practice, profile and

name. The application allowed anyone to match their case to pre-screened

lawyers for free, to learn profiles, ratings & fees up front, and then

choose the lawyer you like best.

Responsibilities:

. Internet/Intranet Developer for All the Modules

. Involved in Study and Analysis of Current ORE system

. Designed use cases using Rational Software.

. Designing and Developed Database using ERwin3.0/Visio for All

the Modules

. Designing and Developing ASP.net web pages for All the Modules

. Developing Class objects for middle tier business logic in

VB.net for all Modules

. Middle tier business logic ADO.net transacts with either

XML/Oracle 8i

. Writing stored procedures and database triggers in Oracle 8i

using SQL, PL/SQL

. Implementing Security for each user Role with different

privileges

. Implementing Concurrency Control when more than one user

interacting with database

. Designing and developing reports in Crystal Reports .net

compatible version.

. Wrote COM/ActiveX DLLs to implement the common functions used in the

entire application and used ADO. NET for database access.

. Participated in the software development life cycle; involved in writing

CSS files and files to maintain the consistency and reusability of the

code in the web pages.

. Visual Source Safe has been used for all the source code maintenance

among the whole team members. Involved in end user training.

Environment: ASP. Net, VB.Net, ADO. Net, Web Forms, Crystal Reports for

.Net, XML, Visual Source Safe, Data modeling with ERwin3.0/Visio and Oracle

8i/9i on Window 2000 Professional, IIS 5.0.

PrayogNET COMPUTING (In) Pvt. Ltd.

Dec.99 - Aug.'01

Description: Involved in developing an on-line shopping store for

electronic parts. A customer can visit the web site and search for an

electronic part. The application will search for different prices offered

by different vendors or suppliers for that particular item. Depending on

the price, the customer can choose to add into the shopping cart. The

customer can save this shopping cart and can return to continue at a later

time.

Responsibilities:

. Designed, configured, and developed the web site using ASP, HTML,

VBScript, and JavaScript

. Involved in the design of the database using Microsoft SQL Server 7.0

. Involved in debugging and testing, designed navigational flow and defined

usability and GUI guidelines

. Worked closely with clients to design and develop solutions that meet

client and audience requirements

. Generated complex reports like requested items reports using crystal

reports.

Description: Developed an Intranet application for a mobile phone

accessories company, where the sales information tracking system is

automated to be accessible from various clients using web browsers. The

core functionality of the application was to gather and retrieve the

customer database or prospective customer's information and online product

information and inventory tracking to be monitored centrally. This gave

tremendous advantage to sales team as information was centralized.

Responsibilities:

. Involved and developed an Interactive Internet site using ASP, HTML,

and Oracle

. VBScript was used for Server-side validations and Java Script was used

for Client-side user input validations.

. Coding of various pages to display company information, customer

information, product online and Inventory tracking for the employees

using ASP and HTML.

. Transformed information pertaining to various departments into HTML

format and linked them in systematic way for meaningful navigation and

provided database connectivity. ADO objects were used to manipulate the

data.

Environment: VB6, ASP, Html, SQL Server 7.0, IIS4, Windows NT4, JavaScript,

VB Script Crystal Reports.



Contact this candidate