MANOJ UMATE

EXPERIENCE SUMMARY

Over **+ years of experience in the software development, application support and management of full life cycle commercial applications.

Functional experience includes Telecomm domain, Financial Applications.

Strong skills include VB 6.0, VBA,, Crystal Reports, ETL process and PL/SQL Script on Unix/ Linux and Windows platforms

Working experience as an Application Support Consultant using MySQL, Oracle 11g,10g and 9i databases on Unix / Linux Platform

Implement Secured Socket Layer [SSL] communication / handshake between multiple interfaces.

Building environments for Production and Non-Production like QA, Staging, Performance, etc.

ACADEMICS

Bachelor of Commerce, Pune University, India, 1994.

Masters Diploma in Computer Management, Datapro infoworld Ltd, Pimpri, Pune, 1997.

MBA [Masters in Businuess Administration ] from Pune University, India, 2010.

PROFESSIONAL CERTIFICATIONS

Done OCA [Oracle Certified Associate] in Administration track from Oracle Corporation.

TECHNICAL SUMMARY

SKILLS

TOOLS

EXPERIENCE LEVEL

GUI(S)

Oracle Forms6i, Crystal report 8

Business Objects

4

1

LANGUAGE

SQL plus, Visual basic for application

4

DATABASE(S)

Oracle, MS Access, MySQL

4

Programming Languages

Visual Basic 6. PL/SQL

4

1 connotes experience ranging between one month to three months

2 connotes experience ranging between three to six months

3 connotes experience ranging to six months to two years

4 connotes experience ranging to two years and higher

For the experience level section, please highlight the skill with the maximum experience

WORK HISTORY

Duration

Organization

Designation

December 2005 till date

TechMahindra Ltd.

Tech Specialist

May 2005 – November 2005

Ubics Technologies.

Software Consultant

January 2003 – January 2005

Creative vision

Software Engineer

August 2000 – December 2002

Shree Infosys Pvt. Ltd.

Programmer Analyst

January 1996 – August 2000

Ganage Pressings Ltd.

Programmer

ACHIEVEMENTS

Integration with Financail accounting package “Tally” for Invoice transaction data.

Integration with AutoCad2000 for resctangular drawing for sheet metal.

WORK EXPERIENCE

Tech Mahindra Limited

1.Feb 2014– Till date

Application Support Lead for IBU-TUS-10 – NGEAG Production Support

Scope:

NGEAG (Next Generation External Application Gateway) is AT&T Mobility’s implementation of an SDP (Service Delivery Platform) – a standard based secure and scalable platform for exposing core AT&T enablers to external (i.e. third party) developers.

Provides secure and controlled access of network services (Voice, Messaging, Data, etc.) to 3rd Party Applications and Subscribers.

Provides 3rd Parties and Subscribers to access SMS, MMS, WAP Push, Location, and Device Capabilities MIND lookup.

Provides a platform for Application Management & Control. AT&T can control traffic from each third party before it reaches the Core Network.

Helps transform 3rd Party/3rd Party Apps Integration Process from a technical one to a business one (reduced TTM, improved economies of scale, etc.). Necessary for bringing on new applications rapidly.

Responsibilities:

As a Team Lead will engage in Monitoring and Maintenance, Installation, configuration, troubleshooting, maintaining and upgrades to software implementation of application used for telecommunication. Specifically, will provide production support management; help stabilize new products to Production.

Works with stakeholders and partner teams to understand business requirements. Participate in and drive discussions on production architecture and support processes.

Work closely with Development and Test organizations to deploy and troubleshoot applications, and for any defects, upgrades, or enhancements.

Perform application monitoring and response, problem management/resolution, change management for a 24*7 suite of applications.

Perform deployment of code, scheduling, tuning and configuration of application and infrastructure components.

Provide support for business projects, product launches and release management.

Support and assist enterprise class customers for production issues.

Gather information independently; carry out necessary research and analysis to resolve production issues.

Guide in developing tools and scripts required for Production Monitoring and Support.

Responsibility of supervising resources in terms of assigning tasks and guiding them in performing the task assigned.

Role - Onsite Application Support consultant

Technology Area - Linux, MySQL, Oracle 10g, Cassandra, SSL

2.Jun 2012– Jan 2014

ADBA for ATT05 – Balance Manager and Mediation critical applications

Scope:

Gold Fusion Work Balance Manager Product is developed by Openet Inc. It’s mainly used for pre-paid customers, although it tracks the usage of pre-paid and post paid customer on real time basis. It is responsible for managing requests from different external systems to provide control over accounts, subscribers, plans, orders and balances for different 3G devices such as netbook, iPad, DataConnect cards.

The users can buy time-based and/or usage based plans and use their device to surf the internet or download data, music or videos over the internet. Balance Manager provides many services such as creating customer, accounts and subscriber and as well provide near real time rating of usage generated by the subscribers.

Responsibilities:

Building Database environments for various type of testing

Supporting Production issues for Balance manager / Mediation

Deploying new releases on Production / Development environments

Troubleshooting queries from development and testing team.

Giving out of hours support (on call/ rota) to the customers if required.

Attending various calls like review, defect and production issues calls.

Performance analysis and diagnosis of development and test environments

Role - Onsite Application DBA

Technology Area - Oracle 10g, 11g and SUN-Solaris

3.Oct 2010 – May 2012

Application Support for ATT05 – LD Tier -2 AMD

Scope: The American Telephone & Telegraph Company ‘AT&T’ is the largest provider of both local and long distance telephone services. I am working under “SBC-LD Tier 2” for this company. I am responsible for production support work in “SBC-LD Tier 2”.

Following major activities carrying included in production support work:

Price Plan: SBC-LD offers various Long Distance Telecommunication services to its customers.

These services are provided with numerous pricing structures [called as ‘Price Plan’] to support a wide range of marketing strategies. The subsystem allows the carrier to add new plans, products and services in a quick and easy manner, and to tailor special price plans to a selected group of customers or an individual customer (i.e. a large corporation).

Features: A Price Plan subsystem supports the following:

Calling plans (basic and Optional Calling Plans), Package plans (several services grouped together), Promotions, Discounts, Blocks of free minutes, Added value services (network capabilities, billing options, etc.), A price plan determines the amount SBCLD charges for calls, MMC/MAC and MRC’s associated with a customer’s products

Non-Production Requests: Giving access to users in different data bases is called as Non

Production requests. (i.e Pht025a2,Pht025a3,Pht025a4 and Pht025a5 Data Bases.)

Thrid Party Jobs: Running third part jobs like LNP, NPA and NXX

4. Feb 2010 – Sep 2010 (8 months)

Application Support for ATT05 – AT&T Mobility eCRM

Scope: Snooper is a web-based 24 x 7 application used by AT&T Mobility personnel such as Customer Care, Retail, and Business to Business (B2B), to verify customer's cellular phone account features against network element profiles. It can be used to troubleshoot and resolve technical customer service issues, and out-of-synch conditions between billing and provisioned network elements. Depending on access level, users can view or edit certain profile fields, and gain access to functionality available from certain applications on cellular switches..

Responsibilities:

Requirement gathering

Work allocation within team

Rota preperation

Co-ordination with client

Requirement analysis and planning

Team Management

Follow up with development team to resolve the defects

Environment: Solaris, Linux, Oracle 10.2, PL/SQL.

5.July 2009 – Jan 2010 ( 7 months)

Manual Testing for ATT04 – Aries EST OSS

Scope: CCM [Consolidated Capacity Management] a part of Data warehouse of AT&T . This application stored the data from various data sources. After that it will apply business rules to raw data and create view for Reporting Data Mart which will access by planner decision maker. The INSIGHT CCM development activities include technologies like Oracle, UNIX shell, ETL process and Business Objects used for reporting.

Responsibilities:

Requirement gathering

Requirement analysis and planning.

Test case designing

Preperation of RTM

Test management activities using Quality Centre 9.2

Follow up with development team to resolve the defects

Environment: Sun Microsystems OS 5.10, Oracle 9i, PL/SQL, ETL process, Toad 9.5.

6.May 2009 – June 2009 (2 months)

Support and Development for ATT05 – LD Tier -2

Scope: BO-ODR is a part of Telegence Long Distance billing. The BO-ODR Project includes applications such as Back-end Project, APM (Amdocs Partner Management), TBS (Telegence Billing System) and ODR (Operational Database Repository). The BO-ODR development activities include technologies like Oracle, UNIX shell, Perl scripts, ETL process and Business Objects used for reporting

Responsibilities:

Requiment analysis.

Low Level Document design for components.

Designing of Reports in Business Object.

Unit testing of developed reports.

Maintainance of existing reports

Monitoring of ETL process.

Environment: HP UNIX 11.11, Oracle 9i, PL/SQL, ETL process.

7.August 2007 – April 2009 (20 months)

Support for ATT05 – LD Tier -2

Scope: The American Telephone & Telegraph Company ‘AT&T’ is the largest provider of both local and long distance telephone services. I am working under “SBC-LD Tier 2” for this company. I am responsible for production support work in “SBC-LD Tier 2”.

Following major activities carrying included in production support work:

Price Plan: SBC-LD offers various Long Distance Telecommunication services to its customers.

These services are provided with numerous pricing structures [called as ‘Price Plan’] to support a wide range of marketing strategies. The subsystem allows the carrier to add new plans, products and services in a quick and easy manner, and to tailor special price plans to a selected group of customers or an individual customer (i.e. a large corporation).

Features: A Price Plan subsystem supports the following:

Calling plans (basic and Optional Calling Plans), Package plans (several services grouped together), Promotions, Discounts, Blocks of free minutes, Added value services (network capabilities, billing options, etc.), A price plan determines the amount SBCLD charges for calls, MMC/MAC and MRC’s associated with a customer’s products

Non-Production Requests: Giving access to users in different data bases is called as Non

Production requests. (i.e Pht025a2,Pht025a3,Pht025a4 and Pht025a5 Data Bases.)

Thrid Party Jobs: Running third part jobs like LNP,NPA and NXX

Responsibilities:

Adding, Updating and expiring users in Telegence application

Adding BOT minutes

Implementing Telegence Non-Production Requests Forms

Running CVS Scripts in various markets database on unix machines

Scheduling various data processing jobs.

Implementing,Validating, Finalizing and Raking Price Plans

Environment: HP UNIX 11.11, Oracle 9i, PL/SQL

December 2005 – July 2007 (19 months)

8.Originating And Destination Number Analysis for BT

Scope: Ordinal (Originating and Destination Number Analysis) focuses on information of ported number i.e. number which do not belong to British Telecom (BT) have come to it and numbers which belong to BT have gone to other license operator (OLO). Timestamp details are maintained i.e. the start date of the duration when an OLO number was with BT or BT numbers were with other OLO.

Responsibilities:

Understanding customer’s requirements and preparing system requirements specifications.

Logical Physical database design on the basis of requirement specifications.

Unit test plan and System test plan preparation and testing.

Developed stored procedures/triggers/functions using PL/SQL as per LLD.

Involved in the implementation and maintenance of the production, development and testing environment.

Environment HP UNIX, Oracle 8i, Forms 6i, Pro*C, PL/SQL Script.

Ubics Technologies, Pune as Software Consultant on deputation at Tech Mahindra Ltd.

May 2005 – November 2005 (07 months)

9.Originating And Destination Number Analysis for BT

Scope: Ordinal (Originating and Destination Number Analysis) focuses on information of ported number i.e. number which do not belong to British Telecom (BT) have come to it and numbers which belong to BT have gone to other license operator (OLO). Timestamp details are maintained i.e. the start date of the duration when an OLO number was with BT or BT numbers were with other OLO.

Responsibilities:

Understanding customer’s requirements and preparing system requirements specifications.

Logical Physical database design on the basis of requirement specifications.

Unit test plan and System test plan preparation and testing.

Developed stored procedures/triggers/functions using PL/SQL as per LLD.

Involved in the implementation and maintenance of the production, development and testing environment.

Environment HP UNIX, Oracle 8i, Forms 6i, Pro*C, PL/SQL Script.

Creative Vision, Pune

1.January 2003 – January 2005 (24 months)

As a Software Engineer was involved in the design and development of various systems using UNIX, Oracle, SQL, PL/SQL and Forms 3.0

Shree Infosys Pvt. Ltd. as Senior Programmer

2.August 2000 – December 2002 (28 months)

As a Senior Programmer developed the software product “Inventory and Shearing Plan” using VB 6.0, SQL Server, Crystal reports and AutoCad2000.

Ganage Pressings P. Ltd as Computer Programmer

3.January 1996 – August 2000 (56 months)

As a Programmer was involved in the design and development of various systems using Visual Basic and FoxPro.

WORKSHOPS/TRAINING PROGRAMS ATTENDED

Oracle Server DBA : Conducted by MBT SQL Star Internation,

Duration : 3 months : September 2005 to December 2005

Completed Executive MBA - Finance degree from University of Pune.

Contact this candidate