PROFESSIONAL SUMMARY:

• Twenty plus years of progressive experience in all the phases of Software Development life cycle which includes Requirement Study, Analysis, Design, Development, Integration, Testing and maintenance using Waterfall and Agile Scrum methodologies.
• Worked with enterprise cloud applications: Salesforce, DocuSign and ServiceNow
• Seven years’ experience utilizing Java and J2EE (EJB, Servlets, JSP, JNDI) to develop application software, n - tier, e-business applications Implemented popular Design Patterns like MVC, Session Façade, Singleton and Factory and have experience with the open source projects like Struts (MVC), Ant and Maven
• Extensive experience in Oracle CRM,, working as Oracle developer and consultant, developing data base objects, such as packages, functions, procedures, triggers, object types for data warehouse and OLTP applications. Strong in Data Modeling, SQL, PL/SQL using TOAD, Oracle SQL developer, DDL, DML, SQL*Plus, SQL*Loader.
• Implemented and supported the Enterprise application software tools: Siebel CRM (Order Management, Account/Asset Management, EIM), Informatica ETL, Tibco ESB.
• Trained in scripting, reporting and SQL ad-hoc queries for various business units and data warehousing reports using OBIEE.
• Effective communication skills and can clearly understand and transform concepts into programming logic.

TECHNICAL SKILLS:

J2EE Technologies: J2EE,JSP, EJB, Java Beans, Java Servlets, JDBC, JNDI, Log4j, Web services

Web Technologies: XML, XSLT,XSD, WSDL, SOAP, HTML, DHTMLX, CSS, JSON, JQuery, NodeJS, AngularJS

CRM: Salesforce, Oracle Siebel CRM, Siebel Tools, eScript, EIM

Frameworks: SpringBoot, Struts, Spring, Hibernate

Servers: Web Logic, Apache Tomcat, JBoss

Database: ORACLE 11g / 10g /9i, SQL Server

Data warehouse/ETL/BI/Big Data Tools: Informatica Power Center, ETL, Application ILM (Data Archive), OBIEE, Oracle Answers, Oracle Dashboard, BI Publisher, Hadoop ecosystem

DB Tools: SQL Developer, TOAD

Version Control: Git, Subversion, Clear case, Visual Source Safe

UML Design / Data Modeling/ESB/ Build/Other Tools: Rational clear case, Visio, TOAD, ServiceNow, DocuSign, Tibco, Maven

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Java Lead/Technical Project Manager

Environment: J2EE (Spring boot), Tibco, hibernate, DocuSign, Maven, ServiceNow, Oracle

Responsibilities:

• Providing LOE on the SOW tasks
• Understand the requirements and provide the design/code and work with them team
• Participate in Brainstorm sessions
• Follow-up/prioritize the tasks and coordinate with off-shore TCS resources
• Reviewing the code and providing the feedback
• Build the application using maven

Confidential, Richardson, TX

Consultant Application Developer

Environment: Java, JBoss 4.2, Struts, Ant, JDK 1.6, JSP, Web services, CVS, Maven, J2EE, Eclipse IDE, JDBC, RDBMS, java script, Jersy, Oracle

Responsibilities:

• Analyzed requirements, wrote design documents for client.
• Work on coding enhancements for lane maintenance and employee maintenance.
• Worked on code fixes for transaction processing.
• Responsible for supporting applications by developing oracle SQL procedures/scripts
• Improved the performance on the existing reports by fine tuning the underlying the SQLs.
• Write SQL queries to generate the summary reports and schedule them for automation.

Confidential, Dallas, TX

Consultant

Responsibilities:

• Responsible for analyzing data which comes from different distributors
• Come up with design options on the data elements
• Review ETL packages /DB objects and come up with design and process documents

Confidential, Plano, TX

Software Engineer Lead

Environment: Java, JSP, JDBC, Struts, java script, Weblogic, ANT, Eclipse, CVS, XML, XSD, EJB, Siebel CRM, Informatica, Oracle

Responsibilities:

• Implemented Java code for several new features.
• Participated in SRS reviews, Design reviews and code reviews.
• Designed the enhancements using OOAD patterns
• Customized the Siebel CRM data to capture on going Product enhancements with configuration, admin support and EIM.
• Responsible for implementation and maintenance of Informatica ILM (Archive), Data conversions and provided the reports using PL SQL/Oracle.
• Supported the design documentation, development, and test of Extract, Transform and Load (ETL) interfaces utilizing Informatica PowerCenter 9.5. Led to deliver the several data conversions.
• Provided the Sales and Order entry reports with Oracle/PL/SQL.

Confidential

Environment: Siebel CRM, Oracle, Informatica

Software Architect

Responsibilities:

• Responsible for implementation of Siebel 7.8 and act as Siebel development lead.
• Led the upgrade implementation of Siebel 7.5 (SQL Server) to 7.8 (Oracle) using PL SQL.
• Followed-up with POCs on status updates to their assigned project tasks.
• Provided the feedback on development tasks and resources performance to upper management
• Led the data migration of Siebel 6.3 to Siebel 7.7/7.8 and actively participated in Order/Asset EIM Migration design and development
• Designed conversion reports (measuring the quality/quantity of the migration).
• Responsible for reviewing the design documents and provide development standards to follow.
• Mentored team members on Technical solutions.

Confidential, Plano, TX

Lead Application Software Engineer

Responsibilities:

• Responsible for implementation of LINX (Siebel CRM) solution for Confidential .
• Participated in Data migration from Siebel 5.6 to Siebel 7.5.2.
• Completed GAP Analysis in migrating the entire application from Siebel 5.6 to 7.5.2.
• Attended EPlan and JPlan sessions from Siebel systems to understand the possibilities of Customization and Configuration changes that can be applied while migration.
• Wrote Business Service scripts using eScript to access the external application and visualize them in Siebel 7.5.2 application.
• Analyzed and developed conversion reports (measuring the quality of the migration).
• Developed framework to process the products based on their functionality (Circuit, Trunk and voice).
• Did extensive performance tuning in EIM process by managing the Oracle environment from the backend (by allocating different tablespaces for EIM tables with proper storage parameters).
• Designed and developed Quote process to simplify the business rules using ASP.NET and C#.

Confidential

Sr., Consultant

Responsibilities:

• Involved in implementation of Siebel 5.6 from Saville Billing System and Provisioning system.
• Responsible for developing IFO process and conversion reports.
• Designed and developed In-Flight Orders (IFO) process for data migration
• Analyzed and developed conversion reports, measuring the quality of the migration.
• Created Interfaces using PL/SQL procedures, functions and packages to populate Siebel Interface tables, manipulate and validate Temporary tables for the data loaded using SQL Loader.
• Designed detail Data Flow Design between Saville Billing System and Siebel application using EIM Mapping.
• Extended Siebel Database schema in table and column level and created EIM mapping to accommodate the data coming from Saville billing system.
• Developed several VB interface program to modify the converted data using Siebel Business Objects and Components.

Confidential

Consultant

Responsibilities:

• Worked as consultant for companies: Entergy Corporation, Mitsui, US Cellular and to develop java and oracle applications.
• Created dynamic HTML data views and objects.
• Involved in DSO and servlets creation, database development using Oracle and wrote stored procedures for report generation.