Uday Kane - ITIL Certified IT Professional with ** years of Legacy experience

Phone: 925-***-****

Email: adhvq5@r.postjobfree.com

Linkedin: www.linkedin.com/in/Uday-R-Kane

Page 1 of 4

PROFESSIONAL OVERVIEW

● Over 20 years of experience and contribute to Customer’s growth and success in the 21st century thru the use of Best ITIL based practices, Tools (Service Now) and Technology, including Software Applications and optimal process and procedures

● 10 years of SQL Server Development experience with an emphasis on design, development, conversion, tuning, optimization, Performance and Security.

● 10+ years of experience in ETL and Data migration validation/testing, mainframe data storages (VSAM, DB2, Datacom) and Remote Stored Procedures (MQ, CICS and DB2).

● Over 11 years of experience in Data modeling and Data profiling.

● Proficient involvement in end to end Development of Projects covering all phases of Software Development Life Cycle including Requirement Analysis, Designing, Build/Construction, Unit/Assembly Testing and Deployment.

● Extensive experience in SQL Business Intelligence tools -

● Experience working on Data Analysis tools creating various Reports and Dashboards using different functionalities.

● Experience in data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

● Extensive experience in creating complex SSIS packages, creating jobs, Alerts and schedule SSIS Packages using SQL Agent, migrating the data from different legacy system to SQL using SSIS.

● Proficient in Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

● Handled various types of encryption and decryptions in SQL as per client requirements to secure data. TECHNICAL SKILLS

Dec 2019 to

Nov-2020

Production Support for MicroFocus based Applications using COBOL, IMS, VSAM, JCL, Endevor, Rexx, AutoSys, Power Shell

June 2004 to

April-2019

Software development and support using COBOL, Z/OS, DB2, SQL, VSAM, CICS, JCL, Eztrieve, Endevor, Rexx, AutoSys, Micro Focus June-2004 to

April-2019 Business Requirements, Functional Requirements, Detailed Specifications, QA, June-2004 to

April-2019

Team leadership for Onshore and Offshore IT teams

June-2004 to

April-2019

Root cause analysis for production incidents, communication and escalation to IT and Business Leadership.

June-2004 to

April-2019 Preparation of Short and Long term solutions for documented problems. EDUCATION:

Diablo Valley College, CA

AA Computer Science and Data

Processing

PROFESSIONAL EXPERIENCE

Uday Kane - ITIL Certified IT Professional with 20 years of Legacy experience Phone: 925-***-****

Email: adhvq5@r.postjobfree.com

Linkedin: www.linkedin.com/in/Uday-R-Kane

Page 2 of 4

From: Dec-2019 To Dec-2020

Client: Boeing/HCL, Long Beach, CA 2019-2020

Role: Batch Support and Onsite IT Coordinator

Responsibilities

● Provided batch monitoring and production support for COBOL, VSAM, JCL and IMS based mission critical applications.

● Prepared System documentation using MS Word.

● Collected and Parsed data for operational statistical reports using and Rexx, PowerShell and MS Excel.

● Prepared and presented to Business Customers MS Power Point and Visio based System and Process Flows.

● Discussed requirements with Business Customers and Prepared Business and Functional requirement documents

● Prepared detailed, step by step “How-To” process and support documentation.

● Defined, developed and deployed standardized IT processes including Incident Management, Change Management and Change Audit.

● Developed PowerShell and Rexx scripts for automation of routine tasks i.e. Application Inventory Audit and Reconciliation.

● Analyzed and implemented Optimization and Standardization in batch scheduling via cleanup of AutoSys JILLs

● Provided consulting in organization and management of onsite IT support staff From: June-2004 To May-2019

Client: CSAA, Walnut Creek, CA

Role: Onshore Lead Developer and Application support Lead Responsibilities

● Led a team of Multidiscipline IT professional in Conversion and Migration of Personal Line Auto and Homeowner Insurance Policy Administration (over 2 million policies) and related Billing, Account Receivable and Statistical Reporting applications and related data from COBOL, DB2,CICS, VSAM based platform to a Java/Oracle based (Software as a Service) vendor platform.

● Throughout the Conversion (over 4 Years), maintained COBOL/CICS Transaction Server VSAM, DB2, JCL MQ, based integrations with and ETL, Stand along applications (IVR, Self-help Kiosks and Data warehousing)

● Coordinated communication between and work assignment prioritization for Developers, QA and Business Analysts.

● The Business Functions supported included Point Of Sales data entry, Back End batch processing

(HUON Policy Administration and Billing), Document generation and Financial Reporting. As well as Call Center Inquiry, Account Receivable and Billing functions.

● Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.

● Developed complex SQL code such as Remote Stored Procedures, functions, triggers, Indexes and views for the application.

● Used mainframe-based tools and generated normalized mainframe data (Comp-3, Variable Length, etc) prior to ETL into Oracle, Informatica and Hadoop.

● Used advanced features of SQL in order to design and tune SQL to interface the database and other applications in most efficient manner.

Uday Kane - ITIL Certified IT Professional with 20 years of Legacy experience Phone: 925-***-****

Email: adhvq5@r.postjobfree.com

Linkedin: www.linkedin.com/in/Uday-R-Kane

Page 3 of 4

● Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.

● Develop and recommend operational processes and/or process improvements in support of clients.

● Developed Subject Areas for MDM using SQL Business Intelligence

● Developed Unit Test Plans for SSIS packages for checking the functionality of each component.

● Modified existing COBOL/DB2 Code base to meet the changes specified by the users.

● Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.

● Generated Data Profiling related Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using mainframe and server based tools.

● Created reports to retrieve data using Stored Procedures that accept parameters.

● Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.

● Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.

● Developed various SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures.

● Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.

● Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.

● Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.

● Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.

● Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.

● Involved in deploying, configuring and managing reports using Report Manager and Report Builder.

● Formatted the reports using the Global variables and expressions.

● Reviewed and fine-tuned stored procedures and triggers before production migration.

● Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the SQL statements using SQL profiler

● In total, my team and I supported Customer, Product and Financial data and related processing for more than 2 Million customers, and Annual Revenue of over 2 Billion USD.

● In this role, for the last 10 years, I have led several technical teams over time, with active hands-on participation in all aspects of SDLC, from Requirements to Deployment and also Post Production support

● We regularly and fully participated in Agile based projects while maintaining use of Waterfall methodology for the project work specific to the Mainframe platform. This included conversion of the entire Legacy Mainframe data to Web applications via a custom built just-in-time software solution.

● Participated in Archival and Decommissioning of Legacy Applications, Data and processes.

● As the process owner, was also responsible for final acceptance of requirements and delivering on them, via the time and effort estimates submitted by my team.

● Skills Applied include:

● Discovery, Review and acceptance of Business Requirements via one-on-one and Joint Application Development (JAD) sessions.

● Creation of Functional Requirements and Technical Specifications documents.

● Design, Documentation and Review (with stakeholders) of Code Functionality, Screen definitions, and Data Structures.

● Development of new and enhanced source code using Z/OS based COBOL, DB2, JCL, CICS, VSAM, MQ solutions as per technical specifications and user requirements. Uday Kane - ITIL Certified IT Professional with 20 years of Legacy experience Phone: 925-***-****

Email: adhvq5@r.postjobfree.com

Linkedin: www.linkedin.com/in/Uday-R-Kane

Page 4 of 4

● Development of Eztrieve and SQL based reports per requirements.

● Production support for both Batch and Online processing in the production, including On-call.

● Development of detailed technical project and delivery plans and schedules.

● Preparation of new and updated Technical Documentation using shop standards.

● Enhancement and Optimization of existing Databases and job/process flows.

● Preparation and presentation of Root Cause Analysis, solution alternatives and recommendations to the Business and IT Stakeholders

● Performance optimization of COBOL/VSAM/DB2/SQL/JCL code and job streams.

● Collaboration with DBA and other Technical resources in Root Cause

● Triage of production abends, and system performance related issues.

● Coordination of technical hand-offs between IT support teams.

● Mentoring and Knowledge sharing with IT support teams and End Users. From: Jan-1997 To June-2004

Client: EDS/CSAA, San Francisco, CA - Jan-1997 To June-2004 Role: Technical Lead and IT Consultant

Responsibilities

● Led a group of onshore and offshore Application developers in support of on-shore Insurance Company client, with several IBM Mainframe based Insurance policy administration and related financial Software Application systems using COBOL, CICS, DB2, VSAM, JCL.

● Prepared and executed Application enhancement related Technical plans and System support related Knowledge Transfer to the Offshore teams.

● Prepared and communicated application Design and Client platform specific training and mentoring to outsourcing partner’s onshore and offshore resources.

● Provided hands-on IT support to the business during On-shore business hours.

● As part of EDS’s IT Consulting practice, worked on external client’s Application development assignments which included:

● Preparation for CMMI Certification

● Automation of manual processes

● Optimization of existing IT processes

● Development of Customer facing and Regulatory system components

Contact this candidate