6+ years of experience in ETL and Database testing
Resume:
Sunil Waghmode
Pune, India
***************@*****.***
Professional Summary
Working as a Test Analyst in Barclay's Global Service Corporation Pvt.Ltd organization with 6.3 years of total IT experience in SQL, UNIX/Linux, Shell scripting
•Good Command on SQL queries
•Good exposure to implement UNIX commands
•Writing the scripts to automate manual process in shell scripts, Python and VBA
•Good hands on experience in ab initio ETL tools, SAS Dataset as analytical tool
•Good hands code deployment to testing environment using CI/CD tool
Professional Skills
•Successfully gained 6.2 years’ experience in oracle database, Unix as OS
•Testing and Migration of legacy/OLTP and data ware housing applications
•Extensive data modeling experience using Dimensional Data modeling, Star Schema modeling
•Good hands on server-side testing, version control and repository tool such as GIT and Stash
•Good hands on BI report testing for data analysis with help of tools such as PowerBI, Tableau
•Good hands knowledge on cloud such as MS Azure platform, Data Platform, Data factory, Data
Lake, Event Hub etc.
•Good knowledge of Basic Java (Core) and Python programming
Education Details
M.Sc. in Computer Science from MAEER’s M.I.T Arts, Commerce, Science College Alandi (Devachi) Pune, Maharashtra, India, 2012
Certification
NSE's CERTIFICATION IN FINANCIAL MARKETS (NCFM) Financial Markets a Beginners' Module
Professional Experience
Company Name Barclays Global Services Pvt.Ltd. (20-Nov-2017 - till date)
Project Name Risk, Finance and Treasury
Roles Test Analyst
Responsibilities
•Writing SQL queries to check the mapping logic
•Working on Credit risk project and upgrading (Migration) version to SAS Grid
•Preparation of test data as per business transformation and analyze the transformation logic
•Responsible for Report testing, code promotion in SIT environment
•Good hands UNIX commands and data quality tools
•Created an automation tool in VBA for teammates to reduce the manual efforts there by
increasing higher accuracy and efficiency of day to day work
•Responsible to measure performance by time elapsed during each phase of SQL statement processing
Company Name TATA Consultancy Services Pvt.Ltd. (24-MAY-2017 to 10-Nov-2017)
Project Name Feed consolidation layer
Roles Business Process Lead
Responsibilities
•Writing SQL coding to check the mapping logic
•Responsible for SIT, Regression testing
•Performing regression testing using Data Validation tool (DVO)
•Preparation of test data as per business transformation and analyze the transformation logic
•Working on Power BI and tableau reporting tool for Data Analysis and Reporting
•Good hands UNIX commands and data quality tools like Informatica, Data validation
Options (DVO)
Company Name Altius Data Solutions Pvt.Ltd. (29-Aug-2016 – 13-April-2017)
Project Name Whitbread – Marketing Cost
Client Name Premier Inn Hotel
Roles Testing Consultant
Responsibilities
•Responsible for SIT, Regression and END to END ETL and Data warehouse testing
•Preparation of test data as per business transformation and analyze the transformation logic
•Worked with Developers to understand requirements for writing test cases
•Responsible for creating and executing the BI report test cases
•Good knowledge on Data Lake, Data platform, data factory, Data Analytics, USQL
•Tested the ETL mappings and other ETL processes (Data Warehouse testing)
•Working on TFS (Team Foundation Server) as defect tracking tool for creating test
plans and test cases
•Good hands on Power BI and Tableau for Data Analysis and Reporting
Company Name Capgemini India Pvt.Ltd.(16-Mar-2016 – 15-July-2017)
Project Name EOS – Credit Risk
Roles Associate Consultant
Responsibilities
• Writing the SQL scripts for data validation
• Responsible for database migration testing from Oracle 11g to 12c
• Preparation of test data as per business transformation and analyze the transformation logic
• Worked with Developers to understand requirements of a client for generating test cases
• Writing Shell Scripts for performing operational data source tested the ETL Informatica
Mappings and other ETL processes (Data Warehouse testing)
• Expertise in writing SQL queries and server-side testing on Linux OS
Company Name Cybage Software Pvt.Ltd.(29-Oct-2012 – 12-Mar-2016)
Project Name Farelogix
Roles Technical Support Executive
Responsibilities
• Writing the SQL scripts for data validation
• Monitoring the health (disk space usage) of global distribution server (GDS)
• Responsible for database migration testing from Oracle 11g to 12c
• Preparation of test data as per business transformation and analyze the transformation logic
• Worked with Developers to understand requirements of a client for generating test cases
Contact this candidate