Diya Guha Roy
MBA Student
Washington University in St. Louis (WashU): OLIN BUSINESS SCHOOL
Email: ****.***@*****.*** Phone: 001-314-***-****
Objective/Aspirations
Seeking a management position with an organization where I can utilize my
skills and experience to marketing, project management, improve operations,
increase profitability, and enhance growth.
Experience Summary
I am attending MBA program (Marketing & General Management) in Olin
Business School for the last 1 year 11 months. I have done two Marketing &
Sales internships with companies in St Louis in 2013. Currently I am
working as marketing data analyst in my business school. I will be
graduating on 17-October-2013.
My main area of experience has been software project management,
development, testing and delivery. I have worked both in IT Software (2004-
2011) and Construction (2003-2004) domains. My technological forte is
Oracle 9i and 10g (SQL, PL/SQL), Unix, Shell Scripting, Selenium Automation
and testing.
Primary Domains: Software and Information technology, General Management,
Marketing, Sales, Business Development.
Technology
Below is a list of important hardware, software products, tools and methods
that I have worked with.
Hardware Software Products Tools Programming
Languages
Windows Oracle 9i TOAD Oracle
2000, XP, 7 Oracle 10g ORATST PL/SQL,SQL
Macintosh OS Microsoft Office Selectica Linux
Excel Risk Solver Selenium Shell Scripting
Unix OS Platform SPSS Perl
Excel Solver Google Adwords Linear
Regression
Non Linear
Modeling
HTML
XML
Functional Skill Areas
Qualifications
Degree and Date Institute Major and Specialization
MBA October 2013 Olin Business School Marketing, General
management
BE August 2003 Jadavpur University Civil Engineering, Remote
Sensing
The details of the various assignments that I have handled are listed here,
in chronological order.
Project Thesis : Management
Project - Concept Marketing for Duration May 2013 - September
OLIN Business School 2013
EMPLOYER : OLIN BUSINESS SCHOOL
Project Description:
The School is exploring new dimensions in academic channels. The
project involves
Identifying new subjects
Increasing Visibility in US and Singapore
Revival in student recruitment processes
Academic accreditation
Educational research works
Assignments:
Academic research work involving marketing data analysis to promote
the school globally
Involved in research work for academic accreditation
Comparing competitive products across the country and provide the
best solution for marketing issues.
Tools used :
Microsoft Office, CRM
Project - Controlling Marketing Duration May 2013 - August 2013
Expenditures for FOXTRAX GPS PVT
LTD
EMPLOYER: FORTRAX GPS PVT. LTD.
Project Description:
The company is doing research work to optimize the cost distribution
in advertisement. The primary goal is to have optimum budget to get
best cost per click (CPC) and click through rate (CTR) in Google
AdWords. The budgeting involves
CPC control
CTR Control
Gaining more coverage
Reducing cost
Distribution across search and display pages
Assignments:
Research work involving search engine optimization.
Involved in optimization of cost management for Google Adwords.
Usage of proper Ad extensions
Communicating the P&L to CEO
Tools Used:
Google Adwords, Excel Optimizer, Microsoft Office
Project - Marketing and Sales of Duration February 2013 - May 2013
two new product lines for STOPPER
TOPPERS
EMPLOYER : STOPPER TOPPERS LLC
Project Description:
Stopper Toppers make patented laminated covers for Sink, Bathtub
toppers. The company is currently trying to mass market the patented
product to corporate houses like Disney, Six Sigma and other
channels. It is engaging in partnerships with water, nature and
animal conservation companies. The project involved
Marketing of new product lines
Using Social media
Designing
Delivering Sales pitches
Partner association
Distribution
Assignments:
Created Go-To-Market Strategy for new product launch.
B2B selling
Prepared potential customer database.
Done research work on market segmentation, product launch strategy.
Prepared research data for market demand and product offering
presentation.
Involved in active marketing and sales process in two different
product lines.
Using social media to market products.
Communication with CEO regarding new business prospects.
Tools Used:
Microsoft Office
Project Thesis : Technology
Project - Oracle Enterprise Duration August 2006 - July 2011
Manager 10.2.0.4, 10.2.05, NG
EMPLOYER : ORACLE INDIA PVT LTD.
Project Description:
Oracle was introducing new versions of Oracle Enterprise Manager
Application. The application was made more robust with new technical
metrics to monitor the target elements effectively. The User
Interface was changed with sophisticated dashboards. The design
involved
Exploring new target types like SOA, BOM, APS etc.
ADF UI experience
New set of metrics to monitor the targets
Improved dashboard with real time data
Sophisticated knowledge base
Easier navigation
Improved release management
Assignments:
Role: Senior Member Technical Staff (2008-2011)
Used technical automation job for webpage and database applications
for quality improvement.
Worked as a senior QA Engineer for Oracle Enterprise Manager
Application.
Designed the testing (Agile) and implementation strategy to reduce
bugs in software product.
Reduced bugs below 1% which was below the standard (2%) in the
company.
Coordinated with technical and marketing teams to keep the product
standard high and free of bugs.
Documented and transferred knowledge to fresh entrants and related
team.
Involved in release management, regressions and shiphome testing.
Role: Member Technical Staff (2006-2008)
Achieved two bug free product releases and helped others to reduce
software glitches.
Developed and maintained automated scripts to fine tune software
application codes.
Provided Operating Systems and browser certifications on Google
Chrome, Netscape, Firefox and Internet Explorer.
Tools Used:
Toad, Selenium, Oratst
Programming Languages
PL/SQL, SQL, Perl, Unix, Shell Scripting
Project - Data warehousing Duration August 2004 - August 2006
projects for INFOSYS TECHNOLOGIES
LTD.
Customer name: Apple and Cisco
EMPLOYER: INFOSYS TECHNOLOGIES LTD.
Project Description:
Both Apple and Cisco was trying to improve their inventory management
system in data ware housing in APAC region. The projects needed
Daily, weekly, monthly, quarterly and yearly snapshot s of sales
data to higher managements
Monitoring sales pattern in APAC region
Maintenance of sales inventory through replenishment
Timely communication to store the inventory
Data mining for inventories
Assignments:
Delivered a dataware housing (DW) project to Apple which helped in
cost reduction in Asia-Pacific warehouses.
Developed DW application for Cisco to track its products using
'Selectica' tool till the selling point.
Analyzed customer requirements and devised high level design to
reflect business strategy.
Interfaced with clients (Cisco/Apple) and managed four junior
employees.
Delivered best quality within time frame and custom level costing and
was selected as 'primary billed resource'.
Tools Used:
Toad, Selectica,
Programming Languages
PL/SQL, SQL, Unix, Shell Scripting
Project Thesis : Construction Planning
Project - Planning engineering for Duration August 2003 - July 2004
SHAPOORJI PALLONJI PVT LTD
EMPLOYER: SHAPOORJI PALLONJI PVT LTD
Project Description:
Shapoorji & Pallonji was expanding its business in early 2000s in
Kolkata to get more construction projects. The project involved
Administration and User Maintenance.
Budget Preparation and Publishing.
Department wise Allotment Distribution.
Receipt Collection and Accounting.
HRMIS functions
Construction
Assignments:
Worked in field for crude data gathering and analyzed official data
to reduce cost.
Got trained for tendering, billing using ERP system.
Supervised onsite construction project involving day to day
construction progress.
Selected vendors after analyzing quotes of rates and presenting
analysis to management team.
Vendor Management
Tools Used:
Microsoft Office, CAD
Key Competencies & Skills
My Competency Profile includes the following
Skill Proficiency (E0 to E5)
Oracle E4
Unix E5
Shell Scripting E5
SPSS E5
Excel E5
Communication E5
Personal Details
Date of birth 19-Jan-1981
Sex Female
Nationality Indian
Marital Status Single
Date of Joining 01-Nov-2013
Present Address 6005 McPherson Avenue
Apartment A. St Louis, Missouri,
United States
Permanent Address EE-151/4 Sector II Salt Lake City
Kolkata, West Bengal, India
Contact Number 001-314-***-****