Rakesh G

Datawarehouse Designer


Datawarehouse Designer

Education Level:


Will Relocate:



PROFILE IT Leader with 25 years of experience in Architecting Designing Delivering and leading Business Intelligence, ETL Data Sciences, Data Management and Data Warehousing projects in various roles .Consulting and industry experience leading projects for world's largest businesses. Lead and delivered multiple projects for complex and challenging Data Warehousing ERP Business Intelligence ETL and data quality projects within time and budget using Agile and waterfall methodologies . Architected Designed and setup mission critical infrastructure for high availability and failover Scenarios to support BI ETL and Data warehousing applications. Led the design and development of Enterprise wide shared services for BI ETL, Data warehousing Data Marts and DevOps . Developed strategies for target state BI, Data mart Data warehousing ETL, Data Quality and data patterns for the enterprise. In the present role working as Chief architect and Lead for Business Intelligence and Analytics Center of Excellence providing thought leadership and delivering multiple BI, ETL, Data Warehousing Data Mart and Infrastructure projects and Support . Leading troubleshooting team for any complex production issues across all BI and data preparation tools . Prolific trainer and frequent Speaker for BI Data Warehouse ETL Data Preparation and Integration KEY CORE QUALIFICATIONS : * BUSINESS INTELLIGENCE/ DATA INTEGRATION SPECIALIST * COMPLEX DATA WAREHOUSE DESIGNS BIG DATA LAKE RELATIONAL / BIG DATA MPP AND AWS SOURCES (REDSHIFT / S3 / PRESTO/SPARK/ POSTGRESS /NETEZZA) * MULTI SOURCE DATA PREPARATION WORKFLOWS AND REAL TIME CONNECTIVITY TO BI TOOLS * AWS INFRASTRUCTURE AND ARCHITECTURE ( BEANSTALK / EC2 / S3 / EMR /SQOOP/ATHENA / DOCKERS) * BIG DATA INTEGRATION AND DEVELOPMENT ( HIVE / SPARK / PRESTO/ AVRO/ PARQUET FORMATS / NIFI/ ATHENA ) * DESIGNING COMPLEX ARCHITECTURES SERVICES AND INFRASTRUCTURE FOR DATA SERVICES AND BI * DATA VISUALIZATION AND INTEGRATION WITH MACHINE LEARNING USING R PYTHON SAS * MISSION CRITICAL INFRASTRUCTURE DESIGN AND SETUP FOR HIGH AVAILABILITY FOR BI DATA PREP AND DW PROJECTS * BUSINESS OBJECTS, MICROSTRATEGY, TABLEAU, SPOTFIRE, INFORMATICA, MEGA, MDM ALTERYX TOAD DATA POINT THOUGHTSPOT, NARRATIVE SCIENCES * PREDICTIVE ANALYTICS PYTHON, API INTEGRATION AWS API * INTEGRATIONS WITH SSO (SAML) / CICD / PAM / PUPPET / CHEF / MONITORING (DYNATRACE/TIVOLI/NETCOOL) /ELASTICSEARCH /ELK / MOBILE / AUTOSYS/NARRATIVE SCIENCES * DESIGN DEVELOPMENT OF SERVICES / INTERFACES USING JAVA / PYTHON/ UNIX SHELL / WINDOWS BATCH / REST SOAP BASED WEB SERVICES DEVOPS * BI ETL DATA PREP TARGET STATE TOOL SELECTIONS FOR PERFORMANCE REAL TIME AGILE DEVELOPMENT ( PAXATA/ ATSCALE / KYVOS / APACHE ARROW / CLEARSTORY / ZOOMDATA TRIFACTA) * RESOLVING COMPLEX PRODUCTION ISSUES FOR BI / DATA PREP TOOLS PROJECTS IN THE ENTERPRISE * LEAD TEAMS RANGING FROM 5 TO 20 TEAM MEMBERS




Companies I like:

Amazon, Capital one , cloud