SUMMARY
• 4+ years of profound working experience in SQL and PL/SQL programming and have worked on tools such as OBIEE 11g, SSRS.
• Extensive experience in business intelligence/reporting tools like Crystal Reports, ETL, Google Analytics, Google AdWords, SEO, SEM, SiteCatalyst, Tableau desktop and Tableau Server.
• Good statistical experience in R and SAS and sound knowledge in regression, clustering, forecasting, multivariate analysis, ANOVA, MANOVA.
• Excellent hands on Advanced Excel (Vlookup, Pivot Tables, Macros), MS – Office Suite, VBA, MS Project and MS Visio.
PROFESSIONAL EXPERIENCE
Southwest Airlines, Customer Relations Analyst Intern Jan 2014 – April 2014.
• Implemented complex reports and dashboards, forecasts, Business Intelligence and analysis solutions in Oracle Business Intelligence 11g (OBIEE).
• Created performance management dashboards to monitor the performance of employees in Crystal Reports.
• Generate data visualization dashboards to identify potential customer complaints using Crystal Reports.
• Recreated all Excel Reports into Crystal Reports.
• Developed a tool in SharePoint to maintain records of customer complaints and the solutions offered.
Retailmenot Inc, Business Intelligence Analyst Intern June 2013 – Aug 2013
• Generated SSRS dashboards to analyze customer buying patterns.
• Assessed user feedback data to create merchant segmentation on the basis of number of genuine coupons in Tableau.
• Examined changes in the website (A/B Testing) to determine how they affect customer buying patterns and outclicks.
• Analyzed KPIs (visits, out clicks, bounce rate etc.) using SiteCatalyst to compare the effects of change of ranking algorithm of coupons.
• Improved the efficiency of long running queries by implementing various SQL query optimization techniques using SQL Server Profiler, Query Analyzer and Tuning Advisor.
• Used SSIS 2012 to automate batch jobs like automatic E-mail generation.
• Co ordinate with other teams to convert their requirements into a Tableau dashboard.
IBM India, System Engineer July 2010 – May 2012
• Analyzed the root cause of failed jobs running in UNIX environment with the Rapid Problem Management team.
• Co ordinate and supported Change Management and patch upgrades to servers.
• Performed analysis of Incident tickets on failed jobs in Tableau.
Red Hat, Project Intern May 2009 – April 2010
• Implemented a tagging approach in LINUX semantic file systems to reduce storage, fast search and minimize performance impact.
• File could be used under multiple workspaces without physical duplication.
• Created a tag cloud where the size of the tag was directly proportional to the number of files in the tag.
ACADEMIC EXPERIENCE
• Business Intelligence Analyst: Used Data Mining techniques to identify patterns and formulated predictive models. Studied BI methods like Affinity Analysis using Apriori and ECLAT algorithms, Clustering using K-Means and Agglomerative methods. Model Analytics using logistic regression, multivariate analysis, ANOVA, MANOVA. Forecasting using Time Series Analysis, Moving Average, Weighted Moving Average and Exponential Smoothing and comparing Mean Absolute Deviation.
Technology/Tools Used: R, R Studio
• Data Analyst: Performed data preprocessing and analysis on Expedia marketing dataset to find out the customer segmentation across USA and thus minimizing the misclassification rate.
Technology/Tools Used: SAS, SAS Enterprise Miner
• Web Marketing Analyst: Participated in Google Online Marketing Challenge in order to increase the number of hits, average position in Search Engine for our client AlphaGRC Consultancy and thus succeeded to increase the hits from 300 to 570 and impressions from 140,000 to 270,000 in a given time.
Technology/Tools Used: Google Analytics, Google AdWords, SEO, SEM.
• ETL: Implemented the ETL process using SAP BW and designed queries using BEx query designer, analyzed queries using slice, dice, drill-down and roll up features in BEx Analyzer.
EDUCATION
• Masters in Management Information Systems, University of Texas at Dallas. May 2014
GPA – 3.67
o Graduate Certificate – Business Intelligence and Data Mining. June 2013
o Graduate Certificate – Google Analytics Individual Qualification Certificate. June 2013
• Bachelors in Information Technology, Pune University, India May 2010
Related Coursework
- Business Intellige...
Login or Register to view the full resume.
