We provide IT Staff Augmentation Services!

Business Intelligence Analyst Intern Resume

Miami, FL

SUMMARY

  • Business Intelligence Professional with over 3 yrs. of experience in data warehousing, ETL, reporting, SQL programming and proficiency in data analysis to derive insights from tera - bytes of data through data mining and big data tools

TECHNICAL SKILLS

ETL & Reporting: Informatica, Tableau, Data Modelling, SSIS, Power BI, OLAP, Advance Excel

Big Data & Data mining: SAS, Rapid Miner, Hadoop, Hive, Pig, MapReduce, Spark, Machine Learning

Databases: Oracle, Microsoft SQL server, IBM Netezza, Cassandra, MongoDB

Programming Languages: SQL, PL-SQL, R, Unix shell Scripting, Python, JAVA

Certifications: Six Sigma Green Belt, Software Estimation, Statistical inference, Tableau

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Business Intelligence Analyst Intern

Responsibilities:

  • Streamlined data migration process and reduced resolution time for manual efforts by 70% per request
  • Worked closely on developing preventive maintenance model using predictive modelling to improve fleet downtime
  • Involved in data analysis and incident fixes of complex SQL queries for ETL workflows in SSIS and Informatica
  • Monitored hourly 24x7 batch - ETL pipe line for Netezza data warehouse
  • Analyzed, implemented and tested PL-SQL/T-SQL procedures and functions
  • Evaluated and enhanced customer facing ad-hoc reports in Tableau and Power BI for business KPIs
  • Formulated development of OLAP cubes and reports in MicroStrategy
  • Acquired hands on experience on Amazon web services, Redshift, Redwood and Paxata for data lake design

Confidential

Business Intelligence Developer

Responsibilities:

  • Worked extensively on dimensional modelling to implement star and snowflake schema design
  • Developed mappings to load into staging tables and then to Dimensions and Facts
  • Involved in performance tuning of targets, sources, mappings, and sessions for Informatica mappings
  • Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows
  • Knowledge of RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraint
  • Published reports and dashboards using dynamic queries, views, charts, interactivity filters and functions for business KPI’s in Reporting and Visualization Tool Tableau
  • Programmed UNIX shell scripts for batch job processing
  • Accelerated Automation of a business process to reduce downtime of application from 9hrs to 4hrs in turn generating cost savings of US $48000
  • Involved in client interactions for requirement gathering, design and testing for full SDLC phases
  • Mentored team of 3, for functional and technical knowledge transitions

Hire Now