Career Profile:

• Software engineer having in total 8 years and 11 months of industry experience, and adept in all stages of project lifecycle, right from capturing of business requirements, publishing application/e2e designs, development, testing, coordinating user acceptance testing (UAT), production support, and maintenance.
• Proven expertise in designing and coding of complex real time, business critical applications on Advanced PL/SQL, Java, and UNIX.
• Very proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers in PL/SQL with extensive use of Oracle Advanced Queues and Oracle XML DB.
• Having extensive experience in SQL query tuning, analysing of explain plans, and troubleshooting of Oracle DB level problems like session locks, resource crunch and so on.
• Have extensive working knowledge on Oracle 10g RAC environment, in active - active mode on clustered file systems (CFS).
• Well exposed to JAVA Springs and iBATIS framework.
• Very clear and vivid understanding of the Oracle Architecture.
• Very thorough understanding of the Object Oriented Programming Concepts.
• Having working experience in the design and implementation of numerous E2E solutions on Java/J2EE and Perl.
• Working knowledge with IBM MQs and Apache web server.
• Having data warehousing concepts.
• Have worked on assignments that required knowledge of programming languages like C and C++.
• Have worked in maintenance assignments for the Logistic domain, involving enhancements and production support.
• Have worked in delivering numerous E2E solutions for the Telecom Billing domain and have been well acclaimed for leading a production support team for the billing application of one of the world’s largest Telecom Service Provider.
• Have always exhibited excellent vocal and written communication skills and have always been an ardent communicator at all levels, including supervisors, subordinates and of course clients.
• Have always exhibited excellent analytical skills and continuous learning ability.
• Strong interpersonal and presentation skills and proven leadership qualities.

Experience Summary:

Currently I am associated with Confidential, since Mar 2012. I started off my career with Confidential, where I served for a long tenure of 7 years and 9 months. In between I was associated withConfidential for a period of 5 months.

• In my first assignment, I have worked primarily in the domain of financial needs of Agilent Technologies International PVT Ltd. Involved in Requirements gathering/analysis, Design, Development, Testing and Production Support for Agilent (GTT) Project.
• Intermittently I was involved in a design and development assignment in BT, working as the development lead for the module Billing Access Layer which shields the underlying complicacies of the Geneva billing system. My role as a developer primarily involved requirement gathering, carry out feasibility study in liaison with the component and E2E designers, and provide inputs to designer in determining modularity, development and thorough unit testing.
• From Sep 2006 till, I was working as the Production Support Lead for British Telecom Billing and Payments Platform, positioned at onsite Cardiff, UK since 09.11.2006. My role demanded more of techno managerial skills, attending/coordinating face to face meetings with the clients, problem solving and decision making abilities and ability to debug application as well as resolving database performance issues.
• From till Mar 2010, I worked as Solution Designer, leading the design and development team of the BAL payment module. I was the design SPOC of the Manage Payment Capability, which encapsulates every intricacies involved in the payment journey, including interfacing with PSP (Payment Service Provider) to successful ledgering on the billing platform. Besides the technical expertise, my role required thorough understanding of the payment systems and the associated complexities.
• From Apr 2010 till, I lead the CIM module for the AT&T account of TCS. Besides leading the offshore development team, I worked as the design and delivery SPOC for the module that aimed in congregating customer address data across all lines of business of AT&T into one centralised enterprise data warehouse.
• From to, I worked as the data architect and onsite lead for the Payment Reconciliation and Reporting System for Cricket Communications, operating from San Diego, California. Besides working on the data model my role also involved owning and compiling the system designs for the ongoing and future CRs, managing the deliveries and also leading the production support activities from onsite.
• From, I am worked as the Development and Delivery Lead for one of the biggest banking account of TCS, JP Morgan & Chase. My role as an onsite lead involved attending release scoping meetings, capturing requirements, identification of changes, implementation and management of the deliveries. So essentially my role spanned right from requirement gathering, development, unit testing and validation of test cases, to the management and quality assurance of the overall deliveries (for both onshore and offshore).
• From, I worked as the Tech Lead for the development and delivery of an enterprise application of the Investment Banking line of business for JP Morgan & Chase, based at Newport, NJ. My role involved providing optimal business solutions, chalking out design, continuous interaction with clients to gather requirements, perform database developments and also manage and streamline the deliveries of the offshore development team.
• Currently I am working as the Maintenance & Operations Lead (Production Support Lead) for the Clinical Data Repository application of Merck & Co, Inc. ’s clinical domain, based at Rahway, NJ. Besides debugging and resolving business critical application and database performance issues and supervising a team of 9 members, my responsibilities also requires owning several development assignments aimed towards application enhancements and delivering the same with the best of my capability.

Qualification:

Bachelor of Technology

Confidential Institute

Information Technology.

Higher Secondary

Confidential High School

Science

ICSE

Confidential

N.A

Technology Proficiency:

Below is a list of important software products, tools and methods that I have worked with.

Computer Languages: Advanced PL-SQL, UNIX Shell Scripting, JAVA, Transact-SQL, C, C++

Database: Oracle 9i, Oracle 10g (RAC), Microsoft SQL Server, Teradata

Front End Tools/Utilities: Visual Basic, Glade in Linux, HTML, D-HTML, JAVA Script

Tools/Utilities: Toad, PL/SQL Developer, Microsoft Visual Source Safe 6.0, MS-Office, SQL Navigator, OVSD (Open View Service Desk - HP), Putty, AMDOCS Clarify, Teradata SQL Assistant, Eclipse Platform

Other Proficiencies: Geneva/IRB Billing System, Oracle Advanced Queues, JAVA Spring and iBATIS Framework, IBM MQ Series, Oracle XML DB, TRECS from Chesapeake Solution Systems, DataStage

Operating Systems: Windows XP, HP UNIX

Project Summary:

The details of the various assignments that I have handled are listed here, in the reverse chronological order of the period worked for.

Project: MERCK Clinical Data Repository

Customer:Confidential.

Employer:Confidential.

Period: to till date

Role:Production Support Lead/Data Analyst (Maintenance and Operations)

Location:Rahway, NJ, USA

Description:

Confidential. is one of the largest pharmaceutical companies in the world. Merck headquarters is located in Whitehouse Station, New Jersey. It is currently one of the world\'s seven largest pharmaceutical companies by market capitalization and revenue. The company describes itself as "a global research-driven pharmaceutical company" that "discovers, develops, manufactures and markets a broad range of innovative products to improve human and animal health, directly and through its joint ventures".

The Clinical Data Repository is one of the most critical applications in the Merck Clinical Vertical, designed based on industrial standards acceptable by the FDA and other Pharmaceutical companies. The application has been conceived to hold patient and clinical data, with feeds from the upstream systems. Several business translations are applied to the data feed to transform the data to SDTM (Study Data Tabulation Model) format, which is then published to CDR’s outbound systems to subsequently publish reports for FDA’s verification.

Responsibilities:

• Design, develop and deliver application enhancements, and several generic components primarily on Oracle PL/SQL and UNIX, as stored procedures/programs or standalone scripts.
• Performance tuning of the existing PL-SQL/SQL code.
• Design and review data models pertaining to the requirements outlined. Compile the most optimum and feasible design in terms of performance and maintenance, after thorough analysis of the requirement.
• Gather business process requirements, high level business model design, business process re-engineering.
• In-depth analysis of business critical issues encountered in the day to day functioning.
• Supervise a team of 9 members ensuring that the work is equally distributed and each team member has got an important role to play within the teams activities.
• Streamline and monitor the several routine processes of the team.
• Engage the team in automating the recurring tasks/activities by coming up with reusable components.
• Attend and organising face to face meetings/con calls with clients and other business stake holders.
• Decide on the reporting formats and maintain and publish regular status reports.
• Ensure program/deliverables meet standards and technical specifications and perform technical analysis and component delivery.
• Create technical specifications, process/workflow design, user acceptance test planning and cut-over planning.
• Set up processes for monitoring the database health at regular intervals and engage the application DBA in setting up relevant traps at database level so as to raise alerts for any DB/system failures.

Solution Environment:HP Unix, Windows XP, Oracle 11g, PL/SQL, J2EE, Eclipse Platform

Project: JPMC Wholesale Customer Relationship Management

Customer:Confidential

Employer:Confidential

Period: to

Role:Tech Lead (Database Development Lead & Solution Designer)

Location:Newport, NJ, USA

Description:

Confidential is a financial holding company incorporated in 1968. The Company is a global financial services firm with operations in over 50 countries. Its principal bank subsidiaries are Confidential in New York, and Chase Manhattan Bank USA in Delaware. JPMorgan Chase\'s principal non-bank subsidiary is its investment bank, J.P. Morgan Securities Inc.

Touchpoint II has been conceived to be a single point reference for the statistical data relevant to all types of meeting, events and activities organized with the clients. The application provides features for the JPMC associate to perform search on several criteria and pull out the aggregated data for the underlying meeting, event and activity records. For each event/activity/meeting arranged, a reward point is determined based on the dimension and accordingly the final aggregate date is projected on the UI for a give search criteria.

Responsibilities:

• Attend regular meetings/con calls with clients and vendors to derive the accurate requirement
• Engage actively in the implementation/development of newly scoped work items.
• Provide inputs for the most optimum and feasible design in terms of performance and maintenance after thorough analysis of the requirement
• Plan and track deliveries, negotiate and obtain timescales from the client.
• Manage review of test specs and ensure proper validation of subsequent test results.
• Liaise with client parties and close all open issues.
• Manage and delegate work within the team and ensure highest level of delivery standards.

Solution Environment:HP Unix, Windows XP, Oracle 10g, PL/SQL, J2EE, Flex, Eclipse Platform

Project: JPMC Wholesale Customer Relationship Management

Customer:Confidential

Employer:Confidential

Period: to

Role:Database Development Lead (Delivery & Development Lead, Solution Designer)

Location:Chicago, Illinois, USA

Description:

Confidential is a financial holding company incorporated in 1968. The Company is a global financial services firm with operations in over 50 countries. Its principal bank subsidiaries are Confidential in New York, and Chase Manhattan Bank USA in Delaware. JPMorgan Chase\'s principal non-bank subsidiary is its investment bank, J.P. Morgan Securities Inc.

JPMC WCRM (Wholesale Customer Relationship Management) System has been conceptualised to be the underlying core application, providing essential business services to numerous interfacing front end applications. WCRM (Whole Sale Customer Relationship Management) system is implemented using service oriented architecture that can be leveraged by multiple LOBs via Web services, real time or scheduled batch interfaces. Built on Oracle 10g database with RAC architecture, WCRM has several JVMs designed to cater to specific consumer systems. WCRM primarily extends one stop data management capabilities for all the distinct entities involved in the banking domain, starting from clients, contacts, deals, products, activities and so on.

Responsibilities:

• Attend regular meetings/con calls with clients and vendors to derive the accurate requirement
• Engage actively in the implementation/development of newly scoped work items.
• Provide inputs for the most optimum and feasible design in terms of performance and maintenance after thorough analysis of the requirement
• Plan and track deliveries, negotiate and obtain timescales from the client.
• Manage review of test specs and ensure proper validation of subsequent test results.
• Liaise with client parties and close all open issues.
• Manage and delegate work within the team and ensure highest level of delivery standards.

Solution Environment:HP Unix, Windows XP, Oracle 10g, PL/SQL, J2EE, JAVA Springs and iBATIS Framework, Eclipse Platform

Project: Cricket Payment TRECS System

Customer:Confidential

Employer:Confidential

Period: to

Role:Onsite Lead (Data Architect, Solution Designer, Delivery & Production Support)

Location:San Diego, California, USA

Description:

Confidential is mobile wireless operating unit of Leap Wireless International, headquartered in San Diego, CA, serving more than 4 million customers in more than 50 markets in 23 US states, with an objective to serve upwards of 9 million customers 2 years from now. It provides a simple, affordable wireless service offering consumers and local businesses a flat-rate unlimited service over the latest technology, high-quality, all-digital CDMA2000 1X and 1xEV-DO wireless network.

Cricket Payment Reconciliation system has been designed to automate the reconciliation of all the customer payments received via multiple payment points and vendors. It has been implemented using the TRECS application from Chesapeake System Solutions. This project focuses primarily on reconciling the customer payment data from various heterogeneous sources and automating the customised payment reports.

Responsibilities:

• Attend regular meetings/con calls with clients and vendors to derive the accurate requirement
• Design and review data models pertaining to the requirements outlined and assist developers based at offshore in implementing the same.
• Compile the most optimum and feasible design in terms of performance and maintenance after thorough analysis of the requirement
• Circulate the component design and data model across all stake holders and arrange regular design walk through sessions for developers and other component designers.
• Plan and track deliveries, negotiate and obtain timescales from the client.
• Manage review of test specs and ensure proper validation of subsequent test results
• Liaise with client parties and close all open issues.
• Proactively monitor the operations of the production system and help in resolving any live problems detected/reported.
• Perform thorough analysis of any existing problem on the production system, identify the root cause and design and lead the implementation of the proposed resolution.
• Manage and delegate work within the team and ensure highest level of delivery standards.

Solution Environment:HP Unix, Windows XP, Oracle 10g, Microsoft SQL Server, TRECS from Chesapeake System Solutions, IRB Billing System