Robert See Email & Phone Number

Los Angeles, Ca, Us

Los Angeles Metropolitan Area

Came to Centene through WellCare acquisition in 2020.

Partner at Running Lady Studios, an animation film production company. Duties include Director of Photography and Production Designer.

Los Angeles Metropolitan Area

Came to WellCare through Universal American acquisition in 2018.

Houston, Texas Area

Universal American Medicare appeals and grievances management applicationHouston, TX Applications Developer/System AnalystAugust 2013 to January 2018 MS Access 2010, SQL Server, VBA, DAO, ADOBenefits: Mission-critical application under development on hard deadline stabilized and deployed.Assumed responsibility for troubleshooting and issues remediation of an Access 2010 application with atypical code base and data structures. Analyzed system to determine immediate corrective actions and implemented additional requirements to successfully meet launch date 27 days after start. Functioned as team lead, guiding analysis and development efforts. Engaged with multiple levels of development and management teams to facilitate quick yet robust issues resolution. Determined long term corrections and improvements, providing detailed analysis of existing logic and standardized approaches to management.

San Francisco Bay Area

MS Access 2007, MS Excel 2007, VBA, DAOBenefits: Improved annual processes, increased data integrity, unprecedented capability to handle irregular data. Analyze client data to determine optimal capture, storage and processing routines. Develop custom database application for benefits plan rate collection and processing using MS Access 2007. Develop data import processes which include structural validations and integrity analysis. Develop framework to handle irregular data using keywording. Facilitate data analysis and cleanup through data structures and user screens. Develop custom reporting interfaces which produce Excel data templates for user review, population and automated import back into main application. Design technical specifications for IO feeds. Implement audit trail through system design. Develop separate ad hoc analysis and reporting solutions with connections to main data repository. Draft user and system documentation. Participate in internal system and SOX compliance audits.

Greater Los Angeles Area

San Francisco Bay Area

MS Access 2003, Excel 2003, Word 2003, ODBC, VBA, DAOBenefits: Successful launch of insurance pilot program, business process vetting and discovery.Develop custom database application for auto insurance product fulfillment tracking and reporting using MS Access 2003. Develop multi-department "work queue" design which allows each department to move product through all lifecycle phases. Design and develop complex exception processing routines to support customer service tasks. Develop routines to extract and transform data from Oracle source system into custom feed files for import into MS Access 2003. Develop logic to manage product return and exchange processes within work queue. Develop custom analytical queries for support activities. Develop feed file formats and specifications and coordinate with third-party provider on development and testing.

Greater Los Angeles Area

MS Access 2003, Excel 2003, Word 2003, MS SQL Server, SQL, VBA, DAOBenefits: Streamlined data collection, analysis and client reporting, automation of complex monthly reporting.Develop custom database applications for investment data tracking, analysis and reporting using MS Access 2003, MS Excel 2003, and MS Word 2003; Develop GUI-driven import processes to convert Excel data into Access. Design and execute data conversion from SQL Server to MS Access database. Develop GUI-driven data export to Excel with full report formatting from VBA code of the Excel workbooks at runtime. Develop parameter-based reports menu for custom filtering and storage of custom filter sets.

Greater Los Angeles Area

MS Access 2000/3, Excel 2000/3, Visio 2000/3, SQL, VBA, DAOBenefits: Automated and systematic data testing, reporting and analysis with large datasets, improved data integrity.Develop data-driven data import and comparison testing applications using Access 2000/. Perform system migration data validation. Design and test validation reference files. Develop custom applications for automation of daily and monthly processes. Maintain data library for validation team. Design, implement and maintain data audit trail procedures. Provide detailed documentation for validation data analysis procedures and results. Develop and maintain file specification of key source system output file for use in reconciliation processes. Develop and perform unit and financial monthly reconciliation between client data system and outsourced Like Kind Exchange system. Provide adhoc bulk data analysis. Draft system and process documentation for SOX compliance. Work with internal and external audit teams during SOX compliance review and assessment. Develop custom utilities using Access 2000/3 including import/export, history tracking and data manipulation capabilities.

Orange County, California Area

MS Access 2000, Excel 2000, Visio 2000, SQL, VBA, DAO, WS FTP, TinyTermBenefits: Automated data import and validation, improved marketing analysis capabilities.Analyze existing system to determine functionality, structural integrity, and upgrade possibilities. Design and develop robust replacement data structure to support ongoing marketing data analysis and facilitate development of future reports. Convert existing data and validate conversion. Design and develop import interfaces to automate existing manual data imports and validate import integrity. Provide full structural and procedural documentation.

Orange County, California Area

MS Access 97, Excel 2000, SQL, VBA, DAOBenefits: Improved data capture and reporting, enhanced ticket tracking.Develop talent program data capture and reporting system using Access 97 and Excel 2000. Develop ad hoc export routines to automate publishing data to Excel. Develop custom reports against hierarchical data structure. Make enhancements to existing Help Desk ticket tracking system to enforce time-based business rules. Develop custom, scaleable reporting interface. Assist reporting team with advanced query and coding tasks.

Greater Los Angeles Area

MS Access 97 and 2000, Excel 2000, Visio 2000, SQL, VBA, DAOConvert existing financial reporting system using Access 97 and Access 2000 for use with new source data system. Gather requirements, document existing and new systems' specifications using Excel 2000 and Visio 2000 and maintain for development team. Develop import specifications and routines using SQL and VBA. Retool all interfaces and reports, design and develop data translation routines.

MS Access 97, Excel, SQL, VBA, DAOMaintain benefits management system in Access 97. Run monthly data import, validation and cleanup routines. Produce monthly health insurance billing. Design, develop and execute data conversion routines using Access 97. Develop and produce monthly eligibility data files for automated import by service providers. Perform data scrubbing using Access 97 and Excel 97. Perform data research as required. Produce ad hoc census files.

Orange County, California Area

MS Access 97, SQL, VBA, DAORetool existing financial deal tracking system built in Access 97. Add transactional functionality to reduce client/server calls and increase user interaction speed. Develop, with original programmer, custom data-driven criteria-based reporting interface to expand user reporting flexibility. Develop custom complex financial reports using Access 97.

Greater Los Angeles Area

MS Access 97, Excel 97, Word 97, Data Junction 7.0, SQL, VBA, DAOCreate benefits products documentation matrix used by client and service providers. Develop benefits management system in Access 97, including structure and interfaces. Develop premium and coverage calculation routines. Develop and produce adhoc and monthly reports. Automate monthly billing production using VBA and DAO to produce Word and Excel documents. Develop custom import/export interfaces and routines. Prepare ASCII files for submission to outside vendors according to specifications. Perform data scrubbing using Access 97 and Excel 97.

Greater Los Angeles Area

MS Access 97, Excel 97, Word 97, VBA, DAODevelop database application to capture policy information and print policy documents using Access 97 and MS Word. Develop Excel component to facilitate premium calculation through Access interface. Design second application to track current policy and endorsement history data. Design custom queries, data input and edit screens, and related functionality, including data validation to enforce business rules. Implement integration of application with Word and Excel through Automation and DAO to facilitate document printing and premium calculation. Design, develop and execute data conversion routines.