Rakshita N Email & Phone Number

United States

Little Elm, Tx, Us

Irving, Texas, United States

Developed and maintained complex data pipelines using Snowflake to support business intelligence and data analytics. Utilized Python and SQL to create automated data validation scripts, improving data accuracy and consistency. Conducted performance tuning and query optimization, reducing average query runtime by 30%, reducing the customer checkout time by 15s, improving customer satisfaction, and gaining higher sales volume. Expert in migration to modern platforms like Snowflake ensures business continuity and provides advanced analytical capabilities, enhancing overall data management. Worked closely with security teams by providing them the logs concerning firewalls, and VPC's and setting up rules in GCP for vulnerability. Worked on batch performance through data processing using Perl, Shell scripting, and Unix. Automated deployment processes using CI/CD pipelines with AWS services like CodePipeline, CodeBuild, and CodeDeploy. Implementing real-time data processing and transformation logic using Snowflake streams, tasks, and other native features. Debugging and optimizing existing Python applications. Implemented FHIR (Fast Healthcare Interoperability Resources) standards to enable seamless data exchange between disparate healthcare systems, enhancing interoperability and improving the accuracy and accessibility of patient data across platforms. Build data pipelines in airflow in GCP for ETL-related jobs using different airflow operators. Parse and validate JSON and XML data using Python libraries (e.g., JSON, XML.etree.ElementTree). Creating and maintaining shell scripts to automate system tasks and manage server operations. Designed various Jenkins jobs to continuously integrate the processes and executed CI/CD pipelines using Jenkins. Managed the transfer of data from SQL Server to Azure, then to Snowflake’s internal data warehouse by using the copy command. Created UNIX reports & flat files using SQL and UNIX.

Hyderabad, Telangana, India

Collaborated on the design and development of ETL processes, leveraging AWS Glue for orchestrating data workflows and SQL for complex data transformations, resulting in optimized data loads into Amazon Redshift for large-scale analytics. Developed 25 Python scripts to automate data validation and transformation tasks, ensuring data quality and consistency. Collaborated with senior data engineers to optimize ETL workflows, reducing data processing time. Implemented data extraction and ingestion processes from AWS S3 to Redshift, supporting business intelligence and reporting needs. Experience in moving data between GCP and Azure using Azure Data Factory. Expertise in writing dynamic SQL, stored procedures, functions, and views. Documented ETL processes, data mappings, and transformation logic for future reference and maintenance. Participated in daily stand-up meetings to report progress, discuss challenges, and plan tasks. Automated data processing and transformation tasks through scripting. Used Git for version control of data processing scripts, configurations, and other project-related files. Utilized AWS Lambda to automate and schedule ETL jobs, improving process efficiency. Performed data cleaning and enrichment to enhance the quality and usability of data for analytics. Supported data warehouse maintenance by updating tables and views, ensuring data accuracy and availability. Assisted in the integration of third-party data sources into the data warehouse, broadening data accessibility. Conducted root cause analysis of ETL failures and implemented corrective actions to prevent recurrence. Document scripts and processes to ensure maintainability and ease of use for other team members. Developed unit tests for ETL code to ensure reliability and accuracy of data processing. Used Git version control to manage the source code integrated Git with Jenkins to support build automation and‚ integrated with Jira to monitor the commits.

Hyderabad, Telangana, India

Conducted data extraction and validation tasks using SQL to support data analysis and reporting functions. Assisted in the development and maintenance of ETL pipelines using AWS services like Lambda and RDS. Utilized SQL to write queries for data extraction, transformation, and loading into data warehouses. Created interactive dashboards using Tableau to visualize key business metrics and provide insights to stakeholders. Worked closely with data engineers to gather data requirements and implement solutions that met business needs. Participated in performance tuning of SQL queries to enhance data retrieval times and overall system efficiency. Assisted in the migration of on-premises data to AWS, ensuring data integrity and minimal downtime. Developed and maintained documentation for ETL processes, data workflows, and best practices. Collaborated with business stakeholders to define key performance indicators (KPIs) and ensure the dashboard met their needs. Implemented data security measures, including access controls and encryption, to protect sensitive information. Provided training and support to end-users on how to utilize the Tableau dashboard effectively.

Master Of Science - Ms, Information Systems - Business Analytics, 3.64

Bachelor Of Technology - Btech, Computer Software Engineering, A

Activities and Societies: Volunteered in student-based NGO ‘Streetcause’ , basketball, dancing.