Punam Patil

Punam Patil Contact: - (M), E-Mail:- Business Analyst PROFESSIONAL SYNOPSIS A Software IT professional with 5. 5 years of experience as a Business and Data Analyst with excellent problem solving skills, good understanding and knowledge around resolving operational issues, extensively worked on Data Analytics including data normalization as per the business requirements and regulations, additional working experience in the SDLC and Agile SCRUM frameworks for software development as part of development projects. Besides ITIL 2011 Foundation certified with fair understanding of processes in large IT set-ups. KEY SKILLS Hands on experience in SQL Server for writing SQL Queries, stored procedure, triggers, functions, view, scheduling jobs, performance tuning, and index. Strong knowledge of ITIL. Strong knowledge with practical knowledge in Microsoft office-Excel, Excel macros & Access. Excellent problem solving skills with ability to provide appropriate solutions along with RCA, resulting in resolution of schedule, resource, and technical conflicts. Prepared formal SDLC documents like Functional and System Requirement Specifications, Design Documents, Support documents and user manuals. Supporting L2 Incidents and Service Requests during the handover of applications to Operations team. Good knowledge and handling experience of Remedy. Experience on KANBAN of Handling User Stories in Agile methodology. CERTIFICATIONS & TRAINING ITIL 2011 Foundation certified VBA Certified Microsoft SQL 2012 Design and Development certified. Microsoft Office Advanced Excel Trained ORGANIZATIONAL EXPERIENCE 1. Tech Mahindra Ltd Nov 2016-Till Date # Project 1 Intrada Pro Description Intrada Pro is a Telecom based system which is already develop in old Java Swings–desktop system and customer want to modernize in system in Web technology. System having ability to generate the new order and new order task till the billing phase and generate the complete worklist for particular order. System also display the customer details information, billing information, order details and the task of order with the status from the oracle database. Responsibilities: Support client meetings to ascertain Business and System Requirements. Define and document all change requirements and conduct detailed analysis of customer requirements to produce Business Requirements documentation, Product Specifications and Technical Specifications. Analyze and document existing business processes and systems and develop revised processes and systems to improve business performance Provide system designs and solutions to meet the customer requirements Provide product demonstrations to customers as required Organize and attend workshops, walk-throughs, and reviews Contribute to feasibility studies, business cases, proposition development and bid collateral Support all levels of testing in line with company processes and standards including supporting the UAT test process and participating in testing as required Support the Implementation process including preparing the training materials, procedural manuals, user guides and release notes. Build and maintain positive professional relationships with internal and external clients 2. L&T InfoTech Ltd, Pune Oct 2014-Oct 2016 # Responsibilities: Working on SQL for daily activity like data upload, data correction, Performance tuning etc. Working on SSRS and SSIS. Working with Business owners for the process improvement and implement ITIL process in project for best practices. Strong knowledge of advance Microsoft Excel, Macros and Access in day to day activities. Carrying out analysis of the given data and draw correct inferences, keeping the objectives of the analysis in mind. Calculate the specified problem, state of affairs and crisis; examine for solution using data analytic practices and prepare analysis reports. Settle on the methodologies and procedures for carrying out effectual data analysis. Gather data from different sources necessary to accomplish analysis assemble it together in prearranged format and enter the data in several data analysis software. Understanding project requirements, collecting all requirements from users. Involved in Business Process Analysis, Develop & Implement Data mart.  Interacted with Business Users and Managers in gathering business requirements.  Analyze data processes to support the automation, efficiency and reporting. Interacted with the Business Users and the client to test according to their requirements. # Project 1 BPO Tools Description The objective of the project is to support and enhance new requirement of 300 BPO and legacy tools as well as the new tool request that came with the new ideas to fulfill the business requirements was to develop a document for any shop to fulfill all kinds of its requirements. Responsibilities: Working on SQL for uploading data, resolve the database issues. Working on different SQL queries to fulfill the client requirement. Understanding project requirements, collecting all requirements from users. Design and develop the application into the MS Excel, Access. Prepare the business document, SharePoint details. Explore the details on KANBAN board. Support the team at the time of development. Based upon requirement write the test cases. Provide internal training on tool ITIL, KANBAN. Prepare monthly report to show KANBAN effectiveness and Process improvement. Working on change management, incident management, and supplier management. 2. Tata Communications Ltd. Programmer, Pune April 2012-Oct 2014 # Responsibilities: Data Upload, data manipulation and monitoring in Sales Force tool. Access and prepare reports from Qlikview tool; Good command of Saleforce.com to develop reports, dashboards, and processes to continuously monitor data quality and integrity. Handling different data in SQL Server 2008 with all the concepts of RDMS. Strong knowledge of advance Microsoft Excel, Macros and Access in day to day activities. Carrying out analysis of the given data and draw correct inferences, keeping the objectives of the analysis in mind. Calculate the specified problem, state of affairs and crisis; examine for solution using data analytic practices and prepare analysis reports. Settle on the methodologies and procedures for carrying out effectual data analysis. Assisted the association in performing data compiling, mining and psychoanalysis required to assess the given data. Understanding project requirements, collecting all requirements from users. Involved in Business Process Analysis, Develop & Implement Data mart.  Interacted with Business Users and Managers in gathering business requirements.  Analyze data processes to support the automation, efficiency and reporting. Wrote complex views, functions and stored procedures using SQL, PL/SQL, to be used in Reports development.  Has been involve in manual testing i.e. creating test scenario ,test case and controlling test data for test cases. Exposure to SQL and preparing bug report. 3. Phoenix Microsystem Pune November 2011 – March 2012 # Project 1 Invoice & Quotation Bills Description The objective of the project was to develop a document for any shop to fulfill all kinds of its requirements. The product is fully customizable, suitable for all kinds of shops. The product contains modules for Manufacturing, Labeling (Barcode), Sales, Purchase, Labor transaction, Accounts, and Backup - Restore etc Responsibilities: Design database schema, Performance tuning database indexes, stored procedures, user-defined functions, and views. Design and develop software using VB.NET, VB6.0, Crystal Report, SQL Server, Data Reports, and ASP etc. Responsible for three tier architecture system. Development, deployment, and maintenance of the companies of software. Interaction with clients to understand their business requirements and appropriately model a solution for software implementation. 4. Defense Research and Development Organization [DRDO] Pune Jan 2011- May 2011 # Project 1 Movement Order system Description The objective of the project was to develop a document and full journey details will be captured for the reimbursement Process. System provides very easy way to maintain and update traveling information & expenditure. Users of this system (Employees of DRDO) can update their traveling details and can also get permission for trip from head authorities. Responsibilities: Design database schema, Performance tuning database indexes, stored procedures, user-defined functions, and views. Design and develop software using VB.NET, VB6.0, Crystal Report, SQL Server, Data Reports, and ASP etc. Responsible for three tier architecture system. ACADEMICS MCA (Computer Application) from North Maharashtra University, Jalgaon with 59.52 % in 2011. BSc (computer Science) from North Maharashtra University, Jalgaon with 61.51 % in 2008. HSC from Nasik Board, Jalgaon with 51.17 % in 2005. SSC from Nasik Board, Jalgaon with 71.15 % in 2002. PERSONAL DETAILS Date of Birth: 13th February, 1987 Current Address:FLAT NO 5, Building no 35,Mittal society ,Vishrantwadi, PUNE 411015 Permanent Address:Dhannai, Plot No.24/561,Anurag State Bank Colony,Jalgaon 425002 Languages Known:English, Hindi, Marathi.