Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Narendra Pamulapati

St Louis,MO

Summary

  • 10+ years of specialized experience in Databaseand Data Engineering, focusing on application development, design, and cloud infrastructure management.
  • Demonstrated proficiency in translating business requirements into comprehensive functional and technicaldesign specifications.
  • Extensive expertise in architecting and managing AWS cloud solutions, encompassing services like EC2, Beanstalk, RDS, DynamoDB, and CloudFormation.
  • Skilled in UNIX and ShellScripting, enhancing database operations, automation, and efficiency.
  • Well-versed in version control systems (Tortoise SVN, GitLab, GitHub) and task monitoring tools (JIRA, HP Quality Center).
  • Strong collaborative and communicationskills, fostering effective teamwork and project execution.
  • Proficient in code review, performance optimization, query tuning, and data profiling to enhancedatabase efficiency and reliability.
  • Experience with Docker, Kubernetes, Splunk, AWS API Services, Harness and CI/CD pipelines.
  • Familiarity with multi-cloud environments, including Google Cloud Platform (GCP) and Microsoft Azure and Big Data Technologies: Spark, EMR, Hive, Hadoop.
  • Adept in utilizing various databases and ETLtools such as DB2, SQL Server, Informatica PowerCenter, and Apache Airflow for seamless data integration and management.
  • Committed to ensuring database reliability through rigorous testing methodologies, including unit testing, regression testing, and troubleshooting.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Database Engineer

Resonate Global Mission
Reston, VA
08.2022 - 03.2024
  • Orchestrated ETL workflows within the Survey Operations team using AWS and Pentaho for seamless data integration.
  • Designed and managed data pipeline workflows, wave processing, and Data Quality Score (DQS) evaluations utilizing AWS services.
  • Led database releases, performance tuning, and bug fixes, ensuring optimal data processing and storage solutions.
  • Conducted Data Quality Score (DQS) analysis to detect anomalies and identify survey discrepancies using rare response combinations (RRPs).
  • Executed REFS (Recent Events Flash Studies) utilizing AWS EMR and Step Functions to analyze real-time data trends and insights.
  • Maintained on-call responsibilities on a rotational basis to monitor and troubleshoot data pipelines, ensuring operational readiness.
  • Managed data loading processes for each wave, optimizing performance and scalability using AWS Step Functions.

Database Engineer

Modis Inc
Columbus, OH
09.2019 - 08.2022
  • Worked on multiple projects: Keynote On Premises to AWS Cloud, Oracle Remediation, SQR to WebFocus conversion, Retirement Plans, and various testing activities, which included a vast code base of Oracle, Java, Python, WebFocus, SQR, and Cobol.
  • Led the migration of critical modules to the AWS Cloud, facilitating seamless data transition and integration within the AWS Cloud environment.
  • Engineered and fine-tuned stored procedures, functions, and packages to align with AWS migration strategies and performance benchmarks.
  • Conducted comprehensive data analysis using Pig and Hive, focusing on data partitioning, bucketing, and query optimization within the Hive environment.
  • Demonstrated proficiency in AWS database services, including DynamoDB, Redshift, and RDS (Aurora), for scalable and efficient data management solutions.

Database Engineer

Lex Nimble solutions
Schaumburg, IL
06.2018 - 09.2019
  • Participated in data migration projects from Oracle to Redshift in AWS Cloud.
  • Analyzed data using Spark SQL and deployed multi-tier applications in AWS.
  • Wrote and maintained technical and functional specification documents.
  • Developed Oracle Stored Procedures, Functions, Packages.
  • Good exposure to Control-M (Creating and running the jobs) and Linux.
  • Experienced in unit testing, regression testing, and functional testing.
  • Worked on daily ETL, bug fixes, analyzing invalid objects, and recompiling them.

Database Developer

Bizintex Inc
Woodstock, GA
10.2015 - 06.2018
  • Implemented Mainframe elimination projects, developed Oracle packages, and performed optimizations and extensive data analysis for various projects.
  • Wrote extensive packages in Oracle to replicate the process that was in Mainframe.
  • Created scorecards to compare the data, Mainframe output vs Oracle output.
  • Wrote technical, functional test plan documents for different modules.
  • Extensively worked on Oracle PL/SQL, good exposure to various Oracle functions like Rank, row over partitions, listagg, and UTIL_FILE.

Database Developer

Amzur Technologies
Tampa, FL
12.2013 - 09.2015
  • Worked with External Tables to access and import the required information.
  • Made use of Oracle features like partitioning, cursors, collections, and dynamic SQL.
  • Worked on PL/SQL tables, procedures, records, and used dynamic SQL and triggers.
  • Wrote extensive exception handling procedures to oversee exceptions.
  • Created database objects like tables, synonyms, views, sequences, and indexes.
  • Made use of data partitioning by range, list, and sub-partitioning to increase the performance of the system.

Education

Master of Arts - Information Technology

Webster University
St Louis, MO

Skills

Databases: PostgreSQL, Snowflake, Oracle, MySQL, SQL Server, DB2

Scripting: SQL, PL/SQL, UNIX Shell Scripting, Python

Languages: Java, HTML/DHTML, XML

Operating Systems: Windows, OS X, UNIX

Query Tools: SQL Developer, TOAD, SSMS, SQL*Plus, pgAdmin, DBeaver

ETL Tools: Informatica Power Center, Apache Airflow, Pentaho, ODI, Glue

Monitoring& Visualization: Grafana, Splunk, Control-M, MobaXterm

Version Control & Task Management: Tortoise SVN, GitLab, GitHub, JIRA

Cloud Platforms: Amazon Web Services (AWS), Google Cloud Platform (GCP)

Certification

  • AWS Cloud Practitioner, Certified Developer & Solutions Architect - Associate.

Timeline

Database Engineer

Resonate Global Mission
08.2022 - 03.2024

Database Engineer

Modis Inc
09.2019 - 08.2022

Database Engineer

Lex Nimble solutions
06.2018 - 09.2019

Database Developer

Bizintex Inc
10.2015 - 06.2018

Database Developer

Amzur Technologies
12.2013 - 09.2015

Master of Arts - Information Technology

Webster University

Similar Profiles

CREATE PROFILE
Narendra Pamulapati