Manoj Reddy Email & Phone Number

Columbia,Sc

• Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping necessary to support advanced analytics initiatives.• Worked closely to streamline data collection and validation processes, ensuring data integrity and compliance.• Utilized Athena for querying and analyzing large-scale datasets, significantly enhancing data-driven decision-making processes and used EMR, S3 for data processing and data storage.• Worked with Databricks as platform and used python, PySpark and sparkSQL for doing data analysis on JSON, CSV and delta tables.• Written pyspark scripts for ingesting JSON data. (Used Lake House architecture and used features such as Unity Catalog, DB-SQL, DBR-Workflows, DLT etc.,).• Good knowledge on data visualization and dashboard designing using Power BI.• Collaborated with cross-functional teams to support budgeting and strategic planning efforts, ensuring data accuracy and consistency across all reports.• Conducted in-depth analysis of financial data to identify trends, anomalies, and opportunities for cost savings, contributing to a 10% reduction in operational costs.• Developed and maintained financial models to forecast revenue, expenses, and profitability, improving accuracy by 30%.• Extensively used Tableau for customer marketing data visualization.• Partnered with stakeholders to understand data requirements and develop tools and models such as dashboards, data visualizations and business case analysis to support the organization.• Performed ad-hoc financial analysis to support strategic initiatives and investment decisions.• Conducted regular data quality audits within the PLM system, ensuring high data integrity and reliability for decision-making processes.• Created Data Quality Scripts using SQL and Hive to validate successful das ta load and quality of the data. Created various types of data visualizations using Python and Tableau.

Columbus, Ohio, United States

▪ Participated in daily scrum meeting with team to discuss on the challenges and development of the project▪ Involved in requirement gathering from business users and IT teams to understand and express business process and business logic.▪ Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.▪ Worked with ADF and Azure Databricks for doing the data ingestion and doing data processing.▪ Worked extensively with snowflake data ware house database and used snowflake database for doing all the adhoc data analysis.▪ Worked with External tables with in snowflake and used snowflake as backend for BI reporting.▪ Extracted data from data warehouse server by developing complex SQL statements using stored-procedures and common table expressions (CTEs) to support report building▪ Defining roles and responsibilities related to data governance and ensuring clear accountability for the stewardship of the company’s principal information assets.▪ Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.▪ Created dynamic dashboards and reports using Power BI and Tableau to provide real-time financial insights to senior management, enhancing decision-making processes.▪ Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.▪ Leveraged Azure Blob Storage for cost-effective data archival and retention, ensuring seamless data management and compliance with data governance policies.▪ Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions.▪ Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.

Boston, Massachusetts, United States

• Provided training sessions to key stakeholders on interpreting forecast outputs and leveraging them for strategic decision-making.• Conducted post-implementation analysis to measure the impact of the forecasting model on inventory management and supply chain efficiency.• Worked with kafka for ingesting the data from multiple sources and store it on data lake.• Conducted data quality assessments and validations to ensure accuracy, completeness, and consistency of data captured at different states within the business process, implementing data governance policies and controls as needed.• Used python and Sql for doing data analysis and documenting the findings in STM.• Involved in design and development and deployment of the application.• Developed Spark applications in python to interact with PostgreSQL database using Spark SQL Context and accessed Hive tables via Hive Context for efficient data processing.• Contributed to the design of various system components including Spark for big-data event processing, Kafka for distributed messaging, and PostgreSQL for SQL database management.• Integrated product data feeds from Kafka into Spark processing system, storing order details in PostgreSQL database to facilitate seamless data flow and analysis.• Designed and managed Hive tables, implementing Dynamic Partitioning and Buckets for optimized data access and storage efficiency.• Structured tables and columns in Redshift for effective data distribution across data nodes, adhering to columnar database design principles.• Used DAX functions FHIR to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.• Conducted comprehensive analysis of EHR data using Athena, improving patient care quality and operational efficiency.• Provided training to staff on data analysis techniques and best practices for data management within the EHR system.

Hyderabad, Telangana, India

• Contributed to the design of the overall database structure using Entity Relationship diagrams, ensuring optimal data organization and relationships.• Participated in building, debugging, and running forms, ensuring seamless functionality and usability.• Managed data loading and extraction functions using SQL*Loader, facilitating efficient data transfer and management.• Documented entity-relationship diagrams (ERDs), data dictionaries, and metadata definitions to communicate data structures, relationships, and data states effectively to technical and non-technical stakeholders.• Designed and developed tables and views in Oracle to support system requirements, optimizing data storage and retrieval processes.• Developed triggers, menus, and stored procedures in PL/SQL, enhancing application functionality and data integrity.• Demonstrated a commitment to continuous learning and development activities, staying abreast of industry trends and best practices.• Conducted back-end testing for the application, ensuring data integrity and system reliability.• Executed manual testing for integration and acceptance, validating system functionality against business requirements.• Conducted both negative and positive testing for the application, identifying and addressing potential issues to enhance user experience.