Summary of Experience and Qualifications

Experienced Technical Project Manager, Technical Consultant, Data Architect and Database Designer with profound knowledge of Design, Development, Testing and implementation of large software applications. A strong leader, excellent team builder and manager with sound technical skills on multiple technologies. Has managed many high values, mission critical projects and has the ability to lead teams to successful completion. Pioneer in onsite / offsite / offshore project model.

Achievements:

• Problem solving: However big an issue is, it can be solved relatively easily if one understands what exactly the issue is.. Whether technical or non-technical or managerial or any type, most of the issues can be prevented and / or mitigated if one has the ability to foresee with the slightest of the symptom of the occurrence. One who does not know what the problem is can never solve the problem.
• I have the ability to lead, manage, and work harmoniously with technical and non-technical teams and individuals.
• Managed many multi-million Dollar IT projects, which includes turnkey projects starting from System Requirement Specification through design, development, testing, and up to implementation, and / or data conversion. Clients: Dixons Curry, UK. British Gas, UK. Hindustan Machine Tools HMT , India.
• It is to be noted that I had/have been managing data conversion for two major Projects ProviderOne for WA State and HealthPlanFinder during Jul 2012 Jun 2013.
• ProviderOne: Data Migration from multiple Legacy systems to State-of-the-art Technology System for Health Care Authority, Washington State. About 2 Billion records have been migrated, and every record migrated has been validated in an automated way Legacy to OLTP Database and OLTP to Data Warehouse. This was an innovative technique that I had brought to the project, and that proved to be one the main reasons for the success of the project. CMS Center for Medicaid and Medicare Services Federal Agency had certified the System with zero Findings. WA is the only State to achieve this feat while every other States had Findings. Phase 1 completed and Phase 2 implementation in early Jan 2015.
• Affortable Care Act Obamacare WA State HealthPlanFinder. Managed the Database design and Client data migration from Legacy system. Data migration was one of the smoothest processes in the system.
• Managed major IT projects for Holland America Line luxury cruise line , Seattle from 1997 through 2007. Led various teams including business stakeholders besides the technical teams for, a Revamping their mission critical Cruise Reservation System, b building a brand new decision support system DSS , which included massive data migration from Legacy OLTP Systems, c Merger and Acquisition project which involved the migration of the Reservation Applications as well as the data.
• Managed teams consisting of various sizes up to 100 software professionals plus. I am more comfortable on managing very large and complex projects.
• Once I am in command, the upper management would get up-to-date information about the projects to the level of the details they would require. The management will never have the anxiety about the statuses of the project s . I foresee the potential issues in advance, and resolve them even before they can show up. I have the ability to build a strong team from any group of individuals, and their combined throughout would be much greater than the sum of their individual normal throughput.
• Turned around the projects that were failing.

• Within a short period of time after taking over the responsibility, identified the causes for the failure, and collaborated with the Executives, Key stakeholders, and the Primary vendor, devised new mechanisms to move forward in an accelerated fashion. The mechanism I devised to convert and validate 100 of data not just sample was unique not many would have even attempted to use such techniques while converting such a massive amount of data. Success achieved through:
• When I took over the Data Conversion responsibility in mid 2007, the project had been in a critical stage. Earlier three Data Conversion managers had come and gone without making any progress during the previous 2 years. Data conversion was the central focus of the upper management / executives.
• Confidential largest health care purchaser, responsible for providing comprehensive health coverage to more than 2 million residents through the Public Employees Benefits and Medicaid programs. The agency provides health purchasing leadership, benefitting both public and private sectors with a focus on moving the health delivery system away from volume toward higher value and better outcomes.
• Confidential
• Involving the stakeholders in every aspect of data mapping from source to target with accurate business rules.
• Vendor management
• Keeping the management / Executives up to date on the progress
• Keeping the State DC team and vendor DC team in synch on all processes defined during the early days of my takeover.
• Applying the innovative technique of DC validation of 100 of converted data.
• Lot of on demand tools development for ensuring the accuracy of the entire ETL Extraction Transformation and Loading processes.
• Confidential Client data migration from Legacy
• Responsible for the entire Database design validation, and client data migration from Legacy and Provider systems. Jul 2012 to Jul 2013.

Project Manager

• Multi Million Dollar migration of a mission critical Reservation System from Travel Advance Cruise Reservation System TRACS to Princess On Line Advance Reservation POLAR
• Prepare project charter for TRACS to POLAR System migration
• Defining the various processes including communication processes among diverse teams
• Preparing detailed master project plan, with major milestones
• Defining the Roles and Responsibilities and assembling project teams
• Tracking actual Capitalized and Expensed costs against the budgeted costs
• Keeping the management up-to-date on the project status
• Setting up and enforcing standards in maintaining project documents
• Guiding the technical team in solution designs to meet the objectives, including Data Conversion. Collecting valuable metrics through out the project life cycle.
• Working with Operations work stream for smooth implementation support
• Successfully completed on time and within budget
• Migration of Inventory Control and Management System from Revenue Management System RMS to Yield Management system YMS
• Managing a team of professionals to convert from RMS to YMS
• Architecting, Strategizing and Managing the data conversion processes
• Enabling data daily feeds from both the old system TRACS and the new system POLAR until TRACS is totally shutdown
• Coordinating with the YMS vendor
• Implementation of the system for all the Company designated business users
• Data Warehouse and Business Intelligence Reports
• Data Warehouse Data analysis and identifying the data conversion problems
• Work with Extraction, Transformation and Loading ETL team in fine tuning the processes and ETL perfection
• Fixing data problems where existing processes cannot handle
• Work closely with WebFocus report developers, identifying causes for the report problems code problem as well as data problems.
• Budget Planning
• Working closely with the CIO in preparing conceptual expenditures CE's , and budget planning.
• SOX Compliance
• Responsible for addressing the findings identified by the SOX audit team.

Technical Environment: UNIX AIX , Oracle 9i , PL/SQL, C , MVS Mainframe , WebFocus, MRE, Developer Studio, MS Project, MS Office Tools, SQL Plus, PL/SQL

.

Project Manager

Technical Project Manager

• Managing the project developing project plan, resource scheduling, monitoring the progress status reports
• Interacting with tool vendors and customize the tools to the project requirements
• Database design and building a new database
• Populating the database from Legacy systems Data Extraction Transformation Loading ETL
• Working with third party vendors on certain specific modules and specific tables and interfaces
• Application development, testing and implementation.
• Provided daily data feed to the Business Intelligence BI Operation Data Store
• Provided various interfaces and access to various subsystems / applications in HAL
• Continuous improvement of the application predicting more accurate

RMS is a Decision Support and Forecasting System designed for helping the Marketing Division to shape up their Marketing Strategies for improving Revenue turnover and profitability. Initially the forecasting module had been developed by a third party vendor the forcasting was inaccurate and the daily data feed was non-existent. When I took over the responsibility it was in a virtual dead end state. The project was turned around with a good project plan and methodology. Remodelled and redeveloped the forecasting, alert management and User Interface UI modules for improved forecasting and usability. All strategic players in HALW are using this system. The is one of the highest rated systems, which the management sees the ROI within months of implementation of the critical modules.

Project Manager

Responsibilities includes:

• Preparing a detailed project plan
• Building teams at onsite Seattle and offshore Bangalore, India
• Delivering the Y2K compliant Codes and obtaining HAL acceptance
• Coordinating invoice process after each delivery acceptance
• Go Live
• Warranty support and final signoff
• The project had been executed like a textbook model. Received 'Employee of the Year 1998' award for successfully completing the project on time and within budget. Received appreciations letter from HAL, and also repeat business.
• This project had been commended within Mastech as the model project for a long time.

Responsibilities include:

• Establishing the newly formed department
• Strategize to get business
• Strengthen the onsite / offshore delivery model
• Work with business development team in getting the technical and commercial proposals, and strive for 40 of proposal being closed in Mastech's favor
• During my tenure as the department head we closed over 15 Million Dollar business, and I moved to Seattle to manage a flagship project.

Technical Environment: MS Office Tools

• Project Manager
• As a Project Manager of the turnkey project, Managed a team of software professionals in every phase of the software development and implementation project, and successfully completed the project.
• This was the first major high value turnkey international project for my employer in the early 90's. This project was a major milestone for India's dominance in the Software business around the globe.
• This multi-phase project has been carried out at onsite and offshore Pune, India .
• The project Phases include User Requirement study, system analysis, database design program specs, Data modeling, report and screen design.
• Highlights include:
• Complexity of the application highly integrated 700 programs 375 entities .
• Had 80 interfaces both in-coming and out-going with external systems both real time and batch.
• One of the largest Databases in the UK at that time.
• System capable of handling 1500 concurrent users, designed to deliver all A class transactions customer interacts with users/operators in less than 2 seconds. A built-in knowledge base.
• Stress tested to ensure optimal performance, before commencement of code.
• Highest project value for the company.
• Took over project management when the project was in a crisis situation, resolved obstacles, brought project back to life with successful project completion and profitable. Responsibilities also included preparing a project plan for the complete life cycle of the project, managing the project, confirming the quality requirements, achieving milestones, and ensuring collection from the customer on time.
• Played three major roles.
• As a Technical Consultant, discussed technical issues related to application/database design, considering all of the integration issues in this complex system.
• As a Contract Manager, ensured that the changes requested by customers were well documented and customers been charged accordingly. Project earned additional 1 million by going change control process.
• As a Project Manager, motivated the team members and made the project a big success. Handed over the software development phase to another person after the Acceptance of the Database Design and successful stress testing.
• Appreciated by ICL UK Program Office for the project management, people management, and the customer management skills.

• As a Software Consultant, designed and developed Performance Measurement Meters to study and analyze the performance characteristics of GoldRush/Oracle 7.0 with 1 to n processing elements. Suggested methods and means to improve Oracle 7.0 performance. Found effective sizing criteria for the Oracle database in terms of disk space and memory. Responsible for creating testing environment, tools development, analyzing the test results, making presentations during team review meetings.

• As a Project Manager, managed the development of Payroll System. The general perception was that it was too difficult to obtain user acceptance. Was responsible for conducting a system study, preparing user requirement specifications URS , completing system design, presenting design to the customer, and obtaining the customer's approval. After successful completion handed over the software development phase to a team leader in the project team.

• As a Project Manager, responsible for converting the of British Gas from ME29 to VME. Source codes were developed using ME29 Assembly language known as PLAN and XECK- COBOL very old version of COBOL . They were converted to Range COBOL known as C2 COBOL . The application was implemented on ICL's latest Mainframe system S/39. ME29 is a 6-bit octal machine, whereas VME is an 8-bit EBCDIC machine. The data was also converted along with the application code.
• The project initially had many problems to overcome major problem was, as many as three project managers had left the project over a period of three months. Responsible for stabilizing the project, lead the team and finish the project successfully on time. Development team members from primarily trainees and were trained on data analysis, application conversion and documentation. The main task was team building and team training in data conversion 6-bit octal code to 8-bit EBCDIC code, and Plan to C2 COBOL conversion. Obtained customer acceptance of the complete application conversion. Student trainees and management trainees were trained with the help of a few WORDS 2-5 experienced team members to analyze and resolve any data and application problems. The project was a grand success.

• As a Consultant, provided consulting service in Unix/Ingres, Oracle and C. Promoted the client's business and improved customer satisfaction level in Barbados and Grenada. Resolved many performance problems of customers. Organized workshops on the advanced features of INGRES and techniques to exploit INGRES tools with the aid of C language.

Confidential

provided software consultancy and support to customers. Was responsible for solving database problems, corruption, improving database performance, providing suggestions to exploit system software.