Developer .Net Sales Project Data Development

Suma

Pati

*** -***-****

*****.******@*****.***

SUMMARY

. 6+ years of experience in Software Development of Web Applications.

. Extensive programming experience using C#, ASP.NET MVC, ASP.Net,

Classics ASP, XML, HTML, ADO.NET, XSLT, CSS, LINQ, Oracle 10g and MS

SQL SERVER.

. Good knowledge in .Net Technologies like Web Services, Web Forms, WCF,

AJAX, User Controls, Validation Controls, HTML Controls.

. Extensive experience with Web based Client-Server using N-tier

Architectures and MVC, MVVM architectures.

. In-depth knowledge of Object-Oriented Programming Concepts (OOPS),

Internet Technologies and related technologies like Web Services, XML,

HTML and JavaScript.

. Good experience with .net Server controls like Data Grid, Repeater,

List view, Drop Down list,

Data List to retrieve the data from database to show the user

interface. Used paging, sorting,

Editing to create dynamic user controls.

. Experience in writing Stored Procedures and Package (T-SQL, PL/SQL),

Functions, Triggers, Indexes, Views and database design/maintenance.

. Hand on experience working with XML, XML Schema and XSL (XSLT, XPATH).

. Extensive experience in working with Language Integrated Query (LINQ)

and retrieve data from different data sources like LINQ to SQL, Entity

Framework.

. Experience in developing reports using SQL Server Reporting Service

(SSRS) and Crystal reports.

. Used SSIS to read excel documents and import data into MS SQL Server.

. Experience analytical skills with proficiency in debugging and problem

solving and business people in the .Net application.

. Involved in production support and maintenance of various project.

. Involved extensively system testing, unit testing using MS Unit Test

Framework and analysis.

. Used Agile Methodologies, Test Driven Development (TDD) and Waterfall

models as software development life cycle.

. Excellent team player and a good communicator capable of interacting

with end users and technical team.

TECHNICAL SKILLS

Languages : C#, ADO.NET, C, C++, HTML, DHTML, XML, Java script, AJAX,

VB6, JQuery

Internet Technologies : ASP.NET, ASP.NET MVC 2, LINQ, ADO.Net

Entity Framework, WCF

Web Services, SOAP,

VBScript

Database : MS-SQL 2005/2008, SSIS/DTS, Oracle10g/11g, MS

Access,

Development Environment : Microsoft Visual Studio 2005/2008/2010

Server Platforms : Windows Server 2003, 2008, SP1, IIS 6.0/7.0

Reporting Tools : Crystal Reports 8.5, SQL Server Reporting

Services 2005/2008

Operating Systems : MS-DOS, Windows

(NT/XP/2000/2003/2007/Vista)

PROFESSIONAL EXPERIENCE

LPL Financial, Charlotte, NC

Dec'12- Till Date

Project: BranchNet Enhancement Assets & Revenue

Role: Sr .Net Developer

LPL Financial is independent Broker dealer and consultant to retirement

Plan they have over 13,300 Financial Advisor (REP) and 700 financial

Instructions.

The System provides Advisor with Secure automation and Controlled

Notification. These Notifications get Trigger to Advisor based on the

various Conditions. These Notifications is of 2 types Alerts / Tasks

System is developed in Classic ASP 3.0/ ASP.Net which take various

parameters and trigger the Alert and Task to Advisor (REPIDS).

Responsibilities:

. Work on the BTR/Notification module to Develop system to get pre

populate Data which Used by User to Create Tasks and Alerts.

. Write Stored Procedure and Function to be used within the

Notification.

. Unit testing of the Module and Development in QA Environment.

. Created a Change Controls for development to QA BOX.

. Validation of A3 Doc. for various RepIDs Team using SP.

. Co-ordinations with various Teams with Development and Deployment

Process.

. Worked on SSRS Report for Printing Trade Blotter Report.

. Written stored procedures in SQL server.

. Used XML DOM to pass values across the Pages.

Environment: C#, Classics Asp 3.0, ASP.Net, SSRS Reporting, MS SQL SERVER

2008, Visual Studio 2008, XML, HTML, Window 2008, IIS 7.0, TFS.

Digital Infuzion, Gaithersburg, MD

Apr'12-Nov '12

Project: DMID- Clinical Research Management System

Role: .Net Developer

The DMID Clinical Research Management System (CRMS) will support management

of clinical research activities funded by (or otherwise supported by) the

Division of Microbiology and Infectious Diseases (DMID). The initial

release of the DMID-CRMS focuses on implementation of the Clinical Site

Monitoring component of the DMID-CRMS. The DMID-CRMS Clinical Site

Monitoring (CSM) system v1.0 will enable DMID users to track clinical site

monitoring activities in a centralized manner. This system will include a

component for managing people and organization information (Master Contact)

and a supporting component for making protocol data available for CSM

activities.

Responsibilities:

. Involved in full life cycle of the project from requirements

gathering, analyzing, designing, and developing the application using

Iterative AGILE Methodology.

. Participated in detail design of the application using MVVM

architecture, involved in creation of use cases, sequence diagrams and

class diagrams.

. Involved in writing and implementing client validation scripts and

also used server side validation controls.

. Developed UI Layer using HTML5.0 Knockout.js, JQuery and CSS.

. Created Dropdown and Drill through reports using SSRS.

. Imported data from flat files to SQL Server database using SSIS.

. Used n-Unit to test developed components.

. Written stored procedures in SQL server.

. Involved in production support and fixing production issues.

Environment: Visual studio 2010, C#, ASP.NET 4.0, MVVM, LINQ, WCF, MS SQL

2008, JQuery, Knockout.js, IIS 7.0, CSS, XML, HTML, SSIS, SSRS, Team

Foundation Server(TFS) and Agile.

Time Warner, Tempa FL, USA

Oct '11 -

Apr '12

PROJECT: Time Warner Retail & Sales Marketing

ROLE: Application Developer

The TWRSM New Rack System is a new database driven Web based application

developed for Time/ Warner Retail and Sales Marketing (TWRSM). Time/ Warner

is one the largest distributor of Magazines in the US and Canada. TWRSM is

a part of Time/Warner which handles the sales and distribution of different

magazines from Time Inc and other publishers. The new rack system was

developed to replace and handle the distribution of Time Inc and its client

magazines to the various stores with the design of racks with proper

sections, tiers and pockets. The new rack system was basically divided into

three divisions to handle three different types of racks in the stores i.e.

Customer Check Out, Main Line and Stock. Customer Check out are found in

the checkout counters of the stores, Mainline are found inside the store

while as Store are used to store the surplus quantity of the magazines.

Responsibilities:

. Gathered the information and requirements for design and development

of new rack system which would be used as an upgrade of the current

system.

. Created and maintained database objects like complex Stored

Procedures, Triggers, Tables, Views and SQL Joins.

. Created Client side validations with JavaScript and Server side

validations with ASP.Net 4.0.

. Used WCF to communicate between DAL and business components.

. Used ADO.Net Entity Framework for connecting to SQL SERVER.

. Design the User Interface to process of the rack system and develop

the Business logic and Data Access logic using C# and ASP.Net.

. Used JQuery UI for Tabs and Date Picker, Image Viewer.

. Also developed the user interface to connect with the Sales Logic for

the proper flow of the rack design and data. Involved in Integration

and unit testing for the developed modules.

. Generate the reports for process of flow of the development i.e.

during Field Approval, Purchase order and Invoice using SSRS.

. Involved in the iterative process of development in Agile and Scrum

Methodologies.

Environment: C#.Net, ASP.NET 4.0, LINQ, ADO.Net Entity Framework, WCF, MS

SQL 2008, JQuery, IIS 6.0, CSS, XML, HTML, DHTML, SSIS, SSRS, Team

Foundation Server(TFS).

ConvaTec, Skillman, NJ, USA

Apr '10 - Jul '11

Project: Compass

Role: Software Developer

ConvaTec, develops, manufactures and sells high-quality products for Ostomy

care, Skin care and advanced Wound care to a range of organizations in the

healthcare marketplace, including hospitals, nursing homes, home health and

pharmaceutical retailers. Compass application is being developed to

facilitate individual Ostomy customer, facility, retailer and Vendor who

are using the Ostomy product(s). The application allows user to explore

about the new products for every existing market across the globe. This is

a multilingual application have two versions: online using ASP.net and

offline using winforms. The database is SQL SERVER.

Responsibilities:

. Designed, developed, and the integration of system with other

application using ASP .NET 3.5 with Active Directory authentication.

. The System is developed in .NET Framework Environment with MVC

Architecture.

. Designed web pages using ASP.NET MVC 2 and databases and created

complex SP Packages and triggers.

. Coding of all layers - UI (View), Business (Modal), Controller, WCF

Services and data access layer (Modal) using LINQ and C#.

. Developed a common library for jobs scheduling component for sending

SMS/EMAIL.

. MS Visual SourceSafe is used for source code version control.

. Developed WCF which is used across the projects.

. Unit and Integration testing for the entire developed module.

. Worked on the agile methodology for this application.

Environment: VS .net 2008, C#, ASP.NET 3.5 MVC 2, WCF, MS SQL 2008, LINQ,

JQuery, Ajax, XML, HTML, IIS 6.0, Visual Source safe (VSS), CSS, OOAD.

Wells Fargo Bank, Pennsylvania, USA

Jan '09 -

Mar '10

PROJECT: GSMOS

ROLE: Software Developer

The GSMOS application facilitates an automated real-time OFAC sanction

scanning solution for names, addresses and narrative text contained in

Trade Services, Correspondent Banking, Global Foreign Exchange and\or ACH

transactions. All fields with entity data values on these transactions will

be sent to GSMOS for sanction scanning. The system provides the capability

for reviewing, approving, or rejecting transactions where parties match

entities from sanction databases.

Responsibilities:

. Responsible for designing, developing business logic and data access

logic in 3- tier architecture and implemented web design patterns.

. Developed the user interface in ASP.NET using C# as code behind

language.

. Used WCF to implement Service component for Web based Services.

. Used Editable Data Grid Controls to generate responses based on client

requests.

. Generated SSRS to display the statistics based on user request

selecting options

. Used ADO.NET for data querying, storage and manipulation. Designed and

Implemented Data Access Layer (DAL) using ADO.NET to communicate with

SQL Server 2008

. Used Custom Validations, Validation Controls and performed validations

both on client side and server side.

. Tuned applications by re-coding T-SQL scripts to utilize cost based

optimizer.

. Responsible for the analysis, designing and coding of the database.

. Responsible for the integration of software updates and upgrades

(version control and packaging releases).

. Documentation of developed Components and module.

. Handled the client problems and troubleshoot and fixed the bugs.

. Involved in Unit testing QA testing and user acceptance testing

Environment: ASP.NET, ADO.NET, C#, WCF, MS SQL 2008, XML, HTML, CSS,

JavaScript, SSRS, SSIS, Oracle 10g, Visual Source Safe(VSS), IIS 6.0

Bet2win, Edison, NJ, USA

Apr '08 - Dec '08

Project: Bet2win

Role: Software Developer

This is a Web Application to facilitate Horse Race betting. Around the

globe to categorize their search, calculate the best bet and place it. It

has an inbuilt Research Engine to calculate the best bet based on a 10-year

archival data, An Alerting Engine to send alerts via Email or SMS to the

subscriber, A Billing Engine to validate the Credit card information and to

deduct proper charges from the subscriber's account.

Responsibilities:

. Designing the Architecture of Bet2Win using C# and ASP.NET.

. Developed Component to upload Xml files using C#.

. Developed jobs scheduling component for sending SMS/EMAIL.

. Using C# and 3rd party tool (IntelliSMSDotNet) developed component for

sending SMS.

. Using C# developed a component which interacts with 3rd party tool

(Trust Mark) for credit card validation and payment.

. Developed the User Control where user enter the matching criteria for

alert.

. Used Oracle ODP for Connecting to Oracle Database.

. Coded and implemented PL/SQL packages to perform get the data from

database.

. Archived historical data using SSIS.

Environment: Visual studio .Net 2008, C#, ASP.NET 3.5, ADO.NET, MS SQL

2008, Oracle 10g, JavaScript, XML, HTML, IIS 6.0, Visual Source safe (VSS),

CSS, OOAD, SSIS, SSRS

Pfizer, NJ, USA

May '07 - Mar '08

Project: Optima

Role: Software Developer

Optima (Online Pfizer Territory Information Management Application) a Web

based Sales Force Automation tool. It will be useful for Professional Sales

officer (PSO) of Pfizer to plan and manage their calls to Doctors and

Chemist. It helps Managers to monitor the activities of PSO's.

Classification of Doctors is done through a "Targeting" Module of the

application. Project help PSO's to manage their leave and onsite visits.

Other's features like Data due duping (removing of duplicates value) and

targeting, future estimation using graph.

Responsibilities:

. Developed user interface using ASP.Net.

. Developed a component to export/imports list of data's.

. Unit Testing of entire developed modules

. Developed web services using C# to be used in PDA'S and across system

. Involved in retrieving data using ADO.Net with C#, ASP.Net and

presenting it to XSLT.

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

rules

. Implemented Forms-based Authentication in ASP.NET to authenticate the

users.

. Deployment of project at client place

. Creating setup for the project

. Developed and implement localization

. Developed component for Encrypt/decrypt using C#

Environment: VS .net 2005, C#, ASP.NET 2.0, MS SQL 2005, JavaScript, XML,

HTML, CSS, IIS 6.0, Visual Source safe (VSS), OOAD

Oscar Online Technology, Mumbai India

Aug '06 - Apr

'07

Project: Fabrication Inventory System

Role: Software Developer

The Project Inventory system has been developed for Gammon India ltd.

Gammon India Ltd is leading Construction Company in India. The Project has

been developed With Object Oriented Approached using C# and Ms-SQL 2005 and

Crystal Report 8.5. Project keeps track of mechanical jobs issued to 3rd

party for development and cost involved in it. Project help management to

get various reports on inventory available at various locations. Keep track

of various vendor/supplier. Other's feature include track of physical

inventory, track of transit/transferred inventory, stock reports, material

issued status, admin module

Responsibilities:

. Requirements Gathering and interaction with client

. Designed, Developed Business Logic, Data Access Layer in C#.

. The application was developed using ADO.net to interact with SQL

Server database.

. Designed and developed user interface screens using C# and Asp.net

. Deployment of project at client place

. Unit and integration testing for the entire developed module.

Environment: Visual Studio 2005, C# 2.0, Asp.net, Visual Source Safe 6.0,

Crystal Reports 8.5 and MS SQL 2005

EDUCATION

. M.Sc. Master of Science(BI), India

. B.Sc. Bachelor of Science, India

. CIC, Certificate in Computing, New Delhi, India

. Diploma Course in C#, ASP.net, ADO.net, Mumbai, India

Contact this candidate