Sai Krishna P.

About Sai Krishna P.

PROFESSIONAL SUMMARY:Software Engineer with hands-on experience in Information Technology with strong background in Data Warehousing, Business Intelligence, Analytics and ETL Processing.• Pursued Masters’ degree and Bachelor’s degree in Computer Science major.• Database experience using Oracle, IBM DB2, Greenplum, AWS Aurora and Snowflake.• Extensively worked and have good knowledge using SQL, PL/SQL, procedures, triggers, packages, functions, shell scripting, PERL scripting, and XML.• Deep understanding in Data Architecture, Modeling and Design development process.• Worked on AWS services EC2, s3, Athena, EMR, Step functions, CloudWatch and Glue.• Experience with stream and messaging platforms such as Kinesis and SNS/SQS.• Experience in managing Google Cloud Platform (GCP) services like App Engine, Compute Engine, Kubernetes Engine, Cloud Functions, Cloud SQL, Load balancing and BigQuery.• Worked on ETL AWS Glue using Python/PySpark to migrate data from external sources like s3, Parquet/JSON/CSV files into Snowflake DataWarehouse.• ETL experience using Informatica Cloud (IICS) and Informatica Power Center 9.1.0 and proficient in Performance Tuning of Informatica Mappings, Sessions, optimizing query performance and complex Informatica transformation like Normalizer, Transaction control, Web Service Consumer, XML, UDF’s and SCD’s.• Experience using Attunity data replication tool to transfer data and ingest into targets.• In-depth understanding of Snowflake cloud technology and hands-on experience using SnowSQL, Snowflake Clone, Time Travel, Multi-cluster and Virtual Warehouses.• Worked on real time data movement from AWS s3 in micro-batches using Snowpipe and load into snowflake. Managed Snowflake Admin activities and capacity planning.• Worked extensively with Business and power user groups to gather requirements and translate data for Reporting using Analytics tool - SAS Enterprise Guide 7.1/6.1/4.3.• Good Understanding in Hadoop Distributions File System and developed applications using Hadoop ecosystem like MapReduce, Hive, Pig, Sqoop and HBase.• Worked on IBM Mainframes by programming with Job Control Language (JCL)• Experience in Technical Project Management and skilled in streamlining operations, process improvement, Agile continuous Integration, gather requirements, capacity planning and collaborative leadership.

Experience

1. Cloud Data Solution Architect Snowflake Architect Aws Qlikreplicate

   Discover

   Aug 2021 — Present

   Cloud Data Architecture & ModernizationDesigned and led the implementation of robust cloud-based data architectures, supporting enterprise transformation initiatives. Migrated legacy systems to Snowflake and AWS, improving query performance and reducing processing time by 40%- Real-Time Data Ingestion & ReplicationArchitected streaming pipelines using Qlik Replicate for CDC from diverse on-prem databases (Oracle, Greenplum, DB2 Mainframes) to AWS S3 and Snowflake. Developed microservices to automate Qlik Replicate task creation via REST APIs (ImportTask, ExportAll, PatchEndpoints, GetTaskList), ensuring accurate, near real-time data availability for analytics and reporting- Cloud Migrations & Infrastructure ResilienceMigrated Rackspace VMs to Azure, implementing automated backups and disaster recovery configurations aligned with high-availability (HA) strategies- Secure & Compliant Data PlatformsUtilized Filebeat for efficient log shipping, managed credentials securely using HashiCorp Vault and PPM, and ensured compliance through Protegrity-based data tokenization- Observability & MonitoringEnhanced monitoring capabilities using Datadog and Grafana across AWS RDS, Qlik Replicate, Snowflake, and S3 environments. Leveraged Moogsoft for intelligent alerting and automated incident management, increasing platform resilience- Kafka Engineering for ScalabilityConfigured and optimized Kafka infrastructure for high throughput and reliability by setting replication factors, partitions, and retention policies. Ensured 99.99% uptime and consistent data delivery for distributed applications- Lakehouse & Analytics EnablementBuilt curated Silver and Gold layers in Databricks to power data exploration and downstream analytics, enabling faster business insights across teams.

Education

• Anurag Group of Institutions

  Bachelor of Technology - BTech

• University of Houston-Clear Lake

  Master's degree, Computer Science

• Jawaharlal Nehru Technological University

  Bachelor's degree, Computer Science