MAHALAKSHMI SUNDARARAJAN
**** * **** ******, **** 1204 .Tucson, AZ .
**************@*****.**.** . 520-***-****
[pic]
OBJECTIVE
To seek full-time position as a Business Intelligence Analyst/Entry-level
Project Manager in an organization that will enable me to progressively
learn and utilize my analytical and project management ability.
EDUCATION
- MS in Management Information Systems, University of Arizona, Dec
2010(expected), GPA - 3.93/4.0
- B.Tech in Textile Technology, Anna University, May 2007, GPA -
3.59/4.0
WORK EXPERIENCE
University of Arizona, Graduate Assistant, Applications System Analyst
(Graduate College IT), Oct 2009 - present
- Statistical Analysis of data for surveys using SSRS, GNU R.
- Created websites with Drupal Content Management system using various
modules such as cck, taxonomy access rules, workflow, views, rules,
triggers and actions, organic groups, computed fields etc.
- Analyzed the graduate college database, identified design anomalies
and proposed a normalized design.
- Created reports, dashboards and triggers for students and faculty
statistics using Oracle Business Intelligence tool.
Graduate Assistant, Business Intelligence Reporting Analyst (SALT Centre),
Jun 2010 - Jul 2010
- Analyzed the reporting requirements at the SALT centre by conducting
interviews with the client.
- Created reports, dashboards and triggers enabling analysis of academic
performance, demographics.
Tucson Medical Centre, Student Consultant, Aug 2010 - present
- Developed a comprehensive understanding of Accountable Care
Organization (ACO).
- In the process of reviewing information systems approach, impact on
the legal system, education to healthcare professionals, financial
impact and impact on network of the healthcare community with ACO
pilot program.
- In the process of researching/developing an optimal incentive
structure and design.
Infosys Technologies Ltd, Software Engineer, Jun 2007 - Jul 2009
- Analyzed the existing business process, database design and job flow
by conducting extensive JAD sessions.
- Designed a job flow that incorporated re-usability of the existing
business processes/job flow and also programmed and tested new batch
jobs/programs.
- Tested the correctness of the incoming data and communicated the
anomalies to the ETL team and loaded the DB2 data warehouse.
- Created test plans and test cases for user acceptance testing and
communicated the results to the client prior to implementation.
- Tested front end functionality in various applications and reported
bugs to the development team.
SKILLS
Domain Knowledge: Banking and Capital Markets, Retail (basic Transaction
processing)
Databases and OS: DB2, Oracle, MS Access, MySQL, MS SQL Server Management
Studio, Windows, Ubuntu
Languages: SQL, C, COBOL, CICS, JCL, HTML, XML, Java, UML
BI Tools: OBIEE, OWB, Microstrategy, SSRS, Weka, SPSS, GNU R
Packages: Drupal, MS Office suite, MS Visio, MS Project, Fogbugz
Concepts: Business Intelligence, Balanced Scorecard, Project Management,
SOA, RDBMS, COBIT, ITIL, Business Process Analysis, Content Management
Systems, workflow analysis, Software design patterns, Data Mining,SAAS
Planned certifications: ITIL V3 Foundation, PMP (both in December 2010)
ACADEMIC PROJECTS
Dimensional Modelling and Reporting, Feb 2010 - Mar 2010
- Dimensional modelling and implementation in Oracle Warehouse Builder
for in-class exercises for the course work Business Intelligence.
- Reporting in Microstrategy and OBIEE for case analysis.
Google Online Marketing Challenge (GOMCHA), Feb 2010 - Mar 2010
- Successfully improved performance of the ad-groups using important
concepts in web analytics such as click- through rate, conversion rate
and continuously monitoring the network settings.
- The campaign was judged as 'strong campaign' and was amongst the top
ten % of the competing teams.
- The project won the second place in the competition held internally at
Eller College, University of Arizona.
Business processes re-design at the Lunar and Planetary Sciences, Sep 2009
- Dec 2009
- Represented AS-IS and TO-BE business process using dataflow diagrams.
- Represented the use cases by use case diagrams and the workflow using
activity diagrams.
- Proposed a normalized design (E-R Diagram), implemented the normalized
database in Oracle and developed front end prototype using Java
applets.
- Analyzed alternatives such as buying software or developing it in-
house and provided recommendations.
Krebs Engineer's Business Intelligence, Jan 2010 - May 2010
- Designed a balanced score card after extensive research about metrics
measured generally in manufacturing firms.
- Designed Sales, Order and Back logs dashboard prototype that helped
track the performance in those departments.
Office of Technology Transfer (OTT), University of Arizona, Feb 2010 - May
2010
- Balanced score card and dashboard development/implementation.
- Thoroughly analyzed the metrics measured in the current system at the
OTT.
- Compared and contrasted the metrics measured by peer institutions.
- Implemented a front end prototype to measure the key metrics using
SSRS.
Project Management for EON US, Jan 2010 - May 2010
- Extensive analysis of the existing manual processing in place and
benefits of SAP implementation.
- Designed a comprehensive project management plan including: Business
Process Document, Work breakdown structure, Gantt chart, Cost
analysis, Resource planning, Resource assignment matrix, Quality
management plan and Risk analysis.
- This project management plan was developed for a finished
implementation. Our team undertook this project to gain in-depth
knowledge of developing project management plan for an extensive
project.
Sarigama.com, Jan 2010 - May 2010
- Designed a comprehensive portal for carnatic music (an Indian
classical music form) that incorporated features of user interaction
such as learning, providing feedback, shopping, participation in forum
etc.
- Database design and implementation using SQL Server Management Studio.
- Implemented lyrics recommender system using the data mining tool
'Weka'. The algorithm used for implementation was K means clustering.
- Implemented Google widgets and API for user interaction, Playme API
for audio and youtube API for video.
Restaurant and rental accommodation web services, Sep 2009 - Dec 2009
- Implemented Representational State Transfer web service using Google
maps API, rentrent.net API and YELP API.
- Included functionalities such as providing real estate and restaurant
information with user specific input
ACCOMPLISHMENTS
- Ranked one of the top three GPA holders in both Graduate and
Undergraduate studies.
- Awarded academic scholarship for Fall 2009.
- Won the second place in GOMCHA (at University of Arizona) amongst 15
teams.
- Finalist in case competition held at Eller College of Management,
University of Arizona.
- Member, career strategy team, Assistant Editor of MIS Graduate
Association newsletter.
- Won prizes/accolades for performances in Indian classical music
(vocal).
- Mentor for new students in college (Anna University) as well as team
members at Infosys.
- Secretary (Jan 2010 - May 2010), Ramblers Hiking Club, University of
Arizona.
Relocation preferences: Open to relocating anywhere in the U.S.
References: Available upon request