Siva – 9+ Years – Snowflake Developer
PROFESSIONAL SUMMARY:

 9+ years of experience in full life cycle of software project development in various areas like Analysis, Design, Development, Testing and Implementation of business application systems for Banking & Financial Services in AS400, Snowflake and Matillion.
 Worked extensively in DB2/400, CL/400, RPG/400, COBOL/400, SQL400, RPG ILE and COBOL ILE programming languages.
 Extensive experience in ETL methodology for performing Data Extraction, Transformation and Loading using Talend and designed data conversions from variety of source systems including Oracle, DB2 and non - relational sources like flat files, XLS and CSV files.
 Experience in Matillion ETL solution to develop pipeline that extract and transform data from multiple sources and loading to Snowflake.
 Migrating the existing data from SQL Server to Snowflake DWH using Matillion Orchestration Jobs.
 Experience with Snowflake Multi-Cluster Warehouses and Snowflake Virtual Warehouses and creating Materialized views in Snowflake and by using Matillion objects.
 Knowledge on Data sharing in Snowflake. Hands on Snowflake database, Schema and Table structures, and experience in using Snowflake Clone and Time Travel.
 Experience on using Amazon S3 services in Matillion job flows.
 Hands on experience in creating Matillion Orchestration Jobs by using components which related to Input, output, update, metadata, Python and Calculator.

 Expertise in creating interactive dashboards by using Marks, Actions, Filters and Parameter
 Experience in creating Normal filters, Quick filters, Context Quick filters and Cascading Filters
 Experience in sets, Joins, bins, hierarchies, sorting, grouping, actions, table Calculations, calculated measures and parameters
 Hands on experience in developing Dashboards, Reports using Tableau Visualizations
 Experience in designing visualizations using Tableau software and Publishing and Presenting dashboards to Tableau server


PROFESSIONAL EXPERIENCE:

 Working as a Specialist Software Engineer from Sep 2019 to Till Date.
 Worked from Dec 2012 to Sep 2019



TECHNICAL SKILL SET:

Operating Systems Windows XP, Windows 7 and OS/400
Database DB2/400, Oracle
Programming
Languages
CL/400, RPG/400, COBOL/400, CLLE, SQL400, RPG ILE and Oracle(PL/SQL)
Utilities/Tools SEU, RLU, SDA
Version Control Tool Implementer and Aldon
ETL Tools Talend and Matillion
Data Warehouse Snowflake
Reporting Tool Tableau


ACADEMIC QUALIFICATION:

 MCA (2007-2010) with 75%.

 BSC Computers with 60%.


CERTIFICATIONS & AWARDS:

 Received APEX(PEGASUS) award for Q3 FY2015
 Received APPLAUD for Tableau Report
 Received Several Appreciation mails from the Client for committed and hard working
towards deliverables.
 Received many appreciation mails from client
















PROJECT DETAILS:
Project #1

Project Name: OneMain Financial
Data Base: DB2/400
Languages: CL/400, RPG/400, COBOL/400, CL ILE, RPG ILE, COBOL ILE.
ETL Tool: Matillion
Data warehouse: Snowflake

OneMain Holdings, Inc. is an American financial services holding company headquartered in Evansville, Indiana, with central offices throughout the United States. The company wholly owns Springleaf Finance Corporation and its subsidiaries, through which it operates in the consumer finance and insurance industries as OneMain Financial. Its business primarily focuses on providing personal loans and optional insurance products to customers with limited access to traditional lenders, such as banks and credit card companies.
Roles & Responsibilities:

 Study the functionality of the application and understand the requirements
 Coding of DB2/400, CL/400, RPG/400, CLLE and RPGLE Programs
 Analyse requirement, preparing detailed technical specifications and coding for the same
 Coding, Unit Testing and Integration testing.
 Involving preparing Business requirement documents
 Involving in preparation of Unit Test Plan and Unit Test Results
 Involving in preparation of implementation log and Source Compares
 Involving in Code and Test Results reviewing
 Involving in Integrated System Testing and Supporting BAT and UAT
 Used temporary and transient tables on different datasets in snowflake.
 Created snow pipe