Business Intelligence Analyst Intern Resume Boston - Hire IT People

TECHNICAL SKILLS

Languages: Java, C, C++, Python, XML, CSS, JavaScript, HTML, SQL, Hive, Pig, Bash

Web Services: REST

Cloud Services: AWS (EC2, SQS, EBS, S3), Google Cloud Platform

Frameworks: Hadoop, MapReduce, Pytest, Apache Spark

Database: Microsoft SQL Server, MySQL, MongoDB, Postgres, Oracle, Cassandra, Hbase, Data - stage (ETL)

Tools: Intellij, Eclipse, Git, JIRA, MS Office, Excel, Docker, Talend (ETL), Tableau, Domo, PowerBI

Protocols: DHCP, DNS, TCP/IP, UDP

PROFESSIONAL EXPERIENCE

Confidential, Boston

Business Intelligence Analyst Intern

Responsibilities:

Designed & implemented industry best practices for MySQL database performance tuning, optimization and maintenance techniques like creating indexing, table partitioning, query optimization, backup and restore strategies resulting in a reduction of defects by 95%.
Efficiently centralized $70 million in Annual recurring revenue (ARR) in reporting and analysis across the North American continent using advanced SQL scripts and tableau reporting
Regulated Business Intelligence strategy and Data Governance policies with firm leaders & Managers Standardized data visualization platform for business analysis and interactive dashboards in Domo, Salesforce reporting and Tableau for stakeholders from Finance, Sales and Marketing

Confidential

Senior Business Intelligence Engineer

Responsibilities:

Responsible for translating Business requirements into technical specifications
Analyzed dataflow and business requirements to create High-Level Design and Low-Level Design
Worked on MPP based architecture on Linux platform for creating data pipelines using ETL tools
Implemented an automation testing for data quality and dynamic schema check

Confidential

Business Intelligence Engineer

Responsibilities:

Generated Tableau Dashboard with quick/context/global filters, parameter and calculated fields
Worked in all phases of BW/BI full life cycles includinganalysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
Constructed design for Operational data system (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ), Housekeeping archives, Capacity Planning and created functional data requirement (FDR) and Master Test Strategy documents.
Used Python & bash scripts for file validation, environment management and database connectivity