Business Intelligence Analyst Intern Resume

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst Intern

Confidential

Responsibilities:

Integrated data from various sources to build a Data Warehouse; identified teh facts and dimensions to streamline business processes
Designed SQL procedures using cursors, views, triggers & performed ETL to improve teh analytical reporting of business operation
Implemented ETL process using SQL Server Integration Services Server, SQL & SSAS to design teh DataMart & MOLAP data cubes
Set teh key performance indicators(KPI) & created interactive reports to gain valuable insights using Power BI and Microsoft Excel

Data Analyst & Database Developer Intern

Confidential

Responsibilities:

Collected data and analyzed them to consolidate teh business process and drafted teh results in Business requirements document
Performed competitor analysis; identified & analyzed Risks involved, Feasibility & Cost to evaluate Database management systems
Used Agile methodology to develop teh database using SQL Server & Quickbase application of Inuit & increased work efficiency by 75%

System Analyst

Confidential

Responsibilities:

Brainstormed to break down complex problems, understand root causes, and proposed viable solutions to improve system efficiency
Performed SWOT analysis & designed teh Use case, ERD, DFD, process & architecture diagrams to build teh relational database
Migrated data from excel to a relational database to facilitate teh change management process & ensure timely release of deliverables
Performed SQL tuning, built forms and reports using MySQL and MS Access which saved teh effort and time by ~50%

Environment: MySQL | MS Access | Data Analysis | UML Diagrams

Data Analyst|

Confidential

Responsibilities:

Performed data cleaning using Pandas and exploratory data analysis to improve teh data quality and data integrity
Created models by logistic regression, random forest, neural networks machine learning algorithm to & analyze teh credit trends
Built big data analytics pipelines in Python, Hadoop and Apache Spark to halp banks make data - driven analytics decision
Visualized teh analysis using heat maps, scatter plots and bar graphs in Python programming language for summarizing teh data

Business Data Analyst

Confidential

Responsibilities:

Analyzed data set of past 10 years to develop cost-TEMPeffective recruitment strategy for best quality students based on GMAT scores
Performed statistical analytics using regression, power pivot, v-lookups, macros, Google Analytics & SQL to evaluate student trends
Developed dashboards using Tableau to gain insights & to establish a strategy dat reduced teh cost by 10%

Environment: Tableau | Statistical programming | Google Analytics | Advanced MS Excel