Atul Panchavate
E Mail: aboifo@r.postjobfree.com
Summary
• 3.5+ yrs total IT professional work experience & 2+ years of work experience as a Business Analyst
• Masters in Management Information Systems at University of South Florida ‘12
• Hands on experience in requirements gathering, analysis, preparing Business Solution documents (Test cases, user interfaces, report
specifications), Joint Application Development (JAD), workflow design and functional testing
• Strong knowledge and experience in relational databases: Oracle and SQL Server
• Proficient in database management systems, writing and optimizing SQL & PL/SQL code
• Good knowledge and experience in Business Process Modeling and Reengineering (“As Is” & “To Be” modeling / mapping of business
processes.) using Microsoft Visio
• KarROX Certification in Microsoft .Net Framework 3.5
• Critical thinker with decision making and problem solving capabilities
• Excellent interpersonal and communication skills
Technical Skills
Operating Systems Linux, Windows.
Languages known C, C++, ASP.Net, VB.Net, C#, Java, JavaScript, WCF, AJAX, HTML, CSS3, iWebKit, XML
RDBMS Oracle 9i, SQL Server 2005/2008, MySQL
Other Tools SAP, Microsoft Visio 2010, SharePoint 2010, Apache Tomcat, Dreamweaver, UML, WEKA, MS Office Suite
Education
Master of Science in Management Information Systems December 2012
University of South Florida, College of Business, Tampa, Florida [GPA 3.9 / 4.00]
Bachelor of Engineering in Information Technology First Class
Vishwakarma Institute of Technology (V.I.T.), Pune, India
Professional Experience
University of South Florida (September 2011 – December 2012) Role: Business Analyst & Application Developer
Project: Work Order Management Mobile System
• Gathered business requirements by conducting detailed interviews with the business users and stakeholders
• Developed use case diagrams, Process Models, Sequence diagrams using Microsoft Visio
• Involved in web application development using iWebKit for Apple and Android devices and designed database in Oracle
• Created tables, views and wrote/optimized complex SQL statements using joins, sub queries for report generation
• Prepared test cases and performed UAT on different platforms (Android and iOS platform)
Department: USF Post Office – Summer Internship (May 2012 August 2012) Role: Business Analyst
Project: Accountable Mail System
• Identified business process improvements and initiated reengineering for the old accountable mail system
• Studied and analyzed old USF Post Office mail system and created business process models (“As Is” & “To Be”)
• Responsible for preparing requirement understanding document (RUD), creating and delivering status reports
• Conducted & participated in JAD sessions with users & stake holders to gather system requirement specifications (SRS)
• Assisted in designing test plans and test cases for functional and user acceptance testing.
• Involved in interacting with vendors and their technical teams to buy and install Scanners for the new mail system.
N.W. Computers, Pune, India (June 2010 to June 2011) Role: Business Analyst & Application Developer
Project: ERP system
• Worked with the users, SME and developers to design and develop the Payroll and Inventory modules of the ERP system
• Involved in business process improvement, database design, UI design and preparing status reports
• Wrote complex SQL queries in Oracle to generate reports based on different criteria
P.I.C. Pvt. Ltd. Pune, India (June 2009 to May 2010) Role: Software Engineer
Projects: Medical ERP System & Report Trends
• Involved in development of the Medical ERP System using Asp.net, C# and designed database in Oracle
• Developed an application for generating Report Trends using Asp.net, C# and SQL server 2005
• Worked a Quality Lead to track the various processes followed within the project
• Worked in agile environment, was involved in integration and maintenance of the applications
• Optimized and handled database queries, created views and stored procedures to maintain backend of applications
Awards and Achievements
• Chief marketing and publicity coordinator of National Level technical event “AGON” at Vishwakarma Institute of Technology sponsored by
Microsoft 2006.
• Table Tennis Gold Medalist for VIT in year 2009.