NA

SAI KRISHNA CHAITANYA CHIGILI

P: 312-***-****, https://www.linkedin.com/in/saikrishnachaitanyachigili, E: *******@***.***

PROFILE

Passionate Management Information Systems student, motivated by working on Market Research Analysis, Business Strategy and Analysis, Financial Problems, Business Strategy and Analysis, Statistical modeling, Machine Learning, Predictive Analytics, Data Mining. Seeking opportunities to contribute Analytical Insights, Business Strategy skills and develop an exceptional foundation in the Analytics Industry to drive high level Business solutions

EDUCATION

Master of Science, Management Information Systems, GPA: 3.7 / 4.0 Anticipated December 2016

University of Illinois at Chicago (UIC) – Liautaud Graduate School of Business Chicago, IL

Course: Advanced Database Management, Statistics, Data Mining, SAS, Web Analytics, Enterprise Information Infrastructure and Security, Marketing, Social Media and Digital marketing, Operations Management, Advanced Text Analytics for Business

Bachelor of Engineering, Electronics and Communications May 2013 Osmania University Hyd, Ind

PROFESSIONAL EXPERIENCE

American Society of Safety Engineers – Digital marketing Analytics Intern, Park Ridge, IL Jul 2016 – Aug 2016

Designed and deployed comprehensive lifecycle email marketing program specializing in B2B and B2C marketing

Designed the email templates using HTML, CSS and Adobe Dreamweaver and integrated with Google analytics to track the number of emails opened and the click through rate

Served as an Email Evangelist and worked in a team with Internet Marketing Strategists, SEO, PPC and Conversion teams to align outbound lifecycle initiatives for all clients

Used advanced MS Excel functions such as VLOOKUP, PIVOT Tables to process the lists using functions

Focused on list building and analysis for all clients to increase quality and quantity of new leads

Conducted inbox testing across major domains to ensure deliverability and brevity prior to deployment.

Using KPI’s and measurable metrics created segmentation strategies, A/B testing of subject lines, content, images and offers which drove higher open and click-through rates

Computer Sciences Corporation – Business Analyst, Hyd, IND Aug 2013 – Jun 2015

Client: Zurich Insurance Group – ZNA Health and Farmers Auto Insurance

Maintained the Zurich Insurance Application from gathering requirements to deploying the projects on bi-monthly basis

Developed the database module for Converting ICD 9 to ICD 10 codes, that facilitated the customers to claim life insurance for all hospital inpatient procedures performed on or after October1,2013 and process payments, reimbursements accurately

Developed the advanced SQL queries which helps to get the results 40% faster in Zurich Insurance database

Designed the data model and warehouse solution for automation of Insurance Renewal project

Designed a module in critical CEA application which has brought more than 50,000 insurance agents in compliance

Automated the application to eSignature Process which reduced 40% of policy completion time and saved $60,000

Optimized SQL queries for Zurich database search which gave results 45% faster than earlier

Headed a new team of 5 members for application testing and mentored them from development to deployment phase

Client: Kroger

The purpose of the project is to analyze terabytes of unstructured log information generated by the ecommerce website and extract meaningful information out of it

Analyzed all log data from individual servers to HDFS as the main log storage and management system and then perform analysis on these HDFS datasets that saved Kroger ~ $60,000

Created the hive partition tables and generated the adhoc analysis reports as per the client requirement.

Imported and Exported Data from Oracle Database to Hive QL and HDFS

Moved the Log data periodically using Flume into HDFS and performed data analysis using Pig and Hive

ACADEMIC EXPERIENCE

Marketing Analysis on National Veterans Organization Data to improve their marketing campaign using Excel and SPSS Spring 2016

Outlined the characteristics of the 13 million records and pre-processed the data for optimum analysis

Analyzed different machine learning algorithms and selected the C5.0 algorithm for the best accuracy and hit rate

Performed the cost benefit analysis using the gain charts and profit charts and estimated a maximum profit of nearly $170,000

Identified the Customers who can donate funds with 69% accuracy and provided recommendations to the marketing team

Topic Modeling of Play store Apps using Python using Gensim, LDA and NLTK packages Spring 2016

Scraped the data from applications using Python and packages Beautiful soup, Requests

Trained the model using the scraped data, and achieved 81% accuracy

Data Mining Analysis on German bank data using SPSS Modeler Spring 2016

Analyzed the data using C&RT, CHAID and C5.0 decision trees and used ROC, precision and Recall for determining buyers

Analyzed with data with neural networks and build the model that predicted with an accuracy of 79% over testing data and tested lift for top 25% of the customers

Analysis of Crowd Funding sites Gofund and Youcaring using Google Analytics, Tableau insights Spring 2016

Extracted and analyzed the data using Static and Dynamic dashboards, and identified the categories which are getting more funds and recommended Call To Action optimizations and backlinks for effective fund flow for other categories

Statistical Analysis on US Bank Data using SAS and providing recommendations to Marketing Client Spring 2016

Modeled the data for analysis using correlation, and identified relevant factors using factor analysis for further analysis

Clustered the data depending on factors identified using cluster analysis and analyzed the clusters

Identified the behavior of Customers in the clusters and provided recommendations to the marketing client

Financial Analysis for Credit Risk Approval using R language Fall 2015

Modeled the data using logistic regression and found customers who have a good credit rank, with an hit rate of 79%, whose credit can be approved

Designing a DataMart OLTP Database using MS SQL Server Management Studio Fall 2015

Created a Data mart that periodically accumulates data from Online Transactional Processing Database

Used MS SQL Server Integration services(ETL) to populate Data mart dimensions and to load Fact tables

Created an OLAP cube (a multidimensional Business Intelligence (BI) Semantic model) to perform multidimensional analysis

Designed advanced SQL queries using MS SSRS to report the data and achieved the results 30% faster than earlier

Surveying the site using Google Analytics and building marketing strategy by analyzing the inflow of visitors Fall 2015

Created an online website using Yola site builder and HTML, and integrated it to google analytics for analysis

Executed social media marketing strategies using Facebook, created banner ads, and led email marketing campaign, and by studying the Funnel reports on goal conversions and reported the ROI metrics and also executed A/B testing

Implemented Content Marketing Strategy to decrease the bounce rate by 36% and increase goal conversions by 27%

Dillard’s Department Store OLAP Cube analysis using MS Excel VBA, Pivot Tables, VLOOKUP and Data Analysis Tool Pak Fall 2015

Designed two critical strategies considering the stores and brands in Dillard's OLAP cube separately, and estimated the increase in the profit to be around 25% by identifying and eliminating the least profitable stores and brands

TECHNICAL SKILLS & CERTIFICATIONS

Statistical Software and Languages: SAS, SPSS Modeler, R language, Python, SQL, Java, Matlab, HTML, CSS

Big Data Ecosystems: Hadoop, Map Reduce, Hive, Pig, Spark

Other Tools: MS Office Suite, Adobe Photoshop, Dreamweaver, MS PPT, Tableau, IBM Watson Analytics, Google Analytics

Competitive Analysis, Customer Segmentation, Digital Marketing Strategy, Multi-Channel Marketing, Content Management

Certified in Professional Presentation Skills Development

LEADERSHIP ACHIEVEMENTS AND HONORS

Sports Lead for 3,500 members, CSC Hyderabad Fall 2015

Core Organizer, Limca Book of Records for Toastmasters for an impromptu 7 hour Speeches Spring 2014

Convener, Technical Fest, Acumen-13– a 2 day national level IEEE recognized technical symposium Spring 2013

Convener, Cultural Fest, Euphoria-13- Lead Student Coordinator of 2-day national level cultural fest Spring 2013

Contact this candidate