Oracle Sql Developer Resume
New, JerseY
SUMMARY:
- Overall 6+ years of IT Experience in experience in all phases of Software Development Life Cycle (SDLC) including analysis, design, implementation, integration, testing and maintenance of applications using Appian, JAVA and J2EE technologies.
- Experience on Multiple BPM Platforms and Expertise in Appian 7.9/16.3/17.1
- Hands on experience on the Appian tool and able to design and develop process workflow, plug ins, tempo, SAIL components and integrating external services like database, web services.
- Good Knowledge in Spring frameworj - Spring IOC,Spring MVC,Spring AOP and Spring Webflow.
- Proficient in database design and coding database objects that include tables, triggers,
- Stored Procedures, Functions, Indexes and Sequences.
- Good exposure in development of web applications using java technologies Core java, Servlets, JSP, Spring, JAXB, Web services - SOAP, REST and Apache Http Client and ORM tools like Hibernate and JPA.
- Designed and implemented several cross-cutting features for a cloud-based, data
- Platform that allow business user to build, execute and evolve process-based business
- Applications without having to write code.
- High ability to work on SOA and Agile projects.
- Good Knowledge on integrating with AWS and AZURE platforms.
- Good experience in coding using interfaces Multithreading, Reflection.
- Good Knowledge in Tomcat, WebSphere servers.
- Solid exposure on Apache velocity templates and Xpath technologies.
- Strong Experience in working with Relational databases like MS SQL Server and MySQL and proficiency in writing complex SQL queries PL/SQL programs and tuning of queries.
- Good in web based client-server Architectures and Frameworks such as Struts and Spring.
- Experience in design, development and deployment of enterprise applications for J2EE platform using JAVA, J2EE, Hibernate 3.0, Springs, JPA, Web Services, EJB 3.0, and XML JavaScript, SQL, HTML.
- Having experience in low level design and reengineering of java projects. This includes extensive knowledge of Spring Core/ Spring Framework, Spring MVC, Web services (Soap, REST).
- Excellent interpersonal capabilities & maximum contribution to attain the team goal.
TECHNICAL SKILLS:
Languages: Java, C, C++, HTML, DHTML/HTML 5, SQL.
BPM Tools: Appian 7.9/16.3/17.1 , PEGA, BIZAGI
Java Technologies: JSP, JDBC, Servlets, JSF, JNDI, JDBC, EJB, JMS, Java Beans, SOAP, JAXP, JSTL,AWT, Swings, ILOG, JXPath, Xpath, JAXB, Spring, RMI, EJB, JMS, JPA, Hibernate, Web services, WSDL, Unix Shell Scripts, Multi-threading, Apache Wicket.
Frame Works: Struts 1.x/2.x, Hibernate 3.x, Spring 2.5/3.0/4.0, Angular JS, Backbone JS
XML Technologies: XML, DOM, XSL, XSLT, XPath, SOAP, RESTful
Web Technologies: HTML, CSS, XHTML, DHTML, JavaScript, Backbone JS, Angular JS, Node Js, RESTful, AJAX, DOJO, BootStrap, JQuery.
Servers: IBM Web Sphere, Apache Tomcat, JBOSS, BEA WebLogic
RDBMS: Oracle 9i/10g/11g, DB2, MySQL, MS SQL Server 2008/2010/2012.
Tools: Eclipse, IBM RAD, CVS, SVN, Jira, Toad, JBuilder, JDeveloper, Ant, Maven
Concepts: UML, Design Patterns.
PROFESSIONAL EXPERIENCE:
Confidential, OH
Appian Developer
Responsibilities:
- Created BPM workflows in Appian using the process modeler.
- Involved in the designing & implementation of modules.
- Create Appian Records, Tempo Reports, and Portal Report .
- Created tempo enabled forms using SAIL, design DB schema using nested CDT.
- Developing Tempo Record, Tempo Reports using including Grid Layouts for the record dashboards.
- Work on Document management and Data Management.
- Handling Appian Packaging and deployment.
- Appian BPM professional with rich Appian Development experience, working with
- Leading professional services firms.
- Take part in all the Agile activites and taking part in Version One for user stories.
- Fixing & issue resolution for the application
- Designed database schemas with complex entity relationships
- Worked on the Implementation of system as an independent component to be supported/integrated with Appian based BPM applications to deliver management capabilities using Appian 7.5 SAIL features such as Record Types, Record dashboards, SAIL Reports, Actions and SAIL forms
- Used Appian 7.3 version for Development of this application and now it has been upgraded to Appian 7.5 version and leveraging SAIL form features
Environment: Appian 6.X, 7, X, Appian Process Designer, Tempo, Workflow, DMS, Feeds, Security, LDAP, Web Services, JBOSS, CDT, JS, Eclipse, Smart Services, Forms, Mobile Forms, KDB, Java, Oracle, SQL Server, Appian and legacy application integration with appian web services.
Confidential, New Jersey
Oracle SQL Developer
Responsibilities:
- Works with other business technology teams to understand requirements and patterns and ensure consistency in design across applications built on the Appian platform
- Hands on coding and development experience on Appian BPM platform.
- Define, design, and develop Appian / BPM shared components by doing a quick POC to prove the value add .
- Updated and Cleaned up the database as per the requirements, redesigned the forms to be more user friendly, added new functionality to the form as well as improve on the notification package, process and security
- Perform the detailed analysis of the business requirements provided, for Appian development
- Helps define and drive application standards and best practices across the Appian /BPM platform.
- Handled the Approval form workflow and notifications.
- Provided the Dashboards and to track the measure the impact of external innovation activities.
- Requested the form for dynamic content rules
- Design and Development of Appian applications
- Unit Testing of application components
- Help on-board new Appian applications in Appian platform
- Build and deploy of applications Help Review application design and code review
- Defect Fixing & issue resolution for the application developed.
- Created different areas to be displayed in the form, for each user group, depending upon the contract category in the Form.
- Involved in the different types of Reports, Rules and Interfaces.
- Involved in different type of validations in the Work flow Process
- Developed the SAIL form interfaces.
- Involved in adding the members in different type of User Groups.
- Created and modified CDT's.
Hadoop Developer
Responsibilities:
- Installed and Configured Apache Hadoop clusters for application development and Hadoop tools like Hive, Pig, Oozie, Zookeeper, HBase, Flume and Sqoop.
- Implemented multiple Map Reduce Jobs in java for data cleaning and pre-processing.
- Development pipeline designs and local, state and federal pipeline relocations.
- Worked in a team with 30 node cluster and increased cluster by adding Nodes, the configuration for additional data nodes was done by Commissioning process in Hadoop.
- Importing the data from the MySQL and Oracle into the HDFS using Sqoop.
- Developed Pig Latin scripts to extract the data from the web server output files to load into HDFS.
- Loading data from different source (database & files) into hive using Talend tool.
- Used Pig as ETL tool to do Transformations, even joins and some pre-aggregations before storing the data onto HDFS.
- Services like EC2 and S3 for small data sets.
- Used Apache kafka to get the data from kafka producer which in turn pushes data to broker.
- Written robust/reusable HiveQL Scripts and UDF’s in Hive using Java.
- Experience developing Splunk queries and dashboards targeted at understanding application performance and capacity analysis..
- Designed and built unit tests and executed operational queries on HBase.
- Built Apache Avro schemas for publishing messages to topics and enabled relevant serializing formats for message publishing and consumption.
- Implemented a script to transmit information from Oracle to HBase using Sqoop.
- Worked on migrating MapReduce Python programs into Spark transformations using Spark
- Experience in working with NoSQL database HBase in getting real time data analytics using Apache Spark with Python.
- Installed Oozie workflow engine to run multiple Map Reduce, HiveQL and Pig jobs.
- Implemented a script to transmit information from Webservers to Hadoop using Flume.
- Used Zookeeper to manage coordination among the clusters.
- Used Apache Kafka and Apache Storm to gather log data and fed into HD FS.
- Developed Scala program for data extraction using Spark Streaming.
- Setting up and managing Kafka for Stream processing.
- Created Produce, consumer and Zookeeper setup to Kafka replication.
- Integrate Splunk with AWS deployment using puppet to collect data from all EC2 systems into Splunk
- Experienced with batch processing of data source using Apache Spark and Elastic search.
- Experienced in implementing Spark RDD transformations, actions to implement business analysis.
- Implemented Spark using Scala and Spark SQL for faster testing and processing of data.
- Created and maintained Technical documentation for launching HADOOP Clusters and for executing Hive queries and Pig Scripts.
Environment: Hadoop, MapReduce, HDFS, Hive, Cloudera, Core Java, Scala, SQL, Flume, Spark, Pig, Sqoop, Oozie, impala, Pyhton, AWS, HBase, Kafka, Cassandra, ETL, Oracle, Unix.
Java Developer
Confidential
Responsibilities:
- Involved in coding using Java Servlets, created web pages using JSP's for generating pages dynamically.
- Involved in developing forms using HTML.
- Developed Enterprise Java beans for the business flow and business objects.
- Designing, coding and configuring server side J2EE components like JSP, Servlets, Java Beans, XML.
- Responsible for implementing the business requirement using the Spring core, Spring boot and Spring data.
- Extensive use of Struts Framework for Controller components and view components.
- Learned XML for communicating client and Consumed and created Restful web services.
- Developed the Database interaction classes using JDBC, java.
- Rigorously followed Test Driven Development(TDD) in coding.
- Implemented Action Classes and server side validations for account activity, payment history and Transactions
- Implemented views using Struts tags, JSTL2.0 and Expression Language.
- Worked with various java patterns such as Service Locater and Factory Pattern at the business layer for effective object behaviors.
- Used Hibernate to transfer the application data between client and server.
- Worked on the JAVA Collections API for handling the data objects between the business layers and the front end
- Worked with JAXB, SAXP and XML Schema for exporting data into XML format and importing data from XML format to data base and JAXB in the web service's request response data marshalling as well as un marshalling process.
- Responsible for coding MySQL Statements and Stored procedures for back end communication using JDBC.
- Developed an API to write XML documents from a database. Utilized XML and XSL Transformation for dynamic web-content and database connectivity.
- Developed a Restful WebService using spring framework.
- Involved in implementing the Hibernate API for database connectivity.
- Maintaining the Source Code Designed, developed and deployed on Apache Tomcat Server.
- Used Maven for continuous integration of the builds and Used ANT for deploying the web applications.
Environment: Java/J2EE, Struts 1.2, Tiles, EJB, JMS, Servlets, JSP, JDBC, HTML, CSS, JavaScript, JUnit, WebSphere 7.0, Eclipse, SQL Server 2000, log4j, Subversion, Jenkin.
Java Developer
Confidential
Responsibilities:
- Involved in all the test cases and fixed any bugs or any issues identified during the testing period.
- Worked on IE Developer tools to debug given HTML.
- Written test cases for Unit testing using Junit.
- Implemented logging mechanism using log4j.
- Created Restful web service in Doc-delete application to delete documents older than given expiration date.
- Involved in complete development of Agile Development Methodology and tested the application in each iteration.
- Designed and Developed websites using CXML and REST for Cisco and multiple other clients.
- Migrated production database from SQL 2000 to SQL 2008 and upgraded production JBOSS application servers.
- Designed User Interfaces using JavaScript, Ajax, CSS JQUERY, functionality
- Used Swing for sophisticated GUI components.
- Writing Java utility classes.
- Troubleshooting and resolving defects.
- IntelliJ as IDE for the application development and integration of the frameworks.
- Designed the application by implementing Struts 2.0 MVC Architecture.
- Development, enhancement, maintenance and support of Java J2EE applications,
- Developed JSP and Servlets to dynamically generate HTML and display the data to the client side.
- Implemented JSON along with Ajax to improve the processing speed.
- Deployed the applications on Tomcat Application Server.
- Prepared high and low level design documents for the business modules for future references and updates.
ENVIRONMENT: Java, apache-maven, SVN, Jenkins, Spring 3.2, Spring Integration, JBOSS, Spring boot Strap, log4j, Junit, IBM MQ, JMS, Web Services, HTML, JQuery, Java Script, Java 1.5, Servlets 2.3, JSP 2.x, Hibernate.