Vinod Choudhary, SCPM, PMP

Reston, VA *****

adi69z@r.postjobfree.com

202-***-**** adi69z@r.postjobfree.com

SUMMARY

A highly motivated, result-driven IT professional with over fifteen years of software development, Business Analysis, testing and implementation experience in client/server and web based environments, who takes ownership of the issues / assignments and drives them to successful resolution.

Excellent skills in problem solving, team building, motivation, expediting, communication, negotiation, leadership, planning, risk mitigation and establishing beneficial vendor and interpersonal relationships. Simplify complex problems using best practices and innovative means to create optimum value. Demonstrated a record of improving processes, developing support programs and quickly developing rapport and trust with clients.

AREAS OF EXPERTISE

Testing SOA, Java, ETL based applications

Manual and automated testing in both Data Warehouse and web based applications

Expertise in Rest API testing

Integration testing experience

Expertise in ETL/data warehouse testing methodologies

Strong SQL Skills ability to develop complex queries for testing

Experience in Agile development methodologies

Solid understanding of object oriented programming, design and debugging skills to apply to automated testing efforts

Passionate about Selenium and agile

Strategic and out-of–the-box thinking

Solid customer focus driven by quality

Test management background with hands on testing covering Unit, Functional & System testing, used Selenium and QTP

TECHNICAL SKILLS

Languages:

JAVA, PL/SQL, C/C++, XML, SAS, COBOL, HTML, JavaScript, Python

Platforms:

Windows 10, UNIX, Mainframes

Databases:

Oracle 12 g, MS SQL Server, IBM DB2, Sybase

Tools:

Informatica, Toad Data Point 4.2, Cucumber and Jenkins, Eclipse, Rally, AB Initio, BusinessObjects 4.2, QTP, LoadRunner, Microsoft Project, DOORS, MS Visio, MS Office, Clear Quest, Rational Suite, JIRA, HP ALM(QC), XMLSpy(x64), Altreyx Designer 2018.4

Other:

Agile with Scrum, RUP, OOP, UML, SDLC, Waterfall, PMBOK

EXPERIENCE

FANNIEMAE, Herndon, VA January 2020 – Present

QA Lead Multifamily Data

Created YAMLs for automation testing. Executed Autosys jobs

Participated in meetings and projects with client, project managers, and developers to automate, upgrade, and expand applications that accomplished business operations of assigned work units.

Developed queries, analyses, and reports.

Provided guidance and technical supervision to less experienced staff performing similar functions.

Provided change impact analysis. Worked on data manipulation techniques and statistics

Communicated technical findings to non-technical audiences

Environment: Oracle, very complicated SQL/PL SQL, Toad Data Point 4.2, Unix, JIRA, Python, SAS

FANNIEMAE, MTC/Herndon, VA February 2019 – December 2019

Sr. Business/Data Analyst: AMTM

Created User Stories and provided acceptance criteria for each sprint.

Participated in meetings and projects with client staff, project managers, and developers to automate, upgrade, and expand applications that accomplished business operations of assigned work units.

Created, designed, and formatted requirement specification documentation including architecture diagrams, process flows, and other information needed to describe required system changes for development, QA, and other internal customers.

Developed queries, analyses, and reports from applications for AMTM.

Provided guidance and technical supervision to less experienced staff performing similar functions.

Provided change impact analysis.

Environment: Oracle, very complicated SQL/PL SQL, Toad Data Point 4.2, Unix, JIRA, MS Project, VISIO

FANNIEMAE, Herndon, VA February 2018 – January 2019

Sr. Business/Data Analyst: IRIS-SC, IRIS-MC, REMIC TAX and MBS TAX

Created User Stories and provided acceptance criteria for each sprint.

Participated in meetings and projects with client staff, project managers, and developers to automate, upgrade, and expand applications that accomplished business operations of assigned work units.

Created, designed, and formatted requirement specification documentation including architecture diagrams, process flows, and other information needed to describe required system changes for development, QA, and other internal customers.

Developed queries, analyses, and reports from applications for multifamily bond admin.

Provided guidance and technical supervision to less experienced staff performing similar functions.

Provided change impact analysis for IRIS-SC, IRIS-MC, REMIC TAX and MBS TAX.

Environment: Oracle, very complicated SQL/PL SQL, Toad Data Point 4.2, SAS,Unix, CQ, HP, VISIO

FANNIEMAE, Herndon, VA May 2017 – Dec 2017

Sr. QA - Bond Administration (MF)

Some function in Bond Admin have been outsourced to KPMG. Collected Single/Multi Class monthly payment information from internal sources is sent to KPMG and Computed payment factors and payment data for paying Agents is received back.

Involved in test planning and analysis, data preparation, execution of KPMG Edits/CDS Edits/DQ Edits

Designed test scenarios for Mega testing, Rollup calculations, Payment factors for Mega's.

Communicated effectively to management, business owners, internal and external teams with the information and advice they needed to make good decisions and solve problems

Identified the testable requirements, created test data and organized testing approach and deliverables

Tested web services, and back-end functionality

Performed database testing which includes Data Validation, Data Mapping, Data Conversion, Data Analysis using SQL Queries

Environment: Oracle, very complicated SQL/PL SQL, Toad Data Point 4.2, Unix, CQ, HP, SAS, XMLSpy(x64)

FANNIEMAE, Herndon, VA Feb 2015 – Nov 2016

Sr. QA - CSPi (IRIS-SC): Collected the monthly payment information at loan level from internal sources. Computed payment factors and aggregated the collateral for computing the payment factors for Mega's. IRIS-SC reported cash flow and disclosure related information to down-streams and investors.

Designed test plan scenarios for automated unit, process, function, integration and acceptance testing

Involved in test planning and analysis, data preparation, execution and post quality control.

Communicated effectively to management, business owners, internal and external teams with the information and advice they needed to make good decisions and solve problems

Identified the testable requirements, prepared the test strategy and Performed Functional test execution.

Tested UI, web services, and back-end functionality

Executed Database testing which included DDL, DML, data integrity and validation, triggers and stored procedures

Researched and identify technical solutions to problems discovered in QA

Created test data and organized testing approach and deliverables

Analyzed and interpreted moderately complex functional and systems requirements

Identified and document software and system defects

Designed scenario & rules based test cases and prepared test data as per requirements

Performed database testing which includes Data Validation, Data Mapping, Data Conversion, Data Analysis using SQL Queries

Environment: Oracle, very complicated SQL/PL SQL, Business Objects, Unix, CQ, HP, Doors, performed web-service testing

FREDDIE MAC, Mclean, VA Jul 2014 – Jan 2015

Test Lead – Selling System, a web-based application that uses MISMO standards and integrates with all secondary marketing functions on one platform that incorporates the pricing, contracting, loan entry, loan allocation, purchase edits, note certification, contract settlement and funding functions.

Demonstrated excellent data analytic skills in identifying themes and trends out of large, seemingly-disparate amounts of data and subsequently presented the data and findings

Defined new processes to meet business goals, reviewed and improved existing processes.

Key participant in application analysis, reviewed business requirement, defined Acceptance criteria, designed documentation for completeness and test-ability.

Planned and conducted regular meetings to assess issues or bugs and plan strategy for addressing them.

Led technical project meetings and managed agendas for a cross functional team on certain projects

Wrote SQL statements for Back End testing, validated against the GUI data

Web services testing using SOAP UI for creating Cash contracts

Environment: Rapid SQL 8.1.1,HP,Clear Quest,SoapUI 3.6.1,PuTTY, WinSCP,Excel macros / VBScript,UFT, TestNG framework

FANNIEMAE, Reston, VA Aug 2012 – May 2014

Test Lead (MBSC): Central Credit Pricing project was an initiative to centralize credit pricing, enabled faster implementation of pricing changes and establish the foundation for dynamic pricing, enabled more granularity and flexibility in setting price and enabled lender transparency of price at any point in the loan process

Implement structured Agile Project Management processes.

Key participant in application analysis, reviewed business requirement, defined Acceptance criteria, designed documentation for completeness and test-ability.

Created test data, organized testing approach and deliverables. Designed/developed automated test scripts

Presented Application demos to senior audience

Communicated effectively to management, business owners, internal and external teams

Identified the testable requirements and prepare the test strategy

Performed Functional, regression, performance test execution.

Designed and developed automated test scripts for Regression testing.

Developed system testing metrics, best practices and methodologies

Oversaw the design, development, and implementation of quality assurance standards for software testing

Lead a team of 3 QA’s, evaluated and managed their efforts.

Created test data and organized testing approach and deliverables

Environment: Oracle, HP, CQ, used Json RESTful Services, Spring MVC, Spring Validation and JACKSON for testing web-services, SQL/PL SQL

REI, Herndon, VA Nov 2011 – June 2012

Principal QA Engineer (HRSA Project)

HRSA Grands and program management processing system is a web-based application.

Reviewed business requirement, design documentation for completeness and testability.

Communicated effectively to management, business owners, internal and external teams

Identified the testable requirements and prepare the test strategy

Presented the Gap Analysis Report to senior audience

Performed Functional, regression, performance test execution.

Designed and developed automated test scripts for Regression testing.

Conducted and facilitated the UAT at the client site.

Performed production verification after software installs.

Assisted in post-production support-such as end-users support; troubleshooting of issues on relevant production like environments.

Developed system testing metrics, best practices and methodologies

Oversaw the design, development, and implementation of quality assurance standards for software testing

Handled two projects, Lead a team of six QA’s, evaluated and managed their efforts.

Environment: Oracle,JIRA, Test Director, UFT, SOAPUI Pro, Selenium 2,PuTTY, WinSCP

FANNIEMAE, Herndon, VA June 2009 – May 2011

QA Lead (Evolv – ETL), Credit Loss Management an ETL project where we had data coming from different sources there were lot of business rule which were to be tested and ultimately the output that we got was 59 oracle table and these tables were input to a Evolv (Risk management solution tool that fanniemae had bought)

Developed SQL queries for database validations

Used Unix commands to execute ETL jobs and validate the data and log files

Validated the data being transformed via (ETL) Ab Initio and tested the Micro strategy report

Presented recommendations to senior audience. Wrote/analyzed test reports across a broad audience.

Design and develop automated test scripts for Regression testing.

Reviewed business requirement, design documentation for completeness and testability

Developed and reviewed test plans, test scenarios/cases, Entry/Exit/Success Criterion and expected results.

Performed data, process and system analysis in support of business and audit inquiries

Communicated effectively to management, business owners, internal and external teams

Created test strategy, test data and organized testing approach and deliverables.

Environment: Oracle, Sysbase, AB Initio, ETL Testing, Unix, Putty, CQ, HP,Excel macros / VBScript

CGI Technologies and Solutions Inc., Fairfax, VA Aug 2006 – March 2009

Sr. Data Analyst/QA Lead (infoAdvantage) (ETL Project),

A Data Warehouse project implemented for California and Texas State.

Made recommendations to improve current performance of ETL in infoAdvantage 3.8. Performed complex data analysis activities, issued research, escalation, follow–up, defect requests, patch request/delivery etc.

Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for infoAdvantage

Developed complex SQL queries, Analyzed data to create various queries and reports

Lead a team of four QA’s and evaluated and managed their efforts.

Environment: Oracle,BOXI, ETL Testing,PuTTY, WinSCP,Excel macros / VBScript,

Design Lead cum Testing Manager Jan 2008 – Jul 2008

Designed iDeal - a Sharepoint based system - to track all opportunities in CGI’s pipeline.

Developed Use Case diagrams, Business Flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stakeholders could understand the business process.

Oversaw test incidents and coordinated with the Development Manager to reach resolutions and gave status updates to the Program Manager.

Managed a test team of 6 testers - Performed data, process and system analysis in support of business and audit inquiries

Validated system executions and explained results to stakeholders and internal/external audit

QA Lead, EO Wells Fargo Project June 2007 – Dec 2007

Managed a team of 6, wrote test scripts, performed end to end testing using SOA architectural approach, and created FAQs for the website, which increased customer satisfaction.

Executed system testing and assisted with user acceptance testing.

Delivered project documentation for the application, encompassing aspects such as: application design, testing results and operating procedures.

Performed Data Analysis, Data profiling, Data Integration, and Data validation by writing SQL queries using TOAD against the ORACLE database.

Sr. Data/QA Analyst (infoAdvantage )(ETL Project) Aug 2006 – May 2007

Designed and tested Financial Accounting reports for an ERP package (Info Advantage 3.7) to establish a new release which included data warehouse.

Performed business requirements gathering and documentation, data cleansing and extraction, report design and implementation.

Wrote test plans for testing correctness of ETL processes and database contents.

Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse using TOAD

Created ETL and report test cases in Quality Center and conducted peer reviews

Executed DDL and DML packages received from database developers and tested the database tables for table structure including data type, size, integrity and other table constraints

Environment: Oracle,BOXI, ETL Testing,PuTTY, WinSCP, Excel macros / VBScript

FANNIEMAE, Washington, DC Feb 2006 – Jul 2006

Sr. Business Analyst

Team Lead - Managed and directed 6 technical analysts through each phase of both projects ensuring on time delivery.

Primary projects worked on included: FIN 46 Restatement project and Multi-Family project where the goal was to gather information required for documentation.

Served as a liaison between business users, technical teams, and managers to develop data management plans, scope documents, technical requirements and User Acceptance Test (UAT) plans for 7 modules.

Environment: Oracle

EDUCATION

MBA, Finance and Marketing, Indira Gandhi Open University, New Delhi

Post Graduate Diploma in Computer Applications, Rajya sainik Board, Chandigarh

MS, Commerce, Himachal Pradesh University, Shimla

AFFILIATIONS / AWARDS

SCPM (Stanford Certified Project Manager)

PMI Certified PMP (Since 2005 and in good standing)

Certified Oracle Professional (SQL*Plus, SQL, PL/SQL)

President, CGI Toastmasters, 2008 – 2009

Contact this candidate