Sibani Agrawal, Report Writer, ISTQB, PSM
Email: ******.*******@*****.***
Mob: 775-***-**** / 847-***-****
EXPERIENCE SUMMARY:
Having more than 7 years of experience in the IT Industry playing multiple roles. Hands on experience with Workday Report writer, Calculated Fields, Advance Reporting and Analytics.
Working knowledge of programming languages such as C#, C++ & Python, HTML, JavaScript, PHP Hands on experience with Power BI, Tableau, SQL Language, Visual Studio, VB.Net (MVC) Good understanding of Object-Oriented Programming concepts, SDLC, STLC Process. Familiar with Defect Management Process.
Hands on experience with excel macros, VLOOKUP, HLOOKUP and other functions. Proficiency with Agile, JIRA and Quality Center, GIT Good experience with requirement gatherings, creating functional and technical specs. Excellent communication skills and ability to work individually and as a team member. A quick learner and adapts to unfamiliar environments easily. PROFESSIONAL TRAINING/CERTIFICATIONS
Completed professional training as Report Writer, Calculated Fields, Advance Reporting and Analytics in Workday.
Completed Power BI Training from Microsoft.
ISTQB Foundation Certified by ISTQB
Professional Scrum Master (PSM) Certified
Completed professional training for Software Testing Course from CegonSoft Pvt. Ltd. Bangalore. Completed professional training for QTP testing tool. PROFESSIONAL EXPERIENCE
Working as Business Data and Systems Analyst with University of Nevada, Reno from August 2022 to till date.
Worked as Business Process Analyst with State of Nevada, Carson City from May 2019 to August 2022.
Worked as System Analyst in Sonata Software PVT LTD, Bangalore from May 2011 to March 2013. Worked as QA Executive in BigFlix, Reliance Big Entertainment, Mumbai from October 2010 to Jan 2011.
EDUCATIONAL QUALIFICATIONS
IOT Specialist degree (2019-2021) from Nevada Technology Academy affiliated to Multnomah University.
Bachelor of Technology in Electrical Engineering (2003-2007) from GHITM affiliated to BPUT (Biju Patnaik University of Technology).
PROJECT DETAILS:
PROJECT #1: VPRI Business App, Workday & Tableau, University of Nevada PROJECT DESCRIPTION:
VPRI (Vice President for Research and Innovation) Business Applications is one of the largest applications used in UNR to maintain Proposals, Awards, and Grants data. The application provides multiple reports that is consumed across different business units in UNR including the HERD report that is being sent out to NSHE (Nation System of Higher Education) RESPONSIBILITIES:
Generating standard and special reports as per business need such as HERD Survey, NIH, Fiscal Year Annual reports, Calendar Year Reports, SEFA (Schedule of Expenditures for Federal Awards) Reports, Award & Grant Recognition Report.
Creating custom advanced workday reports.
Generated Monthly/Yearly Graph in Tableau and send to all stakeholders.
Internal application development, support, data extraction and analysis.
Developed views and queries to maintain the application.
Working with end users to determine strategies and operational needs.
Involve in requirement gathering, user interaction and generating the report as per their requirement.
Modifying and maintaining the console batch application.
Working as a database administrator to optimize the database, do backup and recovery.
Migrated data from workday to VPRI as per business need. PROJECT #2: UNITY, DCFS (State of Nevada)
PROJECT DESCRIPTION:
The UNITY (Unified Nevada Information Technology for Youth) system is a comprehensive state-wide child welfare and juvenile justice case management tool that is used to submit adoption and foster care information to the Administration for Children and Families. The UNIITY system is designed to support the following business functions: Intake, Investigation, Case Management, Eligibility Determination, Adoption, Staff Management, Juvenile Justice, Treatment Services, Provider Management, and Payment Processing along with batch reporting features. It is used throughout Nevada by almost 2500 active users.
RESPONSIBILITIES:
Analysing and Understanding the Business Requirements, involve in user interaction.
Creating the Functional and Technical Specifications.
Executing SQL Queries and report analysis.
Identification of Test Scenarios and preparing & executing of Test Cases.
Performed the defect management process and Root Cause Analysis.
Integration and Regression testing of the application
Using excel functions as per need.
Involved in Integration and regression testing of the application. PROJECT #3: IRIS, Sonata Software Pvt. Ltd
PROJECT DESCRIPTION:
The IRIS system is the J&J global standard system enabling key ITIL (Information Technology Infrastructure Library) service support, operations and management processes that are executed worldwide by J&J I/T personnel and suppliers and used from any location at which J&J I/T delivers or manages I/T services. The following processes are supported by the IRIS system: Incident, Problem, Change, Knowledge, Configuration, Service Request Management, CAPA (Corrective and preventive action) and Reporting.
RESPONSIBILITIES:
Analysing and Understanding the Business Requirements, involve in user interaction.
Creating the Functional and Technical Specifications.
Executing SQL Queries and report analysis.
Identification of Test Scenarios and preparing & executing of Test Cases.
Performed the defect management process and Root Cause Analysis.
Integration and Regression testing
Modifying existing SQL Views based on the business need.
Working with Excel macros and VLookup to search and map the data as per requirement. PROJECT #4: Phone Backup, Sonata Software Pvt. Ltd PROJECT DESCRIPTION:
Phone Backup Solution (VoxBackup) brings to wireless carriers, service providers, and handset vendors the most comprehensive Over Air Phone Backup solution. Easy to use, all functionalities are accessible either from phone application or Self-care Web Interface. Strengthening the subscriber relationship by giving simple but powerful tools to safely copy and recover his personal data, VoxBackup brings to service providers new revenue opportunities.
RESPONSIBILITIES:
Involved in Installation, Feature, Regression, cross-release, and multi-platform testing in a product test phase.
Preparing & executing test cases for new features introduced as per the traceability matrix.
Integration and Regression testing of upgraded applications.
Performed the defect management process and Root Cause Analysis.
Generate test reports and QA matrices and send them to all stakeholders in time. PROJECT #5: BigFlix VOD, Reliance Big Entertainment -BigFlix Pvt. Ltd PROJECT DESCRIPTION:
BigFlix VOD is one of the largest Video-on-Demand websites that provides a personalized movie watching experience and a whole new dimension for users across the world with utmost convenience anytime anywhere. The website includes easier navigation and more user-friendly and interactive features. The Flash player is integrated and works from different countries thereby displaying the content specific to the user location.
RESPONSIBILITIES:
Involved in testing the website using different browsers.
Preparing & executing test cases for new features introduced as per the traceability matrix.
Integration and Regression testing of upgraded applications.
Perform the defect management process and Root Cause Analysis
Analyse Defect Reviews and perform the retesting for confirmation once these get fixed.
Generate test reports and QA matrices.
I hereby declare that the information furnished above is true to the best of my knowledge.
(Sibani Agrawal)