Your Name

• Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.
• Loading data into snowflake tables from the internal stage using snowsql.
• Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.
• Used FLATTEN table function to produce a lateral view of VARIANT, OBJECT, and ARRAY column.
• Used SNOW PIPE for continuous data ingestion from the S3 bucket.
• Developed snowflake procedures for executing branching and looping
• Created clone objects to maintain zero-copy cloning.
• Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake
• Experience with AWS cloud services: EC2, S3, EMR, RDS, Athena, and Glue
• Experience with Azure cloud services: AWS Object & BLOB storage, Containers, Virtual Machines
• Cloned Production data for code modifications and testing
• Perform troubleshooting analysis and resolution of critical issues•
• Designed and developed real time data and streaming applications using python and snowflake.
  • Developed ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake Snow SQL
  • Collaborated with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies.
  • Led a team of developers with deep experience in distributed microservices, machine learning and full stack systems.
  • Performed unit tests and conducted code reviews with other team members to make sure the code is rigorously designed, elegantly coded, and effectively tuned for performance.
  • Actively engaged with technical leads and architects to analyze and guide key technical decisions including Technology platform, Application and Database design, Infrastructure components, SLAS, and Performance metrics.
  • Developed and executed technical roadmap for managing technical debt.
  • Worked across organizational boundaries partnering with Business leads and functional product managers.
  • Collaborated with product managers to anticipate their needs to plan and deliver application and technical roadmaps.
  • Mentored and coached junior team members in using industry standard software engineering methodology and best practices.
  • Followed best practices for code development and documented as part of developers COE.

• Designed and developed ETL packages to build highly complex workflows of data flow to process claims and submit to systems driven by regulatory and compliance purpose.
• Analyze business requirements and various data sources to design and develop SQL Server Integration Service (SSIS) packages.
• Development of ETL Packages for transformations, validations, and derivations. •
• Development of ETL Packages to generate client specific Reports in various file formats including fixed width format, delimited, flat and XML files.
• Development of ETL Packages to process one time and nightly updates to various tables used by downstream applications and processes.
• Increased performance and decreased runtimes of key ETL Processes by converting to PowerShell.
• Modified existing database design to improve system performance and reliability.
• Oversaw change management process to provide database code change guidance to team members.
• Worked extensively on the performance of daily jobs and thus recreated the entire loading process of loading data to achieve performance gain of 40% across different file formats.
• Created TSQL jobs to run at different schedules including Nightly, Monthly and Quarterly. Created and updated stored procedures, materialized views, triggers, and functions.
• Wrote unit and integration tests with the intent of reducing the issues identified during testing and improving the quality of the user stories.
• Collaborated with business and product teams to understand requirements and design detailed engineering solutions.
• Mentored and coached junior team members in using industry standard software engineering methodology and best practices.
• Followed best practices for code development and documented as part of developers COE.

• Analyzed user requirements, business processes, system procedures, and problems to automate processing or improve Existing computer systems, create functional/technical specifications by collaborating with end customers.
• Performed cross platform data extraction and migration (MSSQL, MySQL and Oracle)
• Wrote detailed description of user needs, program functions and steps required to develop or modify complex programs.
• Created detailed design documents and programming specifications.
• Plan and prepare technical reports.
• Extract, Evaluate and Migrate information gathered from multiple sources/applications.
• Collaborated with the Subject Matter Experts to discuss the business process, understand the system to extract the data from the system.
• Created technical specification documents, including data flows, data mappings and review with the team and other stakeholders on the project.
• Created configuration files for scheduling SSIS packages as SQL Agent jobs.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Created several test scripts documentations for user acceptance testing (UAT).
• Conduct code walkthroughs, and review peer code and managed documentation of standards, best practices, and ETL procedures.
• Analyze business requirements and various data sources to design and develop SQL Server Integration Service (SSIS) packages.
• Performing cleaning operations on the data to create pipe delimited text files.
• Configured SQL Mail agent for sending automated alerts/emails.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.