Ashwini G A

Project Description :

Responsibilities:

• Defined and enhanced internal processes through data mining, database changes and SQL queries.
• Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
• Participated in regular code reviews for consistent quality assurance across the team''s work output.
• Enhanced data visualization capabilities by designing and implementing interactive Tableau dashboards.
• Developed pipeline in Airflows to schedule Sql stored procedures, spark jobs, hive jobs and shell scripts.
• Enhanced application functionality by developing custom stored procedures, triggers, and functions using SQL or PL/SQL as required.
• Optimized deployments by automating repetitive tasks using scripting languages like Python or Bash for increased operational efficiency.
• Reduced project delivery time by efficiently managing tasks using JIRA, prioritizing urgent issues, and maintaining open communication with the team.
• Improved code maintainability by adhering to coding standards and performing regular refactoring exercises.
• Enhanced software quality by implementing Agile methodologies and participating in daily stand-up meetings.

Project Description :

• Project ADVAIT mainly deals with transforming data received from various sources in meaningful business insights.
• Data received from various sources in various forms is loaded in RDBMS, moved to HDP following which transformations on data is performed and loaded into Hive tables and exported so that it is further used to generate reports and display on dashboard to obtain meaningful business insights for stakeholders.

Responsibilities :

• Prepared Sqoop jobs to import data to HDFS and export from HDFS.
• Processing of jobs using Spark, Python and Pyspark.
• Extensively worked on partitioning tables, bucketing, joins and DDL statements in Hive.
• Involved in writing shell scripts in Linux for job execution.
• Developed complex SQL queries on DB2 to generate reports.
• Developed end-to-end Oozie workflow to facilitate job flows.
• Documented the functionalities developed in the application.
• Handled development and support operations on the existing systems.

Project Description :

• Marsh is a global professional services firm with operations in insurance broking and risk management.
• This project mainly deals with extracting, transforming and loading data into tables by mapping them using Informatica and then generating reports using Business objects by writing queries and using Business objects tool.

Responsibilities :

• Involved in writing SQL scripts for generating reports from BO tool.
• Actively worked on creating and managing DDL and DML statements in SQL using teradata.
• Worked with the Business Objects (BO) tool to create, share, and store reports by developing pipelines and mapping queries.