Data Analyst Social Media

SHOURYA PARANJAPE

Brooklyn, NY, ***** ****************@*****.*** +1-470-***-**** www.linkedin.com/in/shouryaparanjape

PROFESSIONAL SUMMARY:

Data Analyst professional having 3 years of experience in ETL applications and analytics, working with multinational financial clients from Europe and North America. Passionate about developing efficient processes to help clients improve their businesses and effectively increase enterprise value.

CORE COMPETENCIES:

Skills: Python, R, Informatica, Power BI, Tableau, Teradata, SQL, UNIX, Spark, Kafka, Hadoop, MS Excel, Agile methodology, Salesforce, Data Visualization, Machine learning, Plotly, Pandas, Sci-kit learn.

PROFESSIONAL EXPERIENCE:

Data Analyst Libreum International Jan 2019 - Present

Portfolio optimization project: The scope of this project was to increase enterprise value by correctly predicting price points for lead buying to maximize returns from consumer loans. The parameters involved were lead buying budget, customer default rates and number of loans given out. Developed reinforcement learning model that helps select leads for consumer lending in order to decrease default rates. The reinforcement learning model helped the marketing team buy leads at specific price points to optimize the trade-off between high priced leads and the risk of default in order to boost enterprise value

Tableau KPI Reporting: Created and published Tableau worksheets and dashboards from Tableau desktop to Online cloud environment. Was responsible for developing the pipeline of integration between Tableau data sources and SQL server engine. As a result, the stakeholders from compliance and capital markets teams were able to focus on KPIs and led to 35% increase in raising capital for deployment. Dashboards created for underwriting KPI measurement led straight to a 3% decrease in first payment default rates

Financial Statements integration: Created Macros in Excel to pivot financial statements data and prepare it for exporting to CSV files. This helped reduce manual work done by the capital markets team.

Created reports in Power BI that help monitor performance of customer support representatives. By ensuring accuracy, conversion rates improved by 5% and speed of reaching out to new customers reduced from 2 hours to less than 7 minutes.

Marketing Campaign: Developed Python and batch scripts to call Mailchimp app API in order to implement repeat customer acquisition campaign, through automated e-mails.

Analytics Intern Techbridge Aug 2018 - Dec 2018

Created dashboards in Salesforce for community leaders to monitor their outreach programs to other non-profits. Community leaders were able identify and follow up with leads with 20% more efficiency.

Created dashboard using Tableau cloud environment which helps monitor high school students performances to ensure high school students are up to the academic standards set by the state.

Analytics Intern CONA Services LLC Jun 2018 - Nov 2018

Mined data and published metrics to measure control compliance for Coca-Cola bottlers.

Proactively identified control gaps and opportunities for improvement in IT service management. The insights provided helped reduce resolution time of incidents by 15%.

Created dashboard using Power BI Pro which used near-real time data to monitor IT service incidents.

Analyst Accenture Aug 2015 - Jul 2017

Retail Analytics Project. The scope of this project was to analyze customer buying patterns when customers change residence locations. Worked with third largest retail services client to develop ETL framework using a combination of Informatica and Teradata DB. Created mappings using Informatica to create ETL framework which loaded client data into Teradata databases using SQL. The data from the Informatica was used to analyze customer consumption considering factors such as location, annual income in order to predict rise in consumer consumption when customers switch locations.

Created scripts in UNIX environment to transfer results to third party vendors. This helped clients transform and transfer data with 30% more efficiency.

Finnish social security error prediction. The scope of this project was to develop and train machine learning model by building a ETL framework, so as to predict customer social security number errors in the system. Developed a Support Vector Machine ML model to predict erroneous social security numbers for the largest bank in Finland. The model had more than 80% accuracy rate. This helped clients save potential financial losses which could have been at least $500,000 and also keep customer satisfaction intact.

A combination of IBM DB2 database and IBM Datastage ETL framework was developed from scratch in order to support scalable machine learning models to run on top of this framework.

Created demonstrations for clients as part of agile framework using Tableau and MS PowerPoint, which helped give clients a clear idea about the project status and results after production deployments.

Awarded monetary benefits as part of the Accenture awards and recognition program. Promoted within one year for excellent work.

PROJECTS:

Social media analytics research assistantship:

Created a fault tolerant framework in Apache Kafka to stream 15000 tweets per second into Hadoop file system. Created dashboard using Tableau and Python matplotlib, plotly. Created a neural network in production environment to predict whether any tweet is relevant to the city of Atlanta with 75% accuracy. This system is utilized by the metro Atlanta chamber of commerce for promotion of the city.

EDUCATION:

Georgia State University, J. Mack Robinson School of Business Aug 2017 - Dec 2018

Master of Science, Major: Analytics, 4.09 GPA

Courses: Statistics with R, Machine learning with R, Big Data for Analytics, Operations Research.

Savitribai Phule Pune University (formerly University of Pune) Aug 2011 - May 2015

Bachelor of Engineering,3.75 GPA

CERTIFICATIONS

Neural networks and deep learning. 2018

Applied machine learning in python – Coursera certification. 2017

Contact this candidate