Data Analytics Quality

Ronakkumar Shah

Sr. Data Analytics Engineer

****.**********.*@*****.*** 510-***-**** in/ronakkumar-shah Tableau Portfolio Professional Experience

Sr. Data Analytics Engineer, Wells Fargo Jun 2023 – present San Leandro, CA

•Managed data strategy for RMe applications, ensuring quality, integrity, and compliance across CRM systems and LOBs.

•Supervised data integrity for downstream integrations, reporting, and analytics, ensuring accurate data transmission to LOBs.

•Built and optimized Tableau dashboards for Leadership, the RMe Team and Operations, focusing on KPIs related to Product Data Management in Commercial Banking Sales Enablement and Product Insights, leveraging CRM Systems.

•Developed and executed tailored SQL queries with MS SQL Server and Teradata for CRM Scorecard dashboard, ensuring Data Quality (DQ) compliance. Analyzed user activities and trends, providing detailed insights and drill- down reports for strategic decision-making.

•Added monitoring features to the CRM Scorecard dashboard to track usage trends of active users across various third-party CRM applications (e.g., C360, D&B Hoovers, Seismic, ZoomInfo, Sales Navigator), providing actionable insights to optimize workflows and enhance productivity.

•Analyzed monthly trends in unique user logins and mobile adoption for CRM applications to generate actionable insights.

•Enhanced data quality by identifying and addressing issues, displaying distributions, and detailing open defects related to data quality rules for CRMs, including Commercial Capital (WFCC), Middle Market Banking – Relationship View (RV), and Small Business Administration (SBA). Sr. Business Intelligence Analyst, Kinesso Jun 2014 – Jun 2023 San Francisco, CA

•Proven expertise in analyzing programmatic advertising performance data stored on the Snowflake Data Warehousing Platform. Implemented SQL queries to extract actionable insights from the data, enhancing understanding of advertising campaign performance, and improving return on ad spend.

•Skilled in configuring Snowflake stages, Snowpipe, and tasks for efficient data ingestion from Amazon S3 and Azure Containers, handling formats like CSV and JSON, and managing Snowpipe notifications and event integrations for streamlined data loading and transformation.

•Constructed a comprehensive data model for performance data using SQL Database Modeler, creating tables to represent entities, ensuring data integrity by establishing relationships between tables and enforcing referential integrity for efficient querying.

•Structured Snowflake schemas to create a logical framework for objects such as tables, views, and indices, optimizing data storage, retrieval, and analysis.

•Developed interactive Tableau dashboards with advanced features like custom visualizations, calculations, embedded dashboards, sheet swapping, dynamic visibility, and zoom functionalities to clearly communicate programmatic and financial insights to stakeholders.

•Skilled in utilizing Power BI Desktop to design insightful and visually compelling dashboards, with practical experience in writing DAX measures for data analysis and transformation.

•Crafted Python scripts and used the Pandas library to construct data frames, enabling the collection and analysis of data from Datorama through REST APIs.

•Integrated diverse Ad Server data sources including Google Campaign Manager 360, Doubleclick Bid Manager, Google Analytics, Facebook Ads, Adform, Flashtalking, MOAT Display and Video, X, Google Ads, Integral Ad Science, Sizmek, DoubleVerify, and DSP data from platforms such as DV360, TubeMogul, The Trad Desk, BrightRoll, Teads, Adelphic, Adform, PulsePoint, LoopMe, Invite Media, DeepIntent, and Amobee into the Salesforce Marketing Cloud Intelligence (Datorama) platform, ensuring seamless data ingestion, standardization, loaded into a defined data model with established business logic.

•Set up and administered over 2000 Advertiser/Client Workspaces across 36 markets on the Datorama Platform, configuring local currency conversions, ad server and DSP integrations, time zones, date formats, and metrics to meet market-specific requirements and ensure effective data display.

•Led offshore and onsite teams to ensure efficient business operations across multiple markets. Collaborated with IT operations during deployment and supported the support team in addressing campaign managers' queries.

•Applied CI/CD processes using Jenkins for automating builds and Docker image creation, managed Docker images in S3, and deployed using Spinnaker to Kubernetes clusters.

•Documented details on data sources, transformation processes, data dictionary, and other relevant information related to marketing analytics solutions in Confluence. Business Intelligence Analyst, AnaSpec Nov 2012 – Jun 2014 Fremont, CA

•Extracted and interpreted data from MAS 200 and Salesforce to create reports offering insights into the company's financial performance, sales trends, and customer behavior.

•Created SAP Crystal Reports and SAP Dashboards based on revenue, sales, and invoice history data, enabling the company to gain insights into its financial performance and enhance data-driven decision-making

•Conducted comparative analysis of life science research data to deliver key sales insights, forecast future sales, and support strategic decision-making and business planning. Business Intelligence Developer, Klouddata, Inc. Mar 2012 – Oct 2012 Fremont, CA

•Generated artifacts such as process flows, business requirement documents, and functional and non-functional requirement documents to effectively capture and communicate requirements.

•Designed dashboards for financial, banking, healthcare, and supply chain management using SAP Dashboards Design 4.0 for the Klouddata website, improving data visualization and analysis for clients. Business Analyst, Alot Hitek Pvt. Ltd. Aug 2007 – Aug 2008 Mumbai, India

•Collaborated with stakeholders and subject matter experts to gather requirements, create prototypes and mockups using Dreamweaver and Photoshop, and ensured alignment with business objectives through iterative feedback and verification.

•Engineered financial, inventory, sales, and KPI dashboards using the Web Intelligence (WEBI) tool. Utilized cross- tab, detailed, and drill-down/up functionalities to deliver comprehensive insights into key business metrics for upper management.

Skills

Business Intelligence Tools: (Tableau Desktop, Tableau Server, SF Marketing Cloud Intelligence (Datorama), Power BI Desktop, Snowsight, SAP Crystal Reports, SAP WebI, SAP Information Design Tool, SAP Dashboards Design 4.0, SAP Business Objects xcelsius, SAP Business Objects BI Platform), DB & DW: (MS SQL Server, Teradata, Snowflake, Amazon Athena, Amazon Redshift, MySQL, SQLDBM, DBeaver, Cyberduck), Languages: (SQL, DAX, PL/SQL, Python, Pandas), SDLC Methodologies: (Agile, Scrum), DevOps Tools: (Jira, Confluence, Jenkins, Docker Image, Spinnaker, Kubernetes Clusters), Cloud Storage Platform: (Amazon S3, MS Azure), REST APIs Call: (Postman) Education

Masters in Engineering/Industrial Management,

California State University - East Bay

2009 – 2011 Hayward, USA

Bachelor’s Degree in Chemical Engineering,

Sinhgad College Of Engineering Pune University

2003 – 2007 Pune, India

Awards

Received “There is No I in Awesome” Award from Cadreon, Cadreon Certificates

Tableau Desktop

Contact this candidate