Pranavkumar Mukharjee

Pranav Mukharjee Contact: - Email:- Objective: My objective is to obtain a position in a professional office environment where my skills and education are valued and can benefit the organization. Summary: 3+ years of extensive experience in project delivery, Software Quality Assurance, Quality control and Configuration management. Strong working skills in QA methodologies like Software Design Life Cycle (SDLC), STLC and Agile Methodology. Involved in preparation of Test plans, created, maintained and executed Test Cases using Quality Center, created test reports based on the testing results. Gathered and reviewed business and functional requirements and created design documents (Use Cases). Extensive work experience in System Testing, User Acceptance testing UAT, Functionality Testing, GUI, Black Box Testing, Integration Testing, Positive Testing, Negative Testing and Regression Testing. 2+ years of experience in Business management, Sales, Customer Support and marketing. Duties Included conducting a detailed needs analysis with customers, reviewing the brand image, brainstorming ideas with planner, analyzing trade and products. Handle marketing activities and policies like promoting products and services, working experience with promotion and advertising. Good team player and possess ability to work individually without supervision. Technical Skills: Testing Tools Quality Center, Quick Test Pro, Rational Clear Web Technologies: HTML, DHTML, JavaScript, ASP.NET, XML, CSS. RDBMS: SQL Server 2005/2008, Oracle 10g, MS Access Reporting Tools: Test Director, Rational Clear Quest Operating System: Windows 98/2000/XP/Vista/7 Professional Experience Inception Engineering Services, Kathor (Surat), IndiaAugust 2017 – Till Date Marketing & Client Support Inception Engineering Services is growing business startup Company based in Kathor, District of Surat. The company’s prime focus is to give engineering solutions to mid and large size oil and Gas companies based in Surat, Baroda, Ahmedabad and Jamnagar. Inception provides services for Project Management, E & C Installation wire services. The motto is one stop solution for all electrical, mechanical and instrumentation work. Role: Marketing & Sales Support Responsibilities: Lead delivery team to provide maximum customer satisfaction according to client’s needs. Managing the cost of project and profitability. Was one of the prime contact for clients, vendors and other responsible person inside the Company. Meet various companies and their HR team in order to grow our business. Create media awareness via social platform like Facebook to drive sales. Follow up with sales lead and make sale from it. Provide regular and accurate status reports to clients as well as internal team managers. Oversee project planning, scheduling of employees on project and close out requirement. Responsible for manpower on board and their security training. Intaglio Consultancy Pvt Ltd, Mumbai, India January 2015 – June 2017 QA Analyst Intaglio Consultancy is growing managed technology provider of comprehensive technology solutions serving the US and Asia market. Our goal is to provide companies with integrated business technology services that will help increase their business productivity and reduce the costs associated with information technology. Intaglio has deep experience across systems integration, large scale custom application development, consulting, information architecture design and analysis, and business process services that increase performance and decrease the total cost of technology operations. Support and Working in testing field for company’s different products like calling card billing application, call center application and company’s website. Responsibilities: Analyzing the Requirements from the client. Participating in preparing Test Plans. Preparing Test Scenarios. Preparing Test Cases for module, integration and system testing. Preparing Test Data’s for the test cases. Preparing Test Environment to execute the test cases. Analyzing the Test Cases prepared by other team members. Executing the Test Cases. Defect Tracking and logging. Giving mandatory information of a defect to developers in order to fix it. Carry out testing as per the defined procedures. Participate in walkthroughs of testing procedures. Prepare all reports related to software testing carried out. Ensure that all tested related work is carried out as per the defined standards and procedures. Preparing Summary Reports. Preparing Suggestion Documents to improve the quality of the application. Communication with the Test Lead / Test Manager. Conducting Review Meetings within the Team. Environment: Quality Center, SQL server management studio, IBM Data Studio, SoapUi, MQ tool, Ms-Office, MS Visio. Florida Blue, Jacksonville, FL March 2013 – September 2014 QA Analyst More than 65 years ago, Blue Cross Blue Shield of North Dakota (BCBSND) began as two separate pre-paid health care plans for hospital and physician services. The two companies merged in 1986 and, in 1998, converted to a not-for-profit mutual insurance company. Part of the Blue Cross and Blue Shield Association, Florida Blue offers affordable health insurance to Individuals, Businesses, and Medicare Individuals. Was working on different internal and Vendor based projects such as Fulfillment, End to End Testing for user manuals, Healthcare.gov 2014, Florida Blue internal RBMS Testing, Data Conversion, Data Migration from in-house system to Vendor system, Testing different web based and mainframe services for new vendor system, Tested Mobile application for Viewbill. Responsibilities: Created UML Use cases out of BRD document prepared by the Business. Created Test Plan, that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required. Identified, built and executed Test Cases and Test Sets for Functional, Error Handling, Navigation and Regression in Test Director. Manually tested the entire application along with the junior testers before the tests were automated. Reviewed extensive SQL Queries with complex multi-table joins and nested queries. Involved in HIPAA/EDI Medical Claims Analysis, Design, Implementation and Documentation. Validated the reports and files according to HIPAA X12 enforced standards. Created test cases for Accounts, Activities, Opportunities, Contacts, and Plans. Performed validation testing on the application navigation for various scenarios and reported the errors. Running queries against databases to verify the correctness of XML response Document request/response XML's, test procedures and functional/technical findings from the test run Performed functional testing of the application through ALM. Created and maintained SQL Scripts to perform back-end testing on the oracle database. Assisted EDI team with the testing of maps for HIPAA transactions 835 and 837. Involved in testing maps and translated data. Performed Back End Testing by executing SQL queries on Window and Oracle platform. Verified the relationship between accounts, contacts, opportunities, and activities. Involved in the user acceptance testing (UAT). Manually tested all the interfaces. Tested for data in the database by writing SQL queries for SQL Server before testing the module. Involved in defect reporting and assigning the defects to development team through Mercury Quality center. Tested Application Name ‘View Bill’ on iPhone. Environment: Quality Center, RBMS, HTML, SQL Navigator, IBM Data Studio, SoapUi, MQ tool, Ms-Office, MS Visio, ios. LA QUINTA INNs & SUITES, W.Long Branch NJAPR 2012 – FEB 2013 Marketing & Sale Support LQ Management LLC is one of the largest operators of limited-service hotels in the United States, with over 80,000 rooms. Based in Dallas, Texas with 9,000 employees nationwide, La Quinta operates and provides franchise services to more than 800 hotels in the U.S., Canada and Mexico under La Quinta Inns and La Quinta Inns & Suites brands. Responsibilities: In charge of the budgeting and financial management, planning, organizing and directing of Hotel services. Meeting and greeting customers. Addressing problems and troubleshooting. Ensuring compliance with all licensing laws, health and safety and other statutory regulations. Carrying out reception duties or serving meals. Supervising, training & developing junior staff. Punctual with excellent time keeping. Doing everything with the hotel customers in mind. Education: Oracle DBA Certificate Course (NY, USA) -) SQL Server Certificate Course (NY, USA) (2013) Web Base Development Certificate Course (NY, USA) (2012) Master in Business Administration (CA,USA) -) Bachelor of Arts (Mumbai, India) (2006) 12th Class (Gujarat, India) (2003)