Narasimha Reddy

Project: Marketing Insights.

• Worked with the Demand Generation team to develop and maintain Marketing Funnel Metrics Dashboards, integrating Salesforce and Marketo lead data to track key conversion stages (Leads, MQLs, SQLs, Opportunities, and Wins), analyze lead sources, and provide insights for optimizing marketing strategies, and improving pipeline efficiency.
• Developed and maintained marketing program lead tracking dashboards, integrating campaign performance, lead responses, and account engagement to analyze lead generation effectiveness from marketing programs. Provided insights on lead conversion rates, organization-level engagement, and influenced spend, enabling marketing and sales teams to optimize outreach and campaign strategies.
• Built marketing campaign lead sales activity reports, tracking lead acceptance rates, acceptance timeliness, and lead ownership distribution. Analyzed lead progression metrics from Leads to MQLs, SALs, Opportunities, and Wins, providing insights on sales channel trends, activity types (emails, pitches, meetings, LinkedIn), and engagement by sales owners. Enhanced visibility into member status updates, sales effectiveness, and conversion performance for marketing-driven leads.
• Developed a Sigma dashboard to analyze G2 seller and buyer intent reports, and marketing intelligence reviews, providing data-driven insights into customer engagement, optimizing marketing strategies, and competitive positioning.

Project: Sales and Data Warehouse Operations.

• Collaborated with the Sales Operations team to provide comprehensive sales pipeline metrics, including unweighted and weighted pipeline values, billings, bookings, revenue tracking, actualized and pro forma metrics, discounted and rebated amounts, and currency-adjusted budgets. Leveraged opportunity and delivery data to enhance sales forecasting, deal tracking, and performance analysis across regions, verticals, and customer segments.
• Identified and resolved data quality issues in the sales pipeline, ensuring accuracy and consistency in pipeline metrics and billings.
• Analyzed long-running queries using Snowflake's query profiling tools, and implemented tuning strategies such as query rewriting, micro-partitioning, clustering keys, and result caching, resulting in significantly reduced execution times.
• Built dashboards using Sigma Computing for customers and leadership to visualize and comprehend data, enabling them to draw conclusions. Additionally, I migrated a few dashboards from Tableau to Sigma.
• Participated in a 24/7 on-call rotation for critical data pipelines and ETL processes, diagnosing and resolving production issues in real time with tools like Grafana and Datadog, collaborating with different teams, and maintaining runbooks and post-mortem reviews to drive continuous improvements.
• Managed Jenkins projects to execute Docker commands, streamlining containerized application builds, tests, and deployments. Fixed a few Docker build-related issues.
• Reharvested fact and dimensional tables multiple times using automated processes to resolve recurring data discrepancies, ensuring up-to-date, accurate analytics for critical reporting.

Project: Data Warehouse Development.

• Performed schema-related activities, including adding new columns, creating and maintaining fact and dimensional tables, and modifying existing structures to support evolving business requirements and ensure data integrity.
• Worked on creating new ETL framework using python, SQL that brings data from Salesforce, PostgreSQL and other databases to Snowflake and migrating the full and incremental load ETL Jobs from Pentaho to the framework. The new framework reduced the ETL development time from one week to one hour.
• Transformed complex, multi-join views into pre-computed materialized tables in Snowflake, significantly reducing query execution times by 70%, and enhancing overall dashboard performance.
• Created daily snapshot tables capturing the state of key fact tables, providing a consistent historical data view to support accurate forecasting models, and trend analysis for improved decision-making.

Project: Digital Analytical Reports Delivery.

• Helped customers, Account Managers, TAS, and TAMs gain insights through custom delivery performance reports. These reports included internal and third-party metrics, such as Budget Delivered, Revenue, Impressions, Clicks, Views, Click Conversions (cookie and cookieless), View Conversions, Viewability, Reach, CTR, CPA, and ROAS. Provided multi-level data segmentation, offering breakdowns by campaign, ad set, creative, day, month, and other key dimensions.
• Developed site visit reports to help customers, Account Managers, TAS, and TAMs analyze user engagement, attribution, and performance metrics. These reports segmented visitor data by device type, location, and session behavior, while integrating campaign and budget insights to distinguish between new prospects and retargeted users.
• Developed Path to Conversion reports to analyze user journeys from the first ad impression to conversion. Provided insights into key touchpoints, ad set performance, targeting effectiveness, and time-to-conversion metrics, helping AMs optimize campaign strategies.
• Developed overlap reports to analyze audience targeting efficiency by comparing impressions, reach, and conversions across multiple ad groups. Provided insights into new site visitors, page visit rates, and audience overlap to optimize campaign performance.
• Built and delivered insights through various reporting solutions, including Converter Frequency Reports (analyzing conversion likelihood based on ad exposure), Delivery Frequency Reports (tracking ad impressions per user to optimize reach), Frequency Distribution Reports (breaking down user engagement by exposure levels), Non-Conversion Event Reports (analyzing actions like page visits and video views), Client-Specific Custom Reports (tailored KPI tracking for business needs), and Funnel Visualizer Reports (mapping user journeys to identify drop-offs and optimization opportunities).
• Automated daily, weekly, and monthly custom reports using Python in Jupyter Notebooks, incorporating email notifications, and automated uploads to customer S3 locations for seamless report delivery.

Project: ETL Development / SSIS Packages

• Enhanced teamwork skills by participating in impactful projects alongside a 12-member group at an esteemed U.S. healthcare organization.
• Developed and implemented SSIS packages to automate data extraction, transformation, and loading processes, leading to a 30% reduction in manual effort, and enhanced data accuracy.
• Expertise in writing SQL queries, dynamic queries, subqueries, and complex joins for generating complex stored procedures, triggers, and user-defined functions.
• Provided backend data support to .NET developers by optimizing SQL queries, troubleshooting data integration issues, and ensuring robust, high-performance application functionality.
• Developed interactive Power BI dashboards that integrated data from various sources to provide real-time insights, facilitating more informed decision-making, and optimizing reporting processes.

Backend Integration Testing:

• Performed functional and regression testing using ALM to log test cases and track defects, ensuring system stability after new deployments and downstream processes.
• Conducted performance testing while loading data from Kafka to Microsoft SQL Server, validating data integrity, system scalability, and processing efficiency.
• Executed API endpoint testing using Swagger to validate CRUD operations (Create, Read, Update, Delete), ensuring seamless API interactions and data consistency.
• Deployed and validated code in pre-prod and UAT environments, collaborating with the DB team to deploy SQL scripts, and participating in production support and testing for smooth releases.