Professional Summary

• Multi-skilled IT professional and has more than 11 years of software development experience in full life cycle development using ASP.net ,Classic ASP, Sql Server 2008/2005/2000, Visual studio, Web Services,XML, XSLT ,VB 6,Oracle 8i/9i,MS Access 2000, MySQL,VB/Java Script, HTML and Com
• Strong technical background and specializes in SQL, Transact SQL (T SQL) for writing stored procedures, triggers, creating tables and indexes, Log shipping.
• Involved in development and implementation of web based and desktop applications utilizing ASP.net, Classic ASP, SQL Server 2008/2005/2000, CSS, XML, XSLT and VB.
• Strong technical background in Java script and VB Scripts
• Extensively used Stored Procedures, Triggers, Cursors, Views, Functions, Schema, SQL Profiler, Tuning, Execution Plans, and Optimizations.
• Experienced in development and maintenance of enterprise-level WEB applications
• Excellent skills in analyzing user’s requirements, modeling the system and ensuring the functionality, with client satisfaction as the strong and primary focus.
• Strong debugging and problem solving skills.
• Experience with standard software-development lifecycles and project-management methodologies such as Agile and Waterfall.
• Experience in graphical user interfaces and code development.
• Excellent Verbal and Written communication skills and Presentation skills.
• Excellent inter-personal skills, quick learner and acutance with new technologies, domains, or environments.
• Proficient in query optimization and backend performance improvement.
• Having excellent written and verbal communication skills, including team skills, shares excellent peer relationships and capabilities.
• Experience designing/maintaining Websites.
• Experience working with confidential data

Technical Summery

• Front Ends: ASP, ASP.net,.net,Visual studio
• Database: MS SQL Server 2008/2005/2000, DB2 ,Oracle 8i and 9i, Sybase 12, MS Access
• Web Tools: ASP, ASP.net, HTML, DHTML, XML, Visual InterDev 6.0,IIS
• Scripting Language: VBScript, JavaScript
• Operating System: Windows 2000/NT/ME/98/95,XP

Projects Summary

Confidential,State of Missouri June 2011 – Present
Role: Team Lead /Sr. Programmer Analyst
Stake holders: DSS

Disaster Food Stamp: Worker and Client portal:
The Disaster Food Stamp web pre-application is utilized to collect the applicant’s pre-application information for the Disaster Food Stamp Program. When there is a disaster declared, the state may implement the Disaster Food Stamp Client Portal web pre-application system. This pre-application will be used for applying for disaster benefits for federally activated disaster periods such as hurricanes, tornadoes, storms, floods, snowstorms, drought, fires, explosions or other disasters. This pre-application information will be accessed by the worker while interviewing the applicant for Disaster Food Stamp benefits and used in decision making to determine eligibility for those people who live or work in the disaster area
Food Stamp web application:
The Food Stamp web application will provide a new intake interface application to deliver the DSS modernization effort of application components. The current MO Health Net web application will be modified to add Food Stamp web pages and attributes. This modified web application will enhance the agency’s current Family Assistance Management Information System (FAMIS).
From the perspective of DSS eligibility workers, this web application will provide increased efficiency to the application process by reducing the amount of time workers spend keying client information into the computer. Less keying of data will reduce data entry errors and create more time for eligibility workers to focus on the business. The Food Stamp web application will be available in English and Spanish.
Responsibilities:-

• Designed and Developed GUI for Disaster food stamp applications Worker and Client portal.
• Create and update new and existing stored procedures.
• Involved in system UI design and database table creation.
• Created mockup screens for Disaster food stamp applications.
• Perform bug fixes as problems are discovered by the testing team and clients.
• Routinely participated in project meetings.
• Created Multilanguage, English and Spanish, in Food stamp and Disaster applications.
• Created tables, Wrote complex stored procedures, queries,

Technical Skills: ASP.net,Classic ASP, Sql Server2008, Web Services, XML, XSLT, Visual Studio 2008, JavaScript, HTML, CSS.

Professonal Experience

Confidential, Aug 2009- May 2011
Role: Team Lead /Sr. Programmer Analyst
Stake holders: Administrative Information Services (AIS), Registrar Office (RO), Office of International Students and Scholar (OISS), Dept.of Archives

Office for International Students and Scholars (OISS)
OISS info is a web based application used to maintain data MSU’s international students and exchange visitors data. OISS has identified lots of system enhancements for OISS Info that will resolve cumbersome areas of the system or provide efficiencies in their processes. That list has been prioritized based on effort estimates and impact to the business processes. SEVIS (Students and Exchange Visitor Information System) is a federal (set up by INS) internet based application for tracking and reporting foreign students and exchange visitors in the United States.
Responsibilities:-

• Team Lead and Primary resource for SEVIS (Student and Exchange Visitor Information System), OISS Info System applications, System Enhancement, SEVIS II.
• Interfaced with business users (Clients) to prepare and updated Business Process Requirements and Software System Requirements.
• Designed and developed J-1 Department user interface and database in ASP and SQL Server 2005.
• Updated System Change Request forms for OISS Info.
• Designed and Developed GUI for J-1 Department,OISS INFO using in ASP, XML and HTML
• Support and assist with the user acceptance testing (UAT) process to assure the successful delivery of all modules to the client.
• Designed the Database and tables for J-1 Department. Create new tables, updated current tables, Views, Stored procedures and triggers for OISS INFO in SQL Server 2005.
• Involved and maintained SEVIS application, for tracking and reporting foreign students and exchange visitors, in XML and VB 6.
• Project tracking, Team coordination, Status reports to the Project Lead and project manager.
• Perform bug fixes as problems are discovered by the testing team or customers.
• Managed work orders and provided customer supports.

The Office of the Registrar (RO) : - The Registrar’s Office collects, maintains, preserves, and distributes academic data with accuracy and integrity while maintaining and enforcing the standards set by federal and state laws and University policies and procedures. The Office of the Registrar is an academic service unit committed to the support of the teaching, research and service foci of Michigan State University. The RO recognizes the populations it serves and strives to provide responsive and professional support and access for students, faculty, staff, and the public.
Responsibilities:-

• Involved in STARR (Student Transcript and Academic Record Repository) Application, used VB 6 to create students XML file.
• Updated MSU’s Summer Study web site,
• Added more functionality to the Enrollment & Registration and Course scheduling web applications.
• Involved in GRADINFO system UI design and database table creation.
• Gather and document end-user needs and requirements and prepared design documentation: Work Flow, Process Flow diagrams for GRADINFO System.
• Routinely participated in project meetings.

Confidential,MSU
Spartan Archive Project an electronic record archive at MSU to develop an electronic records archive for the university’s born-digital records and publications.
Responsibilities

• Team Lead for Spartan Archives projects’ database design team.
• Conduct and participate in software design reviews to assure that the best technical approach and solutions are identified before starting the coding phase.
• Prepare and maintain user and system documentation.
• Support and assist with the user acceptance testing (UAT) process to assure the successful delivery of all modules to the client;

Technical Skills: Classic ASP,ASP.net, SQL 2008/2005, XML, XSLT, Visual Studio Interdev, VB 6, VBScript, JavaScript, HTML/XHTML, CSS, IIS 6.0

Confidential,State of Georgia April 2004- May 2009
Role: Team Lead/Programmer Analyst
Project Name: Higher Sight (JTS), LSTS, SMS, HRTS and DJJ website

Georgia DJJ provides supervision, detention and a wide range of treatment and an educational service for youths referred by the Juvenile Courts, and provides assistance or delinquency prevention.

Higher Sight (Behavior Management System)
Behavior Management System, it’s specifically designed for staff to reward Youth for positive behavior and assist in correcting negative behavior. This process includes regular evaluation of youth\'s behavior in the YDC during class periods and dorm in the evening and subsequent reinforcement of the positive behavior with purchasing privileges of listed items with in the week from YDC store.
Responsibilities:-

• Project Team lead for Higher Sight
• Interfaced with business users (Clients) to prepare and updated Business Process Requirements (BPR) and Software System Requirements (SSR).
• Conduct and participate in software design reviews to assure that the best technical approach and solutions are identified before starting the coding phase.
• Prepare design documentation: Work Flow, Data Flow, Process Flow diagrams
• Designed and Developed GUI using Web forms in ASP and HTML.
• Designed the Database and tables for HS Application. Created tables, Views, Wrote complex stored procedures, queries, triggers for HS in SQL Server 2005.
• Applied change requests, versions, and addendums.
• Support and assist with the user acceptance testing (UAT) process to assure the successful delivery of all modules to the client.
• Conduct and participate in the peer review and code walk-through process;
• Project tracking, Team coordination, Status reports to IT Director.
• Managed work orders and provided customer supports.

Juvenile Tracking System (JTS) is an Enterprise Web application that assists DJJ staff to maintain juvenile records, their mental and behavioral health, legal, behavior, case worker tracking, and dashboard reporting.
Responsibilities:-

• Responsible for analysis, development & delivery of enhancements in legal, placement and services modules of JTS.
• Managed DJJ work orders on various JTS modules and provided customer supports.
• Comprehensive report generation on various JTS modules

Legal Service Tracking System (LSTS)
In line of a monitoring system for Legal Director to keep track of requests and correspondence that comes through his/her office (i.e. record requests, Litigations etc.) whom was assigned and the status.
Responsibilities:-

• Team lead for Legal Services Tracking System.
• Determined user/business/functional requirements.
• Designed the Database and tables for LSTS Application. Created stored procedures, queries, triggers.
• Designed and Developed GUI for LSTS using Web forms in ASP and HTML.
• Wrote complex stored procedures, queries, triggers. And managed index and jobs.
• Created e-mail based notification system for activities of concurrent managers

Stores Management System (SMS)
The Stores Management System allows for the tracking of perpetual inventory located in DJJ warehouses and storerooms at DJJ facilities. The system is designed to track expendable Inventory items.
Responsibilities:-

• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams.
• Conduct and participate in software design reviews to assure that the best technical approach and solutions are identified before starting the coding phase;
• Team lead for SMS
• Designed and Developed GUI for SMS using Web forms in ASP and HTML.
• Designed the Database and tables for LSTS Application. Created stored procedures, queries, triggers.
• Participated in project meetings; accustomed to working with management, coworkers and diverse clients.
• Support and assist with the user acceptance testing (UAT) process to assure the successful delivery of all modules to the client.
• Project tracking, Team coordination, Status reports to IT Director
• Conduct and participate in the peer review and code walk-through process;

HR Tracking System (HRTS)
It’s specifically designed for to track employees Performance Appraisals, Personal Actions, Positions & Salary, Payroll, and Leave.
Responsibilities:-

• Prepare design documentation: Work Flow, Data Flow, Process Flow diagrams
• Designed and Developed GUI using Web forms in ASP and HTML.
• JavaScript and vb script are used extensively for client side validations.
• Perform bug fixes as problems are discovered by the testing team or customers;
• Prepare and maintain user and system documentation when applicable;

Environment:Classic ASP, SQL 2005/2000, XML, Visual Studio Interdev, VBScript, JavaScript, XML, HTML, IIS 6.0

Confidential,Dayton OH Jan 2003- Mar 2004
Role: Sr.Programmer Analyst
Project Name: Document Management System, EMR System

Document Management System
Involved in the development and testing of the Document Management System developed for Atreya Health Technology, Dayton, OH. This system (DMS) will provide a platform to allow managing all patient related documents in one place and also it supports storage and retrieval of MSWord Files, Excel Files, GIF, JPEG, PDF binary formats. The system will access to the data using a role-based security with the HIPAA privacy standards.
EMR System
Involved in development and testing of the EMR system, developed for AHT Technology,Dayton OH. This system is designed for, the physicians; to store their patient’s medical and personal details in a CD or smart card in the encrypted format.

As a Programmer/ Analyst, involved in

• Working with the client and coming up with clear requirements.
• Design and Develop front end GUI using Web forms in ASP and HTML
• Designing the Database, Stored procedures and triggers in SQL Server 2005, SQL Server performance optimization.
• Development of a project plan
• Experience HTML, SQL 2000, DHTML.
• Database management was done.
• JavaScript and vb script are used extensively for client side validations.
• Involved in complete Lifecycle Development using ASP, VB Script, Visual Studio Interdev and Java Script
• Conduct and participate in software design reviews to assure that the best technical approach and solutions are identified before starting the coding phase;
• Solving the technical issues within the project.
• Ensuring quality control in the deliverables
• Code Review
• Perform bug fixes as problems are discovered by the testing team or customers;

Environment: ASP, SQL 2005, Visual Studio Interdev, XML,XSLT,Visual Basic 6.0, VBScript,JavaScript, HTML, IIS 6.0

Confidential,Dayton Feb 2002 –Dec 2002
Role: Sr. Developer
Project Name: Online Shopping System and Online Classified System:

Online shopping system
Worked as a developer and involved in analysis, design, development, testing and implementation of an online shopping system. The major sessions of the projects were User manager, Search manager, Shopping cart and Order processing.

Online Classified System
Was involved in the analysis, designing, implementing of the Online Classified System.This system was designed for publishing advertisements of items to sell. It’s a generic system and there are two types of users. Users looking for publishing advertisements and Users looking into advertisements for buy items. This system was multi- tier architecture. In web page designing ASP used for creating HTML pages. MS-SQL Server 2000 as the backend. COM used as the middle tier. JavaScript and vbscript used for the client and server side scripting. Using Ado’s to connect the database via ODBC connectivity.

As a Developer, involved in

• Developed a clear Requirement document for the system.
• Developed the design documents for the system
• Developed the application using ASP, VB, Java scripting, HTML, DHTML
• Design and Developed GUI
• Extensively used dataset objects for data retrieval from the database.
• Involved lot of interaction and communication in the entire project lifecycle.
• Modifying and adding to web-based products to meet customer needs using MS Visual
• Studio/InterDev
• Solving the technical issues in the project
• Code Review

Environment: ASP, SQL Server2000/7, Visual Studio,XML,XSLT, VBScript, JavaScript, , IIS
6.0, Microsoft Windows 2003, HTML

Education Summery

• Bachelor’s Degree in Math’s
• Post Graduate Diploma in Computer Application