Ravish Dave

Experience

• 

  Motif, Inc.

  Dec 2008 - May 2009

  Technical support Executive

  Worked as a technical support executive for a leading e-commerce client based in US. My responsibilities comprised of investigating and resolving issues pertaining to the IT account security of account holders and communicating & co-ordinating with them via real time non-verbal medium.

• 

  IT consultant Self Employed

  Jun 2009 - Apr 2010

  Web Technology consultant

  Worked as a freelancer in open source web technologies. My responsibility was to provide an end to end web solution to the client. The skills and technologies that I used were Drupal PHP framework, PHP 5.0, MySql, HTML, XHTML, CSS, Google products. Created web solutions ranging from static websites to complex e-commerce solutions.

• 

  Tech Mahindra

  Mar 2010 - Nov 2012

  Software engineer

  • To monitor the frequent jobs that load data onto the data warehouse• To resolve any failures or errors that may arise during the load process within SLA timeframe• To communicate & co-ordinate with the other members of the event to get the issues resolved• To keep all the stakeholders informed about the status of the events• To resolve ad hoc queries related to any data warehousing issue• To amend any of the elements like sql or script in case need arises• To implement new applications on the production server• To perform migration & version upgrade activities (Participated in migration from TTU 12 to TTU 13) Show less

• 

  Cognizant

  Dec 2012 - Aug 2014

  Software Associate

  • Co-ordniating with the Business and data modeller for project & mapping details.• Creating Teradata SQLs as per the business logic including FLOAD, MLOAD and BTEQ scripts.• Creating Unix and TWS jobs to handle the application flow logic using shell scripting and IBM TWS.• Developing AnP(Acquisition & Publishing) and CDC (Change Data Capture) layers mappings in Informatica• Conducting SIT and UAT of the application.• Preparing the OAT (Operational Acceptance Testing) Plan and the IP (Implementation Plan).• Providing required training and documentation to the support team.• Providing assistance to support team during the warranty period post implementation. Show less

• 

  LTI - Larsen & Toubro Infotech

  Sept 2014 - Jan 2019

  Senior Software Engineer

  • Using sqoop to import data from RDBMS sources• Creating and managing Hive tables with partitioning and bucketing as per the requirements• Creating hive queries for incremental load of source data• Creating hive queries to handle the mapping business logic from staging to data warehouse layer• To handle SCD (slowly changing dimension) functionality• Creating Unix shell scripts to aid data flow process control• Creating Oozie workflows to synchronise various hive hql files• To create Autosys jobs and box to schedule Oozie workflow• Testing the Hadoop scripts for technical errors and logical defects• Co-ordinating with the Onsite team and Business Analyst for the development processExplored Spark graph processing capabilities for AML transaction monitoring in order to replace Mantas productTechnologies used: Hive, Spark, Spark GraphX, Spark Graphframes, UNIXCreated a Hadoop based recommendation Engine that recommends related knowledge based documents for a given issue or ticket. Also helped in project standardization and documentationTechnologies used: Hadoop, Apache hive, UNIX, Sqoop, Oozie, NLPTK - pythonInvolved in a Natural Language Processing – Text Classification – Sentiment Analysis project for an Insurance client using Naïve Bayes algorithmTechnologies used: Python, NLPTK (Natural Language Processing Tool kit), WindowsInvolved in a Natural Language processing – Name Entity recognition and scoring project of Insurance policies for a leading US based insurance playerTechnologies used: Apache Tika, R, OpenNLP, MongoDB Show less

• 

  FIS

  Mar 2019 - Sept 2022

  Product Specialist

  • Coordinating with the Product Manager and Sales team for understanding client expectations• Coordinating with Business Analysts to understand functional requirements• Performing data modeling as per functional requirement• Designing critical product modules with required level of throughput and latency• Implementing the product modules• Performing unit testing for the product modules implemented• Providing training to other team members for the modules implemented• Helping support team for initial period of production go live phase• Debugging & correcting any production issues• Working on product enhancement and performance improvements Show less

• 

  LTIMindtree

  Oct 2022 - now

  Senior Data Specialist