K.Manjur Ali

#**,******* *********,

First Main Road,

VGP Srinivasa Nagar(South),

Rajakeelpaakkam,

Chennai -73.

Email : acp8z2@r.postjobfree.com

acp8z2@r.postjobfree.com

Cell: 0-887**-*****/ 0-860**-*****

Work experience:

1. Worked as Tech lead with the XTREAM IT SOLUTIONS Pvt Ltd as technical specialist in ORACLE PL/SQL with the client GE, Chennai from Aug2012 Nov2013.

2. Worked as Tech lead with the ObjectWin Technology India Pvt Ltd as technical specialist in ORACLE PL/SQL with the client Wipro Technologies, Chennai from Aug 2011 to Feb 2012.

3. Worked as Consultant in Covansys a CSC Company as technical specialist in ORACLE PL/SQL, Chennai from May 2007 to Jul 2009.

4. Worked as Consultant in Polaris software Lab as technical specialist in ORACLE PL/SQL, Chennai from Nov 2005 to May 2007.

5. Worked as Associate Projects in Covansys (I) Pvt. Ltd as technical specialist in ORACLE PL/SQL, Chennai from Dec 2004 to Nov 2005.

6. Worked as programmer in Srinivasa systems, Chennai from April 2001 to Nov 2004.

7. Worked as ticketing staff in Talent Air Travels, Chennai from June 2000 to Dec 2001.

Technical experience:

Having 9+ years of hardcore experience in Oracle SQL, PL-SQL in 8i, 9i, 10g and 11g.

•Involved Development, Support and Enhancement projects. Major activities

Includes Creation of DB objects, Query preparation, Query Tuning,Creation of stored procedures,functions, packages and database triggers.

•Hands on experience in support to the DBA team Creating Users, Granting privileges to the users, Creating profiles, Creating Roles, Creating tablespaces, Monitoring database and other DBA Activities.

Educational qualification:

Bachelor of Engineering in Computer Science from Bharathidasan University, Trichy, India. Passed out in 1999.

Technical Skills:

Operating Systems : Windows 95 / 98, Windows NT, Windows 200X,LINUX

Languages : Oracle PL/SQL, C, C++

Databases : Oracle 8i, 9i, 10g,11g.

GUI : Visual Basic 6.0, Developer 2000, Oracle Forms and Reports

Tools : Toad, SQL Navigator, SQL Developer,PL/SQL Developer

Utilities : Test Director, Power Designer, Erwin 4.1

Certifications and Awards:

•CSC Accolades award for nbAccelerator project(2008).

•OCA for Oracle PL/SQL Developing Applications(2004).

•OCP for Oracle 9i DBA(2004).

•OCP for Oracle 10g DBA(2011).

•OCP for Oracle 11g DBA(2011).

•IATA/UFTAA

Training:

•C, C++ -Linsoft Trichy(1999).

•Oracle 8i -SSI Chennai(2001).

•Advance Air Ticketting,Cargo Handling Management,Galileo Reservation system-Insitiute of Airlines and Travel Agency (2000-2001).

•Oracle 9i DBA- SQL * International Chennai(2003).

•Oracle 10g DBA-SQL* International Chennai(2010).

•Oracle Forms and Reports-SQL * International Chennai(2010).

•Linux Administration –SQL * International Chennai(2010).

•Informatica 8.6 - Greans Technologies chennai(2014).

Projects experience:

Project # 1:

Name : STIR

Organization : Xtream IT

Client : GE

Software : Oracle 11g,Colfusion

Description :

STIR is a web enabled reporting tool that enables businesses in multiple countries to submit supporting statutory and tax data and review/modify that data in an approval workflow environment. The goal of the project is to reduce the duplication of data entry efforts of finance personnel for both local Stat/Tax and US tax reporting which can contribute to delays in reporting compliance and increased risk of data inconsistency. The end product will be easily scalable to other countries. The front-end browser interface is generated by Coldfusion and an Oracle database.The application also uses ExcelWriter, a 3rd party product, for dynamically generating Excel spreadsheets for reporting purposes.

Responsibilities:

•As per Client requirement, creating and modifying Functions, Procedures, and Packages triggers and queries for reports.

•Query Tuning

•Table Partitioning

•Creating and monitoring ticket for the required DB changes

•Assisting DBA support team and provide required information

•Supporting Development team for the required DB activities

Project # 2:

Name : LMS-Limit Management Systems

Organization : Wipro

Client : State Street.

Software : Oracle 10g, Java

Description:

The system shall allow users to define /set limits using a credit approval process or system calculate the limits based on a rule matrix.The nature of certain products also requires the system to calculate the limits driven by a specific logic. Thus the limits may come in the system by virtue of one of three ways.

•Manual limits as processed by credit analysts using the request workflow.The process has been defined within the workflow use cases and supplementary specifications.

•Automated limits as calculated and processed by system, based on condition matrix.The automated process has been defined in the workflow specification document.

•Calculated limits driven by business rules. The rules for these exception scenarios have been defined in subsequent section of the document.

Responsibilities:

•As per client requirement, creating and modifying Functions, Procedures, and Packages triggers and queries for reports.

•Assisting the development team related on backend activities

Project # 3:

Name : RPS/FRPS

Organization : Covansys a CSC company Pvt Ltd.

Client : MERCATOR- Emirates Airlines.

Software : Oracle 10g, .Net, Java

Description:

RPS is an in-house system that enables creation of a blueprint for revenue generation and a shared vision across EK Planning, Management Accounts, YM, Pricing and Sales through collaborative formulation of detailed O&D, month, compartment, and point of sale (POS) level passenger revenue targets. It also provides facility to generate and review route level targets. The targets are created using scientific methods/modelling and optimised to ensure maximum revenue at the Network level.

Responsibilities:

•Production Support- Adhoc Updates, Monthly data loading, Target revision and Revised capacities

•Query Tuning

•Development-Creation of Procedures, Functions, Packages and Triggers.

•Query preparation as per client requirement and sending Reports

Project # 4:

Name : nbAccelerator Services.

Organization : Covansys a CSC company Pvt Ltd.

Client : AXA.

Software : Oracle 10g, Crystal Reports

Description:

CSC is world leader in the life insurance domain. nbA product is a web application aimed to accelerate the new business process for any life insurance company. It uses VP/MS as a rule engine and AWD as a workflow engine. It is based on SOA and J2EE standards. It automates the underwriting and various others processes, thus makes the process of issuing a policy very fast and cost efficient. CSC India is involved in implementation of this product for various leading Life Insurance companies of US and Canada.

Responsibilities:

•Query Preparation for every reports.

•Creating functions for every reports.

Project # 5:

Name : Direct Operating Cost.

Organization : Covansys India Ltd.

Client : MERCATOR- Emirates Airlines.

Software : VS.Net 2005, .Net 2.0, ASP.Net 2.0, Oracle 10g

Description:

Emirates Airlines (EK) operates to major destinations servicing its customers through its Passenger, Cargo, and Leisure divisions. At each destination, Emirates relies on a variety of services provided by vendors. These services are subsumed under the DOC Elements such as Landing/Parking, Handling, over flying, Catering, and Fuel.

For services provided by the vendors at the various stations during flight operations, the associated operational data is captured at these stations through various software systems. DOC system requires the operational data emanating from each of these stations for the purpose of validating against the resident contractual data, and for subsequent operations such as Accruals, Invoice Matching, and Reconciliation.

Responsibilities:

•DB Modeling(Using Enterprise Architect)

•SQL Activities

•PL/SQL Activities

•Assisting the development team related on backend activities

•Core DBA Activities

Project # 6:

Name : Credit Administration and Central Liability System.

Organization : Polaris Software Lab Ltd.

Client : CITI BANK.

Software : Java, J2EE, iPlanet 4.1 UNIX (Solaris 2.8),Oracle 9i.

Description:

Cacls Web is, a Corporate Credit Maintenance Application, which is implemented by Citibank US, in the south American Countries, which is live in 15 countries. It is an Enhancement & support kind of activities from here. This is the application which maintains Credit details of the corporates, having credit dealings with Citibank in the latam region countries such as Argentina, Brazil, Peru, Paraguay, Chile etc.,.

Responsibilities:

•Query Tuning

•Assisting the development team related on backend activities

Project # 7:

Name : CITY NETWORKS-INVESTIGATION V7.

Organization : Polaris software Lab Ltd.

Client : CITY NETWORKS.

Software : VS.Net 2005, VC#, .Net 2.0, ASP.Net 2.0, Oracle 10g, Microsoft Enterprise Library Patterns and Practices.

Description:

The Investigations v7 system is intended to be the City Networks' strategic Exception Management system. This is an Exception Management system delivering a high level of centralization of control, automation of exception processing and high quality management information. The system is used for investigating discrepancies arising on cash reconciliation, in a localized environment. The business requirement is for an Exception Management system delivering a high level of centralization of control, automation of exception processing and high quality management information.

Responsibilities:

•DB Modeling(Using Erwin 4.1)

•Maintaining Scripts and Queries Preparation

•SQL Activities

•Creation of stored procedures, functions, packages and database triggers

•Assisting the development team related on backend activities

•DBA Activities

•Creating database

•Creation of Tablespaces.

•Creating users.

•Creating Roles.

•Granting privileges and Roles to Users.

•Monitoring the database operations

•Monitoring the tablespace sizes

•Backup

•XML index creation(Primary Index and Secondary index)

Project # 8:

Name : INTERNAL SYSTEMS

Organization : Covansys India Pvt Ltd

Software : Oracle 9i, Power Builder

Client : Covansys India Pvt Ltd

Description:

Enterprise Application Group (EAG) is responsible for developing and maintaining all internal application requirements of Covansys globally.

The application requirements broadly cover the following domains:

•HR functions, headcount analysis & reporting

•Financial Accounting, Planning and reporting

•Payroll processing and accounting

•Administration

•Sales and marketing and other IT operations

Application changes are inevitable either due to change in business processes or business requirements or development enhancement or user reports. They may also occur due to new business requirements or due to error in the existing applications.

Responsibilities:

•Creation of stored procedures, functions, packages and database triggers.

•Query Tuning

•Change oracle DBA passwords at regular intervals.

•Creating and modifying objects within database.

•Loading data in the database when required.

•Creating Indexes.

•Creation of Tablespaces.

•Creating users.

•Creating Roles.

•Granting privileges and Roles to Users.

•Monitor daily schedule jobs and do the fall back procedure in

Case of failures.

•Provides technical support to application development teams.

•Get ad-hoc reports from the respective schemas.

•Execute DML statements in the respective schemas.

Project # 9:

Name : Lima-Viper .

Client : FORD(UK) .

Organization : Covansys India Pvt Ltd.

Software : Oracle 8i, Forms 6i, Reports 6i, Suse Linux .

VIPER:

This application is used to manage all activities of workshop. Also this is used to track the status of vehicles repair and whether they sent it back or not. This system Classified as a SOX (Sarbanes-Oxley) system. System was not very robust when it was taken over by Ford IT. They have done a lot of work to stabilize the system and in the process know a lot more of the system as well as have some documentation.

LIMA:

Application to manage their truck fleet of over 300 trucks and 2000 trailers

Helps to manage all activities related to these trucks and trailers

Responsibilities:

•Automatic migration

•Preparing test cases

•Manual testing.

Personal Details:

Name : Manjur Ali.K

M/F : Male

Date of Birth : 07-May-1976

Marital Status : Married

Passport No : H9233997

Nationality : Indian

Contact this candidate