Home

Sai Prasanna - Data Analyst

[email protected]

Location: Gastonville, Pennsylvania, USA

Relocation:

Visa: h1b

Resume file: Data_Analyst_Resume_1746645197054.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

NAME : SAI PRASANNA MUNNANGI Data Analyst Contact: 302-688-6036 G-Mail: [email protected] PROFESSIONAL SUMMARY: Over 5+ years of Professional Experience in different environments and platforms including Data Analysis, data warehousing, data modelling, data visualization using Tableau, data cleaning on Client-Server applications in Financial Industry. Good Knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI) tools. Experience in ServiceNow to customization of modules, CMDB policies, Discovery. Established various connections to Data Sources via SQL server, Teradata, Databricks, etc. Hands on with Tableau Desktop (dashboard creation, report authoring and troubleshooting, data source management). Expert Knowledge on interactive filters, parameters, and calculations for preparing dashboards & Stories in Tableau. Designed, develop, manage, document, and troubleshoot with the Power Query and DAX. Strong IT experience in the field of Data analysis, Data Modelling, Data Validation, Predictive modelling, Data Visualization, Adept in statistical programming languages like Python. APM Solution Designing and Delivery Expertise in Telecom, logistics and retail domains. Have extracted data from various database sources like Oracle, SQL Server, accessing JIRA tool and other internal issue trackers for the Project development. Involved in creating Dashboards, reports as needed using Tableau Desktop and ServiceNow. Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using multiple ETL tools such as Informatica Power Centre Extensively used Informatica PowerCenter, as ETL tool for extracting, transforming, loading, and cleansing data from various source data inputs to various targets, in batch and real time. Expertise in generating data visualizations using Python and creating dashboards using tools like Tableau or PowerBI. Expert on maintaining and managing Tableau reports, dashboard, and publishing to the end users for Executive level Business Decision. Extensive experience with OLTP/OLAP System, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional modelling. Expertise with data cleansing, data matching, data conversion, data profiling, exception management, reporting and monitoring functions. Knowledge with Python including Scikit-learn, NumPy, SciPy, Pandas, and NumPy developing machine learning models, manipulating, and handling data. Involved in the entire data science project life cycle and actively involved in all the phases including data extraction, data cleaning, statistical modelling, and data visualization with large data sets of structured and unstructured data, created ER diagrams and schema. TECHNICAL SKILLS: Data Visualization Tableau, Power BI, Alteryx, Google Looker Studio Language & scripting Python, PLSQL, TSQL Database & Data Ingestion Tools MySQL, GCP, Oracle, SQL Server, Teradata Tools Jira, Excel, Jupiter Notebook, MS Office, SSMS Extract Transform Load (ETL) Informatica and DataStage. Cloud Computing Tools Azure, AWS, GCP, Snowflake PROFESSIONAL EXPERIENCE: Client: Nike, New York, New York|| June 2022- Till date Role: Data Analyst Roles and Responsibilities: Power BI Development Proficient in designing and creating captivating Power BI reports and dashboards. Skilled in data modelling, establishing relationships, and managing data sources within Power BI Desktop. DAX (Data Analysis Expressions)Expertise in crafting DAX formulas for intricate calculations, aggregations, and custom measures and calculated columns. Accomplished in implementing complex DAX logic. Data Transformation Adept at transforming and cleansing data using Power Query Editor in Power BI. Experienced in handling intricate data transformations and shaping tasks. Prepared training materials and train users on new features and functionalities on ServiceNow. Data Modelling Experienced in constructing effective data models to meet business requirements, including the creation of star schemas, snowflake schemas, and management of role-playing dimensions. Data Integration Skilled in seamlessly integrating data from diverse sources into Power BI, encompassing databases (SQL Server, Oracle), cloud services (Azure, AWS), Excel, and web services. After stress test analyze reports from both Application and APM management end. Collaborated with cross-functional teams to gather business requirements, document processes, and design solutions to improve business performance. Developed and optimized complex SQL queries to extract data from relational databases and generate actionable insights for the business. Automated segmentation workflows using S Query Builder to streamline campaign targeting and improve data accuracy by 25%. Advise customers towards implementing the ServiceNow platform and applications according to best practice Created interactive dashboards and reports in Tableau, providing stakeholders with real-time data visualizations and performance metrics. Built REST APIs to easily add new analytics or issuers into the model. Installed and configured APM agents on various Application servers like WebLogic, JBoss and IIS. Provided ad-hoc data analysis to support strategic decision-making for senior management. Trained team members and business users on how to effectively use Tableau dashboards for data-driven decisions. Assisted in the creation of detailed business requirements documents (BRD) and functional specifications. Extracted, cleansed, and analyzed data from various sources using SQL queries to support business initiatives. Built and maintained Tableau dashboards and reports to track KPIs, sales performance, and customer Behavior. Conducted root cause analysis and collaborated with IT to implement data solutions that improved data accuracy and business insights. Supported senior analysts in preparing presentations for stakeholders, translating technical information into easily understandable business terms. Experience creating, publishing/sharing report for different modules on ServiceNow usingKPIs. Power BI Service Proficient in publishing and administering reports and dashboards on the Power BI Service. Capable of configuring security settings, workspaces, and facilitating report sharing with stakeholders. Performance Optimization: Accomplished in optimizing Power BI solutions to enhance performance by reducing query load times, improving report rendering, and streamlining data refresh processes. Conducted data cleansing and normalization via S Query Builder, ensuring high data integrity across customer journeys. Custom Development Proficient in custom development tasks such as crafting custom connectors, Power BI templates (PBIT), and implementing Power BI Embedded solutions where necessary. Working Knowledgeable in implementing robust data security measures in Power BI, including Row-Level Security (RLS) and object-level security, to ensure data privacy and compliance. Proficient in SQL for efficient data querying, manipulation, and management, complementing Power BI development capabilities. Experienced in utilizing version control systems like Git for effective project management and seamless collaboration with fellow developers. Created Java Agent packages via APM Command Center (ACC) and deployed the Agent binaries in to 4000+ Linux servers. Built scheduled automation using S Query Builder queries in conjunction with Automation Studio to support daily, weekly, and monthly reporting needs. Adept at understanding and translating complex business requirements into actionable insights within Power BI, facilitating informed decision-making. Communication Skills: Excellent communication skills, facilitating effective interaction with business stakeholders, including requirements gathering and insights presentation from Power BI reports. Strong programming skills in Python for building automations and data extraction, strong exposure in data integration with third party tools. Expert with Azure Data Factory, Azure Databricks, and Azure Synapse. Involved in creating different reports based on business requests and ad hoc requirements using Tableau desktop. Prepare financial deliverables (quarterly, accrual and budgetary reports) for stakeholders to illustrate KPI metrics. Highlight your proficiency in designing and developing interactive and insightful Tableau dashboards and reports. Mention your experience in creating calculated fields, sets, and groups. Identify Services and initiate implementation rules for the Service Catalog in ServiceNow. Data Visualization skills in creating compelling data visualizations using Tableau's various chart types, maps, and interactive features. Translated business requirements into scalable SQL logic using S Query Builder, improving operational efficiency and campaign ROI. Gathered business requirements from stakeholders across various departments to create detailed functional and technical specifications. Designed and implemented SQL queries to retrieve, manipulate, and aggregate data, facilitating the creation of ad-hoc and regular reports. Developed and maintained interactive Tableau dashboards to visualize key metrics such as sales performance, operational efficiency, and customer Behavior. Automated reporting processes, reducing manual reporting efforts through the use of Tableau and SQL scripts. Provided actionable recommendations based on data trends, enabling informed decision-making for business leaders and cross-functional teams. Assisted in gathering and analyzing business requirements, working closely with both IT and business teams to define and prioritize project deliverables. Develop REST APIs to provide consumers wif necessary data to develop dashboards and reports Wrote SQL queries to extract and clean data for business reporting, ensuring high data quality and integrity. Developed Tableau dashboards to monitor key business metrics, including financial performance, product lifecycle, and customer satisfaction. Conducted ad-hoc data analysis to support business initiatives and identify opportunities for process improvements. Assisted in the creation of business reports and presentations, translating complex data into clear, understandable insights for management and stakeholders. Work ability to connect Tableau to various data sources, including databases (SQL Server, Oracle), cloud platforms (AWS, Azure), spreadsheets, and web data connectors. Skilled in data preparation and cleansing using Tableau Prep or other ETL tools. Discuss how you've handled complex data transformations and data integration tasks. Also worked on the implementation of Incident Management, Problem Management, Change Management, Event Management, CMDB, Reporting, Service Catalog in ServiceNow. Worked on SQL and Database Include your proficiency in SQL for writing custom queries, joining tables, and performing data manipulations. This is often a complementary skill for Tableau developers. Data Modelling experience in creating effective data models within Tableau, including building relationships, hierarchies, and aggregations to support business requirements. Extract data from external REST API s using Postman to perform data analysis Version Control experience on using version control systems (e.g., Git) for managing Tableau projects, collaborating with other developers, and maintaining a history of changes. Ability to understand and translate business requirements into effective Tableau solutions that provide actionable insights for stakeholders. Effective communication skills, as effective communication with business users is essential for gathering requirements and explaining insights derived from Tableau reports. Environment: SQL Server, Teradata, MySQL, Data Warehouse, ETL, Looker Studio, Tableau & Power BI, Python, GCP, Data Lake, Azure Data Factory, Data Bricks, Informatica (Extract, Transform, Load), Client: NISUM, Hyderabad, India|| Sep 2019- Oct 2021 Roles: Data Analyst Roles and Responsibilities: ETL processes to extract, transform, and load data from multiple sources, ensuring data accuracy and consistency. Designed and developed interactive and visually appealing dashboards and reports using Tableau, Power BI, and Looker Studio, resulting in improved data accessibility and user engagement. Collaborated with cross-functional teams to gather business requirements and translated them into effective data visualizations and reporting solutions. Improved forecasting accuracy through in-depth data analysis and process optimization. Automated key reporting workflows using SQL and Python, reducing manual efforts by 30% and enabling real-time analytics. Work with functional and admin teams to deliver automated workflow solutions in ServiceNow. Designed and executed complex SQL queries to analyze business data, achieving a 25% improvement in data-driven decision-making accuracy. Performed competitive landscape analysis that directly contributed to a 15% increase in market share. Developed Power BI visualizations to support executive decisions, decreasing report preparation time by 40%. Utilized advanced SQL queries and scripting to extract and manipulate data from various databases, optimizing data retrieval and transformation processes. Implemented data modelling techniques to create robust data structures, enabling efficient data analysis and insights generation. Performed data validation and quality checks to maintain data integrity and reliability, resolving discrepancies promptly. Performing teh Business Analysis role for enhancements, including new ServiceNow modules. Conducted regular performance tuning and optimization of Tableau, Power BI, and Looker Studio solutions to ensure optimal report rendering and responsiveness. Worked closely with business stakeholders to understand their needs and provided training and support to ensure effective usage of reporting tools. Collaborated with IT teams to maintain and upgrade reporting tools, ensuring compatibility with the latest software versions. Contributed to the development of best practices and documentation for data reporting and visualization standards within the organization. Successfully managed a portfolio of reports and dashboards, ensuring timely updates and accurate data representation. Develop executive level dashboards for I.T leader, leveraging teh ServiceNow backend. Designed and implemented a comprehensive Tableau dashboard that provided real-time insights into sales performance, resulting in a 20% increase in revenue within the first quarter of deployment. Played a pivotal role in migrating the reporting environment to Looker Studio, enhancing report delivery efficiency and reducing licensing costs by 10%. Received recognition for consistently delivering high-quality reports and dashboards, contributing to data-driven decision-making across departments. ETL (Extract, Transform, Load) Tableau Power BI Looker Studio SQL Data Modeling Data Validation Performance Optimization Data Visualization Business Requirements Gathering Cross-functional Collaboration Documentation. Prepared weekly and monthly project status reports using JIRA and SQL and delivered it to appropriate project team members and stakeholders. Experience in Converting Hive/SQL Queries into Spark transformations using Java and experience in ETL development using Kafka, flume and Sqoop. Developed Spark Code and Spark-SQL/Streaming for faster testing and processing of data. Designed and implemented an ETL framework to load data from multiple sources into Hive and from Hive into Teradata. Build Docker Images to run airflow on local environment to test the Ingestion as well as ETL pipelines. Good experience in Hive Data Warehousing concepts like Static/ Dynamic Partitioning, Bucketing, Managed, and External tables, Join operations on tables. Used Spark-SQL to Load JSON data and create Schema RDD and loaded it into Hive Tables and handled Structured data using Spark SQL. Expertise in publishing and managing reports on Tableau Server or Tableau Online. Discuss your experience with user access control, security settings, and scheduling data refreshes. Performance Optimization: Explain your ability to optimize Tableau dashboards and reports for performance by reducing query times, improving rendering speed, and optimizing data extracts. Working knowledge of advanced calculations and scripting within Tableau, such as table calculations, LOD (Level of Detail) expressions, and Python integration for advanced analytics. Used Python and R scripting by implementing machine algorithms to predict data and forecast data for better results. Experience in developing packages in R studio with a shiny interface Generated and injected Vehicle IOT data to AWS IOT platform using python. Published IOT Data to Kafka Stream, consumed by a spark module to perform predictive analysis using Random Forest Machine learning algorithm. Utilized Redshift to storing the processed records and implemented batch scripts for continuous learning. Writes SQL Stored Procedures and Views and performs in-depth testing of new and existing systems. Manipulate and prepare data, extract data from database for business analyst using Tableau. Review normalized schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments. Exploits power of MS SQL to solve complex business problems by data analysis on a large set of data. Environment: Tableau, Teradata, Python & MySQL, Tableau, Scala, GCP, Spark, Hive, NiFi, Kafka, Shell Scripting, Cloudera, MongoDB, AWS. Keywords: business intelligence active directory rlang information technology microsoft