Hariharan Raj
Summary
Around 9+ years of experience in Software development using Oracle Technologies that includes. Complete System Development Life Cycle from Analysis and Design to Implementation in Banking & Finance and HealthCare domain.
Developed PL/SQL Programs as Database Triggers, Stored Procedures and Functions and Packages
Experience in Dynamic SQL, Records, Collections and Exception Handling. Experience in Table, Index Creation, Roles and Database Links for Remote Database access.
Worked extensively on Oracle8i/9i and Oracle 10G and Knowledge on 11G.
Expertise in creating Range, List Partitions, Sub Partitions and used CASE, DECODE functions and Analytical functions like Rank, Dense Rank, Row Number for data transformations.
Excellent Programming and trouble shooting skills, and an ability to deliver under pressure. Interacted with business technical groups and analyzed business needs.
Have Strong interpersonal, analytical and communication skills, self-motivated and multi-task oriented, with strong work ethic and ability to work effectively in a Team.
Overview
10
10
years of professional experience
Work History
Technical Lead - Amgen
Cognizant Technology Solution
09.2022 - 07.2023
- Tested databases and performed bug fixes
- Designed and created database systems after reviewing end user's requirements
- Developed database dictionaries and schemas
- Prepared documentation for database applications
- Supported innovative product engineering and collaborative decision-making throughout development lifecycle
- Performed root cause analysis to identify system issues
- Conducted software trial runs to achieve desired results and confirm accurate information
- As a senior software developer at Amgen Hospitality, I designed and constructed the workflows in an Informatica tool, which is a crucial consideration in determining a hospital's sales worthiness
- Even though a database needs to be created for each weekly and quarterly report, and it must be updated in the Cognos repository report for the US regions.
Senior Associate - Novartis
Cognizant Technology Solution
04.2021 - 08.2022
- Senior developer for the backend of a Novartis application
- Built views to test data that is being upgraded to a new platform
- The user was given the option to complete the application procedure just on the internet page thanks to this
- Delivered high level of service to clients to both maintain and extend relationships for future business opportunities
- Wrote SQL queries using programs such as Procedure and Functions
- Established successful protocol for program development and database maintenance
- Developed a SQL query for a new environment using the Novartis Scout application, which contains customer information
- Analyzed code and corrected errors to optimize output
- Tracked quality assurance metrics and liaised with internal teams
- Resolved issues to improve productivity and workflows.
Senior Software Developer
Fission Digital Services
07.2018 - 03.2021
- Created Database objects in accordance with clients requirements specifications
- Communicates with clients to learn about their needs and provide updates on a weekly basis
- Worked for Share-khan, a trading application
- Delivered code to meet functional or technical specifications
- Create DB objects – Procedures, Functions, Views, Packages, and Indexes as part of CRs
- Involve in production support issues and fixed bugs of various SLA
- Prepared the Impact Analysis and Detailed designed documents.
Software Developer
Fission Digital Services
08.2013 - 06.2018
- The assignment was to create a useful data model for the GCPS application to hold company-specific data was able to develop a number of potential designs
- The optimal design was about 20% faster than the conventional SQL DB that was being used to store the data after the cost of querying and efficiency for each design were determined
- Experienced in Production Support in both fixed timings and 24
- 7 Support
- Analyze the existing code for necessary changes like enhance procedures, functions, packages, Views and Triggers
- Responsibilities include implementation of security of data according to client's requirements by creating views.
Education
MBA - Project Management
ALAGAPPA UNIVERSITY
Karaikudi, India08.2023
Bachelor of Engineering - Electronics And Communications Engineering
ARM COLLEGE OF ENGINEERING AND TECHNOLOGY
Chennai, India11.2013
Skills
- Environment :
- SQL PLUS, PLSQL, SQL
- LOADER and Linux
- Database : Oracle 10g / 11g/ 12c
- Design Tool : Informatica Developer
- Cloud tools : Amazon Web Services
- Ticketing tool : Jira
- Report tool :
- Cognos repository
Additional Information
- Activities and Honors, Got Excellence Award twice in FDS (Fission Digital Services), one given for extraordinary performance in a quarter.
Timeline
Technical Lead - Amgen
Cognizant Technology Solution
09.2022 - 07.2023
Senior Associate - Novartis
Cognizant Technology Solution
04.2021 - 08.2022
Senior Software Developer
Fission Digital Services
07.2018 - 03.2021
Software Developer
Fission Digital Services
08.2013 - 06.2018
MBA - Project Management
ALAGAPPA UNIVERSITY
Bachelor of Engineering - Electronics And Communications Engineering
ARM COLLEGE OF ENGINEERING AND TECHNOLOGY
Similar Profiles
Deepak JainDeepak Jain
Manager/Domain Architect at Cognizant Technology SolutionManager/Domain Architect at Cognizant Technology Solution
Amit VermaAmit Verma
Intune Admin at Cognizant Technology SolutionIntune Admin at Cognizant Technology Solution
Jithin NairJithin Nair
Consultant at Cognizant Technology SolutionConsultant at Cognizant Technology Solution
Anup DasAnup Das
Software Engineer at Cognizant Technology SolutionSoftware Engineer at Cognizant Technology Solution
Meghna Jayaram HegdeMeghna Jayaram Hegde
QA - Lead Test Engineer at Wipro TechnologiesQA - Lead Test Engineer at Wipro Technologies