Nov 2020 – Oct 2023 · 2 yrs 11 mos · Cedar Rapids, Iowa, United States · Remote

•  Created reports on Metabase to see the Tableau impact on snowflake in terms of cost.
•  Participated in sprint planning meetings, worked closely with manager on gathering the requirements.
•  Designed and implemented efficient data pipelines (ETLs) in order to integrate data from a variety of sources into Data Warehouse.
•  Worked extensively in Mainframe - COBOL, JCL, DB2, IMS, Control-M and VSAM .
•  Developing ETL pipelines in and out of data warehouse using Snowflakes SnowSQL Writing SQL queries against Snowflake

Oct 2017 – Nov 2020 · 3 yrs 1 mo · Irving, Texas, United States · On-site

•  Involved in End-to-End migration of 800+ Object with 4TB Size from Sql server to Snowflake.
•  Data moved from Sql Server  Azure snowflake internal stageSnowflake. with copy options.
•  Published reports and dashboards using Power BI.
•  Created roles and access level privileges and taken care of Snowflake Admin Activity end to end.
•  Converted 230 views query’s from Sql serversnowflake compatibility.
•  Retrofitted 500 Talend jobs from SQL Server to Snowflake.
•  Worked on SnowSQL and Snow pipe
•  Converted Talend Joblets to support the snowflake functionality.
•  Created Dax Queries to generated computed columns in Power BI.
•  Involved in creating new stored procedures and optimizing existing queries and stored procedures.
•  Created data sharing between two snowflake accounts (Prod—Dev).
•  Migrate the database 500 + Tables and views from Redshift to Snowflake.
•  Redesigned the Views in snowflake to increase the performance.

May 2016 – Sep 2017 · 1 yr 4 mos · Boston, Massachusetts, United States · On-site

•  Evaluate Snowflake Design considerations for any change in the application.
•  Build the Logical and Physical data model for snowflake as per the changes required.
•  Define roles, privileges required to access different database objects.
•  Define virtual warehouse sizing for Snowflake for different type of workloads.
•  Design and code required Database structures and components.
•  Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
•  Build the Logical and Physical data model for snowflake as per the changes required.
•  Worked with cloud architect to set up the environment.
•  Involved in Migrating Objects from Teradata to Snowflake.
•  Created Snowpipe for continuous data load.
•  Used COPY to bulk load the data.
•  Created internal and external stage and transformed data during load.

May 2012 – Jul 2014 · 2 yrs 2 mos · Hyderabad, Telangana, India · On-site

•  Primarily worked on a project to develop internal ETL product to handle complex and large volume healthcare claims data. Designed ETL framework and developed number of packages.
•  Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
•  Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
•  Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
•  Played key role in testing Hive LLAP and ACID properties to leverage row level transactions in hive.
•  Volunteered in designing an architecture for a dataset in Hadoop with estimated data size of 2PT/day.
•  Integrated Splunk reporting services with Hadoop eco system to monitor different datasets.
•  Used Avro, Parquet and ORC data formats to store in to HDFS.
•  Developed workflow in SSIS to automate the tasks of loading the data into HDFS and processing using hive.
•  Develop alerts and timed reports Develop and manage Splunk applications.