Performance Data architect

Senior R* Data Architect as **+ years of experience in digital engineering. Expertise in the area of Oracle query performance and tuning.

Worked as developer in Sinewlore, Hyderabad from Sep 2008 to Dec 2009.

Worked as Developer in 7Hills, Hyderabad from Dec 2009 to Jan 2011.

Worked as Senior Software engineer in Polaris Financial Technologies, Chennai from Feb 2011 to Dec 2012

Worked as Project Lead in Larsen & Toubro InfoTech, Chennai from Dec 2012 to Dec 2016.

Currently working in CTS from Dec 2016.

Having 15+ years of experience in Oracle (SQL&PL/SQL), Python Development and Implementation of various commercial applications in HealthCare, Airlines, Banking, Supply Chain and Warehouse management Solutions.

15+ years of working experience in Oracle tuning (SQL, PL/SQL), Microsoft SQL tuning, informatica tuning, SSIS tuning on Azure, Azure synapse, DSQL, Unix/Linux, Splunk, JMeter, Dynatrace and Shell scripting.

Having Knowledge on SRE concepts.

Expertise in Creating Splunk Dashboards, report, scheduled searches and alerts.

Analyze and monitor application and system logs using cognizant developed and commercial profiling tools (AppDynamics, JMeter, Splunk)

Analyze thread and head dumps.

Provide recommendations to tune DB queries.

Make appropriate recommendations to tune JVMs, Cache and GC settings, along with long-term performance improvements

Setup appropriate reports and alerts to monitor performance.

Experience with monitoring tool architecture, deployment, maintenance of multi-vendor tool suite environments, and compliance with published SLA's

Experience working with application & engineering teams to develop requirements that define monitoring and interpret alerting, notification

Expertise in understanding of transaction/batch job processing, multi-tier application development, web infrastructure (web services, trend analysis, etc.)

Experience in the gathering requirements and providing suggestion to client.

Experience in Designing the given requirement and modifying the requirement if needed.

Experience in developing the code based on design.

Experience in testing and fixing the bugs if any.

Experience in implementation and post-delivery support.

Proven record of success in design, development and implementation of software applications with utmost quality and on-time delivery

Hands on experience in handling 890 billion records in contingency, on-prem and azure pdw.

Have good experience in service improvements.

Strong Team Player with excellent inter-personal, written and oral communication skills.

Have good experience in PROC.

Known languages PYTHON, JAVA, C, C++.

IKM certification for ORACLE-11G level 1 & level 2 with more than 85% score.

Project 1

PROJECT PROFILE:

Project Title

BSC QE – NFT Services

Duration

12/26/2016– Till date

Location

EL Dorado Hills, California, onshore

Hardware

Intel based of X86 series of systems

Operating Systems

Windows & Linux

Monitoring Tools

Dynatrace, Splunk

Automation and configuration tool

Ansible

Databases

Oracle, Sql Server

Cloud Technologies

Azure

Known languages

C, C++, JAVA, PYTHON

Incident Management Tools

ServiceNow, JIRA

Scripting Languages

PowerShell, Unix Shell Script

CICD/Version Control

Bitbucket

PROJECT DESCRIPTION:

Find the best health insurance plans in California. Choose from Blue Shield of California's PPO and HMO plans and get the coverage to member need.

CLIENT DESCRIPTION:

The organization serves over 4 million health plan members and nearly 65,000 physicians across the state. Blue Shield of California was founded by the California Medical Association.

ROLES AND RESPONSIBILITIES:

Understand detailed requirements, Automate the operation process, Toil Reduction, working on enhancements, prepare test data and execute within the defined SLA. Running tests for every release and identify performance hot-sport and give recommendation to improve the performance.

Project 2

Project Name

Pros Maintenance.

Organization

Larsen & Toubro InfoTech, Chennai

Client

LATAM,AVAINCA,QANTAS

Role & Contribution

As a lead Engineer, was responsible for

Tuning the batch process.

Requirement gathering, analysis and estimation.

Involved in coding/code review.

Resolving oracle query performance issues.

Perform analysis and documentation of test results.

Provide post-implementation support.

Resolving the Customer queries and issues as per Service Level Agreement (SLA) defined between LATAM and PROS.

Providing Emergency code fix for any Business-critical modules that goes down in production.

Resolve Incident and problem ticket within agreed SLA and adhering to the incident management process.

Implementation and promotion of change requests to production.

Interacted with business analysts and discussed technical problems and reported bugs.

Finding any bugs in existing code and fixing them.

Technologies

Oracle SQL & PL/SQL, UNIX

Tools

Sql Developer.

Key Achievements

Successfully implemented the work requests on-time with ZERO ITAT/UAT defects.

Suggested and implemented many value additions for improving the productivity of the team by reducing the sustenance efforts for supporting applications.

Identified the recurring issues in the application and provided permanent fixes.

Project 3

Project Name

ERP SCP Legacy Oracle Applications Maintenance Activities

Applications

VSOR, DOS, IOD, OPD, CLS, DQM.

Organization

Larsen & Toubro InfoTech, Chennai

Client

Freescale Semiconductor Inc.

Role & Contribution

As an Senior Software Engineer, was responsible for

Requirement gathering, analysis and estimation.

Involved in coding/code review and peer review of the artifacts.

Prepare Unit/System/Regression/Performance Test Plans, Test data.

Perform Unit/Integration/Regression testing.

Perform analysis and documentation of test results.

Provide post-implementation support.

Resolving the Customer queries and issues as per Service Level Agreement (SLA) defined between Freescale and L&T InfoTech.

Providing Emergency code fix for any Business-critical modules that goes down in production.

Resolve Incident and problem ticket within agreed SLA and adhering to the incident management process.

Implementation and promotion of change requests to production.

Interacted with business analysts and discussed technical problems and reported bugs.

Finding any bugs in existing code and fixing them.

Technologies

Oracle SQL & PL/SQL, Perl, UNIX

Tools

Benthic, Sql Developer.

Key Achievements

Successfully implemented the work requests on-time with ZERO ITAT/UAT defects.

Suggested and implemented many value additions for improving the productivity of the team by reducing the sustenance efforts for supporting applications.

Identified the recurring issues in the application and provided permanent fixes.

Project 4

Project Name

CITI-INDIA-NR

Organization

POLARIS FINANCIAL TECHNOLOGY

Client

CITI.

Role & Contribution

As an Associate consultant was responsible for

Involved in design discussions

Involved in Production Development and tuning.

Monitoring the Performance and tuning the sql queries if necessary according to functional requirement.

Involved in creation of PL/SQL Functions, Cursors, and Triggers Etc.

Worked on PL/SQL Procedures, Triggers, PRO*C as part of Implementation

Worked on forms6i for rdr changes.

Worked on unix scripting.

Technologies

PROC, UNIX, Oracle SQL & PL/SQL

Tools

Sql Developer.

Key Achievements

Successfully implemented the work requests on-time with ZERO ITAT/UAT defects.

Suggested and implemented many value additions for improving the productivity of the team by reducing the sustenance efforts for supporting applications.

While migration the queries which are used to fetch large data and elapse more hours if any failure rather than re-running the query given the solutions to fetch remaining data.

Automated the Data fetching process.

Project 5

Project Name

eBizNET Enterprise version of 2010

Organization

7Hills Global Consulting Pvt.Ltd

Client

MARUTI SUZUKI, AlphaComm, Gati, REDINGTON

Role & Contribution

As an Software Engineer was responsible for

Involved in design discussions

Production System Configuration

Involved in Production Development and tuning.

Monitoring the Performance and tuning the code if necessary according to functional requirement.

Granting privileges to various users to access database.

Involved in creation of PL/SQL stored procedures, Packages, Procedures, Functions,

Worked on PL/SQL Procedures, Triggers and Packages as part of Implementation

Technologies

Oracle SQL & PL/SQL, UNIX

Tools

Sql Developer.

Key Achievements

Successfully implemented the work requests on-time with ZERO ITAT/UAT defects.

Education & Credentials

Master of Computer Application.

Name : Veeranjaneyulu Gogineni.

EmpId # : 615211

Cadre : R2 Architect

Current BU/Department : HealthCare, Bule Shield of California.

Location : California, EL Dorado Hills

Contact # : 916-***-****

DOJ : Dec-2016

Release Date : Till Date.

Sr.No

Achievements / Awards

1

LATAM client Appreciation for automation and performance tuning.

2

QANTAS client Appreciation for performance tuning and shell script automation.

3

STAR performer Award for automation and development of LATAM DataMart activities.

4

BLUE DIAMOND AWARD WINNERS - Q1 2020 from BSC. Dated -April 15, 2020

5

Cognizant Rewards Job well done! Award

6

ISO audit completed with zero complaints.

Experience Summary

Skills

Professional Certifications

Project Details

Educational Qualification

Personal Details

Achievements / Awards

Contact this candidate