Ranjan Rashmi Sahoo
Associate Principal - Data Architect
Bengaluru,Karnataka
Summary
Accomplished Data Scientist, ML Engineer, Data Engineer and Data Architect with extensive experience in developing data-driven solutions and creating scalable data platforms. Expertise in advanced analytics, machine learning algorithms, and cloud technologies to derive actionable insights. Proven track record in designing comprehensive data architectures, optimizing workflows, and implementing robust machine learning models while serving as a technical SME for Microsoft technology migrations. Strong collaborator with cross-functional teams, adept at leveraging data strategies to enhance business performance and providing consultative guidance on cloud-based database administration.
Overview
21
21
years of professional experience
1
1
Certificate
8
8
years of post-secondary education
Work History
Associate Principal - Cloud Data Engineer
LTIM
01.2022 - Current
- As an Associate Data and ML Engineer engaged for a Taxation service rollover prediction project
- My key responsibilities include designing and developing ADF pipelines for seamless data integration from Azure SQL Database sources, leveraging Azure Databricks for complex data transformations, and feature engineering of rollover attributes and building robust machine learning models using those attributes
- Utilizing the MLFlow modules end to end CI/CD experiment tracking, model management, and deployment
- Tools Used: PySpark, SparkSQL, MLFlow, Azure SQL, Databricks, Delta lakehouse, Spark Jobs, ADF, Synapse Analytics
Azure Data Architect
Winwire Technologies Ltd.
Bangalore
01.2020 - 01.2022
- Employed Azure SQL Platform-as-a-Service (PaaS) products to migrate on premise SQL databases and reduced Infrastructure cost by 30%
- Designed API based BI Solution architecture for modern data warehouse of a logistics domain multi-tenant application
- Migrated numerous legacy systems (Dbase) to SQL database infrastructure, reducing costs and enhancing efficiency of all computing tasks
- Led team of 12 developers, technical solution guidance to developers, Proof of Concepts
- Presented and documented the design and deployment documents
CLOUD ARCHITECT ASSOCIATE MANAGER
ACCENTURE SOLUTIONS PVT. LTD.
01.2016 - 01.2020
- Lead a Team of 30 L2 & L3 SQL DBAs, supporting 24/7 for a global Pharma based company
- Driving major infrastructure provisioning projects for new applications with the help of multiple technology towers and helping them to move to production through the MTP process
- Received many appreciation for before time delivery, managing complexity and smooth coordination between towers
- Responsible for team management, escalations handling, project execution, major client communications
- Automating the daily, weekly, monthly server health dashboard for all regions
- Driving the remediation activity like monitoring, backup, BBDA agent configuration, patching
- Installation and Configuration of SQL 2016 and Multi node, multi-subnet SQL AlwaysOn Driving end to end DR activity for major hyper-care applications with the help of multiple technical towers
- Leading the team in problem management area and reducing the incident count by 30 % in 8 months
- Managing customer escalations, preparing RCA documents for major incidents and follow-up till its closure
- Created monitoring scripts to alert for production issues
- Created automation scripts for DB growth trend reports
- Training the team on SQL Azure, MongoDB in Linux platform, taking transition of 200 MongoDB instances adding business to company
- Have given 50+ hours in training to team in last 10 months
- Environment: Azure SQL, SQL 2019/2016/2014/2012, PowerShell, MS diagnostic tools, MongoDB and many more
- Team Size: 30
SENIOR MIDDLEWARE SPECIALIST
NETWORK SOLUTIONS AN IBM COMPANY
01.2011 - 01.2016
- Lead a Team of 6+ SQL DBAs, supporting 24/7 for 20+ Indian customers in banking and retail domain
- Responsible for DB management, monitoring, troubleshooting
- Daily Health check and weekly and monthly trend reporting
- Performed installation of SQL Enterprise 2008/2012 on Windows 2008/2012 servers on Enterprise systems of clustered and standalone servers in enterprise Data Centers
- Failover cluster testing and resolution, monitoring and backup reporting setup with Tivoli ITCAM and backup teams
- Configured Clustering, Mirroring and Log shipping as well as basic account management and troubleshooting with connectivity, security and firewall issues
- Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor
- Configured DB mail, SQL mail for automation of log shipping alerts and many other severity alerts in DC and DR
- Created monitoring scripts to alert for production issues
- Created automation scripts for DB growth trend reports
- Training team members for SQL 2012 advanced features, performance tuning, troubleshooting, new features of 2014
- Environment: SQL 2014/2012/2008/2005, T-SQL, PowerShell, TSM, Tivoli and ITCAM
- Team Size: 8
L4 ESCALATION SUPPORT ENGINEER
ATLAS SYSTEMS PVT. LTD.
01.2009 - 01.2011
- Handling escalation issues from L2/L3 DBAs, analyzing and suggesting solutions, avoiding MS involvement
- Have prepared standard installation/configuration checklist for SQL clustering, mirroring, log shipping and upgrade for SQL 2005 and SQL 2008
- Scheduled Full, Differential and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard
- Setup automated DB refresh DTS packages for Dev and QA environments
- Implemented DR solution at the remote site for the production databases using bi-directional Log Shipping
- Setup script based Database Maintenance Plans to reorganize indexes, reindexing and update the index statistics on the production databases to avoid huge log generation
- Used DBCC commands to troubleshoot issues related to database consistency
- Used Index tuning wizard to redesign and created the indexes for better performance
- Environment: SQL 2008/2005, Remedy, and LightSpeed
- Team Size: 4
SENIOR INFRASTRUCTURE MANAGEMENT ANALYST
AFFILIATED COMPUTER SERVICES LTD
Bangalore
01.2007 - 01.2009
- Supporting around 20+ global MNC clients, 1500 SQL servers as shared DBA
- Installation, Configuration SQL server 2000/2005 and SQL 2008 and upgrading latest service patch and hot fixes
- Setting up and maintaining SQL cluster, mirroring and replication
- Adhering to Incident, Problem and change management process as per ITIL Tiger Team activities for one critical client
- Completed four DR activity for two clients
- SQL server monitoring rule setup and its standardization by NetIQ and MOM on most of clients
- Daily DBA monitoring automation scripting and its implementation, monthly various DBA reporting scripting
- Following various standard checklists/templates for new implementations like clustering, upgrading, new installations, user creations/updates
- ITIL training, communication training, skill soft based SQL trainings, backup restore tools like TSM/TDP, VERITAS NetBackup, Backup exec, SRDF, BCV techniques, Monitoring tolls like NetIQ, MOM, Net Cool, peregrine Service Center, Remedy etc
SENIOR SOFTWARE ENGINEER
UNISYS GLOBAL SERVICES
Bangalore
01.2007 - 12.2007
- Evaluated the performance, scalability, security, administration, availability, and cost of EnterpriseDB database as compared to Oracle
- Conducted performance tuning and comparison tests for Oracle, EnterpriseDB, and PostgreSQL on a DELL 1980 Server with SUSE Enterprise 10
- Led successful migration of database from Oracle to EnterpriseDB, ensuring smooth data transfer and business logic compatibility
- Developed comprehensive documentation outlining the feature differences between Oracle and EnterpriseDB
- Executed performance testing and feature analysis to facilitate informed decision-making, creating detailed technical documentation
SENIOR EXECUTIVE DBA
MPHASIS BFL PVT LTD.
Bangalore
01.2004 - 01.2007
- Worked as a DBA, handling backend issues, backups, restores, and server maintenance
- Managed the database architecture for the transport application
- Responsible for database backup, recovery, security, and user access
- Advised users, resolved data conflicts, and ensured data integrity, including security and privacy
- Managed database clusters
- Skilled in cluster management, monitoring, installation, and configuration
- Developed backend stored procedures to meet complex user needs not supported by the front-end
- Involved in MPHASIS's ERP application for call centers
- Managed database in active-passive cluster mode and developed backup scripts for 10 databases
- Collaborated on report generation and query performance tuning
- Handled backup recovery, daily health checks, and performance tuning as part of the DBA team
Education
Master of Science - Computers
National Institute of Technology
Rourkela, Odisha 08.2002 - 08.2004
Bachelor of Engineering - Computers
Bhadrak Institute of Engineering And Technology
Bhadrak, Odisha 07.1997 - 07.2001
Bachelor of Science - Science
Rajendra College
Bolangir, Odisha 07.1993 - 07.1995
10th - Science
P. R. Govt. High School
Balangir, Odisha 07.1993 - 07.1993
Skills
- Advanced SQL Queries
- ERwin
- Azure
- Analytics
- Azure Synapse
- Azure Databricks
- Azure Data Factory
- Data Modeling
- Data Warehousing
- ETL Development
- Data Engineering
- Python
- Python Data Analytics
- Machine Learning
- Data Analytics
Certification
- Microsoft Certified Data Engineer Associate, 06/30/23
- Deep Learning Specialization
- Prompt Engineering for ChatGPT
- Machine Learning
- Improving Deep Neural Networks: Hyperparameter Tuning, Regularization and Optimization
- Sequence Models
- Convolutional Neural Networks
- Neural Networks and Deep Learning
- Microsoft Azure Databricks for Data Engineering
- Structuring Machine Learning Projects
Timeline
Associate Principal - Cloud Data Engineer
LTIM
01.2022 - Current
Azure Data Architect
Winwire Technologies Ltd.
01.2020 - 01.2022
CLOUD ARCHITECT ASSOCIATE MANAGER
ACCENTURE SOLUTIONS PVT. LTD.
01.2016 - 01.2020
SENIOR MIDDLEWARE SPECIALIST
NETWORK SOLUTIONS AN IBM COMPANY
01.2011 - 01.2016
L4 ESCALATION SUPPORT ENGINEER
ATLAS SYSTEMS PVT. LTD.
01.2009 - 01.2011
SENIOR INFRASTRUCTURE MANAGEMENT ANALYST
AFFILIATED COMPUTER SERVICES LTD
01.2007 - 01.2009
SENIOR SOFTWARE ENGINEER
UNISYS GLOBAL SERVICES
01.2007 - 12.2007
SENIOR EXECUTIVE DBA
MPHASIS BFL PVT LTD.
01.2004 - 01.2007
Master of Science - Computers
National Institute of Technology
08.2002 - 08.2004
Bachelor of Engineering - Computers
Bhadrak Institute of Engineering And Technology
07.1997 - 07.2001
Bachelor of Science - Science
Rajendra College
07.1993 - 07.1995
10th - Science
P. R. Govt. High School
07.1993 - 07.1993
Languages
- English
- Hindi
- Oriya
- Bengali
Projects
Study of Dynamic Load Balancing Algorithms for Switchbased Network of Workstations, A switch based Network of Workstations is taken for comparing various load balancing algorithms.
References
References available upon request.
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Personal Information
Total Experience: 20 Years 0 Month
Work Preference
Work Type
Full TimeContract WorkGig WorkWork Location
On-SiteRemoteHybridImportant To Me
Work from home optionFlexible work hoursCompany CultureWork-life balanceCareer advancementPersonal development programsHealthcare benefitsLanguages
- English
- Hindi
- Oriya
- Bengali
Quote
Judge a man by his questions rather than his answers.
Voltaire
Projects
Study of Dynamic Load Balancing Algorithms for Switchbased Network of Workstations, A switch based Network of Workstations is taken for comparing various load balancing algorithms.
Languages
Odia
Native language
English
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2
Bengali
Intermediate (B1)
B1
References
References available upon request.
Similar Profiles
Feraz Ahmad FakhriFeraz Ahmad Fakhri
Senior Network Engineer at LTIMSenior Network Engineer at LTIM
Sandhyashree ShettySandhyashree Shetty
QA/UAT Test Lead at LTIMQA/UAT Test Lead at LTIM
Anam KhanAnam Khan
Senior Cloud Engineer at LTIMSenior Cloud Engineer at LTIM