Sushmitha J Email and Phone Number

• Collaborating with Lab Team, understanding and providing continuous IT support for the existing workflows, and develop new APIs and applications as per the team requirements using Java and its frameworks.• Developing, Containerizing, and Deploying applications into AWS Fargate, ECS, EC2, API Gateway and Cloud Foundry with continuous integration using Docker, GIT, and Jenkins.• Cleaning up, Automating, and Migrating a large number of files with total size in Terabytes from 25 local… Show more • Collaborating with Lab Team, understanding and providing continuous IT support for the existing workflows, and develop new APIs and applications as per the team requirements using Java and its frameworks.• Developing, Containerizing, and Deploying applications into AWS Fargate, ECS, EC2, API Gateway and Cloud Foundry with continuous integration using Docker, GIT, and Jenkins.• Cleaning up, Automating, and Migrating a large number of files with total size in Terabytes from 25 local lab computers to Amazon S3 and Glacier using Python scripts.• Automating the workflows using Apache Kafka and AWS Lambda• Migrating large Postgres and Aurora databases from one account to another using Amazon Cloud formation templates with proper encryption. • Responsible for maintaining a large Oracle and PostgreSQL databases supplying data for multiple APIs and applications.• Active participant and helping team members in migrating the applications and APIs from Cloud foundry to own AWS accounts using Cloud formation templates and following Cyber Security practices. Show less

• Collaborate with Data Scientists and Stakeholders to understand their data needs and modeling requirements, perform ETL processes and provide implementation support to build their AI models and after building models deploy those into Cloud services.• Built APIs using Python3 Flask, Django, and FastAPI that substantially reduced API response time by 70% compared to traditional services.• Automated the data pipeline and models using Apache Airflow.• Aided in the transition of legacy… Show more • Collaborate with Data Scientists and Stakeholders to understand their data needs and modeling requirements, perform ETL processes and provide implementation support to build their AI models and after building models deploy those into Cloud services.• Built APIs using Python3 Flask, Django, and FastAPI that substantially reduced API response time by 70% compared to traditional services.• Automated the data pipeline and models using Apache Airflow.• Aided in the transition of legacy Monsanto data, models, and applications to the AWS cloud by:• Transitioning company data pipeline from Oracle database to RDS ensuring efficiency and security.• Transitioning Cloud Foundry Applications onto AWS Fargate.• Creating the Cloud formation templates for the services EC2, Fargate, RDS and IAM roles. Show less

• Performed data analytics and built cost models for negative revenue parts of various product lines using machine learning algorithms and statistical techniques.• Gathered and analyzed the critical factors of each product line that effects the cost by interacting with the Purchasing department, product’s Subject Matter Experts and Business users.• Created Hive tables, loaded the relevant transactional data from traditional databases using Sqoop.• Created Oozie workflows for regular… Show more • Performed data analytics and built cost models for negative revenue parts of various product lines using machine learning algorithms and statistical techniques.• Gathered and analyzed the critical factors of each product line that effects the cost by interacting with the Purchasing department, product’s Subject Matter Experts and Business users.• Created Hive tables, loaded the relevant transactional data from traditional databases using Sqoop.• Created Oozie workflows for regular jobs to automate the tasks of loading the data into HDFS.• Used Spark to do transformations and process the large volume daily transactional data for analysis• Performed data preparation, data interpretation and statistical analysis using SAS, R and Excel.• Built cost models using Machine Learning Models like Decision Forests, Linear Regression, Logistic Regression and Clustering Analysis.• Translated the statistical analysis into business recommendations and cost opportunistic discovery. Show less

• Designed and developed a database which includes core functional modules and business processes for all the cultural centers at Northern Illinois University.• Developed complex stored procedures, triggers, cursors, tables, constraints, views, and other SQL joins for SQL database.• Ran complex queries to retrieve data and ad-hoc reports from multiple tables within SQL. • Performed ETL operations using SSIS on the data received from different data sources.• Built dashboards… Show more • Designed and developed a database which includes core functional modules and business processes for all the cultural centers at Northern Illinois University.• Developed complex stored procedures, triggers, cursors, tables, constraints, views, and other SQL joins for SQL database.• Ran complex queries to retrieve data and ad-hoc reports from multiple tables within SQL. • Performed ETL operations using SSIS on the data received from different data sources.• Built dashboards, scorecards, KPI using Power BI for the department to analyze and forecast the student enrollment and graduating trends.• Created forms and reports using SQL and VBA with effective user-friendly lookups and filter functionalities. • Delivered technical, functional and user documentation and training the end-users. Show less

• Facilitated undergraduate students in math and statistics by conducting weekly sessions to 100 students throughout the term using various learning and study strategies.

Experimental Learning Center, College of Business, Northern Illinois University• Built multidimensional cubes with star schema and snowflake using SQL Server Analysis Services(SSAS). • Analyzed cubes using pivot tables by performing slicing and dicing functions on the data. • Developed SQL queries to extract, manipulate data and reporting requirements including identifying the tables and columns from which data is extracted.• Data Visualization: Used Pivot tables in Excel and… Show more Experimental Learning Center, College of Business, Northern Illinois University• Built multidimensional cubes with star schema and snowflake using SQL Server Analysis Services(SSAS). • Analyzed cubes using pivot tables by performing slicing and dicing functions on the data. • Developed SQL queries to extract, manipulate data and reporting requirements including identifying the tables and columns from which data is extracted.• Data Visualization: Used Pivot tables in Excel and Tableau to analyze insights of data.• Hosted Requirement gathering workshops, documented business process and followed the SDLC standard of the business in the project meeting. Show less