Sai Sruthi Email and Phone Number

Designed, developed, and maintained data integration programs in Hadoop and RDBMS environment with bothRDBMS and NoSQL data stores for data access and analysis.• Used all major ETL transformations to load the tables through Informatica mappings.• Created Hive queries and tables that helped line of business identify trends by applying strategies on historical databefore promoting them to production.• Installed Hadoop, Map Reduce, HDFS, AWS and developed multiple Map Reduce jobs in PIG and Hive for datacleaning and pre-processing.• Implemented solutions for ingesting data from various sources and processing the Data-at-Rest utilizing Big Datatechnologies such as Hadoop, Map Reduce Frameworks, HBase, Hive.• Implemented Spark GraphX application to analyse guest behaviour for data science segments.• Exploring with the Spark improving the performance and optimization of the existing algorithms in Hadoop usingSpark Context, Spark-SQL, Data Frame, Pair RDD's, Spark YARN.• Worked on batch processing of data sources using Apache Spark, Elastic search.• Involved in converting Hive/SQL queries into Spark transformations using Spark RDDs, Scala.

Evaluate, extract/transform data for analytical purpose in a Big data environment. Involved in designing ETLprocesses and developing source to target mappings.• In-depth understanding of Spark Architecture including Spark Core, Spark SQL, Data Frames.• Developed spark application by using python (pyspark) to transform data according to business rules.• We have worked on many ETL's creating aggregate tables by doing many transformations and actions like JOINS,sum of the amounts etc.• Worked with building data warehouse structures, and creating facts, dimensions, aggregate tables, by dimensionalmodeling, Star and Snowflake schemas.

Responsible for building scalable distributed data solutions using Hadoop.• Designed and oversaw implementation of large-scale parallel relation-learning system.• Installed and configured Pig for ETL jobs and made sure we had Pig scripts with regular expression for datacleaning.• Creating Hive external tables to store the Pig script output. Working on them for data analysis to meet the businessrequirements.• Developed pipeline jobs to process the data and create necessary Files.• Involved in loading the created Files into HBase for faster access of all the products in all the stores without takingPerformance hit.• Used Zookeeper for providing coordinating services to the cluster.• Wrote Spark streaming applications to consume the data from Kafka topics and write the processed streams onHBase.

Work with functional colleagues to develop interactive dashboards and management reports using businessintelligence software.• This includes data quality, data management, data policies, business process management, and risk managementrelated to the processing of business data.• Performed exploratory data analysis for health extractions in Python (Pandas, NumPy & Plotting libraries).• Objects involved in creating a database, such as tables, views, procedures, triggers, functions, etc. that use T-SQLto provide definitions and structures to efficiently manage data.• Create and publish custom interactive reports and dashboards and schedule reports in Tableau Server.• Create action filters, parameters, and calculation sets to prepare dashboards and worksheets in Tableau.• Developed Tableau visualizations and dashboards using Tableau Desktop.

Involved in all the phases of the life cycle of the project from requirements gathering to quality assurance testing.Created J Unit test cases and created set up manuals and user guides. Involved in Units integration, bug fixing andUser acceptance testing with test cases.• Implemented MVC architecture using Apache STRUTS framework. Designed the front end using JSP, TagLibraries and JavaScript. Designed and developed framework components, involved in designing MVC patternusing Struts framework.• Worked closely with testing groups for module and integration testing. Developed batch processes to perform thedaily updates with Spring Batch Module Automation testing using J unit.• Developed hibernate DAO Classes using Spring MVC Template, worked with Hibernate for object relationalmapping and connection management.• Used Angular Promise, Angular Custom directives, Angular custom services, Angular to SOAP to Spring callsinvolve in implementation of REST and SOAP based web services