Anil Kumar Cheerala

***** ****** ****, *** # ***

Austin, TX - 78758

903-***-****

ablnvq@r.postjobfree.com

Experience Summary:

. Information Technology professional with over 10 years of experience in

Object Oriented Analysis and Design (OOAD), UML, enterprise design

patterns, Software Life Cycle Management, Developing Internet/Intranet

related applications using Object Oriented Programming and Visual Studio.

NET.

. Microsoft Certified in Developing and Implementing Web Applications with

Microsoft Visual C#. Net and Microsoft Visual Studio. Net.

. Having 8+ years experience on Internet technologies likes, IIS 5.0-6.0,

VBScript, ASP, JavaScript, HTML, and DHTML.

. Having 9+ years of experience in ASP.NET, ADO.NET, XML, XSL, XPATH, WSDL,

UDDI, SOAP, Web Services, .Net Remoting, WSE 2.0, AJAX, Webforms, and

Winforms etc.

. Having 2+ years experience in NUnit, MSMQ message queuing technologies

and transaction services.

. Experienced with DAL, BLL and entity component layers for .NET as well as

the use of NHIbernate with Fluent NHibernate, LINQ TO SQL, and Entity

Frameworks.

. Experienced with using StructureMap/Unity IOC containers and Common

Service Locator.

Skill Set:

Languages: C, C++, MFC, VC++, C# 2.0,C# 3.0, VB, VB.Net, Java, T-SQL

Web Development: HTML, DHTML, XML, XSLT, XPATH, ASP 3.0,

ASP.NET, PHP and CSS.

Web Services: .NET, UDDI, WSDL,

.Net Remoting, and SOAP

Web Authoring Tools: Dreamweaver-MX, Fireworks, and FrontPage

Web Servers: IIS 5.0, IIS 6.0, Apache

Scripting Languages: JavaScript, VBScript, JQuery, UNIX shell.

Environments: Win 95/98/2000/NT, Win XP, UNIX (IBM-AIX),

And RH-Linux.

RDBMS: MS Access, SQL Server 2000/2005, Oracle 8/9i,

DB2.

Data Access Tools: ODBC, ADO, ADO.NET, and DAO.

Case Tools: Microsoft Project, Microsoft Visio, Enterprise

Architect and Rational Rose.

Microsoft Technologies: Visual Studio 2003/2005, Visual InterDev, and

Visual SourceSafe, MSMQ

Component Technologies: COM, COM+ and DCOM.

Reporting Tools: Crystal Reports 8.5,Cognos Reports 8.3

O/R Mapping Tool: Nhibernate.

DI/IOC Tools: StructureMap, Unity

Certifications:

Developing and Implementing Web Applications with Microsoft Visual C#. Net

And Microsoft Visual Studio. Net.

Professional Projects:

State Performance Plan Indicator System: June' 08 - Current

Texas Education Agency (TEA), TX

Environment: C#, ASP.Net, ADO.Net, SQL Server 2005, Visual Studio 2005,

Version Manager, Tracker, XML, XPATH, XSL, Cognos BI, Enterprise Architect,

Visual Studio 2008, Fluent Nhibernate, StructureMap.

Description: SPP applications enable a statewide data collection system to

meet the

specific requirements of the State Performance Plan Indicators and enable

the Division of

IDEA Coordination to fulfill their mandated OSEP reporting in a timely

manner and at

reduced cost improving performance, productivity, collaboration with other

state or

agency to better share resources with other States or Agencies and mission

critical needs

that cannot be fulfilled more efficiently by other means and also develop

systems using

defined architecture that is efficiently and economically extensible for

other future needs

that supports the mission of the State and the Agency leveraging Microsoft

state of the art

technologies. The application facilitate improvement of the State's

performance on

Indicators at the statewide, regional, and district level.

Responsibilities:

. Participated in database design based on standards and normalization

principles.

. Lead Developer for SPP11, 12, 13 applications based on TEA standards.

. Developed business components using generics, design principles and C#

as programming language.

. Lead the effort in RSA encryption of configuration sections.

. Implemented two-way data binding against custom business objects.

. Developed Cognos reports using Cognos BI suite.

. Enhanced Cognos wrapper using Cognos .Net SDK.

. Monitored remote server performance using Perfmon tool.

. Migrated the application to VS 2008.

. Experienced with DAL, BLL and entity component layers for .NET.

. Used NHibernate with Fluent Nhibernate framework for mapping entity

classes to relational database. .

. Used StructureMap DI/IOC tool to facilitate loose coupling between

classes and it dependencies.

. Used MVC framework to re write the web application.

. Used LINQ to write structured type safe queries to query in memory

object collections and remote data sources.

IML Application: Mar' 08 - Jun' 08

Cleveland Clinic, OH

Environment: C#, ASP.Net, ADO.Net, SQL Server 2005, Visual Studio 2005,

Visual

Source Safe, WCF, XML, XPATH, XSL, XML Spy, AJAX.NET.

Description: IML is a clinical trial application which allows the site user

to track all

study related data and assign randomized treatment type. Scope of the

project involved

creating account management system, create randomization treatment

assignment form

and maintenance screens for the specified data points to be stored in the

database. Once

the subject has been randomized trigger email notification to the Principal

Investigator

and data export process for the mentioned data points.

Responsibilities:

. Designed and Developed database based on database design standards and

normalization principles.

. Created audit trails to log changes to data in tables.

. Created triggers, stored procedures.

. Used ASP.NET built in providers for Membership, Role and Profile

management.

. Used AJAX.net control kit for creating efficient and interactive

application.

. Built business components using C#.

. Implemented two way databinding against custom business objects.

. Created a WCF service for data retrieval operatons.

Foragentsonly: Feb' 06 - Feb' 08

Progressive Insurance, OH

Environment: C#, ASP.NET, ADO.NET, Oracle, Visual Studio 2005, XML, XPATH,

XSLT, XML SPY, IIS 5.1, PVCS, Visio, Fiddler

Description:

Foragentsonly.com is a web based application dedicated to progressive

agents and

broker's to quote and manage policies as well as provide the ability to

complete

endorsements. It also provides access to tools to manage business, Billing

and Payments,

Policy Changes, Customer Policy Search, Policies Needing Services, Claims,

Agency

Admin areas.

Responsibilities:

. Delivered responsibilities as Programmer/Analyst.

. Gathered business requirements, performed analysis and interacted with

management and users at all levels.

. Designed and developed custom control library.

. Created and deployed XML web service.

. Designed and implemented custom event handlers and delegates.

. Optimized SQL queries for performance enhancement.

. Corrected Cross Site Scripting vulnerabilities.

. Document/Comment code in conformance with company standards.

Secure Policy Downloader: Sept' 06 - Mar '07

Progressive Insurance, OH

Environment: VC++, Visual Studio.net 2003, Open SSL library, Windows

Installer,

Orca, JavaScript

Description:

Progressive Policy Downloader is a windows based agency download product

dedicated

to the thousands of progressive independent agents to get updated policy

information on

daily basis through an automated scheduler so that the agency management

systems are

able to pull that information and import the policy information into their

respective

systems.

Responsibilities:

. Involved in migrating from MFC 4.2 to MFC 7.0

. Securing the policy downloader using Open SSL library.

. Created and deployed Web Services for authentication.

. Used machine hash to encrypt credentials and store it in registry.

. Package the software using Microsoft Windows Installer with the

ability to run cleanup scripts and facilitate future upgrades.

Progress: Sept '05 - Feb' 06

Progressive Insurance, OH

Environment: C#, ASP.NET, ADO.NET, SQL SERVER 2000, VISUAL

STUDIO.NET, XML, XPATH, XSLT, XML SPY, IIS 5.1, VISUAL SOURCE SAFE

Description: Progress replaces paper based insurance coverage's that need

to be filled

out manually by the insurance agents and business firms by providing an

automated and

electronic process in order to streamline and simplify all transactions

among the

connected members. Once the e -form is complete it is forwarded to the

underwriter

who decides whether or not to provide the insurance to the business, how

much insurance

and at what cost.

Responsibilities:

. Deliver a ASP.NET/C#/XML/XSLT solution to the above requirement.

. Created dynamic ASP.Net server controls using XML/XSLT.

. Transform XML Data using XSLT style sheet and generate pdf once the

process is a complete using XSL Formatting object.

. Generated XML schemas, XML Documents and style sheet using XML Spy

tool.

. Designed database schema, wrote stored procedures.

Strategic Solutions Platform Ordering Application Dec'04- Sept'

05

Verizon Communications, TX

Environment: C#, ASP.Net, ADO.Net, XML, XPATH, XSL, XMLSPY, Visual

Studio.NET,

Clearcase, SQL Server 2000, T-SQL, .NET Remoting, Windows services and

Windows XP

Description: The scope of the project is to develop a unified GUI for Call

centre Representatives

and DSL Gateway Services (which in turn interfaces with the multiple

ordering systems currently

Exist) and then eliminate many of these systems. The new system is supposed

to provide Unified

Front-end GUI that offers the management of new orders, change orders, move

orders and

terminate orders, business and consumer orders, static and dynamic DSL

orders. The SSP

Ordering application resides within the iConsole Shell container as a thick

client along with

admin thin client on a Windows based PC. Communications from the Ordering

application are

through NetRemoting / binary to the IIS Server. From the IIS server

requests and order

information are forwarded from a UI service to the Business Services

backend using a read /write

HTTP(S) connection.

Responsibilities:

. Delivered responsibilities as front- end middle tier developer.

. Involved in developing GUI and Business classes.

. Developed a windows service that periodically monitors the SSP

application

Metrics.

. Accomplished all communications using Xml.

. Extensively used XML processing API and data structures in XML

namespace.

. Actively participated in performance tuning and analysis in

conjunction with database analysts to optimize application

performance.

. Involved in developing user and custom control library.

. Implemented custom event handlers and delegates.

Automated Security Access Processing System Apr' 04 - Dec' 04

Department of Social Service, MO

Environment: C#, Visual Studio. Net, ASP.NET, ADO.NET, Visual Source Safe,

DB2,

XML web service, Crystal reports and Windows XP

Description: Automated Security Access Processing System is a web based

application that streamlines the Social Service Department data for

managing new hires, job duty changes, promotions, transfers etc with

authorization restricted to local and divisional security officers

and replaces the currently used DDP -137 and DFS-137 forms. Security

requests entered into the system will be forwarded to appropriate approval

and processing authorities and the processor and the requestor would be

notified when the request has been processed through mail. The users can

track the status at any point of time by logging into the ASAP system.

Responsibilities:

. Delivered responsibilities as Programmer/Analyst.

. Gathered business requirements, performed analysis and interacted with

management and users at all levels.

. Designed, Developed database driven web based application using C#.

NET on .NET architecture.

. Wrote Stored Procedures to extract data based on the Business

requirement with DB2 as the backend.

. Created and deployed XML web service using ASP.NET on the web server.

. Designed and Developed Reports using Crystal Reports.

.

Terminal Management System Oct' 03 - Mar' 04

International Transportation Service., CA

Environment: VB.NET, Visual Studio.NET, Visual Source Safe, SQL Server

2000,T-SQl, and Windows XP, XML Web services, .NET Remoting, Infragistics,

Winforms.

Description: Terminal Management System is a container management Winforms

Application built on N-Tier architecture to enhance terminal operations

like Gate Control, Yard, Vessel, Rail planning systems for a top notch

ocean liner companies called International Transportation Service using

state of the art .NET technologies.

Responsibilities:

. Developed GUI and Middle Tier using VB.NET on .NET architecture.

. Designed and developed Inquiry, Popup, Lookup and Multientry popup

screens.

. Designed and developed custom controls.

. Wrote Stored Procedures to extract data based on the Business

requirement.

. Involved in developing control library.

. Extensively used Infragistics control library for developing user

interface screens.

. Used Typed datasets for manipulating and passing data between forms.

. Serialized Input datasets before sending it to the remoting layer

which made calls to the Business Layer where validation was performed

which in turn made calls to the Database layer where actual database

operations where performed.

. Used utility component to maintain frequently used functions in a

central repository which comprised of security, database, error

handling, file management, formatting and miscellaneous functions.

. Maintained reference data in reference files that was cached to the

middle tier and accessed by the middle tier components through the

functions exposed in the utility component to save repeated hits to

the database for nominal amounts of static data.

. Involved in Unit testing of the system

Consultancy Management System Jan' 03 - Sept' 03

Exec Search Inc., WI

Environment: C#, ASP.NET, JavaScript, HTML, XML, XSLT, XPATH, IIS

5.0,Visual Studio .NET Enterprise Architect, Visual Source Safe, ADO.NET,

XML Web Services, SQL Server 2000,Crystal Reports, T-SQL, and Windows 2000.

Description: CMS (Consultancy Management System) is an Intranet Project

using .NET architecture for managing consultants Profiles, Skill sets,

Salary History, experience, Healthcare details, Time sheets entry and it

also consists of candidate template entry, companies requirement and

maintenance.

Responsibilities:

. Developed Server side programming using C# on .NET architecture.

. Designed and developed several user controls using .NET IDE.

. Designed and implemented custom event handlers and delegates.

. Implemented data integrity, indexes, managed transactions and locks,

views, created stored procedures and triggers.

. Establish pioneer activities in .NET related technologies by designing

infrastructure components for custom Role Based Security based on the

Generic Principal of the .NET framework, granular to the level of

methods and properties

. Custom Tracing/Logging (allowing control on what modules/service

layers to trace/log)

. Data access using Stored Procedures and ADO.NET.

. Installed / Administrated IIS 5.0 on Windows 2000 Server

. Designed and developed custom controls.

. Use JavaScript for Client side Validation and CSS for unique interface

of all HTML forms.

. Used XSL Transformations to convert XML input files into HTML through

the XML server control.

. Used XPath expressions to determine XSL contained in the conditional

element to be processed and XPath functions to change output based on

several conditions.

. Used ADO.NET to interact with SQL Server databases.

. Wrote stored procedures and queries to extract data from SQL Server.

. Generated Reports using Crystal Reports.

TTCPM (Total Time to Customer - Project Management) Feb' 02 -

Dec' 02

Exec Search Inc., WI

Environment: Visual Basic.Net, ASP. Net, XML, XSLT, Java Script, SQL Server

2000, Microsoft Visual Interdev, Microsoft Visual SourceSafe, Windows NT.

Description: Project Management System is an Intranet based Reporting

Solution which furnishes the management with project metrics in an easy to

understandable format, utilizing data in SQL Server with exceptional query

and drilldown capabilities grouped on a monthly or quarterly basis, updated

on a daily basis.

Responsibilities:

. Reviewed the user's needs, gathered requirements, and analyzed the

business processes.

. Preliminary System Analysis, design and development of GUI, and

elemental structures using ASP.Net Pages.

. Development and deployment of COM Components, and generating Excel

charts and spreadsheets.

. Developed server side scripting and client side scripting for data

validation.

. Used XSLT as an output formatter and applied set of template rules.

. Used XPath conditional expressions to identify nodes in an XML

document.

. Designed the database and developed stored procedures.

. Developed Conceptual and Logical Design documents.

. Design, development and testing of code modules.

. Created User Interface in Visual Basic for user inputs.

. Automated the process of importing of data from other systems and

Access databases to SQL Database.

Service Monitor Dec' 01 - Feb' 02

Exec Search Inc., WI

Environment: Visual Studio .NET, C#, XML, XSLT, Visio

Description: Designed and developed a highly configurable application that

monitors critical software services on Windows 2000 Advanced Server.

Besides monitoring and generating emails in case of problems the

application also attempts to restart a crashed service and in the worse

case scenario it reboots the computer. Services to be monitored their

dependencies and hierarchies are stored in XML files.

Responsibilities:

. Extensively used WMI class library of the .NET Framework.

. Used .NET Framework libraries to monitor processes and services.

. Designed a client application using which administrator can remotely

monitor the services and processes.

. Created classes for Role based authentication and authorization.

. Designed custom classes to schedule the monitoring of services.

Bladsys 2000 - News Paper Circulation Management System Jan' 00 -

Jul' 00

De Berlingske

Environment: Visual Basic, ASP, C, XML, Crystal Reports, MS SQL server,

IIS, HP-UX

Description: Design and Development of a Newspaper Circulation Management

System called Bladsys 2000. It is a newspaper circulation management system

for De Berlingske Dagblade A/S, one of Denmark's leading newspaper

publishers. Berlingske currently uses computer-based applications in a

number of areas, among which are circulation, financial accounting and

payroll. Berlingske has embarked on a downsizing and redevelopment

exercise. This involves modernizing the Circulation System. Bladsys 2000 is

aimed at developing a new Circulation System encompassing enhanced

functionality as compared to the existing Bladsys in the Unix-SQL Server

environment. Such an application system is expected to provide Berlingske a

competitive edge. Bladsys 2000 comprises three sub-systems viz. Single Copy

Sales, Subscription and Distribution. The estimated size of the project is

38 person-years with a peak team size of 25.

Responsibilities:

. Assisted Information Architect in Designing forms for the defined use

cases and scenarios.

. Studied the existing input screens and mapped them onto the

data/object model.

. Create the Analysis Model, which includes Sequence and Collaboration

diagrams.

. Developed stored procedures and triggers to enforced data integrity.

. Designed and Developed Reports for Dealer Service Module.

. Designed and developed User Interfaces.

. Involved in unit testing of the system.

. Extensively used ASP objects like Response, Request, Session and

Server.

. Developed Shell scripts.

Vehicle Movement and Monitoring System Sep'98 - Dec

'99

E.C.I.L

Environment: Visual Basic, ASP, Java Script, C++, Oracle 8.0, Crystal

Reports, WINDOWS NT, and HP-UX

Description: The main aim of the project is to make a foolproof system for

coalfields. The system involves in daily monitoring of the loaded and

unloaded vehicles from Coalfields. The system records weight of the vehicle

before and after loading and also takes information about vehicle like

(Veh.Number, Driver's name etc.,) and after which access gates are

automatically opened. The same way outgoing vehicles are also processed.

Daily, weekly, monthly and yearly reports were generated and also for the

number of vehicles stranded in at a particular time.

Responsibilities:

. Designed and developed logical and conceptual schemas for SQL Server

database.

. Designed and developed User Interfaces.

. Used UML to design Classes, developed Class Diagrams, Use-Case

diagrams etc.,

. Used Database Triggers to maintain Audit Information, Referential

Integrity etc.

. Used JavaScript for the client side validation and VBScript for Server

side validation.

. Responsible for Application Support.

Education:

M.S. (Computer Science) - Texas A&M University.

Contact this candidate