Prakash Ranjan

Enterprise Information Systems, Enterprise Architecture, Java EE,JavaScript, Servlet, Java Server Pages (JSP), Enterprise Java Beans (EJB), Web Services, Portals, Struts, Spring, Hibernate, WebLogic, WebSphere, MQ series, Oracle (SQL, PL/SQL), DB2,UML with Rational's Rose, HTML, XML, and JDBC, Brickstreet Connect, KANA Response, Analytics, Data Warehousing, Database Marketing, Email Marketing, CRM Architect, Campaign Management, Solutions Architect,Systems Manager,Development Manager

10 years of hands on multi-technology experience, across Financial Services, Telecom, Retail and Direct/Database Marketing domains in the roles of Developer, Technical Lead/Architect, System Analyst / Project Manager. Have extensive systems analysis and design expertise supported by multiple case tools and proficient with Oracle, DB2, and Teradata. A theoretical Computer Engineering background combined with multiple successful "in the trenches" software lifecycles implementation experience result in a uniquely balanced insight into strategic and operational aspects of the technology and an ability to leverage multiple platforms and technologies to deliver right solution meeting right goals.
Career Highlights:
➢ Experienced handling responsibilities of a Technical Project Lead and Technical Architect on large projects developing solutions that support rapidly changing business requirements and operation. Able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines
➢ Acquainted with global work environment. Worked with major clients like eBay Inc, BNP Paribas, Walgreen's, AT&T Wireless, Roger's AT&T Communications architecting and building large scale information systems with global off shoring model..
➢ Strong Process capabilities. Sound understanding of all phases of the Software Development Life Cycle (SDLC), execution at CMM Level 5 and UML based conceptual system design. Track record of multiple successful full life cycle implementations of the large internet based information systems.
➢ Hands on experience in developing Enterprise Information Systems using Java, J2EE ( JavaScript, Java Servlets, Java Server Pages (JSP), Enterprise Java Beans (EJB), Web Services, Portals, Struts, Spring , Hibernate, Adobe Flex, Java FX, WebLogic, WebSphere, Apache/Tomcat, Eclipse, MQ series, Oracle (SQL, PL/SQL), DB2,UML with Rational's Rose, HTML, XML, JDBC, PHP, Perl over multiple flavors of Unix, Linux and Windows.
➢ Recognized for excellent contribution by AT&T Wireless with "The Spirit of Excellence award".

Senior Consultant - eMessaging
Architecture and Technology consulting for the Customer eMessaging/eMarketing Solutions covering outbound/ inbound, secure eMail and SMS. Responsible for Brickstreet Connect, Kana Response, Informatica, WebTrends and Reporting Responsibilities:

• Architecture and planning (structural/functional/scalability) for next generation of HSBC eMarketing/eMessaging solutions, integration with bank site, middleware and data warehouse.
  

• Manage/ troubleshoot BrickStreet Connect and KANA Response installations for eMessaging/eMarketing. Help manage CRM installation with KANA Response.
  

• Plan/execute BrickStreet Connect Database Marketing campaign, help setup campaign analytics.
  

Accomplishments:

• Took over the technology environment and quickly stabilized processes for production troubleshooting, resulting in massive improvement in customer satisfaction and confidence.
  

• Setup better reporting for end-to-end audit of email campaign targeting and delivery, winning accolades from the user base.
  

• Helped setup COE (center of excellence) for eMessaging/eMarketing technologies in US, advising and guiding global technology installations across 200 international locations of bank.
  

Technology on project:
 BrickStreet Connect 10.4, KANA Response 10.4, Java EE/Perl/AJAX, Websphere 7.0 App Server, Portal, Interwoven TeamSite 6.5, Solaris 10, Spring, Struts, jquery, Oracle 10g Database, Informatica 7.1.4, Websphere MQ, Datastage, Websphere Message Broker.

The Online Communication group at PG&E is the department which handles the internal and external communication needs of the company via Web, Email, Social Networks and Advertising mediums. Based out of the PG&E's San Francisco headquarters this division strives to turn internet as a strategic advantage in streamlining and increasing the reach of the utility business's corporate and customer communications.
Responsibilities

• Architect, plan and implement web site enhancement projects (structural/functional/scalability) for www.pge.com.
  

• Manage and troubleshoot KANA Connect and KANA Response installations for online communications.
  

• Plan, create and execute KANA Connect Database Marketing campaigns and help analyze the campaign analytics in conjunction with TargetBase.
  

• Gather Requirements, prototype, design and construct Utility Outage Map for PG&E website using Geographical Information System (GIS) and Google Maps API.
  

• Prototype (Proof of Concept) the Recreational Areas sections with Ajax over Adobe Flex and Java FX for benchmarking.
  

• Integration with Facebook.com and twitter.com social networks initiative.
  

• Integration of forms with salesforce.com hosted sales/lead generation application.
  

• Troubleshoot day to day production problems and issues. Help IT team with application upgrades
  

Accomplishments

• Quickly got up to speed with the Interwoven environment and took over coordination of marketing campaigns from technology standpoint with production troubleshooting.
  

• Created the PG&E Outage Map from scratch, including the technology necessary for near real time updates on the status directly from the utility GIS.
  

Technology on project:
Java EE/Perl/AJAX, Weblogic 9.2 App Server, Interwoven TeamSite 6.5, Kana Connect 6.3.3, KANA Response 7, Solaris 5.8, Oracle 10g Database, Oracle Spatial GIS Database, Informatica 7.1.4

MS & I team at eBay handles the Database Marketing E-Mail campaigns for the eBay. This group primarily deals with the KANA Connect system which is eBay's permission based email campaign management distribution systems catering to the complete eBay User Base (220 Million). All of the marketing communication sent out to eBay users is sent through, and tracked via these systems.
Responsibilities

• Troubleshoot day to day production problems and issues as the KANA Professional Services Consultant handling production support for the three KANA Connect instances
  

• Act as a single point of contact for the huge global user base (Business users) of the KANA Connect system implementation at eBay, Managing the production problems, user education issues, specific user requests, overall coordination and prioritization.
  

• Plan, Re-Architect and construct the integration mechanism for the KANA Connect system and eBay Data Warehouse satisfying multiple rigorous reporting requirements.
  

• Coordinate the Offshore Team in China working on the project for a 24/7 Production support.
  

Accomplishments

• Acted as the single point of contact for the eBay Business Users/Team and KANA Technical support/Teams.
  

• Created coupon management and tracking system incremental prototype in PHP for IMD Customer Loyalty Program.
  

Technology on project:
J2EE platform (JSP, JNDI, JDBC),PHP/Perl/AJAX,Kana Connect 6.3.3, Solaris 5.8,Websphere 5.1 Application Server, Apache /Tomcat Web App Server, JRun Web/App Server, Oracle 10g Database, Teradata OLAP

Pegasus Oscar integration is a suite of web applications, which serve as the public Interface of the NYK Lines Shipping Business Information System. There is an application serving as the trunk for day-to-day business at NYK Lines employees named OSCAR. The Pegasus is the suite of web applications, which connect OSCAR to its public stakeholders like clients and business partners. Through the Pegasus web interface a client can seek information regarding his shipment, track his shipment in real time and in some cases instruct NYK for any change in his plans.
Responsibilities

• Lead a team of six (6) associates for Functional understanding and requirements gathering with global teams using various UML techniques and standards. Understand the business requirements and the business need of those enhancements. Analyze the impact of these changes on the existing functionality.
  

• Understand the business requirements of the system to design the functional modules of the application.
  

• Come up with the initial solution approach for the design problems. Create the requirements analysis documentation. High Level and Low Level Design specifications and code the static prototypes.
  

• Architect the system via UML Model diagrams like Use case diagrams, Interaction Diagrams, Class and object diagrams Design based on Struts MVC framework with J2EE standards and UML.
  

• Design and code the presentation components and page layout design using Tiles. Code the JSP using Struts tags, Struts Layout tags, JSTL, EL and custom tag libraries. Develop Struts Validations and implemented internationalization using Resource Bundles.
  

• Coordinate the Offshore Team working on the project.
  

Accomplishments

• Acted as the single point of contact for the Client's Business Managers/Team and Offshore Technical Managers/Teams.
  

• Participated and contributed in business Architecture workshops with client's functional and corporate business managers.
  

Technology on project:
J2EE platform (JSP, JNDI, JDBC), Struts, Solaris 5.1,Weblogic 8.O Application Server, Oracle 9i Database, IntelliJ Idea, Borland Together

Project Lead
Project Brief: -3G Table Maintenance/ Corporate Online Billing and Reporting Application (COBRA)
Table Maintenance is an ongoing production support operation for the critical AXYS billing system at AT&T. COBRA (Corporate Online Billing and Reporting) application is to enable AT&T Wireless to deliver Internet based reporting tool to the Corporate Customers.
Responsibilities:
Project Lead for 22-member team handling Production Support of distributed application running all over North America. Lead Feasibility Study for Application Enhancements over practical day-to-day monitoring data. Create POC (Proof of Concept) proposals for enhancements. Planned and executed Architectural enhancements, running pilots over the geographic regions ensuring smooth switchover. Analysis, design, development and QA phases of SDLC, Design using UML Use Cases, Interaction Diagrams, Class and Object Diagrams. Report status to Delivery Manager. Code Servlet, JSP and JavaScript with strict adherence to CMM Level 5. Integrate FOP libraries for "on the fly" PDF conversion. Write PL/SQL, Defect analysis and fixes, offshore support and Co-ordination with global users for UAT. Manage Version Control.

Accomplishments:

• Awarded "Spirit of Excellence" by AT&T for exceptional performance.
  

• Planned and executed multiple application enhancements Proof of Concept's.
  

• Solved printout complexities by incorporating FOP Processor for PDF and Excel format downloads of reports.
  

• Architected the I18N (Internationalization) feature on the Canadian site requiring English and French versions depending upon the browser Locale settings.
  

• Build Master during development and QA phases, coordinating between teams and the Configuration Managers.
  

• Formulated strategy of custom Tag Libraries for pagination and sorting of the multi page lists, published as best practice to multiple projects in the group.
  

• CMM champion for the project coaching Team Members on CMM 5 Audit and elements of Key Process Areas at the project.
  

Technology on project:
 Java EE Servlets, JSP, EJB), Struts 1.2 framework, Web logic Portal, Websphere Portal, Websphere Application server 6.0, Websphere Studio Application Developer 5.1, Oracle 9i, Toad, Perl, CVS.

A development project for BNP Paribas, Paris, a Global Custodian, having presence in U.S.A, Europe and Asia to upgrade/replace their existing custody systems of Corporate Actions for its European Operations to TCS securities system product NCS (Network Custody and Clearing System). Originally developed for Standard Chartered Bank Singapore, this Product had to be customized from the T3 Singapore Market to T1 European Market and that involved ground up changes into its core and implementation of 178 new business rules and solution catered to 60 types of Corporate Actions.

The phase 2 of the project aims at providing STP (Straight through Processing) to corporate actions and interfacing the NCS system directly with the Global Information Sources like Reuters, Fininfo, Financial Times and Bloomberg. The Feeds coming from Global Information Sources are fed directly to system which updates the Rates and positions of stock for different client accounts/Business Partners. The task involves downloading large data files from the Global Information providers, validating those files for the correct formats and populating the NCS tables from them changing the holdings, eligibilities and entitlements of the clients.
Responsibilities Phase 1

• Participate in the entire Software Development Life Cycle involving Analysis, Design and Development, QA to the post implementation support of building web applications.
  

• Create Business Requirement, Feasibility Study and Requirement Specifications (SRS) documentation for the customization from the client (BNP).
  

• Design the system architecture with DFD and OOAD
  

• Code the application using the TCS Proprietary CASE Tool MasterCrafttm and its associated development process. Write C++ code for the validations of the user input at the client side.
  

• Code the services for the interaction with the CICS routines called for transaction processing.
  

• Code interface programs for pushing information to and from the MQ Series queues using MQ Interface.
  

• Perform Code Review, Unit testing and System testing.
  

Accomplishments

• Performed the role of the Build Master for the daily deployments using the proprietary CASE tool MasterCrafttm during development and QA phases, coordinating between teams and the Configuration Managers.
  

• Coordinated with the QA Teams acting as the single point liaison and managed the Development team's response tracking the defects from their detections, fixes, verification, till their closure and handled reporting for the higher Management.
  

Responsibilities Phase 2

• Participate in Gap Analysis, feasibility Study and Requirement Specifications (SRS) document preparation regarding the customization from the client (BNP) in the second phase which dealt mainly with the STP (Straight Through Processing) of the data coming from the global feeds like Reuters, Fininfo, Financial Times and Bloomberg.
  

• Code the large batch programs which download daily feeds from the global providers, validate the syntax and semantics and update the NCS tables.
  

• Create the MQ Series interface code for the data feeds coming from multiple sources.
  

Accomplishments

• Performed the role of the Build Master for the daily deployments using the proprietary CASE tool MasterCrafttm during development and QA phases, coordinating between teams and the Configuration Managers.
  

• Created UNIX shell scripts for automated deployments during nights allowing the 6 hours build process to be repeated twice in a day making the patches and fixes go into builds faster during QA resulting in a dramatic improvement to QA turnaround time.
  

Technology on project:
Java Servlets, JSP, MasterCrafttm, C++, MQSeries, CICS, IBM DB2 UDB, IBM AIX for RISC 6000

Recognized for excellent contribution by AT&T Wireless with "The Spirit of Excellence award".

Member IEEE (Institution of Electronics and Electrical engineers)

Member IEEE Computer Society

Member ACM (Association of Computing Machinery)