Hemant Petkar

Experience

• 

  Rohan Software Pvt. Ltd.

  Jan 1997 - Aug 1999

  Senior Technical Executive

  • Design and develop Control Plan/Validation checks, using PL/SQL stored procedures • Create UNIX Shell scripts and SQL*Loader control scripts to automate processes.• Contribute in creating data model and database design using Designer 2000.• Create design specifications based on functional specifications.• Analyze data flow requirements and develop architecture for exchanging data and translate business rules and functional requirements into PL/SQL procedures and functions.• Design and develop Oracle PL/SQL stored packages, procedures, functions and database triggers and tables, global temporary tables, synonyms, sequences, and views to implement business logic.• Work with Middle Management for requirements analysis and develop functional/technical specifications.• Handle data quality and data mapping issues, performance tuning, validating data, troubleshooting and providing corrective solutions with a strong customer focus. Show less

• 

  3i Infotech Ltd.

  Sept 1999 - Nov 2005

  Senior Technical Associate

  • Translate business rules and functional requirements into ETL procedures.• Contribute in creating data model and database design using ERWin tool.• Design and develop PL/SQL stored packages, procedures and functions to implement business logic.• Document process flow and data mapping and convert functional requirements into design specification. • Work with Middle Management for requirements analysis and develop functional/technical specifications.• Handle data quality and data mapping issues, performance tuning, validating data, troubleshooting and providing corrective solutions with a strong customer focus.• Interact with business users to capture user requirements, perform data analysis and data mapping.• Create test scenarios and assist users in UAT environments.• Provide training and customer support for application and database related issues.• Proactive database monitoring and maintenance to locate and prevent future problems.• Microsoft IIS installation and configuration• DBA Activities like Data Migration, Data Maintenance, Backup and Recovery, Tuning, etc.• Interacting with and Supporting users all over India Show less

• 

  CMC Ltd.

  Mar 2006 - Apr 2007

  Senior Software Engineer

  • Organize training and knowledge sharing sessions for knowledge management and learning culture in team.• Coordinating with the team members on sites and off sites for timely execution of the project deliverable and within quality goals.• Analysis of the existing system and the overall domain as per new trends in market.• Recommends product enhancements and desirable changes in the system.• Impact study of the change request, designing, analyzing, documentation and approval of the same.• Document process flows and data mappings and functional specifications.• Encourage the team to expand their technical and domain knowledge and area of influence• Interacting with the clients to understand their requirements and giving constructive feedback to them.• Implementing the System at the Client Site with the necessary setup structures, scripts and functions along with Operating System and Oracle database installation & setup• Liaise with senior managers for recruitment, issue management, billings and future contracts, etc.• Generate reports/provide data to senior management as and when required.• Team Management and Resource tracking and allocations.• Project Delivery & innovation of deliverable within the scope of the project.• Managing DBA Activities like Data Migration, Data Maintenance, Backup and Recovery, Tuning, etc. Show less

• 

  Tech Mahindra

  Apr 2007 - Sept 2009

  Senior Technical Associate / Team Lead

  • Participation in Group Discussion with a number of teams to resolve a particular issue or defect in real time on Group Calls. The issue may concern with Solution Design, Infrastructure, Development or Implementation Defect, Invalid process, or Flow, Testing, etc.• Participation in OR R1000 Open House which involved the testing of above 1500 test scenarios and cases over a period of 2 weeks.• Understand the functionality and the interconnectivity of the various systems like Flow Products, Geneva, BAL, Openreach systems.• Ensure zero or near zero defect or issue attributable to the Issues.• Interact with the various groups and teams on telephonic calls, emails and face to face in order to resolve a particular issue or defect carry it out to resolution with RCA in real time.• Update the HP Quality Center Application with the necessary comments and RCA for the raised issues and defects and to assign the issue or defects to the respective team or person for further processing. Show less

• 

  IBM India Ltd.

  Feb 2010 - Nov 2011

  Senior Data Migration Consultant & DBA

  • Database Monitoring, Management & Tuning Activities in real time.• Trial Backup and Restoration of Database to prepare for any contingencies and to prepare detailed documentation of the steps involved.• PL/SQL Query Tuning and optimization for faster execution for collecting data from source and target• Migrated Data Reconciliation and interacting with the client to analyze the mismatched data.• Coordinating and Managing the Mahindra Satyam and MTNL Team to complete the Reconciliation work and iron out the issues.• Resolving clients issues in front end like SIngleview & Peoplesoft applications systems.• ETL activities of source database and replicating it on test server for reconciliation activities.• Reports generations of the daily & weekly activities and liaise with the senior managements.• Manage the Veritas Netbackup setup by creating the necessary policies for DBs and File Systems.• Creating of new policies, update of existing policies, creation of new client server, media server in Veritas Netbackup Master Server setup• Checking the Veritas Netbackup status along with analysis of any incidents and rectifying the same. In some cases interact with the Symantec team to resolve the incidents in real time. Show less

• 

  The Cold Hub

  Jan 2012 - Oct 2014

  Proprietor

  The Cold Hub is my proprietary family business of being the distributor and seller for ice-creams and other beverages that I launched 2 years back and I am primarily managing on an ongoing basis. Responsibilities: • Handling all marketing and advertising budgets• Responsible for all aspects of in-store employment (hiring, training, coaching and termination)• Managing day to day operational activities of store.• Securing government business license and other legal activities.• Administrating sales books and registers, tracking purchases, VAT and other formalities.• Designing all marketing and advertising strategies • Partnering with product manufacturers for managing inventory of stock.• Managing customer relationships for delivering orders on time.• Maintaining contracts with the assets manufacturers for maintenance of the assets and machines Show less