Senior Functional Consultant
An extremely motivated and detail-oriented individual having around 10 years of experience and working within product management group with expertise in implementing the product for customers as a functional consultant and having extensive experience in Manual and ETL Testing and BI reports testing.
Expertise in contract management domain and having experience in implementing the Icertis Contract Management system
Successfully kicked off the project with international client after extensive onsite requirement gathering and analysis.
Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories
Experience in handling the UAT Process, right from Planning to implementation.
Experience in writing SQL queries.
Used the UNIX commands and utilities to run the system / applications jobs.
Expertise in ETL, Functional Testing, Regression Testing, SIT Testing, Database Testing, UAT Testing, Smoke Testing and Browser Compatibility Testing
Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into Functional, Use Cases/User stories.
Good in preparing Test Cases with the help of Use Case, SRS, BRS and UI Specification.
Active participant in reviews, status, defect triage meetings and client interfacing.
Experience in Agile techniques.
Extensively used JIRA, HP Quality Center for defect Tracking and Test Result
Excellent communication and presentation skills with a results-oriented attitude.
B.E. Civil from Govt. College of Engineering Pune (COEP).
H.S.C.(XII), Maharashtra State Board, 1998
S.S.L.C (X), Karnataka Board 1996
Test and Defect Management tools
HP ALM, JIRA, Quality Center, TFS,MTM
Version control tools
Informatica Power Center
MS-SQL Server 2005 and 2008, Oracle SQL Developer
MS Word, MS Excel, MS PowerPoint
Microsoft Windows, Solaris Unix
Sr. Functional Consultant – Icertis Solutions (Feb 2018 - May 2019)
Client: Daimler, Transurban, HERE, Chemonics, Norfolk Southern
Description: Icertis is a global technology company is a leader in providing enterprise solutions in the Microsoft cloud environment. It is one of the few global technology companies that builds and implements enterprise Contract Management system that address specific business needs of contracting Process.
Icertis Contract Management's (ICM) robustness helps customers cover a wide range of agreements from procurement to corporate agreements that supports all departments with a horizontal solution. These include buy side or sell side agreements, vendor, Employee or Human resource agreements and other administrative agreements.
Participated in requirement gathering at Clients side.
Created product backlog; prioritized features in the backlog and held backlog grooming sessions in reference to keeping the backlog clean & prioritized to ensure that the backlog is ready for the next sprint.
Created user stories from functional requirements
Implemented, designed and configured the system as per the customers requirement
Interacted with clients both internally and externally to understand business needs and identified new opportunities.
Carried out the system Demo to the business owners.
Integrated Salesforce with ICM
Analysing Requirements and Preparing Test Cases/Scenarios.
Executing test cases and reporting bugs.
Actively participating in the STLC (Software Testing Life Cycle).
Sending daily status to all the stakeholders
Sr. Test Analyst – Synechron Technologies (Aug 2015 - Sept 2017)
Client: Deutsche Bank Group
Description: The Data Source Catalogue (DSC) is one of the capabilities in the GDMO strategy. Its goal is to create a definitive, consistent and comprehensive view of all Deutsche Bank corporate data stores. This view is to include all types of business information, from structured data to documents to emails.
It will store information about our Data Assets, whether it is stored in formal databases, Document Management Systems, File Servers or E-Mail Servers. It will tell us what data is stored, where it is located, and who has access to it. It will allow us to find the data (eDiscovery – for legal and compliance) and allow us to track how long to keep the data and ensure we are sourcing the right data from the right places.
As part of ever expanding Legal and Regulatory requirements we are increasingly required to ensure our reporting is accurate and that data is sourced from the right places. Knowing where our data is, how it’s sourced, requirements for retention of the data, and the ability to accurately and quickly retrieve that data upon request is critical. Recent regulatory examples include: Dodd Frank
The DSC is being built in support of a number critical functions and controls within the organization including Records Management (and compliance with retention regulations such as Dodd Frank), Archiving, and eDiscovery (through the identification of a data store’s owners and custodians, facilitating timely retrieval of data from the sources in response to legal or regulatory requests for data).
Understanding requirements and creating test cases and executing them.
Based on the source target mapping preparing the SQL queries for the testing of data transfer
Running the jobs/Workflows for ETL process in Informatica.
Prepared and executed SQL queries to verify the data in source and target.
Verifying the data in target database by ETL process.
Using the UNIX commands verifying the source files in UNIX box.
Verified column mapping between source and target.
Prepared test data for functional & Integration testing.
Interactions with BA & Dev teams to resolve the issues.
Reporting daily testing status.
Designed, Reviewed & Executed Test cases.
Identified Test cases for Regression testing.
Defect analysing and Reporting in HP ALM.
QA III - Realpage India Pvt Ltd (Oct 2010 - June 2015)
Description: The fundamental power of Realpage BI Cognos tool is the ability to generate reports and widgets which helps to analyse their business for clients. BI is a reporting package that allows users to run the reports and widgets and export them in Excel and PDF. It gives ability to create the custom dashboard and where user can add any widgets to the dashboard. Real Page BI, you have immediate access to highly relevant information about your properties and markets—whenever you want it and in whatever format you desire. BI mines your data for you, showing you information instantly and making it easy for you to slice and dice the way you want. Its extraordinary reporting capabilities will enable you to uncover inconsistencies in performance, making it the cornerstone of your asset and portfolio analysis properties. The reports and widgets that are available are dependent on the product centers used at properties and reporting.
The BI project is based on ticketing system called JIRA. I am involved in all testing life cycle activities.
Actively involved in phases of product development which include Requirements Elicitation, Product Road Map Definition, Backlog Prioritization, Sprint Planning, Release Plan & Preparing High-Level Design Document.
Understand requirements and creating test cases and executing them.
Writing the SQL query for reports and widgets based on the business logic
Preparation of Test cases and Test data
Execute Test Cases for Functional, Web and GUI testing using Black Box techniques.
Regression testing on the builds.
Verify data at the backend using the SQL queries prepared.
Report issues in defect tracking tool JIRA and getting them fixed
Sending the daily QA status report to all stake holders.
Associate - Tech Mahindra Pvt Ltd through Softspin Consultancy from October 2009 to April 2010
Description: UAT Testing – The objective of the testing is to allow the user community to test system functionality against a set of agreed requirements, also to view and familiarize themselves with the a new system or new functionality of an existing system once it has undergone and successfully passed a development Unit Testing phase and a System Integration Testing (SIT) testing phase.
Understand the Solution Design Documents, Business Scenarios, User stories, Process design documents and prepare test scenarios/test scripts.
Identify changes made to the systems (CR’s) and its possible impact on testing.
Responsible for the entire UAT Process, right from Planning till implementation till completion (Entry and Exit Criteria).
To identify gaps in systems and Processes and provide feedback to Component teams, Process Designers and Business Analysts.
Responsible for managing Operational/Gold Users and SME’s on a day to day basis during testing.
Managing the issues raised by testers and liaises with the component team for timely resolution of issues/defects.
Stakeholder who is responsible for giving a sign off to UAT and a recommendation to move onto the next stage of Product Launch.
Responsible for identifying the root cause of issues that are encountered during UAT.
Responsible for following the Defect Management Process to rectify any defects or request for CR’s to be raised.
Responsible for identifying the need and impact of a CR Request.
Test Analyst - Sansui Software Pvt Ltd from August 2007 to September 2009
Description: Publish now-Print Solutions is a web based application used for Online Advertising and also for advertising in Newspapers and Magazines. Brand Builder client application is used to customize marketing materials online. It mainly helps in creating, archiving, searching, and editing ads. Pre-designed templates are available for various categories and are editable by the user. The variable text and image content of the Advert (template) can be edited to exact specifications. You can view the JPG or PDF preview of the final template before delivering it to the Printer/Publisher. A print-ready PDF can be generated of the same. All the ads created are saved and are available for re-use whenever required by the user. Ad Builder also supports online delivery of the ads along with the billing information.
Understand project requirements.
Prepare / Update the Test case document for testing of the application from all aspects.
Prepare the test setup.
Conduct the Testing including Smoke, Sanity, System and Regression Testing.
Update the Test Result document.
Attend the Regular client calls.
Log / File the defects in Defect tracking tool / Bug Report.
Conduct Web Service testing for related modules.
Discuss queries with Development Team / Client.
Passport No. and Status
G0386700 with B1/B2 US Visa valid till 2021.