Ravikanth Ponugupati

<p>Working with database tables, spreadsheets, and unstructured data to identify the client data needed and where the data is stored</p><p> Involve in loading of data in between the schemas using Oracle One Source Database Loader</p><p> Cross walk client data schema to internal data requirements to identify the client data needed and where the data is stored</p><p> Creating Extract in SQL scripts to help correct data issues or trigger system activities based on customer requests</p><p> Migrate the existing data into Amazon Redshift Database using PL/SQL programming, triggers, views, and functions</p><p> Used excel sheet, flat files, CSV files to generated Tableauad-hoc reports</p><p> Built R scripts to calculate performance metrics, changed content management user training by enhancing current methods and improved internal QA testing methods which improve strategies and business governance operations</p><p> Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team</p><p> Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions for the company</p><p> Worked with Pandas, NumPy, and Matplotlib for developing various algorithms</p><p> Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau</p><p> Developed Tableau data visualization using Scatter Plots, Geographic Map, Pie Charts and Bar Charts, and Density Chart</p><p> Generated PL/SQL scripts for data manipulation, validation, and materialized views for remote instances</p><p> Responsible for resolved data investigation issues and provide granular level information related to it and updated in Jira</p>

<p>Collected, cleaned, and analyzed user interaction and usability data to identify structural trends and directly improve digital product experiences</p><p> Created dynamic dashboards, comprehensive reports, and high-impact visual presentations to communicate actionable insights to stakeholders and cross-functional design teams</p><p> Conducted user behavior analysis and supported high-level data-driven decision-making for UX improvements and strategic product iterations</p><p> Build custom API to transfer formatted data into cloud storage which exports as a CSV file & GUI displaying real-time test records, resulted in display the information as user command</p><p> Performed Data Analysis and Data Validation by writing complex SQL queries</p><p> Proficient in main Business Intelligence technologies such as Tableau and Power BI for creating dynamic dashboards and reports for various business functions</p><p> Good Understanding of Visualization Techniques by creating summary and detailed reports Using Drill Down and Drill Through techniques</p><p> Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc. for summarizing and analyzing key analytics findings</p><p> Proficient in design and development of various dashboards, reports on Power BI Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement</p><p> Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring parameters, sorting, expressions, drill down and drill through, etc.</p><p> Well-knowledge how to pull data by using SQL Server and SSIS from database automatically</p><p> Organized and managed large-scale datasets related to digital assets and workflow operations to significantly improve internal efficiency and asset accessibility</p><p> Collaborated seamlessly with cross-functional teams to track strategic KPIs, evaluate performance metrics, and optimize internal operations</p><p> Case Collection, is a collected, cleaned, and analyzed user interaction and usability data with a full range of products and services, focused on specialty program business. The major line of business is funds management. Data warehouse was created to give the desired report to different clients</p><p> Technical Environment: Informatica, Repository Manager, Workflow Manager, Oracle 10g/9i, Teradata, UNIX and Shell scripting</p><p> Tools : Excel, Google Sheets, Data Visualization, UX Analytics, Reporting, Problem Solving, Stakeholder Communication</p>

<p>Monitored and analyzed high-volume operational data to ensure strict SLA compliance and optimize large-scale media workflow performance</p><p> Investigated platform irregularities and delivery bottlenecks using JIRA-based workflows, pinpointing root causes and improving incident resolution efficiency</p><p> Identified and analyze stakeholders and subject areas</p><p> Participated in Business Analysis, talking to business Users and determining the entities and attributes for Data Model</p><p> Identified and determined physical attributes and their relationships through cross-analysis of functional areas</p><p> Identified and analyzed source data coming from Oracle, SQL server and flat files</p><p> Used Informatica- Power center for extracting, transforming and loading</p><p> Performed Data profiling, Validation and Integration</p><p> Created materialized views to improve performance and tuned the database design</p><p> Involved in Data migration and Data distribution testing</p><p> Performed testing, knowledge transfer and mentored other team members</p><p> Maintained accurate operational records, rigorously validated metadata accuracy, and generated production reports to support management decision-making</p><p> Collaborated closely with technical and platform engineering teams to streamline digital asset management (DAM) systems and content delivery processes</p><p> Assisted in tracking operational workflow KPIs and identified key process improvement and cost-saving opportunities within an enterprise environment</p><p> Tools & Skills: Excel, JIRA, Data Analysis, Reporting, Workflow Optimization, Data Validation, Quality Assurance</p>

<p>The project involved creating an application that takes care of online account services which included Bill paying, Checking the bill history, collection, Account status. The data mart layer for this project is a UDB database schema. Data from warehouse is processed, transformed and loaded into the data marts for the users to generate reports</p><p> Analyzed complex customer engagement requirements and effectively translated core business needs into visually driven marketing metrics</p><p> Organized historical campaign and content data structures to support high-performance promotional activities and enhance communication effectiveness</p><p> Tracked ongoing marketing performance metrics and prepared structured visual presentations for stakeholder review meetings</p><p> Collaborated directly with startup founding teams to maximize brand visibility through data-informed design strategies</p><p> Technical Environment: Informatica Power Center v 8.6.1, Power Exchange, MS SQL Server, Teradata, PL/SQL, TOAD, Microsoft Project Plan</p><p> Tools : Data Interpretation, Presentation Design, Adobe InDesign, Visual Reporting, Communication</p>

<p>Managed and systematically organized multimedia project data ecosystems, ensuring absolute asset consistency, quality control, and timely delivery</p><p> Analyzed day-to-day production workflows to uncover operational efficiencies and streamline media content creation processes</p><p> Designed mapping and identified and resolved performance bottlenecks in Source to Target, Mappings</p><p> Developed Mappings using Source Qualifier, Expression, Filter, Look up, Update Strategy, Sorter, Joiner, Normalizer and Router transformations</p><p> Involved in writing, testing, and implementing triggers, stored procedures and functions at Database level using PL/SQL</p><p> Designed the logical and physical schema for data marts and integrated the legacy system data into data marts</p><p> Partnered with subject matter experts (SMEs) to structurally organize educational content data while maintaining thorough project documentation</p><p> Supported cross-stage reporting, tracking, and operational coordination activities across multiple concurrent media production cycles</p><p> Tools & Skills: Data Organization, Process Analysis, Project Coordination, Reporting, Communication</p>