Rohit Chouhan

Team Leadership and Stakeholder Engagement:
-Managed and led a team, engaging with Business Executives and Stakeholders to translate business needs into actionable technical solutions.
-Conducted technical and functional design discussions, creating wireframes, and ensuring alignment with stakeholder requirements.

Snowflake Development and Optimization:
-Designed and implemented scalable data pipelines utilizing Snowflake components like File Formats, Stages, Snowpipe, Streams, and Tasks for automated and near real-time data processing.
-Developed optimized Snowflake SQL queries and procedures for efficient data transformation and complex business logic implementation.
-Implemented clustering keys and performance tuning techniques to optimize large dataset queries and improve processing times.

Data Integration:
-Built and maintained ETL/ELT workflows using Matillion and Fivetran, ensuring seamless integration of data from various sources into Snowflake for centralized analytics.
-Automated ingestion of semi-structured data (JSON, Parquet) into Snowflake and flattened data using VARIANT columns and FLATTEN functions.

Data Modeling and Warehousing:
-Designed robust data models in Snowflake, aligning with business requirements to enhance analytics and visualization layers.
-Developed a dimensional model (star and snowflake schemas) for efficient querying and seamless integration with Tableau dashboards.

Analytics and Visualization:
-Created advanced Tableau dashboards powered by Snowflake to deliver actionable insights for Cisco's Senior Leadership.
-Implemented backend logic in Snowflake for analytics solutions such as Customer Segmentation, Churn Prediction, and Market Basket Analysis.

Python for Data Engineering:
-Developed Python scripts for integrating with Snowflake, automating ETL tasks, and managing embedded passwords in Tableau workbooks.
-Created Python-based workflows to extract data from Oracle, SAP HANA, and Snowflake for processing and publishing in Tableau.

Data Governance and Security:
-Ensured compliance and governance by implementing role-based access control (RBAC) and masking policies in Snowflake.
-Managed secure data sharing between internal and external accounts using Snowflake Secure Data Sharing for collaboration.

Operations and Maintenance:
-Oversaw the internal operations team, ensuring system maintenance, support, and execution of critical enhancements.
-Monitored Snowflake warehouses and pipelines for performance and cost optimization.

Data Engineering and Integration:
-Managed data ingestion workflows from diverse sources into Snowflake, Oracle, and SAP HANA, using Python scripts and manual loading techniques.
-Designed and implemented ETL pipelines for structured and semi-structured data, ensuring seamless integration into the Snowflake system for downstream analytics.
-Created and loaded tables in SAP HANA, optimizing them for visualization and reporting requirements.

Backend Development and Optimization:
-Developed Packages, Procedures, and Functions in Oracle and SAP HANA to automate data transformation and ensure data consistency.
-Built Attribute Views, Analytical Views, and Calculation Views in SAP HANA to aggregate data and prepare it for visualization in Tableau.
-Wrote complex SQL scripts and backend logic to clean, model, and enrich data, meeting the requirements of business executives and visualization teams.

Data Governance and Modeling:
-Implemented robust data modeling techniques using Oracle, SAP HANA, and Snowflake to create scalable and query-optimized structures for analytics.
-Ensured accurate data cleaning and preparation for key datasets like Bookings, Revenue, Pipeline, Competitor Data, Install Base, and Service Agreements.

Visualization Support and Analytics:
-Created curated datasets and data models tailored for Tableau dashboards, optimizing performance and flexibility for interactive reports.
-Developed information views in SAP HANA to ensure accurate and efficient visualization of business-critical KPIs.

Data Visualization Expertise:
-Designed interactive and insightful Tableau dashboards for diverse business teams, including Sales, Finance, Marketing, Product Management, and Customer Success teams.
-Utilized advanced Tableau features such as LOD Expressions, Calculated Fields, Parameters, Joins, Blending, Groups, and Dashboard Actions to meet complex visualization requirements.
-Enabled actionable insights through dashboards focused on critical metrics like Customer Trends, Subscription Analytics, and Revenue Insights.

End-to-End Solutions Delivery:
-Collaborated with stakeholders to define requirements, develop technical solutions, and implement end-to-end pipelines integrating backend data processing with frontend visualization.
-Ensured data accuracy and timeliness for all visualizations, directly impacting strategic decisions made by senior leadership.

Data Engineering and Development:
-Developed and optimized Packages, Procedures, and Scripts to implement complex functionalities and business requirements in Snowflake, Oracle, and SAP HANA.
-Designed and tested backend processes to support cross-functional data requirements, ensuring high performance and scalability for production systems.
-Committed code to Crucible for peer review, following best practices in coding standards and deployment processes.

System Knowledge and Documentation:
-Acquired comprehensive functional knowledge of the existing system, documenting workflows, dependencies, and data pipelines to enhance team understanding and onboarding.
-Conducted impact assessments for changes in cross-functional applications, ensuring seamless integration and minimal disruption to the production environment.

Application Support and Issue Resolution:
-Coordinated with the Application Support team to identify and resolve critical issues during post-go-live phases, ensuring system reliability and user satisfaction.
-Monitored and analyzed cross-functional changes, collaborating with stakeholders to address potential risks and their impact on application performance.

Stakeholder Collaboration:
-Engaged with Cisco leaders and clients to address and manage their requirements, ensuring alignment with organizational goals and providing real-time updates on progress.
-Facilitated Knowledge Transfer (KT) sessions for Application Support and Cross-Functional Teams, ensuring smooth transitions and consistent system knowledge.

Cross-Functional Impact Assessments:
-Collaborated with IT and business teams to monitor changes in interdependent systems, performing detailed impact assessments and implementing mitigations.
-Maintained proactive communication with cross-functional stakeholders to align on application changes and enhancements.

Leadership and Post-Implementation Support:
-Provided post-go-live support, collaborating with application teams to ensure system stability and performance in production.
-Led initiatives to improve system processes and streamline workflows, ensuring long-term maintainability and efficiency.

Data Issue Resolution:
-Conducted root cause analysis for performance issues in Concurrent Programs and PL/SQL procedures, collaborating with development teams to implement optimized solutions.
-Designed and executed Production Data Fixes (PDF) for resolving critical data issues, ensuring data integrity and compliance across applications.
-Created complex SQL queries for on-demand ad-hoc reports requested by clients, delivering actionable insights on tight timelines.

Monitoring and Performance Optimization:
-Continuously monitored production environments, ensuring optimal performance of Concurrent Programs and resolving bottlenecks proactively.
-Identified and resolved performance inefficiencies in production data pipelines, contributing to overall system stability and speed.

Requirements Analysis and Impact Assessment:
-Analyzed business requirements for new projects, conducting detailed impact assessments to ensure seamless integration with existing systems.
-Collaborated with cross-functional teams to address dependencies and risks associated with new developments and updates.

Incident and Escalation Management:
-Managed customer-raised incidents, providing timely resolutions within agreed SLAs and prioritizing tasks based on severity and business impact.
-Acknowledged and resolved client escalations, ensuring high-priority issues were addressed with minimal downtime or disruption.

Collaboration and Knowledge Transfer:
-Attended Knowledge Transfer (KT) sessions for new application changes and updates, ensuring smooth transitions between development and support teams.
-Shared insights and conducted KT sessions for cross-functional teams to enhance operational knowledge and system understanding.

Stakeholder Reporting and Insights:
-Delivered ad-hoc reports to stakeholders using advanced SQL techniques, providing insights into application performance and key metrics.
-Ensured clear communication with clients regarding issue resolutions and progress updates for ongoing incidents and projects.