OBJECTIVE:

Seeking a challenging career in the field of SQA/Data Analyst, that utilizes my background and experience in software engineering and project management skills.

SUMMARY:

• About Eight years of professional experience as a SQA/Data Analyst including data collection, analyzing, and delivering statistical reports to end users.
• Experience working with large volumes of complex Internet log data, mobile data, web census data.
• Solid technical working experience with relational databases and SQL, comfortable running fairly complex SQL queries.
• Experience in data quality check using different methodologies and build visualization for data analysis.
• Experience in preparing test plans, test cases and automated test scripts.
• Expertise in carrying out integration testing, regression and system testing in software development life cycle (SDLC) testing.
• Experience working in Agile methodology. knowledge of SAS programming, data processing, data collection, quantitative and qualitative data analysis
• Knowledgeable in contemporary QA/test principles, methodologies and techniques in regards to black box testing, regression testing and test automation.
• Worked closely with senior level executives and product users to continually provide updates regarding new product features and to further support client relationships.

TECHNICAL SKILLS:

DATABASES: SQL Server, Microsoft Access

REPORTING TOOLS: MS Excel, Sportfire

TESTING TOOLS: soapUI, Mercury Interactive s Test Director 6.0, Quality Center 8.2, Winrunner 7.0, QTP, Loadrunner

TRACKING TOOLS: Quality Center, Clear Quest

LANGUAGES: Basic Java, C, C++, VB script

OPERATING SYSTEMS: Windows 2003/XP/2000/NT/98, UNIXOTHERS: MS Office, MS Excel

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Analyst

• Improved and implemented model monitoring process on Confidential 's credit risk capital models using complex SQL queries .
• Conducted back testing using SQL , benchmarked, and sensitivity analysis during bank’s internal model monitoring procedure in SAS .
• Validated wholesale models' production data using SAS to support wholesale capital team's monthly model calibration.
• Maintenance of large data sets, Extracting data from various databases using SAS.
• Adhoc analytical project to design a process where the existing model testing procedure to be migrated into an environment where the Bank's on - balance sheet data is stored at .
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.

Environment: Tableau, SQL, SAS, Quality Center, JavaScript, Excel

Confidential

Senior Data Analyst

• Created detailed and high level test plans, for testing custom and functional enhancements for major Managed accounts.
• Successfully used Agile/Scrum Methodology , worked closely with in a cross-functional team with product owner and developers.
• Automated the Managed Accounts workflows using Tidal Scheduler .
• Automated test cases with Selenium WebDriver using Java programming language and provided rapid feedback when team was implementing Continuous Integration.
• Tested several rollout projects for 401k providers (including Fidelity, Aon Hewitt, XEROX, JPMorgan, Mercer etc). Worked directly with customers on rollout integration testing.
• Delivered Customer commitments for Integration testing, UAT with focus on high quality and customer satisfaction.
• Worked on monthly and quarterly release testing, and executed regression scenarios using selenium
• Good knowledge and hands on experience on Quality Center and Tidal Enterprise Scheduler .
• Expertise in MS SQL Server , XML. Developed SQL scripts for various automation tasks.
• Extensive experience in bug tracking databases Clarify and Team Track.

Environment: Selenium, SQL, Perforce, Jenkin, Quality Center, Tidal, Team Track, JavaScript

Confidential, San Francisco

Senior Data Analyst

• Working on data migration from Mycustomer view to ICIS application.
• Performed Web Service testing using soapUI.
• Created automated test cases using Data Quality Engine for the nightly regression environment.
• Developed SQL scripts for data validation.
• Wrote SAS programs to performed ad-hoc analysis and data manipulation.
• Maintained system metrics to track trends in usage and data integrity.
• Instrumental member in the support during the monthly production release.
• Interacted with developers to understand the required functionalities.
• Reported bugs using Quality Center test management tool.

Environment: SQL, Excel, SAS, SoapUI, Oracle, Toad, Quality Center, Excel, JavaScript

Confidential, Sunnyvale CA

Data Analyst

• Validated compatibility issues when Oracle database was migrated into Netezza, verified backend data using SQL queries.
• Worked on Netview Front Report, validated front end data using SQL scripts.
• Verified Cognos front end GUI application using SQL queries.
• Worked on Page Edit Project, developed SQL scripts for Verifying url instance and pageview instance from meter data.
• Worked on MAC meter project, analyzed statistical trends and created reports.
• Monitored daily trending analysis data using Spotfire.
• Worked on ATPLAN Product, gained complete understanding of the application.
• Worked on Meter and Loader projects and performed trending analysis.
• Worked on Client Inquiries.
• Analyzing datasets and generating statistical reports using SAS
• Participated in preparing Test Plans.
• Trained data analysis beginners to improve overall efficiency of department.

Environment: SQL, SAS, Excel, DB Visualizer, J2EE, Oracle 8i-9i, JavaScript, HTML, Web logic 6.0, Quality Center 8.2,