Srinivas Reddy
AUSTIN,TX
Summary
Over 11 years of experience in creating solutions on data warehouse and data transactional systems with an emphasis on planning, analysis, design, development, testing, deployment, maintenance, and performance improvements/tuning.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Snowflake Admin/Developer
Railroad Commission Of Texas
09.2021 - Current
- Worked on data migration project to load data from Oracle to Snowflake.
- Load data from AWS S3, internal stage to snowflake cloud using theCOPY command.
- Used temp/transient tables to process the data; secured and materialized views to provide the data access to users.
- Utilized Snowpipe to process the data in micro-batches from AWS S3 external stage.
- Created and maintained streams, tasks, and used time travel feature with AT/BEFORE based on the requirement.
- Created clone objects to maintain zero-copy cloning.
- Used Data Build tool (DBT) for the data migration into Snowflake.
- Created and enhanced python programs for generating alerts, loading the data into the tables, and etc,.
- Wrote complex SnowSQL scripts for the data analysis and validations; wrote stored procedures and functions using SQL code.
- Experience with AWS EC2, S3, RDS, DMS, and Airflow.
Snowflake Developer
Canva
09.2020 - 08.2021
- Hired to enhance several PL/SQL programs and work on Oracle to Snowflake migration.
- Created Snowflake comparison documentation for different teams to understand it's functionality and accessibility.
- Installed and setup Data Build tool (DBT), created a snowflake connection and virtualenv and activated it.
- Created models in DBT; configured materializations on the project level.
- Created tables and views in snowflake and steams on the fact/dimension tables.
- Created Snowpipe jobs to feed the data from S3 and created alerts to notify the snowpipe.
- Deployed the sql scripts using SnowSQL and allowed users to take advantage of time travel.
ETL/Database Consultant
Railroad Commission Of Texas
09.2018 - 08.2020
- Responsible for the Database tables design and technical approach in conversion and interface of the gas utility and railroad commission System.
- Worked with DBAs to enhance the physical DB schemas.
- Created complex Informatica mappings, re-usable transformations, and prepared various mappings to load the data into different stages like landing, staging and target tables.
- Implemented business rules by creating transformation, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex mapplets and mappings with ETL Informatica power center.
- Used the Informatica debugger to test the mappings and fixed the mappings.
- Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
- Handled the File transfer through SFTP Scripts, which are running through Informatica and have good knowledge in Unix Shell Scripting.
- Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through trigger.
- Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.
- Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
- Developed Oracle Forms & Reports using Forms12c, and Reports12c Including Forms based on stored procedures.
Data Conversion Specialist
Office Of The Attorney General Of Texas
08.2017 - 08.2018
- Created, shared and reviewed conversion reports to confirm accurate data conversions.
- Followed Sensitive Personal Information (PHI), PHI, and HIPAA rules and regulations while working on the data.
- Performed data loading from source to target using Informatica Cloud designer.
- Created Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy transformations in the complex mapplets and mappings with ETL Informatica power center.
- Wrote SQL and custom SQL PL code to achieve ETL process of extracting the data from multiple sources, transforming the data based on definitions, and loading the data into target databases.
- Created Indexes, constraints, partitions on database objects (tables, views), and considered the performance of database due to the billions volume of data.
- Created ETL workflows with Data flow, control flow Task, Script Task, Execute SQL Task and Containers.
- Wrote complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Functions to implement the business logic and created Clustered and non-Clustered indexes.
- Executed SQL queries to extract data from DB2 tables for running test scripts.
- Worked extensively through Agile development methodology by dividing the application into iterations.
ETL Developer
Union Bank
10.2016 - 08.2017
- Developed technical specifications of the ETL process flow.
- Worked on design and development of Informatica mappings, workflows to load the data into the landing and staging areas, data marts in SQL Server, and Oracle.
- Created mappings, re-usable sessions, and workflows to populate the data into the fact, dimension, and lookup/plain tables simultaneously from different source systems like flat files, DB2, mainframe, Oracle, and etc,.
- Created mappings using various transformations like aggregator, expression, filter, router, joiner, and update strategy.
- Used version mapping to update the slowly changing dimensions to keep full history to the target database.
- Implemented sending post-session email if the data is loaded or not.
- Wrote PL/SQL procedures to clean-up the old data in the staging tables as well as CDC tables.
- Wrote PL/SQL packages to automate the validation of the data loads into the fact/dimension tables.
Data Consultant
Delta Dental
04.2015 - 09.2016
- Lead the team of 3 on-site and 2 offshore developers and analyst as a lead data conversion developer.
- Assisted in Requirements gathering, Data Analysis, and Design and wrote technical design documents.
- Coded database triggers, packages, functions, procedures using PL/SQL and maintained the scripts for data feeds.
- Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
- Developed and maintained for the ETL (Extract, Transform and Load) processes using Oracle and SAP BODS.
- Created PL/SQL store procedures to generate the reports for data discrepancy for each fact/dimension load.
Database/ETL Developer
Elavon
01.2014 - 03.2015
- Created and maintained tables, materialized views (Summary Tables), procedures, functions, and packages, and update, delete, and insert statements and compile them.
- Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
- Coded PL/SQL sub-programs and modified the existing PL/SQL program units. Constant monitoring and performance tuning of the Oracle database checked the most expensive queries.
- Incomplete and full database recovery with experience of complex recovery scenarios.
- Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
- Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
Software Programmer
MindGrid Technologies
01.2011 - 11.2012
- Coded PL/SQL sub-programs and modified the existing PL/SQL program units. Constant monitoring and performance tuning of the Oracle database checked the most expensive queries.
- Incomplete and full database recovery with experience of complex recovery scenarios.
- Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
- Performed a review and analysis of database deadlocks and database performance tuning.
Education
Master of Science - Management Information Systems
University of Mary Hardin-Baylor
Belton, TX12.2013
Bachelor of Technology - Electrical, Electronics Engineering Technologies
JNT University
Hyderabad04.2011
Skills
Oracle, DB2
Informatica
IICS
SQL, PL/SQL
Shell scripting
ETL/ELT
Snowflake
DBT
Python
Matillion
AWS
Certification
- Certified Snowpro Core, Snowflake
Timeline
Snowflake Admin/Developer
Railroad Commission Of Texas
09.2021 - Current
Snowflake Developer
Canva
09.2020 - 08.2021
ETL/Database Consultant
Railroad Commission Of Texas
09.2018 - 08.2020
Data Conversion Specialist
Office Of The Attorney General Of Texas
08.2017 - 08.2018
ETL Developer
Union Bank
10.2016 - 08.2017
Data Consultant
Delta Dental
04.2015 - 09.2016
Database/ETL Developer
Elavon
01.2014 - 03.2015
Software Programmer
MindGrid Technologies
01.2011 - 11.2012
Master of Science - Management Information Systems
University of Mary Hardin-Baylor
Bachelor of Technology - Electrical, Electronics Engineering Technologies
JNT University
- Certified Snowpro Core, Snowflake
Similar Profiles
Steven MendezSteven Mendez
Inspector (CID) at Railroad Commission of TexasInspector (CID) at Railroad Commission of Texas
JOHNNY GARCIAJOHNNY GARCIA
Foreman/track Inspector at Texas City Terminal RailroadForeman/track Inspector at Texas City Terminal Railroad
Kailee MillsapKailee Millsap
Cafe Attendant at Texas State RailroadCafe Attendant at Texas State Railroad