Data Analyst
Resume:
TEJA RAMANA MODUKURU
Data Analyst
******.***********@*****.***
PROFESSIONAL SUMMARY
Over 7 years of experience with solid understanding of Data Sources and strong understanding of Data Visualizations, Client/Server applications.
Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server.
Skilled in data integration, governance, and optimization using SQL, Python, Power BI, and Excel.
Worked on designing dashboard/reports to give them consistent and professional looks using Power BI.
Experience with various Python libraries such as NumPy, SciPy for mathematical calculations, Pandas for data preprocessing/wrangling, Matplotlib, Seaborn for data visualization.
Experience in using Excel and MS Access to dump the data and analyze based on business needs.
Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, for Analytical Projects and Data Visualization Community.
Experienced in converting Legacy Reports to Tableau dashboards connecting to SQL server.
Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
Used different self-service exploratory data analytics tools such as Tableau, QlikView and MS Power BI for data preparation and visual analytics.
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.
Good knowledge in Data Science Statistical Modelling with Python and R.
Expertise in SQL in creating and using Views, User Defined Functions, Triggers, Indexes, involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints.
Performed Data Analysis and Data Validation by writing complex SQL queries.
Proficient in design and development of various dashboards, reports on Power BI Visualizations.
Expertise in DAX which helps in understanding and analyzing the data.
Proficient in data reconciliation, reporting, and migrating frameworks to improve efficiency.
Strong collaborator, adept at translating business needs into data-driven solutions and automating processes through RPA to streamline workflows.
Performed Data Visualization and Exploratory Data Analysis (EDA) to find correlation and patterns within the data using Python and Power BI. Built reports summering the patterns from EDA.
Experience working with cross functional teams by supporting programs, projects, portfolio applications & tools, business processes to drive business unit vison towards digital roadmap.
Extremely passionate about data analytics and data visualization with rich experience in turning large data sets into valuable and actionable business insights using Power BI, Tableau, R and Python.
EDUCATION
MA in Data Analytics
BS in Computer Science & Engineering
TECHNICAL SKILLS
Programming Languages and Softwares
SQL, Microsoft Office, R, Python, VBA, Oracle
Databases
MySQL, MS SQL Server, SQLite
Packages
NumPy, Pandas, Scikit-learn, Matplotlib, Seaborn, Plotly
BI Tools
Power BI, Tableau
Relevant Coursework
Data Management for Analytics, Computation & Visualization, Data Mining, Statistical Methods
PROFESSIONAL EXPERIENCE
Wayfair, Boston, MA Jun 2024 - Present
Data Analyst
Responsibilities:
Supported management team with reports generation and analysis using reporting and visualization on Power BI.
Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Power BI.
Generated, wrote and run SQL script to implement the DB changes including table update, addition or update of indexes, creation of views.
Designing and developing Tableau reports for product and sales managers as well as recommending and implementing new reporting tools and methods.
Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPI, Filter and Aggregations.
Created and developed Power BI visualizations for the Key Performance Indicator (KPIs) and trend analysis.
Designed and developed enterprise-level Power BI dashboards and reports, enabling executive leadership to make faster and more informed business decisions.
Assisted in support of Tableau server testing and deployment for external client support on successful Tableau server installation.
Streamlined ETL processes and optimized SQL queries across multiple databases, reducing data processing time by 30% and improving data reliability.
Partnered with cross-functional teams (Supply Chain, Finance, Operations) to translate business requirements into actionable data models and analytics solutions.
Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
Developed inventory tracking dashboards in Power BI, providing real-time insights into stock availability, backorders, and inventory turnover rates, improving operational efficiency.
Environment: Power BI, SQL, ETL, Data Modeling, Tableau, DAX, KPI, Power Query, SQL Server, Views, Triggers, Data Warehousing, Data Cleansing, Data Mining
Putnam Investments, Boston, MA Jul 2023 - May 2024
Data Analyst
Responsibilities:
Performed ETL processes to data ready for creating business analysis visuals which help the leadership team to make the right business decisions.
Created and shared the dashboards within the organization for updating and editing the report as per the business requirement.
Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data mode.
Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
Implemented role-based security and row level security on data in Power BI.
Created Power BI dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.
Set up automated systems used Excel VBA to pull the data smoothly into Tableau platform to create reports and dashboards.
Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
Performed data Extraction, Transformation and Loading (ETL) between systems using SQL tools such as SSIS.
Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to dump the data in to SQL Database.
Created real-time dashboards in Tableau to visualize and monitor key metrics and A/B test processing using both external and internal data.
Designed and developed a full-scale reporting solution for a multi-client environment using MS SQL Server R2 and Report Builder.
Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services.
Involved in understanding their requirements and translating functional requirements to technical specifications.
Environment: Power BI, MS SQL Server R2, SSIS, Report Builder, SQL Server, Excel, Tableau, Flat Files, Windows
Wise Systems, Boston, MA Sep 2022 – Jun 2023
Data Analyst
Responsibilities:
Providing data analysis that focused on improving user experience and optimizing user retention.
Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions and common table expressions to track user activity metrics such as retention rate and daily active user. Optimized existing queries to run faster on large dataset.
Designed metrics for A/B testing, creating dashboards in Tableau to monitor test processes, analyzing test results, interpret and give recommendations to stakeholders.
Worked on import data to Power BI for creating reports.
Developed Python scripts to automate data validation and data cleaning processes such as de-duplicating and checking data consistency using Pandas.
Defined metrics to estimate impact of new features and give recommendations for business decisions based on data analysis.
Implemented Power BI Power Query to extract data from external sources and modify the data to generate the reports.
Participated in data project planning, gathering business requirements and translating them into technology requirements.
Performed Exploratory Data Analysis (EDA) to visualize through various plots and graphs using Matplotlib, NumPy, Pandas, and Seaborn Libraries of Python.
Queried data from MySQL database and validated and detected inconsistent data using Python packages Pandas and NumPy.
Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
Environment: Python, Pandas, NumPy, MySQL, NoSQL, Power BI, Tableau, A/B Testing, Data Modeling, Window Functions
PricewaterhouseCoopers, Bengaluru, India Sep 2021 – Aug 2022
Data Analyst
Responsibilities:
Managed end-to-end implementation of Oracle Fusion Inventory and Order Management modules.
Optimized inventory processes by automating tracking and restocking workflows.
Designed and executed order management workflows aligned with business objectives.
Involved in designing A/B tests, defining metrics to validate new user interface features, calculating sample size and checking statistical assumptions for tests.
Performed statistical analysis such as hypothesis testing, regression analysis, confidence interval and P-value calculation using R to find insights to increase click through rate and sales and built web applications for ad-hoc interactive dashboard.
Performed Exploratory Data Analysis to identify trends using Tableau and Python (Matplotlib, Seaborn and Plotly Dash).
Communicated key findings from data to multiple stakeholders to facilitate data-driven decisions using tools MS PowerPoint Tableau and Jupyter Notebook.
Developed interactive dashboards and storyboards in Tableau to explore credit portfolios data and report insight to the manager.
Performed exploratory data analysis and identified data patterns that can translate into business rules.
Deployed MS SQL Server platform to store transform and query data for data analyzing and reporting.
Collected data from various sources using Python and loaded data into Pandas Dataframe to detect outliers and imputing missing values.
Created calculated columns and measure in Power BI and Excel depending on the requirement using DAX expressions.
Environment: Oracle Fusion, Tableau, Python (Pandas, Matplotlib, Seaborn, Plotly Dash), R, MS SQL Server, Jupyter Notebook, MS PowerPoint, MS Excel, Power BI
WayCool Bengaluru, India Jul 2019 - Aug 2021
Data Analyst
Responsibilities:
Optimized inventory management using SQL and Python, analyzing stock levels across 1000+ SKUs, reducing excess inventory, and cutting costs by $500K annually.
Developed Power BI, Tableau dashboards to automate supply chain performance tracking, eliminating manual reporting and improving decision-making speed by 40%.
Conducted inventory analysis using historical data, implementing SKU-specific safety stock levels and reorder points, leading to a 100% reduction in stockouts.
Automated demand forecasting models using SQL and Excel, improving forecast accuracy by 20% and optimizing procurement planning, reducing excess purchasing costs by $250K.
Integrated OMS for seamless order tracking and management, increasing processing efficiency by 25% and reducing fulfillment errors.
Analyzed transportation logistics data to optimize shipping routes and carrier selection, reducing transportation costs by 12% ($300K savings) and improving on-time deliveries.
Spearheaded efforts to secure $150 million in funding by leveraging data storytelling and analytics to present supply chain optimization strategies to investors and cross-functional stakeholders.
Provided real-time operational insights to stakeholders, enabling data-driven decision-making and improving supply chain efficiency across multiple business units.
Expertise in Data Cleansing using Power Query in Power BI Desktop Editor.
Involved in writing Queries in SQL server. Trained end users effectively to use reporting tool, to build and customize their Ad-hoc reports.
Performance tuning of sources, targets, mappings and SQL queries in the transformations.
Developed unit test cases for the code developed using complex SQL queries.
Displayed and explained results using Excel and Power point presentations.
Environment: SQL Server, Python, Power BI, Tableau, Excel, PowerPoint, Power Query, OMS, ETL Tools
Aspora, Bengaluru, India Mar 2018 – Jun 2019
Data Analyst
Responsibilities:
Worked on monitoring statistics of email delivery and optimize email efficiency to increase customer engagement.
Analyzed result of A/B tests to find better time of email delivery for different topics using R.
Set up automated systems used Excel VBA to pull the data smoothly into Tableau platform to create reports and dashboards.
Created Dashboard Reports using Power BI and Cognos.
Collected data from internal sources using MySQL and performed data cleaning and aggregation for reporting and further analysis.
Manipulated date and calculated key metric for reporting using MySQL queries (window function, subqueries) and MS Excel.
Visualized data from MySQL and MS Excel using Tableau Dashboard to monitor email performance. Connected to MySQL database using R package RMySQL and retrieving data for statistical analysis and visualization.
Performed Exploratory Data Analysis (EDA) to find insight such as difference efficiency among different devices using ggplot2 in R.
Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.
Developed many Tabular Reports, Matrix Reports, drill down Reports, Bar Graph Reports using Power BI.
Worked on both live and import data to Power BI for creating reports.
Environment: R, MySQL, Excel VBA, Tableau, Power BI, Cognos, ggplot2, RMySQL, MS Excel
Contact this candidate