Management System
Resume:
Harminder Parmar (Harry)
Email - *******@*******.***
Ph: 718-***-****
_____________________________________________________________________
Summary:
Excellent analytical skills and technical competence in computer systems. Strong academic knowledge in Finance and Business Administration.
Educational Background:
• Master in Business Administration (MBA with double concentration in: Management In Information Systems (MIS) & Finance - NYIT- NY)
• Mercury Test Suite Training (Mercury Interactive – Sunnyvale - CA)
Professional Experience:
BJP Consulting Inc
QA Manager
(Client) Active Health Management (NY)
Nov 11 – Jan 2012
Active Health Management is a leading provider of health management services, including disease management, clinical decision support and personal health records. Solutions powered by Care Engine® System, help to improve care for more than 22 million people nationwide and help health plans and employers lower costs.
The health management and data analytics company uses its proprietary Care Engine technology to gather detailed information collected across a patient's care spectrum. It then uses this data to provide clinical care coordination, disease management, and data reporting services. Its ultimate goal is to help reduce medical errors and expenses and identify gaps in care. Clients include employers, health insurance firms, and medical providers.
Administration Suite is a repository for reference data for clinical analytics that is used by the Care Engine group. Administration Suite hosts Accounts, suppliers, products, communication workflows and Member Health State related data.
Administration Suite has Clinical and Clinical Research (Data about illness/diseases) and Account Management (Products and who uses them).
The way the Administration Suite system works is as follows:
1. A new client is set up (one time) by creating an Account
2. Suppliers are set up under an Account
3. Based on the client needs Products are set up for each Supplier
4. Products are bundled into Packages
5. Packages are a mix of Markers and Monitored Events
6. Communication is added to the Products, Markers and Monitored Events
Responsible for the entire testing of Administration Suite.
Bank of America_Merrill Lynch
QA Manager
(Functional, Integration, System and Regression Testing)
May 05 – Sep 2011
Leading an onshore and offshore testing team.
Worked on multiple projects:
1. Greensheets
2. MLCO Tripod
3. CFO Reporting
4. Valuations
5. RiskPl
6. SPVR
7. Daily Reserves
8. Pegasus / Monthly Balance Sheet
9. FDM – Funding & Distribution Module- Daily Balance Sheet
• Responsible for the entire testing of the project end to end.
Responsibilities
1. Responsible for planning and executing testing efforts of system releases, bug fixes and enhancements, including documentation and reporting.
2. Strong understanding of Systems Development Lifecycle.
3. Day to Day activities include:
A. Strategic test planning and development.
B. Manage onsite and offshore QA resources, including time management.
C. Create tasks for the resources.
D. Review business requirements documents and technical design docs.
E. Translate business requirements into test plans and scripts.
F. Execute test scripts.
G. Report metrics.
H. Issue resolution.
I. Ensure teams are sticking to the work plan, project schedule and budget.
J. Perform deliverable reviews.
K. Perform weekly status meetings with test teams.
L. Validate alignment of resources to work efforts on each team. Manage/coordinate the team efforts across projects.
M. Communicate status with project management.
4. Regular Interaction with project managers, business analyst and clients. Attend meetings on code changes, business requirement changes etc.
5. Write comprehensive test plan and also manage test project plan.
6. Help create the project schedule in relation to test efforts. Create test schedule: Test execution coordination/planning per release.
7. Develop and update testing documentation in an efficient and timely manner according to departmental standards and procedures.
8. Manage and drive functional and Integration testing efforts
9. Test data preparation based on business requirements / test cases.
10. Use automated testing tools for regression testing.
11. Experience leading multiple resources on projects.
12. Experience working on multiple projects concurrently.
13. Exposure to different types of testing.
14. Experience with Quality Center & Defect Management for test and defect management
15. Strong written and verbal communication skills. Good communication skills – coordination with End Clients / Business Analysts / Development Teams.
16. Perform all QA and Production releases.
17. Experience with onshore/ offshore testing model.
Greensheets for Blackberry: <mobile application>
Tested the Greensheets application for Blackberry which was developed for Senior Management. This application is a subset of the Greensheets application and was specifically developed for senior management reporting.
By logging into this application via their Blackberries the CEO, CFO and other senior management had the company PnL at their fingertips 24/7.
Greensheets:
The objective of the project is to replicate the existing Greensheets application providing enhanced report functionality, a more efficient business process control environment and a more stable and reliable server environment.
The new system is developed using the front end-reporting product CPM (Clarity Performance Manager), together with back end Hyperion Essbase OLAP database and Oracle database. The Green sheet covers a suite of applications that are primarily used for GMI Management Reporting at Merrill Lynch. These applications provide daily real time revenue estimates and P&L reporting to Senior Management, Finance Planning & Analysis, Business Finance Controllers and Regional Finance groups.
The main function of the Green sheet is to capture daily net revenues and expense estimates, calculate Global daily, regional, pretax and other after tax profit and provide end user reports.
Due to regular requests from the business users for new features and enhancements a new version of the Greensheets application is released to production most weeks. Given the size and complexity of the system even a small enhancement requires full system regression testing. This is extremely difficult to manage with such a high frequency of production releases.
ML&Co Tripod:
ML&Co Tripod is a main report for Senior Management and it consists three parts: Daily Estimate, Weekly Revenue and Quarterly Pacing. Data is coming from current GS CPM for GMI and from new Daily Input templates for GPC, GWM and Corporate. Left upper part of tripod will change name depending on selected data from Daily Estimate - Trader Flash to Daily Estimate (Greensheets).
GMI Management Reporting system is utilized by FP&A group and Senior Management to track performance of GMI Group on the daily basis. GMI Group already accounts for about 65% of Merrill Lynch’s total revenues and profit. To get total picture of company’s performance, it is necessary to include several other groups. This is what ML&Co Greensheets attempts to do.
When complete, the ML&Co Greensheets system will provide full picture of Merrill Lynch performance on daily basis for corporate-level analysts and Senior Management. It will do that by adding revenue estimates for all groups on top of existing GMI reports.
Risk Pl:
Also, tested the Risk Pl system which feeds into the Greensheets system
Risk P&L Website was built to:
• Capture revenue estimates by 5 digit account codes.
• Accommodate feeds from BUCS/Finman systems.
• Accommodate feeds from GELP/FFO systems.
• Have better controls over manual input.
• Increase granularity for E2A analysis.
• Support proper segregation of legal and management revenues.
• Support Legal Entity reporting.
Risk P&L Ultimately feed estimates to Greensheets Website
SPVR:
The purpose of SPV Data Repository project is to build the cross business stream SPV trade repository strategic infrastructure. Phase 1 scope is to ensure repository has feed interfaces to take data from all sourcing systems across business streams. In subsequent phases repository will provide reporting framework in subsequent phases, as well as workflow for processing SPV trades across middle office and finance.
The purpose of SPV Data Repository project is to build the cross business stream SPV trade repository strategic infrastructure to meet the federally regulated MRIA.
The delivery of the repository has been outlined below by 3 Phases:
Phase1
Ensure repository has feed interfaces to take data from all sourcing systems across business streams, provide middle office oversight functionality with workflow screens
Phase2
• Finance data elements
• Finance Workflow & screens
• Data migration of Finance historical data to Trade Repository
• Finance Workflow Enhancements
• Finance User Reporting
Daily Reserve:
GMI’s Financial Planning and Analysis group (FP&A) utilizes financial reporting applications including Greensheets General Management Reporting for financial forecasting and asset allocation.
The new Daily Reserve application will meet the needs for an automated Daily Reserve suite that will allow users to get a snapshot of their reserves at any given date.
When complete, the Daily Reserve system will benefit FP&A by providing a more robust, streamlined application that will be geared toward automating daily, monthly, quarterly, yearly and ad hoc reporting.
Pegasus / Monthly Balance Sheet:
Pegasus is a web-based Balance Sheet Management reporting system that fulfils the following functions:
• It distributes the cost of ML&Co and manages Treasury borrowings to the various business units.
• It calculates the Merrill Lynch Risk Equity (MLRE) assignments that form the foundation of the ROE measurements of each reporting unit.
• It provides a source of average balance sheet positions.
Pegasus is used to provide senior managers with a view of the Legal Balance Sheet from management point of view.
Pegasus receives a number of feeds (daily and monthly) from external systems. Charges are applied to the feeds based on the business rules and the charged data are aggregated. The system allows users to do JE postings and allocations. The balance (feed data and charged data) from the cost center gets distributed to different cost centers based on the distribution rule attached to each account / cost center. The consolidated data is provided to Oracle GL. Pegasus gives the users the ability to run various reports (P/L). The users are allowed to view/update the cost of carry percentages per account and cost center. The reports can be either downloaded in .PDF format or can be viewed in the Spreadsheet.
FDM – Funding & Distribution Module- Daily Balance Sheet:
The Balance Sheet Group and GMI Financial Planning and Analysis group (FP&A) utilizes financial reporting applications including the Inventory website and GMI Management Reporting (Greensheets) website for financial forecasting and asset allocation.
The new Balance Sheet application will meet the needs for an automated Balance Sheet suite of reporting that will allow senior management and finance controllers to have increased visibility, transparency and control.
The major benefits of creating a Balance Sheet reporting tool in the Greensheet platform are:
1) Single platform for daily P&L and Balance Sheet estimates.
2) Increased visibility and transparency for finance, business owners, and senior management to better manage the Balance Sheet.
3) Eliminates the need for multiple FPA teams to create their own offline daily Balance Sheet reporting via MS Access databases.
4) Improved administration for better control of user access, and ease of communication with the user community.
Cambridge Group Inc
Senior QA Analyst
(Client) Health Market Inc (CT)
(Web Site Testing Assignment)
Jan 05 – Feb 05
Health Market is the small group division of the Mega Life and Health Insurance Company, a wholly owned subsidiary of UICI. Health Market has a Web site and an Extranet. Also a new Web Site (www.megasmallgroup.com) is being developed for Mega small Group. Different users use the web. The different users are Agents, Members, Providers etc and non-members for marketing purposes can also use the web. Agents are of different Co brands e.g. MEGA, HMI, CHSPK and ATAC etc. Underwriters, Customer Service Reps, Enrollment, and Sales Support use the Extranet. The site is developed using Java and the Back end is Oracle.
• Responsible for testing of the application.
Prisani Funding Inc (NY)
July 03 – Dec 04
Mortgage and Loan Processing:
The company is engaged in the business of processing mortgage loans.
Responsible for processing the loans.
Accountability for the entire process from receipt of work to resolution and closure
TesCom USA
April 00- Jun 03
Senior QA Analyst
(Client) Post Office Ltd – (Integration and Functional System Testing Assignment)
London – UK
ICPL/ Fujitsu provides the Post Office with the Horizon System in order to support Automated Counter Operations. The Post Office delivers a number of banking services across the counter, but these services are not supported by Horizon. The NBA R1 (Network Banking Automation) program will provide an upgrade to Horizon to support a range of Automated Banking Transactions, together with an infrastructure to connect Horizon to a number of Financial Institutions. At the same time there is a program for the Post Office to set up its own Banking Service, the Post Office Card Account (POCA), to deliver Basic Bank Accounts in order to support Benefits Agency payments directly into the claimant’s bank accounts.
Development of the NBA R1 system requires a number of systems to be developed and tested by individual suppliers and the Post Office, before being integrated to form the overall NBA R1.
The Overall Testing Objectives are to:
• Ensure that the individual suppliers systems operate as specified in the supplier contract schedules.
• Ensure that the NBA R1 operates as an integrated whole, together with POCA.
• Ensure that NBA R1 meets the business requirements (Functional and Non Functional).
• Ensure that all end-to-end processes work as expected with NBA R1, and fully support POCA’s requirements.
• Ensure that NBA R1 meets usability requirements.
• Ensure that NBA R1 meets acceptance requirements.
• Responsible for testing of the application.
(Client) Bessemer Trust Inc (NJ)
(Integration and Functional System Testing Assignment)
Bessemer Trust Inc is a Wealth management firm with over $36 Billion in assets. It provides clients with a fully integrated combination of Asset management and Estate, Tax and Wealth transfer planning.
Customer Relationship Management (CRM) a product of Siebel Inc is being implemented to replace a paper based business workflow used by Bessemer Trust Inc with its clients. CRM is a Web Based Client – Server system. The overall responsibility for implementation of the project lies with Sapient Inc (Management Consultants). The system provides the following Modules:
• Family Groups, Contacts, Relationships, Activities, Accounts, Sub – Accounts, Employees, Data Management System (DMS), Address Mail Merge etc., Responsible for testing of the application.
(Client) Prebon Yamane (NJ)
(Functional System Testing Assignment – Japanese Bond Trading System)
Yamane connect system is being designed to replace a voice paper based business workflow. The system provides:
• Real Time market data display for brokers
• Real Time, delayed and tired market data display to customers
• An easy to use order and deal entry
• Deal check and verification
• Deal notification
• One to one chat forum capabilities
• Responsible for testing of the application.
(Client) Tullet & Tokyo Liberty Inc. (NY)
(Integration and System Testing Assignment)
3-tier Client Server Web based odd lot trading system dealing with treasuries. System handled maximum of 1 million securities. System included in-house developed front end and Quant Trading Sector / Stars used for Repot trades. Back office functions were oracle based.
• Responsible for standalone testing (test design, execution and defect reporting) of Sector and Stars.
DMR Consulting Group Inc (NY)
Business Analyst/ QA Analyst
(Client) Simon and Schuster Inc.
Oct 98- Dec 99
Conversion of legacy data into SAP and then populating this data from SAP into the corporate data warehouse (CDW) which is Oracle based which further sends the data to the downstream systems.
• Performed Integration Testing of SAP (FI, SD and MM modules) business application and CDW
(Corporate Data Warehouse)
• Tested Reconciliation G/L in SAP business application and Corporate Data Warehouse (CDW)
• Used SQL queries to verify Oracle (CDW) design
• Designed and developed Test Plan, Test scripts and Test cases needed to verify system specification
• Performed Y2K testing on SAP To CDW integration data
• Defect Tracking using PVCS Tracker
Computech Inc (NJ)
QA Test Analyst
Nov 95- Sep 98
End to end system testing, regression testing of consumer ordering systems. The objective is to test an
End to end solution to achieve automated flow through provisioning of services from customer marketing systems down to billing systems. The project involved the following:
• Invoice and billing system
• Purchase order processing system
• Financial accounting system
• Payment tracking system
• Responsible for testing of the application.
Contact this candidate