We provide IT Staff Augmentation Services!

Sql Resume

3.00/5 (Submit Your Rating)

BangalorE

Seeking assignments in Delivery Management/ Project Management/ Solutions Consulting with an organisation of repute

SENIOR IT PROFESSIONAL: Possess nearly 13 years of expertise inDelivery Management, Project Managementand People Management.

  • Presently associated with Tech Mahindra Ltd., Bangalore as Project/ Delivery Manager.
  • Acknowledged for integrity, high professional standards, "big-picture" vision, and sensitivity todeliver projectswithin thecommitted time & cost parameters.Demonstrated ability to direct and motivate teams to complete projects meeting specifications and deadlines.
  • An ardent analyst, with a flair for adapting quickly todynamic business environmentsand adopting pragmatic approach in improvising on solutions and resolving complex business issues.
  • Excellent negotiation skills; demonstrated expertise in carrying out effectiverelationship/ engagement and delivery management. Awarded by employer and customer recognition on multiple occasions.
  • Demonstrated excellence ininteracting with clients, managing client challenges, providing client solutions and handling interaction from RFP stage to the project execution stage.
  • Acquired knowledge in the use of Requisite-Pro, Rational Clear Case and Clear Quest.
  • Extensive experience in the complete software development life cycle including System Study, Analysis, Design, Coding, Implementation and Maintenance.
  • Possess excellent knowledge in use of OOAD & Design Patterns.
  • Gained expertise in Oracle 8i/ 9i/ 10G, Visual Basic 5.0/ 6.0, Oracle Forms 6i/ 9i/ 10G, Oracle Reports 6i/ 9i/ 10G, JAVA, J2EE, JDeveloper, UNIX, etc.
  • Involved in the Infrastructure Deployment in Platform Upgrade, Virtualization and New T5220 Server.
  • Handled key domains including Fixed Deposit, Share Transfer System, Shipping and Telecom.
  • Adept in offering advice regarding thecreation of development opportunities, brainstorming ideas for addressing individual skill gaps, and suggesting ways to facilitate the resolution of conflict. Proven ability to work under pressure and adhere to strict deadlines.

IT SKILLS

  • Languages: SQL, PL/SQL, Visual Basic 5.0/ 6.0, Java, HTML, VB Script, COBOL, Pascal, C, UML, JSP, Java Servlets, EJB 3.0, Java Swing, Perl Script
  • Databases: ORACLE 8.x/9.x/10G, SQL Server 6.5/7.0, MYSQL, MS-Access97/ 2003/ 2007
  • Application: Forms 4.5/6i/9i/10G,Reports 6i/10G,JDeveloper, JAVA, J2EE
  • Open Source: Maven 1.0.2, Tomcat 5.5.9, Eclipse 3.0, Struts
  • Apps & Web Servers: Apache web server, Jakarta Tomcat, JBOSS
  • Configuration Control Tools: MS-Visual SourceSafe, Rational Clear Case & Clear Quest
  • Project Management Tools: MS-Project 03/ 07
  • Networking Systems: Telnet, TCP/ IP, FTP, WINDOWS NT, UNIX, Solaris
  • Internet Technologies: ASP, Microsoft Front Page
  • Tools: Toad 7.0, Ant, Tomcat5.5
  • Case Tools: ERWIN, Powerdesigner, Rational Software Architect, Rational Rose

EMPLOYMENT PROFILE

Since Dec'07 Confidential, Bangalore as Project/ Delivery Manager

Mar'07-Dec'07 Confidential, Gurgaon (Subsidiary of Tradeship Inc. New York, USA) as
Development Manager

Nov'03-Feb'07 Confidential, Dubai as Solution Architect

Dec'02-Nov'03 Confidential, Chennai as Project Leader

Jan'97-Nov'02 Confidential, Bangalore

Growth Path:
Senior Developer 03'97-04'99
Team Leader 05'99-11'02
Core Competencies

  • Project Management -Project Sizing
  • Project Conceptualization -Delivery Management
  • Budgeting -Scoping & Drafting Proposals
  • Requirements Management -Team Management

Project Management

  • Carrying out requirement gathering/ analysis, high level and low-level designing of the project.
  • Overseeing the planning, estimation and implementation of project plans within preset budgets and deadlines.
  • Understanding business's requirements and mapping them to system requirements specifications.
  • Liaising with stakeholders - onsite team & with offshore development team members.
  • Incorporating changes/modifications in the project as required; executing project status tracking & reporting, resource allocation and management.
  • Conducting process and system studies and coordinating with team members.
  • Carrying out presale activities such as estimations, showcasing different tools & projects for clients.
  • Risk tracking & mitigation, project costing, team mentoring, deployment, monitoring & development.
  • Executing requirements study and estimation; analysis and design as per object oriented paradigm using UML.

Delivery Management

  • Delivering SLA based services for operations management; ensuring adherence to policies and processes relating to service transition, implementation, and operation of outsourcing services.
  • Stream-lining process of execution.
  • Handling delivery management for technical deliverables of concurrent projects.
  • Coding on Java, J2EE components; participating in the design and code reviews.
  • Executing the Integration and System Testing; preparing the Software Requirements Specification and analysis of the specifications provided by the client.
  • Designing as per object oriented paradigm using UML. Coding, Unit, Integration and System Testing.
  • Handling coordination activities and status reporting for the module.

EDUCATION

Post-Graduate Diploma in Computer Applications
B.Sc. (Mathematics)

CERTIFICATIONS & TRAININGS

PRINCE2 (Project Management) Certification.

Oracle Certified Professional (OCP) in Oracle 9i.

PERSONAL DETAILS

Date of Birth : 3rd January, 1974
Marital Status : Married

PROJECTS HANDLED

Confidential

Project Title : Telecom-PACS (BT-04), RAP & AMT (BT-12)

Clients : Confidential, UK
Duration : Since Dec'07
Environment : JAVA, J2EE, Oracle 9i (SQL/ PLSQL), Shell Script in UNIX
Role : Working as a Project/ Delivery Manager with handling a team of 40-45 team members
Responsibilities :

  • Identifying/ reviewing scope of work to initiate resource planning of development team.
  • Working with Business Analysts regarding changes to the project scope & assessment of possible constraints.
  • Ensuring a thorough understanding of BT-PACS, RAP, AMT applications and technical architecture.
  • Following the TechM project methodology (AGILE).
  • Facilitating necessary internal and external meetings and prepares necessary status reports to ensure project tasks are being completed in a timely fashion.
  • Assisting in the estimating (FPA Tool) and planning of releases & sub-releases.
  • Guaranteeing that deliverables are implemented in a cost-effective manner, achieving results and time commitments within budgeted parameters
  • Making possible impact analysis studies for effective deliveries and accurate development estimates.
  • Identifying, tracking, escalating and resolving project issues
  • Anticipating project deviations and takes immediate corrective actions.
  • Liaising with Technical Leads, Technical Designers, Database Team, Architects, Senior Application Developers and Application Developers to get all necessary details to define comprehensive and consistent technical specifications of the software.
  • Managing infrastructure activities for new T5220 Server and Platform Upgrade (19 Servers).
  • Looking after the virtualization of the Servers saving costs for the customer on physical hardware installations & maintenance thus benefiting the project in its long term Endeavours.

Confidential

Project Title : HSDG Project

Duration : Mar'07-Dec'07
Clients : Confidential, Germany
Environment : JAVA, J2EE, Oracle 9i (SQL/PLSQL)
Role : Working as a Development Manager with handling a team of 30-35 team members
Description : Confidential, New york is a software shipping consultant company with experience of nearly 15 years in the IT Industry. In these 15 years we have delivered shipping software product name as Sealiner to many shipping industries all around the world and also we do the support for those companies.
Responsibilities :

  • Identifying/ reviewing scope of work to initiate resource planning of development team,
  • Working with business analysts regarding changes to the project scope, assessment of possible constraints.
  • Ensuring a thorough understanding of HAMBURG SUD applications and technical architecture. Following the GLOBE project methodology (Waterfall).
  • Facilitating necessary internal and external meetings and preparing necessary status reports to ensure project tasks are being completed in a timely fashion.
  • Assisting in the estimating and planning of releases and sub-releases
  • Guaranteeing that deliverables are implemented in a cost-effective manner, achieving results and time commitments within budgeted parameters
  • Identifying, tracking, escalating and resolving project issues.
  • Anticipating project deviations and takes immediate corrective actions
  • Liaising with Technical Leads, Technical Designers, Database Team, Architects, Senior Application Developers and Application Developers to get all necessary details to define comprehensive and consistent technical specifications of the software.
  • Facilitating impact analysis studies for effective deliveries and accurate development estimates.

Confidential

Project Title : CMMI 5 Level

Duration : Nov'03-Feb'07
Clients : Confidential, France
Role : Process Definer & Enabler in Requirements & Configuration Management
Description : Confidential is one of the Third largest shipping companies in the World and number one in Europe. It is a French shipping having all agent offices all over the world with head office in France and Development Centre in Dubai. Now presently the company is involved in achieving the process CMMI Level 3.
Responsibilities :

  • Defining the process to the Different Teams in the Company.
  • Describing the process level for Requirement and Configuration Management.
  • Presently working as the Enabler in the Architecture Team for other areas of process improvement.
Project Title : LARA 10K

Clients : Confidential, France
Environment : Oracle 9i (SQL/PLSQL), Oracle Forms 9i/10G, Oracle Reports 9i/10G, Shell Script in UNIX
Role : Solution Architect
Description : Confidential is one of the Third largest shipping companies in the World and number one in Europe. French shipping having all agent offices all over the world with head office in France and Development Centre in Dubai. These companies have its own in-house software product as LARA for their Shipping Business. The main objective of this project to redesign the application to support more than 10,000 users worldwide.
Responsibilities :

  • Ensuring:
    • A thorough understanding of CMA CGM applications and technical architecture.
    • Proper technical product documentation of the database structure.
  • Specifying, designing, develop, maintain and troubleshoot software components and framework.
  • Optimizing key SQL and usage of pre-tested routines.
  • Writing technical specifications on request and under the supervision of the Application/Development Architecture Manager.
  • Liaising with Database Architect, Domain Team Leads and Application Developers to get all necessary details to define comprehensive and consistent technical specifications of the software.
  • Facilitating impact analysis studies for effective deliveries and accurate development estimates.
  • Reviewing production environment with DBA team to continuously improve application performance & design.
  • Training Developers to continuously improve the overall awareness and knowledge of database design aspects and its relation to performance.
  • Auditing team deliverables to ensure conformance to the CMA CGM framework and high quality deliverables.
Project Title : Cost & Revenue Control

Clients : Confidential, France
Environment : Oracle 9i (SQL/ PLSQL), Oracle Forms 6i, Oracle Reports 6i, Shell Script in UNIX
Role : Senior Application Developer
Description : Confidential is one of the Third largest shipping companies in the World and number one in Europe. It's a French shipping having all agent offices all over the world with head office in France and Development Centre in Dubai. These companies have its own in-house software product as LARA for their Shipping Business. The main objective of this project on the Accounting Packages of the Head Office, Monthly General Account, PCR-DA Module for the Agents all over India in their day to day activities.
Responsibilities :

  • Designing, implementing & streamlining processes in this development effort which includes:
    • Analyzing user specifications and expected output.
    • Designing using knowledge base.
    • Optimizing key SQL and usage of pre-tested routines.
    • Remote testing on client sites with client data
    • Establishing process improvements and standardized the methodology to deliver a quality Valuation File on a timely basis.

Key Highlights :

  • Instrumental in development of a Smart Tool, Valgen, to ease the effort involved, automate the repetitive tasks and ensure standardized coding conventions and report format.

Confidential

Project Title : Share Transfer System Duration : Dec'02-Nov'03

Clients : Confidential, Chennai
Environment : Oracle 8i, Forms 6i, Reports 6i
Role : Project Leader
Description : This is used for transferring the shares from one shareholder to another shareholder. There are three types of share transfer. a) Transfer: Transfer of shares between two shareholders. b) Transmission: If first holder dies, transferring the shares to legal heirs of the shares holder. c) Transposition: Changing the position of the holders. It helps to enter the transfer deed, for taking the checklist, processing the documents, printing of memorandum, Bad delivery report or confirmation report, summary report and MIS reports to the company. Each and every year after the AGM meeting the annual return reports are taken and dividend warrants to the share holders are also printed. The Graphical Representation of the data for each and every approval are designed and also for every AGM Approval.
Responsibilities :

  • Co-ordinating with Technical Architects globally to help design the product to meet the non-functional requirements & to adhere to architecture guidelines.
  • Trouble-shooting query optimization and performance tuning.
  • Designing Data Model. Analyzing User Specifications and Expected Output.
  • Accountable for project estimation, preparing and managing the project plan.
  • Leading a team of 10 Developers to successfully implement modules. Ensuring that team adhere to Quality process. Optimizing key SQL and usage of pre-tested routines.
  • Accountable for remote testing on client sites with client data. Establishing process improvements and standardized the methodology to deliver a quality Valuation File on a timely basis.

Key Highlights :

  • Instrumental in development of a smart tool, Valgen, to ease the effort involved, automate the repetitive tasks and ensure standardized coding conventions and report format.

Confidential

Project Title : Buy Back Open Offer Duration : Sep'01-Jan'02

Clients : Confidential, Bangalore
Environment : Oracle 8.0, Forms 6i, Reports 6i
Role : Team Leader
Description : After the application is received the data had been entered as inward entry, checklist of the entry list, checking the bank schedules daily basis. Then verifying the signatures we would precede with the OFFER Form Entry with all the details of folio number, name and address details, shares applied with open offer form. Further checklist for open offer form is taken and checked. When everything is finalized after the open offer form with the checklist is corrected and rejected flag is marked. The shares applied would also be checked with physical and electronic master (NSDL&CDSL) .Then process with the master would take place. The co. also creates other MIS reports according to the requirements. Back up process is done before the final master update is done.
Responsibilities :

  • Accountable for query optimization and performance tuning. Designing data model.
  • Performing analysis of the existing product and implementing the new features which meets the client requirements and unit testing.
  • Leading a team of 3 Developers to successfully implement modules.
  • Writing test cases for unit testing and System Testing
  • Ensuring active involvement and support during the integration testing phase.
  • Making sure that the modules meet with the product standards.
  • Trouble-shooting correction of application programs for bugs.
Project Title : Fixed Deposit Registry (United Breweries Limited) Duration : Feb'01-Aug'01

Clients : Confidential, Bangalore
Environment : Oracle 8.0, Forms 6i, Reports 6i
Role : Team Leader
Description : This system was developed for United Breweries Limited, one of the premier companies of United Breweries Limited (UB Group). This project is developed as per company\'s requirement for Fixed Deposit Registry Department.
Responsibilities :

  • Accountable for query optimization and performance tuning.
  • Preparing and managing the project plan.
  • Leading a team of 4 Developers to successfully implement modules.
  • Performing analysis of the existing product and implementing the new features which meets the client requirements and unit testing.
  • Writing test cases for unit testing and System Testing
  • Ensuring active involvement and support during the Integration Testing Phase.
  • Trouble-shooting correction of application programs for bugs.
  • Making sure that the modules meet with the product standards.
Project Title : Fixed Deposit Registry (McDowell & Co Limited) Duration : Jun'00-Jan'01

Clients : Confidential, Bangalore
Environment : Oracle 8.0, Forms 6i, Reports 6i
Role : Team Leader
Description : This system was developed for McDowell & Co. Ltd., is one of the premier companies of United Breweries Limited (UB Group). This Project is developed as per company\'s requirement for Fixed Deposit Registry Department.
Responsibilities :

  • Preparing and managing the project plan.
  • Leading a team of 4 Developers to successfully implement modules.
  • Creating the database design using ERWIN so that maintenance is easy
  • Assigning the units to team members and assisting them if there are any problems. Involved in developing some complex units in PL/ SQL (Stored Procedure).
  • Generating test programs to compare the new and the old billing results as the volume of data was very huge for manual comparison.
  • Trouble-shooting correction of application programs for bugs.
Project Title : Public Issue Duration : May'99-May'00

Clients : Confidential, Bangalore
Environment : Oracle 8.0, Forms 6i, Reports 6i
Role : Team Leader
Description : After the application is received the data had been entered, checklist of the entry list, checking the bank schedules, Preparation of 3 day and 78 days SEBI compliance reports, finalization of basis of allotment, printing of allotment advice, refund orders, share certificates, uploading the electronic data and various other MIS reports. Finally backup the allotment data in the cartridge tape.
Responsibilities :

  • Preparing and managing the project plan.
  • Leading a team of 4 Developers to successfully implement modules.
  • Coding many databases objects using PL/ SQL (Stored Procedure), etc.
  • Unit, Integration and system testing of the module.
  • Ensuring that team adhere to quality process. Ensuring timely and quality deliverables and also ensuring that all quality processes are adhered to.
  • Trouble-shooting correction of application programs for bugs.
Project Title : Depository Registry Duration : Jan'98-Apr'99

Clients : Confidential, Bangalore
Environnent : Oracle 8.0, Developer 2000
Role : Senior Developer
Description : This is used for the Back office of the Depository Registry System. The submitted Certificates for Demat from the Company are entered with the Depository Id, Client Id and the Certificates. Then the Checklist, Confirmation List, Summary Report and other MIS Report are also taken. Finally the entered details are updated to the master with the Dematted Shares and Query is checked with the entered details. An additional option for bulk uploading with the specified format according the depository module is added. The backup procedures of the data are developed after the updating procedure.
Responsibilities :

  • Preparing and managing the Project Plan.
  • Performing analysis of the existing product and implementing the new features which meets the client requirements and unit testing.
  • Writing test cases for unit testing and System Testing
  • Active involvement and support during the Integration Testing Phase.
  • Making sure that the modules meet with the product standards.
Project Title : Share Transfer System Duration : Mar'97-Dec'97

Clients : Confidential, Chennai
Environment : Oracle 8.0, Developer 2000
Role : Senior Developer
Description : This is used for transferring the shares from one shareholder to another shareholder. There are three types of share transfer. a) Transfer: Transfer of shares between two shareholders. b) Transmission: If first holder dies, transferring the shares to legal heirs of the shares holder. c) Transposition: Changing the position of the holders. It helps to enter the transfer deed, for taking the checklist, processing the documents, printing of memorandum, Bad delivery report or confirmation report, summary report and MIS reports to the company. Each and every year after the AGM meeting the annual return reports are taken and dividend warrants to the share holders are also printed. The Graphical Representation of the data for each and every approval are designed and also for every AGM Approval.
Responsibilities :

  • Preparing systems design and database design using ERWIN tool to meet customer requirements.
  • Coding many complex databases objects using PL/ SQL (Stored Procedure), etc.
  • Writing test cases for unit testing and System Testing to compare the new and the old billing results as the volume of data was very huge for manual comparison.
  • Trouble-shooting correction of application programs for bugs.

We'd love your feedback!