Data Analyst

Sri Divya Krishna Ganja

Alpharetta, GA

***************.*****@*****.*** • +1-813-***-**** • https://www.linkedin.com/in/sridivyakrishna/

Analytics Professional SAS Certified in Analytics and Business Intelligence

PROFESSIONAL SUMMARY:

Data Analytics professional with 6 years of experience in Telecom and Financial domains delivering data driven solutions.

Expertise in working on different on-prem databases like Oracle, Teradata, SQL server and cloud databases like Snowflake and Redshift.

Exposure to Data Warehouses based on star, snowflake schemas, ETL, Data marts, OLAP, OLTP databases and designing multi-dimensional data structures.

Experience in working with statistical and Data Analytics tools which include R-studio, Python and SAS Enterprise guide, Tableau.

Proficient in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

Expertise in telling stories with data by creating building dashboards in Tableau.

Hands on experience in creating visualizations and interactive dashboards in Tableau by using features such as calculated fields, dual axis etc., and distributed the reports to the user groups and managing the ownership of the tableau reports.

Experience in developing reports using NumPy and pandas packages in python along with validating, identifying and fixing the bugs in the reports.

Expertise in creating Visualizations in python using Seaborn and Matplotlib packages in python.

Experience on working with tools such as Jupyter notebook and databricks for python development.

Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

Sound Knowledge on Data Warehousing, OLAP, Star schema modelling, Snowflake schema modelling, Fact and Dimension Tables.

Excellent interpersonal and communication skills with ability to communicate effectively with the technical as well as business teams.

EDUCATION:

Master of Science in Business Analytics and Information Systems, University of South Florida, Tampa, GPA-3.7/4 December 2017

Leadership – Organized Events for American Association of University Women

Bachelor of Technology in Electrical and Electronics Engineering, JNTU, India, Percentage-72.9/100 June 2013

PROFESSIONAL EXPERIENCE:

Idexcel Inc, Client – Capital One, Richmond, VA

Data Analyst II October 2018 – Present

Performance Measurement and Visualization: Developed Visualizations and dashboards in Tableau to measure the performance of the Anti-Money Laundering investigators and derived meaningful insights which were helpful for the teams in minimizing the budget by ~2million USD by planning and utilizing the resources efficiently.

Report Creation and Monitoring: Creating Monitoring reports in Data bricks using Python and Pyspark to monitor various processes and sending email reports to the Teams at the scheduled times which has reduced the manual efforts of the teams by 40%.

Cloud Migration: Migrated the reports which were present in the SAS and Teradata environment which were running in the on-premise servers to python and snowflake environment to run on the cloud servers thus helped the client in optimizing the cost of data centers and infrastructure by 1.5 million USD.

Automated email reports: Created scripts in python to save the logs in one lake and S3 platforms and send the logs to the owner when the report fails, so that the time taken to debug and identify the issue was reduced by 80%.

SQL Scripting: Writing SQL scripts using window functions, based on the inputs from business users to capture the demand velocity and number of alerts or cases in the inventory in various queues.

Ad-hoc reporting: Worked on writing ad-hoc SQL queries to extract data from various databases like oracle, Teradata, snowflake based on the requests and requirements of the Business users.

Intelliswift Software Inc, Client - PayPal Credit., Lutherville, MD

Data Reporting Analyst April 2018 – October2018

ETL Process and Development: Extracted the data from Teradata database by writing SQL queries and developed validations based on the underwriting policies using macros, data and proc steps in SAS for the credit applications.

Exceptions Reporting and Automation: Developed the reports to check the policy exceptions and the list of applications with exceptions in SAS Enterprise Guide and sent them in email to the concerned teams by scheduling cron jobs in Unix.

Behavioral Analysis and Visualization: Analyzed the performance of the consumer credit account holders, co brand account holders and the working capital account holders by visualizing the data along with forecasting the defaulters and delinquent accounts and took part in designing the campaign strategies based on the customer segments.

Data Modelling: Designed a Data model using Teradata SQL and SAS by discovering different relationships a PayPal customer holds with PayPal credit products such as Consumer Credit, Working Capital and Co-Brand accounts.

Data Analysis: Analyzed relative financial performance of overlapping customers across different portfolios to assist the business unit to better assess customer behavior.

KPI Dashboard Development: Developed dashboards using Tableau for product and merchant team to assess top growing, declining merchants and financial KPI’s.

University of South Florida, Tampa, FL

Data Analyst Office of Graduate Studies January 2017 - December 2017

BI Reporting: Prepared Weekly and Monthly reports on Student enrollment, their persistence and their academic performance matrix using SAS, SQL (oracle database) and created customized interactive dashboards using Power BI.

Data Manipulation: Extracted large datasets and performed data manipulation, cleansing, transformation and reporting various procedures in SAS to analyze the course popularity and obtain the course combinations that are most frequently enrolled by students.

Predictive Modeling: Built ML models using regression in SAS Base to predict GPA of the students to identify the potential students who may end up with low GPA and helped the faculty and administration to focus on those students and increased the performance 72%.

TATA Consultancy Services, India

Systems Engineer/Data Analyst February 2014 - October 2016

Customer Segmentation: Accomplished customer segmentation using k-means algorithm in R-Studio, based on the behavioral and demographic tendencies to improve the campaigning strategies and reduce the marketing expenses by 10%.

CLTV Prediction: Built machine learning model to predict customer lifetime value using historical telecom data using SAS to better serve high priority customers through loyalty bonus, personalized services and strategize customer retention plans.

Churn Analysis: Analyzed the data related to 4.5 Million subscribers to identify factors impacting customer churn rate to recommend marketing strategies and helped the client in increasing the retention rate by 15%.

KPI Reporting and Visualization: Developed advance interactive dashboards using Tableau using the data in CRM application to track the Key performance indicators, draw insights and recommendations to drive business decisions.

Performance Tuning and Ad-hoc Reporting: Implemented Performance tuning on SQL queries and decreased the query execution time by 60%. Created and ran ad-hoc queries to answer the business queries and provided root cause analysis.

SKILLS:

Software/Tools: SQL, Python, SAS Base, SAS Advance (proc sql and macros), SAS EG 7.1, R, SAS 9.4, Snowflake, Databricks, AWS S3, SSIS, SSRS, Redshift, SQL Server, MySQL, SAS E Miner, IBM, Postgres, Jupyter, UNIX, C, C++, MS Excel, JIRA.

Visualization Tools: Tableau, Qlik View, Python-Matplotlib, Seaborn, Power BI.

Techniques: Quantitative analysis, Hypothesis testing, Visualization, Time Series Forecasting, Machine Learning, ANOVA, PCA, Regression, Decision trees, Random Forest, CART, KNN, SVM, Boosting, Bagging, Clustering, Segmentation, A/B Testing, Google Analytics, Agile, SDLC.

CERTIFICATIONS:

SAS Certified in Analytics and Business Intelligence

SAS Certified Base Programmer for SAS 9 Credential

Contact this candidate