Home

Raghavendra Prasad - Snowflake Data Engineer

[email protected]

Location: , , USA

Relocation: YES

Visa: H1B

Resume file: Raghavendra - Snowflake DataEngineer_1749661518390.doc Please check the file(s) for viruses. Files are checked manually and then made available for download.

Certified Professional Data Engineer with expertise in Snowflake, DBT, Informatica and SAP with around 16 years of IT experience which includes experience in Analysis, design, development and implementation of Data Warehousing, Data Architecture, Data Integration Solutions using Snowflake, Informatica Intelligent Cloud Services (IICS), AWS, ADF, Data Bricks & Salesforce. Experience in Migrating the on prem data from different sources using different AWS services like Database Migration Service, S3, AWS Glue jobs, API Gateway, CloudWatch, SNS, IAM, EC2 Experience on Data Architecture Design, Data Modelling and physical database design and tuning Extracted the data for Multiple data sets like csv, json , parquet and built the transformations to create Final Models using Snowpark API Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL. Adept at translating business needs into end user interactive reports thereby aiding business decisions with demonstrated experience in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications such as Snowflake and Teradata Hands-on experience in creating the Denodo views through using JDBC, ODBC, Delimited files and SOAP/REST Web services. Working on Production Support for the applications like Snowflake, Fivetran, Trifacta Collaborate with Data analysts and Business stake holders to gather requirements and deliver solutions Experience in working on Different data sets like Json, Avro, Parquet, CSV files Experience in Migration from SQL server, Oracle database to Snowflake for Health care systems Implemented Target Models and built transformations Using Snowflake. Develop Data quality checks and Data validation processes to ensure data accuracy and consistency. Implemented real-time data ingestion/pipelines using Snow Pipe, Storage integration and ADF. Implemented the integration between Confluent Kafka to Snowflake Develop SQL queries and created Secure views using Snow SQL, Snow Sight and used Python worksheet for Data loading. Created Reader and Shared accounts for multiple customers for Data Sharing Experience in writing Snowflake Stored Procedures and Sql s Experience in using GITHUB creating new repositories and deploying the code to Test Environments. Good experience in Performance tuning and applying Optimization techniques on both sql and snowflake Having Good Domain Knowledge on Banking, Retail, health care, telecom, insurance & staffing Experience in Business intelligence tools such as Tableau & Power BI reporting. Worked on ETL Methodology for supporting Data Extraction, Transformation and loading data into the Warehouse by using Informatica PowerCenter TRAININGS & CERTIFICATION Cloud Computing Snowflake, Snow sight, DBT, Trifacta, Snow SQL, Snow Sight, Snowpark, Salesforce, Python worksheet AWS Services Database Migration Service, S3, AWS Glue jobs, API Gateway, CloudWatch, SNS, SQS IAM, EC2 Reporting Tools Tableau, Power BI, Sigma and SQR 6.0 ETL Informatica Power Center 7.1.3 ,9.0, Snaplogic ERP SAP, SuccessFactors & Oracle HCM Languages SQL, Python, Json & XML Databases Snowflake, Oracle 8i/11i, DB2 8.1, MS SQL server Data ingestion Fivetran Big Data Hive, Pig, Sqoop, Kafka Deployment Git hub REWARDS & REGONIZATIONS Awarded Outstanding Performance for maintaining Quality and good turn around time. Received Applause award for Quick turn around and quality results. Achieved Team Terrific award on exemplary contribution during scarcity of resources. DETAILED PROFESSIONAL EXPERIENCE FinAdvantage consulting Pvt Ltd (Jan 2024 Till Date) Title : Senior Data Engineer Client: Principal Financial Group, Des Moines, IOWA Responsibilities: Co-ordination with the onsite team members for requirement clarifications. Worked on Snowflake migration using Informatica, AWS Cloud provider. Excellent experience in Warehouses, Roles, Schema, Databases, Resource Monitor. Created a different table in Snowflake development. Have experience in creating Users, IAM roles & trusted policies on AWS as part of integration. Implemented Snowflake Data Pipeline to configure Auto-Ingestion from AWS S3 to Snowflake. Excellent experience in using Snowflake features like Snow pipe, Streams, Tasks, Stages, Clustering, Time Travel and Fail safe. Experience in Data Migration from SQL Server to Cloud/Snowflake cloud data warehouse Deep understanding of Snowflake architecture, Caching and Virtual data warehouse scaling. Expertise in bulk loading into Snowflake tables using COPY command Created data pipelines with streams and tasks Exposure in processing semi structured data files like JSON and Parquet into snowflake. Experience in using zero copy clone to replicate Lower environments from production Handled large and complex data sets in CSV format from object stores like AWS S3. Experience in Snowflake features such as Data sharing, SnowSQL, Snowpipe, Tasks, Zero copy clone and Time travel Provided code walkthrough to onsite. Involved in Enterprise Architecture Planning using Snowflake. Experience in Designing Dimension Modelling and New Data Warehouse Architecture Conducted workshops for Requirement gatherings. Worked on Date Functions conversion into Snowflake. Built transformations on snowflake for different data sets like json, csv Implemented Data cloning, time travel, swapping to multiple target tables Implemented snow pipe for real-time data ingestion/pipelines using S3 and AWS storage integration Created Streams and tasks to orchestrate in Snowflake Involved in Migrating Objects from Teradata to Snowflake. Developed custom SnapLogic connectors and utilized SnapLogic APIs to enhance and extend the platform's functionalities, specifically for seamless integration with Snowflake. Implemented best practices for SnapLogic workflows, ensuring data security, integrity, and scalability within Snowflake data warehouse environments. Collaborated with data architects and business stakeholders to understand business requirements and translated them into technical solutions using SnapLogic for Snowflake data management. Developed ELT workflows using NiFI to load data into Hive and Teradata. Created BTEQ scripts for Teradata used utilities FastLoad, MultiLoad. Worked on data transfer mechanism from Hive to Teradata. Created Snowpipe for continuous data load. Used COPY to bulk load the data. Created internal and external stage and transformed data during load. Used FLATTEN table function to produce lateral view of VARIENT, OBECT and ARRAY column. Involved in unit testing and integration testing. Experience in Data Migration from Oracle, SQL server to Snowflake cloud data warehouse Hands-on experience with Snowflake utilities, SnowSQL, Snow Pipe Experience in writing simple/complex queries, Secured Views, Materialized views in Snowflake. Expertise in deploying Snowflake features such as data sharing. Worked on virtual warehouse sizing, query performance tuning, zero copy clone, time travel Designed the Data Modeling and implemented SCD s for one of the requirements Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions. Experience in writing functions in pivotal green plum Proven experience in writing complex sql queries and functions in oracle and Greenplum Involved in creation of Denodo views and schedules Creating Denodo views and derived views in VDP with connecting multiple data source systems Involved in designing and creating reports in Denodo platform Code review of all technical specs like informatica mappings, sessions and scripts and responsible for deliverables. Tuning the performance of mappings and sessions in informatica and at database level Design, Development and implementation of Informatica Developer Mappings for data cleansing using Address validator, Labeler, Association, Parser, Expression, Filter, Router, Lookup transformations etc. Environment : DB: Oracle,Sql server Cloud DB: Snowflake, ETL: Informatica, Cloud: AWS, On-Premise DB: Oracle, Reporting: Business Objects STANDARD CHARTERED GLOBAL BUSINESS SERVICES PVT.LTD (Dec 2017 Dec 2023) Role: Senior Research Specialist Client: Citizens Bank, Providence June 2022 Till date Responsibilities: Responsible for the Data Analysis on the Source systems and designed mappings and workflows accordingly. Writing PL/SQL Packages, Procedures, Functions, Triggers, Cursors, Anonymous block and other objects for the back-end processing of the proposed database design. Writing scripts for creating Tables, Sequences, Views, Synonyms and Other Database Objects. Client-side validation using JavaScript Designing of the Database Objects Deployment support. Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning. Performed the set up the VSS source code architecture for the client. Performed code reviews. Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing. Analyzing the problems and providing optimum solutions to customers. Participation in unit and system test process. Created internal and external stages and transformed data during the loading. Performed data quality issue analysis using Snow SQL by building the analytical ware houses on the Snowflake. Implemented Change Data Capture (CDC) and Slowly Changing Dimensions (SCD) type-2 for real-time and historical data tracking. Conducted requirement gathering, analysis, and design for data warehousing projects. Communicated effectively with clients to understand their needs and provide tailored solutions. Led a team of data engineers, providing guidance and mentorship. Environment: DB: Oracle, Sql server Cloud DB: Snowflake, ETL: DBT, Cloud: AWS, AZURE On-Premise DB: SSMS, Transformation: Trifacta, Reporting: Sigma, Data Ingestion: Fivetran, MDM: Reltio Role: Research Specialist Client: Westfield Insurance, Westfield Center, OH Dec 2017 May 2022 Responsibilities: Worked on Date Functions conversion into Snowflake. Built transformations on snowflake for different data sets like json, csv Implemented Data cloning, time travel, swapping to multiple target tables Implemented snow pipe for real-time data ingestion/pipelines using S3 and AWS storage integration Created Streams and tasks to orchestrate in Snowflake Involved in Migrating Objects from Teradata to Snowflake. Developed custom SnapLogic connectors and utilized SnapLogic APIs to enhance and extend the platform's functionalities, specifically for seamless integration with Snowflake. Implemented best practices for SnapLogic workflows, ensuring data security, integrity, and scalability within Snowflake data warehouse environments. Collaborated with data architects and business stakeholders to understand business requirements and translated them into technical solutions using SnapLogic for Snowflake data management. Created Snowpipe for continuous data load. Used COPY to bulk load the data. Created internal and external stage and transformed data during load. Used FLATTEN table function to produce lateral view of VARIENT, OBECT and ARRAY column. Involved in unit testing and integration testing. Experience in Data Migration from Oracle, SQL server to Snowflake cloud data warehouse Hands-on experience with Snowflake utilities, SnowSQL, Snow Pipe Experience in writing simple/complex queries, Secured Views, Materialized views in Snowflake. Expertise in deploying Snowflake features such as data sharing. Environment : DB: Oracle,Sql server Cloud DB: Snowflake, ETL: Informatica, Cloud: AWS, On-Premise DB: Oracle, Reporting: Business Objects DELOITTE SUPPORT SERVICES INDIA PVT.LTD (DEC 2008 MAR 2016) Client: Coca-Cola, Atlanta, GA: June 2012 Mar 2016 Role: Senior Analyst -SAP HR, TM Project Phase SAP Implementation-Roll Out and Support Role: Lead Consultant -SAP HR, TM Environment: ECC5.0 Role Summary: Functional Consultant role to lead the off shore team of SAP HCM in order to support the Day to Day issues and Rollouts of different country implementations. Responsible for Change request process and 100% SLA. Responsible to Identify, document and map processes required to ensure timely application and communication for maintenance update on future enhancements. Involved and Lead the Knowledge Transfer process during the handover of Application Support to the different Vendors. Responsibilities: Involved in Full Life cycle implementation in the configuration of SAP HR to meet the client s strategic and tactical business needs. Defined HR implementation scope, establishing project resources and determining SAP HR functionality. Discovered gaps and areas for process improvements and provided recommendations. Work schedules, shift schedules were generated for all the employees. Defined public holiday classes according to the clients requirements. Configure time wage types for time evaluation, both regular time and overtime. System settings were made for infotype 2003 for substitutions. Counting rules were defined for absence counting Defined the leave quotas based on employee group and employee subgroup by using the infotype 2006 (Absence Quota). Maintained the time evaluation schema TM04 for generating holiday hours depending on the work schedule. Created time sheets trough transaction CAT2 and approved in CATS. Evaluated time using RPTIME00 and maintained master data in infotypes 2001, 2002, 2010. Client: Deloitte Canada: July 2010 -May 2012 Role: Senior Analyst -SAP HCM Project Phase Support project OM & PA Environment: ECC5.0 Role Summary: Client is a Deloitte internal client (Deloitte Canada). Deloitte Deloitte Canada has implemented Personnel Administration, Organizational Management. Responsibilities: Personnel Administration: - Addressing the daily Tickets. Involved in KT process. Communicating with the Client as well as the Product Manager to understand the Business process and Requirements. Designed functional specification for new changes. Understanding in working for release management, releasing quality of production. Consulting Support service in the areas of PA, OM, TM. Configuring Personnel Areas, Personnel Sub-Areas, Employee Groups and Employee Subgroups, Info type menus in the master data screens (PA30) as per the requirements. Setting up of Info groups for Personnel Actions like Hiring. Defined Public holiday classes and maintained Holiday calendar. Creation of Daily Work Schedules, defining Break Schedules, Period Work Schedules, set Work Schedule Rules and using feature SCHKZ as per the requirements Define absence types and absence quotas types. Maintained Counting Rules, Deduction Rules, and Base Entitlements for Absence Quotas. Organization Management: - Creating of Object Types, Object Relationships. (Organization units to Organization units, Positions, Jobs & Tasks.) Creation of organization actions Organization and Staffing Interface Organization Structure - Expert Mode Info type Maintenance & Simple Maintenance. Technical Environment: SAP HCM ECC 6.0. HRIS Analytics / Market Mapping & Analysis (Power BI & Tableau) December 2008 June 2010 Providing Market Mapping to find out the market trend and analysis on each segment from different Industries by preparing data pertaining to (Diversity percentage, Industry, Top Skills, Experience, Local & Non Local etc..) Proficient in preparing MIS to support measurement of service delivery and customer satisfaction through dashboards by using Power BI & Tableu for data visualization Accountable for preparing and publishing daily reports (Open / Filled/Cancelled & On Hold) for the different Entities / Business Functions. Efficiently Delivering reports on Daily, Weekly & Monthly MIS Reports & Dashboard. Always ahead in chasing respective Recruiters / TAM s to meet the SLA s (Agency Payments, Step Status change in Malaysia & SD Form & Highlights collecting for Town Hall) Prepared MIS reports such as GTR Dashboard, Post Selection report / Time to offer & Time to fill / Offer Renege and Refused / Diversity/ Internal vs External & Requisition pending approval etc.. Helped in providing inputs Automation file for Daily Open report, Post selection report Gained strong knowledge in finding the Gaps in Reporting as well in Oracle Taleo & MSTR tool and informed the respective SPOC s to resolve the issues by following up multiple time until we get the solution Supporting the Business with presentation using Excel pivot tables and charts along with the Inferences. Handled multiple reports, working with formulae, pivot tables & pivot charts, and various other excel sheet components for accurate data. Resource Management: Allocating the client hours by checking the Availability report and Requirement information, handling the adhoc client hours request by negotiating with Sr Manager and Manager to utilize their resources in critical projects. Map the resources against business demands, monitoring and tracking employee s utilization details for all revenue and non-revenue client, following up with professional in regards to variance, support professional to update their assignment loader and updating their schedules in Staff Track. Working on different reports like Variance, schedule hours report and sending staffboard report for weekly meetings and Headcount reconciliation. Management information system (MIS): Analysis different types of MIS reports like headcount analysis, attrition analysis, compensation analysis, performance analysis, schedule hours, availability hours , requirement hours with the support of software tool and running Macro s. Recruitment: Accountable to hire the Leadership roles Band of 3,4, &5 those are Director, Senior Vice President, Vice President & Associate Vice President budgeted recruitment numbers for IT and Non-IT requirements for fiscal which is spilt across a quarter and then periods. Handling all Business Functions, ITO, CIB, Private, Retail, Commercial & Wealth Management. Successfully drive the extended team- Sourcing Specialists, Coordination support and Onboarding Specialists to meet the recruitment targets for the practice, coach and mentor the team to provide the direction and infuse rigor in the process. Develop and cultivate relationships with various levels of management, candidates, and external recruiting sources LOA & PTO tracking: Calculating and proration of their annual client service hour s goals based on their LOA dates and updating their information in the Service hour s summary tool. Maintaining accurate records of employees on leaves tracking LOA start date and End date. Maintaining bi-weekly reports on leave trends including current leaves and returns from leaves. Maintaining PTO (Personal time of) mail box and updating their schedules in StaffTrak tool based on their leave eligibility and necessary approvals from Sr Manager and PPD s based on the duration of their Leave and type of leaves like Sick leave, Maternity leave & CPA leave. Resource utilization: Map resources against business demands, monitoring and tracking employee s utilization details for all revenue and non-revenue client, following up with professional in regards to variance, support professional to update their assignment loader and updating their schedules in Staff Track. Working on different reports like Variance, schedule hours report and sending staffboard report for weekly meetings and Headcount reconciliation. Compensation & Benefit: Compensation analysis by supporting with yearend compensation review, normalization according to grades, assisting by maintaining compensation offline spreadsheet, helping US talent for Minimum, Mid and Maximum Salary ranges based on location, Level and Service area. Entering Merit, Promotion and AIP information in workscape tool, assisting US talent for workscape reports for analysis. FOURSOFT LTD (CURRENLY KNOWN AS KEWILL INC) (NOV 2004 NOV'2008) Designation: Dy Manager Recruitments Ensuring the complete life cycle as per the company s recruitment procedure right from sourcing a candidate to generating the offer letter. Leading a team of three technical recruiters & two HR generalists Sourcing Candidates as per requirements using sourcing tools like Naukri, Jobsahead, Monster, Internal database, job postings, and referrals. Short-listing of candidate s profiles in accordance with the requirement. Interacting with the candidates for job openings, scheduling and organizing the interviews. Conducted & Participated in walk-in interviews. Interacting with the Project managers on regular basis for the understanding of upcoming requirements. Allocation of resources based on the requirement in respective departments. Taking part in the meetings to understand the Head Count required for that particular month for a particular competency. Weekly & Monthly Reports Generation: Preparing high quality MIS to support proper analysis and appropriate decision- making for the Superiors, Management and Other teams (MIS,Weekly and Monthly Headcount Reports to be maintained and circulated with 100% accuracy to management. Preparing ITC cost report Other related HR reports ACADEMIC CREDENTIALS Master in Business Administration, Osmania University, 2001 to 2003. Bachelor of Commerce, Andhra University, 1997 to 2000. Keywords: business intelligence sthree database information technology microsoft procedural language Colorado Georgia Ohio Pennsylvania South Dakota