Sonam Patkar
Principal Software Engineer
Perth
Summary
Principal Software Engineer with 13+ years of experience in data engineering, specializing in data migration and database systems. Skilled in leading high-performing teams, driving data architecture and modeling, and ensuring code quality through systematic reviews. Brings a balanced mix of technical depth and collaborative leadership across complex data initiatives.
Overview
13
13
years of professional experience
8
8
years of post-secondary education
1
1
Certification
Work History
Principal Software Engineer
Fidelity Investments
03.2022 - Current
- Led the migration from Oracle to Snowflake, replacing legacy systems with faster, cost-effective solutions.
- Delivered the Marketing Media Mix project, showing marketing data in dashboards to help with better planning and decisions.
- Worked with external teams to understand requirements and share data as needed.
- Mentored junior engineers to strengthen their technical skills and improve overall team efficiency.
- Designed and built Snowflake pipelines and workflows, making sure data flows were smooth and reliable.
- Reviewed code, supported team members, and followed best coding practices.
- Worked with business and marketing teams to turn their needs into working data solutions.
- Took care of data security, governance, and cost control in Snowflake.
- Acted as a technical lead, making sure projects were delivered on time and with quality.
- Increased customer satisfaction rates through diligent collaboration with cross-functional teams on feature development and bug resolution.
Technical Lead
Mindtree
03.2021 - 03.2022
- Created pipeline to deploy the code into different platforms.
- Writing complex procedures in JavaScript to manage platform.
- Responsible for designing and developing complex ETL processes, prepare unit test, QA and deployment using CICD.
- Contributed to development and maintenance of Snowflake ADMINTOOL feature which includes creating database, schema, RBAC to both schema and database, cloning database, creating role (database/schema/environment level), dropping role, dropping schema, dropping database, etc.
- Customized and Integrated pipeline to perform Build, Deployment and Release using SNOWCHANGE
Lead Software Engineer
Fidelity Investments
12.2017 - 03.2021
- Campaign DB (Oracle) migrated into Cloud/Snowflake.
- DevOps team is responsible for managing Fidelity Personal Investment data.
- Build Complex procedures and Shell scripts as part of new feeds in the system and supporting existing daily/weekly/monthly batches.
- Build tested and deployed scalable, high available and modular software products using PL/SQL, Shell scripts executed from Jenkins to move from one environment to another.
- Responsible for design and maintenance of the GIT repositories.
- Independently handled 'Attunity Visibility' installation.
- Analyze, design, develop, implement, test, and evaluate automated system and application monitoring tools related to engineering function requirements for associated system.
- Used Nexus repository to upload the build artefacts after a successful build.
- Continuous integration and continuous delivery of changing query workloads.
- Reduce technical dept of code using SonarQube.
- Moved to Agile wave 2
IT Analyst
TATA Consultancy Services
05.2016 - 11.2017
- Solas Nupas Migration: Decommission of these two applications, which feed policy related data to Data warehouse, after migration all policies will come by Paxus.
- DW Changes/Implementations: Taking home, motor policy related data from different applications in data warehouse and after the transformation of data generating the various data reports by Cognos.
- Independently handling whole migration.
- Monitoring of daily batches after migration.
- Handling related issues.
- Gather requirements and design of data warehouse and data mart entities.
- Developed an automated tool to extract the data into oracle from UNIX box, then transform it and load into UK pricing mart.
- Provide complex data for reporting using multiple data providers, user-defined objects, aggregate aware objects.
- Created UNIX shell scripts to extract data from various sources such as Oracle, Mainframe system.
- Design and develop packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
- Conduct code walkthroughs and review peer code and documentation.
- Build efficient packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
- Created system for capturing, reporting, and correcting error data.
- Work with DBAs, and systems support personnel in elevating and automating successful code to production.
- Provide on-call support to production system to resolve any issues.
Software Engineer
TATA Consultancy Services
12.2012 - 04.2016
- Alternate Technology Migration.
- Moved towards from centralized system to decentralize.
- Conversion & migration of data from one platform to another platform. Realign UPSS Circle’s on different Zone.
- Created Audit report after successfully conversion of Zone data from one platform to another.
- Build a tool that automatically import the whole objects from one platform and deploy into another platform.
- Created PL/SQL, SQL scripts for data extraction, cleansing, transformation and load across databases. Data synchronize across databases.
- Successfully migrated Alternate Technology for all zones in which data moved from Oracle 11g to Exadata.
Education
B. Tech - I.T
Truba Institute of Engineering & Information Technology
01.2008 - 01.2012
Class XII - undefined
St. Thomas Convent & High School
01.2006 - 01.2008
Class X - undefined
St. Thomas Convent & High School
01.2004 - 01.2006
Skills
SQL
PLSQL
Unix
Shell scripting
AWS
Python
Snowflake
Oracle
Data Warehousing
PL/SQL Developer
Oral and written communications
Customer support
Client interaction
Disclaimer
I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.
Skills Profile
- Telecom, Insurance, Finance, SQL/PLSQL, Unix, shell scripting, AWS (S3/Lambda/EC2), Python, Snowflake, Oracle 8i, 9i, 10G, 11G, 12C, Exadata, Data Warehousing, 12c ODI, PL/SQL Developer, SQL Developer, SQL
- Loader, Toad, Informatica, DataStage, SAP BODS, Cognos, Jenkins, SonarQube, Nexus, Control-M, Putty, Attunity, Attunity Visibility, Agile, DevOps, MS Office, Open Office, Microsoft Outlook
Certification
Oracle OCA
Timeline
Principal Software Engineer
Fidelity Investments
03.2022 - Current
Technical Lead
Mindtree
03.2021 - 03.2022
Lead Software Engineer
Fidelity Investments
12.2017 - 03.2021
IT Analyst
TATA Consultancy Services
05.2016 - 11.2017
Software Engineer
TATA Consultancy Services
12.2012 - 04.2016
B. Tech - I.T
Truba Institute of Engineering & Information Technology
01.2008 - 01.2012
Class XII - undefined
St. Thomas Convent & High School
01.2006 - 01.2008
Class X - undefined
St. Thomas Convent & High School
01.2004 - 01.2006
Similar Profiles
MICHAEL O'BRIENMICHAEL O'BRIEN
FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)FIDELITY CLIENT SERVICES REPRESENTATIVE at Fidelity Investments - Fidelity Institutional (Fidelity Advisor Funds)
Randolph Roark IIRandolph Roark II
Workplace Planning Consultant at Fidelity InvestmentsWorkplace Planning Consultant at Fidelity Investments
Arturo CastilloArturo Castillo
Workplace Planning Associate at Fidelity InvestmentsWorkplace Planning Associate at Fidelity Investments
SHASHI SHEKAR N SSHASHI SHEKAR N S
Senior Executive at CBRE South Asia Pvt Ltd. (Client : Fidelity Investments)Senior Executive at CBRE South Asia Pvt Ltd. (Client : Fidelity Investments)
CASSANDRA HERBERT JENOSCASSANDRA HERBERT JENOS
Commercial Staff/ Barista at Curtin UniversityCommercial Staff/ Barista at Curtin University