.Net Developer Sql Server Business Manager Data

RESUME OF SRIKANTH NARISETTYNAGA, (MCAD)

Summary

. Over 4 years of experience and good working knowledge and conceptual

understanding on the Microsoft .NET2.0, 3.0, 3.5 Framework and the

complete suite of web development environments including, C#.Net,

ASP.Net, ADO.Net, Visual Studio .Net, .Net Remoting.

. Experience and working knowledge on ASP.NET AJAX framework and ASP.NET

AJAX Control Toolkit.

. Expert knowledge in Using DTS, Microsoft Integration Services SSIS

(Control Flow tasks, Data Flow tasks, Transformations, Database

administration tasks).

. Good knowledge in using Microsoft Analysis Services 2005 (creating cubes

and MDX queries) and OLAP.

. Strong in using Microsoft Reporting Services SSRS (report items, report

viewer control, datasets, parameters).

. Strong in using Microsoft SharePoint Services (Workflow, shared document

library, permissions).

. Knowledge of FLEX and Cairngorm methodology, Action Script.

. Experience in exception handling, debugging and tracing.

. Strong in user documentation, project architecture, system

specifications, project planning, interaction with end users, schedule

meetings, reviews, follow-ups and preparation of test modules.

. Strong abilities in Database Design, Normalization, writing complex

queries Stored Procedures, Functions and Triggers.

. Hands on experience with database Technologies like SQL Server 2000, ADO.

Net, MS Access, ODBC, ADO, and RDO.

. Experience in integrating.Net applications and flexible, analytical

programming and maintainable complex development and Team Foundation

Server.

. Experience in deploying the applications in web server, application

server and database server

. Experience in working with IIS, Creating and configuring the virtual

directories map them to physical folders. Setting up the default document

for the application and configuring the applications for domain

authentication

. Good communication and interpersonal skills and a team player

. Strong analytical and problem solving skills and a quick learner.

. Effective skills with good written, verbal communication and presentation

skills. Self-motivated with result oriented approach.

Education

. Masters in Computer Science - Governors State University,IL,U.S.A

. Bachelor of Technology - Jawaharlal Nehru Technological University

. MCAD - SR2594193

Skills and Core Competencies

Operating System: Windows NT 4.0/2000, 2003 server, 2008 server,

vista, 7, UNIX and Linux

Languages: JAVA, C++, C#, VC++, Visual C#.NET, VISUAL BASIC, T-SQL,

MATLAB

RDBMS SQL Server 2000, 2005, 2008, Oracle 8i/9i 10g, MS-Access, My

SQL, SQL and PL/SQL

Internet Technologies .NET Framework 2.0,3.0,3.5, ASP.NET AJAX, ADO.NET,

ASP.NET, .NET IIS, JavaScript, Core Java, VisualStudio.Net

2005.08,UML,Microsoft Share Point Services, WPF,WCF

Business Intelligence Business Objects, MS Analysis Services 2005, MS

Integration Services, Crystal Reports, MS Reporting

Services (SSRS) 2005

GUI Visual Basic 5.0/6.0, Developer 2000, Crystal Reports,

Flash, Flex2

Other technologies HTML, DHTML, XML, ASP

Experience

May 23 - Present Allstate Insurance Company

Software Developer

Maintainance and supported an important Intranet Application in Allstate

Insurance Company Using Asp.net 2.0, Sql Server 2005, C#. This application

is named "Vendor Self Service" part of big NEXTGEN application .Used for

vendor registration purposes. This application Used for submitting and

generating registrations, for a particular vendor. This application has

very good security levels, where some of menu controls can be seen by some

users and others cannot.

Responsibilities:

. Involved in Requirement Analysis, logging Issues and gathering Business

Requirements and designed in to Functional Design and Technical Design.

. Developed n-architecture basically developed into Business Layer, Data

Layer, and Presentation Layer.

. Written Many Stored Procedures Using Sql Server 2005 using Update stmt,

joins, insert statements.

. Developed Many Functions in C# which performs inserting, updating records

in database using stored procedures. Created Function for Creating and

displaying Ntid in the form.

. Used Grid View in ASP.Net 2.0 for Binding Data and updating the values,

Set Data Key names for columns and wrote events like onrowcommand.

. Used Flex ActionScript code generator can result in significant

productivity boost and increased quality of code by which invoking

different methods of a .net class is made easy

. Used TFS for source checkin and checkout operations for code safety .

. Used TDD and Continuous Integration methodologies to run and maintain the

projects.

. Configured Active Directory to provide security for various user groups.

. Developed various stored procedures and functions in Oracle10g.

. Involved in full SDLC implementation of project

. Created Review Id, using output Parameters in SqlServer 2005.

. Used SharePoint Content Management concepts for creating SharePoint Gantt

Project Management Chart

. Used UML diagrams for class definition.

Environment: C#.NET, VB, VB.NET, ADO.NET, VB6, .NET 2.0 Framework, SQL

Server 2005, ASP.NET Microsoft Web Expression, Adobe Photo shop, SharePoint

2007, SSIS, SSAS, VisualStudio2005, Flex 2.

Mar 10 - June 10 Magnani Continuum Marketing

Software Programmer

Magnani is a major client based marketing company in Chicago .They are with

large clients such as Marriott, CME Group, CNA insurance serving them with

all marketing needs .

They work on digital processes, marketing, ads, videos, and all creative

suite that today technology is offering to the world. Magnani website

creation involves lot of graphical skills and JavaScript and HTML skills

Responsibilities:

. Involved in business meetings for gathering of requirements and

analysis

. Worked extensively on .Net framework 4.0 and Visual studio 2010.

. Worked with Latest Silverlight4.0 for latest design patterns.

. Used Extensive Java script and JQUERY functions and plugins for graphical

user interface.

. Started working on PHP and some TYPO 3 technologies for a new product

proposal

. Worked on Advanced HTML for graphical programming and email Cutups

. Worked on SQL Server 2005 for generating user requests and maintaining

records

. Maintained different versions of applications and others using Source

safe.

Environment : .Net Framework4.0, ASP.Net4.0, VB.Net, ADO.Net, XML,

JavaScript, HTML, CSS, Crystal Reports, SQL Server 2005, Visual Studio

2010, Ajax, Visual Source Safe, Windows 2003 Advance Server.

Nov 07 - Mar 10 Farmers Insurance Group

Senior Software Developer

Farmers Insurance Group is a major multi-national insurance company for

auto and home Insurance.

The Scorecard is a web reporting portal that helps the Farmers Insurance

Group to evaluate performance of the employees using on-field performance

data. Scorecards facilitate the company to identify weak areas of the

employees to provide employee feedback and corrective suggestions. Also,

the scorecards help the company identify and award best-performing

employees in a fiscal year. Analyzers also give ability to use Online

Analytical processing ability to generate reports for vice presidents and

presidents to make decisions on employee, supervisor and manager

efficiency. Pivot sharp is one product which they use extensively as

Business Intelligence tool which is integrated to .Net application.

Responsibilities:

. Involved in understanding and developing .Net applications by migrating

from classical Asp to .Net

. Separated code from HTML content and classical asp code in to .Net code

behind. Cleaned up functions that mix code and script throughout a

function body. Doing so did put in a much better position to leverage

code-behind.

. One strategy used in the migration process is to migrate all of the

utility functions and code contained in your server-side include files

into C# class libraries. This allowed us to finally put all of the code

where it belongs-in objects, as opposed to multiple-interpreted ASP

files. We did able to group all sub-routines together in logical files

thus allowing us to easily create a set of VB or C# classes

. Involved in Client discussions to base line the requirement for 5 major

releases of this application like Auto Property Damage (APD) and

Liability, Circle of Dependability, Commercial Casualty, Workers

Compensation.

. Used DB2 database tables for loading the data in to our local SQL

database.

. Used JavaScript for client side validations for Show & Hide, Pop up

windows, Calendar, enable/disable, Controls, Hourglass etc.

. Increased the web page's interactivity, speed, and usability using AJAX.

. Implemented database connectivity using Microsoft Data Access Application

Block.

. Used WCF for using services using interfaces or contracts.

. Used WPF for Designing purposes for web pages used in building reports

. Used WWF for developmental Purposes.

. Developed front end web pages in ASP.NET 3.5 and business components

using Vb.Net 2008.

. Design pages and controls using Macromedia Flash and Silverlight.

. Design pages using flex by using default mappings between Action Script

and .Net data types.

. Reports were generated using Crystal Reports and exported to

PDF/Excel/Word format.

. Developed Scorecards and acted as production support lead since

scorecards and analyzers pushed in to production. Created workflows, to

configure routing so that documents are routed to right people for proper

action items using Microsoft SharePoint Services

. Maintenance included modifying the shared documents in libraries,

approving the documents while integrating with active directory to

provide security, so that authorize people can see what they have to see

SharePoint Services .

. Configured Active Directory to provide security and permissions and group

policies to various usergroups.

. Configured DNS to route various applications to different domains.

. Developed PL/SQL, T-SQL, and Oracle Forms using Oracle10g.

. Developed several reports using Microsoft SQL Server Reporting Services

(SSRS).

. Created Several reports using Report viewer control using Microsoft SQL

Server Reporting Services

. Used DTS Version to load the data and extract it the SQL Database.

. Extract, Transform and Load data using Microsoft ETL tool (SSIS) from

stage tables between different sources and target databases (Oracle, SQL

2008).

. Integrate the TSQL stored procedures inside the SSIS tool to automate

backend monitoring tasks in SQL 2008 using SSIS tool. Using property

expressions in SSIS to dynamically connect multiple servers at runtime

(to run backend jobs).

. Created and Configured Workflows, Work lets and Sessions to transport the

data to target warehouse Oracle tables using SSIS tool and also used to

load data through Onyx CRM data layer.

. There were two kinds of data loading processes (Daily and Weekly)

depending on the frequency of source data.

. Involved in development of Business Intelligence tool (Pivot Sharp) which

is used for generating reports for vice-presidents for their manager's

performances.

. Involved in development of Analyzers which include creating Cubes and Mdx

queries using Microsoft Analysis Services 2005.

. Acted as team lead of production support team for Analyzers for all LOB'S

(Apd, Liability, Cod, Commercial Casualty, and Workers Compensation).

. Involved in creating, building and processing several Cubes which are

used in Analyzers.

. Connecting Cubes with .Net application which is used for calculating

inventory such as assignments, reassignments, closed inventory of several

claim representatives, supervisors and several offices.

. Experience in Creating data source view, measures and calculated measures

in a Cube.

Environment: .Net Framework 3.5, ASP.Net 3.5, VB6,VB.Net, ADO.Net, XML,

JavaScript, HTML, CSS, Crystal Reports, Microsoft WPF and WCF, AJAX, Visual

Source Safe, DTS, Microsoft SQL Server Integration services 2005, Microsoft

SQL Server Analysis Services 2005 and 2008, SQL Server Business

Intelligence studio 2008, SSRS 2005, Windows 2003 Advance Server, Flex 2.

May 07 - Nov 07 Allstate Insurance Company

Software Developer

Developed an important Intranet Application in Allstate Insurance Company

Using Asp.net 2.0, Sql Server 2005, C#. This application is named "ROQSTAR"

Repository of Quality Standards and Reviews .Used for quality Assurance

purposes. This application Used for submitting and generating reviews, for

a particular project. This application has very good security levels, where

some of menu controls can be seen by some users and others cannot.

Responsibilities:

. Involved in Requirement Analysis, logging Issues and gathering Business

Requirements and designed in to Functional Design and Technical Design.

. Developed n-architecture basically developed into Business Layer, Data

Layer, and Presentation Layer.

. Written Many Stored Procedures Using Sql Server 2005 using Update stmt,

joins, insert statements.

. Developed Many Functions in C# which performs inserting, updating records

in database using stored procedures. Created Function for Creating and

displaying Ntid in the form.

. Used Grid View in ASP.Net 2.0 for Binding Data and updating the values,

Set Data Key names for columns and wrote events like onrowcommand.

. Used MDX queries, analyzed and created cubes for large amount of data.

. Used Flex ActionScript code generator can result in significant

productivity boost and increased quality of code by which invoking

different methods of a .net class is made easy

. Used SSIS and SSAS tools for back end management of integrating the data.

. Used TDD and Continuous Integration methodologies to run and maintain the

projects.

. Configured Active Directory to provide security for various user groups.

. Developed various stored procedures and functions in Oracle10g.

. Involved in full SDLC implementation of project

. Created Review Id, using output Parameters in SqlServer 2005.

. Used SharePoint Content Management concepts for creating SharePoint Gantt

Project Management Chart

. Used Crystal Reports for report building.

. Used UML diagrams for class definition.

Environment: C#.NET, VB, VB.NET, ADO.NET, VB6, .NET 2.0 Framework, SQL

Server 2005, ASP.NET Microsoft Web Expression, Adobe Photo shop, SharePoint

2007, SSIS, SSAS, VisualStudio2005, Flex 2.

Jan 07 - May 07 BCCIS County Information Services

Senior Developer

Worked on two separate projects. Both of the projects are from scratch-but

based on pre-defined requirements, web-based forms which can be filled out

by personnel within the organization to submit: a work-order request, or a

space-change request.

The sender of the request will receive an automatic email notifying them of

confirmation of their request, and the individual responsible for

facilitating the work which is being requested will get an automatic email

as well.

Thus allowing both parties to be fully aware of the request, facilitates

better follow-up & follow-through, and will create an accountability model

for requests and actions taken within the organization.

Responsibilities:

. Was involved in requirements analysis, understanding and documenting the

requirements into Business Requirement Documents and Business Design

documents

. Converted the BRD and BDD's into Technical Design documents

. Created sequence diagrams to realize the use cases and created class

diagrams to represent the static view of the system using Rational Rose

. Application was developed with VB.NET, Oracle, Stored Procedures,

Packages and Cursors.

. Exclusively used REF CURSORS for getting output parameters from the

stored procedures.

. Used ADO.NET objects such as Data Reader, Dataset and Data Adapter for

consistent access to ORACLE data base.

. Configuring SMTP Server, giving permissions for sending email from

application in local domain and also other domains.

. Extensively used TOAD for accessing the database while using ORACLE 9I

client.

. Used Validation controls Regular Expression Validator, RangeValidator,

Required Validator for validating different kinds of data from the user

like Email Address and Phone Number

. Was able to create a work-order request and space-change request, and

automatically send emails for request of work and response to the

particular work using Visual Studio Web Forms and Created User Interface

to the users.

. Using Infragistics NetAdvantage toolset, all major interface elements are

included like grids, toolbars, menus, listbars, explorer bars, UI and

editors.

Environment WIN 2000, Visual Studio 2003, Crystal Reports 9, IIS,

Infragistics Netadvantage, C#.NET, VB.NET, ADO.NET, .NET 1.1 Framework,

TOAD, Oracle 9I client and Visual Source.

Mar 06 - Jan 07 TicketsNow.com

Developer

Initiated and implemented varies business development ideas on the

company's primary website, TicketsNow.com and other sub-sites.

Responsibilities:

. Lead and managed an offshore team of 5 developers. Our team is

responsible for daily maintenance of applications and database of

websites. Also, I coordinated new developments as per the business

requests and requirements.

. Was the lead developer of Pay Per Click (PPC) application which is used

to create and manage company's ads for different event tickets on Google,

Yahoo, MSN, and other search engines. Application is used to manage

nearly 2 million keyword ads. Application was developed with C#, SQL,

Stored Procedures, and Triggers.

. Completed UML design modeling, which included Class Diagram, Sequence

Diagram, and Use Case Diagram for different projects.

. Implemented Cardinal Commerce Centinel client for Verified by Visa and

MasterCard SecureCode on the shopping cart.

. Integrated VeriSign Payflow payment gateway for authorization and

processing. This was completed using C#, ASP.NET Web Services, Session,

and XML.

. The above implementations helped in reducing fraudulent orders and loss

in revenue by 90% and also enabled realization of order automation

system.

. Developed comprehensive referral tracking and stats system for affiliates

using C# and SQL Server.

. Was a member of the team which was responsible for backend integration of

sub-sites to create industries first customer loyalty program, The

InCrowd. http://www.theincrowd.com Application was developed to create

periodic XML export of customers and orders data for data warehouse.

. Customized shopping cart for affiliates and partners. Custom

Configuration reader and User Controls developed in C# were used for

this, which enabled use of different style sheets, content, and order

parameters for the shopping cart.

. Developed application in C# to provide XML feed to IBSYS, Internet

Broadcasting Systems. Also created an admin interface using ASP.NET

technology for Business users to have complete control, with minimal

delay, over the promotional campaigns that get displayed on third party

web sites. This helped in creating brand awareness at locations across

the country using local media.

Environment: .NET 2.0, C# .NET, ASP.NET, SQL Server 2005, XML, SOAP

May 05 - Apr 06 First Trust Bank

Web Systems/Application Developer

Investment Management and Loan administration system was developed for

First trust bank. It deals with management of bank Shares and bonds, loans,

disbursements, deposits, credit and history of accounts. The applications

developed were for handling data for various borrowers. Their co borrower

related banks and variety of detailed information related to these.

Responsibilities:

. Understanding the existing application and study the database.

. Developed application interface using Windows Forms.

. Developed reports using report viewer control and exported to PDF format.

. Used controls like Master Pages, Login control, Dataview and Wizard

control.

. Used Atlas (Microsoft version for AJAX).

. Ensure deliverables are prepared to satisfy the project requirements and

schedule.

. Involved in defining the Business Components like Single Sign On,

Business Logic Assemblies etc.

. Involved in defining stored procedures in database.

. Involved in giving demo to the senior management and client.

. Developed the test cases and performed quality control operations.

. As Build Manager involved in builds of the entire application using NAnt

& Deployment Project in VS2005.

. As Build Manager developed batch file to execute schema's and deploy the

application.

. As Build Manager involved in configuration of the development and

production servers.

Environment :WIN 2000/2003, Visual Studio 2005, WIN FX (MS Window

Workflow), .NET2.0 Framework, SQL Server Reporting Services, IIS, ASP.NET,

VB.NET, ADO.NET, Atlas, NAnt, MS SQL Server 2005 and Subversion (client:

Tortoise SVN)

Contact this candidate