AMRITA MOHANTY
Bengaluru
Summary
Results-oriented Database Analyst Specialist with over 14 years of experience at Fidelity Information Services. Proficient in database administration and SQL development, guaranteeing data integrity and peak performance. Demonstrated expertise in designing scalable data pipelines and automating processes, significantly improving operational efficiency.
Overview
14
14
years of professional experience
Work History
Database Analyst Specialist
FIDELITY INFORMATION SERVICES
Bengaluru
06.2016 - Current
- Analyzed complex databases to identify trends, improve data integrity, developed and maintained database.
- Collaborated with cross-functional teams to support data-driven decision-making.
- Designed scalable data pipelines to support analytics and reporting needs.
- Administered Oracle databases, ensuring optimal performance and reliability.
- Managed database backups and recovery processes to safeguard data integrity.
- Scheduled jobs for maintenance activities like index rebuilding.
- Developed scripts for automation of tasks with PL and SQL or shell scripting languages.
- Created and maintained database objects such as tables, indexes, views, triggers, stored procedures.
Database Engineer
CAPGEMINI INDIA
Bengaluru
03.2015 - 06.2016
- Designed and implemented database structures for efficient data storage and retrieval.
- Developed and maintained SSRS reports for diverse business applications.
- Developed ETL processes using SQL Server Integration Services.
Database Engineer
INFINITE COMPUTER SOLUTIONS
Bengaluru
06.2014 - 03.2015
- Developed complex SQL queries for data extraction and analysis.
- Designed and maintained database structures for optimal performance.
- Collaborated with cross-functional teams to gather data requirements.
Database Engineer
SM NETSERV TECHNOLOGIES PVT LTD
Bangalore
12.2013 - 06.2014
- Conducted data validation and integrity checks on database entries.
- Automated routine reporting processes using SQL scripting techniques.
- Developed complex SQL queries for data extraction and analysis.
Database Administrator
IL & FS TECHNOLOGIES LTD
GURGAON
02.2011 - 12.2013
- Administered SQL Server databases to ensure optimal performance and reliability.
- Created tables, views, functions, stored procedures and other database objects.
- Implemented replication between multiple servers to ensure high availability of the system.
- Troubleshot complex SQL queries to identify problems or potential improvements in performance.
Education
Bachelor of Technology - Computer Science
BIJU PATTNAIK UNIVERSITY OF TECHNOLOGY
ODISHA06-2010
Skills
- Database administration and PL/SQL development
- Python programming
- Data migration
- Database design
- Problem-solving abilities
- Data analysis and ETL processes
- Oracle database management
- Data integrity and quality assurance
- Linux administration
- Azure Data Lake Storage and Azure Data Factory
- Data modeling
- Data architecture
- Microsoft Azure
- Normalization techniques
- Query optimization
- Backup and recovery
- Replication techniques
- NoSQL databases
- Advanced SQL
- Critical thinking
- Performance tuning
- Database technologies: Oracle 19c, SQL Server
- Tools: SQL Developer, Power Designer, SSRS, SSIS
Languages
English
First Language
English
Upper Intermediate (B2)
B2
Timeline
Database Analyst Specialist
FIDELITY INFORMATION SERVICES
06.2016 - Current
Database Engineer
CAPGEMINI INDIA
03.2015 - 06.2016
Database Engineer
INFINITE COMPUTER SOLUTIONS
06.2014 - 03.2015
Database Engineer
SM NETSERV TECHNOLOGIES PVT LTD
12.2013 - 06.2014
Database Administrator
IL & FS TECHNOLOGIES LTD
02.2011 - 12.2013
Bachelor of Technology - Computer Science
BIJU PATTNAIK UNIVERSITY OF TECHNOLOGY
Similar Profiles
Mithun DasMithun Das
IT Team Lead at CMS IT Services Private Limited and CLIENT : Fidelity Information Services India Private ltdIT Team Lead at CMS IT Services Private Limited and CLIENT : Fidelity Information Services India Private ltd
Madhusudan NMadhusudan N
Senior Database Analyst at Fidelity Information ServicesSenior Database Analyst at Fidelity Information Services
Amaresh SatapathyAmaresh Satapathy
Network Analyst 3 ( Permit to Operate Projects) at Fidelity Information ServicesNetwork Analyst 3 ( Permit to Operate Projects) at Fidelity Information Services
Jagadeesh ChitragarJagadeesh Chitragar
A) Senior Business Systems Analyst at Fidelity Information Services Ind Pvt. Ltd.A) Senior Business Systems Analyst at Fidelity Information Services Ind Pvt. Ltd.
Bharath Reddy KBharath Reddy K
Lead Securities Analyst at Wells FargoLead Securities Analyst at Wells Fargo