Sai Lahari Jalaparthi Email & Phone Number

Neenah, Wisconsin

Greater Chicago Area

• Analyzed, interpreted the extracted data and presented the insights to the non-technical team members.• Implemented new ideas such as generation of automated billing at the end of each quarter and track them. This feature has the facility to Approve or deny the bill sent. This saved a lot of time to the Administrators.• Created stored procedures, triggers and wrote functions using SQL Server. • Scheduled jobs using SQL Server Agent. • Generated reports using SQL views, stored procedures and Visual studio report builder. Few of the reports are made available to the administrators through Ad hoc methods. • Responsible for development and maintenance of database administration.• Developed website https://crosspad.ihrp.uic.edu using .Net and SQL Server.• The current motive 'DREAM PRIME' is to migrate the application http://prime.ihrp.uic.edu/CCTS/index.jsp in Java to .Net environment and integrate with CROSSPAD. • Most of the development work requires the knowledge of SQL to normalize the data, add/retrieve/update of the data.

Chennai Area, India

• ServiceNow is an ITSM tool used for the management of different process such as Incident management, Problem management, Event management, Change management and Configuration• Worked as an individual team member for this project.• Worked with the business analyst team to gather requirements and prepared the project estimation plan.• Designed, developed and implemented test plans and scripts using the business requirements document provided.• Followed agile methodology to perform the quality assurance testing.• Executed manual test cases for user stories, smoke tests and logged defects in HP Quality center.• Received appreciation from the clients for the identification of the static defects.• Assisted developers in identifying the resolution for the problems during the defect management calls. • Implemented an idea of performance testing and regression analysis and was successful.• Conducted knowledge training sessions to other teams working for the same client and performance testing team.

Thiruvananthapuram Area, India

• Online Telecom Bill Enquiry System is generation of bills based on appropriate plan and call log of customers.• Developed new layout for the generation of bills so that user will be able to pay bills online using Java, Java script, HTML, CSS and MySQL, resulting in a modular system, reducing maintenance time and cost by 30%.• Designed Class diagram or UML to describe the structure of the proposed system during design phase using Gliffy.• Designed Entity relationship diagram for modeling databases during the design phase of SDLC process.• New users signup or old users login to the system. Users view their bill online. Generated bill based on the usage and costs involved to that usage. • Implemented the user ability to pay their bills online. Appreciated by clients for the implementation of page expiration in 5 mins in the payment details page which is not specified in the requirements. • Proposed and implemented a help desk layout for resolving the user issues which improved customer satisfaction from 75% to 90% within 3 months.• Retrieved the data from the database using MySQL. Analyzed and generated reports for the daily payments.

Chennai Area, India

• Payroll Processing: Payroll run happens once in every week. Paychecks for employees are generated weekly or biweekly. There are many prerequisites for payroll run. Interfaces like person import,accruals etc should be run to import all the date required for payroll run.• All the hours the team member works are converted into appropriate pay codes ( like regular,overtime, shift differential etc ) which are multiplied by a factor during payroll to convert to dollars. In addition some taxes may be deducted, increments can be added.• Analyzed the different state rules applicable for the employee and prepared the requirements specification document that generalizes the rules. • Punch in and out were recorded in the Kronos Timekeeping and payroll processing is processed using PeopleSoft. •Testing involves if all the data is imported correctly before payroll, if the pay is generated properly for the hours worked, whether all the interfaces are run successfully. • This project was taken upon my interest and worked parallel with another testing project ServiceNow.

Master Of Science (M.S.), Management Information Systems, General, 3.91

Activities and Societies: Indian Graduate Students Association (IGSA)

Bachelor Of Technology (B.Tech.), Electrical And Electronics Engineering, 3.9

Activities and Societies: One of the event organizer for Encurso and Viswavidyala Varshika Saptaham, Technical Leader for paper and poster.