Pravallika Chimmiri

**** ***** *********** ***, *** 104,

Arlington Heights, IL - 60004.

Contact: (470) - (494) - 2883 Email: adi7kd@r.postjobfree.com

5+ years of hands on experience in various tools and technologies like Tableau, Power BI, Data Mining, Business Intelligence, Predictive Modelling, Statistical Data Analysis & Machine Learning. Worked closely with MySQL server and Oracle servers, Snowflake databases to build reports using Tableau and PowerBI.

FIELDS AND DOMAINS

Banking, Healthcare, Biomedical, Industrial Manufacturing & Automotive [Supply Chain], Insurance and Financial Services.

PROFESSIONAL SUMMARY

Currently working as the Business Intelligence Team lead for the U.S Citizens Bank and leading a team of 12 Business Intelligence Engineers both onsite and offshore to deliver the reports to “Credit Risk Enhancement Project”.

Helping Citizens bank automate the reports using a BI tool - WebFOCUS by remodelling the structure from IBM COGNOS Frame Work Manager Unified Model to Shared drives by using the data from Amazon Redshift Databases.[ Both On Prem and AWS Cloud ]

Worked as a Data Scientist by building machine learning Models in AWS Sage Maker and building ARIMA and SARIMA models in R Studio that helped Vanguard analyze the cash flow output during the crisis time of COVID.

Worked as a Data Analyst/Tableau Developer/Power BI Developer for multiple Caterpillar projects by building reports using Tableau, Power BI, QlikView, Informatica and Advanced Excel.

Queried Advanced SQL codes in MySQL, Oracle and Snowflake databases.

Built and deployed Machine Learning Models, Deep Learning models using AWS Sagemaker.

Maintaining requirements, project, and application documentation as well as providing solution proposals. Design and Development of Business Intelligence Strategy

Responsible for leading the strategy and development of technology and reporting solutions needed in order to provide an effective and efficient data and analytics solution that can support and transform the business.

PROFESSIONAL EXPERIENCE

U.S Citizens Bank (Vertiv), Johnston, Rhode Island. September 2020 – Present

Business Intelligence Team Lead

Credit Risk Report Enhancement Project :

Managing and leading a team of qualified individuals to help enhance the quality of the reporting process at Citizens Bank @Rhode Island.

Built the Reporting Structure and templates for the team of Business Intelligence Engineers actively working in enhancing the visualization of the reports related to the Credit Cards of U.S Citizens Bank.

Supporting a team of 12 Reporters understand the user requirements, perform analysis and build reports.

Acting as a bridge between the data engineers and the stake holders to ensure the objective of enhancing the efficiency of the reports using latest technologies like WebFOCUS.

Aiding in organizing the data from data lakes and helping structure the data in Amazon Redshift.

Vigorously building reports using Tableau, PowerBI and WebFOCUS.

Writing SQL Queries and resolving queries and extending the support to the team offshore and improving the coordination to develop the strategies of how Banking industry perceives the latest technologies.

Understanding the Banking Environment and help them automate the daily reports and provide improved accessibility to enhance the reports.

Vanguard (Judge Group), Malvern, Pennsylvania Feb 2020 – Sept 2020

Data Scientist

Recession Analysis :

Helped standardize the data by performing data transformation and other data cleaning operations before generating the sample data form the population.

Supported the team that was invested in analysis of the behavioural changes of the investors during the current recession period by analysing the amount of funds withdrawn due to the panic of the COVID Situation.

Helped the company understand the impact of the COVID and the amount of funds withdrawn due to the current circumstances and to predict the amount of funds that might be withdrawn in the near future.

Build a Linear Regression model to understand the weight of the factors invested and to help check the data quality.

Compared the analysis to the great recessions of 2001 and 2009 to make sure the model is not overfit or underfit.

Pre-processed the previous data using nltk, numpy & pandas package.

Performed text mining and text parsing using python and R studio.

Advice and Full Service Report Library, FSE Client Pricing Tool Applications:

Built the prediction reports using Tableau to understand the adaptability of the clients to the digitalization of the investment technical tool built by Vanguard.

Helped understand the challenges in the pipeline, built strategies to enhance the adaptability and classified the clients into multiple pipeline phases.

Built a web based DASH application in order to automate and embed the reports.

Supported the Tableau reports and maintained them all through out the project.

Structed the digitalization adaptability of the full service an IO clients by building the reports and pipelines.

Built Sankey Diagrams, Waffle charts, scatterplots, violin plot, population pyramid and flow map in Tableau reports.

Worked as a part of the Institutional Analytics Team in order help them build the reports required for visualization and other analysis.

Worked on SAP and ERP in multiple projects.

Caterpillar Headquarters (Belcan), Peoria, Illinois. October 2019 – Jan 2020

Data Analyst

Building Power BI Reports, Tableau Reports for the Products Support and the Logistics Division.

Analysed the service parts data, demand, supply and business plans for the past few years that helped to identify the unique trends of revenue and patterns

Aided in migration of the database tables and views to Snowflake

Worked intensively with Snap Logic in building a process flow to update the databases automatically

Excellent communication, interpersonal, analytical skills and strong ability to manage and motivate the team.

Caterpillar (CGN Global), Multiple Locations across USA January 2017 - October 2019

Tableau/Power BI Developer

Worked across multiple locations in multiple projects for 3 years in the field of data science.

Helped support the foundries and designed new tools based on the requirements of the customer in order to understand the supply chain demand forecast in multiple perspectives.

Built Trees, K means clustering and logistic regression, Random forest, k-NN, k-Means, boosted trees, SVM, Neural Network models to help enhance the productivity of the respective scenarios.

Worked on the AWS platform to prepare transformation clusters in order to make sure the data is being handled efficiently.

Used SSIS to build the pipelines to handle the data and enhance the KPI

Deloitte, DATABASE ADMINISTRATOR, India Aug 2015 – June 2016

Analysis of key products like Ports (Internet, Private, Enhanced), Local Loop, Lines (Private, E), VoIP and SONET to complete a Knowledge Repository for Centipede(CTP)

Experience with various reporting objects like Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters, Level-of-Detail (LOD) expressions etc., in Tableau.

Performed data transformation and data standardization using Tableau, Informatica.

EDUCATION

Master of Science in Data Science, Bradley University, Peoria, IL May 2018 Graduated

Bachelor of Technology in Information Technology, India May 2016 Graduated

TECHNICAL SKILLS

Programming Languages : Python, R, UNIX, SQL, C, Pro*c

Databases : SQL Developer, Oracle 10g/11 g

Tools : Tableau (Desktop, Reader, Public, Server), WEKA, MS Office, Autosys, JIRA

IDE : Anaconda, Jupyter Notebook, R Studio, Eclipse, Visual Studio

Version Control : VCTL, Git

Web Technologies : HTML5, CSS3, JavaScript, XML, JSON, SOAP UI for testing.

SDLC Methodologies : Agile, Water Fall

Other technologies and tools : Azura, Devops, Spark ML, Pyspark, AWS, Snap logic, Snowflake, Datameer, COGNOS, DASH, SAS.

PUBLICATION RECORD – Bradley University, Peoria, IL. May 2018

Title - “An Ontological Approach and a Meta-Algorithm for Data and Machine Learning Algorithms Analysis and Classification with Application in the Medical Domain”

https://search.proquest.com/docview/205-***-****

CERTIFICATIONS

2017-02 Stanford Certified - SQL, Relational Algebra, Relational Design Theory

2018-07 Tableau Certified - [Udemy]

2018-07 Google Analytics

2019-AWS Certification (Currently Working)

AWARDS & ACTIVITIES

Dean's Award for best Graduate Research in Data Science

Caterpillar Academic Excellence Scholarship

Peoria Area Scholarship for the best Annual performance

Dr. Uskov Award for the best presentation in Data Science

Contact this candidate