John Sheldon Email & Phone Number

Sacramento, California Area

Work with Business Analysts to produce desired results. This potentially includes designing ETLs, data layer, reporting layer, presentation layer, tables, views, stored procedures, and work process flows.Main responsibilities include:Create and maintain Compensation Applications to support payment to 500+ clinicians (Doctors, APCs, etc).Create and maintain.

Sacramento, California Area

• The West Division footprint consists of 28,000 employees, 7 million customers, covering 8 states, generating $12 billion in revenue. Responsible for developing and enhancing data streams and reporting for division.
• West Division Daily Operation Report (DOR) (3rd Gen.) Replacing 7 regional reports using conflicting logic, created tool for meeting the needs of division and regional management, marketing, and operations. Built.
• NEO ID views / database. Since Employee DB is unwieldy, created a means for 30 plus reporting analysts to quickly locate Operator, Technician, and Sales IDs ownership, supervisor relationships, sales channel.
• Security Audits. Security team failed meeting timeframes with existing labor intensive, excel driven reports. Implemented new reports, enabling the quick identification of erroneous / lapsed users, meeting required.
• Employee DB cleanup project. Controlled by an external team, with no additional ownership stakes, it was riddled with errors and underutilized. I coordinated the efforts for IS Reporting to eliminate erroneous IDs.

Sacramento, California Area

• The newly formed California (super region) consisting of 7,500 employees and 2.45 million customers. Responsible for providing executive management, commissions, marketing, and operational reporting.
• California DOR (2nd Gen.) Replaced two existing reports for management, marketing, and operations with an enhanced application, providing a robust platform for existing and new products, allowing quick turnaround for.
• Revenue Assurance (RA) Reporting. California finance and RA team had no systematic means of stemming excessive and erroneous discount code usage. Created a tool kit for RA team, enabling them to coach, penalize, and.
• Adjustment Reporting. Replaced a cryptic, obsolete, and erroneous Access based report. Enabled Finance team to quickly identify adjustment abuse by customers and/or staff, thus retaining revenue. Implemented a robust.
• Stacked Index Reporting. Revenue Assurance and Finance team required a means to track products on 2.4 million customers on a monthly basis. Executed new monthly report summarizing up to 15 different product lines into.

Sacramento, California Area

• Central California region covered cable systems from Chico to Fresno. Primary responsible for providing summarized activity for executive management and commission / vendor payment reporting.
• Central Cal Management Reporting (Zero Gen.) Replacing several erroneous/incomplete data sets, designed new summarized reports for executive management tracking key metrics of connects, disconnects, trouble calls.
• Enhanced Management Reporting (1st Gen.) Migrated reports into SQL 7.0, shortening processing time, increasing accuracy, and eliminating 4 hours of daily staff time working with crude excel data sets.
• NC_Tracking (New Commission) Replacing numerous Access applications, created a SQL 7.0 based reporting tool for commissions. Created first comprehensive commissioning tool that could meet the disjointed commission.

Sacramento, California Area

Temporary job correcting standardized tests.

Sacramento, California Area

Lead Analyst for Providian Platinum Sales Operations. Responsible for designing and maintaining MIS for 600+ staff members, marketing, and executive staff. Created MIS Home Page and HTML-based MIS reporting for management. Responsible for meeting Providian's regulatory and settlement compliance requirements. Liaison between Operations, Management.

Sacramento, California Area

Lead assistant to ITU operations for a $300 million a year agency. Required to maintain and upgrade 150+ computers in various state offices. Completed limited programming assignments for ITU staff. Mandated to maintain comprehensive inventory of all hardware and software for ETP. Key resource on Word Perfect and Excel tasks.

Master Of Business Administration (Mba), Operations / Production

Bachelor Of Applied Science (B.A.Sc.), Mathematics