Occupation:Datawarehouse Designer |
Location:Rochester, MI |
Education Level:Master |
Will Relocate:YES |
Description
PROFESSIONAL SUMMARY * Data and Business Intelligence Analyst with more than 8 years of experience supporting data driven systems for healthcare, industrial and technology organizations * Specializes in collecting, analyzing and maintaining business and healthcare data to generate information and reports * Proven history of utilizing strong analytical skills, attention to detail, and hard work ethics to turn complex requirements into working systems. In-depth knowledge of various Software Development Lifecycle (SDLC) methodologies such as Waterfall, Agile and Scrum. * 3+ years as MS SQL Server/Business Intelligence developer in designing and developing T-SQL queries, ETL packages, and business reports using SQL Server Reporting Services (SSRS) * 3+ years as Data Warehouse developer in designing and developing SQL queries, ETL packages, and business reports using Oracle, IBM Cognos reporting tools. * Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality. * Designed SSIS Packages to extract data from various data sources such as SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server database for further Data Analysis and Reporting. * An excellent team member with an ability to perform individually and interpersonal relationship, good communication skills, hardworking and high level of motivation. * Proficient in SQL, T-SQL, PL/SQL Programming with exposure to RDBMS using Oracle, SQL Server. * Extensively involved in Data Modeling. * Experience in electronic medical coding (CPT/ICD/EDI) * Experience creating dashboard for healthcare billing and managed care monitoring as well as to monitor areas for improvements (AFI), and performance indicators (KPI)