Social Media Data

NAINY MEHRA

**** ***** *********, *******, ********, USA - 60616 +1-312-***-****

*******@****.***.*** www.linkedin.com/in/nainy-mehra Summary

Business Intelligence Analyst and Scrum Master with 6 years of IT industry experience across domains like airlines, retail, Pharmaceutical and entertainment. Expertise in Business Intelligence, Data warehouse, ETL, Scripting/testing software, Work Experience Reporting, SDLC, stakeholder requirement analysis. Seeking a full time Business Intelligence Analyst position. DormanSmith Switchgear LLC, Doha, Qatar December 2015 – June 2017 Business Intelligence Analyst

o Owned building of daily reports in Tableau, sent via email to manufacturing team to measure the actual and forecasted quantity of various products and streamline the manufacturing process, reduced shipping costs by

~10% and inventory idle time by ~25%.

o Acquired order details, sales, stock data from different data sources, Interpreted and analyzed data to identify key metrics to provide actionable insights on and future business strategies. o Carried out User Acceptance Testing (UAT) and coordinated with business users to validate the new functionalities, requirement changes and features upgrade request.

o Trained and mentored junior business analysts on building BI reports, understanding on service level agreements and Agile methodology.

Tek Systems, Bangalore, India March 2014 – June 2015 Agile Business Analyst

o Organized meeting with the key stakeholder, Hewlett Packard to gather business requirements, drafted ~200 test cases for Executive Briefing Center (EBC) application used by senior management to manage their bidding process, which led to the release of thorough tested application for the customer. o Led the automation of test cases for EBC tool using QTP framework saving 2500+ hours of manual testing effort. o Developed dashboards in Excel for SLA/KPI reporting by using pivot tables and VLOOKUP. Interpreted and analyzed data to transformed into meaningful insight for market strategy team. o Provided end-to-end solution design for data foundation. Created data warehouse using ETL Pentaho data model to implement Star Schema which helped in preparing business intelligence report for the revenue forecasting. Sabre Travel Technologies LTD, Bangalore, India July 2012 – October 2013 IT o Business Prepared Analyst end-to-end Business Requirement Document(BRD) for developing the Crew Control application, for clients, Jet Airways, Etihad, Sri Lankan Airways. Application helped to optimize crew transportation costs and reduced time taken to create rosters by ~20% using Waterfall methodology. o Identified functionality gap in the Crew control application and came up with actionable points for the IT teams with the help of Use Case Diagrams. Also validated the data in the reports against database by executing SQL query. o Designed and implemented stored procedures, tables and views which were used across the application for daily reporting. Also, created dynamic reporting dashboards via MicroStrategy BI tool. o Assisted in the implementation of data warehouse and data marts. Developed BI data models and ETL jobs for extracting data from different data sources and loaded them into data warehouse using Informatica. Capgemini System Analyst LTD, Bangalore, India February 2011 – July 2012 o Spearheaded the QA function to achieve a cost reduction of ~25% while releasing bug-free applications to key stakeholders, Johnson & Johnson and Warner Bros using Agile Methodology. o Worked on the project called “360 degree Dashboard” Tool. This project was mainly focused on generating reports of incident and change tickets. Involved in ticket trend analysis and data migration from excel to Oracle database. o Conducted Joint Application Development sessions, worked with teams in multiple locations and acted as a liaison between business users and technical team in gathering requirements for developing BI reports via Tableau. o Extensively documented business cases, test plans, root cause analysis and change request documents, leading to better recommendations for application performance improvements. Technical Skills

Programming tools: Core JAVA 8.0/9.0, JavaScript ES6+, Drupal, HTML5, CSS3, XML, JSON, QTP, Selenium suite Business Intelligence tools: Tableau, PowerBI, Informatica, Pentaho, SSIS, QlikView, Excel, Visio, R-Studio, Hadoop Project Management: Agile, Scrum, Kanban, Risk Management, Time & Cost estimation, KPI Analysis, ITIL v3, COBIT Versioning/Tracking: Maven, SVN, GitHub, JIRA, Siebel, TFS, HP ALM, IBM ClearQuest, Quality Center Database: Oracle 11g, MySQL5.1, SQL Server

Education

Illinois Institute of Technology – Chicago, Illinois, USA August 2017 – May 2019 Management in Information System GPA: 3.8 / 4.0

Staffordshire University – Staffordshire, UK August 2006 – May 2010 B.E in Information Technology GPA: 3.6 / 4.0

On Campus Projects

Illinois Institute of Technology, Chicago, Illinois, USA May 2018 – Present Graduate Student Assistant

o Developed dynamic web pages for Active Fantasy Sports application using JSP, Java Script and CSS styling. Also worked on a corresponding Fitbit app.

o Responsible for social media distribution of IIT news feeds using Google forms and MailChimp. o Worked as check-in staff in Chicago Public Schools (CPS) testing conducted at IIT. Served as the first point of contact for students, organizing and coordinating tests for more than 1000 students. Academic Projects

Course: Advance Database

Project: Implementation of DBMS for B&N Bookstore

Designed logical schema and physical database structure for well-known bookstore chain that has helped in improving business processes and also generated business intelligence reports using analytical SQL queries. Course: Client-server Architecture

Project: Analysis on MR jobs

Installed Hadoop on local and cluster environment. Worked with weather historical data, ran different MR(Map- Reduce) jobs with various optimizations techniques. Also analyzed how execution time of each MR job is effected by adding of different number of MR reducers, compression and combiners techniques in Hadoop Architecture. Course: Project Management

Project: Significance of requirements gathering

Identified and presented thesis on common errors and best practices in requirement gathering techniques. Also explained how proper requirement gathering leads to successful project execution, control requirements creep and save cost/time for any organization.

Rewards & Recognitions

o Team excellence-Award at Capgemini for exceptional contribution in developing high quality deliverables. o Gold Star-Award at Sabre for the most efficient team member and closing the highest number of customer deals. o Peer-to-peer-Award at Dorman Smith for introducing new customers to the organization.

Contact this candidate