We provide IT Staff Augmentation Services!

Sql Developer Resume

3.00/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY

  • Skilled Technologist possessing multiple years of experience in Analyzing, Designing, Developing the applications and Leading the Projects.
  • Experienced in leading the team in different phase of the life cycle of the project such as Analysis, Design, implementation, Automation and deployment.
  • Experienced in working with high traffic application where the load will be in half a million/minute. worked in cloud computing using AWS, OneOPS, Openstack, Gumby etc.
  • Experienced in Developing Service Oriented Architecture using REST and Webservice.
  • Used Distributed Computing like Kafka.
  • Expertise in using Search Framework like Solr.
  • Experienced in using Frameworks like Struts, Spring, Play, Spring Boot.
  • Experienced in working in NoSQL like Cassandra and MongoDB.
  • Extensive Experience in Database like Oracle, MSSQL, MySQL.
  • Used ORM technologies like Hibernate.
  • Expertise in using Splunk Logging and Dashboards.
  • Experienced in using Performance Monitoring Tools like Medusa, AppDynamics.
  • Experienced with working in the front End of the application JavaScript, JSP, HTML, Jquery, BootStrap, AmCharts, DataTable.js, D3.js, Tableau and other JS libraries.
  • Extensive Experience in using Application Servers like Tomcat, Jboss, Weblogic and Websphere
  • Experienced in working with SAP products like Hybris.
  • Experienced in migrating from SQL database to NoSQL DataBase.
  • Experienced in Improving the performance of the application by refactoring the code and tuning the Database.
  • Experienced in Writing Junit, Integration and Automation using TestNG, Mockito, Cucumber etc.
  • Domain expertise in Ecommerce, Media, Networking, Finance, Insurance, Government etc.

TECHNICAL SKILLS

Framework: Spring MVC, Spring Boot, Play Framework, Struts, Hibernate

Search: Apache SOLR

Messaging: Apache KAFKA, AMQP, ActiveMQ.

AWS: S3, R53

Cloud Technologies: AWS, OpenStack, Gummy

NoSQL: MongoDB, Cassandra

Realtime DB: FireBase

UI Technologies: JavaScript, JSP, HTML, Jquery, BootStrap, AmCharts, CSS, DataTable.js, D3.js, Tableau

SAP Hybris: Hybris, HMC, HAC, CS Cockpit, Product Cockpit

XML Related: XML, DOM, SOAP, WSDL, XSLT, XML - Schema and XPATH.

Web Service: SOAP, REST

RDBMS: SQL, Oracle, MYSQL, PL-SQL.

Build: Maven, Apache Ant

Log Monitoring: Splunk, Thread Dump Analyzer, GC log Analyzer

Performance Tool: AppDynamics and Splunk.

Automation: Cucumber, Zucchini

Continuous Integration: Team City, Jenkins

J2EE: Servlets, EJB, JDBC, JNDI

App Servers : WebSphere, Weblogic, TOMCAT and JBoss, JBoss-WildFly.

UML : Use cases, Class Diagrams, Sequence Diagrams

Version Control: GIT, Clear-case, SVN, CVS, Star Team

DB Development Tool: Toad, MySQL Workbench, SQL Query Analyzer, Advanced Query Tool

PROFESSIONAL EXPERIENCE

Confidential, Sunnyvale, CA

SQL Developer

Responsibilities:

  • Involved in the Design and development of the application
  • Analyzed and worked on Accounts, Payments, Orders, Fraud and Checkout etc.
  • Worked on integrating with many internal and third party application.
  • Used java, Spring and Rest to develop the services.
  • Responsible for writing various REST Endpoints in the application.
  • Used Service Registry for implementing SOA Architecture.
  • Used Kafka for pushing the messages in the application.
  • Used Solr for Indexing the data from the Oracle DB.
  • Splunk was used for monitoring the logs in the application.
  • Used OneOPs for deploying the application on QA /STG/ PROD Env.
  • Jenkins was used as Continuous Integration tool.
  • Worked on payment Security on the encryption and decryption part.
  • Used AES 256 and JWT Algorithm to Encrypt and decrypt data.
  • Configuration management was done through Cloud management tool - CCM.
  • Wrote Automation in the Application using TestNG and Junit Test cases
  • For Tracking the Response Time, Status Codes etc of the APIs used Medusa.
  • Used PagerDuty for tracking the Alerts on the production Environment.
  • Tomcat application server was used for building the application.
  • Maven was used for packaging the application.
  • Used Git for maintaining the code in the repository.
  • Responsible for Reviewing the code and suggesting good practice in the application.

Environment: Java, Service Oriented Architecture, Spring, Kafka, Solr, REST, Oracle, Cassandra, Service Registry, OneOps, Jenkins, Medusa, Splunk, CCM, Maven, Tomcat, Jira, TestNG, Junit, Confluence, Git, PagerDuty.

Confidential, Sunnyvale, CA

SQL Developer

Responsibilities:
  • Lead the team in migrating the project into different Services.
  • Involved in the design and development of the application.
  • Spring MVC framework and spring core was used in the application
  • Micro Services Framework like Spring Boot was used in the Application.
  • Amazon AWS S3 for storing the cookies and AWS R53 for maintaining the hosts in the application
  • Kafka was used for distributed Computing in the application.
  • Developed various REST Endpoints in the application.
  • NoSQL DB like Cassandra was used in the back end of the Application
  • Configuring the Rules in the Application was implemented by ADS.
  • Developed Alerts and pager duty to send to the Slack.
  • HTML, JavaScript, jQuery and other JS libraries was used in the UI part of the application.
  • Solr was used for search functionality in the System.
  • Maven for building, deploying and packaging the application.
  • Linux was used for deploying the applications in the virtual machines.
  • Splunk was used for monitoring and Querying the logs in the application.
  • Firebase database was used for storing the configuration in the system.
  • AppDynamics was used for performance monitoring on different Environments
  • TeamCity was used for Continuous Integration tool.
  • Gumby cloud was used for deploying the application on the VM
  • Cucumber and Zucchini Framework was used for Automating the Test cases
  • GIT distributed version control was used for code management.
  • Used Jira for tracking the user stories and defects.
  • Followed Agile and Scrum methodologies in the project.

Environment: Java, J2EE, Spring MVC, Spring Boot, Amazon AWS, Solr, Kafka, Cassandra, REST, ADS, Javascript, HTML, Jquery, Splunk, AppDynamics, Linux, Maven, Git, SQL, Cucumber, Zucchini, FireBase, JBoss, Gumby, TeamCity, Agile, Scrum, jira, Confluence.

Confidential, San Jose, CA

SQL Developer

Responsibilities:
  • Lead the team in implementing the Search functionality in the application.
  • Used Struts, Spring frameworks on the front end of the application.
  • Used Apache KAFKA for Distributed publish-subscribe messaging.
  • Used Zookeeper for storing the Configuration files.
  • Design and implemented the SOLR search from the scratch and integrated with the Prime Service Catalog Application.
  • Using SOLR Implemented SSL, Full import, delta import in the Application.
  • Used JavaScript, JSP, HTML, Jquery, BootStrap, CSS in the front end of the Application
  • Improved the performance of the application for the client Ford, which uses more than 1TB of data.
  • Automated the data load using Spring Poller.
  • Used Cassandra for persisting the Entitlements data.
  • REST web service call was used for accessing the Application.
  • Used Cisco Cloud for IAAS, PAAS and SAAS.
  • Wrote Complex SQL queries to retrieve the Entitlement details from the Application.
  • Refactored Most of the Application and deployed on separate jars, to enable easy deployment to the client.
  • Used MS SQL and Oracle on the database side of the application.
  • Apache Ant for building the application.
  • Used Apache Jboss and Apache WildFly Servers for deploying the Application.
  • Improved the performance of the application by removing the unnecessary logic in the application and altering the queries.
  • Used Splunk for monitoring the logs in the application. Used Thread dump Analyzer and GC Log Analyzer for analyzing the thread dumps.
  • Jenkins was used for monitoring the Build
  • Supported several clients like bosch, ford, Boeing etc in using the application.

Environment: Java, J2EE, Struts, Spring MVC, Spring Boot, SOA, Apache SOLR, Apache KAFKA, Apache Zookeeper, Cassandra, Oracle, SQL, Cisco cloud, SVN, REST Web Service, JavaScript, JSP, HTML, Jquery, BootStrap, CSS, DataTable.js, MS SQL, Tomcat, Apache Ant, Unix, SQL Server Studio, Splunk, Apache Jboss, Apache WildFly, Jenkins, Eclipse.

Confidential, San Francisco, CA

SQL Developer

Responsibilities:
  • Lead the team for migrating the data from RFO DB to hybris DB.
  • Built the E-commerce application and interacted with the business to gather the requirements.
  • Used Java, Spring MVC and Hybris to implement the Application.
  • Developed the Service Oriented Architecture for accessing the DB and internal Application.
  • Used Jquery, JSP, Tags, and HTML in the Front end of the Application.
  • Used Solr for indexing the data in the application.
  • Used REST Webservice to interacting with the Enterprise service that interacts with other third party and internal application to retrieve the data.
  • Used Unix on deploying the hybris in QA,STG and prod environments.
  • Used maven for building the SOA Application.
  • Used ActiveMQ for storing the messages in the Queue.
  • Experienced in using hybris technology like hmc, hac, cscockpit, productcockpit.
  • Used hibernate in the external applications to interact with DB.
  • Experienced in writing SQL and Flexible search Queries.
  • Worked on interacting with third party Application like QAS (Address Validation), LITLE (credit card validation) and Avalar (Tax Calculation).
  • Used MongoDB in the back end of the legacy application.
  • Used Splunk for analyzing the logs on different environment.
  • Experienced in hybris encryption keys. Generated new keys and migrated it.
  • Used MS Data base and Hybris Data base in the back end of the Application.
  • Analyzed the models, items.xml and hybris DB and mapped with the RFO application for data migration.
  • Lead the PCI associated task and penetration report task on the hybris side.
  • Experienced in writing impex to load the data in the hybris DB.
  • Wrote Integration test and Junit Test for validating the application.
  • Used SonarQube for validating the Code in the application.
  • Followed the Agile methodology in building the application.
  • Apache Ant was used for building the Application and GIT as repository.
  • Lead the PCI integration in the application.

Environment: Java, J2EE, Spring MVC,SOA, Maven, REST Webservice, Apache Solr, Active MQ, Hybris, HMC, HAC, JQuery, JQuery Tag, JSP, HTML, Sonar Qube, CSCockpit, Product CockPit, Hybris DataBase, MS SQL, GIT, Tomcat, Apache Ant, Splunk, Unix, SQL Server Studio.

We'd love your feedback!