Data Analyst Team Lead

Rajeev P Dhanawade

**** * ****** **** **, Bloomington, IN 47404

Email: ***********@*****.*** Phone: 302-***-****

Summary of Experience and Qualifications

Experienced data professional transitioning to a Data Analyst role, with a strong background in database administration and data modeling. Played a key role in data migration projects, including moving applications from legacy mainframe environments to open systems. Skilled in SQL Server and DB2, with a focus on leveraging data insights to drive business decisions. Eager to apply analytical skills and technical expertise to contribute to data-driven strategies.

Current Experience

Industry: Product Development: Technology

Organization: Cloudframe Inc

Start Date: January 2025

End Date: July 2025

Role: Team Lead / Mainframe SME

Cloudframe Inc. is an organization that has developed a Modernization Suite that is the most advanced legacy modernization software in the industry. Leveraging Agentic AI with unrivaled capability, CloudFrame provides deep understanding of existing systems before implementing a Retain, Refactor, or Reimagine modernization strategy. Despite accelerating SME attrition, CloudFrame enables organizations to first understand their legacy applications—then modernize strategically, intelligently, and with purpose.

The target of this suite of products is to convert legacy COBOL code into Java and to document the application using AI.

Role: As a mainframe SME, I was hired to provide critical initial analysis of COBOL programs from prospective clients. I familiarized myself with the primary product (CodeNavigator) of the company and designed, developed and conducted courses for employees of a partner organization.

Technical Environment: Windows 10/11, Unix, COBOL, Java.

Deloitte Experience

Industry: Public Sector Service Area: Technology

Service Line: Application Management Services Additional Service Lines

Start Date: September 2023

End Date: December 2024

Role: Team Lead

Commonwealth of Pennsylvania Department of Human Services.

Data Migration – The Commonwealth of Pennsylvania has been moving its applications from Legacy Mainframe environment to Open Systems. In this last phase of Incremental Renewal, data which was not migrated earlier are in scope to be migrated. The source data was a mix of flat files, DMS (hierarchical) and RDMS (relational) models. The target was Oracle.

System Study and Re-engineering – As part of the Incremental Renewal, functionality that was not previously migrated is within the scope of this release. The methodology for this exercise is to analyze existing mainframe programs to generate functional specification documentation which is validated by the functional team with the client before creating functional specifications to be developed and tested by developers and, finally, implemented in the Open Systems.

Inventory Master maintenance – There are over 12,000 components that make up the Integrated Eligibility system. These are listed in an Excel Spreadsheet. This spreadsheet contains data points about the components like whether the component is active or inactive, which functionality it belongs to and some other information. As this list was started in 2018, I worked with two SMEs who were knowledgable about the project along with 1.5 FTEs and updated the list. This exercise also served a verification of scope to ensure that nothing was missed.

Role: As a Team Lead on the Incremental Renewal project for the Commonwealth of Pennsylvania, I lead a team of 9 individuals across three areas of responsibility – Data Migration, Inventory Maintenance and System Study and Re-engineering.

Technical Environment: Unisys 2200, DMS, RDMS, Oracle, TFS, Windows 10/11, MS SharePoint, COBOL.

Industry: Public Sector Service Area: Technology

Service Line: Application Management Services Additional Service Lines

Start Date: November 2007

End Date: August 2023

Role: Project Manager/DBA/Data Modeler

State of Delaware Department of Health and Social Services (Division of Social Services).

MCI – This was an application that collected demographic information related to individuals that apply for any of the benefit programs administered by DHSS. Each applicant is assigned a unique identification number that is then used to reference the individual in all applications within DHSS.

ASSIST Worker Web (AWW) is a modernized version of DCIS-II which was a system developed to support the delivery of welfare to the residents of Delaware. It is architected on the Windows platform and was designed to collect and verify information on welfare applicants, calculate and deliver benefits based on policy. The application was continuously upgraded functionally and technologically to serve the neediest population of the State of Delaware.

ASSIST Self Service is a portion of Integrated Eligibility and it allows applicants to explore their eligibility and directly apply for, view and renew benefits with DSS using the internet. They also have the facility to submit changes to their personal information.

Other applications added to the Suite are:

FORCES – This is an application that enables the State to address overpayments with recovery and recoupment. There is a separate division that addresses this and the application facilitates that process.

LIHEAP – This is an application that tracks and manages applications for Low Income Home Energy Program.

DCIS-II is the legacy system developed to support the delivery of welfare to the residents of Delaware. It was architected on a mixed platform of Windows and IBM Mainframe. The Windows platform handled the User interface while the IBM platform handled the business processing and data storage.

The DCISII system has been modernized and replaced by the ASSIST suite of applications. As a subject matter expert, I provided guidance and necessary information to personnel assigned to this project as necessary.

Role: As Master Data Modeler on the Delaware Modernization project, I was responsible to control all changes to the database so that they fit into the overall Data Model.

As Master Data Modeler for the Maintenance contract, I oversaw day-to-day activities of the database management activities. As Database Administrator, I provided support for maintenance of database to ensure performance and integrity of the application. I assisted the State with technology decisions and Software upgrades.

Technical Environment: Redgate, SentryOne, ErWin Data Modeler, SQL Server, TFS, Windows 10, MS Project, CICS, DB2, COBOL, IBM Z9, PowerBuilder, TransAccess, zServices, zDirect, TMONMVS, TMONDB2, TMONCICS, BMC Change Manager, Serena Software version control, IBM File Manager (MVS & DB2), IBM Fault Analyzer, IBM debugger, Mainview.

Previous Experience

Industry: Public Sector Service Area: Technology

Service Line: Application Management Services Additional Service Lines

Organization/s: ISC/Waypointe/Syntel/Indes LLC

Start Date: May 1996

End Date: November 2007

Role: Project Manager, DB2 Database Manager, Application Architect

State of Delaware Department of Health and Social Services (Division of Social Services).

DCIS-II is a system developed to support the delivery of welfare to the residents of Delaware. It is designed to collect and verify information on welfare applicants and calculate benefits based on policy.

Role: Prior to becoming a Deloitte employee, I managed all day-to-day activities of the project in the absence of a Deloitte Manager onsite. As Database Administrator, I maintained the database to ensure it supports the needs of the application. I participated in the project from the beginning (since 1996) and started as Sr. Analyst. In this role, I was part of the Data Exchange team, gathered requirements and documented the SDX process. I was involved in the initial requirements gathering phase and was part of the team that designed the architecture and documented standards on the project. I also helped the State of Delaware with technology decisions and Software upgrades.

Technical Environment: CICS, DB2, COBOL, IBM Z9, PowerBuilder, TransAccess, zServices, zDirect, TMONMVS, TMONDB2, TMONCICS, BMC Change Manager, Serena Software version control - Changeman ZMF

Industry: Public Sector Service Area: Technology

Service Line: Application Management Services Additional Service Lines

Organization: Ministry of Interior, Qatar

Start Date: November 1988

End Date: May 1996

Role: Lead Analyst

A Government Ministry engaged in protecting the sovereignty of the Sovereign State of Qatar and in the welfare of the Residents of the State. The Ministry is responsible for various departments such as the Police Force, Immigration and Traffic departments.

During my tenure at the Ministry of Interior, several projects were completed, including the implementation of applications for the Immigration Department, Department of Motor Vehicles and the Police Department.

Role: As a lead analyst I led the implementation of the Qatar Identification system - a national identity system, Residence Permits system for the Immigration department, Visa System, Company Indexing, Police Identification, Driving License and Immigration Control System. I also conducted classes and seminars for local employees in COBOL, CICS, DB2 & MVS/JCL.

Technical Environment: IBM 2086-A04, IBM 4381, Intel based IBM compatible PCs, Windows 3.1, CICS, DB2, COBOL II, TELON

Industry: Public Sector Service Area: Technology

Service Line: Application Management Services Additional Service Lines

Organization: CMC Ltd.

Start Date: August 1981

End date: November 1988

Role: Associate Systems Engineer/Computer Operator

A Government of India Enterprise that started as an Organization that took over support operations for IBM machines when IBM left India. It later diversified into a Company committed to One Point Support in all aspects of the Computer and Information Services.

I was initially involved in the daily operation of Data Center functions. Later I applied for and qualified for the Systems Trainee program by passing a nationwide competitive exam. A major project was the development of a National Online Inventory Control system implemented on the first nationwide network of computers.

Role: I started as a Computer Operator responsible for the daily data center operations. I competed and qualified for a one-year Systems Trainee Program conducted by the company and was promoted to Associate Systems Engineer (ASE) on successful completion of the program. As an ASE, I was part of a team of 17 that undertook the development of an Online Inventory Control System that was implemented on the first nationwide commercial computer network in India. It was implemented across 113 locations nationwide and I had the privilege of being part of the team that demonstrated the System to then Prime Minister of India. I also designed and conducted seminars on CICS/VS, MVS/JCL & MVS/JECL.

Technical Environment: IBM 4361, TDC-316, Intel based IBM compatible PCs, MS-DOS, CICS, COBOL II, VSAM

System Experience

Software / Products: CICS - expert, DB2 - expert, TransAccess - expert, zServices - project experience, TELON - expert, BMC Change Manager - expert, Serena Changeman ZMF - expert, COBOL - expert, PowerBuilder - project experience, C# - training only, TMONCICS - project experience, TMONDB2 - project experience, TMONMVS - project experience.

Proficiency Key: Indicate proficiency as "training only," "project experience," or "expert".

Hardware / Operating Systems: IBM 2086-A04/ICCF, DOS/VSE, MVS - project experience, IBM 4381/TSO, MVS - experience, IBM Z9/TSO, MVS, z/OS - expert.

Middleware / Databases: TransAccess - expert, zServices - Project experience, DB2 - Expert, Microsoft Access - Project experience, SQL/Server - project experience.

General Tools: Microsoft Excel - project experience, Microsoft Word - project experience, Microsoft Power Point - project experience, Microsoft Project - project experience, Access - project experience.

Education

BS - Chemistry and Physics

Bombay University

Graduate Diploma - Computer Management

Bombay University

Professional Affiliations / Certifications

IEEE

DB2 V9 for z/OS IBM Certified DBA

PMP

ITIL

Lean Six Sigma – Yellow Belt

Training

DB2 Database Administrator for z/OS - conducted at IDUG conference May 2008

C# - in-house course conducted by Rob Partee, Manager, Deloitte

Microsoft SQL Server – DBA certification

Publications

White Paper - • An unusual approach to tuning in DB2 https://kx.deloitteresources.com/G1000/Lists/PublishedContent/DispForm.aspx?ID=88141&Source=http%3a%2f%2fkx.deloitteresources.com%2fG1000%2fLists%2fPublishedContent%2fAll+Documents+by+Title.aspx

Presentations

Designed and Conducted seminars in CICS, MVS/JCL, MVS/JECL at CMC Ltd. to a team of developers from Datamatics Corporation to prepare them for an overseas project.

Conducted seminars in CICS, DB2, COBOL and MVS/JCL to a team of Officers of the Ministry of Interior, Qatar.

Foreign Language Skills

Hindi, Marathi, Kannada – Native

Contact this candidate