Mariam Khan
Microsoft Business Intelligence Analyst – SQL/SSIS/Power BI
Des Plaines, IL 60016
adiwy6@r.postjobfree.com
OBJECTIVE
To obtain a challenging Business Intelligence Analyst position that will utilize both my educational and professional experience to contribute towards the growth of an organization.
EXPERIENCE
Best Home Health Chicago, IL 10/2019- 11/2020
Microsoft BI Analyst – Power BI / SSIS
Designed a data warehouse focused on performing analysis on census data provided via an EMR system.
Connected nightly to Best Home Health’s EMR system (with SSIS packages) to pull census information and future appointments scheduled in the system. Stored the information in data mart for analysis in Power BI.
Helped build analytics around claims to compare cost of procedures that the business used for reducing costs and this data was used in negotiation and increase throughput of services at the health system. Analysis was primarily done using T-SQL and loading data in SQL Server using excel files and compare cost of procedures done across various providers and associated opportunity cost should those procedures be shifted internally in the healthcare system.
Levtech Health Chicago, IL 10/2017- 09/2019
Microsoft BI Analyst – Denial Analysis
Built a data mart that connected to claims files coming from various sources including SQL Server and Excel files.
Data mart was built using SQL Server Integration Services packages.
Packages connected to various sources (in case of multiple excel files looping through a folder location to identify all data with denial files) and loaded them into the data mart while performing lookups and modeling to fit it into a star schema to perform analysis by BI team
Took data from star schema data source and imported into a Microsoft Power BI Data Set for analysis
Power BI report included creating bookmarks that lets different stakeholders switch between views.
Created dynamic measures which were dependent on slicer values and using SelectedValue function in DAX script to switch the measure value based on slicer value in the Power BI visual. This enabled users to have one visual but the measure it displayed was dynamic
Helped team support the application and enhancements received from various stakeholders.
Career Builder 07/2017- 10/2017
Verification Specialist
Investigation by contacting the employment, education, licensing and DOT sources provided to verify employment, education/licensing.
Investigation by conducting interviews pertaining to job performance with references.
Adhere to confidentiality guidelines and legal compliance regulations as required.
RUSH University Medical Center Chicago, IL 07/2014-04/2016
Volunteer
Responds to nursing requests, aids discharge of patients by providing wheelchair accompaniment of patients to waiting area.
Provided clerical and reception support as requested, making labels, mail sorting/copies, deliveries and phone support.
COMPUTER SKILLS & LANGUAGES
T-SQL – Develop complex T-SQL combining data from various sources
Databases: Microsoft SQL Server
BI Tools: Microsoft Power BI Desktop and Power BI Service
ETL Tools: SQL Server Integration Server (Development and Deployment of packages and supporting existing ETL development)
OLAP Tools: SQL Server Analysis Services
Documentation tools – Proficient with MS Office and Excel
Bilingual (Urdu)
EDUCATION
BS Biological Sciences (2016)
University of Illinois at Chicago (UIC), IL
REFERENCES
Available upon request.