SHUBHAM GAUTAM

• OCI(Oracle Cloud Infrastructure) Team:
• Developed data pipelines from scratch through Spark, Kafka.
• Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
• Utilize MongoDB to create No SQL databases that harvest data from variety of sources.
• Development of various Interactive dashboards and Visualizations through Tableau, OAC.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Worked on PySpark , Kafka , Kubernetes to deliver and maintain data pipeline.
• Impact analysis tool that reduced manual effort of working day and increased throughput.
• Developed, implemented and maintained data analytics protocols, standards and documentation.

Key Achievement: Automation of the deployment process of catalog migration and RPD which helps in optimization of the process by 20%

Project HR Analytics:

• Made Attrition and HighPerformer's dashboards consolidated and Interactive dashboard having different views and functions for HR to facilitate and acknowledge number of employees leaving organization and trend of leavers so that proper action can be taken by higher management
• Improved performance, hiring practices and management systems to facilitate success of client's organization by Implementing CI CD plans.
• Created coherent Logical data models that helped guide important client business decisions implementing Facts and Dimensions .
• Improved performance in data pipelines through implementation of Kafka data streams .

Key Achievements: Lead a team of 5 people in OAC project which helps in creating interactive and meaningful dashboards.

• Worked in Fidelity as an Analyst Programmer in ORACLE Analytics Projects and
• Worked on reporting tools like OBIEE 12c, BI Publisher
• Helped Data Analytics team in data cleansing through technologies like Python for data science and its various libraries(numpy, pandas,etc)
• Experience in SQL Tuning through Explain plan and Optimiser Hints
• Worked on the requirement gathering by users and development of the
• Dashboards and reports and to schedule them followed by support.
• worked on creating SQL, PLSQL data models.

• Complete hands-on and familiar with OBIEE 11g and 12c and BI Publisher
• Knowledge of DATA WAREHOUSING , OLAP , and OLTP concepts
• Worked in the development of Reports and Repositories in OBIEE
• Also worked on front and backend configuration development of OBIEE
• Developed a real-time commentary/feedback and Writeback for OBIEE dashboards
• Have made interactive Tableau Dashboards, as well as BI Publisher, reports that involve backend SQL queries as well as report development for the Users
• OAC (Oracle Analytics Cloud): It is a cloud version of OBIEE, involved in the support as well as the development of interactive dashboards as well as reports