PRABHAKARA RAO VARANASI

PRABHAKARA RAO VARANASI

Data Architect with 15 years of experience in Data Warehousing and Database management
Kuwait
English

About Me

Data Solution Architect with 15 years of experience in Data Architecture, Modeling, Management, Integration, Warehousing, Data Mart, Data Lake, Data Governance and Business Intelligence using Transactional, Operational, …

Experience

Data Solution Architect

National Bank of Kuwait
Jan 2022 - Present · 4 years 6 months

Develop conceptual, logical and physical design for various data applications to flow large volume of data into enterprise data warehouse (EDW) and data lake
 Provide technical leadership and governance of the ODS & EDW teams and implementation of solution architecture in digital banking of NBK
 Provides detailed technical specifications and ETL documentations required in each phase of the SDLC, and complies to internal standards and guidelines

Data Engineer

National Bank of Kuwait, Kuwait
Jan 2022 - Present · 4 years 6 months

Provide architect responsibilities including road maps, leadership, planning, technical innovation, security, IT governance as part of data solution architecture.
Develop conceptual, logical and physical design for various data applications to flow large volume of data into enterprise data warehouse (EDW) and data lake.
Provide technical leadership and governance of the ODS/EDW teams and implementation of solution architecture in digital banking of NBK.
Constructed a data pipeline to process Credit Card transactions on real time data analytics cluster and detected fraudulent/suspicious transactions on the fly.
Provides detailed technical specifications and ETL documentations required in each phase of the SDLC, and complies to internal standards and guidelines.
Present and persuade the design architecture to the various stakeholders (Customer, Server, Network, Security and other teams).

ETL Architect

Overseas Chinese Banking Corporation Bank, Malaysia
Jul 2018 - Nov 2022 · 4 years 4 months

Designed & Developed data models for the Data Warehouse.
Assist in developing project plans, assigning the appropriate technical resources and cost estimations.
Ensured the data architecture is optimized for large dataset acquisition, analysis, storage, cleansing and transformation.
Design and develop high performance, robust and secure solutions based on HortonWorks ecosystems.
Provide expertise on batch & stream analytics with HDFS, Kafka & Spark.

Big Data Architect

PETRONAS, Malaysia
Dec 2014 - Jun 2018 · 3 years 6 months

Develop standards and methodologies for benchmarking, performance, evaluation, testing, data security.
Responsible for building scalable distributed data solutions using Hadoop cluster environment with AWS.
Extract real time feed using Kafka & Spark streaming and process data in the form of RDD & Data Frame and save in HDFS in various format.
Provides reviews of deliverables and identifies gaps/areas for improvement.

Tech Lead

CES Pvt Ltd – Verizon, India
Jan 2012 - Nov 2014 · 2 years 10 months

Lead and guide the ETL developers in data profiling, source-target mappings, development, SQL tunings and optimization, testing and implementation.
Developed & Enhanced Control-M drafts as per requirements.

Sr. Software Engineer

Avyaya IT Solutions Pvt Ltd – Liberty Mutual Insurance
Aug 2008 - Nov 2011 · 3 years 3 months

Responsible for ETL design, development, testing and delivery.
Developed SCD Type2 in ETL jobs for certain Dimensions.

Skills

Data Modeling 3NF Snowflake Data Warehouse (EDW) Data Lake Hive Spark PySpark Scala Kafka AWS Azure GCP Teradata Oracle MSSQL MySQL PostgreSQL Informatica SSIS BO Cognos SSRS Qlikview Power BI Bash Shell Linux Windows TFS Git SVN Erwin Enterprise Architect ETL ELT Hadoop MapReduce HDFS HBase Sqoop Pig Zookeeper Oozie Flume BTEQ FLOAD MLOAD TPUMP Fast EXPORT Control-M
Report this Profile?