Deepak Kulkarni
Green Card
*********@*****.***
PROFESSIONAL SUMMARY:
• Since last 15 + years managing Software Quality Assurance in US.
• Possess proven Communication, management & leadership skills.
• Experience in managing multiple testing teams working under Onsite-Offshore model.
• People management with 20+ resources along with Vendor Management
• Managed multiple projects located across distributed geographical Locations.
• Ability to work against extremely tight deadlines.
• Well organized, self-motivated, proactive, process and result oriented.
• Self-starter who can work independently or with a variety of IT partners.
• Extensive experience in driving Automation, resource allocation, test strategies, Test plan.
• Exposure to web-based app testing, Mobile App testing for both iOS and Android o/s.
• GUI testing, functional, integration, regression and end to end testing.
• Vigorously worked on forecast deadlines and budgets for future projects.
• Good knowledge of MS Project and MS Office.
• Extensive exposure to CMM Levels and ISO Quality Processes.
• Rich experience on Automation frameworks having different platforms
• Extensively worked on Testing of ERP, Healthcare, Financial products, Retail
• Attend and host project track status meetings, host QA meetings, Triage meeting
• Identify project risks and work with PMO to assess, and respond to the identified issues. TECHNICAL SUMMARY:
Dev Platform Java, .Net, C++, VC++, Oracle Forms, Pega, Informatica Scripting Languages TSL, SQA Basic, Java Script, Python and VB Script Operating Systems Unix / Linux / HPUX, Windows 98 / NT / 2000 / XP, Citrix Oracle RDBMS 7/8/8i,9, DB2, SQL Server and MS-Access Application Servers Web logic 6.0, Web Sphere Server, Tomcat and IIS Testing Tools WinRunner, Load Runner, QTP.
Defect Tracking Tool Rational Clear Quest, PVCS Tracker, Bugzilla, QC Configuration Tools Rational Clear Case LT, VSS
Tools IBM Web Sphere, Toad, DBArtisan, Truesite, MS Office. CERTIFICATION
Riversand Product Information Management (PIM) Certified PBM – Specialty Pharmacy – Medco Certification
Pharmacy Benefit Management - Medco Certification
HealthCare - Medco Certification
Education: M.S. Computer Science, B.S. Engineering. EXPERIENCE:
Client: Infosys NYC, NY 2019 to Till Date
Role: QA Lead/Manager/UAT Lead
Managed 5 projects in Retail - Williams – Sonoma (WSI/WSGC), Buy Low/Choices Market, Tiffany, Ascensia and Johnson Control.
WSI/WSGC: Presently working on WSI project. WSI wanted to migrate from their existing legacy system to Riversand Product Information Management (PIM). I’m looking after the QA activities for this project.
Buy Low/Choices Market: BuyLow is a chain of retail grocery stores in Canada. They wanted to launch their ECOMM website. I was managing QA efforts for ECOMM (Local Organic Grocery Store Choices Markets). I was Accountable for end to end execution - validating xml with json file using swagger and then checking the details in storefront
Tiffany: a market leader in luxury goods, particularly diamond and Jewelry all over the world. Here I worked as a BI ETL QA Lead. Tiffany wanted to move to cloud. For this Tiffany wanted to test BI reports when database was migrated to cloud. Also managed multiple small projects simultaneously.
Ascensia: is having chain of hospitals all across America and many other countries. Ascensia is mainly in to Diabetic care. Ascensia wanted to launch mobile app “Abound
(https://play.google.com/store/apps/details?id=com.ascensia.abound.us&hl=en_US ) “ for both iOS as well as Android operating systems. I was looking after QA activity for this Abound App. Done lot of API testing since this App was interfacing lot many 3rd party applications such as Acuity (For Appointments), Twilio (For Communications), Shippo (Carrier), NetSuite (CRM), etc. Managed End to End testing for Abound App.
Johnson control: are in to Government contracts. Contracts for HVAC, Securities, etc. They wanted to implement new payroll application CP-PW (Certified Payroll – Prevailing Wage) for their different types of employees/contractors. They wanted to conduct End to END UAT for this Payroll system which involves multiple other systems. I was leading this whole End-to-End UAT exercise for CP-PW for all 50 States having different complex rules for Federal, State and Counties. Co-ordination among different Business Teams such as – Contracts (NxGen and CBS), Timesheet (NxGen and Kronos), HR Benefits (Workday, Alight and Mercer), E-Sign, PWCOE, etc. Responsibilities:
• Initiate/ Kick off and Project Closure
• Co-ordination amongst different teams: Dev, Infra, Admin, Architect, DBA and Network
• Manage and Administer UAT activities.
• UAT Plan and Strategy preparation
• Build and deliver UAT project status reports and metrics.
• Created project schedules considering associated dependencies and constraints.
• Involved in risk identification, impact analysis and mitigation/ contingency planning.
• Test Data analysis
• Delivery and management of the project within defined schedule and budget
• Jira Set Up. Trained Business user for Jira
• Co-ordinate for UAT Environment set up
• Write, Execute Test Script and defect management for Mobile App
• Host QA and Triage meetings
• API testing
• Project estimation and effort estimation
• Coordinate weekly estimation meetings to provide Story Points for backlog items
• worked with product owners to grooming and plan sprints
• Participation in data governance and analysis workshops
• identifying and analyzing data patterns
• validation of defined business rules for data conversion
• Participation in technical discussions related to EDW, EDH (AWS) environment data flow design and strategy
Environment: Jira, ALM, Java, Siebel, Oracle, Postman, GITHUB, Trello, SQL, Azure, Mendix, iOS, Android, SAP, Manhattan, AWS, SQL Developer, Informatica, Tibco Designer, Json Client: NYC State Gov/ Spruce Technology, NY 2018 to 2019 Role: QA Lead
NYC DOB (Department of Building) wanted to test their different applications such as Boilers, Cranes, etc. Overlooking QA activities for following for Cranes starting from Prototype – New Amendments, supplement. Crane Device – New, different types of Amendments and Supplement and Crane Notice and End to End testing starting from New Prototype to Crane Notice for both CRM as well Portal.
Responsibilities:
• Create test scenarios from BRD’s having complex rules & calculations.
• Worked closely with Dev Team, System Admin, Architect, DBA and Network Admin.
• Manage and Administer QA activities.
• Build and deliver QA project status reports and metrics.
• RCA of defects – Coding, communication, miss interpretation.
• Created project schedules considering associated dependencies and constraints.
• Involved in risk identification, impact analysis and mitigation/ contingency planning.
• Key strategist for all aspects of QA (Test Plan, QA Sign-offs and UAT).
• Successfully delivered weekly, monthly & quarterly releases.
• Monitored and reviewed defect management and defect lifecycle using TFS.
• Decide scope of testing, entry & exit criteria.
Environment: Microsoft CRM, .Net, SQL, TFS, Salesforce. Client: Pure Insurance/ Qualities, White Plains, NY 2017 to 2018 Role: QA Manager
Pure Insurance mainly deals in niche insurance market. I was managing 2 projects in Agile methodology at Pure Docgen forms conversion and Dragon. Pure wanted to test their Insurance forms as per federal and state guidelines for all 50 states for various LOBs such as Auto, Home, Collection, Excess, etc. and Dragon where Pure application talk to Liberty Mutual another Insurance Companies.
Responsibilities:
• Manage, plan and administer QA activities.
• Prioritize individual and team tasks and projects so that deadlines are met.
• Co-Ordinate among different teams - System Admin, Architect, DBA and Network Admin.
• Escalate issues to higher management.
• Build and deliver QA project status reports and metrics.
• RCA of defects – Coding, communication, miss interpretation.
• Created project schedules considering associated dependencies and constraints.
• Involved in risk identification, impact analysis and mitigation/ contingency planning.
• Prepare Test Plan, Test Strategy
• Ensures proper test coverage exists based on requirements and design specifications
• Successfully delivered weekly, monthly & quarterly releases
• Monitored and reviewed defect management and defect lifecycle using Rally.
• Decide scope of testing, entry & exit criteria
• Decide & monitor the project estimation
Environment: Rally, AppliTool, InetPDF-C, Selenium, Oracle, Java. Client: Amica Insurance/ Teksystems. Lincoln, RI 2015 to 2017 Role: QA Manager
While working for Amica Insurance managing testing of 2 projects Teradata and Parser. Amica was discarding their old Mainframe Systems Core, Datamart to Teradata and Legacy System to Policy, Claim Center and Billing Center. Main goal of testing was to make sure that migration
(etl) from old system to the new one happens correctly using Agile/Waterfall/KanBan methodologies. Done data validation in different phases Acquisition, Standardize/Integrate, Post Process and Final Teradata Data Warehouse.
Responsibilities:
• Initiated Data Validation Practices at Amica.
• Did presentation to client how we are going to implement Data Validation practices at Amica.
• Was managing a team of 6 testers.
• Was managing various phases of Migration - initiation, planning, execution, and closure.
• Single point of contact for Data Validation at Amica.
• Successfully created macros for automating the data validation.
• Review of offshore deliverables - DSR, WSR, Test Plan and TSR.
• Understand T2S documents.
• Prioritize testing efforts looking at the time and resource constrain so that deadlines are met
• Host/coordinate QA meetings, triage meetings, Prepare mitigation plan.
• Ensures proper test coverage exists based on requirements and design specifications.
• Identify and communicate project risks, if required escalate issues to higher management.
• Worked closely with various teams Offshore, Development, Network Admin, and DBA. Environment: ALM 12.50, CQ 8.0.1.7, Windows, Teradata 15.00, QMF, SQL Server 2014, Informatica, Data stage, QMF, Rumba, SAS
Client: CITI Bank/ Infosys. NYC, NY 2012 to 2015
Role: UAT Lead
While working for CITI bank worked on their Retail and Invest banking products LRR, FBB, Genesis, etc. LRR was a Testing Customer Account, ETL Data, reporting as per RBI norms. Genesis was Citi’s Investment banking project for Trading - How Securities, Stocks, Bonds are traded in Capital Market (Primary and Secondary Market) and their work flow, ACH batch processing, FBB Data Acquisition
Responsibilities:
• Was managing 4 teams.
• Single point of contact between Citi and Citi’s internal Clients.
• Review of offshore deliverables - Test execution report, DSR, WSR, Test Plan, TSR,
• Host/coordinate QA meetings, triage meetings, Prepare mitigation plan.
• Ensures proper test coverage exists based on requirements and design specifications.
• Prioritize individual and team tasks and projects so that deadlines are met.
• Identify and communicate project risks, if required escalate issues to higher management.
• Worked closely with various teams Offshore, Development, Network Admin, and DBA. Environment: Quality Center, Windows, Java, Sitescope, SQL Developer, Toad Client: Cognizant Technology 2010 to 2012
Role: QA Lead
Cognizant is global IT and business process outsourcing services provider. While working at Cognizant worked for different clients such as
Proag – Crop Insurance managed Proag’s products such as Combo, for corporate accounting account payable, loss details, policy details for both SIT as well as UAT. Medco/Express Script (ESI) - Healthcare, was managing QAing of Medco’s IVR and Mobile Apps products for Usability, Compatibility, etc. developed in agile methodology. Johnson and Johnson (JnJ) – Healthcare, was working as a BA/QA on JnJ’s Informatica products. Worked on validation testing for WMS systems at JnJ Responsibilities:
• Was managing various phases of projects such as initiation, planning, execution, and closure.
• Developing test strategy, Project scope, Project estimates.
• Resource Management - Negotiations regarding team ramp up, ramp down, SOW, etc.
• Single point of contact between Cognizant and Client.
• Review of offshore deliverables - Test execution report, DSR, WSR, Test Plan, TSR,
• Interface with business and technology teams to capture requirements.
• Host/coordinate QA meetings, triage meetings, Prepare mitigation plan.
• Worked closely with various teams - Offshore, Development, Network Admin, and DBA.
• Was involved in interviewing and hiring QA staff.
• Provide cross-project information, resourcing requests and release scheduling input
• While testing Medco’s IVR system 1. Read complex data/call flow diagrams – entering from, wording, Grammar, Expressions 2. Actions – options, conditions, transition. 3. Recovery Behavior – Type, condition, actions, transition. 4. Global commands, special conditions for Legacy refill
• Worked on Metadata (Informatica) in Johnson and Johnson (JnJ). Worked as a BA/QA in JnJ
• While testing JnJ’s WMS verified following – 1. annual/regular stocktaking online or offline, for batch or serial numbers 2. Verified zone and bins to match your warehouse layout, display locations
3. Verified Dispatch single/multiple picks and branch transfers, automatically adjust inventory and integrate with shipping solutions 4. Verified double-selling and stockouts, and sync stock levels with websites and marketplaces 5. Shelf life, LIFO, FIFO, etc. Environment: Quality Center (ALM), Jira, Oracle, Windows, Informatica, Pega, Bigdata Client: Capital One Bank. Richmond, VA 2008 to 2009 Role: Project Lead
Capital One Bank wanted to test their retail banking products for fund transfers end to end. Worked on Cap1 products such as Insite, Towernet, Citrix, etc. As per federal regulation they wanted to test their product for disaster recovery. It was a data warehouse project includes testing of various applications.
Responsibilities:
• Project initiation; keep track of progress of the project, Co-Ordinate among different teams.
• Worked closely with System Admin, Architect, DBA and Network Admin.
• Testing in a controlled environment before the code migration (Cycle Release) and repeat after every code migration to monitor performance between releases.
• Manage, plan and administer QA activities during all test-related project phases.
• Build and deliver QA project status reports and metrics.
• Created project schedules while identifying associated dependencies and constraints.
• Involved in risk identification, impact analysis and mitigation/ contingency planning.
• Tested Cap one’s funds transfers application.
• Vigorously worked on Configuration of Jira, Capturing user stories, issues in Jira for Agile Methodology.
Environment: Windows, Mainframe DB2, Jira, Loadrunner. Client: J.P. Morgan Chase (JPMC). NYC, NY 2007 to 2008 Role: Project Lead.
JPMC wanted to test their Investment Banking Products for front, middle & back office. Such as Reports (FX Delta, FX Vega Report, etc.), Endur Batch Feeds, etc. Worked on JPMC’s applications Athena, Nike, Endure (Risk Management), Openlink, etc. for Capital Market - Trade, Stocks, Securities, Bonds, etc. Compare the new system Athena with existing Murex. Basically, this was migration project requires data mining and to check the performance of the applications.
Responsibilities:
• Prepare weekly status report & metrics.
• Key strategist for all aspects of QA (Test Plan, QA Sign-offs and UAT).
• Successfully delivered monthly & quarterly releases.
• Resource Management - Negotiations regarding team ramp up, ramp down, etc.
• Established all benchmarking/ Performance measurement for web applications.
• Monitored and reviewed defect management and defect lifecycle
• Decide scope of testing, entry & exit criteria.
• Decide & monitor the project estimation, project schedule. Environment: Python, SQL Developer, Java, UNIX, QC. Client: Rent a Center (RAC). Plano, TX 2006 to 2007 Role: QA Lead
Rent a Center is a huge retail chain that rent household furniture items to people. Rent a Center wanted to test performance of their Time Keeping applications, Pencil which also gives input to Rent a Center’s Payroll system. Also worked on their E-commerce application and in house developed Mach5 application for supply chain (from warehouse to point of sale). Where POS terminals directly linked to store warehouse and store warehouse to company’s central database. Here we tested functions such as FIFO, availability of inventory in nearby other stores if not in nearby stores then in central stores, discounts for loyal customers, outstanding payments, etc.
Responsibilities:
• Analyzed business requirements, wrote and implemented the Test Plan, Test cases according to functional documents and requirements.
• Used Data Driven Testing methodology to test the application with multiple sets of data.
• Performed Back End Testing and wrote queries to retrieve relevant data.
• Coordinated with network and application development teams and prepared application performance issues
• Tested RAC’s E- business application for usability. Environment: SAP R/3, HP-QC, Windows, SAP GUI & SAP WEB protocols, MM. Patni Computers/ Cap Gemini, Boston, MA 2004 to 2006 Role: Project Lead
Cap Gemini is a leading global IT services provider company with offices located in US, Europe and India. While working at Cap Gemini worked on retail banking products such credit cards, account transfer, etc. from SIT perceptive. Westlaw Thompson - Worked E-commerce applications on US Law which provides services to lawyers, attorneys regarding history of cases, their outcome, US Law, citations, etc. GE – Commercial Finance for Commercial vehicles, their mileage, and time and Gas required for a trip, etc. Responsibilities:
• Was leading testing teams at on-site and offshore within N.A. and India.
• Prepared and updated Test Scenarios and cases, Test plan and Test results for SIT and UAT
• Written SQL queries for data validation, regression and end-to-end testing
• Closely working with Business Analysts and Development team in completing the testing of business applications.
• Worked in all phases of testing life cycle - requirements gathering, project planning, Test Cycle planning, scheduling, Test case writing, testing, defect tracking, management, and reporting.
• Test Automation using QTP
Environment: Test Director, Linux, Oracle, Windows, Sitescope, QTP, Loadrunner