Sai Likith

About Sai Likith

Overall 8+ years of Professional IT experience in the Design & Development of applications using Python, Java, SQL, and NoSQL databases. • Extensive involvement in system analysis, design, development, and implementation of web-based and client/server applications using HTML, CSS, JavaScript, Java/J2EE, JDBC, XML, Python, Django, PHPs. • Experience in Multi-Tier circulated Enterprise applications. • Experience in execution of Python web frameworks like Pylons, Web2py, and Python Servlet Engine (PSE). • Experience in working with python editors like PyCharm, PyScripter, PyStudio, and used Pylint extensively. • Have good Knowledge of Agile Methodologies (Scrum) and experience in using APIs\'s REST, CRUD, SOAP. • Has good experience in Automation Testing using Selenium. • Good Experience in Error and Exceptional handling and debugging. • Good experience in Shell Scripting, SQL Server, Unix, and Linux. • Researched new techniques to develop the application in salesforce like lighting, integration with social media, and also with other applications. • Used ticketing systems like Bugzilla and Jira. • Worked with relational databases like SQL database and Teradata according to the need of the client. • Experience with migration of data from excel to SFDC through apex data loader such as import, export and update the data. • Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems which includes loading nested JSON formatted data into snowflake table. • Used Wireshark and Fiddler2 to debug and see what data and headers are flowing back and forth. • Hands-on experience on AWS, GCP (Google Cloud Platform). • Created EBS volumes for storing application files for use with EC2 instances whenever they are mounted to them. • Wrote and executed various MYSQL database queries from python using the python-MySQL connector and MySQL dB package. • Testing and troubleshooting the Force.com APIs, such as customizable soap headers, debug logs for API traffic, backward compatibility testing with previous API versions, and single sign-on integration within the salesforce application by the workbench. • Define virtual warehouse sizing for Snowflake for a different types of workloads. • Have good Knowledge of ETL and hands-on experience in ETL. • Experienced in Working on Big Data Integration and Analytics based on Hadoop, Spark, and No-SQL databases like HBase and MongoDB.

Experience

1. Python Pyspark Developer

   USAA

   Oct 2019 — Present · TX, US

   Worked on building PySpark algorithms for different aggregations of data based on the specifications. • Involved with performance and process enhancement of the PySpark framework. • Developed integration checks around the PySpark framework for Processing of large datasets. • Worked on migration of PySpark framework into AWS Glue for enhanced processing. • Wrote various automation scripts for automation of data processing on AWS Glue. • Developed data warehouse model in snowflake for over 100 datasets using whereScape. • Worked on Scripting CloudFormation Templates to auto provisioning of resources. • Worked of various Quality control checks for data processing using Spark SQL. • Build a data processing algorithm for incremental processing of data that’s aggregated each week. • Wrote ETL jobs to read from web APIs using REST and HTTP calls and loaded into HDFS using java and Talend. • Worked on data transformation like cleaning, partitioning of data for enhanced processing of data. • Worked on setting up of SEE5 data mining server on AWS for pattern finding in the data • Implemented Change Data Capture technology in Talend in order to load deltas to a Data Warehouse. • Created and maintained reports and dashboards to provide fast access to key business metrics. • Enhanced apex class and Visualforce page to create a custom related list, showing activities for selected contacts or clients. • Wrote an apex trigger on contact for cross object field update for reporting purposes. • Involved with migration of AI based project from Google Cloud Platform into AWS. • Build Schedule based AWS Lambdas for automatic build and run of data processing pipelines • Worked on building a standalone UI tool using wxPython for creating custom requirement JSON templets to feed into AWS Glue for ETL processing of data.