Sql Server Project

ARUNA PENTAPARTHY acsr9r@r.postjobfree.com

**** ******* ***** ** 517-***-****(Personal Cell)

Okemos, MI 48864 517-***-****(Office Cell)

* ***** ********** ** ******** development, testing, implementation, and maintenance of Web applications using HTML, JavaScript, ASP, ASP.NET, VB.NET, SQL, C#, Microsoft Visual Studio, Microsoft Visio, TFS (Team Foundation Server), Angular JS, Bootstrap, Selenium, SVN (Sub Version), JBoss Studio, as well as other web development tools at State of Michigan and IBM.

EDUCATION

Name of Institution

Program/Certificate

Lansing Community College

Computer Programmer/Analyst

Associate in Business Degree

December 2011

SKILLS & EXPERIENCE:

5 years of Comprehensive software professional experience in Programming with HTML, JavaScript, ASP, ASP.NET, VB.NET, SQL, C#, Microsoft Visual Studio, Microsoft Visio, Angular JS, Bootstrap, Selenium, SVN

Worked with MS Access, MySQL, Microsoft Server 2008, Oracle 10g and 11g as database in programming

Used communication skills for group projects

Used writing skills for project documentation

Communicated effectively with teammates in daily standup meetings, emails

Communicated effectively with users through Web meetings, regular meetings, emails

Prepared documents for functional and system designs

Tested web pages in different web browsers such as Internet Explorer, Fire Fox, Google Chrome, Opera, Safari

Used Microsoft Office with Microsoft Word, Microsoft Spreadsheet, Microsoft Access, Microsoft Power Point 2003, 2007, and 2010, Microsoft Visio 2003, 2007 and 2010

Used database tools with SQL Developer, Toad 9.6, 10.5 and 11.5

Developed programs with using IDEs such as Eclipse, NetBeans6.0, Microsoft Visual Studio 2005, 2008, 2010, JBoss Studio

Developed Crystal Reports in Microsoft Visual Studio 2010

Used Microsoft Project 2010 tool for Project Management class

Learned QTP at IBM, Load runner, QC, VBScript online in guru99.com

Professional Experience:

State of Michigan

Michigan State Police, Lansing, MI May 2015 – Present

I have been working at State of Michigan as a Java Developer using JBoss and Oracle to develop Concealed Pistol License (CPL) and Automated Pistol Registration System (APRS) applications, writing Selenium test cases with Java programming language, and writing manual test cases for users. And also have been attending Agile stand up meeting every morning with my team and client.

Concealed Pistol License

Worked with Oracle database and Java applications

Developed CPL home, CPL Search, New Application, Clerk Profile, Rapback List, Report Status, MSP Review, License Details with JBoss Studio and Oracle 10g database

Tested CPL Applications with manual/automated testing

Development Environment: JBoss Studio, Java, Angular JS, Bootstrap, Toad 10.3, Oracle 11g, SVN.

Automated Pistol Registration System

Worked with Oracle database and Java applications

Tested APRS Applications with manual testing

Development Environment: JBoss Studio, Java, Angular JS, Bootstrap, Toad 10.3, Oracle 11g, SVN.

IBM, East Lansing, MI June 2014– May 2015

Projects: Salt River Project (SRP) & Avista

I have been working at IBM as an application developer using Maximo for supporting and maintaining of asset development applications, monitoring tickets in service desk/tracker and defects in HPQC, resolving tickets, creating and maintaining Preventive Maintenance Request (PMR), updating ticket checklist with Service Desk & Chop list according to everyday standup meetings in SRP project, working in Development, Test, and Proto environments.

Development Environment: IBM Maximo Asset Development, Windows 7, HPQC, Tracker/Service Desk

State of Michigan

Department of Human Services, Lansing, MI Nov 2011 – June 2014

Developed and tested Child Care, Adult Foster Care, and Home For Aged applications in QA, DEVELOPMENT, and Production with manual testing such as unit testing, system testing, integration testing, smoke testing, and user acceptance testing

Child Care Application

Worked with Oracle database and C#.net applications

Developed Applicant, Joint Applicant, Facility, Licensee Designee, Program Director, and Add a New Person pages for Child Care Applications with MS Visual Studio 2008 and Oracle 10g database

Tested Child Care Applications manual/automated testing

Development Environment: Microsoft Visual Studio 2008/2010, C#, ASP.Net, Ajax, Toad 10.3, Oracle 11g, TFS.

Adult Foster Care Application

Developed Adult Foster Care applications – some fields with panel hide and show

Developed Applicant, Joint Applicant, Mailing Address, Facility, Licensee Designee, Program Director, Add Responsible Person, Add Administrator, and Add a New Person pages for Adult Foster Care Applications with MS Visual Studio 2010 and Oracle 11g database

Wrote test cases for all pages in Adult Foster Care Applications

Tested Adult Foster Care Applications with automated testing with regression testing with coded UI tests and spec flow

Used GIT tool for storing Adult Foster Care Testing Applications in repository and get the updates from it

Development Environment: Microsoft Visual Studio, C#, ASP.Net, Ajax, Toad 10.3, Oracle 11g, TFS.

Home For Aged applications

Developed and tested Home For Aged Applications

Have had scrum meetings in our team

Developed code to read HRMN data file and trace file to find out deleted employees for the given date and write into a file and if that file has any information write into another file with system date and run with command prompt

Development Environment: Microsoft Visual Studio, C#, ASP.Net, Ajax, Toad 10.3, Oracle 11g, TFS.

HR Turnover Report and MHR 1031 Report

Created and coded for Login, Password Recovery, Change Password, and Application Administration pages

Wrote procedures in Oracle database packages

Involved in coding and testing HR Turnover Report applications in different Web browsers such as IE, Firefox, Chrome, and Opera

Tested HR Turnover Report applications with manual testing such as unit testing, system testing, integration testing, smoke testing, and user acceptance testing

Worked with MHR1031 Report Web Development Project

Created and coded for Search page

Tested Disability Management and Incident Management to create, update, and delete an employee data and find it with last name, first name, id, and so on

Tested MHR1031 Report applications in different Web browsers such as IE, Firefox, Chrome, and Opera

Development Environment: Microsoft Visual Studio 2008, C#, ASP, Toad 10.3, Oracle 11g.

Other Assignments:

Updated the JAVA application into a Web application using JSPs and Servlets on JBoss and Tomcat server with Eclipse IDE

Developed an application in JAVA which reads HRMN data file and trace file to find out deleted employees for the given date and write into a file and if that file has any information write into another file with system date and run with command prompt

Tested AWARE application for Michigan Rehabilitation Services (DHS-MRS)

Was assigned a task to new version of AWARE application

Updated Functional and System Designs for Child Care Applications Version 2.0

Created documents with all child care applications from register to pay online for user

Created documents for LASR Meeting Minutes

Created documents for LASR new Release12 in Oracle

Tested MiSACWIS applications manually

Created a xl sheet for LASR new Release12 document in Version Manager

Michigan House of Representatives, Lansing, MI June 2011 – Aug 2011

Project:

Created website and the pages with dynamic tables with hyperlinks to retrieve data from the database

Created an application to insert data into the database which is created by current user log in and requested by selected employee

Created database queries with joining multiple tables

Created dynamic web pages

Development Environment: Microsoft Visual Studio 2005, VB.Net, Ajax, SQL Server 2008, SQL database

Michigan State Medical Society, Lansing, MI June 2011 – Sep 2011

Project:

Created a website to advertise their digital products with Visual Studio 2010 and SQL server 2008

Created master page with headers with navigation menu with sub menus and footer

Inherited other pages by the master page

Created forms to insert data into a database

Worked with VB.Net and SQL database

Development Environment: Microsoft Visual Studio 2010, VB.Net, JQuery, SQL Server 2008

Lansing Community College, Lansing, MI Jan 2009– Dec 2011

ASP.Net Project

Sports Pro project with MS Access and SQL Server databases

Created a master page and used it for all of the pages that my project has

Used extensively combo box & drop down lists to get the customers’ & technicians’ information and list boxes to show the products for the customers’ data from data base

Used grid view, details view, list view and form view to show the customers & technicians from SQL server data base

Created cart & order applications with sessions

Used object data source to store to and get from database

Used form-based authentication with adding roles, users, and access rules to access my website

Used multi view to show different pages through the main page

Used query builder, and wrote queries to get and manipulate data from the database

Development Environment: Microsoft Visual Studio 2008, Visio 2010

Advance C#

Did assignments for Object Oriented Program, User Interface, Database, Crystal Report, Web Application, Simple Chat Server applications

Learned Crystal Reports to show the data, graphs, charts, etc. from the database and used it in Assignment 4

Did a project with SQL server database and User Interface to show products in a grid view to add, update, and delete of them with each individual forms

Development Environment: Microsoft Visual Studio 2010, Visio 2010

Advanced Web Development

Involved in a group project to make a web site about how to make green money in different ways

Created a contact page form and tested our web pages with usability test in different web browsers such as Internet Explorer, Firefox, and Google Chrome

Development Environment: Microsoft Visual Studio 2008, Visio 2010

Contact this candidate