Vikas Khashaba Ravidhone
Mumbai
Summary
Enthusiastic software engineer with 12+ years’ experience participating in the complete product/software development life cycle with following Agile/Waterfall model of successfully launched applications. Currently working Snowflake architect to build data flow design to meet business requirement and for one of the Fortune 500 clients. In previous roles, worked on automation of various requirements which helped to reduced downtime by 15% and warranty costs by 25%; identified and resolved a process bottleneck that reduced coding efficiency by up to 30%. apart from coding have I been certified data scientist (IIM Rohtak) and I have sound knowledge on code estimation, communicating with client for the new business requirement.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Team Lead/Solution architect
Accenture
Mumbai
08.2021 - Current
- Actively involved architecture of snowflake integration and cloud(AWS)
- Created external tables/logic for data load from cloud to snowflake.
- Used COPY to bulk load the data.
- Created stage and to transformed data during load.
- Worked on different format of data like parquet//csv etc
- Actively involved in AWS s3 policies, IAM and cloud watch use of them.
- Developed data warehouse model in snowflake for datasets.
- Help other associates to review code and test case documents.
- Coordination with testing team for the defect status and resolve the issues.
- Write algo/design document to meet requirement to avoid regression issues.
- Write down technical design specification and mapping related details.
- Create UNIT test cases and to make sure that it is covering all the scenarios as per the business requirement to avoid the number of defects.
Team Lead/Developer
Capgemini
Mumbai
03.2020 - 07.2021
- All the KPO related discussed data like policy premium amount, claim related information discussed on service center have received we are converting them either in or csv file format and as per requirement we have maintained them in snowflake cloud database.
- Created Snowpipe for continuous data load.
- Used COPY to bulk load the data.
- Created stage and to transformed data during load.
- Used FLATTEN table function to produce lateral view of VARIENT, OBECT and ARRAY column.
- Actively involved in AWS s3 policies, IAM and cloud watch.
- Developed data warehouse model in snowflake for over 23 datasets.
- Help other associates to review code and test case documents.
- Coordination with testing team for the defect status and resolve the issues.
- Write a efficient code to match complexity of the requirement to avoid regression issues.
- Write down technical design specification and mapping related details.
- Create UNIT test cases and to make sure that it is covering all the scenarios as per the business requirement to avoid the number of defects.
Team Lead/Developer
Capgemini
Mumbai
05.2017 - 12.2019
- Farmers migrating data from Heart and various source system to Oracle then to OBIEE reporting for all the major attributes. To integrate the data of various sources and convert them as per business requirement. Maintenance of CDC data in snowflake warehouse using snowflake procedures/code.
- Set up call and discussion with onshore coordinator to discuss day to day business requirement.
- Writing codes and creation of objects using snowflake and reviews of ongoing development in current sprint.
- To understand the requirement and find out the best approach to implement.
- Help other associates to review code and test case documents.
- Coordination with testing team for the defect status and resolve the issues.
- Write an efficient code or creation of objects and meet the business requirement to match complexity of the requirement.
- Taken care of time travel policy in snowflake.
- Write down technical design specification and mapping related details.
- Create UNIT test cases and to make sure that it is covering all the scenarios as per the business requirement to avoid the number of defects.
Team Leader/Tech Lead
Larsen and Toubro
Mumbai-Andheri client location
02.2016 - 04.2017
- To integrate different format of data in single system through which all Barc, Broadview system ratings can be observed and do the analysis on the same.
- Creating informatica mapping technical specifications on basis of new changes done for enhancement.
- Resolving issues in daily/weekly load cycle.
- Understand the requirement and make a document on the same, get an approval from client on the same.
- Preparation and reviews of test plans and unit testing.
- Used Informatica client tools - Workflow Manager, Mapping Designer, and Transformation Developer.
- Automated and scheduled the Informatica jobs.
- Extensively used ETL methodology for developing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using Informatica.
- Created Unit cases and uploaded in SharePoint, tortoise SVN.
- Ensure that daily support tasks are done in accordance with the defined SLAs.
- Viacom18 Media Pvt. Ltd. is one of India's fastest growing entertainment networks and a house of iconic brands that offers multi-platform, multi-generational and multicultural brand experiences.
Data analyst
Campaign Promotion History
Mumbai
09.2015 - 01.2016
- Designed a project specific versioning of oracle objects for all related core tables to keep track of historical data.
- Used almost all oracle objects and written many packages to meet customer requirement and to implement business logic into technical requirement.
- Worked with SQL query tuning with Explan Table and understand the cost and try to minimize the same by using proper logic.
- Responsible for designing code document and Performance tuning.
- Involved in the SDLC process beginning with the design of dimensional modeling in building the data warehouse.
- To analyze source system data and prepare low-level documentation.
- To ensure successful data loading using SQL loader.
- Performed root cause analysis and recovery process and raised ticket to concern BA.
- Documentation on requirement.
- Leading provider Campaigning Promotion is a process of raising customer awareness of product or brand, generating sales and creating brand loyalty. It is one of the four basic elements of market mix, which include 4 major P’s i.e. Price, Product, Promotion and Place.
Education
Bachelor of Engineering - Information Technology
Mumbai
Mumbai01.2010
SSC -
Maharashtra State board
Maharashtra01.2010
Diploma in Computer technology - Computer Technology
MSBTE(Maharashtra state board of technical education)
Mumbai01.2006
Skills
- Windows 10
- Solaris
- Client
- Oracle
- DB2
- Microsoft Server
- Mongo DB
- MY SQL
- HTML
- PHP
- Jira
- Rally
- Informatica
- PL SQL
- Autosys
- Snowflake
- AWS
- Python
- Unix Shell script
- Big Data
- Python Image processing
- Management
- Leadership
- Time management
- RFPs
- POCs
- ML
- AI
- BI tools
- Training
- Development
Certification
- AWS practitioner
- PL SQL Developer associate
Training
- Training on AWS with Big Data analytics completed from AWS.
- PL SQL Training completed, which was scheduled by Oracle representative.
- Big Data in Hive training completed from udemy.com.
- Python with data analytics from udemy.com.
Prior Work Experience
- Capgemini, Senior Consultant, 05/22/17, Present, Mumbai, Maharashtra, NA
- Larsen and Toubro(LTI), Senior developer, 05/28/15, 05/17/17, Mumbai, Maharashtra, NA
- Capgemini, Consultant, 07/31/14, 05/20/15, Mumbai, Maharashtra, NA
- Mastek, Senior Developer, 04/09/12, 07/30/14, Mumbai, Maharashtra, NA
- Reliance Tech Services, Deputy Manager, 01/04/10, 04/06/12, Mumbai, Maharashtra, NA
Skills Profile
Windows 10, Solaris, Client, Oracle, DB2, Microsoft Server, Mongo DB, MY SQL, HTML, PHP, Jira, Rally, Informatica, PL SQL, Autosys, Snowflake, AWS, Python, Unix Shell script, Big Data, AWS, Python Image processing, Ability to manage and Lead a major project 10-12 resources with proper time management and delivery on time of all modules. Ability to work on RFPS and POCs with the current technology such as ML and AI. Currently handling new assignment of around 20 resource on BI tools which include different environment with various technologies., Conducted many sessions on Python, Informatica, Big Data and PLSQL also helping colleagues in project areas also eager to learn new technologies.
Timeline
Team Lead/Solution architect
Accenture
08.2021 - Current
Team Lead/Developer
Capgemini
03.2020 - 07.2021
Team Lead/Developer
Capgemini
05.2017 - 12.2019
Team Leader/Tech Lead
Larsen and Toubro
02.2016 - 04.2017
Data analyst
Campaign Promotion History
09.2015 - 01.2016
Bachelor of Engineering - Information Technology
Mumbai
SSC -
Maharashtra State board
Diploma in Computer technology - Computer Technology
MSBTE(Maharashtra state board of technical education)