POOJA S SURNIS **** E *th Street Apt #E Bloomington IN 47408
PH: 650-***-**** ********@*******.*** www.linkedin.com/in/poojassurnis/
EDUCATION:
Kelley School of Business, Indiana University, Bloomington, IN [May’13-May’14]
Master of Science in Information Systems with Business Intelligence and Analytics concentration
- Analytics Project: Built an analytical model with SAS and JMP to predict student enrollment in Office of Admissions
- BI Data Visualization Project: Built executive level dashboards for Discover Financial Services to track fraudulent credit card transactions across time and region
- Capstone Project: Designing investment banking IT value maps and IT landscape for Kurt Salmon
- Council Member, Women in Technology
- Certified by ITIL v3 foundation, License 4911758
Konkan Gyaanpeeth College of Engineering, Mumbai University, MH, IN; GPA 3.7/4.0 [July’07-June’11]
Bachelor of Engineering in Computer Science
- Capstone Project: Built an online yearbook to connect all users of an organization using ASP.NET, C# and AT commands
- Web Tech Project: Built a Web Application to track student attendance; Was appreciated in college newsletter
- Class representative in student council for 2 years
- Public Relations officer for IEEE student branch
WORK EXPERIENCE:
Tata Technologies Limited, Pune, India [July’11-April’13]
Role: Solution Developer: Siebel Analytics for CRM Business Intelligence team
- Designed application and dashboard reporting modules for Tata Motors client on Oracle Business Intelligence Application for all dealers in APAC region
- Performed fine tuning of Extraction, Transformation and Loading (ETL) process of OLAP Database of size 3TB
- Improved data sanity and increased the efficiency of dashboard performance by 30% by implementing changes in Data Warehouse and table structures
- Certified by Harvard Business Management Mentor in ‘Goal Setting’ and ‘Leading and Motivating’
Role: Functional Consultant: CRM Business Intelligence Domain - Life Line team
- Led a team of six to deliver weekly releases, and develop ETL processes for dealers in APAC region
- Analyzed feasibility of changes to be introduced in the DataWarehouse tables in Tata Motors OLAP and OLTP Database and advised development team on appropriate actions to be taken
- Performed bug fixing and achieved 35% reduction in time required to solve client service requests
Role: Graduate Engineer: Enterprise Solutions Group
- Implemented changes in Siebel Analytics processes for the clients using knowledge transfer sessions
- Executed migration of Siebel Analytics 7.8.4 to OBIA 7.9.6.2 environment for Tata Motors client with a team of 7
- Performed requirements elicitation from dealers & stakeholders across APAC region to build knowledge repository
SKILL SETS:
- Programming Proficiencies: C#, C/C++, Java, SQL, MDX, HTML, Visual Basic, ASP.NET, SAS
- Database/Packages: Microsoft Visual Studio, Microsoft SQL, Access, DataWarehouse Administration Console 10x, MySQL, SAP, OBIEE, JMP, Informatica Powercenter8x
- Reporting Tools: Siebel Analytics, Tableau, Palisade @Risk, Talend
- Other Proficiencies: Microsoft Word, Microsoft Excel, Microsoft Power point, Microsoft Project, Microsoft Visio
ADDITONAL:
- Art of Living foundation: Volunteered as a fund raising event organizer for a Non-Profit organization
- Microsoft Dreamspark Yatra: Organized a Microsoft Event for promoting Cloud Computing and Win 7 Mobile
- IEEE paper presentation, 2nd place: Technical paper presentation on ‘cryptography’
- School of Engineering, 1st place in literary events: English Debate, “War of Words” and Elocution competitions
- School of Engineering, 2nd place in “Best Female Entrepreneur”: Lead a team of three students in the event