Data Social Media

RITIKSHA GADA

****.*@*****.***.*** 857-***-**** www.linkedin.com/in/ritikshagada

SUMMARY:

Self-motivated Business Data Analyst with 3 years of experience and an extensive knowledge in Data Gathering, Cleaning, Analyzing and Reporting using Tableau, QlikSense and Excel. In-depth understanding of all phases of SDLC, Waterfall and Agile methodologies. EDUCATION:

Northeastern University Boston, MA

Masters of Science in Information Systems Dec 2017 V.E.S Institute of Technology Mumbai, India

Bachelor of Engineering in Information Technology Jun 2013 PROFESSIONAL EXPERIENCE:

MFS Investment Management Boston, MA

Sales System Development (Business Analyst) Co-op Jul 2016 – Dec 2016

• Managed ad hoc data request work-flow and KPIs of business performance data and automated them for intuitive reporting using ACS Green, JWalk and Tableau, impacting the business by +2.5%.

• Facilitated senior members and managers in quality control of all reports, applications and tests to drive key business decisions that improved productivity by 9%.

• Lowered processing delays by 15% for MFD Sales; Applied reverse engineering to existing database structures, which reduced redundancies and consolidated databases using Toad Data Modeler resulting an improved ROI by 8.5%.

• Translated and analyzed business requirements into detailed, production-level technical specifications, detailed new features and enhancements to existing business functionality using Changepoint, Remedy Ticketing System saving up to 13 hours/week.

• Monitored data loads between vendors, data marts and CRM application; Maintained documentation on SharePoint.

• Performed predictive analysis of structured, semi-structured data using R; Used digital marketing analytics and regression techniques to understand behavioral trends and personas using R.

• Streamlined 70% of reporting using BI reporting tools to reduce man-hours up to 173 hours annually.

• Designed dashboards using Tableau projecting the data extracted by SQL from cluster tables enhancing operations capability by 17%. Accenture Mumbai, India

Software Engineer Analyst (Role: Business Intelligence Analyst) Nov 2013 – Aug 2015

• Developed and implemented different ETL processes and mappings using transformations in Informatica PowerCenter

• Tuned the performance of 15 long running ETL jobs by tuning the SQL used in Transformations and tuning the database

• Designed interactive dashboards and reports using Tableau to deliver KPIs, summary and detailed information

• Proactively troubleshooted and resolved data issues in OBIEE, Tableau and PS reports to reduce the business impact

• Identified bottlenecks in the process and resolved them on time to avoid SLA breach with a resolution efficiency of 100% TECHNICAL SKILLS:

Languages: PL/SQL, Java, SAS, Python, R

Databases: MySQL, Microsoft SQL Server, PostgreSQL, Oracle Data Integration: Informatica PowerCenter, Talend, Toad Data Modeler, SSIS, SSAS (OLAP Cubes), SSRS Business Intelligence: Tableau, Excel, QlikSense, Microsoft PowerBI, OBIEE, SAP Big Data: Hadoop, HDFS, Mahout, MongoDB, Hive, Pig, HBase, Spark, NoSQL, Redshift Modelling: Machine Learning, Neural Network, Classification, Clustering, MapReduce, AWS Python: NLTK, NumPy, Pandas, SciPy, Scikit Learn, Keras, TenserFlow ACADEMIC PROJECTS:

School Data Warehouse (Talend, SSIS, Power BI, SQL Server, MySQL) Sep 2016

• Used Talend and SSIS to integrate data from various sources like Flat Files, Oracle, SQL Server, PostgreSQL and MySQL

• Optimized queries and used various BI Tools like Tableau, QlikSense, PowerPivot and PowerBI to generate reports Predictive Analysis (Linear Regression, Decision Tree, SVM, XGBoost, R) Apr 2017

• Developed a predictive analysis model to identify the risk and eligibility of applicants to buy Life Insurance using R

• Build predictive models using Regression, SVM, Decision Tree, XGBoost and evaluated the performance of models Social Media Sentimental Analysis (Text Mining, R) Oct 2017

• Web Scraping of social media using rvest library, extracted and tokenized to create a corpus and performed text mining

• Created visualizations like Word Cloud, Radial Trees, dendrograms to represent the most relevant words MapReduce Analysis on Yelp Dataset (Hadoop, AWS EMR, Hive, Pig, HBase, Mahout, Tableau) Dec 2017

• Implemented MapReduce algorithms to perform analysis on Yelp dataset; Used HBase to store the unstructured data

• Scrutinized the dataset using Amazon’s EMR, Hive, Pig to run complex queries and Visualized results using Tableau

Contact this candidate