SUMMARY:

• Over 9 years of experience in BigData, Hadoop, HDFS, HBASE, Hive, pig and Linux with hands - on project experience in various Vertical Applications.
• Expertise in HDFS Architecture and Cluster concepts.
• Expertise in Hadoop Security and Hive Security.
• Expertise in Hive Query Language and debugging hive issues.
• Expertise in Sqoop and Flume.
• Worked with Kafka messaging services, familiar with other related messaging tools - RabbitMQ.
• Involved in implementation of Hadoop multi node cluster, installed Hadoop Ecosystem softwares, configured HDFS.
• Worked on Multi Clustered environment and setting up Cloudera Hadoop echo-System, creating jobs to get the data from RDBMS to HDFS, from HDFS to RDBMS.
• Experience in Big Data, Hadoop architecting.
• Worked on Hadoop environment (HDFS) setup, Map Reduce Jobs, HIVE, Hbase, PIG and NoSQL and MongoDB
• Software installation and configuration
• Built automation and internal tools for Hadoop jobs.
• Tableau 9.0 / Tableau 8.1, SQL Server 2008R2 & 2012, Excel, Access, Google Stack
• Worked with all kinds of Data Sources, TDE, TDS, Extracts, live connections using HBase, Hadoop HDFS, GPDB (Greenplum), data blends, joins with both relational model databases and multi-dimensional modeled data sources across heterogeneous databases.
• Experience designing complex dashboards that take advantage of all tableau functions including data blend
• Strong experience writing complex SQL and troubleshoot and tune SQL to provide the best performance
• Ability to drive insight by designing visualizations with logical and meaningful data flow
• Experience doing full life cycle development, including business requirements, technical analysis and design, coding, testing, documentation, implementation, and maintenance
• Tableau Server Administration knowledge
• Experience with Microsoft SQL Server Reporting Service, Microsoft BI Stack (SSIS/SSAS/SSRS)
• Knowledge of health data standards and architectures a huge plus
• Hands-on experience developing logical and physical dimensional models
• Experience implementing data visualization solutions using Hadoop is a pulsing, actions, and parameters
• Big Data (Map Reduce, Impala, HIVE, etc.), JIRA project management suite
• Data Modeling / Data Architecture
• Multiple Reporting Structures / Dashboards
• OBIEE/OBIA with RPD development using Star/Snow Flake Schemas / BI Publisher / DAC / OBIEE upgrade cycle expertize / BI Apps with Oracle EBS integration
• Extensive experience in building Interactive Dashboards with drill-down & drill-across capabilities using global & local Filters, Contextual Navigation, Guided Analytics, Business Rules with User Identity & Roles, Profiles & Personalization
• Expertise in creating different report format - Table, Pivot, Charts, View/Column selector, Narrative reports
• IT exposure in: SCM, Order Management, HR, Pharmaceutical, Healthcare, Insurance, Financial and Manufacturing
• Gathering Business Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing Business Intelligence information & analytical solutions - 8 Years
• Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards/Reports
• Informatica Mappings / Mapplets and Workflows with Worklets & Tasks using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) for ETL of data from Multiple Sources to Data Warehouse
• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes
• Pivoting, custom requests for Excel Export, and Fast Change and objects for Management Dashboard reporting and other KPI's.
• Strong data analysis experience and proficient in development and tuning of SQL queries, stored procedures, views, and packages using PL/SQL.
• Experience in designing Spotfire Layouts to make consistent and professional optimized look to clients. Extract, Transform and Load (ETL) / Business Intelligence strategy and implementation.
• Data mapping for ETL and Reporting Architecture. Application life-cycle development from data extraction, transformation and loading thru reporting and analysis. Business and data analysis using multiple data modeling tools including Erwin and TDR
• Multiple campaign management and marketing optimization tools.
• ETL development with SSIS, Informatica, TDR, Epiphany, SQL, perl, Shell Scripts, and QTP.
• Developed advanced and optimized SQL queries.
• Business Intelligence development with Business Object, Excel, SSRS, SSAS, and MicroStrategy.
• IT exposure initiated with Application development and web development using dBase, Foxpro, Visual Basic, C#, .Net, LISP, FORTRAN, COBOL, C, and C++, cmd, ksh and sh shell script and perl and awk programming.
• Domain expertise in Financial Services, CRM, ERP, Insurance, Supply Chain, and Health & Benef Confidential s.
• Agile and Rapid application development

TECHNICAL SKILLS:

Other skillsets: Hadoop environments - Cloudera / Hortonworks with HDF / Data Scientist / Hadoop Architect (CDH 5) / Hadoop Security Specialist (Kerberos / Sentry / ACL) / Cloud Architect (AWS) / Cloud Security Professional (CCSP) / GCP (Google Cloud Platform) / Microsoft Azure Platform / DevOps toolset with docker/container manager / Datawarehouse Architect

Hadoop Architecture related: Cloudera Hadoop / Hortonworks / Data Science Analysis / Data Visualization skills / Amazon Web Services (AWS) Architect / Windows Azure Architect / Cloud Security (CCSP) / Google Cloud Platform

Working on a POC with Google Cloud Platform: Stackdriver (Monitoring / Logging / Error Reporting), App Engine, Compute Engine, Container and Networking, storage related Bigtable/SQL, Google Cloud Platform related API Manager, Cloud Launcher and IAM & Admin activities. BigQuery, Dataproc, DataFlow and Genomics from the BigData implementation of data migration activities.

Hadoop Security related skills: Apache Sentry / Apache Knox / Apache Argus (Hortonworks)

BI Dash boarding skills: Tableau 9.3 / Tibco Spotfire / Qlikview / Sisense BI / Kibana / Splunk / Watson Analytics / Pentaho / SSRS / OBIEE / Microstrategy

ETL Expertize: Informatica BDE 9.6 / Ab Initio / SSIS / Spark / ODI / Datastage

Databases / RDBMS / NoSQL / Columnar DB / Unstructured Data / SQL related skills: Oracle, Solr, HBase, MongoDB, Casandra, Greenplum (GPDB)