Amber King

Experience

• 

  Cigna Investment Management

  Jul 2004 - Dec 2008

  Sr Claims Analyst

  • Responsible for answering questions, auditing and coaching 11 senior employees.• Processed high dollar medical claims UB94/HCFA.• Requested information to determine benefits and completed adjustments on multiple systems.• Reviewed and issued audits on account information and processes.

• 

  Health Choice Arizona

  Mar 2009 - Oct 2014

  • Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.• Excellent interpersonal communication, problem solving, documentation and business analytical skills.• Fixed the bugs present in already existing reports.• Identified and worked with Parameters for parameterized reports in SSRS 2008.• Deployed the generated reports directly on the client’s workstation.• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.• Analyzed and designed software and database solutions.• Modified existing reports according to requirements of the end users.• Extracted data using SSIS packages (ETL) from different server locations and data sources.• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.• Involved in all phases of software development life cycle: design, implementation and testing.• In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports.• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS).• Responsible for New Hire training and mentoring new developers. Show less

  • Database Developer / Reporting Analyst

    Dec 2011 - Oct 2014

  • Quality Analyst

    Mar 2009 - Dec 2011
• 

  Health Choice

  Nov 2014 - Apr 2015

  Database System Analyst

  • Troubleshooting Interfaces and coordinating between client, vendor, and development for optimized solution.• Identify client needs and develop audit compliant solutions; this involves understanding primary objectives and implementing solutions.• Responsible for maintaining and updating technical documentation for software and systems.• Assisted development and production teams by determining application defects which optimize Interfaces and Software.

• 

  TriZetto, A Cognizant Company

  Apr 2015 - Aug 2015

  Technical Analyst

  • Troubleshooting Applications with End Users• Explaining Features and Limitations of Applications• Reporting and Managing Bug Fixes• Debugging Application Code, SQL, and EDI 834,835,837 Files.

• 

  GO Financial

  Aug 2015 - May 2016

  Business Intelligence Developer

  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.• Excellent interpersonal communication, problem solving, documentation and business analytical skills.• Fixed the bugs present in already existing reports.• Led Proof of Concepts around Azure Cloud Solutions including Azure SQL Data Warehouse, SQL Database, SSAS Tabular Models and more. Including presentations to Senior Management, performance testing, process implementation and pricing evaluations. • Apply Data Architect practices to design and build out new data models. • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary.• Modified existing reports according to requirements of the end users.• Extracted data using SSIS packages (ETL) from different server locations and data sources.• Build out, maintain, and debug SSAS Tabular Models. Show less

• 

  DriveTime

  May 2016 - Dec 2017

  Business Intelligence Developer

  • Focus on building out architecture, creating new models and datamarts. • Using Azure Cloud technology, Microsoft Transact SQL, SSIS, SSRS, Power BI, Azure SQL Data Warehouse, Azure SQL Database.• Special focus on communication, timeline estimation, documentation, leading meetings, and presentations.

• 

  OfferPad

  Dec 2017 - Apr 2021

  Business Intelligence Manager

  ● Led a team of 5, (3 Engineers and 2 Analysts) who were responsible for building and maintaining our data warehouse, data integrations, and reporting across the entire organization. ● Implemented a cross functional Data Warehouse using Kimball Methodology that refreshes every 15 minutes supporting all reporting, analytics, and data science. ● Led our Data Engineering team to scale our Data Warehouse to be able to function with Big Data. in a full PaaS environment and then scaling that solution to be able to convert and function on a Big Data platform. ● Led an Analytics team in Implementing Azure Analysis Services, creating, analyzing, and presenting reports in Power BI. Including focus on Best Practices and performance. ● Responsible for all Data Architecture including design, build, and maintenance of a data warehouse using Azure Architecture integrating with AWS, Oracle ERP, Google Analytics, Salesforce, and various other APIs. ● Responsible for discovering new technology, evaluating impact, cost, and strategy to implementation. ● Successfully Integrated with Facebook and Google Analytics using Python and Databricks. ● Completed my CSPO and CSM certifications and applied Scrum methods across an Engineering Team, Analytics Team, and Data Science Team. ● Led a team in creating a structure of best practices, focusing on professional development and positive engagement. ● Managing expectations and competing priorities through Agile ceremonies, adapting where it’s needed and focusing on communication. ● Developing Employees through mentoring, training, and effective communication. I focus a great deal on aligning personal goals with relevant company needs. A team that is engaged in their work are more innovative and productive. Show less

• 

  UST

  Apr 2021 - now

  Cloud Solution Architect