Prakash Ranjan's Resume (Last updated July 22nd 2008)

Enterprise Information Systems, Enterprise Architecture, Java, J2EE,JavaScript, Java Servlet, Java Server Pages (JSP), Enterprise Java Beans (EJB), Web Services, Portals, Struts, WebLogic, WebSphere, MQ series, Oracle (SQL, PL/SQL), DB2,UML with Rational's Rose, HTML, XML, and JDBC,PHP, LAMP.

Eight years of experience, working in multiple technologies across domain of Financial Services, Telecom, Retail and Direct/Database marketing. My Technological Forte has been Java/J2EE in Windows and UNIX environments. Have extensively worked with the systems analysis and design activities supported by multiple case tools and am proficient with Oracle and DB2 on Database front. Drawing upon the knowledge acquired in Computer Engineering background, and combining with the expertise and insights gained during successive software implementation lifecycles, am able to handle projects combining multiple platforms and technologies.
Career Highlights:

• 8 years of hands on work on design and development of software products for Financial services, Telecommunication, Retail and Direct/Database Marketing domain using Java and Web Technologies.
  

• Experienced for 4 years in handling responsibilities of a Team Leader and Tech Leader on large projects.
  

• Acquaintance with global work environment. Worked with major clients like BNP Paribas, Walgreen's, AT&T Wireless, Rogers AT&T Communications, and participated in business design workshops during consulting assignment with NYK Lines Systems research, USA.
  

• Sound understanding of all phases of the Software Development Life Cycle (SDLC) execution at CMM Level 5 and am very comfortable with UML based conceptual system design. Have been involved with multiple full life cycle implementations of the large internet bases information systems.
  

• Hands on experience in developing Enterprise Information Systems using Java, JavaScript, Java Servlet, Java Server Pages (JSP), Enterprise Java Beans (EJB), Web Services, Portals, Struts, WebLogic, WebSphere, MQ series, Oracle (SQL, PL/SQL), DB2,UML with Rational's Rose, HTML, XML, and JDBC.
  

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

Project Brief: -

Marketing Systems & Infrastructure Group
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

• Worked as the KANA Professional Services Consultant to handle production support for the three KANA Connect instances
  

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

• Acted as a single point of contact for KANA Technical Support for the Connect product.
  

• Involved in the requirement gathering, prototyping, design and construction of the multiple enhancements to the connect products integration with existing eBay technologies.
  

• Planned, Designed and constructed the integration mechanism for the KANA Connect system and eBay Data Warehouse satisfying multiple rigorous reporting requirements.
  

• Involved with the Coordination of the Offshore Team working on the project.
  

Accomplishments
 Acted as the single point of contact for the eBay Business Users/Team and KANA Technical support/Teams.
 Participated and contributed in business design workshops with client's functional and corporate business managers to chart out integration with Data Warehouse technologies at eBay.

Technology on project:
 J2EE platform (JSP, JNDI, JDBC)
 Kana Connect 6.3.3
 Solaris 5.8
 Websphere5.1 Application Server
 JRun Web/App Server
 Oracle 9i Database
 Teradata OLAP Database
 Informatica 7.1.4
 Business Objects/Microstratagy
 IntelliJ Idea

Project Brief: -
Pegasus Oscar integration
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, can actually track his shipment in real time, and in some cases instruct NYK for any change in his plans.
Responsibilities

• Lead a team of six 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.
  

• Involved in the requirements analysis documentation and preparation of the static prototype.
  

• Preparation of UML Model diagrams like Use case diagrams, Interaction Diagrams, Class and object diagrams.
  

• Designing based on Struts MVC framework with J2EE standards and UML. Composing and documenting the High Level and Low Level Design specifications.
  

• Design and coding of presentation components and page layout design using Tiles.
  

• Coding of JSPs using Struts tags, Struts Layout tags, JSTL, EL and custom tag libraries.
  

• Developed Struts Validators and implemented internationalization using Resource Bundles.
  

• Involved with the Coordination of 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 design 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 Brief:-
3G Table Maintenance
Table Maintenance is an ongoing production support operation for the critical AXYS billing system at AT&T. The system has information regarding all the applicable rate plans and the discounts for the AT&T customers across North America and the database is accesses by the vendors, dealers, employees and also directly by customers over AT&T website.
Responsibilities

• Led the 22 member team for ongoing Production Support of live application running in a distributed manner all over North America
  

• Did Feasibility Study for Application Enhancements over practical day to day monitoring data.
  

• Handled multiple POC (Proof of Concept) initiatives for the proposed enhancements.
  

• Planned and executed multiple enhancements, running pilots for them all over the geographic regions with a smooth switchover.
  

Accomplishments
 Was chosen for the "Spirit of Excellence" award by AT&T for exceptional performance.
 Planned and executed multiple application enhancements Proof of Concept's.

Technology on project:
 Java 2
 SWING, Applets
 Sybase
 Windows 2000 OS

Project Brief: -
Corporate Online Billing and Reporting Application (COBRA)
COBRA (Corporate Online Billing and Reporting) application is to enable Rogers AT&T Wireless to deliver Internet based reporting tool to the Corporate Customers. The tool will enable business accounts with company code to view, pay, approve and perform analysis on their usage and billing information.
Responsibilities

• Study of the existing Applications of the project, and charting out design for the Application using UML Use Cases, Interaction Diagrams, Class and Object Diagrams.
  

• Construction of the application with JSP and Servlet with integration with FOP libraries for on the fly conversion of the reports to PDF format.
  

• Wrote SQL queries and PL/SQL procedures in the database as part of building back end DB components.
  

• Carried out the analysis of the Defects and the necessary coding to close that bug during unit and system testing phases.
  

• Strict Adherence to TCS Quality Processes for CMM Level 5 during all phases of the project
  

• Offshore support and Co-ordination with global users for UAT and get the signoff from them with complete end-end testing
  

• Used Version Control software like CVS and Win-CVS tools in configuring and maintaining the versions of the application code.
  

Accomplishments
 Solved the issue of printout complexities of Reports by incorporating FOP Processor into the application and allowing the users to have their reports in Portable documents format (.PDF) and also incorporated Excel format downloads of reports.
 Planned and executed the I18N (Internationalization) feature on the Canadian website requiring English and French versions depending upon the browser Locale settings.

Technology on project:
 Java 2
 PL/SQL developer
 Text Pad
 NetBeans IDE
 WebLogic Server 7.6
 Oracle 9i
 Sun Solaris 5.0
 CVS

Project Brief: -
StoreNet Enhancements
WALGREENS is one of the largest pharmacy chains in the world, with over 3600 stores spread across the North and South America. WALGREENS is considered the leader in innovative drugstore retailing. WALGREENS pioneered many store features over the last two decades that are becoming standards in the industry.
'StoreNet' the Walgreen's intranet portal for stores is one element of Walgreen's large intranet. As it has evolved, problems have arisen such as difficulty in tracking information at the right time, lesser ease of use etc. Considering the immense importance of this StoreNet, Walgreen's has taken up the initiative of enhancing the StoreNet. The project involved a full life cycle implementation of a Knowledge Management Solution for integration and reporting of point of sale data across the stores of largest pharmacy chain in U.S.A. The project was executed at CMM Level 5 using OO Methodology

Responsibilities

• Involved in the entire Software Development Life Cycle involving analysis, design, and development, QA to the post implementation support of building web applications.
  

• Design for the Application using UML Use Cases, Interaction Diagrams, Class and Object Diagrams
  

• Distribution of work to the 3 Team Members reporting to me and tracking their progress to ensure timeliness of deliverables. Reporting on the day to day status to the project leader and to the delivery manager.
  

• Coding for the application using Servlets, JSP and JavaScript with Strict Adherence to CMM Level 5
  

• Support during UAT and deployment of the project at Deerfield, Chicago, IL, USA
  

• Used Version Control software like CVS and Win-CVS tools in configuring and maintaining the versions of the application code.
  

Accomplishments
 Performed the role of the Build Master for the daily deployments during development and QA phases, coordinating between teams and the configuration managers.
 Came up with a strategy of using custom Tag Libraries for handling pagination and sorting of the multi page lists which was copied across multiple projects in the group.
 Was CMM champion for the project that involved coaching Team Members in the aspects of a CMM 5 Audit, and elements of Key Process Areas at the project

Technology on project:
 J2EE(Servlet, JSP, EJB)
 Struts 1.2 framework
 Portals Implementation
 WebSphere Application server 5.0
 WebSphere Studio Application Developer 5.1
 Oracle 9i
 Toad
 Windows 2000 OS
 CVS

Project Brief: -
NCS Product Customization Phase 2
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 the state of art securities services 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 almost ground up changes into its core and an implementation of 178 new business rules.
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 , validation those files for the correct formats and populating the NCS tables from them changing the holdings, eligibilities and entitlements of the clients.

Responsibilities

• Involved 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.
  

• Coded the large periodic programs known as PCABs which downloaded files from the global providers and validated these files for the correctness of syntax and semantics, and on passing validations updated the NCS tables with this data.
  

• Updated the MQ Series programs 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.
 Came up with Unix shell scripts for automated deployments during nights as the build process which stretched for 5 to 6 hours due to large KLOCs and huge team of 54 members, could be repeated twice in a day making the patches and fixes go into builds faster during QA making drastic reductions to QA turnaround time .

Technology on project:
 Java Servlet
 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)