Ganesh Dnyanoba Andhare

 Expertise Summary 6 years 9 months of total experience Retail and Insurance domain. 4 year 9months of experience in ETL Tools Talend. Good knowledge of ETL tools Like Talend studio and Talend Big Data studio. Experience in handling of source files such as delimited files, ASCII fixed files, Multi-schema files etc. Hands on experience in analyzing all kinds of data including EBCDIC data formats. Experience of Talend job deployment on Talend TAC and schedule job. Worked on Data Extraction, Data Transformation, Data Loading and then perform different transformation like join, union, remove duplicates etc as per the audit requirement.. Extensive experience in designing and developing complex mapping from varied transformation logic and used various components like tmap,tjoin,tReplicate,tParallelize,tsendmail,tDie,tUnique,Tflowtoiterate,tsort,tfilterrow in design job in Talend Development complex talend ETL job to load the data from file to HDFS ,HDFS to Hive ,Hive to SQL table. Academic Qualification EducationalQualification Year Board/University Percentage MasterinComputeApplication March-2012 MGMCollege/(Dr.BAMU) 64.59% BachelorofScience Jan-2009 ShivchhatrapatiCollege/(Dr.BAMU) 61.67% H.S.C March-2005 MaharashtraStateBoard/S.B.College 48.17% S.S.C March-2003 MaharashtraStateBoard/SonamataVidyalaya 75.33% Certification Certified in oracle Developer by (partnership Focus service Training and Oracle Associate). Programming Language C, C++, C#, ASP.net. Skill Set: ETL Tools :TalendFabric,Talend 6.0.1.,Talend 6.0.2,Haddop,NT Build. Database : SQL Server 2008, MySQL, Oracle Operating System: Windows 98/2000/XP/ Windows7, Linux, UNIX. Tools : Jira, Putty,SVN Professional Experience: Employer: Capgemini india pvt ltd Client:RSA Duration: 07-JAN-2019 to Till date Role: Consultant 1) Project : Insurance Environment : Talend Fabric,Sql server,Cassendra. Project Description: This project was to create centralise database to store the business data for the client to provide maximum data for the Insurance Domain. Responsibilities: Requirement Understanding from clients/ Design and Development. Created Talend Job for retrieve the data which received from the other database (Cassandra,SQl Database) Created Talend jobs to load data to Sql server from various database. Monitoring all job on TAC Handled data related issues in the data. Created Talend job for validation of data before loading into tables and the rejected records were sent back in flat file format. Employer: PRGX India Pvt Ltd Client:Bashas,Kroger,WinnDIXI Duration: 22-FEB-2016 to 31-Dec-2018 Role: Senior ETL Developer 2) Project : HDFS data push Environment : Hadoop, HDFS, Hive, Impala,UNIX, Talend. Project Description: This project was to create centralise database to store the business data for the client to provide maximum data for the recovery audit team. The builds are generated once the data store in database or Hadoop ecosystemThe scope of the project is to find out the maximum recovery audit claim which will benefit for the company. Responsibilities: Created Mapping documents for files received by clients. Created Talend Job to unzip/archive/decrypt data which received from client into FTP location Created Talend job to load the data into HDFS from various flat files (ASCII, EBCDIC and Excel) by applying various transformation rules. Scheduled Talend jobs on TAC as per frequency basis like Daily, Weekly ,Monthly etc Monitoring the performance of various jobs running. Direct Interaction with clients and users over Critical Issues. 2) Project : AP Vendor Data Mart Environment : Talend 6.0.1, SQL Sever The scope of the project is to find out the maximum recovery audit claim in Retail sector. Responsibilities : Requirement Understanding from clients/ Design and Development. Created Talend Job to unzip/archive/decrypt data which received from client into FTP location Created Talend Job for copying data from FTP Location to staging Location on daily basis. Created Talend jobs to load data to Sql server from various flat files. HandledHandled Delimiter issues in the data. Created Talend job for validation of data before loading into tables and the rejected records were sent back in flat file format. 3 ) Employer: Anand ERP (I) Pvt Ltd Client: Jaihind Automation Pvt. Ltd. Duration: 01-May-2014 to 13-Feb-2016 Role: (Techno functional) Developer Product: “UPCREST” (ERP Software) Front End : C#.NET Backend: SQL Server Role: SQL Developer Having experience working with various clients where “UPCREST” product is implemented. Currently working on day today Issue & new development on the existing product. Crystal Report (SQL Server) Report / Preview Fine Tuning Report / Preview for Payroll Report / Preview Production Plan report. Report for Accounts Payable- Supplier Design & Develop Custom Form Purchase Order Form GRN Form Sales Invoice Sales Order Form Extra Curriculum Activities Participated in National “All INDIA INDOOR CRICKET CHAMPIOANSHIP-2002” Orissa. I have completed udemy course "Spark using scala " Personal Summary Date of Birth:Feb 18, 1987 Father’s Name:Mr. Dnyanoba S. Andhare Marital Status:Married Language Known:English, Hindi, Marathi (Ganesh Andhare)