Abinaya Karunagaran

469-***-****; ac2sk5@r.postjobfree.com

Passionate and versatile engineer who has a broad range of skills dealing with data extraction and report generation. Adept at database management, fulfilling executive data requests and finding solutions to business issues. EDUCATION

The University of Texas at Dallas December 2016

MS, Business Analytics (JSOM Graduate Impact Scholarship) GPA: 3.88 Anna University, India May 2012

B.Tech, Information Technology GPA: 4

TECHNICAL SKILLS

Analysis/Reporting Tools : Alteryx, Kettle, Google Analytics, SAP Business Objects 4.0, Tableau 9.1, MS Excel, QGIS ETL Tools : Informatica Power Center 8.6, Informatica Data Quality 9.5 Databases : PostgreSQL, Oracle SQL Developer, DB2, Sybase, Microsoft SQL Server Programming Languages : Base SAS, SQL, UNIX shell scripting, R Statistical Techniques : Linear, Multiple, Logit & Probit regression, Anova, Hypothesis Testing BUSINESS EXPERIENCE

Tango Analytics, Dallas, Texas

Analytical Services Analyst Jan 2017 – Present

• Created a customer loyalty data mart for a leading retail client including 15 dimensions and 2 fact tables which reduced the processing overhead by 25%

• Collected, processed, analyzed, and reported on metrics and quality control data to meet specific customer reporting requirements.

• Contributed to build business dashboards to conduct trend analysis on retail metrics, especially related to sales revenue and customer retention KPI’s

• Performed sales forecasting to predict the optimal sales potential for new locations in Store Lifecycle Management, by minimizing sister-store impact and maximizing profitability

• Developed Brand awareness index and Trade area model based on the market of operation and customer profile

• Supporting and maintaining existing database and BI systems Tango Analytics, Dallas, Texas

Analytical Services Intern Sep 2016 – Dec 2016

• Performed detailed analysis of customer data including Exploratory statistics, Data classification for analysis, Spatial data analysis including definition of customer trading areas, Customer segmentation and profile analysis

• Cleansed the data to remove noise and inconsistency, Checked for data accuracy and Data validation Capgemini, Chennai, India

Associate Consultant Sep 2012 - May 2015

• Led 2 major applications for a financial services client including Anti-Money laundering and Employee trading, leading to a double promotion during a span of 2 years

• Performed end-end data modelling & analysis, design, development and maintenance of major applications

• Developed reusable mappets to execute the Data Quality rules across 10 source systems leading to 30% increase in efficiency

• Executed the Business rules in Informatica Data Quality with 100% Quality assurance and have Expert experience in designing and developing ETL jobs using Informatica Power Center and Data Quality

• Created visualization dashboards using Tableau desktop for internal project tracking, thereby enabling the team to identify and resolve gaps in timeline and dependencies

• Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.

• Planned along with senior management new ways to improve efficiency and reduce errors ACADEMIC PROJECTS

Marketing Predictive Analytics Using SAS Jan 2016 – May 2016 Market Structure Analysis for consumer product

• Analyzed store and panel level data for the consumer product – Diapers, using descriptive statistical methods

• Identified important factors leading to increase in market share for the top brand, computed price elasticity to learn the effect of competitor’s price fluctuations on the top brand’s market share Business Data Warehousing Aug 2015 – Dec 2015

TaskRabbit – Reporting & Visualization

• Created a reporting environment with an ecommerce website model - Created a universe in the Universe Design Tool of SAP Business Objects v4.1; Source: SQL server database

• Created reports in the Web Intelligence Rich Client tool and Data visualization performed using Tableau 9.1

Contact this candidate