Rishabh Gulati Email & Phone Number

United States

Mumbai, Maharashtra, India

Hartford, Connecticut Area

In BOND BI&A MIS and finance project, we majorly take data from upstream, validate the data and create feed files, which other departments used as input information for their processing. The main aim of this project is to help various BOND business customers and users in reducing their manual tasks by automating it and enhance the process to support more business and improve the quality of the processes.⎫ Mature the data lake while enhancing the input transactional data, Log data and… Show more In BOND BI&A MIS and finance project, we majorly take data from upstream, validate the data and create feed files, which other departments used as input information for their processing. The main aim of this project is to help various BOND business customers and users in reducing their manual tasks by automating it and enhance the process to support more business and improve the quality of the processes.⎫ Mature the data lake while enhancing the input transactional data, Log data and ware house processed data using HDFS, Hive and SQOOP.⎫ Implement complex analytics on Data Lake using Python, Spark and PySpark to get resultant informed decisions in business direction to achieve organizational goals.⎫ Develop applications after reviewing and modifying the underlying architecture incorporated using ETL programs in Ab Initio for implementing data transformations and data transfer.⎫ Consultation with business and technical team to instrument solutions in order to modernize the storage and accessibility of data.⎫ Requirement elicitation and end to end implementation in an Agile environment.⎫ Identifying automation and modernization opportunities to the supported systems.⎫ Understand and design the service orchestration and data aggregation for invoking one or more services to complete a business or data access function and aggregating into data sets.⎫ Providing solutions to convert SQL Stored Procedures to convert to AB Initio graphs and plans.⎫ Monitor the health of the existing stored procedures during code enhancement and improve them to reduce time and space complexity.⎫ Conceptualized transformation strategy for implementing Catastrophic Risk Analysis process in Hadoop (Sqoop/Hive/Spark) by showcasing performance improvement over existing Ab Initio processes. Show less

Hartford, Connecticut Area

• Responsible for developing E2E APIs using Mark Logic which includes the ingestion ofbulk data in Mark Logic, processing and extraction of data from content DB. Also worked with MarkLogic Semantics to ingest triples in content DB and retrieve information using search APIs• Core development of REST-ful APIs for ingest, transformation and extraction of data inNoSQL fashion and worked exhaustively with Roxy Framework• Transformation of data ingested using XSLT 2.0 and usage of… Show more • Responsible for developing E2E APIs using Mark Logic which includes the ingestion ofbulk data in Mark Logic, processing and extraction of data from content DB. Also worked with MarkLogic Semantics to ingest triples in content DB and retrieve information using search APIs• Core development of REST-ful APIs for ingest, transformation and extraction of data inNoSQL fashion and worked exhaustively with Roxy Framework• Transformation of data ingested using XSLT 2.0 and usage of XSDs to perform validationof the incoming data• Involved in XML data modelling activities in addition to Development of REST basedservices• Implemented the Advanced search API, Maps and cts search inbuilt functions forextensive search on the database• Created Universal indexes, Element Range Index, Element Attribute Index and PathRange Indexes to improve the performance of the application• Collaborated with Roxy framework to interactively work with MarkLogic• Created extensive cURL scripts to connect to external applications• Worked with CORB – Java library in Mark Logic for faster processing of bulk documents.• Created and implemented benchmark workloads for internal R&D use• Engrossed in continuous unit testing, development and end to end support provided underAgile environment• Mentored new employees in the company and support groups Show less

Bhubaneshwar Area, India

• Extensive professional experience in Information Technology with strong background in the areas of ETL Design and Development in Data Warehousing using Ab Initio 3.0.3.• Experience in building Operational Data Store (ODS) and Enterprise Data Warehouse with the knowledge of logical and physical Dimensional modeling concept Star /Snowflakes Schema, fact and dimension table and proficient in identification of Facts, measures and dimensions• Knowledge of managing full project life cycle… Show more • Extensive professional experience in Information Technology with strong background in the areas of ETL Design and Development in Data Warehousing using Ab Initio 3.0.3.• Experience in building Operational Data Store (ODS) and Enterprise Data Warehouse with the knowledge of logical and physical Dimensional modeling concept Star /Snowflakes Schema, fact and dimension table and proficient in identification of Facts, measures and dimensions• Knowledge of managing full project life cycle, including planning development, requirement definition, application development, QA testing support and implementation.• Expertise in handling errors and performance issues in Ab Initio Tool for data manipulation and scheduling task along with third party scheduling tools like Zeke• Hands-on experience on all stages of Ab Initio with variety of source file formats including csv, mainframe and flat files as well as diverse databases like DB2, Oracle and SQL Server• Skills in implementation and co-ordination of traditional waterfall model• Experience in Unix shell scripting, batch scheduling and version control tools• Proven ability to lead and motivate teams in-order to maximize productivity• Result-oriented, dedicated professional with record of accomplishment for consistentlydelivering effective solutions within critical time and budget constraints• Have excellent analytical abilities and ability to solve problems and technical flaws withexcellent communication, interpersonal and presentation skills Show less

Mysuru Area, India