Employment

2005 -  Present

QA Data Store

Long Term Care Group is the nation's premier supplier of outsourced services in the long term care insurance industry. LTCG focuses solely on delivering superior products and services for their clients. LTCG is a 1 stop organization that offers a complete platform of long term care insurance services, product development and administrative and backend support for both group and individual markets. LTCG's experienced staff knows the industry and customizes long term care insurance solutions for each client's specific needs.

My responsibility was to define a strategy for Testing the Actuarial Data Store built using DataStage and MS SQL Server as the backend.

Following tasks were to be completed :
Define a Test Strategy for testing the DataStage jobs

Own the process document for implementing the Best Practices in DataStage development

Create Templates for Test Plan, Test Scenarios, Test Cases and appropriate Test Scripts

Use Track Record for Defect management and generate reports on defect metrics

Use Visual Source Safe for Version Control of documents.

Prepare Test Scripts for testing the Interface Objects developed in MS SQL. The SQL scripts and Stored procedures had to be tested before calling them in the source DataStage jobs

Own the Version Control for promotion of jobs using DataStage Version Control, DataStage Manager.

Test the jobs using DataStage Director and Designer. Verify that the Load in the target has the business rules applied on the source data by executing alternate SQL scripts using SQL Analyzer

Manage the timeline on a base lined project plan in MS Project

Environment : DataStage 7.5 MS SQL Server 2003 MS SQL Analyzer, Visual Source Safe, Track Record, MS Visio, MS Project, MS Office, Win XP, Citrix remote connect

2004 -  2005

UAT Manager

Moody's Investors Service, is among the world's most respected, utilized sources for credit ratings, research and risk analysis. In addition to the core ratings business, Moody's publishes market leading credit opinions, deal research and commentary that reach more than 3000 institutions and 22000 subscribers around the globe. They have offices in more than 26 countries.

In accordance with the Federal Regulations, all Reports reaching the investors have to comply with the Sarbanes Oxley Act of 2002, Section 404 This is audited by leading Audit companies based on the results from User Acceptance Tests of the products released by Moody's and used by Analysts worldwide.

My responsibility was to define a strategy for UAT to test the Analysts Tools developed in-house.

Several tasks enumerated below were to be completed before the financial year ending :
Define a Test Strategy for UAT

Modify the company wide 'Policy and Procedure Document' to include UAT requirements, highlighting Management's role in assessment.

Create Templates for Test Plan, Test Scenarios, Test Cases and appropriate Test Scripts

Use Qtrack, a company wide Task and Issue management tool, where Users reporting issues are resolved by the developers, unit tested, QA verified, before subjecting to UAT. The tasks logged as Request for Enhancement or Request for Maintenance, were additionally re-processed by the design team before being submitted to the developers

Use Visual Source Safe for Version Control of documents.

Prepare Test Scripts for testing the Analyst Tools and Qtrack issues.

'Own' the UAT process to map the results to the Auditor's requirements for Management's Sign Off on the 'Acceptance Release' document after all UATs were PASSed.

2003 -  2004
Test Manager

HealthPartners, a Minnesota based Health Care Insurance company, is building a Data Warehouse to address several goals for improving the health and saving money for its employers. This facilitates HP to leverage non claim data into demonstrated care improvement activities.

My primary responsibility was to conceptualize a departmental testing facility to test a Data Warehousing project, with the following key tasks :
Working closely with the Program Manager, managing testing resources for 4 projects, monitoring the Test process, version control and Bug tracking process

Define Test Strategy for testing Data Warehouse components developed using DataStage, Oracle Reports and Business Objects Reports. Based on the Iterative Project Management, taking the customer feedback at each level of sub deliverable.

Responsible for conducting technical quality reviews on deliverables which include the review of design documents. Subsequently, tailor a deliverable based test strategy, maintaining consistency and compliance with HP standards and development methodologies.

Timesheet management for all test resources to balance their productivity

Quality metrics and testing progress presented periodically to the management team, taking care that projects do not slip schedule, optimizing the test process using Critical Path Method.

Obtain 'Sign-off' on the Test documentation from the business users

2003 -  2003
PVCS Version Manager

Project Manager

Managing 14 projects, monitoring the Requirements, Analysis and Design team

Team spread over New Jersey, Pennsylvania, Delaware and Virginia

Initiate RAD, JAD and Inter RAD meetings and attend them

Issue Management, Management and planning SOWs for team

Several issues on System Integration were to be addressed during the project management.

updating the project status to the management and taking care that projects do not slip schedule

2002 -  2003

Project Manager or Security Auditor

Defining the policies for administering SWIFT services for the Securities and Financial customers

Integrate and implement the QMS policies and ISMS policies

Conceptualized the Disaster Recovery and Business Continuity Planning for Banking Industry as per Federal rules

Build the Information Security Management Policies. Obtain management approval on the Quality Manual and Policies for implementation

Plan the Infrastructure set up process for a financial institution and build a network to manage messages

Environment : VISIO, MS Word, MS Power Point, MS Project, MS Excel, WIN NT, XP.

IN-HOUSE
Risk based Project Manager, Business Analyst
Handling and managing several projects to be controlled using MS-Project. All the data from different team members and projects were entered and from the general repository the resources were deployed.

Managing web based projects, centralized bug tracking and resolving issues and reporting to the management.

Conducted pre audit gap analysis to bring all the projects under standard SDLC processes, as applicable. Operations Planning for Financial Services Group of the company, involving Scoping, Scheduling and preparing Project Plan and metrics and creating a WBS Chart.

Implementing features of MS Project Server 2002 using Project 2000 having the following functionalities :
a. Centralized resource pooling

b. Utilizing features of MS-SQL Server technology and XML based support, multi tier and OLAP to manage multiple projects on a server

c. Extensive WBS and Project planning features

Prepare business presentations for technical discussions and participate in workshops and conferences for enhancing the business prospects.

Taking care of the technical documentation in line with the quality policies.

Conceptualize, plan and define site set up, processes, test and implement the entire suite of Disaster Recovery for the Financial Services. Plan included management issues related to Return of Investment and Payback.

2001 -  2002

Compaq Partner Network CPN, Compaq Customer Network CCN

Project Manager, Business Analyst

Compaq Partner Network project used Microsoft Technology, Vignette Story Server and Oracle as back end.

Involved updating on-line orders received from Call Centers across the world.

Customer support and helpdesk information routing with traffic management

Executed in an on-site/off-shore model with a saving of about $ 1.5 Million.

Prepared Team Chart, Responsibility Charts, Reporting Heads, WBS notes, etc.

Used MS-Project extensively for the offshore operations in Budapest, Hungary with an on-site group of 5 developers in Houston, USA, managed using Primavera TeamPlay Project Manager.

Define a migration plan for key functional departments managed from Marlborough, MA, onto the central database server at Houston, TX.

Scoping and implementation of Web based Middleware components during the migration.

Documents versioned by storing in VSS

Between the 2 projects, demonstrated excellent resource sharing capabilities and had the distinction of converting a 40 - distributed on-site software support and development team to a cost effective 31 member team using an on-site or offshore methodology for a centralized development and support model.

Environment : ASP, MS-SQL, Oracle, MS-Project, Primavera TeamPlay Project Manager, VSS, Vignette Story Server, Win 2K, NT

IN-HOUSE
Project Manager, Business Analyst
Scoping an e-commerce project on on-line training and University valued at US $2.1 Million for a professional training company. Testing prototypes using WinRunner during the business analisys

Feasibility Study, Business Planning, estimation using IFPUG FPA CPM 4 counting practice manual processes the FPCs for the projects at Compaq, scheduling and delivery plan for a year was worked out. Prepared WBS and team responsibilities structure across the team.

Planning and feasibility study of a US $3 Million project for web enabling an ERP application. An on-site/off-site/offshore combination is worked out for execution. Product to be developed, migrated from the UNIX environment to the Windows environment.

Initiated a plan for data warehouse project, feasibility gap analysis worked out and ETL process studied. Working on new strategies of implementation

Technical Documentation preparation and reviews.

Work with SWIFT Business Managers on planning and delivering SWIFT services.

2000 -  2001

Contract Labor Management

Project Manager

This is an integrated e-commerce CRM solution developed using Microsoft Technology. This application consolidated business applications and processes by integrated various satellite applications and databases and removing redundant applications. Complete consultant management was possible with localization, multi country, multi currency changeover properties for payment and receivables. Worked on extensive Business Intelligence reporting, planning and delivery milestones throughout the project. Several Change Management Processes were implemented and reporting was reviewed on a continuous basis. Test suites, Test plans were scripted, reviewed and executed throughout the project at various levels. Few interface modules tested with WinRunner.

Phase II of the project with Oracle as back end for another multi national client, UNISYS. Managed the project metrics using 2 different Estimation Methods. This was an 11 man year project with 22 developers, 2 project leaders executed on an on-site, offshore model.

During the execution of the project I received bonus for managing this responsibilities and setting up the Centralized Testing Center .

Environment : VB, ASP, COM, MTS, XML, MS SQL, Oracle, IIS, Rational Rose, Visio, Crystal Reports, MS-Project, WinRunner, Win NT, 2K.

Partners for Advanced Carriers in Technology, NY

AIQ Historical and Dynamic Charting

Project Manager

Development of components and applets, functioning as standalone application for trading. There are 2 ways of fetching data from different servers at Stock Exchanges through MyTrack host, 1 is Historical and the other is Dynamic Intraday. Historical fetches the data till the previous day. User can fetch daily, weekly and monthly data to draw the chart. Dynamic Intraday would fetch data for fixed intervals. This is in minutes or hours for last 30 days which is accomplished using threading. The properties like color, Grid and Plot Spacing is set for each graph. Overall testing the product with WinRunner.

Environment : Java, Java 2D, Swing, Applets, Applet Security, Policy Tool, JavaDoc, Rational Rose 2001A, Gateway Package, VSS6.0 WinRunner, Forte for Java CE 3.0 MS Project, ERWin, J2EE

WINEMART,
France

Data Mining

Project Manager/ Business Analyst

Data mining was performed in the project involving coding scripts written in Webl and running on Linux. The driver would spider scan the entire internet for all available brands, prices, year of manufacture and location availability across the world, etc. Once they were mined, the data was sorted accordingly and report generated.

Prepared Data and Work Flow Diagrams, Converted DFD in to Business Flow Diagrams, leading to detailed documentation of the processes.

Defined an Entity Relationship Model ; studying the cost of an incomplete ERM and its impact on the project during execution.

Provided technical guidance and leadership in designing and building of several functional modules ; services, user authentication and authorization ; a new database and a new module that extracts data, formats the data and inserts it into the new tables in the central database.

Environment : Webl, MySql, Linux, Win NT, Weblogic Tuxedo Application Server

New York Medical College, NY

Project Coordinator

Project involved in the accounting of all the janitorial services and basic waste management system for NYMC. It was collecting, validating all the information fed in to the system and reconciled. It involved in automatic release of purchase orders, few inventory alert messages, etc.

Prepared a checklist comprised of impact on Human s, Equipment Requirements, Control Strategy Requirements, Performance or Service Level Agreements Requirements, Implementation Requirements and Training Requirements.

Environment : Cold Fusion, MS-SQL, Win NT, MS Project, MS Visio

Johns Hopkins University, MD

Project Coordinator, Business Analyst

Clinical Trials on Mammography Medical Research projects developed using Cold Fusion and SQL Server. Cancer related project modules developed and maintained. Performed architecture and OOAD design.

Setup an exclusive testing team. Guiding and reviewing the test plans, test specifications and estimation of the projects. Extensive testing procedures, templates adhering to Quality standards developed and implemented. Managed the project through the SDLC Process using MS-Project

1999 -  2000

Email Station

Project Manager

A specialized product which would send email without the computers and ISP, using Embedded System development and Telecommunication using RTOS. Had an opportunity to establish an exclusive product testing center for testing the developed email station called iStation .

Generated comprehensive Product Specification and Functional Requirements for the web site. Implemented Change Management Processes, with job responsibilities and reports generation

In conjunction with the marketing department, developed a strategy using the Retail Management System for the distribution of the product on a regional and state wide basis.

Environment : ArmCore Processor, C, C++, RTOS, Win NT

ADELA TECHNOLOGIES,
Australia

On-line Stock Processing

Project Manager

Designed a detailed impact analysis for an On-line Stock and Trade Processing project. Several options were studied on how the stocks were received, statistical analysis processed using rules based techniques, graphical presentations, alerts using email, pager alert, were implemented. Study was conducted the feasibility of mobile alerts.

Environment : Java, Macromedia, Adobe, Acrobat, Site Server and ASP

SURINAME ASSOCIATES,
Suriname

Multi point Accounting

Project Manager

A project in South America necessitated my expertise in resolving the bottlenecks in a multi point accounting process. An elaborate breakdown process was adopted ; modules and sub modules were identified and coded using Power Builder and Sybase.

Environment : Power Builder, Sybase, MS-Project and Flowchart

MISQ,
Israel

Bug Tracking Tool

Project Manager

A web based centralized Bug Tracking Tool was made for the manufacturers. The manufacturer would enter the product under current distribution worldwide. All over the world if the report were diagnosed to have a bug, it would get reported on this tool, for later action and closure.

Environment : Java, IIS, Win 98

Global Edge Software, CA

Retail Management System

Project Manager

Managed client server and web based applications in the areas of Retail, Point of Sale systems, Inventory involving Project Management, Project Reporting, reviewing, designing, problem solving, etc

Developed in the similar lines of RetailPro, a used international Retail and POS application.

Environment : FoxPro 2.6 Oracle

TRANSPORTATION DEPARTMENT,
Indonesia

Traffic Controller

Business Analyst

System Analysis on a business process evaluation project, in a CT performance test development, for an Indonesian project was to use a DB2 or DB2 Connect, SCO Unix, NT, Java, Weblogic and Apache, for their Traffic Controlling. Alternate analysis was worked using Oracle as the back end and got the approval subsequently.

Skilled in preparing Feasibility Analysis, User Specification Document, User Requirement Document, Gap Analysis Document, System Analysis and Design documentation and User documentation

Environment : MS-Excel, MS-Power point, MS-Project, Visio

IN-HOUSE
Projects executed in e-commerce, e-governance, Web Authoring Tool, Device Drivers on Windows 9x/NT and OS/2 platforms and Portal development using Java, ASP, JSP, Site Server

Proposal for Fax over IP and Feasibility report for Voice over IP

Collaborate in Quality Audit on the Real Time, embedded systems and system software projects especially in the defense sector. Conducted 12 Security Audits for Defense Projects.

Heading the testing group, thorough scrutiny of the SDLC Test plans, specification templates, etc. and provides technical expertise by evaluating test designs for development engineers

Overall Quality Process implementation and QA process reviews. Using FPA and Dr.Han's estimation techniques for close monitoring of the metrics in over 11 projects simultaneously. Position demands reporting to the Managing Director the process status and adherence to ISO standards in line with the management representative of Quality department

Initiated data marts using SQL server 6.5

Perform weekly risk assessment.

Environment : MS Excel, MSWord, MS Project, MS-Access, WordPerfect, VI Editor, WordStar, Java, VB, ASP, JSP, XML, HTML, SQL Server, Macromedia, WIN xx, Linux, OS/2.

1997 -  1999

Y2K Migration projects

Project coordinator

2 projects on Y2K conversions from Tandem based codes to the PC based code using Micro Focus Tool, Revolve, CICS, COBOL

Provided consultation on the usage of the Internet ; Presentations on Web, Internet markets , Software market identification , Significance of Y2K Compliance using MS Office PowerPoint ; organizing training schedules for Y2K on Micro Focus platform

Environment : Revolve, CICS, COBOL, Tandem, Win 95

INNOVA PRINTING and PACKAGING

Printing and Packaging Management Applications

Business Analyst/Sr. Software Analyst

Formulating extensive WBS reports, task assignment, milestones, resource management and areas of responsibilities

Conceptualized a detailed Production plan for the Printing and Packaging Co.

Consultation, on-site planning, layout designing, system analysis ; Web designing, marketing and productivity v/s profit analysis management consultation in several projects

CLINICAL DIAGNOSIS

Saber Diagnostics

Project Lead, Manager

The package was fully user friendly, having patient acceptable entry methodology, intermediate approximate diagnosis approach for patients, leading to the diagnosis by the Doctor. The development was in Visual Basic, MS-Access, Win 95

1994 -  1997

Senior Software Engineer

Designing and coding a total solution on Cooperative or Retail Banking, helped in developing and implementing the projects with data processing, periodical backup arrangement and maintenance support facilities.

Environment : Visual Basic, MS-Access

ELECTION COMMISSIONER

Photo ID Cards

Account Manager/ Project Sponsor

Managed 2 projects for the Election Commissioner, 1 of 11 months and another of 18 months, involving project planning, acquisition and installation of the equipment used for the project. This involved extensive financial planning through VC Funding and funds management, resource management managing 426 persons in 1 project and about 90 in the other, based on roles, time frames and involvement level for the various phases of the project. The project, managed using MS-Project, had to be accurate, quality maintained and in the budget. Entire project was developed using FoxPro and data migrated to Oracle for future use in the state wise general database.

Environment : MS-Project, FoxPro 2.6 Oracle

Higher Secondary Education Board

Departmental Package

Senior Software Analyst

A 4 - month project, it was divided into 4 sections - Inspection, Establishment, Planning and Accounts. This involved 4 team members Technical writing of User documentation, software test reporting.

1989 -  1994
Student Data Administrator

Versatile packages to maintain purchase details, control and process details from different departments with respect to office procedures ; maintain student data, print consolidated marks and grade sheet, courses taken by faculties, issuing memos ; maintain staff profiles, project, schemes details, publications

Graphics Simulator

In 6 months conceptualized and developed a Graphics simulator of the layout of a nuclear power plant using C on IBM PC The package was used for educational demonstration of the working and flow of a nuclear power plant

MISCELLANEOUS PROJECTS
In 6 months developed a utility package for X-Y plotting using BASIC on the CP/M system on Z80 processor. The package contained writing program for generating tables of data, reading them and plotting them on the screen after scaling as per the user requirement

In 1 year generated a database of list of scientists using dBase. The database was used for IBM PC It contained facility for updating the records every year or depending on the user requirement

In 4 months debugged a large program on DEC/1090 for the injection system of IC engines. Debugged a program for the gas system. Porting, migration of the same to the VAX, VMS system. Extensively managed the version control using tools on VMS. Involved in training programs conducted by the company.

1984 -  1989

Education

Miscellaneous
Publications : More than 3 Technical Publications and International Conference or Workshop Presentations

Academic Certifications and Affiliations :
PROFICIENCY
Certificate in Psychology in Management

Certificate as Lead Auditor in Information Security Management System, BSI

Certificate as Lead Auditor in Quality Management System, QMI

Certificate in Software Testing

Certificate as Internal Auditor in ISO 9001

Essentials of Project Management, QAI

Member, IEEE

Board Member, TCQAA

Member, Project Management Institute, pursuing PMP certification

Alumni Member, Indian Institute of Science, India

MS-Project, Primavera TeamPlay Project Manager, Iterative Project Management, Ascential DataStage, PVCS Version Manager, Visual Source Safe, PVCS Tracker, Oracle SQL and PL/SQL Developer, Oracle Reports, Business Objects, MS Office, MS Visio, VB, XML, HTML, MS SQL Server, SQL Analyzer, Track Record, Cold Fusion, J2EE, EJB, JAVA, JSP, Servlets, JDBC, C/C++/VC++, Visual Foxpro, PB, Sybase, Webl, FORTRAN, Power Builder, Pascal, BASIC, Mercury WinRunner, Rational Suite.

Aerospace Projects

For the Aeronautical Research and Development Board, in the 27 months of experience on mainframes ; solved FORTRAN problems, debugged old programs, porting, migrating them on to PCs. Compiling several data from various computers across the country - meteorological centers - statistical evaluation, using telnet across the world. Developed a program for defining a standard reference atmosphere for the tropics based on mathematical model on VAX-11/730 IBM 360 DEC 1090 and CDC CYBER

Conceptualized some of the scientific and research based statistical problems using Matlab and Fortran

Designed and programmed several defense programs using Random Number Generator and used Graphics Plotting utilities like XY Plot, Calcomp plots, Grapher and Surfer. Used several statistical methods like randomized, chi square test, regression, correlation and time series for the projects. Programs were subjected to Monte Carlo simulation for understanding their performance

Coordinating with several voluntary groups as a lead member in organizing meets, fund raising, camps, social functions, etc.

Environment : DEC 1090 CDC CYBER, VAX-11/730 FORTRAN, MATLAB, Mathematica, Grapher, Surfer, Calcomp, Monte Carlo Simulation, Random Number Generator, Chi Square Test