Yashwanth Gurram

• Design, develop, and test HTML5, CSS3, Bootstrap, JavaScript, and React.Js that meet accessibility and web browser standards for websites.
• High-level proficiency in developing REST APIs using Java & Spring boot.
• General understanding of software development lifecycle from planning to deployment.
• Experience consuming, building, and deploying APIs and applications.
• Designed CSS templates for use in all pages on the website working with CSS Background, positioning, text, border, margin, padding, and table.
• Applied optimization techniques to reduce page size and load times to enhance the user experience using sprites.
• Developed the user interface by using React JS for SPA development.
• Implemented ReactJS code to handle cross-browser compatibility issues across browsers.
• I worked on using React JS components, forms, events, keys, router, and animations.
• Worked on responsive design and developed a responsive website that could be served to desktop, tablet, and mobile users using React.js.
• Maintained states in the stores and dispatched the actions using redux.
• In Phase Two, worked closely with the Back-End team to display data using the Custom Components, library Components, and Redux.
• Used middleware, Redux-Promise, in the application to retrieve data from the backend and to also perform RESTFUL services.
• Created and used reducers that received said actions to modify the store state tree.
• Worked with backend engineers to optimize existing API calls to create efficiencies by deprecating unneeded API calls.
• Called the Restful web services calls for POST, PUT, DELETE, and GET methods.
• Used object-oriented programming concepts to develop Ul components that could be reused across the web application.
• Extensively used Git for version control and regularly pushed the code to GitHub.
• Used JIRA as the bug tracking system to track and maintain the history of bugs and issues on everyday basis.
• Worked with the Jest unit test framework to write unit tests for JavaScript code.

Environment: HTML 5, CSS3, Sass, JavaScript, Bootstrap, React JS, Redux, ES6, Node.JS, Typescript,Jest,GIT,JSON,Java,SpringBoot,Figma.

• Proficient in crafting reporting dashboards, I have conducted extensive data mining and analysis to gain insights into customer purchasing patterns.
• Utilized Tableau to develop real-time dashboards for visualizing and monitoring crucial metrics, incorporating A/B test processing with both external and internal data sources.
• Collaborated closely with the marketing team to analyze campaign data, undertaking segmentation and cohort analysis.
• Designed MySQL table schemas and implemented stored procedures for extracting and storing customer purchase and session data.
• Extracted data from MySQL databases, employing Python packages such as Pandas and NumPy to validate and identify inconsistencies.
• Played an integral role in defining metrics, calculating sample sizes, and verifying statistical assumptions to evaluate new interface features.
• Conducted statistical analysis, including hypothesis testing, regression analysis, and confidence interval calculation using R, aiming to enhance click-through rates and sales. Developed web applications for ad-hoc interactive dashboards.
• Conducted exploratory Data Analysis using Tableau and Python libraries (Matplotlib, Seaborn) to discern trends.
• Developed scripts to transfer data to Hadoop HFS from various sources like AWS S3, AWS RDS, Web APIs, and MongoDB NoSQL databases.
• Employed Big Data tools like Spark and Hive to analyze large datasets up to 2TB stored in Hadoop HSDF, performing filtering and aggregation with SparkSQL based on Spark Data Frame.
• Created Python scripts for data preprocessing tasks in predictive modeling, including handling missing values, label encoding, and feature engineering.
• Implemented machine learning models such as decision trees and logistic regression to forecast revenue from returning customers, aiding in the formulation of effective promotional strategies by the marketing team.
• Effectively communicated key data findings to multiple stakeholders using tools such as MS PowerPoint, Tableau, and Jupyter Notebook to support data-driven decision-making.

Environment: Python, R, SQL, Bash, NumPy, Pandas, TensorFlow, Matplotlib, Seaborn, Plotly, MySQL, PostgreSQL, MS SQL Server, MongoDB, Hive, Tableau, Hadoop, Hive, Apache Kafka, Jupyter Notebook, Excel, Jira, Git, Docker, Kubernetes

• Engaged in analyzing, designing, and documenting business requirements alongside data specifications. Supported data warehousing extraction programs, end-user reports, and queries.
• Collaborated with Business analysts to grasp data requirements, ensuring the delivery of high-quality data to customers.
• Executed numerous ad-hoc data pulls for business analysis and monitoring through SQL scripting.
• Formulated monthly and quarterly business monitoring reports using Teradata SQL queries, employing System Calendars, Inner Joins, and Outer Joins to extract data from multiple tables.
• Crafted BTEQ scripts in Unix via Putty, leveraging cron-tab for batch script automation and executing scheduled Unix jobs.
• Conducted thorough verification and validation to ensure the accuracy of data in monthly/quarterly reports.
• Analyzed and validated data within the Hadoop Lake by querying through hive tables.
• Generated reports and charts using Hive Query Language, highlighting discrepancies in lake data loads.
• Proficient in JSON format data, conducting source and target validations utilizing aggregations and null validity functions.
• Created multi-set tables and volatile tables from existing tables, optimizing performance by collecting statistics.
• Developed Teradata SQL scripts incorporating RANK functions to enhance query performance for large tables.
• Extensive experience in performing dual data validation on critical reports in collaboration with other analysts.
• Designed compelling visualizations using Tableau software, publishing, and presenting dashboards across web and desktop platforms.
• Implemented point-of-view security measures on Tableau dashboards to ensure visibility across various organizational levels.
• Designed and deployed reports with features such as drill-down, drill-through, and drop-down menus, and parameterized and linked reports within Tableau.

Environment: Teradata SQL Assistant, Teradata, Teradata Loading utilities, Python, Campaign, Hadoop, Hive, UNIX Shell Scripts, Tableau, MS Excel, MS Power Point.

• Expertise in key deliverables, including Project Plans, Business Requirement Documents (BRD), Functional Requirements, Use Cases, and System Sequence Diagrams.
• Ability to support multiple ongoing projects in a fast-paced environment, while ensuring high-quality deliverables.
• Strong analytical and problem-solving skills to design effective solutions that meet business requirements.
• Experience in developing modular front-end components and building responsive web experiences using HTML5, CSS3, and JavaScript.
• Proficient in Agile methodologies, with knowledge of Scrum stories and sprint planning (good to have).
• Capable of working independently and collaboratively, within a team environment, to achieve project goals.
• Experience in designing relational databases and deploying cloud applications for scalable solutions.
• Analyzed and prioritized user and business requirements, as well as system requirements, that were included while developing the software.
• Prepared high-level logical data models and BRDs (Business Requirement Documents), supporting documents containing essential business elements, detailed definitions, and descriptions of the relationships, to analyze and document business data requirements.
• Developed the ability to utilize point-of-sale data, transactional data, and market basket data to better understand business trends and help develop plans to meet changing requirements.
• Created UML diagrams, like sequence diagrams, activity diagrams, and process flow diagrams, to elaborate on the new processes using Rational Rose.

Environment:

UML, Waterfall, Agile, SDLC, Object-Oriented Analysis and Design (OOAD), Rational Rose, Microsoft Visio, PowerDesigner, Oracle/PL/SQL, Java, .NET.

• Worked with Agile methodology and actively participated in Scrum meetings as a part of SDLC, to produce quality deliverables within time.
• Develop the Ul component architecture for the developer framework using Angular 7, Typescript, HTML5, CSS3, and Bootstrap.
• Created custom, self-contained, reusable, and testable Angular 7 modules, controllers, directives, and services to implement key functionalities for customer account summary.
• Used Angular 7 Http services for asynchronous validations for the input fields of the forms with the data existing in the database.
• Took part in setting up the routing configuration using an Angular 7 router for various views and sub views.
• Worked simultaneously in both production and development teams and took part in designing and developing dynamic web.
• pages using HTML5, CSS3, Bootstrap, SASS, JavaScript, jQuery, and Angular 7 for single-page applications.
• Worked on customizing the Bootstrap classes using CSS preprocessors like SASS.
• Worked on the enhancements of the navigation and menu buttons into responsive features using Bootstrap Nav-Default class and the collapse button.
• Used AJAX calls to consume RESTful web services to fetch data and implement asynchronous communication with the server side, and then rendered the data on Prime NG data tables.
• Worked on creating Angular custom pipes to sort the history of various customers in order of date, year, and month,
• Used Hibernate 4 to store the persistent data as an object-relational mapping (ORM) for communicating with the database.
• Used a microservice architecture with Spring Boot-based services interacting through a combination of REST to build, test, and deploy identity microservices.
• Worked on latest features of Java 8, like lambda expressions and functional interfaces.
• Developed Spring MS Message listeners to process messages synchronously between new services and legacy services.
• Developed the DAO layer for the application using Spring and Hibernate and developed various business logic and reports.
• Used GIT as a version control tool for effectively managing the code changes and my experience with Agile/Scrum methodology.
• Worked in a CI/CD environment with Jenkins, Maven, AWS and Terraform

Environment: Java 8, HTML5, CSS3, Bootstrap, JSON, TypeScript, Angular 4, MongoDB, Spring security, Spring Boot, SASS, Hibernate ORM, Spring AOP, Karma, Jasmine, Jenkins, AWS, Prime NG, Agile, Scrum, Jira, Junit, SoapUl, REST, GIT, Tomcat.