Jawali Rikkala
***************@*****.***
Senior Data Analyst
PROFESSIONAL SUMMARY:
Extensive 6+ year career as a Senior Data Analyst specializing in data visualization, advanced analytics, and business analysis.
Analyzed complex data sets using SQL and Python, applying statistical techniques to uncover trends and inform business decisions effectively.
Developed predictive models using Python, which significantly improved decision-making processes by identifying key business predictors.
Employed advanced visualization tools such as Tableau and Power BI to create compelling dashboards and reports that enhanced data accessibility for stakeholders.
Integrated AI functionalities with Azure Cognitive Services to streamline operations and introduce advanced analytical capabilities into business processes.
Led a team to implement and maintain a comprehensive data warehouse using technologies like SQL, Python and Power BI, which centralized data management.
Automated routine data processes using Alteryx, which increased efficiency and accuracy in data preparation and analysis tasks.
Conducted extensive data modeling and analysis using Databricks, providing deep insights into business metrics and performance.
Enhanced project documentation and reporting processes using Microsoft Excel and SharePoint, which improved project tracking and stakeholder communication.
Implemented Azure Databricks to perform robust data processing tasks, enabling more efficient handling of big data workloads.
Championed the use of Azure Cognitive Services to enhance data interpretation and extraction of actionable insights through advanced analytics.
Utilized data lineage tools to ensure data integrity and traceability throughout the analytics lifecycle, maintaining high data quality standards.
Spearheaded the adoption of AGILE methodologies in project management, which enhanced team flexibility and accelerated delivery timelines.
Facilitated stakeholder meetings and presentations using PowerPoint, effectively communicating complex data-driven insights and strategic recommendations.
Conducted in-depth value stream mapping sessions to identify inefficiencies and areas for process improvement, leading to significant cost savings.
Led workflow automation projects, which significantly reduced manual labor and streamlined business operations for increased productivity.
TECHNICAL SKILLS:
Data Analysis : SQL, Python, Excel, Snowflake, Databricks
Data Visualization : Tableau, Qlik Sense, Looker, Power BI, Alteryx
Project Management : JIRA, Confluence, Microsoft SharePoint
Cloud Platforms : Azure Blob, Azure Cognitive Services, SQL Server
PROFESSIONAL EXPERIENCE:
Client: Met Life Inc. May 2023 – Present
Role: Senior Data Analyst
Roles & Responsibilities:
Enhanced reporting capabilities using Tableau, creating dynamic dashboards that visualized claims data and business metrics.
Collaborated with Health and Safety leadership and cross-functional teams to translate their requirements into actionable insights, facilitating informed decision-making and driving project success.
Engaged in designing and developing distributed backend processes, data pipelines across Health and Safety data and other sectors in stakeholder-facing role, delivering high-performance data architectures.
Deployed Power BI and tableau dashboards and integrated models on the Safety data, enabling leadership to establish actionable targets. This initiative led to a notable 25% increase in the YOY Take charge rate.
Mentored team members in maintaining effective Power BI dashboards and enhanced data quality through effective data validation techniques making 25% more data usable.
Built data models, providing in-depth analysis across various functions in global acquisition and deployment business.
Developed complex reports using SQL for IT business data, thereby improving the forthcoming budget by 28%.
Deployed Tableau dashboards to server for cost optimization analysis, resulted in improved average WOW spend by $3.4 Million.
Forecasted Budget using Machine learning techniques, thereby reducing the operational time by 80 %.
Implemented continuous process improvement (CPI) related to acquisition of hardware globally across all business units.
Leveraged Confluence for team collaboration and project management, ensuring all stakeholders were aligned on project goals.
Environment: Tableau, Power BI, SQL, Excel, Python, PySpark, Databricks
Client: Liberty Mutual Nov 2021 to April 2023
Role: Data analyst
Roles & Responsibilities:
Developed data automation processes using Alteryx, enhancing the efficiency of data manipulation and analysis workflows.
Enhanced reporting capabilities using Tableau, creating dynamic dashboards that visualized claims data and business metrics.
Implemented data visualizations with Excel, providing detailed analytical reports to support strategic decision-making.
Used SharePoint to centralize document management and collaboration, improving project communication and documentation.
Leveraged Confluence for team collaboration and project management, ensuring all stakeholders were aligned on project goals.
Developed machine learning models with Apache Spark ALS, optimizing recommendation systems for personalized insurance offerings.
Utilized ML algorithms in advanced analytics projects, significantly improving claim processing accuracy and efficiency.
Created interactive dashboards using Tableau, which allowed for real-time monitoring of insurance metrics and trends.
Conducted data analysis using SQL, extracting and interpreting large datasets to inform business strategies and operations.
Implemented predictive analytics models using R language, enhancing forecasting accuracy for financial planning and risk management.
Developed and maintained automated workflows using Apache Spark, processing large volumes of data efficiently.
Applied advanced analytics to assess insurance claims and policy data, using Python to automate data extraction and processing.
Employed Alteryx to streamline data preparation and blending, significantly reducing the time required for data readiness.
Used LightCast, labor source that provides real time insights.
Utilized Azure Cognitive Services to implement natural language processing in customer feedback analysis, enhancing customer service.
For workforce planning and talent strategies used LightCast.
Conducted statistical analysis with MATLAB, supporting the development of insurance pricing models and risk assessment tools.
Environment: Alteryx, Tableau, Excel, SharePoint, Confluence, Apache Spark ALS,, ML algorithms, SQL, Apache Spark, Python, MATLAB, LightCast .
Wipro Limited, Bengaluru, India May 2018 – Sept 2021
Client: GE (General Electric)
Role: Data Analyst
Roles & Responsibilities:
Created SQL Server (T-SQL) stored procedures, Python automation scripts and Power BI reports for project planning and regulatory reporting for data analysis on GE finance data.
Implemented process changes in the Data flow process using SQL querying techniques, reduced the overall run time by 40%.
Designed Live Analysis dashboards to track real time Finance data and predict customer behavior metrics and trends, revised and narrowed data operations by 80%.
Created Data Quality scorecard dashboards in Tableau for tracking Client Entity Data Quality.
Supported a team of Data Analysts managing historical times series data for various exchange-traded assets by performing data sourcing, cleaning, loading, and processing from sources like Oracle and SAP.
Created a Python package around public APIs (Companies House), managing ETL and data validation for US based entities data sources. Process supplied corrections for internal client data to improve data quality to 100% accuracy.
Worked in GE Lighting & GE Power Projects, Performed SAP Data Migration and Analytics on customer Transactional data using Informatica ETL tool.
Implemented process changes in the Data flow process using SQL querying techniques, reduced the overall run time by 40%.
Designed Live Analysis dashboards to track real time Finance data and predict customer behavior metrics and trends, revised and narrowed data operations by 80%.
Created an email workflow update Application in the Informatica tool enabling users effectively manage load in the production cycles.
Leveraged AGILE methodologies in project management, enhancing team responsiveness and project adaptability.
Analyzed business requirements and technical specifications using SQL, ensuring that software solutions aligned with business goals.
Managed project documentation and collaboration using Confluence, ensuring that all stakeholders had access to the latest project updates.
Environment: SQL, Python, Microsoft Excel, Oracle, SAP FICO, Tableau, Power BI.
Education:
Master of Business Administration (MBA) from ICFAI University, Bangalore, India (2016-2018)