Java Sql Server
Resume:
VENKAT SANKA
Ph: 847-***-****
Mail: abg6u5@r.postjobfree.com
Summary:
> Ten years of Information Technology experience in design, development,
testing and implementation of web applications.
> Experienced in enterprise application architecture like Blue
martini/escalate retail, which includes web servers, application
servers, search servers and database servers.
> 7+ years of experience in application development using Java with JSP,
Servlets, XML
> 1+ Years of solid experience in TIBCO Enterprise Application
Integration tools like Business Works 2.0/5.1, Rendezvous 7.2, and
Business Connect 3.0.
> 2 years of experience with Jakarta Struts Framework, MVC and J2EE
Framework.
> Worked on projects for major clients like Blue Cross Blue Shield of
Missouri (Well point, MO), Blue Martini, Citibank, HP.
> Proficient in WEBLOGIC 6.1/7.0/8/9.2, WEBSPHERE 5.0, IIS5.0, IPLANET,
SQL Server 7.5/2000/2005 and ORACLE 8i/9i.
> Experienced in Testing J2EE internet applications and EAI
applications.
> Extensively used XML, XSD, XSLT, and XPATH.
> Extensively used version control tools like CVS, Star team.
> Extensively used Oracle, Sql Server, and Ms Access.
Certifications:
> Sun certified programmer for java 2
> Brainbench certified for Java 2
> Microsoft certified professional in Visual Basic 5.0
Technical Expertise:
Languages Java, C, C++, HTML, DHTML, XML, XSD, XSL, XSLT
Java Technologies Servlets, Java Server Pages, JDBC,EJB, Struts,
Swing
Application Weblogic Server 5.0, Weblogic Server
Servers 6.1/8/9.2,Web Sphere 5.x.
EAI Tools TIBCO Business Works, Business Connect,
Rendezvous, JMS
Web Servers IIS, Iplanet, Apache
IDEs JBuilder, Exceed, XML spy
Databases Oracle 7.x/8i/9i, MS-SQL Server 7.0/2000,
MS-Access
Operating MS-DOS, Windows 95/98/2000/2003/XP, Win NT,
Systems Sun Solaris, HP Unix
Tools/Utilities TOAD, Winrunner, Dame ware remote control,
RUP, ANT
1.5,Maven,Struts,HomeSite+,Jbuilder,eclipse,
DBVisualizer 4.3.1,smart ftp, perforce, vss
CRM Blue Martini 3.1/4.0/5.0.2/6.0/6.5, contact
center
Professional Experience:
Oc North America Jan 2007 to till date
Oc North America is in the process of upgrading their Blue Martini
infrastructure to the latest version Blue Martini 9.5.0.7. In this
initiative Oc would like to upgrade the www.oceusa.com site, including RM.
Role:
> Designing new templates according to the business requirements.
> Extensively worked on bmarchive, publishing process, DSS, reports
generation, support.
> Designed, analyzed the requirements of the Project.
> Designed and developed the UI using JSP, HTML, CSS and JavaScript.
> Involved in all day to day tasks and support.
Environment: Java 1.5.11, JSP, Servlets, Active Perl 5.6.1, Weblogic9.2,
Fulcrum search server5.4, IIS, Sun Solaris, Oracle, Toad, VSS as version
control system, Edit plus, Blue Martini 9.5.0.7, Ipswitch WS_FTP 12.
Lonely Planet Publications July 2006 to Jan 2007
Lonely Planet Publications decided to fulfill orders manually through
Contact Center.
Role:
> Designing the contact center to include the manual fulfillment
process.
> Customize Contact Center to integrate 3 different currencies like US
Dollar, UK Pound, and AU Dollar.
> Integrate with world pay to process payments.
> Integrate with cyber source to calculate tax for some states in USA
like CA.
> Make "Shipement processor" to run at order level, to complete the
order.
> Packing slips are printed for customer orders.
> After packing slips are printed, the system automatically changes
order status to "Packing order".
> Allow partial quantity to be shipped along with packing slip.
> Customize emails for order confirmation and shipment confirmation.
> Ignore inventory check for pre order and back orders.
Environment: Java 1.4.06, JSP, Servlets, Weblogic, Fulcrum search server,
IIS, Sun Solaris, Oracle, Toad, Perforce as version control system, Edit
plus, Blue Martini 6.5.1, smart ftp, Blue Martini 6.0
Gymboree,CA Feb2006 to Jun 2006
Gymboree is in the process of upgrading their Blue Martini infrastructure
to the latest version Blue Martini 6.5.1. In this initiative Gymboree would
like to upgrade the janieandjack.com site, including contact center.
Role:
> Designing the contact center to include the entire customization done
on the old call center.
> Designed and developed Application based on Struts framework using MVC
framework.
> Worked with different components in Struts frame work like Modal,
View, Controller components.
> Worked with different configuration files and with Struts tiles,
validation frame work.
> Designed, analyzed the requirements of the Project.
> Designed and developed the UI using JSP, HTML, CSS and JavaScript.
> Enhancements to the BM651 contact center.
> Converting the necessary id changes from int to long in all the
tmplates and business objects.
> Involved in merging the differential data generated during the
cutover.
> Created and implemented custom privileges for CSR to view sensitive
information like credit cards.
Environment: Java 1.4.06, JSP, Servlets, Weblogic, Fulcrum search server,
IIS, Sun Solaris, Oracle, Toad, Perforce as version control system, Edit
plus, Blue Martini 6.5.1, smart ftp, Blue Martini 6.0
MensWearHouse, CA Sep2004 to Jan2006
The Men's Wearhouse Builds Brand and Increases In-Store Traffic with Blue
Martini Website. The Men's Wearhouse designed a web site that would enable
to provide thousands of personalized interactions for their customers on a
daily basis. Twinhill, a division of Men's wear House has tie up with
Netjets an organization which is providing their employees to buy the
yearly work clothing by using their B2B website.
Role:
> Implemented multiple credit card functionality, dynamic domain
listeners.
> Developed Struts Action classes and Validation classes using Struts
controller component and Struts validation framework.
> Designed and developed the UI using JSP, HTML, CSS and JavaScript.
> Designed and developed custom business actions to achieve their
requirements.
> Resolving Production issues on their b2c, b2b websites including
shipment processor.
> Developed JSP templates for contact center and web store by using Blue
Martini.
> Developed custom audit reports for their daily use like shipping
audit, order entry, return audit, 14day audit, allowance audit,
accommodation audit, in process credit card audit reports.
> Resolving configuration issues in development, testing, and production
environments.
> Bug fixing and testing in all the environments.
> Modifications of their existing templates according to their Business
requirements.
> Implemented custom session time out, tax ware error interfaces in
their system.
Environment: Java 1.3, JSP, Servlets, Weblogic, Fulcrum search server, IIS,
Sun Solaris, Oracle, Exceed, Toad, Borland star team as version control
system, Home site, Blue Martini 6.0, struts
Customer Interactive System
Blue Martini Software, CA
April 2002 to Aug 2004
Blue Martini has a suite of Java based E-CRM tools used for building and
managing a complete e-commerce website. They support a large number of
third party tools and work on a wide range of platforms. We provided them
with technical support & consultancy for all their applications, offering
round the clock support for around 30 customers in Europe and Asia. The
primary activities involved helping the customers from the design stage
till going live, including b2b sites and also supporting those in case of
any problems maintaining the websites built using Blue Martini tools.
Role: ECommerce Consultant
> Designed and developed custom business actions and business objects.
> Created the naming standards and the directory structure for JSP
templates, Blue Martini configuration files and java classes.
> Designed and developed utility java classes for shopping cart,
personalization, database, date, and phone functionality.
> Participated in code reviews for various parts of the system.
> Developed JSP templates using BlueMartini API.
> Created attributes in Enterprise Merchandising Server (EMS).
> Transferred data from ERP Database to Blue Martini database using
BMLoader.
> Support Patch Testing.
> Replicating the entire customer site and giving feasible solutions.
> Solving configuration, upgradation issues.
> Extensively used Oracle import and export utilities for replicating
customer databases in blue martini lab.
> Involved in all the phases, like development of b2c and b2b sites,
testing, and technical support for the entire product.
> Developed and deployed EJB's (Session and Entity) to implement the
business logic and to handle various interactions with the database.
> Bugzilla used as defect reporting system.
Environment: Java 2.0, Jsp, Servlets, EJB, Weblogic, Web sphere, Fulcrum
search server, IIS, Apache, Iplanet, Sun Solaris, Oracle, Sql-server,
Exceed, Toad, Remedy.
Consolidated Gateway
Blue Cross Blue Shield of Missouri (Well point)
Oct 2001 to Mar 2002
Consolidated Gateway project is aimed at reducing the number of different
gateways/interfaces used to receive claims from different providers and
clearing houses. It not only achieved process efficiencies but also saved
costs in licensing, support etc...
The input transactions in EDI format are validated by Tibco's Business
Connect and data with errors is rejected. An XML file is created with the
cleared data and fed as input to the Business Works processes. The data is
again validated against provider and member records and sent for
adjudication.
The core processes are EDI Pre processing, BC HIPAA Validation, Upload ST,
Upload Claim, Member validation, Provider validation, Overlay process,
Batching by transaction, and Par process modules.
Role:
> Designed and Implemented Business processes and Error Handling
Processes.
> Involved in Process Integration, deployment and monitoring during
design time using TIBCO Designer and Administrator.
> Developed required XSD schemas.
> Used XPATH language to implement the business logic.
> Used JDBC to interact with Oracle for required data lookup and
storage
> Used Java activity to implement smart logic programs like to check
date of Birth and just born baby smart logic.
> Used Tibco Rendezvous to publish the information using different
transports like RV, RVCM, and RVDQ.
> Used file adapter to interact with the file system.
> Thorough understanding of HIPAA Transactions (Batch transactions and
Real time transactions) and processing at various levels.
> Involved in creating various kinds of design and development documents
as well as Test Plans.
Environment: Java 2.0, JDBC, JMS, Oracle 8.1, Win NT, Sun Solaris 2.7, HP-
Unix, TIB SDK, TIB Rendezvous 6.9, TIB Repository 4.0.1, TIB Hawk 3.0, TIB
Designer 2.0.1, Tibco Business Connect, Visio, Exceed, Windows Terminal
Service Client, MQseries.
Defense Against Real Threats (DART)
Hewlett Packard (HP),CA
Mar 2000 - Sep 2001
DART is a proactive approach of dealing with the vulnerabilities detected
in IT assets such as operating systems, applications, network components
etc. DART would maintain a repository of vulnerabilities in these IT
components and these would be accessible to customers subscribed to DART.
It would also maintain customer asset details like type of technologies
used, asset value, classification for the assets, etc. This would be used
to give an impact analysis to the customer for a specific vulnerability.
The vulnerabilities for these assets will be listed individually for each
asset of the customer.
The source of the vulnerability information would be predetermined web
sites and mailing lists identified by the service provider. These sites and
lists would be crawled at regular intervals. The patches and exploits for
these vulnerabilities would be downloaded and a link to access them would
also be stored. The customer would be shown a list of vulnerabilities and
also the patches, if any for each of his assets. The customer can maintain
along with the assets, details of the patches that he has already
installed. The customer is advised on the latest patch that he can install.
Role:
> Responsible for the Black box testing for the application and signing
off User Acceptance Test (UAT).
> Unit testing for the whole application.
> Coordinating with the development team to ensure the errors / bugs are
rectified as soon as possible.
> Interacting with the customer directly for providing solutions and
ensuring customer satisfaction.
> Handling the change request and enhancements in the product.
> Analyzing the Network, Operating system and Application based
vulnerabilities and updating them in DART portal.
> Uploading the patches for various Networking devices, Operating
systems and applications associated with the vulnerabilities.
Environment: Java, jsp, Sql server, IIS, Exceed.
Trade Information Management System 7.0
Citibank's Global Trade Finance Division
Jan 1999 - Feb2000
The system will provide end-to-end trade processing support on a single
global platform and will support all trade products. TRIMS is currently
operational in North America and is primarily used for processing Export
LCs, payments and Collections. The other Trade systems in North America are
LOCCAL and CitiTrade which are used to support Trade products that are
currently not handled in TRIMS like Bank to Bank Reimbursements,
Reinsurance LCs, US Standby's etc.
The end goal is to decommission LOCCAL and CitiTrade, and use TRIMS for
trade processing supporting the entire set of trade products. As part of
TRIMS Version 7.0, the system will be enhanced to handle all the Trade
products that are currently handled in LOCCAL and CitiTrade and build
interfaces to various MIS and GL systems that the existing systems feed.
Role:
> Developed the User Interface using JSP and Swing.
> Developed utility classes for database access and UI
> Technical documentation of the components and their implementations
> Unit testing & integration testing of the components.
> Integrated individual modules and the application in interactive
development cycle.
Environment: Java, Jsp,Swing, Servlets, JDBC, Oracle, Visio, Exceed,
Windows Terminal Service Client, Toad, Shell Scripts.
Business Management System
Jun 1998 - Dec 1998
This software system takes care of all the business activities of a service
organization like responding to enquiries for services, preparations of
quotations, executing contracts etc., It takes care of payroll activities.
It takes care of financial accounting also. Provides reports such as
General
Ledger, trial Balance, balance sheet, pay slips, multiple bank/cash books,
listing of accounts, sub accounts. Provide all MIS and other outstanding
reports. The following are the salient features:
Marketing
HRD Function
Invoicing/Collections
MIS Reports
Pay processing
Role:
> Developed the User Interface using AWT and Swing
> Developed utility classes for database access and UI
> Technical documentation of the components and their implementations
> Unit testing & integration testing of the components.
> Integrated individual modules and the application in interactive
development cycle.
Environment: Java1.2, AWT,Swing,JDBC, Oracle.
FINANCIAL ACCOUNTING
Jan 1998 - May 1998
This software is used to maintain Accounts of commercial and technical
companies. It mainly contains 5 modules. These are Masters, Transactions,
Queries, Reports and utilities. The features of this package are Receipts,
Payments, Debit Note, Credit Note, and Journal voucher. It provides reports
such as Cashbook, Bankbook, Sales Register, Purchases Register, sub
accounts ledger (Debtors/Creditors), general ledger. It also provides
listings of Receipts, Payments, debit/credit note, Journal voucher, Head of
account and sub accounts.
Role:
> Involved in analyzing the requirements and preparing the requirements
document
> Designing the database and developed utility classes for database
access and UI.
> Developed the user interface using JSP,Awt, Swing
> Unit testing of the modules and integration with the application.
> Interaction with Configuration Management team in building and
deploying the system.
Environment: Java, AWT, Swing, JDBC, Ms access 97
Courier Management System
Jun 1997 - Nov 1998
This package is used to maintain the daily transactions of the courier
office. Master entry provides a facility to add, delete, modify, view of a
customer, Transporter, agent. It provides a credit facility for a regular
customer. Transactions provide inward and outward consignments. It provides
customer wise, date wise, agent wise reports & receipts.
Role:
> Involved in analyzing the requirements and preparing the requirements
document.
> Designing the database.
> Developed the user interface using JSP,Awt, Swing
> Unit testing of the modules and integration with the application.
Environment: Java, AWT, Swing, JDBC, Ms access 97
Contact this candidate