JANAKI VENKATESH

E-mail: adzt1v@r.postjobfree.com; Phone: 703-***-****

PROFESSIONAL PROFILE

IT Professional with over 14 years of experience in Software Testing, Software Development, Project Management, Business Systems Analysis and Data Analysis seeking a suitable role and available immediately.

EDUCATION

M.S. (Computer Applications), Bharathidasan University, India.

Bachelor’s in Commerce, Madras University, India.

CERTIFICATIONS

Advanced Diploma in Systems Management, India.

Diploma in Internet Technology, India. Certified Scrum Master (CSM).

Python Programmer, Data Camp (2019)

Mountaineer · 39 badges · 45350 points in Salesforce (2020)

Google Certified Data Analytics Professional (2023)

TECHNICAL SKILLS

Tools: Selenium, QTP 6, Quality Center, Clear Case, Clear Quest, MS Visio, Ontime, JIRA, Hotgloo, Tableau.

Languages/Web Technologies: VB 6.0, Java, ASP, Cold Fusion, Vbscript, JavaScript, R Programming.

ETL Tools: Informatica Power Center 8.6, Power Exchange 8.6.1.

Data Modeling: Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions).

Databases: Oracle 9 / 10g, SQL Server 2008 R2 and MS Access, AWS-BigQuery.

Operating Systems: Windows 95, 98, NT, 2000, XP, Windows 7, MS DOS, UNIX

SDLC Methodologies: Waterfall, RUP, Iterative, Agile / Scrum.

DOMAIN SKILLS

Worked with SQL Server, Oracle & MS Access, Big Query Databases to the extent of creating tables, importing & exporting data, creating datasets and writing queries

Experienced in Manual Testing (Unit, System, Regression, Integration & User Acceptance testing), defect tracking, planning, writing, organizing and executing test cases

Excellent exposure to Automated Testing tool – QTP, Selenium

Good at Data Import, Data Cleaning, Data Exploration, Data Analysis and Data Visualizations

Managed teams of QA Engineers and Helpdesk Engineers

Gathered requirements, performed Gap Analysis and developed Use Cases

Skilled in Change Management, Process Improvement and Web Services Development

Well-versed in Client-Server & web applications development using Visual Basic, Java, HTML, JavaScript, Vbscript, Cold fusion and ASP

Google Certified Data Analyst, Coursera October 2022 to March 2023

Capstone Case Study: Bellabeat – Smart Device Data

Smart Device Data Analysis: Bellabeat, a high-tech health focused smart device manufacturer wants to analyze their device usage data to gain insights and provide recommendations on how these trends can inform their marketing strategy.

Understood business task to search for usage pattern of their smart devices to gain insights that would better orientate marketing decisions.

Imported Fitbit device data, performed Sorting, Merging, Parsing, Formatting and confirmed the usability of data using R, Excel.

Performed data analysis, projected graphs and shared recommendations using R.

Practiced generating graphs using analyzed data in Tableau.

PROFESSIONAL EXPERIENCE

Lead / Senior QA, Neighbor works America, Washington DC March 2008 to June 2014

Projects: LEAP & MYNWL April 2012 to June 2014 1. Learning and Events Administration Platform (LEAP) will meet the Training Division’s business needs and supports NeighborWorks America’s line of business evolving needs. The new system will be a centralized web application for corporate-wide accessibility.

2. My NeighborWorks Learning (MYNWL) provides information on NeighborWorks Training Events, Virtual Classroom courses and eLearning courses, allows registering online and accessing eLearning / Virtual Classroom courses.

Created Test Plan and managed testing efforts following Agile Framework for each sprint cycle

Trained, provided vision, technical leadership to a small team of software QA engineers

Created and managed wireframes in Hotgloo for core and missing requirements

Performed Unit, System and Regression testing to confirm system is per design specifications

Created, Assigned, Maintained defects in JIRA.

Led Daily Scrums, Sprint Planning, Review & Retrospective sessions

Maintained product backlog, Defects backlog and generated progress reports

Worked with Product Owner to prioritize tasks in Gantt chart and helped with Product Demos

Facilitated UAT workshops and Release Planning sessions

Worked with Stake holders for Data clean up and Data migration issues

Provided production support as needed

Key Accomplishments:

Led the PeopleSoft integration effort successfully.

Reorganized the requirements change management process by introducing numbering /color coding techniques to identify change requests and pending development / testing tasks

Strategized maintenance of test data for each sprint cycle by implementing time saving methods

Environment / Tools: Visual Studio 2012, MVC 4.0, NET 4.5, SQL Server 2008.

Projects: NCHEC & NIS January 2011 to December 2011

1. National Homeownership Education & Counseling is a corporate application which facilitates Certification enrollment, candidate certification maintenance using continue education process.

2. National Industry Standards provides set of guidelines for quality homeownership and counseling services. Industry professionals who adopt these standards can be trusted to provide consistent, high quality advice.

Created Test Strategy Plan and led Kick-Off and Review meetings

Planned & managed all testing related activities for the entire Program

Created and enhanced Test Cases, Test Scripts and execution of the scripts and scenarios

Acted as a Subject Matter Expert for NCHEC and NIS programs

Created complex queries to validate report results

Maintained / Reported test defects every week by generating defect report

Managed Stakeholder expectations by presenting test results and findings on a weekly basis to Project sponsors and Business users

Coordinated project activity, facilitated project meetings with inter-functional teams

Environment / Tools: Visual Studio Ultimate, .NET 4.0, SQL Reporting Services, SQL Server 2008.

Project: GrantWorks January 2009 to June 2014 GrantWorks is NeighborWorks America’s online grant application management system. Grantees submit application requesting grants. Grantor will use this application to review, evaluate submitted applications. Approved applicants receive grant assistance using PeopleSoft funding process.

Organized Training sessions for stakeholders to use the Grant Applications system

Created Test plans, Test cases and conducted various types of testing on Grant Applications created by Third-party Vendor

Monitored and provided support to Vendor for defect fixing using Projectrax tool

Led End to End testing for upgrading GrantWorks from ASP to .Net

Environment / Tools: .Net4.0, Sql Server 2008, Integrated with PeopleSoft, Datasync.

Project: Changepoint April 2010 to August 2012 Changepoint is a commercial off-the- shelf web application by Compuware. It is a single integrated system that enables divisions and departments within the organization to manage core work processes, tracks effort for projects, process and request driven work.

Led the Development effort of the application for different modules

Developed various custom reports for several branch offices of the Organization

Configured the request module to manage and track various divisions’ requests

Created annual surveys for 5 districts

Prioritized & resolved issues for support team in a timely manner

Projects: TEAM & TEAM Online March 2008 to June 2012 1. Training Events & Activities Management will meet the Training Division’s business needs and supports NeighborWorks America’s line of business evolving needs.

2. Training Online Registration provides information on NWA Training Events, Virtual Classroom and eLearning courses, allows online registration and access to eLearning / Virtual Classroom courses.

Led testing efforts for eLearning and Virtual classroom modules

Created System Test Plan and updated Project Management Plan for test schedule

Conducted System, Regression, Integration and reported defects using Ontime

Facilitated UAT sessions, helped Stakeholders with data clean up and migration for release

Wrote complex queries using SQL to confirm reports

Updated production database for data-related issues

Environment / Tools: Visual Studio.NET 2003, MS Visio, SQL Server 2000, Crystal Reports 8.0, ASP

Lead Tester / Analyst, Fannie Mae, Herndon, VA November 2006 to December 2007

1.FIN46 CCI Centralized Consolidation Indicator will develop an automated counter for percentage ownership that will derive the consolidation/de-recognition indicators for each instrument on a daily basis.

2.FIN46 STC’ is a stand-alone sub-ledger for all consolidated structured transactions that cannot be maintained and accounted for in the Securities Cost Basis Sub-Ledger (SCBSL).

Created System Test Plan, reviewed with team and analyzed Process Flow Diagrams with Business and System requirements and prepared test cases in Quality Center

Created more than 300 scenarios in Quality Center and generated mock data

Executed UNIX instructions to run Autosys to generate actual results for mock data / live data

Analyzed log files to solve the issues and validated CCI Engine using mock data approach

Queried Database, compared and validated actual versus expected results

Supported Test Oracle team to automate existing testing process

Ran reports in Business Objects 11, constructed complex SQL queries to validate reports

Entered defects in Clear Review Meeting, and attended CCB meetings

Updated Quality Center for execution cycles to generate weekly status and requirements mapping for RTM generation and performed regression testing for different builds

Wrote complex queries to retrieve results and validated against expected using Win merge

Environment / Tools: Windows XP / 2000, Oracle 10g, Java, AbInitio, Rational Clear case, Clear Quest, Quality Center.

SIGNIFICANT ADDITIONAL EMPLOYMENT

Senior QA Analyst, Maverick Systems, Chennai, India April 2003 to February 2005 Senior Automation Test Analyst, Citibank, NJ June 2002 to March 2003 Project Lead, Value Software Technologies Limited, India January 2000 – May 2002 Programmer Analyst, DSRC, India June 1998 – December 1999

Contact this candidate