Gowri Eegaa Phone: +1-331-***-****
Mail: *****.*****@*****.***
SQL/Python Developer
IT professional with over 9+ years of experience and in-depth knowledge in implementation of on-premises and cloud applications and products. Extensive Programming and implementation experience of complex applications using Python/SQL and Java /JEE technologies
Expertise in end-to-end implementation of enterprise applications for financial and insurance institutions using SQL/Python and Java
Good experience in creating writing sub-queries to simplify complex queries involving multiple tables
Strong hands on experience in Python with the packages like Pandas and Numpy .
Strong experience in Software Development Methodology such as Agile(Scrum) Methodology, Iterative and waterfall
Experience in developing web-based applications using Python,Sql,Java,Html, Java Script etc.
Hands on experience with container-based deployments using Docker working with Docker images and Docker Hub and implementations in AWS (Amazon Web Services)
Designing and implementing various design patterns, POCs and technical modules using
Databases like MySQL, SQL (Oracle)
Application servers like Tomcat7, WebSphere.
Design patterns like DAO, DTO etc
CI/CD pipeline setup using Jenkins
Service level Testing in Web Services using Soap UI, Postman
Major contributions in solution delivery include – Overseeing the design, evaluation, implementation and support of various functional modules, review and evaluate database and application performance, feasibility studies, prototype development, integration and end-to-end Implementation
Experience in delivering using scrum methodology including Backlog and User story preparations and updates, Sprint iteration planning, User story estimates and priority, Risk assessment and retrospectives
Experience in delivering using Iterative / waterfall methodology including project task Planning, implementation, Progress tracking, daily and weekly reporting, and stakeholder and customer communications
Conduct team level meetings ensuring visibility into project progress & resolve issues involving customer effectively & efficiently. Well recognized by customers and internal organization management
Good leadership skills in deriving the best from the team, promoting teamwork and synergy in solution delivery. Provide constructive feedback and act as a mentor to the team to build high-performance team to deliver optimized technical solutions
Good in building strong relationships between distributed and diverse teams within IT and external teams including, infrastructure and business users and maintain professional relationships with peers in other corporations
Strong communication and influence skills when interacting with all levels of the organization starting with senior leadership and to the team members
CORE COMPETENCIES:
Agile methodology- Sprint planning, Scrum management, Spring reviews, Story decompositions, tacking and monitoring
Team Leadership
Private Banking, Asset and Wealth Management domain
Java, JEE, Struts, Spring boot, Hibernate, AngularJS
MySQL, Oracle, SQL Server
Weblogic Server, Websphere, Tomcat, Jboss
Cloud Solution design and development in AWS
JIRA, Azure DevOps, HP Quality control
Eclipse, STS, Visual Studio
Web Services, REST and SOAP, JSON, XML
MS Office: Excel, PPT, Word
Tortoise SVN, GIT Lab, Maven.
TOOLS and TECHNOLOGIES:
EDUCATIONAL QUALIFICATIONS:
Master of Computer Applications (M.C.A) from Sri Venkateswara University, India in 2010
TEAM LEAD RESPONSIBILITES:
Gathering business requirements and analyzing data / workflows, defining scope, financial projections and converting problem statement to well documented functional & design documents and user manuals
Handling end to end implementation of software development projects including requirement gathering, cost and effort estimates, design and implementation of Enterprise applications and products globally
Develop prototypes, Proof-of-Concepts, identifying reusable components, development of major modules and interfaces for various applications. Facilitate integration with other applications; collaborate with other teams to develop and implement Virtusa products and services
Preparation of Traceability Matrix, Monthly Metrics (Effort Variance Schedule Variance], Causal Analysis, Defect Prevention Plan, Age-wise defects Analysis & Monthly Status Reports
Release and Installation of all the major/minor Versions of multiple applications into UAT and Production. Provide deployment support and manage issues by coordinating with application teams for resolution
Track assigned work to team members, identify slippages and report to managers. Identifying, evaluate and mitigating risks in the project by re-planning activities. Communicate progress, issues and risks to leadership, escalate when necessary
Act as a mentor to junior and newly recruited team members and provide guidance on domain, technical and career goals
Proficient in test planning and estimations and Resource management throughout the entire project life cycle. Publish software test deliverables identified during each control point of SDLC- Test Strategy, Test plan, Reports
Achieving project objectives by systematically structuring the work and deliverables, delegation and periodic reviews to track progress. Responsible for project accruals, participation in internal and external audits
Onsite experience working with Global financial banks and institutions during all the stages of project lifecycle
WORK EXPERIENCE:
PROJECTS SYNOPSIS
PROJECT 5:
Project Name : MassMutual
Role : Java Lead Developer
Client : Empower
Location : Chicago, IL
Duration : From March 2021
Description: MassMutual project self-service dashboard. This project is using web API’s to Create, account, user and consolidation user interfaces .interfaces is provided flexibility to users to access their information and perform the account inactivation process.
Roles and Responsibilities:
Requirement gathering, creating technical and functional design documents.
Understanding the client’s requirements by conducting detailed discussions/meetings with clients, functional and technical consultants to collect requirement specifications, metrics, and key performance indicators.
API’s calls by using the Yamal and Swagger files to create the end points and calls the controllers.
Work on creating java API’s using microservices and maintain them to ingest real time data generated out of oracle/legacy systems.
Used Tomcat Server(local server) to deploy the application and responsible for developing integration test for an WS-hosted cloud application using test Driven Development(TDD).
Implement user authorities a management with Spring Security.
Integrated Spring Security with JDBC to manage user registration and login.
Single Sign on authentication is implemented using Spring Security and site minder so that user can sign in to Single site and browser will sign automatically to another cross domain.
Validating the API’s by using the postman
Testing the API’s using the JUNIT test cases.
Designed java API’s micro services to perform the external data ingestion process.
Involve in Planning, Estimation and Development using the Agile software development methodology.
Worked on Release Management, Code deployment to User Acceptance Testing (UAT)
used Jenkins for code Deployments.
Provide Production and UAT support for applications.
Creating the Rest API’S in AWS Environment.
Selecting the appropriate AWS services based on compute,data, or security requirements.
Experience in integration of Amazon web Services (AWS) with other applications infrastructure.
Used Amazon cloud watch to monitor AWS services and Amazon cloud watch logs to monitor applications.
Deployed the applications using Docker images.
Daily handover calls with offshore team members, knowledge sharing sessions.
Environment: Java, Spring boot, API’s Microservices, Oracle, Unix, SQL Developer, Maven, GIT, STS.
PROJECT 4:
Project Name : Volume Price Agreement (VPA)
Role : Java Developer
Client : NXP (L&T Infotech)
Location : Chennai, India
Duration : March 2017 to OCT 2017.
Description: Volume Price Agreement (VPA) is a web Application project which is primarily used by Marketing, Finance and Sales associates of NXP Semiconductors Inc. The aim of Volume Price Agreement intended to arrive at Pricing decisions and strategy. This tool is mainly used for Volume Price Negotiations by replacing the legacy VPA module exists in Vendavo. The Users will be able to create Header details for each Customer and then generate RFQ and Analysis for each part items for their customers. The Application also enables users to add Product Cost based on Part Hierarchy. The Users will be able to generate Excel Workbooks based on these records. This Excel workbook would help them analyse their negotiations and arrive at valid pricing decisions.
Roles and Responsibilities:
Implemented Different design patterns like Singleton, Factory and J2EE design patterns like DAO, DTo etc.
Developed Spring framework IOC Dependency Injection to inject Service Object using Service Design Pattern into Action classes and used Struts libraries in the JSP pages.
Developed a Controller Servlet that Dispatcher request to appropriate Action classes.
Extensively worked on Spring Bean wiring, Spring DAO and Spring AOP modules.
Developed Front End screens using JSP, HTML, CSS.
Involved in developing web components using Spring MVC Framework.
Developed the business components using VO, BO based Spring class
Communication with client on daily basis for planning and execution of tasks in a timely manner
Database access was implemented through Hibernate.
Involved in Designing, coding, unit testing and implementation.
Communicating with Client on Weekly basis for new enhancement
Involved in Requirement Gathering.
Involved in Code Review and unit testing.
Environment: Spring MVC, Hibernate 3.0, jQuery, AJAX, Apache POI, JavaScript, HTML5, JSP, CSS, Oracle SQL Developer 11g, Tomcat 7, WebSphere, Eclipse Luna, SVN
PROJECT 3:
Project Name : Under Writing-UW- Liberty Mutual Insurance
Role : Team Member
Client : Liberty Mutual (TCS)
Location : Chennai, India
Duration : JUN 2015 – May 2016.
Description: As a UI developer for developing responsive web application for Agent Task Management System in insurance domain. This application will be used by Insurance agent people for managing tasks and the workflow. We access the rest service for data and which in turn will access market services.
Roles and Responsibilities:
UI design and functional implementation
Actively involved in the design, development as part of the Agile methodology.
Developed the DAO layer for the application using Spring, Hibernate and developed various business logic.
Developed java modules implementing business rules and workflows using Spring MVC, Ioc, web framework.
Improved the maintainability of the project by implementing and improving Exception Handling and Collection API.
Implemented caching techniques, wrote POJO classes for storing data and DAO’s to retrieve the data and did other database configurations using Spring.
Writing unit test cases and code coverage through Jasmine
Handling the data and form validations using Breeze
Creating REST service to deal with market services
Communication with client on daily basis for planning and execution of tasks in a timely manner
Environment: Spring MVC, Hibernate 3.0, AngularJS, AJAX, Apache POI, JavaScript, HTML5, JSP, CSS, Oracle SQL Developer 11g, Tomcat 7, Eclipse Luna, SVN
PROJECT 2:
Project Name : ONLINE CHIT APPLICATION
Role : Software Engineer
Client : Shriram Value Services
Location : Chennai, India
Duration : Nov 2011 – May 2015
Description : ONLINE CHIT is web-based project. ONLINE CHIT aims at fundamentally changing the way people careers. It gives information about Chit, Competencies, Add Customers and Companies to their visitors and members. It shares insights about company by collecting the information from their chit and transactions, which gripes and enthusiasm for other Customers. Any user can join the chit help by customers talking about their work and their recent Schemes.
Roles and Responsibilities:
Developed Front End screens using HTML, JSP.
Involved in developing web components using Spring Frame work.
Developed the business components using spring class.
Database access was implemented through jdbc.
Involved in Designing, coding, unit testing and implementation.
Involved in Requirement Gathering.
Involved in Code Review and unit testing.
Environment: Spring MVC, Hibernate 3.0, AJAX, Apache POI, JavaScript, HTML5, JSP, CSS, Oracle SQL Developer 11g, Tomcat 7, Eclipse Luna,SVN,
PROJECT 1:
Project Name : TALKTACT
Role : Team Member
Client : Coign Edu & IT Solutions
Location : Hyd, India
Duration : Oct 2010 – OCT 2011
Description: TALKTACIT is a social Network Project. It is web-based project. TALKTACIT aims at fundamentally changing the way people advance their careers and search for jobs. It gives information about Jobs, Competencies, Salaries, Interviews and Companies to their visitors and members. It shares insights about any company by collecting the information from their employees, which gripes and enthusiasm for other job seekers. Any user can help by ANONYMOUSLY talking about their work and recent job search experience which helps others. This project mainly contains three modules like admin, moderator and user. An admin has the right to control over all system. He can also act as moderator also. He can create moderators, technical questions (which can view by user), and other rights in creating sectors, companies, positions...etc. A moderator can modify whatever the data coming from user like removing bad words. They used to manage the system properly. A User who is the key role of the system. He can view the system and gives the information about their company, interview experience, salary ratings and so on.
Roles and Responsibilities:
Developed Front End screens using HTML, JSP
Involved in development of Action classes, which is a part of Struts Frame work
Involved in writing HQL queries which makes db transactions.
Coding and Configurating in xml files like struts.xml, application-context.xml and web.xml.
Involved in Code Review and unit testing
Environment: JSP, JSTL, Struts, and Tomcat 5,6.