Sales Data

POOJA DUGGAL

** ********* ******, *******, ** ***26 Phone: 716-***-**** ************@*****.*** OBJECTIVE

To seek Internship in reputed Organisation.

VISA Status

Currently doing MS MIS & graduating in May-2017. Authorized to work for 3 years wef June-2017 under OPT-EAD & OPT Extension-EAD in US as the course is STEM certified Masters Degree. EDUCATION

University at Buffalo, The State University of New York Expected Graduation: May 2017 Master of Science, Management in Information Systems GPA: 3.9/4

(STEM Certified & applicant is eligible to work in US under OPT & OPT extension (3 years)) Coursework: Data Warehousing, Statistics with SAS, Distributed Computing and Big Data, Database Management System Planned Coursework: Social network analytics, Predictive analytics with SAS e-miner, System analysis and Design Chandigarh College of Engineering and Technology, Chandigarh, India May 2013 Bachelor of Engineering, Computer Science and Engineering GPA: 3.6/4 SKILLS

Languages: Objective-C, Swift, Java, SQL, SAS Base, R

Tools and Technologies: MSVisio, Pentaho Kettle, Apache Hadoop, SPSS, Minitab, Tableau, JIRA, Radar, MS Excel, MS Powerpoint, Six Sigma -White Belt Certified

Configuration control: SVN, GIT

Database: Oracle 11g, MS Access,

Data Formats: XML, JSON, Plist

ACADEMIC PROJECTS

Data Warehouse for Retail Store Campaign Sept 2016 - Dec 2016

Identified Business Requirement and Process involved by performing Bus Matrix Analysis

Built Data Warehouse using Star schema architecture

Performed Extraction, Transformation and Loading (ETL) using Pentaho Kettle and Oracle SQL

Using Tableau, analyzed the dependence of campaign success on consumer behavior, product shelving and product categories Big Data Analysis using Hadoop Sept 2016 - Dec 2016

Analyzed the word count frequency of documents stored on HDFS

Created a program for analyzing bigram and trigram in the given files Database Management for Patient Referral Sept 2016 - Dec 2016

Identified Business rules to conceptually model the Entity Relationship diagram in Microsoft Visio

Created a normalized Database in Oracle for a Patient Referral System by ‘Primary Care Physician’ to a 'Specialist' using SQL WORK EXPERIENCE

National Informatics Centre, Chandigarh, India Sept 2015 - Jul 2016 Business Technology Analyst

Gathered the requirements and created the bid procurement process flow documents of each client

Created and validated the data of bid documents in MS Excel

Provided sophisticated analysis in form of Reports in Excel and Data Tables to be published on the website for internally

Responsible for maintaining the integrity of the bid process with use of Digital Signature Certificates

SPOC for user staff training of the portal at nine client locations

Provided day to day support functions and troubleshooting for the users

Marketed the e-procurement solution of NIC (GePNIC) in Haryana Govt departments by giving demonstration, interacting with senior Government officials for convincing them that solution is the best in class compared to other industry solutions of TCS, WIPRO & Next Tenders. I was able to achieve purchase of solution in 10 New departments during the year. Infosys Limited, Mangalore, India Oct 2013 - Jul 2015 System Engineer

Designed, developed and tested an iOS application for Apple's internal retail store in Objective C using Xcode

Designed the application using 'Design Thinking' methodology and design implementation using Storyboard and NIB files with an extensive use of Auto layout to make the application platform independent

Development of application using agile methodology while coordinating with cross functional teams from other companies including Business, QA and production support

Developed the application using Model View Controller (MVC) architecture

Extensive experience with project management tools like JIRA Software and version control systems like SVN and GIT

Internally tested the application and resolved bugs prior to production. Used Apple’s bug tracking tool 'Radar'

ACHIEVEMENTS AND EXTRA-CURRICULARS

Winner of IBM Case Simulation, University at Buffalo Sept 2016

• Analyzed market intelligence to develop a business and sales strategy that directed team’s negotiations with mock IBM clients

• Demonstrated strategic thinking, marketing and sales expertise, ethical decision-making, leadership skills

Public Speaking: Member, Toastmasters Society. Best Role taker- six times, Co-editor of quarterly newsletter

Contact this candidate