Pinaki BASU
Franklin,ACT
Summary
Data professional with five years of experience designing, implementing, and optimizing data pipelines and architectures.
Proficient in data migration, modelling and cleansing and with a strong aptitude for transforming raw data into valuable insights.
Demonstrated ability to work collaboratively in cross-functional teams and consistently deliver high-quality results. Adept at problem-solving and adapting to new technologies and tools to drive data-driven decision-making processes.
Overview
23
23
years of professional experience
Work History
DATA MANAGER
LEIDOS
11.2022 - 05.2023
- Formulate data migration strategy
- Undertake an audit of existing data
- Test the system after the migration process
- Find and fix any outstanding faults or issues with migrated data
- Document the processes undertaken, any issues, and fixes that have been deployed
- Review management duties in place of managers
- Map and allocate tasks within projects and general departmental structures
- Helped the Verification and Validation team to test the data migration process
- Teaching and mentoring other junior team members in SQL Server and data migration.
DATA TEST ANALYST
DEPT OF HEALTH
03.2022 - 10.2022
- Writing complex SQL queries based on data mapping
- Executing the queries to find issues related to the data
- Demonstrating the query execution (testing process) to the client as a demo
- Gap analysis of data mapping documents prepared by the data analyst.
- Skilled at working independently and collaboratively in a team environment.
- Self-motivated, with a strong sense of personal responsibility.
- Proven ability to learn quickly and adapt to new situations.
- Worked well in a team setting, providing support and guidance.
- Worked effectively in fast-paced environments.
DATA MIGRATION LEAD
NHMRC
07.2020 - 01.2022
- Utilised SQL Queries to conduct validation of data migration from one system to another; undertook multiple levels of testing and reporting as part of migration process development
- Mediated among vendors, Business groups and NHMRC internal engineers in resolving issues
- Performed as a Business Analyst responsible for facilitating user requirement gathering workshop; ensured the NHMRC business group addressed the vendor queries
- Maintained communication with the internal and external stakeholders to ensure they were informed of the program's progress
- Performed related duties such as coordination of UAT (User Acceptance Testing), stakeholder management and project schedule management.
- Managed time efficiently in order to complete all tasks within deadlines.
TEST ENGINEER
TELSTRA
03.2020 - 06.2020
- Reviewed project-related documents such as requirements, specifications, and technical designs
- Created test cases to conduct the positive and negative testing of the application and interacted with the business analysts and developers to resolve the technical issues to meet the client's requirement for a better-quality software product
- Created and maintained test cases in the quality centre
- Participated in project-related meetings and provided the information required for the meetings regarding the QA and testing status
- 13
- Building reports, such as requirement traceability and test case execution status in HP ALM.
QUALITY ASSURANCE ENGINEER
NORTHROP GRUMMAN
06.2019 - 02.2020
- Analyzed system data and modified it accordingly for test data purposes
- Analyzed requirements and developed test plans, test scenarios, and test cases for cybersecurity analytics product (Huntsman) with built-in threat intelligence and behaviour anomaly detection
- I liaised with various business stakeholders and engineers, ensuring the testbed ran constantly
- Identified future risks and conveyed them to stakeholders with a mitigation plan
- Delivered infrastructure testing program for firewall (FortiGate and Juniper)
- Discussed requirements and processes with project managers and developers.
- Provided time-to-time guidance on the test process to the test manager and other project stakeholders
- Coordinated with partners to document and assess acceptance criteria for the COTS program.
TEST ENGINEER THALES
THALES AUSTRALIA
07.2018 - 06.2019
- Developed various documents, such as test plans and test reports to support test execution
- Involved in performing Development Test and Evaluation (DT&E) and Acceptance Test and Evaluation (AT&E)
- Managed schedule in case there were conflicting priorities
- Responsible for maintaining virtual test environments, ensuring that environments are customised according to the testing of applications
- Participated in regular meetings with upper management to communicate accomplishments, plans and issues and any risks to the project's progress.
DATA ANALYST AND TEST
DEPARTMENT OF JOBS
01.2018 - 07.2018
- Prepared an effective Test Plan document to Validate data transformations and perform End-to-End data validation for Enterprise Data Warehouse
- Prepared Test Cases and Test Scripts (SQL Scripts) as per given requirements
- Executed Test cases and logged defects for failed Test cases
- Participated in Defect Triage meetings, ensured Defects were correctly assigned, and tracked them to closure
- Engaged department representatives, Business Analysts and other key stakeholders in the use and delivery of data
- In addition to the above testing task, it also delivered a complete testing process working in iterative releases
- Successfully configured Microsoft Testing Foundation Server (TFS) and Microsoft Test Manager (MTM)
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Collaborated with business-unit leaders to identify and prioritize problems.
V&V LEad
FUJITSU AUSTRALIA
05.2016 - 01.2017
- Coordinated test strategy development, project planning, scheduling, allocation of test engineers to programs, ensuring test environment availability, generation of test reports, communication of test status, and networking to coordinate test activities
- Oversaw engagement with Fujitsu engineers and Prime System Integrator (PSI) in formulating correct System Specification and Design documentation
- Engaged client to remediate any risk or issues arising from our day-to-day deliverables
- These engagements are through formal or informal meetings with clients
- Maintained effective communication channels with internal stakeholders through test and defect reports and collaborated with PMs in providing project scheduling, and resource scheduling for all our capabilities
- Thus, we have been delivering our capabilities on time and high quality
- Ensured QA Test Team created test cases, plans, and scripts and executed tests using these techniques for identifying defects for corrective action
- Was responsible for creating effective reporting and analysis of identified defects for analysing where the defect occurred, how many areas impacted, how this impacts overall test coverage, and where the overall testing cycle stands relative to project schedule and time allocated
- Lead my team in developing proper risk assessment skills and identifying significant risks in a fast-paced environment
- Successfully managed, as PM capacity, for infrastructure work package
- The vastly improved integration of test engineers with Engineering teams resulted in a cohesive work environment
- Responsible for creating detailed project plans and work breakdown structure plans to illustrate resource allocation and scheduling tasks using MS Project
TEST ENGINEER
CHUBB
08.2014 - 02.2016
- Developed expert understanding of systems requirements to implement test strategies with greater efficiency
- Analysed complex software systems and liaised with stakeholders to ensure applications performed to specifications
- Tested hardware and software within sandbox environment prior to release to production.
- Ensured consistent successful implementation of test strategies
- Tested web-based applications across various devices and environments
- Identified software issues and reported at length for engineering teams to address
- Supported engineering teams in the development of device designs and concepts
- Developed accurate documentation relating to test methods, test reports, standard operating procedures and data collection
- Provided continual feedback and solutions for design team and supported them to complete goals in line with the company's targets.
TEST MANAGER
RMS
05.2011 - 07.2014
- I have successfully implemented the QA process for the Tolling system
- Improved and maintained programs and processes for quality
- Collaborated with cross-functional teams for identification and resolution of validation issues.
- Improved defect identification and remediation cycles
- Produced and maintained technical documentation for project reference.
- Implemented programs to identify and drive early test adoption and SDLC principles in all projects and validated functional requirements
- Proposed development and testing improvements to positively impact usability, function and performance.
- Facilitated workshops and similar forums where requirements and tool implementation were discussed
- Met tight deadlines to satisfy client demands and project timelines.
- Planed and developed quality test design and test cases that meet functional objectives Performed hands-on test planning, test execution and defect management for multiple workstreams
- Worked with business and development teams to understand product vision and requirements
- Drove expectations around quality for significant releases
- Was responsible for the development of test strategies and creation of appropriate test harnesses
- Set up target goals for team members and monitor the fulfilment of these goals
- Provided ongoing coaching, mentoring, and training for software testers in the department
- Ensured that direct reports met quality objectives.
TEST MANAGER
FAIRFAX BUSINESS MEDIA
03.2008 - 04.2011
- Built a cohesive test team who shared best practices and test responsibilities and supported reuse of test cases
- Increased test coverage and efficiency without increasing test engineer headcount
- Participated in regular meetings with upper management to communicate accomplishments, plans and issues and any risks to the project's progress
- Application Knowledge transfer from Subject Matter Experts) and Business Managers for the preparation of Test cases and Scenarios
- Provided project timelines, level of effort, detailed status reports, risk assessments and gap analysis to all project
- stakeholders
- Coordinated with off-site staff to verify correct use of test procedures and confirm accurate reporting.
- Negotiated test requirements and test strategies and served as liaison with internal customers and outside vendors
- Reviewed bug reports and error logs, translating data into digestible reports for senior leadership personnel.
- Provided Quality assurance on project deliverable releases based on the project schedule
- Updated ongoing testing procedures for software to account for changes resulting from post-release patches.
- Evaluated and proposed different Testing Tools, Utilities and Methodologies for testing
- Defined testing and acceptance strategies and determined quality assurance benchmarks.
- Focused on employee growth to give test engineers visibility and accountability for their work
- Maintained bug reporting system for logged faults, delegating issues to development personnel for remediation.
- Recognised by managers for the ability to get the most out of individuals.
- Documented testing procedures for developers and future testing use.
DATA ANALYST
Lion Nathan
02.2006 - 12.2007
- Develop end-to-end solutions requiring a transformation of complex data sets from multiple source systems, fix bugs, develop enhancements, address business queries and requests, and assist in data and integration tests
- Work as a hands-on, authentic and committed Data Engineer to support clients
- Take responsibility for all aspects of data engineering, from delivery planning, estimating and analysis to data architecture and pipeline design, delivery, and production implementation
- Provide technical thought to define data migration strategy and solution design using ETL (Extract-Transform-Load) methodology
- Ensure technical expectations of deliverables are met
- Communicate insights and recommendations effectively to the various stakeholders
- Monitor data management processes to ensure data quality and consistency
- Coach and develop a field to exceed customer expectations
- Contribute to the data dictionary, standards, training, and ongoing updates.
TEST TEAM LEAD
VODAFONE AUSTRALIA
04.2005 - 12.2006
- Managed and maintained shared test resources (test environment), which involved regular liaison with offshore vendors
- Led teams with various staffing models of internal and external onshore and offshore resources
- Provided leadership and supervisory oversight to quality assurance
- Worked with business analysts and technical team to define the necessary testing scope, including functional testing, integrations, reports, and impacts to systems
- Escalate any issues or blockers that arise during testing
- Checked software beyond testing scripts for interconnected problems not covered by established specifications.
- Completed tasks efficiently and promptly, reporting progress to managers, worked closely with Project Manager, continually seeking to improve testing processes.
- Incorporated delivery requirements into planning of testing schedules.
SENIOR TEST ANALYST
COMBANK
01.2003 - 01.2004
- Perform system concept formulation, system design analysis and subsystems design analysis
- Supports the analysis of business requirements by utilizing knowledge of business areas and Workflow applications for the portfolio supported
- Contribute to development and delivery of tactical and strategic QA plans and initiatives and manage governance
- Have input into the schedule and sequence of testing activities
- Provide test progress status/reports to QA Manager
- Collaborate with internal teams including (Development, Design, Business)
- Respond to user questions regarding system behavior and provide assistance during defect resolution.
TEST ANALYST
HCF
01.2000 - 10.2002
- Ensure systems, applications, and other devices are user-friendly by writing detailed test plans, test cases, and bug reports based on input from product
- Managers
- Study project specifications, gather/analyze data, and as well as establish test guidelines and timeframes in conjunction with other team members
- Assure requirements are met by application testing aspects, including functionality and usability
- Review code to identify errors and resolve issues related to system security and performance
- Offer feedback on software bugs, determine solutions, and execute code improvements
- Participate in scrum meetings to discuss project status and ensure applications meet user needs
- Update client data using CMS features, such as indexing and format management
- Maintain records of all procedures and adhere to best testing practices, SDLC methodologies, and industry regulations.
Education
Graduate Certificate - Project Management
Master of Information Technology - INFORMATION TECHNOLOGY
University of Western Sydney
Sydney, NSW11.1999
Graduate Certificate of Project Management - Project Management(PMBok)
University of South Australia
Sydney, NSW03.2005
Skills
- Testing Skills
- System Testing
- System Integration Testing (SIT)
- Database-related testing (ETL, Datawarehouse)
- User Acceptance Testing (UAT)
- Defect management
- Test artefacts related
- Test Strategy
- Test plan
- Traceability Matrix (such as VCRM)
- Test Coverage Analysis
- Test cases
- Test Summary reports
- Management skills Test Management
- Resource management
- Risk management
- Stakeholder management
- Testing Domain Client-Server application
- Database (ETL, Reports, Datawarehouse)
- Web-based application
- Soft Skills Formal & informal communication
- Problem / Conflict Resolution
- Analytical & logical reasoning
- Effective communication
Accomplishments
In NHRMC, developed automated testing using SQL Server Integration Services and PowerShell—implemented testing process, encompassing various testing levels and reporting.
Managed delivery of Verification and Validation program in EUC transformation project in Defense. Completed testing of the core infrastructure components ahead of schedule.
Timeline
DATA MANAGER
LEIDOS
11.2022 - 05.2023
DATA TEST ANALYST
DEPT OF HEALTH
03.2022 - 10.2022
DATA MIGRATION LEAD
NHMRC
07.2020 - 01.2022
TEST ENGINEER
TELSTRA
03.2020 - 06.2020
QUALITY ASSURANCE ENGINEER
NORTHROP GRUMMAN
06.2019 - 02.2020
TEST ENGINEER THALES
THALES AUSTRALIA
07.2018 - 06.2019
DATA ANALYST AND TEST
DEPARTMENT OF JOBS
01.2018 - 07.2018
V&V LEad
FUJITSU AUSTRALIA
05.2016 - 01.2017
TEST ENGINEER
CHUBB
08.2014 - 02.2016
TEST MANAGER
RMS
05.2011 - 07.2014
TEST MANAGER
FAIRFAX BUSINESS MEDIA
03.2008 - 04.2011
DATA ANALYST
Lion Nathan
02.2006 - 12.2007
TEST TEAM LEAD
VODAFONE AUSTRALIA
04.2005 - 12.2006
SENIOR TEST ANALYST
COMBANK
01.2003 - 01.2004
TEST ANALYST
HCF
01.2000 - 10.2002
Graduate Certificate - Project Management
Master of Information Technology - INFORMATION TECHNOLOGY
University of Western Sydney
Graduate Certificate of Project Management - Project Management(PMBok)
University of South Australia