Gowtam Kumar
Hyderabad
Summary
Around 11 Years of Total IT experience Around 5 Years of Oracle PLSQL Developer experience Around 3 Years of Azure and Pyspark Data Engineering experience Around 3 years of Data Analyst experience
Overview
12
12
years of professional experience
Work History
Clinical Software Private Limited(Officially Known as Signanthealth)
Hyderabad
02.2023 - Current
- Collaborated with customers and product manager to prioritize and validate requirements.
- Coordinated weekly estimation meetings, providing high-level estimates for backlog items.
- Developed scalable ETL pipelines utilizing ADF, Delta Lake, and Databricks technologies.
- Implemented Bronze-Silver-Gold architecture with schema evolution using Delta Tables.
- Established data governance policies ensuring regulatory compliance and data privacy.
- Integrated Unity Catalog to secure access to data assets across Databricks workspaces.
- Automated data quality checks and error handling processes to enhance dataset integrity.
- Optimized financial data ingestion pipelines, achieving 40% reduction in execution time.
Senior Data Engineer
Signant Health
Hyderabad
09.2022 - 02.2023
- Worked with customers and product manager to prioritize and validate requirements.
- Completed plans for long term goals using Microsoft Project.
- Coordinated the work efforts of 8 person team for various projects. Helped team complete tasks successfully and on-time and resolved obstacles encountered by team members.
- Coordinated and participated in weekly estimation meetings to provide high-level estimates (Story Points) for backlog items.
- Working on DB Team Lead Activities.
- Built and deployed PySpark data quality checks for standardized curated layer validation.
- Delivered business-critical reporting data in Delta format to Azure Synapse for downstream use.
- Conducted ADF activity-level logging integrated with Log Analytics and Azure Monitor.
- Participated in establishing data governance workflows, including masking, classification, and lineage with Unity Catalog and Purview.
- Reduced batch processing duration by 30% through optimization of Spark cores, partitions, and I/O operations.
- Implemented CDC logic using Delta MERGE strategy while managing schema drift scenarios.
Senior Software Lead
Persistent Systems Limited
Hyderabad
09.2021 - 06.2022
- Collaborated with customers and product manager to prioritize and validate requirements.
- Coordinated efforts of 8-person team, ensuring timely completion of tasks and resolution of obstacles encountered.
- Participated in weekly estimation meetings to provide high-level estimates for backlog items using Story Points.
- Created PL/SQL scripts for data extraction from operational database into flat text files using UTL_FILE package.
- Developed indexes on tables to enhance database retrieval performance.
- Utilized Bulk Collections to minimize context switching between SQL and PL/SQL engines for improved performance.
- Partitioned fact tables and materialized views to optimize database efficiency.
- Employed advanced PL/SQL features such as Records, Tables, and Dynamic SQL for enhanced functionality.
Senior PLSQL Developer (Health Care Domain)
Capgemini India Private Limited
Hyderabad
10.2018 - 09.2021
- Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Work with the DW Development team to implement data strategies, build data flows and develop conceptual data models.
- Work with the development team to implement data strategies, build data flows and develop data models.
- Work with development, application and other data architects to provide an overall solution approach.
- Provides technical assistance and mentoring to staff for developing conceptual and logical database designs and the physical database.
- Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the files and loading them into the base tables.
- Involved in the continuous enhancements and fixing of production problems.
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Developed PL/SQL triggers and master tables for automatic creation of primary keys.
- Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Created indexes on the tables for faster retrieval of the data to enhance database performance.
- Involved in data loading using PL/SQL and SQL
- Loader calling UNIX scripts to download and manipulate files.
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
- Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
- Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL
- Plus.
- Partitioned the fact tables and materialized views to enhance the performance.
- Extensively used bulk collection in PL/SQL objects for improving the performing.
- Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
- Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
- Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
- Extensively involved in using Performance Tuning.
PLSQL Developer(Core Banking Domain)
3i-Infotech Private Limited
Hyderabad
09.2016 - 10.2018
- Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
- Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
- Involved in creating UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
- Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
- Worked on SQL
- Loader to load data from flat files obtained from various facilities every day.
- Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
- Used principles of Normalization to improve the performance.
- Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
- Involved in the continuous enhancements and fixing of production problems.
- Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Data Analyst (Clinical Trials Domain)
Clinical Software Private Limited(Officially Known as Signanthealth)
Hyderabad
07.2013 - 08.2016
- Analyzed clinical data related to patients, physicians, prescriptions, hospitals, campaigns, insurance, and claims.
- Used SQL to extract and transform datasets for patient diagnosis tracking and physician mapping.
- Generated Excel-based dashboards and pivot reports for pharmaceutical forecasting and campaign analytics.
- Cleaned and validated raw files using Excel (VLOOKUP, conditional formatting, IF/COUNTIF, and pivot tables).
- Provided input to BI and marketing teams to track user conversion and business performance metrics.
- Collaborated with data engineers and QA teams to ensure accuracy of reporting layer inputs.
Education
Master of Computer Applications -
Vignan Institute of Information Technology
Vishakhapatnam01.2012
Bachelor of Science (B.Sc.) -
Govt Degree College
Saluru01.2009
Intermediate: M.P.C -
Vasavi Junior College
Saluru01.2006
S.S.C -
Govt High School
Saluru01.2004
Skills
- Oracle SQL/PLSQL
- Azure Data Factory
- Pyspark
- Azure Data Bricks
- Unix Shell Scripting
- Query Optimization
- ETL/ELT
- Data modelling
- Data base design
- Building Migration Pipelines
- Hive
Timeline
Clinical Software Private Limited(Officially Known as Signanthealth)
02.2023 - Current
Senior Data Engineer
Signant Health
09.2022 - 02.2023
Senior Software Lead
Persistent Systems Limited
09.2021 - 06.2022
Senior PLSQL Developer (Health Care Domain)
Capgemini India Private Limited
10.2018 - 09.2021
PLSQL Developer(Core Banking Domain)
3i-Infotech Private Limited
09.2016 - 10.2018
Data Analyst (Clinical Trials Domain)
Clinical Software Private Limited(Officially Known as Signanthealth)
07.2013 - 08.2016
Master of Computer Applications -
Vignan Institute of Information Technology
Bachelor of Science (B.Sc.) -
Govt Degree College
Intermediate: M.P.C -
Vasavi Junior College
S.S.C -
Govt High School
Similar Profiles
Vasuda KrishnamurthyVasuda Krishnamurthy
Financial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private LimitedFinancial Analyst at EMC SOFTWARE AND SERVICES INDIA PRIVATE LIMITED/Dell, Technologies India Private Limited
Mohan KumarMohan Kumar
HR at Imarticus Learning Private Limited, Imarticus Learning, South India, Josh Software Private LimitedHR at Imarticus Learning Private Limited, Imarticus Learning, South India, Josh Software Private Limited
Rakshith KattaRakshith Katta
Director, Regulatory Affairs at SMO Clinical Research Private LimitedDirector, Regulatory Affairs at SMO Clinical Research Private Limited
Ismail MohammedIsmail Mohammed
Data Specialist at S&P GlobalData Specialist at S&P Global
Bharath Kumar KondetiBharath Kumar Kondeti
Senior Drupal Developer at SpecbeeSenior Drupal Developer at Specbee