Vishnupriya Ranganathan

• Creation and Implementation of Automation framework using AWS, Python and Snowflake
• Development of Stored procedures and schedule them using Tasks in Snowflake
• Creation of views, tables and user-defined functions in Snowflake
• Automation of generating key-pair in AWS Lambda and assigning it to different users in Snowflake
• Creation of External functions in Snowflake to invoke AWS Lambda through API gateway
• Integration of Snowflake with AWS using FastAPI and Pydantic models as part of Automation
• Exposure on Snowpipe, SnowSQL and Streams
• Configuring stages and Storage integration in Snowflake for Data loading
• Created CICD pipeline in Git for deploying data objects in Snowflake
• Worked closely with clients to implement solutions for enhancements
• Evaluated and recommended new and future technology, improving organizational effectiveness
• Offered mentorship and guidance to interns to help grow professional skills through Enablement programs
• Organizer of Snowflake Internal Training sessions for New joiners

• Analyzed user needs and software requirements to determine feasibility of design within time and cost constraints
• Development of migration framework from SQL server to Snowflake by creating python scripts for Incremental load and Full load
• Worked on creating Tasks in Attunity for data loading and Scheduling jobs in Airflow for data loading
• Experience in developing Python scripts to achieve ETL process equivalent to SSIS packages
• Development of views/custom SQLs for Tableau reports
• Created well-designed and reusable scripts
• Lead team of four developers and two testers from Offshore

• Worked on the Analysis, Design and Development in Abinitio tool
• Conversion of ETL process from Abinitio to Apache Pyspark and building scripts to bring the history load from Teradata to Redshift
• Successful go-live of the five major ETL process using Spark

• Responsible for identifying and resolving production issues like missing file, Teradata load failure, graph failure due to transformation or data issue
• Supported SIT and UAT and post production activities
• Trainer on Ab-Initio sessions for new joiners
• Improved processes and created efficiencies using various initiatives
• Responded proactively to meet customer needs and resolve problems
• Tested programs or databases, corrected errors and made necessary modifications
• Reviewed designs, code and and documentation to check quality
• Verified accuracy and quality of the data in Teradata Database