Neha Kalra (***) *** – **** *************@*****.*** LinkedIn
EDUCATION
THE UNIVERSITY OF TEXAS AT DALLAS - MS in Management Information Systems May 2019 Courses: Business Data Warehouse, SAS, System Analysis, Web Analytics, Data Viz, Agile (Scrum), Predictive Analysis
MAHARSHI DAYANAND UNIVERSITY - Bachelor of Technology in Computer Science July 2013
Courses: Database Management, Computer Graphics, Data Structures, JAVA, Computer Networks, Web Development
TECHNICAL SKILLS:
BI: BIDS, ETL, SAP Business Objects, SSRS, SSIS, SSAS, Informatica MDM, Looker, QlikView, Tableau, Power BI, Gephi,
Data Mining: R, SAS Enterprise Miner, Cluster Analysis, Descriptive/Predictive Statistics, Linear/Nonlinear programming, Regression Analysis, A/B Testing, RapidMiner, Advanced Excel, Power Pivot, RStudio, ArcGIS, Teradata, MS Azure, DB2
Software Engineering: Data Modelling, SharePoint Nintex, InfoPath, Git, C, C++, C#, Python, XML, HTML5, PHP, JavaScript, D3.js, JSON, PL/SQL, MySQL, NoSQL, PostgreSQL, Oracle 10g, VBA, ASP.NET, UNIX Shell Scripting, PowerShell
Project Management: MS Visio, MS Project, Agile (SCRUM), JIRA, WBS, FMEA
ACADEMIC PROJECTS
Data Visualization - Analysed large dataset at global and country level; implemented R-based clustering to perform an integrated visual analysis and created interactive data stories in Tableau to present value enhancing insights
Business Analytics with SAS – Estimated the price of used cars using logistic regression & market basket analysis; also established a relationship between car attributes and its price using cluster analysis and association rule mining
Web Analytics – Analyzed market data for omni.care, measured campaign results and proposed changes to drive decision making, effectively reduced CPA from $6.9 to $0.8 and improved engagement rate by 200%
Machine Learning – Combined collaborative, knowledge-based and content-based filtering techniques to design and develop a ‘Movie recommendation System’ which can help users to save time and get personalized recommendations
Data Structures – Developed a project to detect collisions between moving objects and implemented zoom in and zoom out functionality using Quadtree algorithms in Python that can be used for gaming or robotics
WORK EXPERIENCE
Application Programmer Specialist Co-op – AstraZeneca, Maryland May 2018 – May 2019
Replaced paper-based process with an online ‘Task Management System’ developed using Python; leveraged customer feedback to strategize new features, estimated faster project deliverables by 10 days
Created complex DAX measures and integrated custom visuals in Power BI; generated health metrics to support changing business needs and allowed users to visualize information more effectively
Senior Systems Engineer - Business Intelligence Analyst – Infosys Limited, India May 2016 – July 2017
Gathered technical requirements from client and supervised a cross-functional team of 20 employees
Collaborated with 3 lead Analysts to identify gaps and inconsistencies within the current system and made recommendations by developing a cost-effective business model
Automated control flow & data flow events using data transformation scripts to allocate high priority to logged errors established for more than 3 days, bringing about an expansion in the rate of mistake settling by 40%
Analyzed real-time job failures and performed regression analysis in SAS to ensure efficient system functionality and recommended scheduling enhancements which improved system performance by 20%
Identified KPI’s; created dimensions & MDX expressions to implement cell-level security in SSAS OLAP cubes
Systems Engineer - Business Intelligence Analyst – Infosys Limited, India Feb 2014 – Apr 2016
Designed high-performance data integration solutions by developing and deploying SSIS packages into Dev, QA and Production environment through job scheduling to ease the debugging process
Migrated Oracle Discoverer reports to SSRS reports and deployed 500+ ad-hoc SSRS reports on report server; performance tuned long-running reports and optimized rendering time by 10 times of the actual time
Software Engineer – National Informatics Centre, India Aug 2013 – Jan 2014
Developed complex machine learning algorithms based on exploratory data analysis and predictive modeling, that were used to strengthen relationships and personalize interactions with customers
Designed, tested and implemented a user login, online registration, order placing and tracking system in 6
months; also developed a security system to monitor failed authentication using PHP, JSON, JavaScript and CSS
COMPETITION, LEADERSHIP & CERTIFICATIONS
Google AdWords, Google Analytics Certified
Organized Texas Level – Analytics Case Competition as part of Corporate Relations team, INFORMS Club, UTD
1st Runner-up in Data Visualization Hackathon 2018 organized by Data Science Student Chapter, UTD
Head of Technology at INFORMS Student Chapter; designed and developed www.informsutd.org