Project Management Data

NAYANA MADHEKAR

551-***-**** Jersey City, NJ ****7 www.linkedin.com/in/nayana-madhekar acy3cm@r.postjobfree.com

EDUCATION

Pace University, Seidenberg School of CSIS, New York, NY Expected May 2017

Masters in Information Systems Management, GPA: 3.62

Usha Mittal Institute of Technology, SDNT University, India June 2015

Bachelors of Engineering in Information Technology, GPA: 4.0

RELEVANT COURSEWORK

Database: Big Data, Data Warehousing, Mining and Visualization, Database Design and Web Development, Data Analytics and Decision Making (MBA Course), UX/UI Designing

Management: Information Systems and Organizational Strategies, Project and Change Management, Issues in IS, Visualizing GIS

TECHNICAL SKILLS

Requirement Management Tools: SAP Power Designer, SPSS, SAS

Work Methodologies: SDLC, Agile Methodology, Waterfall model, Spiral model, Kanban (Version 1.0), UML

Programming Languages: SQL, R, Python

Project Management Tools: MS Project, Microsoft Office Suite (Word, Excel, PowerPoint, Access), Share Point, Outlook

Analytical Tools: Tealeaf, Adobe Analytics, Google Analytics, Omniture, Coremetrics, Power BI, Tableau

Databases: MySQL, Microsoft SQL Server 2008-12, MS Access

PROFESSIONAL EXPERIENCE

Offrbox, New York, NY Business Intelligence / Data Analyst Intern Sept 2016 - Dec 2016

• Generated validation reports each week for real estate analysis through Business Intelligence tool - Microsoft Power BI

• Maintained 4 web analytics platform by building combined dashboards in Power BI Desktop using MS Azure

• Automated the process of searching 16K client data in excel by querying extensively in MS SQL to resolve missing, backup, duplicated data issues and organize databases containing over 10 years of data

• Executed complex SQL queries including JOINS, Pivot tables, lookups, chart functions to validate Back-end data

• Analyzed large datasets comprising of over 100k transactions using analytical tools to generate actionable information

• Provided data visualizations using Tableau to interpret data, trends to support recommendations increasing 95% better planning

• Performed data manipulation along with web scrapping using program interface (API) and managed multiple priorities alone

Sprint World Head Quarters, Kansas City, MO Web Analyst Intern May 2016 - Aug 2016

• Implemented Agile Methodology, best practices, processes, and tools across multiple agile product and organization

• Monitored KPI alerts and analyzed session data to understand consumer response and track N number of issues faced by them

• ETL, analyzed data to solve and address highly complex business problems to predict future outcomes and build strategies

• Designed and monitored Tealeaf (IBM) dashboards to ensure all API’s are working properly and monitored Keynote alerts to ensure all network resources and systems are running continuously

• Gave a broad overview of the hourly submission trend report by monitoring 9NS alert emails, RPM alerts and Adobe Analytics sanity-check dashboard to ensure customers are able to pay their bills online through desktop and mobile websites

• Built reports on order investigation (BAN service requests) and created Ad Hoc reports using SAP Business Objects

• Created weekly and monthly reports on manual application testing results and implemented hypothesis testing

Triologic Media Solutions, Mumbai, India Web Developer Intern July 2014 - Aug 2015

• Built a website for an online help portal to showcase our design strength in a professional manner using MySQL, PHP and HTML

• Utilized problem solving skills to develop, test, verify tech solutions and ran large scale ERP program projects

• Deployed reporting solutions using SQL Server Reporting Services integrated with SharePoint to provide real time data access

• Assisted senior leader in gathering, defining and articulating business requirements with Stakeholders and Change Control Board

• Created Use Case Diagrams, Activity Diagrams, DFD, FC, Wireframe designs and Prototypes for Business Process Modeling

ACADEMIC PROJECTS

Data Analysis on Citi-Bikes using Big Data Nov 2015

• Performed research by using Rapid Miner on the datasets; designed Citi Bike application to give customers all the Citi bike know-how needed to get around the city and aid other business organizations to benefit from the patterns analyzed using Big Data programming languages using R and Python

Accessories Store Ecommerce Website Jan 2016

• Developed a website for buying accessories online wherein accessories could be booked and ordered by customers

• Designed front end using HTML 5 and deployed database on the XAMP Server using SQL and connectivity using PHP

VOLUNTEER EXPERIENCE

• Volunteered as Web Developer for ‘African American Women In Cinema, New York’ and evaluated, tested, debugged the front end functionality of organization’s dynamic website for Award Events

• Active Project Management Institute (PMI) Student Member for New York chapter in the field of Project Management

Contact this candidate