Sreenath Ireni

Client: META (FACEBOOK)

• Analyzing user engagement, interactions, and behaviors across platforms to gain insights into user preferences and trends.
• Testing and user experience experiments.
• Design tests to evaluate the impact of changes to platform’s features, and user interface, and algorithms.
• Construct ETL’s to capture productivity and the data quality checks for product analysis.
• Work with stakeholders including data, design, product, and executive teams and assisting them with data related technical issues.

• Involved in setting up enterprise lake house in data bricks environment.
• Ingested the data from multiple sources like AWS RDS, Odoo, quick books, Pipedrive systems into data bricks.
• Created 20+ ETL pipelines in pyspark and reducing the data processing time by 30% and improving the accuracy for reporting.
• Consolidated and migrated 50+ reports from spreadsheets and Power BI to Tableau, improving dashboard performance and reducing manual reporting by 80%.
• Managed AWS and Data bricks access and monitored the billing as well.
• Automated weekly AWS region-to-region data replication, saving ~5 hours/week in manual effort and ensuring compliance with regional data availability requirements.

Client: CISCO, META (FACEBOOK)

• Involved as a key team member for requirement analysis during the design phase and interaction with the business user.
• Performed technical analysis, ETL design, development, and deploying on the data as per the business requirement.
• Involved in testing snowflake to understand best possible way to use cloud resources.
• Developed ETL workflows to load data into snowflake and migrated the data from oracle using python.
• Scheduled the jobs in control-m and involved in migrating the jobs from tidal to control-m.
• Developed PL/SQL packages to bring the data on incremental basis from source via DB link. Tested packages and monitored the data volume for few days.
• Used agile development environments using continuous integration and deployments.

Client: VISA, CISCO

• Imported log files of master card, baseII, visa organizations from mainframes.
• Using Golden Gate Software and injected these logfiles into hive tables by creating hive external tables for each type of log files.
• Created Hive external tables to store the GGS output. Working on them for data analysis to meet the business requirements.
• Involved in Hive performance optimizations like partitioning, bucketing and perform several types of joins on Hive tables and implementing Hive Serdes like JSON and Avro.
• Implemented several types of scripts like shell scripts, python, and HQL scripts to meet the business requirements.

• Involved in installing Hadoop Ecosystem components (Hadoop, MapReduce, Spark, Pig, Hive, Sqoop, Flume, Zookeeper and HBase.
• Imported and exported data (MySQL, CSV, and text file) from local/ external file system and MySQL to HDFS on a regular basis.
• Worked with structured, semi-structured and unstructured data which is automated in the tool Big Bench.
• Implemented Hive Generic UDF's to incorporate business logic into Hive Queries.
• Configured Spark Streaming to receive real time data from the Kafka and Store the stream data to HDFS.