Arthur Rymer Email & Phone Number

Chattanooga, Tn, Us

Chattanooga, Tn, Us

Hixson, Tennessee, Us

Affiliate for Tennessee's top-shelf cannabis company; compete in a variety of virtual motorsports events to raise awareness and sales.

Plantation, Florida, Us

New Orleans, Louisiana, Us

New Orleans, Louisiana, Us

Montreal, Quebec, Ca

Internal IS&IT - Business Intelligence (2018 - 2019)● Used Microsoft SQL Server 2016 (advanced T-SQL queries, stored procedures) to support ETL processes to import/export data to various departments within CGI Federal.● Used knowledge of T-SQL and indexing to improve nightly processes by an average of 50-75%.● Technical lead on project to develop data warehouse to house data from various internal/external systems in order to standardize and improve reporting metrics.Healthcare Compliance Practices (CGI ProperPay) (2016 - 2018)● Used Microsoft SQL Server 2008 R2 (advanced T-SQL queries, stored procedures, Reporting Services) to develop and support various versions of CGI’s ProperPay application.● Led development and implementation of various development initiatives to increase financial demands to insurers from $10M to $60M per month during 2017.● Led development and implementation of various development initiatives to increase compliance with CMS’s Mandatory Lead Development initiative to over 95% standard on a regular basis.

Atlanta, Georgia, Us

● Used​ ​Microsoft​ ​SQL​ ​Server​ ​2008​ ​R2,​ ​and​ ​then​ ​later​ ​Microsoft​ ​SQL​ ​Server​ ​2014 (advanced​ ​T-SQL​ ​queries,​ ​stored​ ​procedures,​ ​Integration​ ​Services,​ ​Reporting​ ​Services, Analysis​ ​Services),​ ​Microstrategy,​ ​and​ ​Tableau​ ​to​ ​serve​ ​the​ ​many​ ​reporting​ ​needs​ ​of​ ​the company,​ ​with​ ​an​ ​emphasis​ ​on​ ​coding​ ​and​ ​quality​ ​performance ● Heavily​ ​involved​ ​in​ ​project​ ​to​ ​allow​ ​for​ ​acceptance​ ​of​ ​ICD-10​ ​coding​ ​in​ ​the​ ​data​ ​warehouse ● Worked​ ​to​ ​help​ ​improve​ ​performance​ ​of​ ​nightly​ ​builds;​ ​along​ ​with​ ​others,​ ​have​ ​reduced nightly​ ​build​ ​time​ ​by​ ​an​ ​average​ ​of​ ​about​ ​2​ ​hours​ ​(prior​ ​to​ ​SQL​ ​Server​ ​2014​ ​upgrades)

Birmingham, Alabama, Us

● Used​ ​Oracle​ ​11g​ ​and​ ​Microsoft​ ​SQL​ ​Server​ ​2012​ ​(Integration​ ​Services,​ ​Reporting Services,​ ​Analysis​ ​Services,​ ​MDX)​ ​to​ ​serve​ ​the​ ​reporting​ ​needs​ ​of​ ​Business​ ​Services, Private​ ​Wealth​ ​Management,​ ​Treasury​ ​Management,​ ​and​ ​Mortgage ● Developed​ ​cubes​ ​in​ ​Analysis​ ​Services​ ​to​ ​allow​ ​for​ ​better​ ​trending​ ​of​ ​bank​ ​quality​ ​metrics than​ ​cubes​ ​developed​ ​by​ ​outside​ ​contractors,​ ​and​ ​thus​ ​better​ ​meet​ ​needs​ ​of​ ​business users​ ​for​ ​self-serve​ ​business​ ​intelligence ● Served​ ​as​ ​technical​ ​lead​ ​and​ ​mentor​ ​to​ ​junior​ ​employees​ ​in​ ​the​ ​department

Birmingham, Alabama, Us

● Used​ ​Microsoft​ ​SQL​ ​Server​ ​2008​ ​R2​ ​(advanced​ ​T-SQL​ ​queries,​ ​stored​ ​procedures, Integration​ ​Services,​ ​Reporting​ ​Services,​ ​Analysis​ ​Services,​ ​MDX)​ ​to​ ​serve​ ​the​ ​many reporting​ ​needs​ ​of​ ​Branch​ ​Consumer​ ​Sales,​ ​Service,​ ​and​ ​Performance​ ​Management ● Responsible​ ​for​ ​continued​ ​maintenance​ ​and​ ​development​ ​of​ ​the​ ​Weekly​ ​Sales​ ​Report, sourcing​ ​data​ ​from​ ​many​ ​different​ ​systems​ ​within​ ​Regions.​ ​Used​ ​Integration​ ​Services, T-SQL,​ ​Reporting​ ​Services,​ ​and​ ​Analysis​ ​Services/MDX ● Responsible​ ​for​ ​development​ ​of​ ​performance​ ​reporting​ ​using​ ​RegionsConnects​ ​SQL Server​ ​backend​ ​to​ ​help​ ​track​ ​performance​ ​of​ ​associates​ ​in​ ​contacting​ ​sales​ ​leads (consumer​ ​and​ ​business).​ ​Used​ ​Integration​ ​Services,​ ​T-SQL,​ ​and​ ​Reporting​ ​Services

Atlanta, Ga, Us

● Used​ ​Microsoft​ ​SQL​ ​Server​ ​2005​ ​(advanced​ ​T-SQL​ ​queries,​ ​Integration​ ​Services, Reporting​ ​Services,​ ​stored​ ​procedures),​ ​Microsoft​ ​Excel​ ​2007,​ ​Salient​ ​UXT​ ​Margin Minder,​ ​Teradata,​ ​and​ ​Business​ ​Objects​ ​to​ ​produce,​ ​audit,​ ​maintain,​ ​and​ ​distribute​ ​various financial​ ​reports​ ​for​ ​the​ ​company ● Involved​ ​in​ ​development​ ​of​ ​monthly​ ​financial​ ​statements​ ​using​ ​data​ ​from​ ​multiple​ ​systems from​ ​various​ ​facets​ ​of​ ​Coca-Cola​ ​Refreshments​ ​and​ ​The​ ​Coca-Cola​ ​Company.​ ​Lead architect​ ​of​ ​report​ ​solution​ ​for​ ​this​ ​project​ ​using​ ​SQL​ ​Server​ ​Reporting​ ​Services​ ​2008. Architect​ ​of​ ​ETL​ ​and​ ​audit​ ​processes​ ​using​ ​Integration​ ​Services​ ​and​ ​T-SQL

● Mainly​ ​worked​ ​with​ ​health​ ​services​ ​sector​ ​on​ ​patient​ ​utilization,​ ​but​ ​was​ ​also​ ​responsible for​ ​membership​ ​data​ ​and​ ​some​ ​claims/cost​ ​analysis;​ ​worked​ ​with​ ​end​ ​users​ ​to​ ​obtain​ ​and document​ ​reporting​ ​requirements ● Using​ ​Microsoft​ ​SQL​ ​Server​ ​2005​ ​(advanced​ ​T-SQL​ ​queries​ ​and​ ​stored​ ​procedures)​ ​and Crystal​ ​Reports​ ​XI,​ ​streamlined​ ​daily,​ ​weekly,​ ​and​ ​monthly​ ​patient​ ​utilization​ ​reports,​ ​thus saving​ ​time​ ​and​ ​manpower​ ​on​ ​routine​ ​reporting ● Using​ ​knowledge​ ​of​ ​Crystal​ ​Reports​ ​XI,​ ​built​ ​reports​ ​flexible​ ​in​ ​parameters​ ​and layout/export,​ ​thus​ ​saving​ ​time​ ​and​ ​effort​ ​on​ ​handling​ ​ad-hoc​ ​requests​ ​from​ ​various departments

Bedminster, New Jersey, Us

● Used​ ​Microsoft​ ​SQL​ ​Server​ ​2000​ ​(advanced​ ​T-SQL​ ​queries​ ​and​ ​stored​ ​procedures)​ ​and Microsoft​ ​Excel​ ​2003/Crystal​ ​Reports​ ​XI​ ​to​ ​streamline​ ​the​ ​processes​ ​for​ ​weekly​ ​and monthly​ ​reporting,​ ​thus​ ​freeing​ ​up​ ​time​ ​for​ ​more​ ​specialized​ ​data​ ​requests​ ​using​ ​same software ● Used​ ​Alignstar​ ​and​ ​Microsoft​ ​SQL​ ​Server​ ​2000​ ​to​ ​play​ ​a​ ​major​ ​role​ ​in​ ​the​ ​design​ ​of​ ​sales territories​ ​for​ ​the​ ​company’s​ ​nationwide​ ​expansion​ ​in​ ​2007 ● Co-authored​ ​a​ ​quarterly​ ​newsletter​ ​on​ ​various​ ​pharmaceutical​ ​data​ ​concepts​ ​that​ ​brought new​ ​ideas​ ​to​ ​sales​ ​management