Data Analyst

Rutuja Chavan

201-***-**** NJ ***** ******.*********@*****.*** https://www.linkedin.com/in/rutuja-chavan-22354124 EDUCATION

PACE University, New York, USA (GPA 3.85) May 2018 Studying in Computer Science & Information System

University of Pune, Maharashtra, India Aug 2009

Bachelor of Engineering, Computer Science

TECHNICAL QUALIFICATIONS:

• ETL Tools: Power center Informatica, SAP BW, Pentaho Data Integration

• Reporting Tools: BEX Query Designer, OBIEE, WEBI, Crystal Report, BO, Pentaho BI, Tableau

• Programming Languages: PHP, Python, SQL, ASP.NET, XML, HTML, Spark, R

• Database: SQL Server, MySQL, Hive, Oracle, DB2

• Version Control System: Git

• Cloud Computing: Google Cloud (Big query), AWS (Redshift, RDS, S3), MS Azure WORK EXPERIENCE

NYC Department of Sanitation New York, USA

Programmer Analyst intern Oct 2017- Current

Designed and implementing new databases in MSSQL/Oracle/MySql/DB2 and a broad understating of relational and multidimensional data

Created stored procedures, database, Views, Indexes, Triggers, XML and ETL processes

Developed and managed python/Unix scripts for data integrations with Pentaho (PDI), Created mappings, workflows and debugging in Informatica environment

Collaborated on development of new in house data-driven application using ASP.Net (MVC 5) & Entity- Framework, develop web API using C#, unit testing

Used SQL and perform complex data profiling functions of multiple, large datasets for analysis, testing and other efforts. Created multiple/multi-type table joins, multiple keys, nested queries and other complex SQL function for advanced data analysis. Worked on query tuning.

Developed and update reports using OBI, Power BI, Informatica, Pentaho Kettle ETL development

Used advanced features of T-SQL in order to design and tune to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL

Performed advanced excel functions such as pivot tables, Vlookup, macros, visual basic and more to supplement advanced SQL skills in data analysis exercises

Wrote SQL/Hive/Spark queries to extract necessary data and present the information either in Tableau or PowerPoint and analyze the results to generate business insights, Utilized Pandas, Numpy for data manipulation in python

Accenture Pune, India

Senior Analyst July 2015- Jan 2016

Performed enterprise data mart development and familiar with multiple schematics including star schema, snowflake schema, and 3rd NF

Convert the business requirements to technical code using SQL

Experienced in building relationships and collaborating within a cross-functional team

Involved with the development and architecture of an enterprise data warehouse

Experience writing advanced SQL queries, analyzing and optimizing queries, stored procedures

Understand and analyzed the data to find patterns and valuable Business Data Insights

Worked on business intelligence solution development Business Intelligence tools (Cognos BI, Tableau), developed dashboards and reports

Worked on processes of data cleansing and data transformation, data quality and data modeling

Worked comfortably in manipulating and analyzing complex, high-volume, high-dimensionality data from varying sources

Enhanced Database infrastructure across 4 environments including production migrations

Work on various Business and Technical documents (Business Map, Business Change, Unit Test case, High level etc) using Agile methodology for project development, also worked in all phases of the Software Development Life Cycle

Tata Technologies Pune, India

BI/BO Data Analyst June 2014- July 2015

Worked on data warehouse life cycle right from data source to ETL to transformations to multidimensional models like data marts, star schema and Report and dashboard creation

Utilized ETL processes to extract data from different kinds of source systems into a BW system

Daily monitoring like checking Space statistics, spool logs, background job overview

Involved in changing the Existing data model of an Infocubes by adding new Characteristics and Key figures, involving the Re-initialization of Data Sources

Worked on Web Intelligence, Crystal Report and data visualization using Tableau

Has worked extensively on the BEx Web-Reporting Tool and Excelsius Repots, Infoview, BEX Reports WIL Pune, India

SAP BI Developer Aug 2010 - June 2014

Involved in various activities of the implementation like understanding the current system, data gathering, analyzing the information gathered, involved in designing and developing the solutions

Extensively worked in Business Information Warehouse Info cubes, ODS Objects, Info Sources, Info objects, data sources

Knowledge on performance tuning activities like Aggregate, Compression, Partitioning, Cache, clustering

Experienced in end-to-end implementation of Business Intelligence (BI) projects, worked on KPIs, reports

& dashboards. Created new custom data sources, enhance existing data sources and Install new data sources

Responsible for transportation of the ETL (Extraction, Transformation, Loading) flow to the production server ACADEMIC PROJECTS:

Data Analysis with statistical programming R Fall 2017

Extracted tweets and followers from the Twitter website with R and the twitteR package

With the tm package, cleaned text by removing punctuations, numbers, hyperlinks and stop words, followed by stemming and stem completion, analyzed topics with the topic models package, analyzed following/followed and retweeting relationships with the igraph package

Explored and predicted CO2 emission of vehicles data using multiple regression, analyzed dataset with various reports (Scatterplot, histogram, bar charts, box plot, time series) Aviation data analysis and visualization (Big data Hadoop, Apache Hive, pig & Tableau) Spring 2017

Performed predictive analysis on U.S. Department of Transportation open data source to find out which month have seen the most number of cancellation due to bad weather

Analyzed top 10 route (origin and destination) that has seen maximum diversions, analyzed top 5 visited destination

Connection of Hive with tableau to visualize data, graphic representation and generate reports

Explored various tools Pandas, SciPy, Scikit, Jupyter notebooks for data analysis Self-Learning Projects and Tools (Python, Hadoop, Machine Learning, Cognos BI) Spring 2017

Created a game named Guess the Word, Guess Number in Python

Worked on Map Reduce.

Predicted House Price using linear regression algorithm for Machine Learning

Completed online courses of IBM Cognos and AWS S3, RDS, DynamoDB, Redshift data warehouse

Contact this candidate