Business Intelligence Resume
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
