A

https://twitter.com/shaily****

G SHAILY AGRAWAL A acoz95@r.postjobfree.com

https://www.linkedin.com/in/shailyagrawal8 469-***-****

p

R t

SUMMARY

A 1

Graduate student and Research Assistant pursuing MIS in the field of Business Intelligence and Data Analytics.

9

W I am a "maker" and would like to find a career that allows me to discover interesting problems, build solutions

1

for them, and share that knowledge with others 8

A Actively Seeking Co-op/Full time position

L EDUCATION

University of Texas at Dallas

Masters of Science (MS) Management Information Systems (M I S) Richardson, TX May 15

Relevant Courses: Business Intelligence, Management Consulting, Data Warehousing, Spreadsheet Modelling GPA: 3.7/4.0

Enterprise Resource Planning, Web Analytics, Statistics, Software Analysis and Project Management, Accounting

Rajiv Gandhi Technical University Bhopal, India May 11

Bachelor of Engineering in Information Technology (Department rank 2/120) GPA: 3.8/4.0

Relevant Courses: Web-technologies, Object Oriented Programming, Database Management Systems, Data Communications

SKILLS

Key Skills

Data Modeling, Data Warehouse, Database Management, ETL, Data Visualization, Analytics, Business Analysis

Systems Analysis, Agile and SDLC methodology

Technical Skills:

MS-Office: Word, PowerPoint, Outlook, MS Project, MS Visio, Excel [Advance (Pivot Tables, V-Lookup, Macros) ]

Packages and Tools: SAP BW, SAS 9.3, Rapid Miner, Tableau, ERwin

Analysis Tools: SAS (Enterprise Miner), SAP Business Objects, Google Analytics, MS Excel

Databases: Oracle 9i/10g, DB2, SQL Server

Programming: SQL, PL/SQL, UNIX, C, HTML, SAS Programming

Operating Platforms: Unix, Linux, Windows

Certification: Sun Certified Java Programmer (SCJP), Google Analytics Individual Qualification(GAIQ)

WORK EXPERIENCE

Ryder System, Inc Business Analyst Intern July 2014 – December 2014

Work on SQL queries, generated and automated reports using TOAD for Data Analyst.

Conduct Technical Reviews for all IT changes going into production to evaluate the impact of the change on

business as well as other applications

Interact with Technology, Business and Internal groups to gather requirements and propose the best solutions

Managed and coordinated 50+ projects which also resulted in 12 new client accounts

Performed research to assist in development of project scope, define requirements, and proposed changes

University of Texas at Dallas Research Assistant January 2014 – June 2014

Design, development and maintenance of learning management system using PHP MySQL.

Managing wide range of activities to ensure smooth functioning of Professional, Global and other MBA courses at

UT Dallas.

Coordinating with the professors and students by hosting lectures via web conference for online MBA programs

UT Dallas CS Outreach, Richardson, TX Presenter & Coordinator August 2013 -December 2013

Instructor for Logo, Scratch, JavaScript, MIT Appinventor for Android which are basic programming tools for

individuals aged from 8 years through 14 years.

Administer planning, organizing and execution of many events and competitions.

Assist Prof. Jey Veerasamy with the teaching material for the classes (www.utdallas.edu/~jeyv/k12.htm)

Infosys Technologies Limited Programming Analyst September 2011 -July 2013

Associated with HCL Middleware SOA in Enterprise Application and Integration stream with the following

responsibilities

Involved in performing Data Analysis using TIBCO Spotfire for predictive analytics to analyze data using statistics

and speed decisions, helped segment their customers, generate reports on the company’s activity and financial

performance, helped to better manage and use the millions of data (non-structured records) they have

accumulated over many years to know their target customers to make enough investments and expand their

business

Automated the process to calculate the turnover percentage for fiscal years, reducing

reporting time and overhead in performing complex calculations

Forecasted quarterly product sales and predicted gross quarterly revenue by analyzing historical sales data,

geographic distribution & population density, customer demographics using Tibco Spotfire and presented

comprehensive reports to the executive management for the same

PROJECTS/RESEARCH

Business Intelligence/Analytics: Twitter Sentimental Analysis

Used Data mining Techniques to observe patterns and formulated Descriptive and Predictive models

Evaluated business Intelligence methods like Data Analytics (data pre-processing feature selection & imputation),

Model Analytics (model selection, enhancement & combination), Model Optimization (building customized models)

and Advanced Customer Analytics using SAS Enterprise Miner and XL Miner.

Accounting for Managers:

Perform in-depth research and analysis, develop and maintain Balance sheets, Income statements, Cash Flow

statements

System Analysis and Project Management: Bicycle Rental System for students

Developed ability to analyze business solutions and design computer based information systems using object-

oriented methodologies.

Analyzed a real-life business system, identified improvements, recommended and designed a new system to

incorporate the improvements

Identified project requirements and scope and team responsibilities and designed the project timeline

Web Analytics: Google Online Marketing Challenge

Create online marketing campaigns for a company using Google AdWords and Google+

Proficient in concepts related to web site optimization and web marketing : SEO (Search Engine

Optimization),Tracking & Analyzing website traffic, PPC (pay per click) using Google Analytics

LEADERSHIP ACTIVITIES

Enactus UT Dallas, Team Lead, Spreading Smiles

CMC Leadership Council, UT Dallas

Students’ Council, OIST President for 3400+ students

ASCEND leadership council, UT Dallas AVP, IT Committee

Co-founder and member of a NGO- Prayas, Bhopal, India

Habitat for Humanity, Volunteer Coordinator

Zonal level Chess Player

ADDITIONAL INFORMATION

Eligible to work in the U.S. for 29 months and will require visa sponsorship for further full-time employment.

Comfortable for the relocation and travel.

Contact this candidate