Customer Service Sql Server
Resume:
SHASHANK SHIVHARE
Oracle Certified JAVA PROGRAMMER
PROFESSIONAL SUMMARY:
Oracle Certified Associate, Java SE 7 Programmer
Experience in IT industry in Software Analysis, Design, Development, Testing, Deployment and Maintenance of Web and J2EE applications.
Experience in different phases of Software Development Life Cycle (SDLC) including Design, Implementation and testing during the development of software applications.
Experience in developing and deploying applications using Web sphere Application Server, Tomcat, Web Logic and JBOSS.
Expert in Web Development using Java/J2EE technologies like Java, multithreading, JSP, Servlets, JDBC and XML/XSL.
Experience in developing applications using three tier architectural frameworks such as MVC (Model View Controller) STRUTS, SPRING framework and Hibernate.
Experience with Installing and configuring AWS cloud servers with Linux, Tomcat, MySQL, Apache, etc.
Installed and maintained NoSQL Database Mongodb.
Set up and administer Amazon servers (AWS, Linux, Apache and MySQL).
Experience designing REST APIs and developing RESTful Web Services with JAX-RX.
Design & implementing RESTful APIs, SOAP, WSDL, XSD, JSON, Web services and XML.
Well versed with J2EE Design Patterns like Singleton, Factory, Front-Controller, Session Façade, Service-Locator, Data Access Object (DAO), Data Transfer Object (DTO), MVC (Struts), Business-Delegate.
Experience using Front End Technologies such as HTML, JavaScript.
Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.
Developed a core component of Analytics with MVC frameworks - Angular and JavaScript design patterns.
Experience in developing desktop applications and Add-In for Microsoft Office.
Created prototypes of the GUI environment using iRise.
Skilled in writing technical specification documents, translating user requirements to technical specifications.
Interacted with various architects in identifying various business rules to design the Business Requirement Document (BRD).
Quick learner and excellent team player, ability to meet deadlines and work under pressure - either unsupervised or in a team.
TECHNICAL SKILLS
Language and Web technologies Core Java, Servlets, JSP, Struts, JDBC, spring, Multithreading, Web Services, UML, JQuery, Ajax, JMS
Methodology Agile, Scrum Waterfall model, Iterative development model
Tools Known Eclipse 3.x, RAD 7.0, VSS, PL/SQL Developer, IReport5.0, JMeter, Putty, WinScp3, DbVisualiser, Oracle UCM10gR3, GenMyModel,iRise.
Operating Systems Windows 2000 Professional/Server/XP Professional/NT/98/95, Windows 2003/2008 Server, UNIX.
Web and Application Servers JBoss 5.1, Tomcat 5/6, Oracle UCM 10gr3, WebSphere 5.1/6/7, AWS.
Databases and Data Storage Oracle 10g, 11g, SQL Server, Hadoop, ETL, XML Files
Version Controls Visual Source Safe, Rational Tool
Job Functions Requirement Analysis, Design, Coding, Testing, Documentation, Maintenance, Application Support, Project Management
WORK EXPERIENCES:
Calsoft Labs, Santa Clara, CA May 2015 to Till Date
Programmer Analyst -15
Constituent Satisfaction Initiative (CSI)
The scope of the overall project is to replace EyeMed's current backend system, which was developed in-house on an AS/400 system. The main reason for the migration is to provide some additional flexibility, reduce costs and improve accuracy, which they hope to do by adopting an industry standard solution. The product chosen is called Facets x` and is provided by a company called Trizetto. Up until now this product has only been used in the medical industry, so there is some customization needed for the eye care industry. Some of these customizations will be made to the core Facets product, and some will be provided as additional services outside of the core product, specifically for EyeMed. The overall project has been called Constituent Satisfaction Initiative (CSI).
Responsibilities:
Responsible for requirement capture, design and implementation.
Developed technical design documentation for major functional enhancements.
Bug fixing and Knowledge Management Sessions.
Involved in design and development of web interface using JSP and JavaScript for administering and managing users and clients.
Implemented business process, database retrievals, access of information and User Interface using Spring Framework.
Installed, configured and hosted the Tomcat app servers and MySQL DB servers on physical servers (Linux, Mac, Windows), and Amazon AWS virtual servers (Linux)
Improved code quality and coverage by adding unit test cases.
Involved in estimation based on functional specification and provided the high level & low level design.
Involved in review activities such as peer code review, test cases review and document review.
Business Component has been implemented using EJB Session Beans technology in order to provide a scalable, reliable, manageable, extensible, distributed and object-oriented framework.
Used SPRING to implement Business layer to Data access layer
Worked on XML Technologies like XML Parsers, JAXB for binding data to java objects.
Implemented various design patterns: Singleton, Data Access Object (DAO), Command Design Pattern, Factory Method Design Pattern.
Generated Class Diagrams, Sequence Diagrams with Microsoft Visio and RAD.
Wrote SQL, PL/SQL and stored procedures as part of database interaction.
Extensively used Hibernate for Object relational Mapping for data persistence.
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.
Involved in JUnit testing, bug fixing in multiple environments (DEV/INT/CERT/PROD) and reproduce bugs for fixing and code review of individual modules in the application.
Developed the Ant scripts for preparing WAR files used to deploy J2EE components.
Involved in writing of Web Services using SOAP, WSDL, deployment, configuration and testing.
Implemented log4j API for exception handling, logging of the errors, warnings, messages, stack traces, debuggers throughout the code.
Designed Frontend with in object oriented JavaScript Framework like Angular.JS.
Implemented centralized factory models to achieve MVC architecture using AngularJS
Release management and support. Participate in User Acceptance Testing during each Agile Cycle.
Review proposed test cases with technical analysts, business analysts, developers and documentation staff to ensure understanding of system requirements from a QA perspective in order to achieve a high level of quality throughout this project.
Enhanced the code according to the business requirements.
Environment: Java, spring, Hibernate, Oracle 9i, PL/SQL, Tomcat, JUnit, SVN, AWS.
Tech Bizzz Software and Web development LLP, Pune, India Apr 2013 to May 2014
Software Programmer
Property Pointer Back End System
The project was about developing a system which was developed to manage the working at backend in property pointer. It was linked with the propertypointer.com website. It enables to find the best match for the client for buying property like apartments, houses with best deals. The back end system provided access to employees of the company to carry out their work.
Bid Shipper Customer Service System
The project was to manage customer service, place bid on transport, place shipment and managing deals with local transport facilities. The system was directly linked with bidshippers.com.
Responsibilities:
Developed and implemented software efficient algorithms.
Developing and maintaining the front end functionality of websites.
Designing prototypes for apps and websites.
Used SPRING to implement Business layer to Data access layer.
Worked on XML Technologies like XML Parsers, JAXB for binding data to java objects.
Involved in writing of Web Services using SOAP, WSDL, deployment, configuration and testing.
Used Struts MVC for Web applications.
Writing cross-browser compliant XHTML, CSS & JavaScript.
Simultaneously managing several databases and reporting tools.
Performed designing, coding and testing of desktop and web applications.
Developed customized business solutions to clients in IT/Non IT industry based on emerging technologies.
Used the techniques, skills, and modern engineering tools necessary for engineering practice and implement them on existing software.
Created screen-mockups using iRise to review the requirements and provide feedback on the screen design.
Created prototypes of the GUI environment using iRise to be used by the developers during the design phase.
Designed, created, and maintained DB2 database objects.
Audited application SQL code with DB2 Explain prior to production implementation.
Developing websites that have a consistent feel and look throughout all web properties.
Worked with languages like PHP and Java as Backend.
HTML, CSS and JavaScript was used as Frontend.
Setup and hosted the Tomcat app servers and MySQL DB servers on physical servers (Linux, Mac, Windows), and Amazon AWS virtual servers (Linux)
Developing websites that have a consistent feel and look throughout all web properties.
Changing the code, software or graphics of existing websites.
Solving issues independently and liaising with business analysts and issue managers to resolve issues proactively.
Identifying and validating solution objects, functions, interfaces, dependencies, and integration points.
Involved in unit testing and testing of modules and deployment project into production servers.
Environment: Java, spring, Hibernate, Struts, Soap, Windows 7, Linux/ UNIX, PHP, MySQL, HTML, CSS, JavaScript,AWS.
OTHER INTERN PROJECTS:
Math Equation Reader (ADD -IN) Aug 2015 to Present
Thesis (Copyrighted)
https://youtu.be/0gdcHUmH3gM
Developed ADD-IN for Microsoft Word in Visual Studio 2013.
Built a Prototype model in C#.
Generated a Class to interact with Windows inbuilt functions and configuring shortcut keys.
Worked with XML to enhance ADD-IN Design.
Generated different patterns and regular expressions.
Used espeak class to synthesis the text to speech
Implemented exception handling, logging of the errors and warnings messages to avoid from unexpected crash.
To read aloud all types of math equations
Help blind people and people with learning disability to understand math better
The ADD-IN provide a simplicity which can give a big competition to existing Screen Readers like JAWS which uses MathML to read the math equations.
Environment: Windows 10, Visual Studio 2013 Professional, C#, VSTO.
California State University, Fresno May 2015 to Present
Student Assistant
Assist with student admissions process.
Managing confidential test records, fee waivers, etc.
My supervisor adores my administrative and management skills
Worked closely with students to meet their application needs
Hospital Management Software Project Jun 2013 to Aug 2013
Software Programmer
Developed patient appointment scheduling tool in Visual Studio 2010
Development and design of product was in C#
Wrote SQL and stored procedures as part of database interaction.
The application communicates with server to manage all working of hospital and linking hospitals data to the doctors and respective data to the patients.
Algorithm and design was developed in such a pattern that every hospital of the city was linked with patient details
Developed a paperless system
Environment: Windows 7, Visual Studio 2010 Professional, C#, SQL Server 2008.
Ecommerce Website Project
Developed website for tourism in city Jabalpur, India
Intended for buying and selling products over the internet.
Created websites that is user-friendly, effective and appealing.
PHP was used as backend language.
CSS, HTML and JavaScript was used as frontend.
Wrote SQL commands to work with database. SQL Server 2008 was used to support database.
Designing, implementing and supporting database development on an SQL server.
Worked with Apache Tomcat 2.2 for server.
Algorithm was developed to connect specifically people of a particular city for giving the chance to small entrepreneur
Environment: Windows 7, PHP, SQL Server 2008, HTML, CSS, JavaScript.
Java Developer (Intern) Oct 2012 to Dec 2012
Center for Research and Industrial Staff
Performance CRISP
Learned to develop an application from scratch
Used UI elements and understood the main architecture of an Android application.
Indulge in the coding of the Android. An application which was developed using java in eclipse.
Integrated camera with phonebook, worked with all types of views.
Integrated multiple systems to move data between layers of software stack.
Conceptualized, designed, developed and deployed mobile applications.
Wrote unit tests for mobile code and debugged critical application issues such as crashes.
Tested code for robustness; executed edge case, usability, and general reliability analysis.
Fixed bugs and improved application performance.
Environment: Windows 7, Java, Eclipse, PL/SQL.
Dairy Management Software Project
Developed a desktop application using Java
Net Beans was used as an IDE
Wrote SQL Commands to manage database. SQL Server 2008 was used for the database.
Algorithm was developed to manage the day to day activities on a dairy farm.
The tool enabled streamlined purchasing and selling of products for a dairy farm.
This software gave dairy farm owners to include software in their life and make their work systematic.
Environment: Windows 7, Java, NetBeans, SQL Server 2008.
EDUCATION:
Master of Science in Computer Science, California State University, Fresno, CA
Bachelor of Engineering in Computer Science, Rajiv Gandhi Technical University, Bhopal, India
CERTIFICATION
Oracle Certified Associate, Java SE 7 Programmer
Certification URL: https://www.youracclaim.com/badges/01cd0e2c-eb2c-40ce-9cbb-393331b82b7c/linked_in_profile
Reference
Ashutosh Rai - Director
Tech Bizzz Software and Web development LLP, Pune, India
********.***@*********.***
Contact: +91-879*******
Supervisor at TechBizzz
Contact this candidate