Project Manager
Resume:
Hemant Upadhyay
Profile
*+ years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
Extensive experience with analysis, design, development, customizations and implementation of software applications including ERP (Apex) applications.
Proficient in analyzing and translating business requirements to technical requirements and architecture.
Strong database skills, Object Oriented Programming and development knowledge.
Experience in leading and managing teams. Handled multiple project and roles.
Executed software projects for Aerospace, Telecom, Retailer, Insurance and banking industry
Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
Experience in estimating the project, managing CRP.
Skill Set
Platforms: MS-DOS, MS Windows NT/2000/2003, Sun Solaris, Linux
Oracle Languages & Tools:
Oracle PL/SQL, Oracle SQL, Oracle (9i, 10g, 11g)
Tool: Apex 3.2, 4.1, Dream viewer, ETL
Language: PL/SQL, C, C++, Java
Internet technologies: JavaScript, HTML.
Tools: SQL Developer, SQL Navigator, Citrix, Web sphere, Quality Center.
Application Server: Oracle Apex 4.1 (Oracle Application Express).
Education:
Bachelor in Information Technology from Mumbai University.
Oracle Certified (OCA) on June-2013.
ITIL Certified on June-2014.
Professional Experience:-ETL testing with database testing/Manual testing.
Nov 13 – Till date, Tech Lead, IBM India Pvt. Ltd. India. Client:-MetLife
Responsibilities:
Managing team and attending client meeting.
Weekly Status report.
Provide estimation for wmA and GPM project.
Creating/Review MTP for new projects.
Tracking Defect and follow-up with SMEs and AD team.
Sending DSR and WSR on Weekly bases.
Deliver new and complex high quality solutions to clients in response to varying business requirements
Responsible for managing scope, planning, tracking, change control, aspects of the project.
Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.
Utilize in-depth knowledge of functional and Technical experience in GPM and other leading-edge products and technology in conjunction with industry and business skills to deliver solutions to customer.
Creating complex query to team for database testing i.e. Pre-landing, Landing, ODS.
Project Description:
The Wealth Management Accelerator (wmA) and Global party search (GPM) Business Capabilities Class is designed to provide a comprehensive understanding of the annuity product features and administrative functions supported by wmA and GPM.
This admin system is used to process the fixed and variable annuity products for individuals.
System processes products in accumulation phase.
wmA is the modified version of EV15 10.0.
EV15 was an mainframe based application, whereas wmA is web based application.
wmA is used for administration of new issues and post (financial & non-financial) issues.
wmA is admin system for RP (Retirement Products), in which there are around 316 plan codes.
wmA is the admin system which stores information about Metlife policies which are sold through MET, NEF, MLI,USA, & MIC franchises/distribution channels. These policies are always issued through SmartApp application
Individual contract which is active is handled by wmA.
GPM is the backend (dB) for all the upper admin system, where data flow from source file to pre-landing, landing, ODS database.
Checking Mapping document to check data flow from Source system to destination system.
Environment: JAVA, Citrix, ETL, Oracle.
Team Size : 11
July 12 – Nov13, Project coordinator IBM India Pvt. Ltd. India. Client: - Jet Airways
Project 1: AMOS (MRO)
Responsibilities:
Involved in planning the activities.
Co-ordination with Client and other stack holder.
Prepared the plan of UAT.
Implementation in development.
Creating setup between AMOS and other system.
Project Description:
AMOS (Aircraft Maintenance and Engineering System), is a complex integrated soft-ware package that manages the maintenance, engineering and logistic functions of aviation companies. The software has been developed by the IT department of SWISS, i.e. in direct communication with airline staff a powerful online system has been de-signed. The software analysts and programmers profit from the early information about trends in the aviation industry due to their position within an airline.
AMOS is an MRO (Maintenance, Repair and Operations) system which is used by the airlines engineering section to plan and carry out their maintenance activities on the air-craft.
AMOS covers by large all business functions with regard to aircraft maintenance & en-gineering. AMOS is a completely integrated program that maintains everything needed in order to maintain and access information.
Environment: LINUX RHEL Environment, Putty, Amos web report designer, Oracle,Apex.
Project 2: Implementation of Avient Application in Jet
Responsibilities:
Involved in planning the activities, co-ordination with Client and other stack holder, prepared the plan of UAT, Implementation in development, Implementation in production.
Project Description:
Avient is a wide-ranging application for fleet scheduling and management that monitors and tracks airline operations and provides tools to minimize disruptions. This solution can be tailored to meet the needs of an individual airline as a fully integrated solution, or as a single module that can integrate with existing infrastructure.
Planning provides impact analysis with the ability to review plans before release to publication.
Environment: Sun Solaris 10, Oracle 11g, MQ Web Sphere, Exceed on demand 8, SQL Developer.
Mar 12 – Jun 12, Sr.Test Specialist IBM India Pvt. Ltd. India. Client:-Godrej
Responsibilities:
Analyzing the business requirements and preparing test cases for same.
Preparing preliminary test strategy and validating it with Project Manager.
Using SQLs for checking data related scenarios during intensive test cycles.
Using UNIX extensively for logs/processes for monitoring application during performance Testing.
Gather NMON statistics and send to HiPoD SMEs/Application Architects for performance enhancement by identifying bottlenecks.
Using SAP application for extracting data and the same has been validated manually i.e. pricing detail with Tax, Product mapping etc.
Defect tracking and weekly status reporting.
Alpha Testing – internal acceptance testing.
Writing test case and performing peer reviews for other test cases.
Involvement in System testing and System Integration Testing.
Checking Mapping document to check data flow from Source system to destination system.
Project Description:
Stocky Console is the application which enables corporate to control the flow of master data, Pricing, Product Promotion, Claims and Transactional Information like Purchase Invoice from Corporate ERP to the downstream supply chain. Console is Web based Application.
DMS is also known as Core Stocky is designed to maintain detailed information on products, stocks, suppliers, retailers, purchases, order book, Invoicing, promotions, claims, damages, returns, receivables etc.DMS is a window base Application.
It is also known as Secondary Sales Management System which consists of Console and Core Stocky. The data flow from ERP to Console and then migrate the same to Core Stocky.
Integration of all this Application is done with an EXE file generated from SAP. Where the data from ERP is downloaded to Console and then the same also is downloaded to core stocky by doing housekeeping activity. And then in Core stocky the same data is been upload with sync Process.
Environment: SAP, WEB, Oracle 10g.
Mar 10 – Feb 12, Tester IBM India Pvt. Ltd. India. Client:-Vodafone
Responsibilities:
Requirement understanding & analysis from Business Analysts.
Managing team and attending client meeting.
Weekly Status report.
Provide estimation for project.
Creating MTP for new projects.
Tracking Defect and follow-up with SMEs and AD team.
Sending SSR and WSR on Weekly bases.
Deliver new and complex high quality solutions to clients in response to varying business requirements
Analyzing the business requirements and preparing test cases for same.
Preparing preliminary test strategy and validating it with Project Manager.
Using SQLs for checking data related scenarios during intensive test cycles.
Using SAP application for extracting data and the same has been validated
manually i.e. pricing detail with Tax, Product mapping etc.
Defect tracking and weekly status reporting.
Alpha Testing – internal acceptance testing.
Writing test case and performing peer reviews for other test cases.
Involvement in System testing and System Integration Testing.
Complex query writing to find data from data base based on mapping document.
Project Description: UPSS, MNP, RM-Attendances, OSS-APPS, Uvision of credit, Distributor
Management System (DMS)
1.)VAS (Value Added Services) is a core business critical application supporting high volume TPS. In this application all services accessible by SMS are exposed to the customer. Testing involved configuration of each and every keyword based on the requirement, Sandbox testing of the keyword and approving for use in production. 4500+ keywords were deployed within a span of 3 months and is successfully running in 11 circles as of today. This application interacts with every other application within the Vodafone Enterprise scope.
2.)RECC is an application which is used primarily used for SIM Card Creation. Predominantly applicable for the prepaid business scope; this application interacts with a network element similar to IN (intelligent network) and HLR (home location register).
This propriety application & its related network interfaces used to take care of real time
charging for the customer GPRS usage and other data related traffic.
3.)Project Disha is a transformation project to replace Vodafone Essar’s existing billing system.
The current billing system is BSCS Billing (v. 6.0) and will be replaced by AMDOCS’ billing system. OSSAPPS provides the functionality for Bulk uploads and complex user administration.
OssApps accepts file (Excel/Text) as input from the business users for batch upload for 48 various activities including Payments supporting a TPS of 1391(pan India). Before uploading the files, OSS Apps validates the files and its data content via dynamic Oracle functions and code and then inserts them to the corresponding OSS Apps Interface tables. OSSAPPS also supports complex User Management scenarios.
4.)MNP is a prepaid & post-paid billing tool part of UPSS. MMP help users and business by
giving the capability to switch from one service provider to another without changing the assigned MSISDN/Number. They can seamlessly use the facilities provided by the target network. Concepts of Port-in and port-out were thoroughly tested including interaction with National MNP backbone interfaces.
Environment: Oracle, JAVA, UNIX, Web Sphere.
JUNE 08 – Mar 10, Tester TCS.India . Client:-VSNL
Responsibilities:
E2E Product testing.
Testing software releases
Dispatching Error Fixed files.
Checking performance of application using load runner.
Rating Part
Slab Creation.
Testing rejected CDR.
Interaction with Team Member and Client.
Understand the functional aspect of the application
IMMARSAT, VCIPLC Usage based service.
Solving user query.
Ensuring smooth running of the daily operations by regression testing.
Checking relevant log files stored on UNIX server.
Adding new features, Root cause analysis (RCA) and Bug fixing.
I being work as Software Development and Maintenance to Test Geneva databases and solving day to day production issues faced by the user. Testing of monthly billing activities for CIT, VCIPLC, INMARAST, and Usage based services. By using Reconciliation application it is possible to settle the dispute arises between different carriers.
Project Description:
Geneva is a Telecom billing and rating tool of Convergys. This tool is used to Bill and rate of CDR based and Non CDR based Service.
Environment: Sun Solaris, Linux, Oracle SQL*Plus (On UNIX platform), Oracle Database.
Mar 08 - June 08, Software Engineer, 3i-Infotech Pvt.ltd. Client:-ICICI
Responsibilities:
Supporting banking application (finnone).
Coordinating with team member.
Deployment of patches.
Checking night jobs.
Scheduling scheduler for jobs.
Project Description:
Finnone is one of the banking support application which helps bank to track their daily day to day activity. It is a SOPC for customer to feed their detail into bank systems.
Environment: UNIX, Oracle
DECLARATION:-
I sincerely believe in team spirit, hard work and loyalty. I hope the particulars in the attached resume are in line of your requirements and an opportunity would be provided to prove my worth.
Place: Mumbai Yours Truly,
Date: (Hemant U)
Contact this candidate