Software Development Data Analytics

Chidambaranadar Jeyabalan (CJ) 206-***-****

Email: ********@***.***

Experienced Senior Technical person with vast knowledge in Design, Development, Testing, and Implementation of large projects involving massive database design & data migration, and application development. Expert on data warehouse design – initial ETL (Mainframe databases & files) from OLTP and subsequent real time data integration. Strong leader and excellent team builder with sound technical and analytical skills, and have managed large (multi-million Dollars) projects from inception through implementation, and post implementation support for both Government and private organizations. Have been managing teams at multiple locations (onsite, offsite and offshore), and also had been managing multiple vendors in critical multi-million Dollar projects for Health Care Authority of WA State.

I enjoy working with hardcore techies (both frontend and backend) as well as business stakeholders and executives. Very strong on change control.

See below what you require and what I have:

IBM mainframe SAS programmer (Part Time)

Seq#

Your Expectations

What Chidambaranadar Jeyabalan (CJ) has

1

● Researches, designs, develops, and/or modifies enterprise-wide systems and/or applications software

Developed software applications from requirements gathering, design (file layouts & tables), application development, testing and implementation. Developed a software tool and sold it to a software vendor. Managed and trained team members.

2

● Have daily interaction with the team and client staff to identify requirements and issues to be resolved.

Fundamentally a problem solver. Possess various techniques to identify the problems and root cause; then solution to the problems will be relatively simple tasks.

3

● Work with the team to discuss options and approaches.

Yes, strong on discussing various options and identifying which one would be the most appropriate to the context under discussion.

4

● Participate in financial annual close planning. Respond to client requests for service via email and/or tickets to assure financial data passes all GAO audits.

Have been working on developing budget for the various projects. I am not new to working with Government Accounting Office.

5

● Use SAS skills to perform analysis as requested for client CFO staff. Peer review other team members SAS coding.

Very strong on analysis whether it is analyzing a problem or pure data analysis. Have been interacted with multiple teams in an organization.

WHAT YOU’LL NEED TO SUCCEED:

6

● Required Experience: 5+ years of SAS/JCL coding. Knowledge of COBOL would also be helpful.

Developed hundreds of COBOL programs and JCL scripts. Very strong on both the legacy systems and RDBMS including Oracle, DB2, MS-SQL. Expert on SAS.

7

● Required Technical Skills: SAS/JCL are required.

More than a decade of experience in SAS/JCL

8

● Security Clearance Level: Possess or able to attain confidential (MBI) clearance.

Absolutely no problem; will be able to obtain MBI when I am offered this position.

9

● Required Skills and Abilities: Must have excellent verbal and writing skills to communicate with client Finance staff and/or client technical staff, e.g. job schedulers.

Talented and well experienced on verbal and written communications with both technical and non-tech business stakeholders

10

● Preferred Skills: Knowledge of Federal financial processes, CONTROL products, CA ENDEVOR, ServiceNow ticketing a plus.

ServiceNow - Have used this ticking in various project to log, track, and resolve the issues. Strong on procedures for authorization, record-keeping, and reconciliation.

11

● Location: Remote

Perfect. I have managed teams located at multiple locations within our country.

12

● US Citizenship or green card holder required

US Citizen

13

Guarantee

I, Chidambaranadar Jeyabalan guarantee that this undertaking will be 100% successful if I am onboard.

Professional Skills

About two decades of Technical Management experience in:

oLarge scale software application development and post implementation support projects

Application development - Requirement gathering through design, Dev, QA & implementation

Strong on both Agile and Waterfall methodologies. Very familiar with when and where to use these methodologies.

Expert on managing large database / data warehouse design and data migration.

Expert on multiple programming languages, and have experience on design and development of compilers and operating system.

Both Private and Government where legacy systems have been replaced with modern technology

Innovation is my special skill, and strong on developing a strong tech team.

Expert on both mainframe technology (IDMS, JCL, COBOL) and RDBMS & beyond.

Technical Project Management. Project ownership from Project initiation through implementation and beyond.

oProject Initiation through planning, execution & controlling, and project closing.

Fantastic client facing skills

oExpert at interfacing between the technical team, the business stakeholders and executives

oGetting the full cooperation of both the Technical and non-technical teams during the entire project

oSetting realistic expectations and meeting (or exceeding) the expectations

oKeeping the management up-to-date on the project, and gaining their trust and support

Over 20 years of relational database (Oracle, DB2 and SQL Server) experience on multiple platforms

Quality conscious in everything, establishing Standards, and practicing in day-to-day activities

Highly innovative, thinker, planner, and ability to solve any problem/issue however complex it may be

Migrated 2 billion records from legacy systems to current systems with zero defects

After CMS (Centers for Medicare and Medicaid Services) monitored the ProviderOne System for one full year, they reported zero findings. WA was the only State to achieve the feat in the entire country.

Design and develop Online Transaction Processing (OLTP) databases, Data Warehouse (DW)

Provide infrastructure for Business Intelligence (BI) applications

Provide technical analysis/support as and when other team members as required

Build internal technical capabilities; thereby reduce vendor dependency.

Education

Master of Engineering with Distinction in Computer Engineering from Indian Institute of Science.

Bachelors in Electronics & Communication Engineering with Honors from Madras Institute of Technology, India. 2nd Rank Holder

Bachelors in Physics Major, and Math Minor from Madurai University, India.

Technical Skills

Operating Systems

Solaris UNIX, IBM AIX, Windows, IBM Mainframe and many other OS

Involved in the Design & development of operating systems and compilers in beginning of my career.

Languages

PL/SQL, T-SQL, C, Java, Python

S/W Developed

Multi-user Operating System, Compiler for BASIC language and many System utilities

Software Used

ORACLE up to 11g, PL/SQL, SQL Server 2014, and many other Databases

Database Admin (DBA)

Expert in Fine Tuning Very Large Database. Table - index physical placement, Work Load Analysis, Oracle User / Views / other Objects management, optimization and performance. MS SQL Server and DB2.

Tools

MS-Project, Visual Source Safe, MS Office (Word, Excel, PowerPoint) and Visio, PL/SQL, SQL*Plus, Erwin Data Modeling

Developed a tool called “SQL Optimizer” for IDMS (Mainframe network Database) transactional changes to Oracle database and sold it to a software vendor.

Remediation Tech Lead – OFM, WA State Mar 2022 – Mar 2024

Project:

This is a major project within the OneWa Program, WORKDAY core financial, HRMS, and Payroll implementation. More than 40 Agencies (95% State business) 250+ applications require remediation. The legacy financial system/HRMS/Payroll will be replaced by WORKDAY in a phased manner.

Responsibilities:

Manage and establish process for the team to:

o Identifying the mainframe and other systems that require remediation for each Agency, and gather the requirements.

oWork with the business/application owners and estimate the effort that would require to remediate each system

oWork with Agencies and OFM (Office of Finance Management) on Tech Pool Fund (biennium budget) planning.

oAnalyze the monthly status reports from agencies, provide up-to-date Dashboard with 4 months of trend and the progress of Remediation at agency level and even at system level

oCoordinate with the WORKDAY integration team, and other workstreams to meet the needs of every Agency.

Update weekly progress to the Program Remediation Director/CTO.

Technology: Mainframe applications (COBOL), Oracle, DB2, MS-SQL, Workday

Project Consultant – JELD-WEN/ABS Mar 2020 – Feb 2022

Responsibilities:

Developed and maintained detailed project plans for various large-scale projects.

Collaborated with multiple teams located in different geographical locations, including offshore teams.

Acted as the single point of contact between the customer management and the project teams, ensuring smooth communication and coordination.

Supported and maintained an existing ERP package, ensuring efficient operations.

Regularly updated executives on every phase of the project, ensuring transparency and alignment.

Managed and coordinated database changes, ensuring system integrity and minimizing downtime.

Enforced standards across projects, ensuring consistency in coding, documentation, and system architecture.

Planned and executed a major migration project, transferring decades-old data to a new platform.

Developed a powerful tool for legacy data migration to RDBMS (SQL) with minimal effort.

Created interactive dashboards and reports in Power BI, providing actionable insights for stakeholders and supporting decision-making processes.

Utilized SQL for querying databases, ensuring accurate and efficient extraction of data for analysis and reporting.

Conducted data analysis to identify trends, monitor project performance, and support business intelligence efforts.

Ensured data accuracy and quality by developing automated scripts and tools to validate data sets and streamline the analysis process.

Note: A powerful tool had been developed to migrate legacy data to RDBMS (MS-SQL) with very minimal effort.

Technology: IBM Mainframe (z/OS), COBOL, JCL, Unix, MS-SQL,

Project Manager – ELUHO New CMS, Phase II Part A Feb 2020 – Jun 2020

This was a part time position. Worked with a business analyst and business key stakeholders and the ELUHO (Environmental & Land Use Hearings Office – Washington) Director in achieving the goals of the New Case Management System (New CMS) Phase II Part A

Responsible for:

Detailed Project plan

Gathering and documenting the Business and Data conversion requirements for the New CMS Phase II Part B

Submit the final SOW (Statement of Work) that would be used for the future Vendor for developing the NEW CMS

Document OCM (Organizational Change Management) – the old and new business processes and organizational changes.

Completed the project as per the project plan submitted at the beginning of the project, within the budget and timeline.

Project Manager – Aspen Dental, Syracuse Jul – Nov 2019

Responsibilities include:

Detailed project plan

Working with multiple vendors

Large database design, and data migration

Project execution and monitoring

oKeep track of the progress

oTake necessary resource and task allocation and reallocation as appropriate

oMake necessary modifications to the processes and project plan

Project Change request (PCR) management

oUnderstand what exactly constitute a Change and qualify for a price

oBe thorough on the contracts and / or SOW with the vendors

oTry to keep the PCR near zero

Bridge between frontend & backend teams, and business stakeholders.

oKeep in constant touch with the business stakeholders and executives

oInvolve the business stakeholders in the project and earn their respect and encourage them to involve/participate in the project

oUpdate the executives weekly and daily as per requirements and necessity depending upon the phase of the project.

Techniques for defect-free data migration, data quality

oDatabase design to deliver 3 seconds response time up to 8,000 concurrent users

oValidate data migration for 100% accuracy; validate every migrated record, not just sample

oApply proven theories for data validation and data quality

Business Intelligence Supervisor, Department of Corrections (DOC), Tumwater 2016 – 2018

Responsible for:

Multiple projects (ongoing and future projects)

oProject planning/execution

oWorking with multiple business units within DOC

oOngoing Operations support

BI Strategic planning at the enterprise level

oWorking with IT leadership and RDA Executives/Managers

oBusiness Unit Heads

oTaking the BI to the next level.

Data migration from OLTP to Data warehouse and Data Cubes

oRequirement gathering

oProviding self-service Reporting tools to various business units based on priorities

o Providing various innovative solutions on ETL front

oSystem up time SLA

oCustomer satisfaction.

Procuring high caliber resources and keeping then very active

oProcures highly educated persons

oKeeping the BI staff highly motivated and satisfied

oRetaining the resources using various innovative techniques.

Technology platforms at DOC

oWindows – Operating systems

oDatabase – SQL Server 2008/R2 2014 and 2016

oIntegration, Reports, Analytical tool – SSIS, SSRS, SSAS

oSource Control – TFS

Technology: Mainframe applications and MS-SQL databases

Project Manager & Data Manager Fifth Donut/DataChef LLC, Seattle Sep 2015 – Oct 2016

Responsible for:

Managing the projects in an Agile environment

oProject planning

oProduct updates and release every week

oBacklog tracking, and moving into Sprints

oDefect / issue / resolution

oDaily Standup meeting

oWeekly status report

Customer data management

oCustomer data

oCustomer configuration data

oCustomer transaction data

oData consistency and quality

BI Report

oBusiness trend

oSales reports

I had been one of the partners of the company.

Data Conversion Consultant / Data Conversion Manager: Dept. of Social Services, SC. May 2015 – Sep 2015

SC State counties are supporting their Child support system with very old legacy systems. Their successive attempts to make an integrated Central system had failed. There were 46 different [County] Legacy sources of data; about 2,000 data extract files, and 25,000 data elements.

As a Data Conversion Manager, responsible for:

Understand the complexity of data sources and business, and identify the causes for the failure of the project thrice before.

Come out with a solution that would be fail proof after thoroughly analyzing the metadata across the counties.

Present the Data analytical findings to the management.

Established various Processes and methods for analyzing the meta data, business data

Build a strong technical team that would follow the established processes and improve them if require

Guiding and mentoring the team members on achieving the goals of the project

Planning, setting milestones and deliverables

Time and delivery management

Problem solving

Developing software tools for the project

Problem solving – both technical and between teams and within on tech and non-tech subjects

Shield the team’s focus from external interruptions.

Achievement: A viable solution is identified to the satisfaction of the DSS management.

Target Database: SQL Server

Data Conversion Project Manager: ProviderOne Project, Health Care Authority, WA. 2007 - 2015

The Health Care Authority (HCA) is Washington’s 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, benefiting both public and private sectors with a focus on moving the health delivery system away from volume toward higher value and better outcomes.

When I took over the Data Conversion responsibility in mid-2007, the project had been in a critical stage. Data conversion was the central focus of the upper management / executives. Within few weeks of taking over the responsibility, I identified the causes for the failure, and collaborated with the Executives, Key stakeholders, and the Primary vendor to devise new mechanisms and move forward in an accelerated fashion.

Successfully implemented both ProviderOne Phase 1 and Phase 2.

Design, develop, and document the Processes for the entire conversion project.

Develop Standards (Files, Records, Columns, Tables, and other Naming) for the projects.

Innovated new techniques & short cuts that are based on proven theories.

Massive data analysis, data defect identification, and present to the stakeholders

Involve the stakeholders in every aspect of data mapping from source to target with accurate business rules.

Work with third party vendors and keep monitoring the progress.

Keep the stakeholders and executives up-to date on the progress

Conduct meetings, take minutes, distribute to the participants, and follow-up on Action Items with the respective owners

Keep the State DC team and vendor DC team in synch on all processes.

Develop on-demand for ensuring the accuracy of the entire ETL (Extraction – Transformation – and Loading) processes.

Manage the resources effectively – Team Leads, Tech architects, Developers, and Testers.

Architect ODS / Data warehouse – Database design, ETL from OLTP to ODS / EDW.

Develop Tools to generate ETL validation test cases, and run them automatically.

Massive data analysis using SQL and PL/SQL

CMS (Federal Agency ‘Centers for Medicare & Medicaid Services’) certified the ProviderOne System with zero Findings. WA was the only State which achieved this feat.

Other State Data Conversion teams had contacted and sought my advice.

Provide production support of the DW and ODS for 4 years as and when the Operations requested.

Achievement: CMS certified the WA State ProviderOne system with zero Findings. WA is the only State to achieve the feat.

Technology: Oracle Databases for OLTP, ODS and Data Warehouse (DW). Source Data: MS-SQL Server and Mainframe, MS Tools. Expertise - PL/SQL and Transact SQL, Erwin Data Modeling

Affordable Care Act (ACA) – WA Health Benefit Exchange July 2012 - June 2013

I executed the Data Conversion for ACA project in parallel to ProviderOne. My responsibility was to perform client data migration from Legacy & ProviderOne to WA HealthPlanFinder.

Managed two projects’ data migration simultaneously

HCA had trusted and handed over responsibilities to manage HBE System, and ProviderOne Phase 2, and the associated vendors.

Database Design, validation and approval

Develop Extract, Transform, and Load (ETL) data processes.

Liaison between DSHS eligibility team and the HBE vendor on Client Data Mapping from legacy to HBE Database

oEnsure all business rules are captured

oEnsure every data element required to run the business is mapped

oEnsure both the business / policy team and vendor are in synch

oMapping signoff

Validate ETL processes, and ensure every converted record is accurately converted as per mapping

Project Manager, Holland America Line (HAL), Seattle June 1997 - June 2007

As project manager, I successfully executed three major projects for Holland America between 1997 and 2007. During this time, I managed Holland America employees ranging from Business and IT Directors to IT managers.

1)POLAR PROJECT - Cost: $10 Million 2004 - 2007

Responsible for E2E Multi-Million Dollar migration of a mission critical Reservation System from Travel Advance Cruise Reservation System (TRACS) to Princess OnLine Advance Reservation (POLAR).

Prepare project charter for (TRACS) to (POLAR) System migration

Define the various processes including communication processes among diverse teams

Prepare detailed master project work plan, with major milestones

Define the Roles and Responsibilities and assemble project teams

Track actual Capitalized and Expensed costs against the budgeted costs

Set up and enforce standards in maintaining project documents

Guide the technical team in solution designs to meet the objectives, including Data Conversion. Collecting valuable metrics throughout the project life cycle.

Manage the resources effectively – Team Leads, Tech architects, Developers, and Testers.

Technology: Mainframe, COBOL,VSAM. Unix, Data warehouse ORACLE 8i, PL/SQL, Pro*C, C, VB 6.0, MS Project, MS Office Tools

2)Revenue Management System Project (RMS) - Cost: $4 Million 1999 - 2004

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.

I turned around the project with a good project plan and methodology. I remodeled and redeveloped the forecasting, alert management and User Interface (UI) modules for improved forecasting and usability. All strategic players in HAL are using this system. This is one of their highest rated systems. The management could see the ROI within months of implementation of the critical modules. It resulted in 20% improvement in revenue yield.

As a Technical Project Manager, I was responsible for:

Managing the application development project – developing project plan, resource scheduling, monitoring the progress – status reports

Working with tool vendors and customizing the tools to the project requirements

Incorporating Database design changes

Populating the database from Legacy systems – Data Extraction – Transformation – Loading (ETL)

Continuous improvement of the application predicting more accurately

Technology: Solaris UNIX, WINDOWS, ORACLE 8i, PL/SQL, Pro*C, C, VB 6.0, MS Project, MS Office Tools

3)Data conversion and Y2K Project - Cost: $1.5 Million 1997 - 1999

As a Project Manager, I was responsible for:

Preparing a detailed project plan

Rule book – Y2K rules and Standards were prepared and signed off.

Multiple Delivery work units (Sprints)

Building onsite and offshore teams

Establishing communication processes and setting communication standards and protocols.

Coordination among the customer (HAL), onsite team and offshore team.

Building teams at onsite (4 at Seattle) and offshore (35 at Bangalore, India)

Delivering the Y2K compliant Codes and obtaining HAL acceptance

Warranty support and final signoff

Technology: Mainframe, JCL, COBOL

Recognition

I received 'Employee of the Year 1998' award for successfully completing the project on time and within budget.

Received repeat business from HAL.

This project had been commended, and used as a model project for a long time at Mastech.

Contact this candidate