Krishna Chaitanya Dhenuva Konda Email & Phone Number

San Diego, Ca, Us

Valley Forge, Pa, Us

Las Vegas, Nevada, Us

• Oversaw the management of database operations for multiple customers, ensuring optimal performance and minimal downtime.• Set up CloudWatch metrics streams with filters to Kinesis• Configure to send CloudWatch logs to S3• Configure CloudWatch Logs Insights for querying capabilities on the logs• Create IAM permissions & Setup CloudWatch agent on EC2 instances to facilitate routing of logs to CloudWatch• Created, Administered and Maintained Peta-byte scale enterprise data warehouse clusters built using AWS Redshift• Improved Redshift query performance using WLM queues, AWS Performance Insights, AWS CloudTrail, AWS Redshift data distribution styles and sort keys.• Developed and Maintained data security and governance for Redshift EDW using VPC, Security Groups, IAM users & Encryption• Created Tables, Views, Constraints, Indexes, MVs, External Tables, Ref Cursors, Collections, Triggers• Performance Tuning of Oracle queries and PL/SQL stored procedures, functions, packages etc.• Led the design and deployment of a new data warehousing or Data Lake solution using AWS S3, Lake Formation, Glue, Redshift, Oracle that processed over 10TB of data daily• Enhanced system performance by optimizing query response times and doubling the speed of report generation for client-facing applications.• Conducted comprehensive reviews and updates to existing database systems for improving operational efficiency.• Collaborated with cross-functional teams to integrate data handling that improved location-based analytics capabilities.• Established data security measures that led to reduction in vulnerability exploits within the first year of implementation using KMS, IAM, TLS, VPC• Developed and maintained over 6 data models throughout multiple projects, ensuring consistency and accessibility. Facilitated the seamless replication of critical databases across different geographical locations, boosting data redundancy.

Basking Ridge, Nj, Us

• Design and implement cost-effective, efficient and secure cloud architectures on AWS• Deployment and management of AWS services – including but not limited to VPC, Route 53, ELB, EBS, EC2, S3, DynamoDB, RDS and Redshift• Monitor and optimize cloud infrastructure performance using AWS CloudWatch, CloudTrail• Setup correct IAM policies & CloudWatch agent on EC2 instances to facilitate routing of logs to CloudWatch• Setup Composite Alarms using CloudWatch• Setup CloudWatch alarms for EC2 instance recovery and alerts to SNS topics• Develop basic Lambda functions using Python• Created and Maintained AWS Redshift data warehouse clusters• Design and implement disaster recovery plans using AWS Backup, multi-AZ features, Route 53, Cloud Formation and best practices• Analyze and troubleshoot cloud infrastructure issues• Responsible for ETL design using Glue, Data Pipelines from multiple sources / Data Lake using S3 and Lake Formation / Datawarehouse using Redshift• Created Oracle PL/SQL stored procedures, functions and packages for moving data from staging area to data mart• Created Oracle indexes on the tables for better query performance• Used Oracle bulk processing for better performance• Partitioned the Oracle fact tables and MVs to enhance the performance• Data loading using SQL*Loader, External Tables• Write and implement the respective IAM policies as required per the respective services• Design and implement cloud-based monitoring and logging solutions• Created AWS Data Pipeline to consolidate operational data from multiple data sources to house at centralized location feeding data to multiple dashboards• Write reference architecture, best practices and thought leadership whitepapers, identify and enforce AWS architectural best practices• Create POCs to migration of existing on-prem applications to AWS• Delivered descriptive reports by extracting data from client systems using SQL & designed user screens for financial reporting on ad-hoc basis

Irving, Texas, Us

• Requirement Gathering and Analysis • Create the Logical, Physical Data Models using ERWin• Designed dashboards and scorecards to show operational performance across different markets; variance in actuals and planned, trend analysis to find process improvement opportunity• Automated weekly reports used by product and operation’s team to track/monitor performance • Designed a customized accounting report using complex SQL queries to be produced from the system on the 1st & 2nd day after month end for multiple legal entities based on user inputs• Design and develop various reports using Oracle PL/SQL stored procedures and UNIX scripts• Performance Tuning of Oracle queries and PL/SQL stored procedures• Developed a forecast model to forecast completions based on schedules, historical completions and other variables using SQL and tableau to predict operational capacity and completions for different vendors• Unit Testing of Oracle stored procedures and UNIX scripts • Collaborated with business team for requirement elicitation to design complex reports to extract & validate client’s financial & operational data in SQL & integrating with SAP & Salesforce systems • Version management of the code/documents using GitHub• Tracking & Tuning slow scorecard jobs per their Priority using Oracle PL/SQL and Business Objects• Triggering and Monitoring test runs using Business Objects Data Integrator• Report the status of performance improvements to Management on a weekly basis• Design and Develop ETL jobs using Pentaho/Kettle and Oracle MVs• Implement Master Data Management (MDM) and Data Governance rules engine• As an Agile team member, follow the Agile Methodology, attend daily team meetings, Estimate size of backlog items, Evaluate technical feasibility, Implement backlog items, Write and verify code which adheres to the acceptance criteria

Atlanta, Georgia, Us

• Design and Develop stored procedures using Oracle PL/SQL• Tuning slow scorecard jobs per their Priority using Oracle PL/SQL and Business Objects• Systems Integration• Triggering and Monitoring test runs using Business Objects Data Integrator• Design and Develop ETL jobs using Business Objects Data Integrator• Unit Testing Oracle stored procedures and Business Objects ETL jobs

Charlotte, Nc, Us

• Responsible for end-to-end development (LLD, Development, Unit Testing, Maintenance Support) of a given BPM function based on the HLD using PL/SQL - Oracle 10g • Extensive performance tuning using EXPLAIN PLANs, TKPROF, DBMS Profiler to meet the stringent SLAs• Identify and modify the time consuming PL/SQL procedures to use bulk binding(BULK COLLECT, FOR ALL, COLLECTIONS) to reduce context switches between PL/SQL and SQL engine• Development of Materialized views, Creation of indexes, De-normalization and Partitioning of tables/indexes, Rebuilding indexes, Stats Collection as required to improve the query performance• Simulation of EXPLAIN PLANs from one environment to another using SQL Profiles and Outlines• Responsible for replication of transactional data (from BPM) to Repoprting server (BAM) using Oracle Streams• Data Modeling enhancements for Term Life Insurance products• Generation and monitoring AWR Reports in DEV, CIT, SIT and LT environments

Atlanta, Georgia, Us

• Design, Develop and Unit Test PL/SQL procedures, functions, and packages for PM using Oracle 10g• Identify and modify the time-consuming PL/SQL procedures to use bulk binding (BULK COLLECT, FOR ALL, COLLECTIONS) to reduce context switches between PL/SQL and SQL engine• Debug PL/SQL routines using TOAD IDE visual checkpoints• Develop complex SQL queries for generation of trend analysis reports• Resolving vendor historical feed file issues and load into PIN Management• Load failed vendor feed files using External Tables to identify data issues• Tuning PL/SQL procedures, functions and packages related to PM load process using DBMS profiler• Tuning SQL queries using EXPLAIN PLAN, TKPROF • User access creation and management, and cloning the production db in dev and test environments for development and testing

Mumbai, Maharashtra, In

Nortel Networks, Durham, USAAT&T Wireless, Seattle, USACingular Wireless, Seattle, USAOman Telecommunications, Oman & India• Data Modeling (conceptual, logical and physical), Oracle Physical DB creation for the integrated Case Mart, CURE web and CODS environments using Oracle 10g• Design, Develop and Test PL/SQL procedures, functions, and packages • Design and implement Views to safeguard data, and Triggers to implement auditing and Replication• Develop ETL (Extract, Transform and Load) routines using PL/SQL for data extraction, validation, cleansing, transformation and loading.• Modify the time-consuming PL/SQL procedures to use bulk binding (BULK COLLECT, FOR ALL, COLLECTIONS) to reduce context switches• Tuning SQL queries (using EXPLAIN PLAN, TKPROF), PL/SQL Procedures, Functions and Packages (using DBMS_PROFILER), and Generating/Monitoring STATSPACK Reports• Data loading using SQL*Loader, Direct-Load Inserts, and Database schema/tables’ migration using Import/Export• Extensive design, development and support of BO XI universes and reports using BO Designer, DeskI/WebI, and InfoView• Performance tuning of BO XI reports at the universe level using derived summary views, hints etc.• UNIX shell scripting for file loading, file manipulation & job scheduling thru Crontab• Responsible for Database Backup and Recovery using RMAN• Perform day-to-day database administration tasks – tablespace management, user password management, ASM space/disk addition, privileges and grants etc.• Plan Oracle PSU patching and apply patches to Prod and non-Prod databases• Performance Tuning – SGA, initialization parameters, slow database response, re-size redo logs, ADDM and AWR reports

Bachelor Of Engineering, Computer Science

S.S.C

Education record

Education record