VINNYA.V +91-807******* Vinnya v

Bangalore, India

Express entry profile: E001963343 adm45b@r.postjobfree.com Vinnya.V Aspiring for a position that will effectively utilize my acquired educational knowledge, technical expertise and also to upgrade my knowledge about the new and emerging trends in the IT sector PROFESSIONAL SUMMARY

• Technology-driven IT professional with 9+ years of experience and a strong background in Banking domain, Data warehousing, ETL Informatica Development, Testing and Production support

• Currently spearheading function as an Assistant Consultant (Technical Business Analyst) at Tata Consultancy Services Limited TCS, Bangalore

• Experienced in Software Development Life cycle phases - Requirement gathering, Analysis, Design, Development, Testing and Implementation phase under Waterfall and Agile methodology

• Proficient in handling various production issues and ensuring optimum solution within defined timelines and expectations

• Proven accomplishments in Minor enhancements, Manual Testing and Production Support projects

• Well versed in Teradata, Oracle, SQL, UNIX, Informatica & Mainframe (basic) technologies

• Proficient at maintaining cordial relationships with clients, ensuring quality and service norms to achieve client’s satisfaction and business retention

• Holds high personal standards and consistently leads cross-functional teams to achieve project objectives TECHNICAL SKILLS

ETL Tools Informatica

Operating Systems UNIX, Windows

Databases Oracle, Teradata, Hadoop

Defect Tools BMC Remedy Management, ServiceNow, Quality Centre, JIRA Job Scheduler Control-M Enterprise Manager

Programming Languages Basics of C, C++ and Java

Other Tools/skills Hue, Zeppelin, Teradata SQL Assistant, Oracle SQL Developer, Mainframe, Git, Clearcase (Version Control Tool), vi Editor, Putty, IntelliJ EXPERIENCE SUMMARY

Company Name Years of experience Roles performed

TATA Consultancy Services Ltd

Sep-2011 till now

• Technical Business Analyst

• Tester

• Production support Executive

• Module and Team leader

GLOBAL EXPOSURE

• Efficiently interacted and maintained cordial relation with clients in Sydney, Australia for better execution and functioning of projects

EDUCATION

• Bachelor of Technology (Electronics and Instrumentation Engineering) from Pondicherry Engineering College, Pondicherry, 2011

CERTIFICATIONS

• ISTQB – International Software Testing Qualifications Board

• Oracle Database 11g:SQL Fundamentals I

LANGUAGE

• Fluent in English

PROJECT DETAILS

Project Title BELL – Biz Express Lending

Client Common Wealth Bank - Australia

Domain Banking

Duration Jan 2020 – till date

Role Technical Business Analyst and Tester

Description

CBA is a multinational bank with businesses across the globe. The objective of this project is to ease the process of lending loans to customers by reducing the processing time and also make the lending data available to different stakeholders for reporting

Contribution • Understanding and gathering of business requirements

• Participate in architecture and design meetings

• Analysing the data and identifying the data quality gaps and ensuring it is fixed

• Preparing business requirement and technical analysis documents

• Writing complex SQL queries for the developers to build

• Walkthrough of the requirement, design and SQL with developers, testers and stakeholders

• Providing end to end support for the developers and testers

• Doing BVT once the features are productionised

• Preparing test plan and test cases/scenarios for system testing

• Walkthrough of test cases with clients, solution designers and BAs

• Executing test cases, identifying issues, raising defects and ensuring it to closure

• Documentation of test results and walkthrough of it with stakeholders

• Trouble shooting of production issues

• Analyzing data issues and providing solutions to queries of users Project Title Group Data Warehouse (Production Support) Client Westpac Banking Corporation – Australia

Domain Banking

Duration Feb-2012 to Apr-2015, July-2015 to Dec-2015, May-2016 to Apr 2017 Role Module Lead & Support Executive

Description

Group Data Warehouse (GDW) is a central repository of corporate data across Westpac Banking Corporation and to the business units across the group. The objective of this support project is to make GDW data available to Business users for serving the analytical/decision and reporting needs of the business users without any delays

Contribution • Active involvement in analyzing data issues/queries of users and responding to it without delays

• Taking prior actions in meeting the SLAs of data for business reporting during the critical End of Year and End of Half Year preparations

• Diligently handled various production issues and ensuring the issues are fixed in a timely manner

• Working on Minor enhancements which focus on addition of new functionality to the existing system in place in order to satisfy business requirements

• Ensuring the process, standards and Service Level Agreements are followed

• Documentation of application and technical knowledge

• Stellar role in:

o Taking up permanent fixes to stabilize the application o Monitoring jobs and performance of DB

o Performance tuning of long running queries

Project Title Group Data Warehouse Re-platform - Parallel Run Team Client Westpac Banking Corporation – Australia

Domain Banking

Duration May-2015 to June-2015, Jan-2016 to Apr-2016 Role Team Lead and Support Analyst

Description

GDWR project is re-platform of old GDW Oracle database to Teradata, which is a central repository of corporate data across WBC and to the business units across the group. The objective of this project is to migrate all the data from Oracle to Teradata database Contribution • Assisted a 12member team with GDW Application knowledge in analysing and resolving issues

• Compared data between Oracle and Teradata database and ensured it’s in sync

• Identified bugs and raised defects with appropriate severity and priority

• Took up permanent fixes to make sure GDW Teradata platform is in sync with the GDW Oracle

• Wrote test cases and tested the changes for the defects raised

• Co-ordinated with teams to ensure business expectations are met Project Title ADAPT - Advanced Data Analytics Platform Client PNC Financial Services Group – US

Domain Retail Banking

Duration Aug 2017 – May 2018

Role Technical Support

Description

PNC project deals with the corporate data across PNC Banking. The objective of this support project is to make data available to Business users for serving the analytical/decision and reporting needs of the business users without any delays.

Contribution • ETL performance tuning

• Trouble shooting of production issues

• Analyzing data issues and providing solutions to queries of users

• Taking prior actions in meeting the SLAs of data for business reporting

• Working on automation and process improvement tasks

• Monitoring jobs

Contact this candidate