Uma Nalluri
Medway,MA
Summary
An Innovative thinker with extensive experience designing, coding, testing and supporting next generation database solution possesses Over 23 years of experience in IT Industry performed as DBA, Data Architect/DataEngineer,Business Intelligence Analyst and Report Developer. Provided 24x7 Remote/on-call production supports experience in databases like PostgreSQL, Aurora Postgres, ORACLE, MySQL, SQLServer 2014,Cassandra,Snowflake and Redshift. Design a Data Pipeline process and its code that is tested, scalable, extendable, and performant. Define and manage SLAs for datasets that support production services, job monitoring, and data issue resolution. Extensive experience in ETL/ELT processes and tools. Expertise in building pipelines with Snowflake, databricks, python, scala. Highly developed SQL and PL/SQL query and procedure optimization skills. Extremely comfortable with scripting languages including Bash, Python, VB script, Scala. Had done various projects using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, cloning, patching, Performance Tuning. Experience with Data streaming tools like Airflow, spark. Experience with Delta Live tables setup in Databricks and setting up data pipelines. Extensive experience with create and maintaining, tuning Redshift. Experience in Pyspark, Scala, shell script and Jupyter notebooks. Planning and scheduling the cold/Hot as well as RMAN backups. Experience in management tools like Oracle Enterprise Manager, TOAD and SQL Developer. Experience of data modeling techniques and high-volume ETL/ELT design. Experience with SOC 2 Type II and PCI Level 1 compliance audits. Moderate experience with Business Intelligence tools like SSIS, SSRS, T-SQL and PowerBI. Excellent experience in Oracle Service Bus integration on UNIX(Centos,Redhat). Excellent Team Member with good communication and Interpersonal skills. Evaluate modern technologies and integrate them into our current infrastructure. Configuration and using Kubernetes. Experience with AWS redshift, S3, Glue, REST API’s, EMR. Experience in creating and troubleshooting the airflow jobs. Experience in building the databases with Docker. Experience in building the AWS components with TERRAFORM. High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
8
8
years of professional experience
Work History
Risk Data Manager
Citizens Bank
- Citizens CDX group is responsible to provide the retail and whole sale credit risk data based on the reporting user requirement.CDX team developed and maintained a data mart to load and process the retail and Whole sale data from different source systems
- This process includes loading the huge volumes of data well as provides the historical reporting capabilities
- Responsibilities: Managed fulltime and Contract resources Involved in design sessions and Implemented and coordinate the solution and design for some critical business requirements and develop the Sqls to process the data in Production region
- Building and maintaining robust data architectures and databases Designing efficient data pipelines and ensuring data quality and integrity Collaborating with data science and analytics teams and strategize Scaling data solutions Overseeing data security and compliance Continuous learning and implementation of latest technologies Managing and training the data engineering team Budgeting and resource allocation Coordinating with IT and other departments Crisis management and problem-solving
Sr Database QA/Developer
Micros-Retail
- MICROS-Retail is a leading developer of award-winning software solutions that offer cross-channel functionality to retailers and direct marketers, Micros developed a POS application which will prevent the employee theft and flaws in the sales
- Application contains two products called XBR and Balance will allow customer to perform a report on their data at the end of the each business day to review the sales and inventory as well as theft
- I was involved in testing the data into the reports through the data warehouse
- Responsibilities: involved in designing and developing and testing the data pipelines
- Involved in verifying the data, architecture and design and modeling of databases
- Created and maintained the Test databases
- Set up the applications on Terminal services in windows2008
- Setup the Remote Desktop Services from scratch on win2008R2 servers
- Involved in testing and analyzing the BI Reports and ETL process built with SSRS and SSIS
- Involved in testing the complex stored procedures, Views which are developed for populating the data into the reports.
Lead BI & DW Consultant
The Hanover Insurance Group
- Information management team is a sub team in Hanover Insurance Group, this team will manage the Data and reports for all lines of business
- This group will process and maintain a data in the Enterprise Data Warehouse (EDW)
- Responsibilities: experience with the offshore model and managed offshore resources
- Involved in writing automation scripts for data validation and data pipelines creation
- Involved in verifying the data, architecture and design and modeling of databases
- Wrote very complex SQL queries in validating the Data
- Good experience in testing the relational and dimensional database models.
Sr Test Automation Consultant
Department of Public Welfare
- CCMIS is a statewide initiative, created by the Pennsylvania Department of Public Welfare to enhance community-based solutions to improving the quality and increasing the capacity of child care services in Pennsylvania
- Responsibilities: Involved in End to End, white box, black box, Unit, Integration, System and Data conversion Testing Performed Data conversion testing by writing SQL queries
- Involved in writing the Complex functions by Using VBScript
- Involved in verifying the data, architecture and design and modeling of databases.
Sr Database Consultant
WebMD Practice Services
- Responsibilities: involved in verifying the data, architecture and design and modeling of databases
- Writing and executing Test Plans and Test cases based on requirements and documentation
- Data migration projects Involved in Data governance.
QA Consultant
Home Shopping Network (HSN)
- Responsibilities: involved in verifying the data, architecture and design and modeling of databases
Sr reporting developer
Taruni Techno Vision
- Developed reports and graphs to present the performance as well as stress test results SMS with VB
- Developed design the code using VC++ and VB
Software Developer
Zen Tech
- Responsibilities: Developed Forms using VB5.0 GUI Development, database design and CI/CD pipelines
Sr Database Administrator / Data Engineer
Upgrade Inc
08.2022 - Current
- Motivated and results-driven professional seeking a challenging position at Upgrade Inc
- To contribute to the company's mission of driving innovation and transformation
- With a strong background in technology and a passion for cutting-edge solutions, I aim to utilize my skills and experience to propel Upgrade Inc
- And its clients to new heights of success
- Responsibilities: Managing major/minor version upgrades, patching, performance tuning with Postgres 13, Aurora, Mysql, Redshift, Snowflake and Databricks
- Extensive experience in building the ETL/ELT processes
- Experience in creating data pipeline notebooks with scala and python, pyspark
- Experience with HA/DR with all the databases
- Build data pipelines with DLT in databricks
- Started setting up the Unity catalog in databricks
- Extensive experience with create and maintaining, tuning Redshift
- Experience in creating Data sharing and WLM Queues, external tables in Redshift
- Experience in setting up cross account IAM setup
- Created data pipelines with Pyspark notebooks
- Experience in setting up DMS tasks and other AWS components with terraform
- Performed Data migrations on critical DB’s with DMS
- Setup data pipelines between different source and target data points
- Experience with Tools like Jenkins, GitLab CI/CD automatically compile the code, run tests, and generate artifacts
- Experience with Docker, AWS, GLue, Terraform
- Environment: Linux/Unix, AWS, RDS, EC2, S3 MySQL 8, Postgres 13.9, Redshift, terraform, git, Aurora postgres, Spark, Python, Kubernetes, spark, scala, Python, terraform, Snowflake, Databricks, pyspark, DLT and Unitity Catalog
Lead DBA/ Data Architect
Welltok/ Virginpulse
09.2017 - 08.2022
- Welltok is on a mission to empower our customers to connect consumers with personalized health improvement resources and make it easy and rewarding for consumers to complete actions that optimize their health
- Responsibilities: Supporting and administering different databases like Posgresql AWS RDS, Mysql, Mysql Percona, Oracle and Cassandra and Snowflake e.t.c Involved in 24/7 Production and maintenance
- Administering DSE Cassandra and DSE SOLR 6 node clusters in all environments
- Experience with postgres community edition on on premise
- Involved backups, DR, Performance tuning, patches, installations and Upgrades of all DB’s mentioned Extensive experience with MySQL on premise and percona tools performed Oracle upgrade from 12c to 19c environments
- Created Backup procedures using Hot, Cold, RMAN and Logical backups
- Setup and configuration of Data guard
- Created and maintained Databricks notebooks Administer the databricks environment Experience in writing scripts in Python and Scala, Spark
- Experience in writing the Jupyter notebooks Worked with huge Databases like 60TB dbs
- Managing the Snowflake Databases in all environments
- Experience in building ETL/ELT data migrations
- Experience with airflows jobs
- Troubleshooting the logs in Kubernetes pods
- Extensive experience with AWS, RDS, S3, Glue, DMS, VPC’s
- Environment: Linux/Unix, AWS, RDS, EC2, S3 MySQL 5.7.31, Postgres 9.6 and 10 community edition, Cassandra DSE 5.0.12, Databricks, Spark, Scala Spark, Oracle 12c, Scala, Snowflake, Airflow, Python, Kubernetes
Database Administrator
PrismHR
12.2016 - 09.2017
- PrismHR provides the most comprehensive software for Professional Employer Organizations (PEOs) and Administrative Service Organizations (ASOs)
- Responsibilities: Installing the Unidata on Linux, Performed POC Connected all applications and make sure Unidata on Linux working with all apps Setup the replication and EDA solution using SQLServer 2014
- Automated the database build process on Linux environment with shell scripts
- Involved in implementing the Unidata database on to Docker architecture
- Setup a SQLServer 2014 and started developing a ETL process using SSIS Created SSIS scripts to pull the data from legacy Unidata environment to SQLServer
- Wrote the Visual basic scripts to copy the data from the Unidata live account to customer demo accounts without impacting the production environment
- Involved in implementing the Unidata on Docker environment
- Implemented the Automation scripts using VBA and macros
- Automate the maintenance task using VBscripts
- Environment: Linux/Unix, Unidata 8.1, Mysql5.6, Postgres9.4, SQLServer 2014, Shell Scripts, Python, SSIS, SSRS, Puppet, Foreman, Docker
Sr DBA/Data Architect
Dunnhumby Inc
01.2016 - 12.2016
- Dunnhumby Inc is a world leading customer Science Company, dunnhumby provide with a clear 360 view of your customers based on data such as shopping habits, social network interactions, local weather patterns, and media exposure Responsibilities: Built a Data warehouse Environment for Business from scratch using postgres pg/plsql
- Created Adhoc reports based on User requirements and done POC of that data
- Strong experience with backups, DR, Performance tuning, patches, installations and Upgrades of all DB’s MySql, postgres Experience in setting up MySQL multi-master replication setup
- Created triggers and stored procedures to provide complex inter-table relationships
- Setup a replication on online postgres databases
- Mentor fellow DBA’s in PostgreSQL 24/7 on-call rotation Environment: Linux/Unix, Oracle10g, Oracle12c, Mysql5.6, Postgres9.4, AWS, SQL Manager, Shell Scripts, Python.
Database Administrator
Credorax Inc
- 01.2016
- Credorax is a smart Acquiring company
- An acquirer specifically focused on the e-commerce and m-commerce arenas, Credorax introduces an entirely new breed of acquiring — Smart Acquiring — to PSPs, ISOs and online retailers Responsibilities: Oracle Server Experience: Responsible for installing, upgrading and configuring the Oracle environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance
- Create & Managing Database Structure, Storage Allocation
- Created Backup procedures using Hot, Cold, RMAN and Logical backups
- Setup and configuration of Data guard
- Responsible for Load and Performance testing of the database servers and application servers
- Created automated scripts by using Python programming
- Implemented the Oracle Service Bus to implement the middle ware process and communication
- Implemented Oracle Forms and Reports to server to maintain the data warehouse reports
- PL/SQL development: packages, stored procedures, functions, triggers Users and roles management, FGA (Fine Grained Auditing) Performance Tuning of the database using AWR, TKPROF, STATSPACK for optimum performance and to meet user requirements
- Assisting Developers in writing and tuning their queries
- Tuning the database: Instance and SQL tuning MySQL /Postgres Experience: Experience of Database Administration, design, development, maintenance and production support of relational databases, business applications, new server setup, MySql and postgres installation, upgrade, migration
- Strong MySql and SQL Server skills but also significant general system administration skills on UNIX/HP Open Implemented of comprehensive backup and database replication solutions
- MySQL multi-master replication setup
- Setup a replication on online postgres databases
- Mentor fellow DBA’s in PostgreSQL DBA techniques
- Environment: Oracle 10g, 11gR2, Toad 12.6, Python, Cognos, Java, PL/SQL, SQL, Mysql 5.6.22, postgreSQL9.2.
Lead BI Analyst
Fidelity Investments
- 10.2012
- Fidelity Investments Information system which is known as MIS (Management Information system),MIS is a Data warehouse and Batch system, During Batch cycle pricing and fund performance data is collected Responsibilities: involved in designing and developing and testing the data pipelines Understand the reporting structure and develop a test strategy on report validation
- Wrote automated scripts for regression testing by using UNIX
- Developed the Automated test cases on the Batch application with Python Scripts
- Designing and analyzing the data warehouse reports and ETL workflows
- Involved in ETL workflow analysis and data validation.
Education
Bachelor of Science - Electronics Technology
Bapatla Engg College
India 04.1994
Skills
- Data Security
- Statistical Analysis
- Quality Assurance
- Business Intelligence
- Data Migration
- Master Data Management
- Data Warehousing
- NoSQL Databases
- Data Governance
- DBMS
- Data Modeling
- Report Development
- Python Programming
- ETL Processes
- Big Data Technologies
- Apache Spark
- Team Leadership
- Data Visualization
- Cloud Computing
- Hadoop Ecosystem
- Metadata Management
- Data Integration
- Data Quality Assurance
- Data Architecture
- Project Management
- R Programming
- Data Analysis
- Linux Operating System
- Continuous Process Improvement
- Systems Administration
- Python
- Data Acquisitions
- Relational Database Management
- Database Development
- Compiling Data
- Disaster Recovery
- Data Audits
- Running Backups
- Agile Methodology
- New Product Testing
- Database Administration
- Implementing Security Measures
- Information Modeling
- Database Management
- SQL Proficiency
- Data Cleansing
- Troubleshooting
Timeline
Sr Database Administrator / Data Engineer
Upgrade Inc
08.2022 - Current
Lead DBA/ Data Architect
Welltok/ Virginpulse
09.2017 - 08.2022
Database Administrator
PrismHR
12.2016 - 09.2017
Sr DBA/Data Architect
Dunnhumby Inc
01.2016 - 12.2016
Risk Data Manager
Citizens Bank
Sr Database QA/Developer
Micros-Retail
Lead BI & DW Consultant
The Hanover Insurance Group
Sr Test Automation Consultant
Department of Public Welfare
Sr Database Consultant
WebMD Practice Services
QA Consultant
Home Shopping Network (HSN)
Sr reporting developer
Taruni Techno Vision
Software Developer
Zen Tech
Database Administrator
Credorax Inc
- 01.2016
Lead BI Analyst
Fidelity Investments
- 10.2012
Bachelor of Science - Electronics Technology
Bapatla Engg College