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.

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.

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.

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.
• 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.
• 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.