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 Operational ReportingMaintain various security / filtering models. (Active Directory Groups, Local Groups, home grown security, home grown row level filtering, etc)

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 wide, regional, and specialized needs, while operating under difficult environmental constraints.• 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 solution to process billing system data, including simultaneous processing of regional data sets, automated product and sales channel mapping, and robust recovery safeguards in case of network/data failures. Provided robust daily summary and account level details on all new, pending, and completed product transactions. • 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, occupation, and function, thus enabling critical division based reports.• 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 compliance timeframes. Utilized BIDS/SSIS, along with SSRS, to process and display information. • 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, automating data feeds, and liaison between regional, divisional, and corporate staff. Making DB a single stop for creating and maintaining IDs. Created an accurate single system of record for west division to utilize.

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 launching new services. Data sets critical for marketing forecasts on sold, pending, and completed activity. Utilized SQL 2005 to create both primary and backup data flows.• 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 stem losses, thus saving $1+ million in monthly revenue. “Top 10” report provided details based upon geography, function, and product. Provided both summary and account level details.• 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 SQL 2008 solution and provided end users with a simple, Excel based front end. • 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 one record per customer. Enabled finance team to examine month over month trends.

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, sold, pending, and completed activity by product and geographical area. Maximized value of “Forest and Trees” application to obtain billing system data for Excel based reports. (See Below)• 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 plans / payments for employees /vendors for different geographical areas and sales channels. Application increased accuracy, while reducing the time to add new commission products from days to hours. Code formed the core of a new commission application for California Call Centers.

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, Marketing, and Business Engineering.

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