Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Sreeshma Mohanan

Systems Specialist

Summary

Oracle PL/SQL developer with 4 years of experience in the field of software development. 4 years of Oracle PL/SQL programming experience and 1.5 years of Unix shell scripting experience. Building application component using Oracle 12c. Strong technical expertise in creating and maintaining database objects. Extensive experience in developing PL/SQL Stored procedures, Packages, Functions, Triggers, Cursors etc. Proficient in oracle utilities and tools-SQL Loader, SQL Plus, SQL developer, Toad Expertise in software development life cycle of client implementations including requirement gathering, analysis, solution design, development, unit testing, production implementation and technical documentation. Worked in healthcare, banking campaign and investment data management domains so far. Excels in fast-paced, high-energy and deadline-driven environment with willingness to take on additional tasks.

Overview

5
5
years of professional experience
7
7
years of post-secondary education

Work History

Systems Specialist

Allianz Technology
Trivandrum
2 2022 - Current
  • Working on over 3 DataMarts which majorly focuses on investment data management and risk reporting
  • Supported technical solution design, implementation of new services, further development of existing services complying with change management process
  • Experience in working on start schema model, developed dimensions and loading views to support fact tables, ensuring efficient data aggregation and reporting capabilities
  • Creation of new interfaces using PL/SQL Stored procedures for data loading from new source and enhancement of existing Packages for interfaces
  • Worked on supporting front end application by creating various database objects
  • Contributed to documentation and knowledge sharing initiatives, providing technical guidance and support to team members and stakeholders
  • Provided post-deployment and early life support
  • Created journaling tables using Triggers for tracking changes made on Manual input tables
  • Close collaboration with team members and external stakeholders regarding project progress and milestones
  • Proactively identified areas for process improvement and implemented changes that led to significant time savings for team.

Data Analyst

Hansa Cequity
05.2021 - 01.2022
  • Worked as data analyst in banking domain project, taking care of their campaign projects for products
  • Daily tracking of data loading from external flat files to database
  • Design and development
  • Data extraction
  • Operational Support.

Software Engineer 1

IQVIA
07.2019 - 01.2021
  • 1.5 year experience in developing application on health care/pharma domain
  • Worked on data analysis as per client requirements
  • Daily and weekly interaction with stakeholders on gathering business requirements and providing insights on solution implementation
  • Worked on extracting data sets as per client requirement
  • Automation of feedback files for clients
  • Developed SQL scripts for extracting data from multiple data source and provided data insights based on extracted data
  • High level design and time driven deliverables employing Oracle and mainframe technologies.

Education

B-Tech - ECE

TKM College of Engineering
Kollam
05.2015 - 05.2019

Higher Secondary -

KPRGSGHSS
Kannur
06.2013 - 06.2015

High School -

Tagore Vidyaniketan
Kannur
06.2012 - 06.2013

Skills

PL/SQL

Oracle SQL

Unix shell scripting

Cognos FM

Mainframe Schedule designing and automating

Python Basics

Accomplishments

  • Rookie of the year - Received Rookie of the year award from Allianz Technology in 2023
  • Navratna award - Received Navratna award from Allianz Technology in 2022
  • Bravo award in 2024

Timeline

Data Analyst

Hansa Cequity
05.2021 - 01.2022

Software Engineer 1

IQVIA
07.2019 - 01.2021

B-Tech - ECE

TKM College of Engineering
05.2015 - 05.2019

Higher Secondary -

KPRGSGHSS
06.2013 - 06.2015

High School -

Tagore Vidyaniketan
06.2012 - 06.2013

Systems Specialist

Allianz Technology
2 2022 - Current

Similar Profiles

CREATE PROFILE
Sreeshma MohananSystems Specialist