55
Resume:
SHREERUPA K. BHATTARAI
**** ***** *** **. *********** VA 20121
***********@*******.***
Summary:
Certified Microsoft User Specialist with strong Business & Data Analysis and Data testing skills using SQL and EXCEL. Has hands on experience with multiple databases like MySQL, Vertica, MS Access and designing reports using MS Access along with good understanding of SDLC. Exposure working in different ticketing system and generating different ad-hoc/scheduled reports. Has solid experience using advanced Excel functions – Pivot Table, V-lookup, MACROS, Charts, Word, Excel, PowerPoint etc. Strong background in Defect tracking software, JIRA and Centralized Document Repository, Confluence and SharePoint and is seasoned in Agile Software Development Methodology and is comfortable with Manual Testing, Data Testing and Sanity Testing Exposure.
Employment Records:
Engineering and Materials (EM) Tech. 04/2014 - 02/2017
Data Analyst
Manassas, VA
Gathered requirement from different stakeholders and documented Business Requirement Document.
Documented Technical Specification Document based on the Business Requirement Document and provided necessary walkthrough to development team.
Documented test cases and conducted multiple review sessions to finalize it.
Identified existing data sources and performed its mapping to different fields in the tool and database.
Worked on projects and teams that required proficiency on data related tasks and ensured that all types of data issues are investigated and resolved.
Created ad-hoc and canned business reports in MS Access and provided needed walk through to the SME.
Created customized charts using Excel on ad-hoc and or regular basis.
Performed data testing of the calculations/formulae used in reports, manually by running SQL in MS Access, MySQL and SQLSERVER database.
Performed data validation using SQL in MS Access/ MS Excel and confirmed if the implementation is as per the requirement specifications document.
Performed data analysis using advanced excel functions like v-lookup, pivot tables, charts, excel macros, etc. and reported the findings to the team.
Documented data mapping and transformation document for ETL process.
Validated SQL scripts used in ETL process as part of ETL/data testing.
Migrated data between different databases and across different servers and documented data migrations specifications.
Performed data clean up, formatting and calculation by recording and using macros in excel.
Attended software project kickoff meetings and gathered requirements.
Created requirement traceability matrix (RTM) and worked together with Business Analyst Lead and QA lead on its approval.
Worked with QA Lead to finalize the test plan.
Performed data analysis and confirmed if the data is as per the requirement.
Executed manual testing on QA environment, UAT and Production environment as per the schedule.
Conducted UAT by providing walkthrough of UAT documentation and following UAT schedules.
Compiled all the issues found during the testing and reported to the project manager and the team.
Worked with project manager to define the severity of the issue.
Performed sanity testing of the software whenever the new build was released.
Assisted support team to confirm if the issue raised by the customer is a real issue or not.
Compiled actual work schedule data from the field engineers and forecasted weekly work schedule.
Compiled, reviewed and uploaded all the technical and business specification in centralized document depositary, Confluence and SharePoint.
Documented work process flow using Visio and conducted walkthrough to the team member.
Monument Parking Inc. 11/2009 – 2/2012
Analyst
Washington, D.C.
Organized and maintained employee information in the company database.
Maintained and reviewed the company documentation in centralized document depositary.
Entered client’s information and their respective request in the company database.
Extract report of existing and potential clients from company database and route it to sales team member to reach out.
Maintained and extracted the list of clients that are soon to end the yearly/monthly contract and worked with sales team member to retain them.
Gathered monthly, quarterly and yearly transaction report from the database and distributed to the senior management.
Extracted the transaction comparison report of the past year and compared it with the present number to see company’s current progress.
Created ad-hoc Excel Chart based on the transaction data and drafted PowerPoint Slides for the presentation.
Created workflow of the process using PowerPoint/Visio.
Deployed on different roles as per organization’s need.
Law Office of Romney Wright (Immigration Law) 04/2008- 05/2009
Administrative Assistant/Office Secretary
Entered new employee and client information into the system.
Validated and input required data on office's database.
Generated and validated scheduled report.
Organized documents in Document Control Center.
Strictly adhered to company guidelines and procedures.
Computer Skills:
Operating System: Windows (7, XP, 2000, Vista), Mac
Database: MySQL, Vertica, SQLSERVER, MS Access
Software: Microsoft Office (Word, Excel, PowerPoint, Outlook) including office 365, JIRA, Confluence, SharePoint, Tableau, Bugzilla, Google Shared Drive, Visio, etc.
Certified- Microsoft User Specialist
EDUCATION:
Bachelor’s Degree in Sociology - Tribhuvan University Graduated - 2006
Selenium Web Driver and Core Java (Online Class)
Ongoing (Currently enrolled while in the maternity leave)
Contact this candidate