We provide IT Staff Augmentation Services!

Business Intelligence Resume

5.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Over 14 years of IT experience in all phases of SDLC process from Software Analysis till Production support, and Implementation of Business Intelligence (BI) and Big D Confidential Analytical Applications with strong emphasis in ETL, Modeling, D Confidential Analytics and Reporting tools.
  • 10+ years of experience in ETL technologies with D Confidential Integration, D Confidential Analytics, D Confidential warehouse Design, Analysis, Development, Testing and Implementation.
  • 4 years of experience in Big D Confidential & Hadoop technologies involving HDFS, Sqoop, Hue, Hive, Impala, Spark (SQL), Pig, Hbase, NoSQL d Confidential base, Kafka, Solr, Hbase, Flume, Oozie, StreamSets, NiFi, D Confidential meer, Trifacta, D Confidential iku, Python and Linux.
  • Expert in designing and developing Apache Sqoop program to ingest the d Confidential from Oracle, SQL Server to Hive and performed descriptive and predictive analysis on the imported d Confidential in Impala
  • Implemented SCD Type 1 and Type 2 in Hive to process ETL updates with huge amount of d Confidential .
  • Strong experience in automating the d Confidential ingestion jobs in batch and near - real time using Oozie
  • Experienced in generating keystore files for storing DB password and monitor the jobs in Hue
  • Expertise in using Hue for Hive, Impala, Spark, Pig, Hbase, Solr for d Confidential analysis in HDFS
  • Great technical proficiency in Big D Confidential Ingestion tools using NiFi, StreamSets and Informatica by creating d Confidential processing flows to load d Confidential in HDFS
  • Developed Python scripts in PySpark for building d Confidential pipelines/analysis and ingest d Confidential in HDFS
  • Strong understanding in Kafka and Flume to capture messages and store in HDFS.
  • Having knowledge in NoSQL d Confidential base like MongoDB and Splunk for analyzing the web service logs
  • Designed and developed collections in Solr and successfully deployed Cloudera Search functionality
  • Strong knowledge in Kerberos authentication and Sentry authorization to maintain security
  • Implemented d Confidential munging/wrangling in D Confidential meer and Trifacta that transforms the clickstream d Confidential using sessionization logic for analytics, reporting and deep learning
  • Experience in Deep and Machine Learning with supervised - Random Forest Model using D Confidential iku
  • Strong experience in d Confidential modeling implementing Star and snowflake schemas in ERWIN and SAP Power designer with considerations on handling PII, PCI, PHI d Confidential using GDPR, HIPAA standards
  • Expert in designing and developing Canned reports and Interactive Dashboards in the Zoom D Confidential and Tableau 2018.1 using both Live and Extract connection from Hadoop HDFS
  • Experienced in various domains - Insurance, Health Care, Oil & Energy and Airline Industry
  • Expertise in both Waterfall and Agile methodologies
  • Passionate to Excellence, Problem Solving, Troubleshooting and Decision Making skills

TECHNICAL SKILLS:

BigD Confidential Ecosystem: Sqoop, Hue, Hive, Impala, Spark (SQL), Pig, Hbase, NoSQL d Confidential base, Kafka, Solr, Hbase, Flume, Oozie, StreamSets, NiFi, D Confidential meer, Trifacta, D Confidential iku

ETL Tools: Informatica, Business Objects D Confidential Integrator, D Confidential Stage

Reporting Tools: Tableau BI, Zoom D Confidential, SAP Business Objects

Modeling Tools: SAP Power Designer, ERWIN, MS Visio

D Confidential bases: Terad Confidential 14.0, Oracle 11g, SQL Server 2014, DB2, Netezza, MS Access

Language Skills: BTeq, SQL, PL/SQL, SQL*Plus, UNIX - Perl, Bash Shell Scripting

Utilities: TOAD, Advanced Query tool(AQT), SQL*Loader, Terad Confidential SQL Assistant, Splunk, Kibana, HP Quality Center, Service Now, Jupyter Notebook, Spyder

Operating Systems: Windows, UNIX and Linux

Version Control: GitHub, Share Point

We'd love your feedback!