Robert See

Robert See Email and Phone Number

CTO and Director of Photography @ Running Lady Studios
Los Angeles, CA, US
Robert See's Location
Los Angeles Metropolitan Area, United States
Robert See's Contact Details

Robert See personal email

n/a
About Robert See

I've been working actively as as Applications Developer and Analyst since 1997. My primary area of expertise is the design and development of custom Access applications. In support of this, I've gained considerable experience in data manipulation (extraction, validation, cleanup, massaging, transformation, etc.), GUI design, and reporting (in Access, Excel and Word), along with knowledge in the areas of auto insurance, health benefits, auto leasing, and investments. My most recent work has involved developing a custom application for collecting rates related to health benefits which facilitates review and updating of said rates prior to generating exports for upload to a production system.ROLES:Applications Developer | Data Analyst | Systems AnalystTOOLKIT:Access | Excel | Word | VBA | DAO | ODBC | SQL | Visio | ProjectBENEFICIARIES:Centene Corporation | WellCare | Universal American | Kaiser Permanente | AAA | Honda | Zee Medical | Washington Mutual | Northrup Grumman | Black Angus | GE CapitalPERFORMANCE:Database architecture and business process analysis.Active and continuous development of file/server database systems using MS Access, Excel and Word since 1997. Extensive data analysis and conversion experience. Custom data capture and reporting design and development.Experience in accessing external data sources.Custom conversion and validation design and development.Custom interface design and development, including data-driven interfaces.Data export and publishing routines design and development utilizing MS Excel and Word. Financial reporting, including monthly billing.SOX Compliance and audit experience.Experience in financial, insurance, benefits, marketing and auto leasing environments.Fluent in techno babble and user speak.Specialties: data manipulation, extraction, validation, cleanup, massaging, transformation, GUI design, reporting, Access, Excel, Word, Office, auto insurance, health benefits, auto leasing, investments, product fulfillment, SQL, Oracle, querying, requirements gathering, documentation

Robert See's Current Company Details
Running Lady Studios

Running Lady Studios

View
CTO and Director of Photography
Los Angeles, CA, US
Robert See Work Experience Details
  • Running Lady Studios
    Cto And Director Of Photography
    Running Lady Studios
    Los Angeles, Ca, Us
  • Centene Corporation
    Senior Business Systems Analyst
    Centene Corporation Jun 2020 - Present
    Los Angeles Metropolitan Area
    Came to Centene through WellCare acquisition in 2020.
    View
  • Running Lady Studios
    Cto/Director Of Photography
    Running Lady Studios Feb 2008 - Present
    Partner at Running Lady Studios, an animation film production company. Duties include Director of Photography and Production Designer.
  • Wellcare Medicare
    Application Developer
    Wellcare Medicare Jan 2018 - Jun 2020
    Los Angeles Metropolitan Area
    Came to WellCare through Universal American acquisition in 2018.
    View
  • Universal American
    Application Developer
    Universal American Aug 2013 - Jan 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.
    View
  • Kaiser Permanente It
    Applications Developer/Data Analyst
    Kaiser Permanente It Aug 2010 - Dec 2012
    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.
    View
  • See Creative
    Cto
    See Creative 1995 - 2012
    Greater Los Angeles Area
  • Csaa
    Applications Developer/System Analyst
    Csaa Aug 2009 - Jul 2010
    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.
    View
  • Cliffwater Financial Services
    Applications Developer
    Cliffwater Financial Services Apr 2006 - Jun 2010
    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.
  • American Honda Finance Corporation
    Applications Developer/System Analyst
    American Honda Finance Corporation Jan 2004 - Jun 2007
    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.
  • Zee Medical
    Applications Developer
    Zee Medical Jul 2003 - Jan 2004
    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.
    View
  • Washington Mutual
    Applications Developer
    Washington Mutual Apr 2003 - Jun 2003
    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.
  • Northrop Grumman
    Applications Developer
    Northrop Grumman Oct 2002 - Feb 2003
    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.
    View
  • Stuart Anderson'S Black Angus
    Applications Developer/Data Analyst
    Stuart Anderson'S Black Angus Feb 2002 - Jan 2003
    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.
    View
  • Ge Capital
    Applications Developer/Data Analyst
    Ge Capital Nov 2001 - Aug 2002
    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.
    View
  • Near North National Group/Custom Benefit Consultants, Inc
    Applications Developer/Data Analyst
    Near North National Group/Custom Benefit Consultants, Inc Dec 1999 - Feb 2002
    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.
  • Amwest Surety Insurance Company
    Applications Developer/System Analyst
    Amwest Surety Insurance Company Sep 1998 - Nov 1999
    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.

Robert See Skills

Access Visio Sql Databases Software Documentation Microsoft Excel Vba Analysis Microsoft Word Requirements Analysis Requirements Gathering User Interface Design Microsoft Office Database Design Programming Oracle Excel Validation Photoshop After Effects Data Analysis Documentation Data Manipulation Health Insurance Word Ms Project Problem Solving Application Architecture Graphic Design Title Design Database Development Microsoft Sql Server Big Data Data Management Data Modeling Database Administration

Frequently Asked Questions about Robert See

What company does Robert See work for?

Robert See works for Running Lady Studios

What is Robert See's role at the current company?

Robert See's current role is CTO and Director of Photography.

What is Robert See's email address?

Robert See's email address is ro****@****can.com

What is Robert See's direct phone number?

Robert See's direct phone number is +140799*****

What skills is Robert See known for?

Robert See has skills like Access, Visio, Sql, Databases, Software Documentation, Microsoft Excel, Vba, Analysis, Microsoft Word, Requirements Analysis, Requirements Gathering, User Interface Design.

Not the Robert See you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.