Harshith Pashikanti

With over three years of experience in software development and data-centric pipelines, I possess strong skills in relational databases, documentation, and publication. Demonstrating a service-oriented mindset, attention to detail, and problem-solving abilities, I handle sensitive information with utmost confidentiality and comply with security standards. Proficient in SQL development and performance tuning, I excel in Oracle, SQLServer, SSIS, Sybase, NoSQL, Python, AWS, Docker, Git, and Visual Studio. My expertise extends to data lakes, lake houses, and ELT processes, and I have competencies in Azure cloud services, AWS Glue, AWS Data Pipeline, AWS EMR, and AWS Lambda. 
 

Around 4 years of experience in Data Engineering, involved in design, construction, and maintenance of data that support the storage, processing, and analysis of data. ▪ Proficient in building distributed data solutions, data analytical applications, predictive modeling, and ETL and streaming pipelines leveraging big data technologies. ▪ Experienced in utilizing Hadoop ecosystem components, Databricks platform, and AWS services for developing data solutions. ▪ Skilled in SQL Server, MSBI, and Databricks on AWS for building data solutions. ▪ Experienced in Dimensional Data Modeling using Data modeling, Relational Data modeling, ER/Studio, Erwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling. ▪ Extensive experience in installing and configuring Hadoop ecosystem components such as Hive, Sqoop, HBase, Zookeeper, and Flume. ▪ Involved in designing and deploying multiple applications utilizing the entire AWS stack (EC2, S3, RDS, Glue, Lambda, Athena, Aurora, Dynamo DB, SNS, SQS). ▪ Skilled in working with EC2 instances ECS, EBeanstalk, Lambda, Glue, RDS, DynamoDB, CloudFront, CloudFormation, S3, Athena, SNS, SQS, X-ray, Elastic load balancing (ELB), creating auto-scaling groups. ▪ Hands-on experience in in-memory data processing with Apache Spark using Scala and Python codes. ▪ Experienced in Big data Hadoop, Hadoop Ecosystem components like MapReduce, Sqoop, Flume, Kafka, Pig, Hive, Spark, Storm, HBase, Airflow, Oozie, and Zookeeper. ▪ Proficient in building, deploying, and managing SSIS packages with SQL server management studio, creating SQL server agent jobs, configuring jobs, configuring data sources, and scheduling packages through SQL server agent jobs. ▪ Experienced with SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages. ▪ Skilled in utilizing BI tools such as Power BI and Quicksight for enhancing reporting capabilities and developing BI applications. ▪ Demonstrated capability in liaising with key stakeholders for delivering compelling business value to senior leadership and clients. ▪ Well versed in Data warehouse concepts normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints. ▪ Knowledge in Data Modeling and Data analyzing in MS SQL Server and good knowledge in query optimization. ▪ Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Indexes, CTEs, Joins, and Subqueries with T-SQL. ▪ Skilled in working with Amazon Web Services (AWS) using EC2 for computing and S3 as storage. ▪ Experienced in developing ETL data pipelines using Pyspark. ▪ Proficient in installing and setting up Hadoop Environment in the cloud through Amazon Web services (AWS) like EMR and EC2 which provide efficient processing of data. ▪ Skilled in w

Master's in computer science, The University of Texas at Arlington