I worked for 2+ years with Genpact and Cognizant Technology Solutions as an analyst in India. I have recently graduated from University of Texas at Dallas with a GPA of 3.92 In MS, Information Technology and Management. I have experience in data analytics, building dashboards and models on Tableau and Power BI. I also have experience with SQL, Python to manipulate data and create models. I can seemingly work with cross functional teams and am a strong team player.
-
Experience
I have over 2 years of prior corporate experience with Genpact (1+ year) and Cognizant Technology Solutions (1+ year) as an analyst in India. My role and responsibility included performing diagnostic, descriptive, predictive and market/customer trend analysis on sales and financial data using Python; creating weekly KPIs and SLAs for senior management, generating SQL queries for data management, developing visualization dashboards using Tableau and Power BI and effectively communicating key business insights and recommendations to the senior management.
In 2018, I joined University of Texas and have completed my Master’s in Information Technology and Management with a GPA of 3.92. This program introduced me with technical as well as management courses like Business Analytics with SAS, Agile Project Management, Machine Learning with Python, Database Management and Statistics & Data Analysis. As part of my course, I have worked on multiple projects like Implementing predictive models (Regression & Classification) using various Python libraries; ETL and OLAP Analysis, designing HANA Dimension, Cube & Calculation View Modeling and dashboards using HANA Design Studio.
-
Projects
Sales Data Analysis
• Created SQL queries to extract consumer and sales data for a key client operating in 4 geographies with more than 150 product offerings
• Created consumer and market trend analysis using MS excel and Tableau to examine geographical, temporal and behavioral patterns on revenue and volumes
• Identified key issues around customer churn rate, purchasing behavior, seasonal impact on product margins in various geographies
• Created linear regression models to identify YoY sales growth by customer, geography and product using Python and implemented classification models using Python to identify customer purchasing behavior
• Created final recommendation and visualizations using Tableau to improve YoY Revenue growth by 10%
Financial Data Analysis
• Performed diagnostic and descriptive analysis for a client on its reconciliation accounts to identify issues with open AR items
• Created queries in SQL using joins, sub-queries for more than 150 business units within the organization, filtered by customers
• Expertise in writing complex DAX functions in Power BI to compare data from different databases to verify payments in corporate accounts to bank accounts
• Identified key issues and made recommendation to the client to close opened accounts receivable items
• Leveraged SQL database and Power BI to create effective visualizations/dashboards for the various reconciliation accounts data, communicating key business insights and recommendations to the senior management.
ACADEMIC PROJECTS
Data Management
• Designed an ER diagram of a mileage tracking database for a bus company.
• Used SQL queries to create a database to store total miles driven by a bus for efficient tire management system.
Applied Machine Learning using Python
• Implemented predictive models on Airbnb Dataset to forecast Airbnb prices (Regression) and on Loan Dataset to forecast loan status (Classification) using python libraries like pandas, NumPy, Scikit-learn, Keras, TensorFlow, Matplotlib.
Business Data Warehousing
• Conducted ETL and OLAP Analysis on the sales data of 20,000 records to produce multidimensional reporting environment.
• Designed HANA Dimension, Cube and Calculation View Modeling and dashboard using HANA Design Studio