Project Data
Resume:
Rishi M. Popat
**** *** ****** ******* ** ***** . Email: **********@*****.*** . Cell:
EDUCATION
Masters(M.S.) in Computer University of Southern August 2007 - May 2009
Science California
Bachelor of Computer University of Mumbai August 2003 - May 2007
Engineering
WORK EXPERIENCE
Business Analyst, Jaypar Inc
January 2010 - present
. Responsible for interacting with client teams to understand business
objectives, aligning on required analyses and collaborating with cross-
functional teams to execute project goals
. Worked closely with functional experts to narrow key metrics to track for
executive dashboards and what-if analyses; subsequently interfaced with
IT teams to ensure appropriate design and development
. Co-ordinated functional specifications with off-shore development teams
. Documented the business process by identifying the requirements and also
involved in finding the system requirements.
. Participated in the creation of project plan, define milestones and goals
as well as creating the functional test plan and the user acceptance
testing
. Accomplished the successful data migration from SAP to Oracle maintaining
data integrity and consistency.
. Successfully customized and deployed SAP Rapid Marts using Data Services
Designer (Data Integrator).
. Co-ordinated with BI team members to review legacy reports, develop a new
Data Model design and data transformation logic to support the reporting
requirements
. Worked on functional specifications to narrow key metrics to track for
executive dashboards and What-If analysis; subsequently interfaced with
IT teams to ensure appropriate design and development
. Excellent knowledge of the Business Objects Suite helped train the end
users and brought them up to speed.
Technology/Tools Used: Crystal Reports, BusinessObjects XI 3.1, Xcelsius,
Data Integrator 11,
Oracle 10g
Software Engineer, Sequence Data, Santa Monica CA
August 2009 -December 2009
. Implemented a business application tool in Python/Django to get
statistics of viewers and clips.
. Developed a system which analyzed user preference and created a
report for ready reference.
. Configured maintenance and backup jobs for MySQL databases.
Technology/Tools Used: MySQL 5.0, Python, Django, Subversion, Ubuntu
Business/Data Analyst, Adsystech, Long Beach CA
June 2009 - August 2009
. Interacted with clients to obtain requirements for software
customization.
. Mapped requirements and provided the clients (State and Federal
government agencies) with working prototypes.
. Identified and bridged the gaps between client's needs and
services provided by the software.
. Configured and validated scheduled jobs to ensure daily, weekly
and monthly backups of MS SQL databases.
. Developed a Disaster Recovery system including replication of data
on different servers at multiple locations.
. Installed and configured Idera(database monitoring tool) to
monitor and optimize database performance.
Technology/Tools Used: MS SQL Server 2000/2005, Idera, VB.NET, SQL, PL/SQL
ORACLE Database Administrator, AOL, Santa Monica, CA
May 2008 - August 2008
. Created Intranet statistics packages for business development
group by data mining Oracle database.
. Set up Enterprise Manager to enable graphical interface for non-
technical individuals to monitor the database
. Deployed new PL/SQL code into the QA and Production environments
as needed.
. Developed a system to monitor functioning of database using PHP
pages and stored procedures in
Oracle
. Joined Boards development team and was responsible for building
out of all necessary procedures, packages, functions and triggers.
Technology/Tools Used: Oracle 10g, TOAD, PLSQL, HTML, CSS, PHP, MySQL
Project Leader, Tata Institute of Fundamental Research (TIFR), Mumbai,
India June 2006 - May 2007
. Actively managed cross-functional teams (Engineering and Quality
Assurance) to accomplish the goals of the project, GNOWSYS, a kernel for
semantic computing (www.gnowsys.org) .
. GNOWSYS helps bring structure to all the gnowledge(sharable
knowledge) available on the internet.
. The parameters for testing were data security, integrity,
scalability and archiving in an e-learning environment.
. This project also included the testing of various GnowQL library
functions.
. Developed code for data migration of the data in ATutor (an Open
Source Web-based Learning Content Management System (LCMS) from SQL to
GnowQL
. Data migration was done with reference to the SCORM standards.
. Scripted test cases in Python to enable different testing
strategies.
. Configured test cases for unit testing, load testing, stress
testing, regression and incremental integration testing.
Technology/Tools Used: Python, PERL, CVS, GnowQL, ZOPE, ZODB, SCORM, MySQL
PROJECTS
Website scrapping and Mashup Application
. Implemented server side scripting using PERL to scrap websites.
. The website used in this project was tv.yahoo.com/listings.
. TV listings were dynamically extracted into XML files,
. These files were then passed through Java Servlets in JSON format.
. Implemented client side scripting and Google Maps API to parse
JSON files.
. The data was then displayed on Google Maps
Technology/Tools Used: Perl, AJAX, JSON, XML, JavaScript, HTML, Java
Servlets and Google mashups
Web Technology, XML Parser and DOM
. Websites were scraped into XML format.
. An XML parser was used to parse the results of scraping the
website.
. The results were accessed using JavaScript and DOM and were
dynamically displayed.
Technology/Tools Used: HTML, XML, DOM and JavaScript
Computer Networks (Socket Programming)
. Implemented client server architecture using TCP and UDP protocols
on UNIX in C.
. Simulated a network consisting of self organizing set of nodes to
discover and communicate with each other
. This communication took place in a Client - Server environment
using TCP and UDP sockets.
. Initially, status messages were sent in the form of UDP packets in
phase 1
. The data was sent using TCP data packets in phase 2.
Technology/Tools used: C, TCP/IP, UDP on UNIX Platform.
Software Engineering, Los Angeles Personnel Department
. Interacted with Clients during the requirement gathering phase.
. Identified the need to improve the searching technique and also to
re-design the database.
. The Agile method of Software Development was used to develop a
prototype.
. The prototype was presented to the client for their approval.
. Gaps were identified and were bridged.
. COCOMO was used to estimate the effort to complete the project.
Technology/Tools Used: Visual Basic, MS Access, COCOMO, MS Project,
Distributed Assessment of Risk Tool(DART), Rational Software Modeler.
Data Warehousing, Business Intelligence and Mining
. Working with the USC Marshall School of Business to create a data
warehouse.
. The data warehouse consisted of a large database designed using
the snowflake schema.
. It was mined using business intelligence software MicroStrategy.
. The objective of this project was to evaluate the effectiveness of
data mining and applications of business intelligence algorithms to a data
warehouse.
Technology/Tools Used: MicroStrategy, MS Access, Oracle 10g, SQL, PL/SQL
Face Recognition System, Brain Theory and Artificial intelligence
. Developed a system that learnt to recognize human faces using a
back propagation network.
. The system was trained using a back propagation network by showing
it a list of faces.
. Another set of faces were used to validate the results of the
earlier set.
. In the last phase, the system was tested with a third set of
faces.
. Came up with a layout to display the results in the form of graphs
and tables.
Technology/Tools Used: NSL-Matlab, Brain model
TECHNICAL SKILLS
Programming Languages : C, C++, Java, SQL, PL/SQL, Visual Basic, Python,
Perl, OpenGL
Databases : ORACLE 8i,10g and 11g, MS Access,
SQL Server 2000 /2005 /2008
Web Development : PHP, HTML, XML, DOM, JavaScript, Dream
weaver, Apache, Tomcat
Application Packages : MicroStrategy, Matlab, Rational Rose, TOAD,
Wireshark, Adobe Suite, Operating Systems : MS-DOS, UNIX,
Windows 9x, 2000, NT, XP, Vista, Ubuntu, Linux
SOFT SKILLS:
Presentation to clients, Communication (Verbal and Written), Budgeting,
Negotiations, Team player, Leadership, Multi-tasking, Self
Starter.
EXTRA-CURRICULAR ACTIVITIES
Team Leader, USC Library
Security
2008-2009
. Managed a team of 65 students responsible for USC library
Security.
. Created and implemented 24x7 security schedule for the libraries
. Resolved team issues and encouraged team spirit among the officers
. Implemented point system to reward star performers.
. Certified American Red Cross First Aid and CPR
provider. 2008-2009
. Founding member and Chairman of CSI (Computer Society of India)-
Student Chapter. 2006-2007
Shah & Anchor Kutchi Engg. College (SAKEC)
. Tutored eight under-privileged students of Don Bosco Shelter to
help them achieve their1999-2001 academic goals in Math, Science, English
and Social Studies.
Contact this candidate