Krishna Srinivas Suryadevara

About Krishna Srinivas Suryadevara

Results-driven data professional with 16+ years of experience in designing, developing and implementing data warehousing applications across various industries, including retail, manufacturing, finance, insurance, healthcare and facility management.Certifications : Snowflake Admin snowflake Pro Azure FundamentalsTechnical Skills: • Key Skills: Data analysis, modelling, design, development and testing• Data warehousing: Snowflake, DB2, Oracle, Teradata• Data ingestion: Python, SnowSQL, Snowpipe, Databricks (PySpark), Azure ADF, Azure SQL, IBM Infosphere Data Stage• Data Storage processing: Azure BLOB storage, SQL Server, DB2, Data Lake, HDFS, HIVE, HBASE• Data transformation: DBT, macros, Databricks & SQL• Data visualization: Tableau, PowerBI• Database administration: Snowflake• Programming languages: Python, Java, UNIX scripting, Cobol • Data management: Data profiling, quality analysis, standardization, cleansing• Data Modeling: Dimensional Data Modeling, Star Schema & Snowflake Modeling, FACT and Dimensions Tables.• Orchestrations: Control-M, CA-7Snowflake experience:• Created snowflake account with appropriate edition with available regions• Setup Federation authentication using SAML using active directory• Configure SSO federation for single sign-on• Implemented SCIM for user provisioning• Enable MFA for User.• Created AD roles using service now • Created custom access roles / Functional roles and map to AD roles• Created Databases and Schemas with Access role mapping• Configured Virtual Warehouses with access role mapping• Created Snowflake users & Service account and grant necessary privileges• Resource Usage Monitoring• Backup and Recovery• Alerting and NotificationsProfessional experience:• Experience in Data extracting, Data processing & Data wrangling using Databricks, Data Lake, Python, Azure BLOB storages, SQL Server, DB2, Visual Studio and Data Warehouse cloud platforms like Snowflake, Azure SQL. • Experience in transforming the data using DBT & load into Snowflake, Creating Macros, and custom materialization of DBT.• Experience in snowflake data ingestion using Python & SnowSQL from different Data sources like DB2, Oracle, SAP HANA Databases and AWS S3 Buckets.• Experience in creating Data ETL Pipelines as per the business requirements using Python.• Experience in writing stored procedures and creating views for Tableau data consumption in Snowflake Database.• Experience in working with various structured and semi-structured data formats like delimited, fixed width,

Experience

1. Senior Software Engineer

   Adaequare Inc

   Oct 2015 — Present

Education

• Sree Datta Institute of Engineering & Sciences

  Master of Computer Applications (M.C.A.), Computer Programming, Specific Applications

  2006 — 2009

• ANDHRA LOYOLA COLLEGE

  Bachelor of Science (B.Sc.)

  2003 — 2006

Skills

• Data Warehousing
• Core Java
• C Language
• Msbi
• Xpediter
• Sql
• Ca7 Scheduling
• Unix Shell Scripting , Perl Scripting
• Ibm Db2
• Rexx
• Dimensional Data Modeling
• C++
• Teradata
• Bmc Control-M
• Easytrieve
• Cobol
• Databases
• Esp Scheduling Tool
• Endeavor
• Unix
• Data Modeling
• Oracle Database
• Ibm Infosphere Datastage V8.1 , 9.1
• Mainframe Jcl
• Extract, Transform, Load (Etl)