Robert Wheeldon Email & Phone Number

San Francisco, California, Us

Create, modify and support SSIS packages for ETL processesCreate and modify client SSRS reportsCreate SQL scripts for ad hoc requests, data, and system monitoringWork with Clients to define and document requirementsTroubleshoot and remediate issues in a timely manner to keep processes runningUnit test scripts and packages for accuracyDocument changes and results for references purposes

Create, modify, and support SQL queries and stored procedures for clientsProficient with SQL and T-SQL languagesProficient with SQL Server Management Studio versions 2008 and 2016Perform data manipulation per client requestsLead on the design, modification, and support of SSRS reports Proficient with Visual Studio versions 2012 and 2019System test updates to in house software packages Support client questions on use and issues with software packagesLead on mapping and importing client data into their databases

Des Moines, Iowa, Us

Team lead on project to convert data and processes from Global Software to the server-based Enterprise Accounting System (EAS) from Sungard Insurance SystemsTrained with Financial department on Accounts Payable, ledger entries, and basic accounting/banking principals for new systemLead Analyst/Developer on 1099 conversion to move data from mainframe to sever for processingPrimary Analyst/Developer for reloading data from EAS to mainframe in order to support non-converted systemsIT lead on discovery team for new 1099 package; Compared and analyzed systems to select the best option for companyImplemented selected 1099 package and worked with end users to support/train on new functionsWorked with business to understand needs and communicate those needs to the technical team for development and supportLead Analyst/Developer on project to convert 1099 package to OneSource 1099 from Thomson ReutersAnalyst/Developer for COBOL and SQL based Financial History reporting system on serverMonitored IT reports to detect Ledger posting issues and worked to resolve them in a timely manner Familiar with PeopleSoft, Team Foundation Server, VB Script, Access, and IBM mainframesExperience with LifePro from PDMA and Convey 1099 system

Des Moines, Iowa, Us

Primary Analyst/Developer on Policyholder ID Card systemMaintained documentation for ID Card systemAnalyst/Developer on team to update and streamline accounting cost reportingContinued support of Accounting and Actuarial processing and reportingBecame primary Analyst/Developer for company 1099 processing on mainframeAnalyst/Developer on project to feed data to new data warehouse system

Des Moines, Iowa, Us

Analyzed and developed programs to assist business applicationsPrepared documentation such as IT work requests from business requirements and test plansAnalyst/Developer on conversion of in-house Expense Check system from IMS to DB2Lead Analyst/Developer on ID number expansion for the Expense Check systemWrote documentation on Expense Check system for new entry and batch processing from conversionsPrimary Analyst/Developer for Global Software package when implanting new General Ledger function of Global Software Classic Accounting packageTeam lead on consolidating system data feeds into Global accounting package

Des Moines, Iowa, Us

Resolved issues quickly and efficiently to keep business areas on timeAccurately coded programs from problem descriptions; solved coding and logic errors; tested programs to satisfy requirementsProficient in COBOL, PL/1, DB2, SPUFI, JCL, and FileAidResponsible for in house Morbidity Reporting system and databases.Converted in house Morbidity Reporting system from IMS to DB2; updated documentation on changes and new run processesResponsible for the COBOL and VSAM based Accounts Payable and Purchase Order pieces of third-party vendor, Global Software’s, Classic Accounting package is support of company’s Financial departmentResponsible for mainframe Financial History reporting system and databases

Worked with communications equipment in a classified environment.

Ba In Computer Information Systems, Computer Information Systems

Associate Of Applied Science Computer Programmer/Analyst, Computer Programming/ Analyst

Associates Of Applied Science, Computer Programming

Certificate In Cryptology, Cryptology And Comunications Equipment