Summary
Overview
Work History
Education
Skills
Certification
Awards
Proof Of Concepts
Languages
Software
Work Availability
Timeline
Generic

ASHOK DASARI

Pasadena,CA

Summary

Overall,11+ years of IT work experience with 5 years in Production and 6 years software development in the area of business intelligence and data warehouse using SQL Server Integration Services (SSIS), MS Access, TSQL, Splunk, Dynatrace, Informatica and Unix.v 4+ years in Kaiser (Membership module) and played major contribution in creating business reports, dashboards, data ingestion pipelines to bring value to the customers.v Having knowledge on monitoring tools like Splunk and Dynatrace.v Expertise in handling and driving P1 and Major incidents calls from endto-end by sending communication to all stakeholders and management till the issue is resolvedv Having practical knowledge on ITIL concepts.v Excellent experience in migrating data from Excel, Flat files, Oracle and various heterogeneous sources to MS SQL Server using SSIS.v Experience in installing, Configuring, Managing, Monitoring, and troubleshooting ETL jobsv Having hands-on experience in job scheduling and monitoring tools like SQL Server Agent and AutoSysv Expertise in developing complex stored procedures, Functions, views for improving performance.v Trained new resources on the tools for day-to-day activities for BAU process to run smoothly.v Able to prioritize tasks and workloads in order of importance.v Strong decision making and problem-solving skills.v Able to motivate and lead others in a team environment.v Excellent communication skills, both written and verbal.v An ability to build rapport and trust quickly with work colleagues.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Site Reliability Engineer

Kaiser Permanente
01.2019 - Current
  • Implemented Combined tool which improves the performance to 100% by using MS Access database
  • Automated manual tasks by using SSIS job which brings value to customer and helps business to generate accurate SOX report
  • Provided solution to major issue occurred during database migration and minimized risk to 100%
  • Responsible to implement standard change request on monthly basis.
  • Handled change tasks during project deployments
  • Monitor SSIS jobs using SQL Server Agent
  • Automated SSIS job to archive source files
  • Experience in scheduling jobs from SQL server Agent
  • Created reports, forms using MS access database and VB6 code
  • Worked on migration of DTS 2000 packages to SSIS 2018 using SQL server 2008
  • Worked on SQL server migration from 2012 to 2019.

Tata consultancy services Pvt Ltd
09.2011 - Current

Production Support

Kaiser Permanente
01.2017 - 01.2019
  • Identified bottlenecks in ETL job performance and provided solution to development team to fix the recurring issues
  • Supported Day to Day Production data load activities and maintaining communications between internal teams and external distributors and partners
  • Automated Unix script to get the health report of file servers and database server on daily basis to minimize operational risk
  • Worked with application team to troubleshoot production performance and reliability issues.
  • Involved in interacting with business owners, developers and business analysts in improving the application.
  • Developed the SQL scripts to gather failure jobs log information to dashboard and fix issues on time
  • Responsible for provide role base permissions to business users to generate reports
  • Database refresh by using stored procedures

Production Support | Development

Bank of America
01.2011 - 01.2017
  • Root cause analysis for failure jobs and provide detailed error details to development team
  • Involved in fine tuning the database queries and improved the performance of application processing time.
  • Monitor Informatica batch jobs using AutoSys tool on daily basis
  • Responsible to send business notifications for incidents with root cause, resolution time and Impact details
  • Communication with upstream to define ETA to downstream on data availability in case of any data issues in source files
  • Force restart of abend ETL jobs using Unix commands and AutoSys tool
  • Created 50 plus SSIS jobs and deployed in production environment.
  • Having knowledge in using ServiceNow ticketing tool
  • Handled changed tasks as part of production deployment.
  • Responsible for conducting the heath checks of application fileservers and provide evidence to release management team before change implementation.

Education

MTech - Computers and Communications

Jawaharlal Nehru Technological University
Kakinada
01.2011

BTech - Electronics and Communications

Jawaharlal Nehru Technological University
Hyderabad
01.2008

Skills

  • SSIS
  • Power BI
  • Splunk
  • Dynatrace
  • SERVICENOW
  • C
  • VB6
  • Core Java
  • Python
  • SQL/PL
  • TSQL
  • Hive
  • SVN
  • Bash shell

Certification

  • Certified in TCS ITIL foundation
  • Certified in Microsoft Azure Fundamentals (AZ-900)
  • Certified in Splunk

Awards

  • TCS On the spot award
  • TCS star of the month

Proof Of Concepts

  • Certified Azure fundamentals
  • Expert in creating ETM and ELT pipelines using Azure Data Factory.
  • Having knowledge in root cause analysis of application performance related issues through Splunk tool and Dynatrace tool
  • Created Regular Expressions for Field Extractions and Field Transformations in Splunk.
  • Having knowledge on Dynatrace query language and able to create metrics like resource availability, network availability, memory utilization and CPU saturation.
  • Having knowledge on onboarding real time system logs to Splunk and create different Indexes and troubleshoot errors with help Splunk Query Language.
  • Developed Splunk queries and building dashboards, reports, alerts.
  • Integrated Dynatrace in Splunk to monitor the cloud environments.
  • Having knowledge on cloud concepts.

Languages

English

Software

SQL

SSIS

Azure Data Factory

Databricks

IICS

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Site Reliability Engineer

Kaiser Permanente
01.2019 - Current

Production Support

Kaiser Permanente
01.2017 - 01.2019

Tata consultancy services Pvt Ltd
09.2011 - Current

Production Support | Development

Bank of America
01.2011 - 01.2017

BTech - Electronics and Communications

Jawaharlal Nehru Technological University

MTech - Computers and Communications

Jawaharlal Nehru Technological University
ASHOK DASARI