Manager .Net Service Project Sql Server Customer

Mythili Parthasarathy

SUMMARY

• Extensive experience with application analysis, requirement analysis, system design,

development, deployment, testing, integration, documentation and maintenance of application

software in web-based technologies, distributed n-tier architecture and Client/Server architecture

using Object Oriented Design and Object Oriented Programming

• Possess expertise in developing Windows applications, Web applications and Web Services

using C#.NET, ASP.NET, ADO.NET, VB.NET, ASP

• Extensive hands on experience with .NET Server controls, Web User Controls, Form Validation

controls, Custom controls and Data Grid Web controls

• In-depth experience in writing SQL Queries, implementing Views, Stored Procedures and

Triggers using SQL Server 2000 and SQL 2005

• Working knowledge in Internet languages like HTML, XML, JavaScript, ASP.NET

• Familiar with MySQL.

• Familiar with NHibernate Concept.

TECHNICAL SKILLS

Languages ASP.NET 4.0/3.5/2.0/1.1/1.0, VB, C#, ASP 3.0, VB.6.0

Web Related Visual Studio. NET 2010/2008/2005/2000, Web Services,

Window Services, ASP.NET,ADO.NET,C#, VB.Net, JavaScript,

Classic ASP, HTML, WCF

Web Servers and Application Microsoft IIS, Microsoft Team Foundation Server

Servers

Databases SQL Server 2008/2005/2000/7.0, MS Access 2003/2000,

MySQL

GUI VB 6.0, VB.NET

Methodologies Object Oriented Programming, Domain Driven Design

Report related Crystal reports 2008,SQL Server Reporting Services

Other Tools VSS, SSIS,SVN, Team Foundation Server, CRM, Telerik

Controls, Infragistics Controls

EDUCATION

B.S Degree in Engineering.

Diploma in Advanced computer Programming.

WORK EXPERIENCE

Project : Program Manager, Room & Resource Manager, eTouches, iMIS

Client : (C) Systems LLC., NJ

Date Jan 2011 – Till Date

(C) Systems have been involved in the delivery of technology solutions to the non-profit sector. The

company mainly provides project management processes, membership and fundraising applications,

accounting, order fulfillment, customer service, and distribution systems. (C) Systems is focused

exclusively on the tax-exempt sector, delivering and implementing ASI's iMIS Membership and iMIS Fund

Raising applications, and several other sophisticated solutions that include Content Management,

Communications and Collaboration tools, and extensive Program, Class, Seminar and Facilities

Management applications.

Description:

Program Manager:

PM provides full function educational program management and program marketing capabilities. It is

100% .NET and browser based with roles based security so access to the system is easily offered from

any web connection. This unique software manages all aspects of program creation, scheduling, session

controls, instructors and facilities and resource management. Combined with powerful on-line ecommerce

and marketing capabilities, Program Manager meets the needs of the most complex education and

training organizations.

Room & Resource Manager:

RRM Manages the organization’s shared meeting facilities in a lot more than just booking a conference

room. Quickly finding the right space that’s available, and properly configured for your event sounds

simple enough, but when it comes to manage a large number of rooms, sessions, instructors and

equipment the task can become quite complex. Meeting managers and planners face everyday

challenges to eliminate double bookings and resource shortages that are critical for productivity and cost

savings. Optimally managing the valuable resources will result in significant improvements in resource

utilization.

eTouches:

The eTouches product line is comprised of an extensive line of modules that can be used individually or

combined to achieve the software package that you need. All of the modules work together to allow you

cross-event data capture and reporting and are designed to provide the greatest efficiency in performing

logistical event management tasks. (C)onnect is the name for the integration product that enables the

eTouches event management platform to correctly interface with the iMIS 15 platform.

iMIS Product Line:

iMIS is an upgradeable, web-based software solution for managing associations, membership, nonprofits,

fundraising and continuing education. iMIS provides the core functionality nonprofits need in one

database with a single location for name, address and historical constituent information.

Responsibilities:

• Designed and developed Connect project for eTouches integration with iMIS and handles service

requests from client.

• Responsible for deploying the connect project for multiple clients.

• Involved in developing new functionalities as per the user requirement in the existing in-house

applications like PM and RRM.

• Involved in integrating the RRM with MS Outlook using outlook addin feature for creating and

managing appointments.

• Heavily involved in UI design using .Net Framework, CSS, AJAX, HTML, JS and Master Pages.

• Responsible for resolving the service issues by interacting with clients and by handling the

service/support tickets.

• Involved in writing stored procedures and user-defined functions for sql communications.

• Responsible for QA/production/client deployments.

• Created multiple Web Service products for iMIS interaction to be used at various client servers.

• Worked in creating and modifying the sites at iis at client servers for various product installations.

• Responsible for preparing technical documents, release notes and deployment lists as and when

required.

• Involved in mentoring team members.

• Worked directly with IT Director and Senior Project Manager in estimating the timelines and

project planning.

Environment: Visual Studio 2010, C#.NET, SQL Server 2008,, WCF, Infragistics Controls, VSS,

TFS, Hyper Snap, CSS, HTML, AJAX, JavaScript.

Project : GlowpointMaster Conference Scheduling System

Client : Glowpoint Inc., NJ

Date : Feb 2010 – Oct 2010

Glowpoint is a leading provider of advanced video communications solutions. Glowpoint provides

advanced and robust telepresence and video communications service solutions empower global

organizations to dramatically enhance the impact and productivity of their internal and external

communications, while reducing their ongoing operating costs. They achieve this for customers by

providing a full suite of telepresence and video conferencing managed services, and by enabling secure

business-to-business video communications.

Description:

Glowpointmaster is a conference scheduling system which provides the ability to schedule conference

online based on the internal user’s role. Glowpoint master has data layer, business layer and presentation

layer. WCF technology has been used in order to make service-oriented application feature to provide the

communication across the web and enterprise.

Responsibilities:

• Designed and developed CRM console search application for the user to get the conference

details

• Responsible for implementing Telerik controls like Schedule General, Timepicker, Datepicker and

Telerik Grid

• Involved in developing new functionalities as per the user requirement in the existing in-house

application.

• Responsible for troubleshooting and bug fixing as the application process.

• Involved in writing stored procedures and user-defined functions

• Responsible for sending automated error email to appdev and IT support team in case if of any

system error occurs

• Designed and developed the business layer.

• Worked on creating the dbml files for the data access layer

• Created Web Service to perform scheduled tasks which assembles various data into a multiple

database

• Consumed CRM websrvice to insert, update and deactivate data into CRM

• Worked in modifying the registry files for different environments

• Responsible for sending automated confirmation email to users after scheduling a conference.

Environment: Visual Studio 2010, C#.NET, SQL Server 2008, SVN, WCF, Telerik Controls,

Infragistics Controls, CRM

Project : RRAD Application (Internal Company System), Client Websites (External users)

Client : The Peer Group Inc., NJ

Date : Nov 2008 – Jan 2010

The Peer Group is the premier provider of moderated peer influence programs for the

Bio-pharmaceutical industry. Peergroup brings the targeted physicians together for a moderated and in-

depth discussion of product messages, respond to marketplace challenges, influence prescribing choices,

augment your sales force, disseminate clinical research or convey new standards of care. A leader and

innovator in the field of peer-to-peer programs, The Peer Group created the first moderator-led

promotional meetings for healthcare professionals.

Description:

RRAD is a healthcare marketing application used to educate physicians and market drugs developed by

reputed pharmaceutical companies. The application has several modules like List Processing Module,

Meeting Scheduling, Venue Scheduling, Speaker Module, Recruiting Module, Reporting Module and

Customer Service Module. In addition to RRAD (an Internal system), Client-focused Websites (External

system interface) provided clients with custom solutions to interact with RRAD as well as facilitate

managing their programs.

Responsibilities:

• Project Management activities for small-medium size projects

• Designed and developed web application which directly interacts with RRAD using ASP.NET and

C#.NET

• Added new User Interface features to enhance the existing application using C#.NET

• Involved in developing new functionalities as per the user requirement in the existing in-house

application.

• Responsible for troubleshooting and bug fixing as the application process.

• Involved in writing stored procedures and user-defined functions

• Created Reports using SSRS for the components like meeting schedule, recruiting and Tracking.

• Responsible for writing Software Design Specification document

• Involved in creating the Client websites for the Healthcare clients to view the schedules online

and also able to modify the schedule online.

• Created Reports using Crystal Reports 2008 based on business analysis perspective.

• Responsible for automating the reports to clients via email using the SSRS subscription feature.

• Directly interacting with client/users to gather the requirements and conduct demo of the system

for any modifications.

Accomplishments:

• Re-engineered existing processes' to increase productivity, reduce maintenance costs, enhance

User Experience

• Implemented Open-Source solutions to meet business needs, saving money while still meeting

business requirements

• Implemented custom solution to integrate Adobe with Training activities to create online ePrep

Tool for the moderators to do the online course about the healthcare product and create a survey

out of the course for own reference.

• Designed and developed the website for the moderators to view their scheduled meeting online in

list view and Calendar View.

Environment: Visual Studio 2005, VB.NET, C#.NET, SQL Server 2005, Microsoft Team Foundation

Server.

Project : DirecTV Overlay

Client : (homes.org) The Elephant Group., NJ

Date : Jun 2008 – Oct 2008

Description:

The System is an Overlay of DirecTV Site. This basically involves in (screen scraping)capturing data from

the DirecTV web site pages like the customer and order information and storing in the database through

Web Services. This Overlay Application designed to the finest possible entity which helps in capturing the

data as the order goes through in the sales process. The captured data will be sent to the database and

saved for further reference. This process has been taken care by the Web service and any Error created

during the screen scraping or the storage process will be stored in the DB by Error log Web service.

Responsibilities:

• Involved in full life cycle development of the software

• Created process flow and class diagrams of the system

• Responsible for writing Software Design Specification document

• Involved in designing database structure of the application and created tables, stored

procedures

• Designed User Interface using ASP.NET and Business Classes using C#.NET

• Created Web Service to perform scheduled tasks which assembles various data into a single

database

• Errolog Webservice is implemented to monitor the breaking of the system and alert mails will

be sent out

• Generated Emails from .Net which would send the Excel reports

• Unit Testing of the application done against the real orders

• SSIS is used to build the data integration and workflow of the application.

Environment: ASP.NET 2.0, C#.NET, SQL Server 2005, Web Services, SVN-Version control tool.

Project : Unified Web Ordering System

Client : J.Knipper & Co., NJ

Date : Aug 2007 – Jun 2008

Knipper provides healthcare marketing solutions to various pharmaceutical companies. It also handles

database management, fulfillment, telemarketing, mass mailings and web services.

Description:

UWOS aims at providing a generic framework for order placement and order processing for various

clients of the company. All the system and business changes are made configurable which provides an

ease in serving the clients with different requirements. This is a database-driven application designed to

the finest possible generic entity which helps in changing the configuration settings. The project has 3

components viz. User Interface - the front end to place the orders, OPS - the middle layer to get the

orders from different clients and place it in unified OPS database for reporting purpose and the third layer

OMS - to integrate different types of orders and sending it to the Promail for further processing and

shipment.

Responsibilities:

• Designed User Interface using ASP.NET and Business Classes using VB.NET

• Used Microsoft Data Application Block for database interaction

• Worked on master pages and Web User Control for the application

• Extensively worked with Grid view binding with Data Source along with SqlDataAdapter

• Created Windows Service to perform scheduled tasks which assembles various data into a

single database

• Used Reflection to execute various classes from the database

• Implemented logging and notification for sending various Error and job failure emails for

scheduled tasks

• Responsible for Unit Testing of the application

• Conducted demos for the clients explaining the flow and behavior of the system

• SQL reports have been developed to view the orders placed for month, week and year. Also

reports were generated to view the product usage.

Environment: ASP.NET 2.0, VB.NET, C#.NET, SQL Server 2005, Web Services, Windows Services,

SQL Reporting Services.

Project : Novo Web Ordering System

Client : J.Knipper & Co., NJ

Date : Dec 2006 – Jul 2007

Description:

This application is being developed as Web Ordering System for Novo Nordisk products

that consist of various components such as Novo Seven/Novo HT (Hormone Therapy),

Novo Medlink, Novo Booth Manager, Novo Patient Expo. This system provides a user

friendly interface for placing new orders and viewing prior orders. In addition, the system

includes an administrative function for managing users, offer items and application

components. GenericWebAdmin is an Administration site which is used for maintaining

all of these components together. It provides a single-entry point for creating and

maintaining users and products for all the components.

Responsibilities:

• Design and implementation of seamless communication between different modules of the

system.

• Used Microsoft Data Access Application Blocks to build queries and retrieve specific data

from the database.

• Developed the classes using VB.Net. The Entity Objects are used to perform data

manipulation operations.

• Developed the User Interface using ASP.NET UI Component’s like Panel, GridView and

FormView etc.

• Implementing Ajax to get control over web page design as partial page update and Ajax

enabled extender controls.

• Achieved data validations in the UI ASP.NET Validation Controls.

• Built Report Screens for various functions that includes refining, retrieving and displaying of

data based on specific search criteria keyed in by the user.

• Designed and coded database tables and stored procedures and their interface with front end

using ADO.Net.

Environment: VB.Net 2.0, SQL Server 2005, Visual Studio .Net 2005, ADO .Net, ASP.Net, Ajax,

Classic ASP, Web Services, JavaScript, XML and HTML.

Project : e-KYC

Client : HSBC, NYC

Date : Aug 2005 – Dec 2006

Description:

E-KYC is Data Capture Utility developed for this purpose. This utility is developed to help relationship

managers capture Know Your Customer (KYC) information for existing customers.

This project has different roles namely Admin, Relation manager, Compliance manager and Enquiry

manager. Among many processes KYC i.e. Know Your Client is one of the important processes. All

radicals with detail information such as risk score, KYC complete, due date is shown in data grid. User

can then enter data in Basic Account Information. Once all KYC information is entered & due diligence

level is set, KYC completion can be done. Once certified as complete, record gets locked & is not

available for editing. OFAC & PEP checking is also done in KYC information. KYC also has further

screens such as product & services, Ownership and relationship information.

This project makes use of web service technology extensively. A web service authenticates the user. After

successful login, user also gets authorized. We also created various user controls to access the database

ADO.NET is used in the DAO layer.

Responsibilities:

• Involved in the database and application design

• Involved in writing system and interface use cases.

• Dynamic rendering of screens.

• Designed and implemented user interfaces, screen layouts using ASP.net Web controls,

HTML and CSS.

• Developed web pages in ASP.NET for various processes like Know Your Client

information, Basic information, Ownership etc.

• Worked on SQL Server backend, writing stored procedures and triggers

• Implemented HTML Server Controls, ASP Server Controls along with Validation Controls,

worked with Data Grid and Repeater controls.

• Involved in writing unit test cases.

• SQL reports were generated to view the Customers risk score and rating information.

• SSIS is mainly used for data warehousing purpose.

Environment: ASP.NET 2.0, C#, ASP 3.0, SQL SERVER 2005, ADO.NET, IIS, Visual SourceSafe 6.0,

HTML, Java Script, XML, XSLT, Web service, SQL Reporting Services, SIS.

Contact this candidate