PAVITHRA PANJALA
Norfolk, VA 757-***-****
BUSINESS ANALYST
Proactive and process-oriented Business Analyst, experience in designing, validating and analyzing data to enhance business performance. Created and maintained data reports. Excellent communication, presentation and interpersonal skills. Certified Tableau Desktop Specialist SKILLS
Databases
Tableau
Analysis
Reporting
Statistics
Communication
Presentation
Jira
MS Office/Google Workspace
Requirement Gathering
Problem Solving
Leadership
Documentation
Agile Software Development
Time Management
PROFESSIONAL EXPERIENCE
Get Tested COVID-19 2020 – 2020
Business Analyst
● Developed wireframes and use cases diagrams using Visio, based on the requirements gathered.
● Designed and developed queries, views, functions and stored procedures to work seamlessly with Appdev team’s data needs.
● Implemented SQL queries using joins and subqueries to retrieve data from database.
● Conducted weekly sprint planning meetings with developers and quality assurance team to review user stories, assign story points and remove any blockages.
● Documented functional requirements and technical specifications. Costar, Norfolk, VA 2018 – 2019
Software Developer
● Worked in Agile methodology which included daily standup, Sprint Planning, Retrospective or Backlog grooming meetings.
● Created Jira epic, stories and tasks based on the business logic.
● Generated data reports and performed data analysis using Excel to visualize the outcome to enable the team to gain insight to various parts of the business.
● Performed Data Migration on portion of the project, which included mass update of hundreds of thousands of rows.
● Implemented audits using triggers and enforced business rules via checks and constraints. Used views to prevent unauthorized access to sensitive data.
● Optimized queries, functions and stored procedures to decrease the data retrieval time and increase the performance.
ForRent.com, Norfolk, VA 2016 – 2018
Software Developer
● Developed and maintained User Account on ForRent.com website using Angular 6, TypeScript 2, HTML5 and CSS preprocessor like SASS.
● Worked with the users/stakeholders to understand the goals and objectives of the projects.
● Written Ad-hoc queries based on schema knowledge for various reporting requirements.
● Monitored and analyzed the data in terms of number of visits, sign ups and favorites.
● Fixed production issues as needed.
Old Dominion University, Norfolk, VA 2014 – 2016
Graduate Assistant
● Updated and maintained the course portal. Created assignments and exams for students.
● Assisted and monitored students in using Sharepoint, Powerpoint and MS word for their group project.
● Developed and maintained SQL objects like tables, stored procedures, triggers, functions and views for the course portal.
EDUCATION
M.S. in Computer Science,
Old Dominion University, Norfolk, VA.
Bachelor of Technology in Computer Science
Jawaharlal Nehru Technological University, Hyderabad, India. CERTIFICATES
● Tableau Desktop Specialist.
● Oracle Database 11g Administrator Certified Associate.