Software Developer Analyst
Resume:
******@****.***
SUMMARY
Software manager, designer and developer, experienced in creation of new applications and their support throughout life cycle. Established good reputation as a problem-solver, analyst and innovator while acting as a lead and team player. Skill set containing a system view and module knowledge has produced successful projects using many development environments. For the last 20+ years, I have been gaining a rich experience in the database arena which included Oracle, Sybase, DB2 and SQL Server. This experience ranges from database design, analysis and development to tuning of database queries, creating stored procedures, functions and triggers, tables, views and other objects. I have generated Oracle Forms and Reports, SSIS packages for ETL functionality, Crystal Reports and the use of MS Access and Excel to create reports. Underlying all of this development is the use of SQL, T-SQL and PL/SQL to retrieve, update and store data.
TECHNICAL SKILLS
Languages: Objective-C, C++, Delphi, Java, PL/SQL, ABAP, T-SQL, SQL, SSIS
Op Systems: NEXTSTEP, UNIX, Windows XP/NT/7/10, Oracle (PL/SQL, SAP, SAP BW), SQL Server 2017, Sybase, Business Object Enterprise, Excel VBA
PROFESSIONAL EXPERIENCE
Health Advocate (engage2Health), Westlake Village, CA
2014 – 2020
SQL Developer – Employee
System Design and Development
Design and develop SQL Server stored procedures for new projects
Generate documentation for defining projects and enhancements
Generate configuration files for new data streams
Generate translation records to convert data into standard formats
Develop SSIS packages to process data
Bank of America, Calabasas, CA
2014 – 2014
System Analyst – Contractor (Collabera)
System analyst
Develop SQL Server queries to analyze upgrades and enhancements to our data system
Determine backfill SQL from proposed business rules changes
Generate documentation for defining upgrades and enhancements
Act as liaison with users and developers
Bank of America, Westlake Village, CA
2013 – 2014
Data Analyst – Contractor (Collabera)
Business analyst and developer.
Develop MS Access queries and tables to determine eligible loans to process.
Analyze loan data in SQL Server database.
Generate reports using MS SQL Server 2008 queries and stored procedures, MS Access and MS Excel.
Generate reports for adhoc requests using MS SQL Server 2008 queries.
Develop SSIS packages to automate data processes
Generate documentation for recurring processes
Aera Energy, Ventura, CA
2013 - 2013
Information Specialist – Contractor (TEKsystems)
System analyst and developer.
Analyze field data gathering and data upload to corporate servers.
Generate operational data reports using SSRS and Access.
Update processes to be in conformance with corporate guidelines.
Working with Oracle and SQL Server databases using SQL, PL/SQL and T-SQL.
Analyze data structures in new database to determine relationships and usability.
Moda Health ( formerly ODS Companies), Portland, OR
2012 - 2013
Software Engineer: Reports – Employee
System analyst and developer.
Analyze functional document and generate technical document to define new report or updates to existing report.
Develop stored procedures/functions written with T-SQL on a Sybase database, using Facets tables, and reports using Crystal Reports (version XI R2) which are stored in Business Object Enterprise system. Designed and developed stored procedures in T-SQL to supply Crystal Reports with the required data.
Liaison with development and BSA teams to refine and clarify requested enhancements.
Lead or participate in internal and external reviews of tasks.
Analyze Facets database to determine the necessity of new views and materialized views.
Nike, Beaverton, OR
2011 - 2012
Information Systems Analyst – Contractor (Matrix Resources)
System analyst and developer.
Analyze legacy system to replicate functionality in new database systems.
Document findings in a functional specification document.
Analysis involved understanding of UNIX scripts, ProC and PL/SQL code.
Wells Fargo, Portland, OR
2010 - 2011
Oracle Reports Developer – Contractor (Robert Half)
Software analyst and developer. Develop and maintain Oracle Reports.
Design, document and develop Oracle Reports using Reports Builder 10g with embedded SQL code.
Generate table data in a DB2 database in support of the reports.
Gather, analyze and document requirements for reports from users.
ZIROUS, Portland, OR
2010 - 2010
Senior PL/SQL Developer – Contractor (Zirous)
Software analyst and developer. Develop database packages for various projects.
Design, document and develop PL/SQL packages running on Oracle 9i/10g for ETL functionality.
Create Use Cases to document designed packages
Create XML code from extracted database data
Parse XML code from application and update database
Document and develop BI ETL packages on OED Oracle 10g server.
HOLLYWOOD ENTERTAINMENT, Wilsonville, OR
2007 - 2009
Software Developer/Analysis – Employee/Contract (ProDX)
Software analyst and developer. Supporting corporate IS functionality by enhancing/correcting major systems.
Enhancing business systems using Delphi 6 and PL/SQL running on Oracle 9i.
Developed Stored Procedures to process EDI-850s (PO) and EDI-810s (Invoice).
Serving as a peer review/system tester for others in the group.
Supported company Data Mart for various management reports.
Studied Oracle 10g for impending system upgrade.
COUNTRYWIDE FINANCIAL, West Hills, CA
2006 - 2007
Software Developer/Analysis – Contractor (DMA Consulting)
Software analyst and developer. Creating periodic reports and on-line quick look capability for upper management.
Create periodic reports using SQL Server 2005, MS Access, Excel and PowerPoint. Reports present upper management with table data and graphical representation of company financial trend analysis for volume and risk.
Produced many Excel macros using VBA to import data, add calculated columns and format it for presentation.
Implemented many SSIS Packages in MS SQL Server 2005 to extract data from remote databases to populate our local database.
Designed and developed many stored procedures to process the SQL Server data into tables for the population of Excel worksheets.
MONSANTO (FORMERLY SEMINIS VEGETABLE SEEDS), Oxnard, CA
1998 – 2006
Software Developer/Analysis - Employee
Software architect, lead, analyst and developer. Function as a SAP analyst by gathering and documenting requirements, designing solutions, developing and integrating the chosen solution. Created major systems necessary to the management of company assets and products worldwide. Served as a technical bridge between the SAP and the Oracle systems within IT department.
Experienced with SAP ABAP Reports and Dialogs. SAP modules include MM, SD, FI and HR
Created SAP BW systems: data extractions, translation and loading (ETL) using infoObjects and infoSources into infoCubes and ODSs to gather data from many in-house systems for integrated reporting. Gathered master and transitional data into Star schema database.
Designed and developed the COVAR system by leading, designing and developing to manage the product description repository and life-cycle promotion system used worldwide by our breeders, sales force, product managers and others. The system is implemented using an Oracle database systems using Oracle 9i, PL/SQL packages, procedures and functions, with Oracle Forms and Reports and Excel on the web. Interfaced with end users to define upgrades and related requirements to development team. Created the functional specification to document the interrelationships of the database elements.
WESTERN DATA SYSTEMS, Calabasas, CA
1996 – 1998
Software Developer/Analysis - Employee
Oracle database software designer, analyst, developer and integrator. Technical lead for development team.
Designed, developed and integrated an Oracle 7.0 RDBMS-based contract management system as part of a team. Interfaced with users and management to create the functional specification from which the development team implemented the system.
Architected, designed and documented the Supply Chain Management System (SCMS) with two other leads, which was an expansion of CompassCONTRACT, the main WDS product. Technical lead with two others for a group of 30 software developers. Design was performed using Oracle Designer 2000 and the development using Oracle Developer 2000 (Forms and Reports).
Provided strategic, analytic, operational and tactical information toward the best design.
ADDITIONAL RELEVANT EXPERIENCE
ENGINEERING MANAGEMENT CONCEPTS, Camarillo, CA
Software Developer
Software designer, developer and integrator. Managed the enhancement and customer support of the US Navy NEXTSTEP SADS application developed while with ManTech.
MANTECH INTERNATIONAL, Oxnard, CA
Software Manager/Developer/Analyst
Managed development team, designed and developed mission-critical software and acted as liaison with the customer. Built and managed a team of developers and interfaced with the civil service personnel to deliver software system with necessary functionality ensuring the Mobile Sea Range (MSR) could perform their duties. Architected, designed, developed, implemented and served as customer support of the US Navy’s Strategic At-sea Display System (SADS) created to provide for safe open-ocean live fire naval operations.
EG&G WASHINGTON ANALYTICAL, Oxnard, CA
Software Developer
Software designer, developer, integrator, installer and trainer. Designed, developed, integrated and documented the Contract Automated Procurement System (CADS). Installed system and trained customer at their site on a periodic basis. Innovated a load-as-needed functionality to alleviate slowness of client hardware.
NORTHROP CORP. ELECTRONICS DIVISION, Hawthorne, CA
Unit Manager/Software Design Specialist
Managed the ATLAS Compiler Development Unit and ATLAS Documentation Unit. Design and developed software for testing. Managed the ATLAS System Software Development Unit to enhance and support the ATLAS test language for the PeaceKeeper Missile program hardware developers and manufacturers.
RAYTHEON CO. MISSILE SYSTEMS DIVISION, Oxnard, CA
Software Developer
System software designer and developer. Designed and developed many prototype and functional missile test station systems utilizing micro-processors and mini-computers in assembly and Fortran languages.
EDUCATION
MBA, Business, California Lutheran University, Thousand Oaks, CA
BA, Mathematics, University of LaVerne, Oxnard, CA
PROFESSIONAL DEVELOPMENT
Computer science courses, Ventura College and UC Santa Cruz
Oracle, Inc. (Java), SAP (ABAP and BW), NeXT, Inc (NeXTSTEP, Objective-C)
Contact this candidate