Abhijeet S. Gunadekar
College Station, TX 77840
abmq5f@r.postjobfree.com
Objective Seeking full time/contract employment after May 2010 graduation
Education
Texas A&M University, Mays Business School, College Station, TX
May
2010
Master of Science in Management Information Systems, GPA 3.33
Courses: Financial Accounting and Procedures, Data Warehousing, Financial
Statements and Analysis and Business Data Mining
University Of Mumbai, Sardar Patel College of Engineering, Mumbai, India
June 2006
Bachelor of Engineering in Computer Science, GPA 3.5
Experience
Texas A&M University, Mays Business School, College Station, TX
January 2009-May 2010
Student Intern and Research Assistant, Real Estate Center
? Designed and deployed SSIS packages using technical and analytical skills
with a clear understanding of data model for Data
Warehouse development required for Real Estate information analysis and
reporting purposes.
? Created and developed T- SQL scripts, triggers and tables to extract and
load data resulting into more efficient dimensional data
analysis model facilitating implementation and further useful analysis
of data using SAS.
? Worked with users to define and convert their requirements into technical
specifications and complex reporting solutions (SSRS)
based on specifications and business needs and modified existing
reports as needed.
? Conducted data analysis and generated tables, listings and graphs using
SAS and SSRS for Texas Land market sales data analysis
and research publication purpose.
National Securities Depository Limited (NSDL), Mumbai, India
June 2006-June
2008
Assistant Manager and Database Administrator
? Communicated with clients to develop effective business solutions by
gathering and analyzing their requirements. Organized
weekly meetings involving senior management and technical staff for
status reporting and ensured a clear line of communication.
? Conducted training sessions for Business Partners to improve and better
their understanding of in-house transaction system
application.
? Performed a monthly audit of client systems for checking of technical and
functional consistency and leading to efficient
maintenance of client transaction systems.
? Supervised a team of 8 employees and coordinated their work by delegating
tasks to successfully carry out important decisions and
improved their performance by mentoring and sharing knowledge on a daily
basis.
? Developed complex T-SQL scripts and queries to analyze the data and
resolve the issues resulting into 75% reduction in production
issues and increased client satisfaction. Maintained proper
documentation of standard procedures for future reference.
? Managed production database by monitoring server performance, tuning the
database server and applications, and performing
backup and recovery for effective functioning of production.
Class Projects
? Business Data Mining: Performed data preparation, cleansing, data
analysis, and model evaluation using data mining algorithms for
effective detection of fraudulent car insurance claims.
? Data Warehousing: Designed a data model and developed an effective data
warehouse solution for a retail store chain using
Microsoft SSIS, SSRS and SSAS.
Leadership, Honors and Membership
? Winner, CMIS Case Study Competition, Mays Business School, Texas A&M
University, October 2008.
? Recipient, CMIS (October 2008), REAL ESTATE CENTER (August 2009).
? Recipient of CFA Society of Houston's CFA Exam "Society Scholarships",
January 2010.
Technical Skills
? Languages and Software: Visual C#, SQL, HTML, MS Office, Microsoft Visio,
SAS Enterprise Guide 4, Base SAS.
? Databases and Development Tools: MSSQL Server 2000/5/8, Microsoft Access,
SAS, .NET Framework 2.0/3.5, IIS.
? Business Intelligence and Data warehouse Technologies: Microsoft SQL
Server 2005 Reporting Services, SSIS, SSAS
? Certifications: MCITP Business Intelligence Developer, Preparing for CFA
Certification
Work Authorization Eligible to work in the US through optional practical
training for 29 months[pic][pic][pic][pic][pic][pic]