Home

Lenin kumar - Snow flake developer

[email protected]

Location: Addison, Alabama, USA

Relocation: yes

Visa: H1B

Kumar B Snowflake Developer Mobile:972-410-6336 Professional Summary 8 years of IT experience with a strong background in Snowflake, Data warehousing, Data Integration tools including Informatica PowerCenter and Business intelligence applications in Financial, Insurance, Retail and Telecom Industries. 2 Years of experience in Snowflake as a Developer. Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing. Data Loading experience in SQL Server 2008 using SSIC ETL and experience in developing packages in SSIS and DTS according to task. Strong experience in migrating other databases to snowflake. Experience with Snowflake Multi - Cluster Warehouses. Good experience in UNIX/LINUX working environment. Responsible for on boarding the users onto Snowflake, Creating, and managing Storage Integrations, DB objects, Stages (Internal & External), File Formats (JSON, CSV, TSV). Experience working on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files. Hand on experience on various SQL Server services like integration services (SSIS), and reporting services (SSRS). Professional knowledge of AWS Redshift. Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table. Design relational and non-relational data stores on Azure. Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling. Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes. Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions, and Dimensional Modeling (Star Schema and Snowflake Schema) and Kimball methodologies. Good understanding on Tableau Desktop and Tableau Online. Good knowledge on data migration and data analysis by transferring them using SSIS packages. In-depth knowledge of Snowflake Database, Schema and Table structures. Strong experience in SQL Server DTS and SSIS Integration Services package design, constructing, and deployment. Good experience with Snowflake utilities, SnowSQL, SnowPipe using Python. Experience in migration of Data from various sources like Excel, Flat file etc., to MS SQL Server by using MS SQL Server DTS and SSIS. Expert in designing stylish reports like Drilldown, Parametrized, ad-hoc and chart reports using SQL Server Reporting Services (SSRS). Education Details: Bachelor s: Bachelor s in Science Osmania University (2012-2015) Master s: Master s in CS, Troy University, AL (2015-2017) Certifications: SnowPro Core Certification Technical Skills: Programming Languages Python, Bash Query Languages SQL, PL/SQL, T-SQL, SnowSQL ETL Tools Informatica Power Exchange Databases Oracle 10g/9i/8i, DB28.x, SQL Server 2012/2014 Reporting Tools SSRS, PowerBI, QlikView Version control Git, SVN, TFVC Cloud Platform AWS, Azure Cloud Technologies EC2, S3, EMR Scheduling Tools Control-M, Crontab, Autosys Professional Experience: Client: Fiserv, Alpharetta GA Aug 2021 - Present Snowflake Developer Responsibilities: Experience with end-to-end implementation of Snowflake cloud data warehouse. Extensively worked on Views, Stored Procedures, Triggers and SQL queries and for loading the data (staging) to enhance and maintain the existing functionality. Experience working ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL Writing SQL queries against Snowflake. Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding. Created various Documents such as Source-to-Target Data mapping Document, and Unit Test Cases Document. Expertise with Snow SQL, advanced concepts query performance tuning, time travel etc. and features/tools data sharing events, Snow Pipe etc. Very good knowledge on RDBMS topics, ability to write complex SQL, PL/SQL. Migrated mappings from Development to Testing and from Testing to Production. Establish data structures for all enterprise data stored in business intelligence systems. Used ETL to extract files for the external vendors and coordinated that effort. Establish interfaces between the data warehouse and reporting tools, such as PowerBI. Build the Logical and Physical data model for snowflake as per the changes required. Created Snow-pipes for continuous data load. Created internal and external stage and transformed data during load. Used Temporary and Transient tables on different datasets. Implemented data transformations and data structures for data warehouse and repository. Created the External Tables to load data from flat files and PL/SQL scripts for monitoring. Writing Tuned SQL queries for data retrieval involving Complex Join Conditions. Works with the project team to analyze and resolve problems. Good understanding on Agile process and Agile project execution. Used ETL to extract files for the external vendors and coordinated that effort. Migrated mappings from Development to Testing and from Testing to Production. Performed Unit Testing and tuned for better performance. Environment: SQL, Oracle, PowerBI, Snowflake, Python, AWS, S3, IAM, SQS, SNS, JIRA, Google Analytics, Tableu, SSIS. Verizon, Tampa, FL Sep 2018 Jul 2021 SQL BI Developer Responsibilities: Participated in Daily stand-up call in a Scrum Environment and discussing about things to do and things completed so far in the present sprint. Participated in Backlog grooming and Sprint planning meetings. Performed Pre-deployment Unit testing & Functional testing in DEV and TEST Environments. Worked as QA for other projects and helped in writing test cases and worked on executing them by performing the functional testing for Pre and Post deployment cases. Worked on Project management by tasking the project to actionable sub-tasks. Worked on refining the spec features, business rule validation and refinement with Business Analysts. Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes. Involved in writing automated scripts, Stored procedures to improve the performance of internal tools and thus reducing the overall cycle time. Worked on SQL development like modifying complex SQL stored procedures to accommodate the needed business logic and to make the procedures work accordingly. Worked on SQL server batch updates on the production server and monitored the performance. Worked with SQL server profiler to trace out the stuff that is needed and helpful to figure out the flow and functionality of procedures. Used Bulk collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. Developed T-SQL Scripts to identify SQL Server objects without indexes and relationships and helped create clustered and non-clustered indexes for optimizing the database performance. Involved in Unit testing, System testing. regression testing. Provided production support for the production database and also to the code deployed in production environment. Environment: MS SQL Server 2012, MS office 2010 T-SQL, SQL Server Query Analyzer, Microsoft SSMS, SQL Server Integration Services (SSIS), Visual studio 2010, object Scripter. NBC Universals, NYC Jan 2017 - Aug 2018 SQL Server Developer Responsibilities: Created and maintained database objects. Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic using TSQL. Created various reports using MS Reporting Services. Assisted in writing and optimizing complex SQL Queries. Analyzed the existing application programs and tuned SQL queries using SQL Profiler. Involved in writing scripts for the programs. Created aggregation queries for reporting and analysis. Loading data from various data sources using MS Data Transformation Services. Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting. Worked on SQL loader to load data from flat files and obtained from various facilities every day. SQL performance tuning by modifying SQL or adding/changing indexes. Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML etc. Wrote and integrated stored procedures to generate the reports. Created PL/SQL triggers and master tables for automatic creation of primary keys. Developed Stored Procedures, functions, and packages as part of project requirements. Provided on-call support for various projects. Environment: SQL Server 2005/2008, SQL Diagrams, Sybase, DTS, Excel, MS Access 2000, ASP, MS SQL Reporting Services, Query Analyzer, Sql-Profiler. NBC Universals, NYC Sep 2014 - Dec 2015 SQL Server Developer Responsibilities: Designed and analyzed the SQL Server database and involved in gathering the user requirements. Responsible for pushing data objects across databases to different working levels: Dev- Test- Prod. Logical and physical design of database for project based to user requirements. Created Triggers to enforce data and referential integrity. Defined Check Constraints, Business Rules, Indexes, and Views. Coordinated with the front-end developer to put in the business rules. Created procedure to check some of the rules at the backend at the time of entering data. Created tables, Stored Procedures, views, triggers to facilitate the web application. Good programming skills and experience in VB.Net. Used tools like SQL Profiler, Index Tuning Wizard and database Engine tuning Wizard, Windows performance monitor for monitoring and turning MS SQL Server performance. Environment: SQL Server 2008, Query Analyzer, DTS Designer, Excel, MS Access 2000, Index Tuning Wizard, SQL Profiler. Keywords: quality analyst business intelligence sthree database active directory information technology microsoft procedural language Alabama Florida Georgia