Portfolio Management Program
Resume:
Sona Mehta
**********@*****.***
linkedin.com/in/sona-mehta-aa989646
Professional Summary:
Results-driven Program Analyst with over 10 years of diverse experience in manual and automated testing, program management, and federal government consulting.
Adept at overseeing IT and non-IT programs, facilitating CPIC processes, and analyzing program data to support strategic decision-making.
Experience in writing Python Scripts and UNIX Shell-Scripts
Experience using the workload automation tool Control-M for scheduling and managing batch processing jobs for data processing, ETL (Extract, Transform, Load), and report generation.
Utilized AWS Simple Queue Service (SQS) to send JSON payloads to Spring Boot application.
Performed Database Testing with SQL, Data warehouse Validations & ETL Testing.
Strong analytical skills with a proven track record in program oversight, portfolio management, and capital planning. Effective communicator with a robust ability to collaborate with cross-functional teams and stakeholders.
Active DHS/CBP clearance holder with extensive experience in Agile methodologies and a background in both technical and business analysis.
Education:
Bachelor of Science in Computer Information Systems DeVry University – Columbus, OH -1999
Diploma in Medical Laboratory Technology S.N.D.T. Women’s University – India -
Certifications:
American Software Testing Quality Board (ASTQB, ISTQB) Certified
CompTIA Network+, MTA Networking+, MTA (Windows Client Operating System), MTA (Windows Server Administration Fundamentals), MTA (Security Fundamentals)
Technical Skills:
Federal Government Consulting: Program/Portfolio Management, PMO Support, CPIC
Data Analysis & Reporting: Excel, PowerPoint, Word, IT Dashboard, OMB Reports
Technology Business Management (TBM): TBM Data Analysis, Portfolio Management
Testing Tools: Quality Center (ALM), Jira, TFS, Selenium, Cucumber, Postman, SOAPUI
API Testing: Postman, SOAPUI, Rest Assured
Automation Tools: Selenium, Cucumber, GitHub, Jenkins
Database Testing: SQL Queries, ETL Testing, Data Warehouse Validation
Cloud Platforms: Azure, AWS, Sauce Labs, Perfecto
Accessibility Testing: WCAG AA Compliance, JAWS, NVDA
Methodologies: Agile, Scrum, BDD, Dev
Professional Experience
Quality Analyst
Whole Point Systems (ICF) March 2022 – Present
Act as a CPIC Subject Matter Expert (SME) for Program Managers and PMOs, offering expert guidance on capital planning, investment control, and program management processes.
Review and provide feedback on program data and documentation, ensuring compliance with federal regulations and OMB guidelines.
Tested the ETL mappings from Source to Target.
Analyze OMB and agency monthly reports, including the IT Dashboard, to support portfolio management and strategic planning initiatives.
Experienced professional adept in data integration and software testing, with a strong focus on ETL (SSIS) development.
Facilitate portfolio reviews and program assessments, working with stakeholders to identify risks, opportunities, and actionable improvements.
Collect, analyze, and present program data to senior management, including the Chief Information Officer, for strategic decision-making.
Leveraged Python for creating automation scripts to perform API testing, data analysis, and generate test reports, integrating these scripts into the existing test frameworks to improve overall test execution speed and accuracy.
Conduct in-depth analysis of Technology Business Management (TBM) data to inform program evaluations and investment decisions.
Manage data analytics for program portfolios, supporting ad hoc requests and delivering insights for executive-level decision-making.
Collaborate with cross-functional teams to ensure alignment with program goals and federal requirements.
Designed and implemented ServiceNow workflows for ITSM and automation.
Created cross-functional diagrams to visualize end-to-end business processes and system integrations.
Key Achievements:
Spearheaded a comprehensive review of NCWDMS, resulting in a 15% improvement in reporting accuracy
Developed a robust framework for portfolio assessment that streamlined review processes and reduced review times by 25%.
Facilitated 3 portfolio reviews and program assessments, leading to risk mitigations.
QA Analyst Test Lead
NREMT October 2018 – February 2022
Led requirements gathering, test planning, and execution for Salesforce products and various web and mobile applications.
Validating staging database by writing SQL scripts to validate the databases tables for ETL testing and Reports data for backend database testing
Developed automation scripts using Selenium WebDriver, python for user management module.
Performed API level testing for web services, enhancing the test harness and developing test suites using XML and Python.
Conducted API testing for SAP projects, including smoke, regression, and UAT testing, while also managing sprints and test automation efforts.
Implemented Agile test practices and frameworks, including acceptance test automation using Cucumber and BDD methodologies.
Developed and maintained test automation scripts, utilizing tools such as Selenium, Postman, and Rest Assured for effective testing of applications.
Key Achievements:
Successfully established Agile test practices and acceptance test automation processes, enhancing the efficiency of CRM and Marketing project.
Designed and implemented a reusable test framework for eCommerce projects, improving test automation and coverage.
QA Analyst
Pearson October 2016 – October 2018
Designed test scenarios, created test cases, and performed functional and regression testing for web and mobile applications.
Proficient in extracting, cleaning, transforming, and loading data into final databases, employing a comprehensive understanding of ETL processes and best practices.
Conducted manual API testing and automated testing for web services using Postman, SOAPUI, and Rest Assured.
Participated in Agile sprint planning, daily standups, and retrospectives, ensuring alignment with project goals and deliverables.
Key Achievements:
Automated test scripts for Kentico CMS and BI projects, significantly improving test efficiency and coverage.
Enhanced accessibility testing practices, ensuring compliance with WCAG AA standards.
QA Analyst
TEKsystems March 2015 – October 2016
Developed and executed test cases for web applications, including IVR and utility client projects, using Selenium Grid and SOAPUI.
Automated testing using C# and Selenium, with a focus on ETL processes using Python and Java.
Participated in Agile ceremonies including sprint planning and retrospectives, contributing to team effectiveness and project success.
Key Achievements:
Created automated test cases for IVR and web outage applications, leading to improved testing coverage and defect identification.
Quality Testing Analyst
Sedgwick CMS May 2012 – December 2014
Developed and executed automated test scripts, maintained test environments, and performed SQL queries for front-end and back-end testing.
Write Python scripts to load data from different file formats for validation using Azure Data Bricks
Written several complex SQL queries for validating SSIS Reports
Coordinated defect tracking and reporting, ensuring thorough documentation and resolution of issues.
Key Achievements:
Developed complex testing scenarios and scripts that improved test coverage and defect tracking processes.
Software Testing Specialist
Hewlett-Packard February 2010 – April 2012
Developed test plans and managed test environments for DMV projects, collaborating with offshore teams and implementing testing methodologies.
Demonstrated expertise in writing Python scripts for data pipeline implementation, optimizing data storage, and ensuring secure processing in the cloud.
Key Achievements:
●Successfully transitioned from manual Excel-based testing to Quality Center, improving test management and defect tracking processes.
Quality Analyst
Care Works Technologies March 2009 – January 2010
●Supported legacy systems, performed UNIX scripting for test case creation, and managed software defect documentation.
Key Achievements:
●Created and maintained test cases and defect logs for legacy systems, contributing to the successful transition to new systems.
Contact this candidate