Developer Sql

Venkat Muttineni abhwhn@r.postjobfree.com

Sr. Niku/CA Clarity Analyst 703-***-****

Summary

. 10 years of IT experience this includes 6+ years on Java, J2EE

technologies. And 4 years in CA Clarity PPM.

. Sound experience in Clarity administration and configuration like

creating jobs, integrating Clarity with legacy systems, Auto

scheduling jobs, business process definitions, creating custom

objects, data providers, queries and lookups.

. 4+ Years experience designing and coding Stored Procedures, Functions,

Triggers and Packages using PL/SQL and T-SQL.

. Excellent knowledge on CA Clarity Data Model. Expertise in All phases

of CA Clarity which includes Clarity Installation, Fix Packs, Hot

Packs, Admin, Studio Development, Process Design, Integration, Admin.

. Very good experience (2 yrs) in developing web services and SOA

choreography. Expertise and Experience in Enterprise Application

Integration (EAI).

. Excellent experience and expertise in Enterprise/Distributed/Web

Application Development and design, Object Oriented Programming,

Internet/Intranet based Database Applications.

. Expert level skills on Java (EJB, Servlets, JSP, JMS, Java Beans,

JDBC, Java and Struts, Hibernate, XML, WSDL, BPEL, DOM, SAX, JAX-RPC,

SQL, PL-SQL, Clarity).

. Excellent communication and interpersonal skills.

Technical Skills

Protocols HTTP, TCP/IP, RMI/IIOP, SOAP, SSL

Clarity(advance XOG, NSQL, HTML Portlets, Grid Portlets, JSP's with Niku

d) API, Query API, Invocation API, Object API, NSA Tool, Gel

scripts, Actuate/BO Reports, Clarity Integration With

External Systems(People Soft, Remedy..) Using XOG

Business Objects XI R2(Universe Design, XCelcius, Webi,

Reporting Desktop Intelligence, Infoview)

Programming/ Java, JSP, SERVLETS, JDBC, JTA, XML, UML, EJB, PL/SQL, C

Distributed and C++, NSQL, JSR-168 Specific Portlets, SQL, PL-SQL,

Technologies Niku XOG, JAAS, JMS, shell scripting

Internet/Client XML, XSLT, HTML and DHTML, JavaScript, Ajax (Web 2.0).

Technologies

Databases Oracle 8i/9i/10g, MS-SQL Server 2000/2005, DB2, AS400.

App./Web BEA Web logic 8x, 9x. IBM Web sphere 5.0, 6.0 Tomcat and

Servers jboss-4.0.4.GA, OC4J.

IDE Eclipse, Jdeveloper, Web Logic Work Shop 8.1, WSAD,

NetBeans 6.5

Tools TOAD, Oracle Enterprise Manager, ANT, Maven, JUnit, VSS,

Win CVS, FindBugs, Log4j, PVCS, ANT, SOAP station 5.5,

SOAtest 4.5, Perforce. Clarity Studio Developer, Business

Objects.

Platforms Windows XP/2000/NT and Unix

Web Services SOAP, WSDL, XML, JAXRPC, JAXB, SAAJ, BPEL

PPM Niku/CA Clarity

OO/J2EE Design Strategy, Singleton, Observer, Adapter, Factory, Session

Patterns Fa ade, Business Delegate, Service Locator, Value Object

Education - Certifications

. Bachelors of Technology (4yr).

. Sun Certified Java Programmer.

. Sun Certified Web Component Developer.

. Oracle Certified PL-SQL Developer.

Professional Experience

Dec 2008 to Till Date Wal-Mart, Bentonville,

AR.

Position Sr. Clarity Solution Analyst

Consultant

Contribution Convert customer business requirements into functional and

technical design specifications.

Develop Prototypes to get the Customer sign offs. Provided work

around solutions when out of the box solutions are not enough to

meet critical requirements.

Created an interface to Sync the Clarity Users from PeopleSoft (HR

System) which runs daily.

Migrated data from External Systems like Remedy and AS/400 into

Clarity.

Have been single point of contact for all technical issues and

their resolutions.

Review the code and design docs developed by other developers in

the team and implement industry best practices. Risk analysis,

estimate and suggest Clarity best practices.

Developed Objects and Sub objects in Clarity for new functionality

and enhancements.

Wrote triggers, procedures, functions in SQL Server 2005.

Developed Clarity custom solutions using JavaScript, AJAX, NSQL,

and XOG.

Developed Clarity Portlets, Reports using BO, views, sub pages,

attributes, lookups (static, dynamic), Clarity jobs, Clarity

Processes (synchronous, async, on demand, event based), Clarity

Menu, Sections, Links, Security set ups.

Integrated other Enterprise Systems with Clarity using Java, Web

Services and XOG.

Automated many manual processes using Clarity Automatic processes,

like new project requests will be approved/rejected via email by

VP, once approved, Clarity Process automatically creates a

project.

Achievements Reduced portlet rendering time from 10 min to 10 sec by tuning

NSQL /SQL Queries.

Environment Java, J2EE, XML, Portlets, NSQL, Unix, JSP, Servlets, JavaScript,

GEL scripts. T-SQL, SQL, SQL Server 2005, CA Clarity 8.1/12.1,

Business Objects XI R2.

Oct2007 to Till Nov2008 The Coca Cola Company,

Atlanta, GA.

Position Sr. Clarity Developer

Contractor

Contribution Mentor & Train Offshore and Onshore resources as well as manage

team deliverables.

Wrote Packages, Triggers, Functions and Stored Procedures against

the CA/Niku database for customer specific functionality.

Proactively communicate project roadblocks to upper management.

Converted customer business requirements into technical design

specifications.

Configured, develop, test and deploy CA/Niku solutions using

CA/Niku application toolset.

Performed Clarity administration, integration, XOG, custom object

and business process configurations.

Developed reports using Actuate.

Achievements Designed and developed multiple modules with ZERO Integration and

UAT defects.

Automated Project deletion process thus eliminating the several

manual effort hours.

Environment CA Clarity Portfolio Management, XML, XOG, Clarity Studio,

Portlets, NSQL, SQL, PL SQL,, PDF Reports using Itext, Unix,

Java, JSP, Servlets, JavaScript, GEL scripts, WSAD, Web Sphere App

Server, Shell scripting, Actuate 7.0, Oracle 10g.

Aug2006 to Sep2007 Target. Minneapolis, MN.

Position Clarity Administrator

Contractor

Contribution Trouble shooted Back Ground Process Engine, Niku Beacon.

Deployed niku application on Web Sphere App Server.

Installed Niku Clarity on Sand Boxes.

Migrated Clarity objects between various environments using

Clarity XOG utility.

Set up user resource access rights. Monitored user Login access to

Clarity system.

Set up LDAP authentication. Configured Auto Job Schedules.

Achievements Written several scripts to automate the processes.

Environment CA Clarity Management, XML, XOG, Clarity Studio, Portlets, Unix,

Java, JavaScript, GEL scripts, WSAD, Web Sphere App Server, Shell

scripting

Nov2005 to Jul2006 CalISO, Folsom, CA.

Position Sr. Web Services Developer

Contractor

Contribution Involved in data modeling for MDS application.

Implemented Fault Handling and Exception Management.

Used Poling Adapters to get the data from external systems.

Developed BPEL flows as POC.

Implemented both top-down and bottom up approaches to develop web

services (WSDL to Java and Java to WSDL).

Created WSDLs and XSDs to meet business requirements,

interoperability and platform independence needs.

Developed SOAP Clients Developed Adapter to fit in between

existing WS Framework and new web service.

Designed and Developed JBoss portlets, these portlets will call

web services to display and up date content.

Used application integration tools (Actional SOAP stack) and

technologies to ingrate multiple applications.

Achievements Fixed Oracle data base dead locks.

Provided information on latest SOA and available tools and

technologies to implement SOA to Chief Architect.

Jan 2005 to Oct 2005 Production Pull System, GM

Position J2EE Developer

Contributions Created/modified DAO classes to populate the Result Objects there

by Web Pages.

Developed new web interface functionalities using JSP, HTML, CSS,

and Java Script.

Developed Test Cases and Test Plans for Unit testing using Junit

and performed integration testing.

For every module followed the process of doing Analysis, Design,

Produce, Unit Testing and Integration Testing.

Involved, Initiated, Recorded, facilitated in Reviews like Design,

Code, Unit Testing reviews.

Estimated the cost of client new requirements did requirements

analysis and developed prototypes to get customer approval.

Responsible for writing complex SQL queries in process of

executing the business logic for desired out put.

Achievements Fixed JVM memory leaks.

Implemented Cashing in Web Tier there by improved performance

significantly.

Dec 2003 - Nov 2004

Benefit Focus, BCBS.

Position Sr. J2EE Developer

Contribution Created Functional/Business logic classes for various modules like

Member, HR Admin and Carrier using Business Delegate pattern.

Developed the Presentation layer JSP/SERVLETS, Tiles and MVC Frame

work using Struts.

Responsible for writing session beans for encapsulating business

logic.

Prepared Technical Design and Deployment documents

Managed a team 6 developers

Responsible for writing complex SQL and PL/SQL queries for writing

stored procedures and triggers.

Involved in JavaScript and Struts Validation to handle client side

programming and for validating screens.

Sep 2002- Nov 2003 ICL Systems

Position J2EE Developer

Contribution Implemented the File Handler Beans using JMS and session Beans.

Created File Handlers for the incoming FTP files using apache FTP

API.

Involved in the Data Model Designing.

Created the build files and deployed in to Linux environment from

the windows development environment.

Oct 2001 - Aug 2002 Provident Fund Management System

Position Programmer Analyst

Contribution Involved in writing technical specification documents based on

functional specifications.

Designed and developed programs to import data from legacy systems

(data files) to oracle database tables using SQL Loader import

programs.

Designed and developed SQL Scripts to create, alter, and drop

database objects, like tables, views, and sequences.

Involved in debugging developed code and performed unit testing.

Created stored procedures, triggers, and functions to retrieve

data from the database using PL/SQL.

Resolved dead lock problem in Oracle Data Base.

Oct 2000 - Aug 2001 Pyxis

Position Programmer

Contribution

Prepared the prototype of the system

User interface screens were developed using JAVA Applets.

Coded Servlets for Database connectivity and session tracking.

Coded error traps routines and form level validation routines.

Contact this candidate