SHAYAN KHAN

ad2hw0@r.postjobfree.com 646-***-****

linkedin.com/in/shayan-khan-125038107

Summary

Professional SUMMARY

•8+ years of extensive experience in Data analysis, Data Quality Management, gathering requirement.

•Proficient in Data Analysis, System Analysis and Business Requirement Gathering.

•Good understanding of Data profiling, Data Cleansing, Data Security and Data Quality Management.

•Good knowledge of Agile Methodology of SDLC for implementing Business projects.

•Data Manipulation, Data definition, Data control and excellent report writing.

•Good experience working on databases like MS SQL Server and Oracle SQL Developer.

•Also have experience working with SAP S/4HANA ERP.

•Good working knowledge of Business intelligence software like Tableau, Alteryx, and Excel.

•Generating reports, status, graphics and statistical analysis through the use of Tableau and Excel.

•Developing various metrics and needed KPI’s on Tableau.

•Effective use of needed tools for Integration and extraction of data from various sources like SQL Server and Flat files into a staging area.

•Experienced in implementing data analysis with tools such as SSMS and Excel.

•Proficient in Tableau visualizations and dashboards creations using Tableau Desktop.

•Proficient in Power BI visualizations and dashboards creations using Power BI Desktop. Experience

Business Data Analyst

Midtronix INC

Feb 2021 - Jan 2023 (2 years)

Conducted data analysis on annual net clients/patients’ revenue.

•Analyzed and tracked client’s data and monthly payments.

•Worked with medical staff to clean and update patients’ data in agreement with HIPAA regulations.

•Contributed to the implementation of a medical record filing system which resulted in decreasing new client’s admission wait time by 15%.

•Created Excel BI Analysis and regulatory reports using VLOOKUP, Pivot tables and complex DAX languages.

•Created Excel based Analysis and reports using VLOOKUP, Pivot tables and complex excel formulas.

•Manually modified the SQL data sets in Report Studio to tune and/or to write complicated reports.

•Wrote SQL codes to implement report specific queries in reporting.

•Reviewed medical insurance packages to determine coverage that best benefits the client.

•Responsible for operational data needs of the marketing plan.

•Created and implemented new and efficient strategies for data collection within the company.

•Developed Oracle Business Intelligence Enterprise (OBIEE) Queries for Analyzing and reporting Dataset.

•Wrote complex SQL queries using various joins, unions and functions for report purpose.

•Compiled and prepared financial reports on a quarterly basis and presented financial metrics to upper management.

•Daily monitoring and clearing of sales-related documents on controlled error screens within SAP. SHAYAN KHAN - page 1

8684 North 62nd st, Milwaukee,

WI, 53223

•Produced weekly, monthly and ad hoc reports using advanced Excel spreadsheet functions.

•Direct effective implementation, integration and execution of reporting on new and existing business initiatives.

•Automated Importing of data to Access and SQL Server from flat files and Excel spreadsheets.

•Manual review and correction of numerous errors and gaps for tenant’s dataset using Data Analysis Expressions.

•Developed Tableau visualizations and dashboards from extracted reports using Tableau Desktop. Data Analyst

Elephans

Mar 2020 - Jan 2021 (11 months)

Understanding of the business requirements and the existing data warehouse architecture design.

•Taking existing data from a separate document and inputting it into Excel

•Creating a financial strategy or budgeting plan from scratch and typing it into Excel

•Transferring a schedule from an outside source and rebuilding it in Excel

•Used Informatica Designer to Create, Load, Update mappings using different transformations to move data marts in Data Warehouse.

•Developed SQL stored procedures and triggers in T-SQL for various data cleansing activities.

•Created source, target, transformations, sessions, batches, and defined schedules for the sessions.

•Successfully maintained the workflow for ad hoc for client reporting. (Santander bank, UPMC & Prudential) and assist manager with ad hoc metrics and projects.

•Proficiency in fault investigation, analyzing the data and data cleansing.

•Work on Documentation review within Workflow.

•Maintain excellent documentation for understanding and accessing data storage.

•Creating ad hoc reports based on client management data using MicroStrategy.

•Understanding data flows and systems utilization of security master file data.

•Used Data Integrators to club data from different kind of sources.

•Performed incremental aggregation to load incremental data into aggregate tables.

•Involved in moving Mapping, Sessions and Workflows between development and production environments.

•Involved in preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Data Analyst

IEEE

Jan 2019 - Jan 2020 (1 year 1 month)

Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.x.

•Worked extensively on SQL server, ETL tools include INFORMATICA

•Good Knowledge and hands-on experience on Oracle(SQL/PLSQL), MS Access, databases(MySQL, Oracle, SQL Server)

•Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop versions 8.0, 8.1 and 8.2. Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public. Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data. SHAYAN KHAN - page 2

•Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.

•Experience in gathering and writing detailed business requirement and translating them into technical specifications and design.

•Extensive knowledge in Business Intelligence and Data Warehousing Concepts with emphasis on ETL and System Development Life Cycle (SDLC).

•Extensive knowledge on Data Profiling using Informatica Developer tool.

•Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures Data Analyst

King Edward School

Apr 2014 - Jan 2019 (4 years 10 months)

Organized quarterly projection data gathered by senior analysts in an orderly way for executive management.

•Reported bi-monthly data analysis findings to upper management to use in making organizational decisions.

•Worked with advanced calculations to draw conclusions about data findings.

•Assisted superiors with interpreting data and compiling it in an organized manner. Education

DePaul University

Master of Science, Computer Information Systems

NED University of Engineering and Technology

Bachelor of Science, Computer Science

Licenses & Certifications

SQL for Data Analytics - LinkedIn Learn

R-Programming Certified - LinkedIn Learn

Data Analytics for Business Professionals - LinkedIn Learn Power BI Certified - LinkedIn Learn

Tableau Certified - LinkedIn Learn

Skills

R (Programming Language) • SQL • Tableau • Microsoft Power BI • Microsoft SQL Server • Python

(Programming Language) • Alteryx • QlikView • Informatica • Enterprise Resource Planning (ERP) SHAYAN KHAN - page 3

Contact this candidate