DATABASE ANALYST Resume

SUMMARY

Expert Test Analyst/Lead in Software testing and backend database testing (ETE, SIT, UAT, UCT, ORT, Regression)
Expert in Test Management
Excellent Data Analyst skill (SQL, MS Excel and MS Access) SQL Server, Access Database development
Test Planner (assessment of test level doc)
Intermediate Project Management
MS Office Expert(Word, Excel, Power point, Access)
Efficient in Production Support Roel (4+ years)
Web design (Language HTML, ASP, JS, CSS)
Expert Defect Management - Tool used: HP Quality Control and Rally
Working Knowledge of Automation Tool: WinAutomation Console, Selenium IDE
Excellent verbal and written communication skills
Problem solving skills

PROFESSIONAL EXPERIENCE

Confidential

DATABASE ANALYST

Responsibilities:

Responsible for maintaining and enhancing Access database
Maintain and optimize VBA in Excel
Refresh weekly report and publish it on SharePoint.
Prepare and publish SOP documents on Confluence (quick issue creation and reports, great for team work smarter and faster).
Big data manupulation (IDW and S3 Browser)
Refresh reporting using Automation tool (WinAutomation Console)

Confidential

SPECIALIST

Responsibilities:

Responsible for data management (MS Access, SQL and MS Excel).
Responsible for testing for a range of projects from and enhancements to strategic initiatives using Agile and Waterfall methodology.
Writing & executing test plans and scripts, documentation of test procedures and issues
Utilization of HP/Mercury QC for defect management, generating daily report and creation of various reporting and statistics throughout the UAT cycle and also using TDP platform.
Responsible for ETE testing, UAT Testing, Release Production Testing (ORT), Regression testing and UCT testing.
Design and develop database (MS Access 2000) for various (daily, weekly, monthly) status report, Adhoc reports, and defects reports.
Conducted project management work, test management work, Plan, initiate and manage information Technology projects. Lead and guide the work of technical staff, Plan project stages and assess business implications for each stage.
Monitor progress to assure deadlines, standards and cost targets are met. Generate L1, L2 report for upper management.
Prepare TCP1 Estimates (Project Estimation Cost) in Excel.
Used ALM tool for daily report generation, defect management
Used SharePoint and Rally tool for all projects documentation.

Confidential

TTECHNICAL WRITER/DATA ANALYST

Responsibilities:

Responsible for building End to End inventory for UAT testing on service delivery.
Support HP Quality Center Mercury tool (version 9.2) for UAT testing defect log and resolution.
Request and Validate required data prior to testing start.
Prepare/review test plan for End to End testing
Monitor testing defects during all testing phase under QC tool.
Maintaining release status daily.
Invent new innovation after release and implement for next release to reduce the defect, ETE test support to user from release to release.

Confidential

TEST ENGINEER

Responsibilities:

Responsible for troubleshooting of Rave application issues to all pharmaceutical customers.
Direct contact with real client while working on issues that is reported by user.
Member of CIRT 24x7 (Critical Issue Resolution Team) to handle Severity one issue, reported by user.
Worked with Business Object development team for report.
Managed hot list daily.

Confidential

System Engineer

Responsibilities:

As a system engineer, the job responsibilities include to write system requirement from user requirement (back end development work) for dev team
As a system tester, the responsibilities include to write a good system test plan and review with se and dev and once the plan is approved then write the test cases (sql script) for testing.
As a iDAT production support, the responsibilities include to monitor the production site daily that it’s up and running, create daily report of system/report status and work on trouble tickets (trouble ticket includes the work listed below:)
Investigate the data/report issue given by customer in the Oracle database
Prepare database update (remove duplicate, correct incorrect data (if main source database and replication has mismatch issue) and run the update in db.
Designed and developed databases for Voice Mail hobbling system and Technology Life Cycle. Responsibility includes creating user interface, various reports design, VB Crystal Report, forms, modules using Access 97, VB 6.0 as front end and Access 97, SQL Server 7.0 as back end.
Designed Intranet pages using HTML, ASP and VB Script to interact with Access 97 and SQL Server 7.0 databases.