Wanda Larangeira
San Francisco,CA
Summary
Detail-oriented Computer Systems Analyst with over 15 years of experience in software quality assurance and a proven track record in developing test specifications, use cases, and test scripts. Skilled in executing manual test cases, tracking defects, and ensuring alignment between technology solutions and business objectives through effective stakeholder collaboration.
Proficient in creating and managing test plans, conducting requirements analysis, and leveraging core competencies in SQL, PL/SQL, MySQL, Core Java, and DB2. Adept at optimizing system design, performing data analysis, and managing network security to drive organizational efficiency.
A highly motivated professional with a strong work ethic, exceptional interpersonal skills, and the ability to thrive in dynamic environments. Known for quickly mastering new tools and technologies, working independently with minimal supervision, and delivering high-quality results in complex projects. Recognized for problem-solving, effective teamwork, and clear communication, ensuring successful project delivery and continuous improvement of organizational processes.
Overview
35
35
years of professional experience
Work History
Information Systems Programmer/Analyst III
Contra Costa Public Works, Martinez
Martinez, CA
08.2016 - Current
- Provided comprehensive maintenance of WebLogic Oracle legacy applications, leveraging Oracle 12c/19c databases, SQL Developer, PL/SQL programming, and additional database platforms (SQL Server, MySQL) to ensure optimal performance of public works operations.
- Applied advanced programming techniques for system conversion and rewriting programs, documented development stages, logic, coding practices and corrections.
- Executed WebLogic Server 12c implementation, system design, and configuration in Windows environment to ensure system functionality.
- Completed the initial phase of enterprise modernization by migrating Oracle Forms and Reports from 6i into 11g, successfully establishing foundation for future upgrades.
- Maintained mission-critical database systems across Oracle 12c/19c, SQL Server, and MySQL platforms supporting public works operations
Staff Programmer Analyst Specialist
Office of Systems Integration (OSI)
Sacramento, USA
09.2014 - 07.2016
- Led migration of enterprise Oracle Forms and Reports from 11g to 12c, including WebLogic Server implementation in Windows environment.
- Researched emerging technologies that could be used to improve current systems.
- Reviewed and modified unit and integration tests to improve software quality and reliability.
- Established and executed program development plans detailing steps and schedules.
- Created reusable programming libraries to support multi-project integration and rapid iterative development.
- Executed scripts to communicate with back-end servers and provide real-time updates.
- Offered proactive documentation of original code to support sustainability and adoption of products.
- Participated in code reviews to maintain high development standards.
- Continuously researched and implemented new technologies to maximize development efficiency.
- Monitored application performance metrics and implemented optimizations.
- Developed, documented and revised system design procedures and quality standards.
- Tested, maintained and monitored computer programs and systems.
- Consulted with management to reach agreement on system principles.
- Reviewed and analyzed computer printouts and performance indicators to locate code problems and correct errors.
Programmer Analyst
Board of Equalization
05.2011 - 09.2014
- Worked on development activities, analyzing complex business and systems requirements, databases structure and overall system architecture to provide innovative solutions and proper documentation, in support of enterprise's efforts to develop new ETL processes for data transformation and movement across different platforms, creation of data warehouse for BI, and the expansion/improvement of BOE's online services
- Perform analysis, development, implementation in support of IT systems initiatives such as the CROS IT Environment Matrix which documented all architectural environments for current Extract and Load Parallel Initiatives at the Board of Equalization
- Establish and document upcoming ETL processes related to the Metadata Warehouse Initiative
- Delivered first BI- Data Warehouse web application tool using Visual Studio/ C# .NET framework, MSSQL, Server 2008 and SharePoint 2010
- Develop problem solutions using information technology methods; conduct feasibility studies; work on analysis and support of multifunction office systems; develop/implement Data Conversion tools using C#, .Net and Visual Studio 2010 such as CROS Dashboard Automation which provided in addition to the ETL processing itself, error log tracking information, ETL cost reporting and summary, to facilitate the ETL processing management
- Environment: z/OS IBM MAINFRAME, CICS, ADABAS, MSSQL Server 2008, FTP, UNIX, MSOffice and SharePoint 2010, Visual Studio 2010, Springsource STS, Java SE
Contractor - Mainframe Programmer - Accounts Receivable Services
Kaiser Permanente
Pleasanton, USA
01.2006 - 10.2006
- Work on the re-writing of their in-house Accounts Receivable and Billing Reporting System
- Complete analysis and pseudo coding, provided creation and execution of test cases, design, code, document and implement system's modules for process replacement
- Test plan/test case creation and management
- Reviewed coding to ensure standards set by Kaiser
- Prepared job status reports and record test results
- Debugged and tested the data
- Specialized in troubleshooting test issues, tracking and prioritizing defects
- Environment: MVS on IBM MAINFRAME, CICS, COBOL II, SAS, DB2, FTP, UNIX
Contractor - System Test Execution - Billing Services
SBC Communications, Inc
San Ramon, USA
02.2005 - 08.2005
- Submit and monitor automated system tests for approximately 3000 batch jobs per cycle
- Responsible for troubleshooting problems with environments, application issues, job scheduling tools, mainframe tools, communicating with other SBC departments and external vendors
- Estimated, coordinated and directed testing for multiple projects
- Reviewed coding to ensure standards set by SBC
- Created and maintenance of SBC test specifications, test cases/scripts/data
- Prepared work status reports to be presented at Daily Status Meetings
- Involved in debugging and testing the data integrity
IT Consultant
SCIF- Workers Compensation Ins. Fund
San Francisco, USA
04.2002 - 01.2004
- Worked on the re-writing of their in-house Claims Reporting System
- Completed analysis and pseudo coding, provided creation and execution of test cases to validate premium allocation, cash value, withdrawal, surrender, benefit calculations as applicable, according to system's segment
- Designed, coded, documented and implemented system's modules for process replacement
- Review of the coding to ensure standards set by SCIF
- Performed Unit testing using the test data given by SCIF
- Prepared job status reports to be sent to the client
- Established processes for maintenance of data quality and integrity
- Created documentation of program flow
- Environment: MVS on IBM MAINFRAME, IBM COBOL, CICS, COBOL II, DB2, VSAM, JCL, TSO/ISPF, FTP, QMF, XPEDITER, CHANGEMAN, FILEAID, VTAM, ISPF/PDF, JCL, SYNCSORT, File-AID, Abend-AID, Visio, MS Word, MS Excel, MS PowerPoint, MS Outlook, Win2K
Staff Technology Solutions - Dev. Services Brokerage Operations
Charles Schwab
San Francisco, USA
04.1997 - 11.2001
- Lead Mainframe Developer - MFTS Automated Daily Loading System Project
- Participated in the requirements review, test scripting, quality assurance testing (manual, black box) and implementation of enhancements to MFTS systems
- Worked on the analysis and development of ISPF application dialog system for daily production data extracts and loads of Schwab's multiple testing environments
- Mainframe Developer - Schwab Institutional 1099 Tax Reporting Project
- Coordinated and developed regulatory enhancements for the 1997 fiscal year translating regulatory requirements into functional/technical specifications and delivering code enhancements to 1099 system components
- Provided creation and execution of test case bed, coordinated the global testing procedures with technical team and delivered installation into production
- Communicated and coordinated data requirements and tasks with Project Coordinators and Technical Team, during the maintenance of queue projects crossing multiple business functions and application systems such Margin Accounts, Mutual Funds, BP&T and Customer Reporting
- Performed detailed documentation and structured coding of application system modules and assured production installation in timely matter
- Worked on new development of Corporate Offering implement of the Resource Broker System, designed to establish the communication between commonly used processes in the MVS environment such as CICS tasks and batch jobs and facilitate the location of the requested service, using Schwab-specific architectural standards, writing new CICS application, Cobol and DB2 APIs
- Environment: MVS/ESA/XA on IBM MAINFRAME, CICS, COBOL II, DB2, DATACOM, VSAM, JCL, TSO/ ISPF, FTP, QMF, XPEDITER, CHANGEMAN, FILEAID, NDM, MQ, ISPF/PDF, JCL, SYNCSORT, Visio, MS Office, Win2K
Mainframe Developer
Union Bank of California
San Francisco, USA
04.1990 - 01.1997
- Maintained a variety of systems such as Electronic Check Processing, General Ledger and Monetary Warehouse systems
- Involved in the Cash Flow Automation Project of existent General Ledger Legacy System to provide automation in producing the approved set of directives required by UBOC for Check Processing
- Involved in preparing Jobs and procedures for testing new COBOL programs using production data
- Involved in Design, Development, support & testing for regulatory compliance Ad-Hoc requests
- Prepared test data for unit Testing, Developed Test Plan and Test Procedures and online documentation to cover the functionality, features, and reliability
Education
Certificate in Program -
City College
Certificate in Design and DB2 Advanced Development -
University of San Francisco
San Francisco, CABachelor of Economics - Monetary/Fiscal Policies
Pontificia Universidade Catolica
Skills
- Z/OS IBM
- IBM-3090
- UNIX
- IBM 370
- MVS
- VMS
- IBM-AIX
- HP-UNIX
- WINDOWS NT
- OS/2
- CICS
- DB2
- ACCESS
- DATACOM
- ADABAS
- MS SQL Server 2012
- COBOLII
- SQL , PL/SQL, My/SQL
- C
- XML
- Javascript
- Visual Studio
- Laserfiche
- SharePoint 2010
- MS Office Suite
- Microsoft SQL Server Solutions for BI DW Environments
- Integration Services (SSIS)
- Analysis Services (SSAS)
- Reporting Services (SSRS)
- EASYTRIEVE
- QMF
- CLIST
- XPEDITER
- CHANGEMAN
- FILEAID
- TSO
- VSAM
- VTAM
- ISPF/PDF
- JCL
- Dyl 280 SYNCSORT
- IMS
- File-AID
- Abend-AID
- MQ Series
Personal Information
Work Permit: Authorized to work in the US for any employer
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Languages
Portuguese
Native language
Spanish
Intermediate (B1)
B1
Software
Database: Oracle, SQL, PL/SQL, DB2, My/SQL Programming & Scripting Languages: Cobol, SQL, PL/SQL, Javascript
Timeline
Information Systems Programmer/Analyst III
Contra Costa Public Works, Martinez
08.2016 - Current
Staff Programmer Analyst Specialist
Office of Systems Integration (OSI)
09.2014 - 07.2016
Programmer Analyst
Board of Equalization
05.2011 - 09.2014
Contractor - Mainframe Programmer - Accounts Receivable Services
Kaiser Permanente
01.2006 - 10.2006
Contractor - System Test Execution - Billing Services
SBC Communications, Inc
02.2005 - 08.2005
IT Consultant
SCIF- Workers Compensation Ins. Fund
04.2002 - 01.2004
Staff Technology Solutions - Dev. Services Brokerage Operations
Charles Schwab
04.1997 - 11.2001
Mainframe Developer
Union Bank of California
04.1990 - 01.1997
Certificate in Program -
City College
Certificate in Design and DB2 Advanced Development -
University of San Francisco
Bachelor of Economics - Monetary/Fiscal Policies
Pontificia Universidade Catolica
Similar Profiles
Kelly KalfsbeekKelly Kalfsbeek
Community & Media Relations Coordinator at Contra Costa County Public WorksCommunity & Media Relations Coordinator at Contra Costa County Public Works
Tiana KnightTiana Knight
LVN at Contra Costa County-MartinezLVN at Contra Costa County-Martinez
Sharronda WheatSharronda Wheat
Public Defender Investigator II at Office of the Public Defender, Contra Costa CountyPublic Defender Investigator II at Office of the Public Defender, Contra Costa County