Raja Jaya sree G
Chennai
Summary
SQL Developer with 8+ years of progressive experience in MS SQL and in Hands on experience of 3 years in Oracle SQL , databases and application programming. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.
Overview
11
11
years of professional experience
1
1
Certification
Work History
DBA, Oracle SQL Developer
Citi Bank, Wipro Technologies
05.2022 - Current
- Healthcare Group in US., Designing and implementing Database structures, including tables, indexes and views
- Coordinating with, team to create and mapping FID for new Database
- Created and tested Table creation in Dev, testing and Production environments
- Created PL SQL stored procedures for NDM Batch jobs to transfer files from Client location
- Also, Stored procedure to create input file for outbound process
- Ensure deployment of new table creation and data maintenance in all environments for region specific
- Skilled at optimizing and debugging PL- SQL statements and stored procedures
- Tools, set up new DB for new application Solix platform to create reports for customers.
- Managed multiple Severity issues (3-5 issues) single handed during production support.
- Transfer files from client location to production server path
- Specify table structure and column names and data length to load data into Solix knowledge base
- Created new tables in Oracle DB to store data that is fed from client file
- Created trigger to call stored procedure, whenever there is data change in primary table
- Ensure stored procedure updates secondary table data
- Make recommendations towards development of new code or reuse of existing code
- Created TSQL procedure as wrapper to support user validation
- Excellent proficient in writing Transact SQL queried and scripts
- Developed Com Callable Wrapper in Asp page that makes application to support pin length validations
- Ensure Design, coding and unit test cases are peer reviewed and supported for quality testing and deployment
- Prepare documentations and specifications
- Develop, Maintain and support programs/tools for internal and external clients
- Design, Code, test, debug and document changes according to functional requirements
- Participate in status meetings for projects and prepare new proposals
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Coordinate with architects and business analyst to determine functionalities
- Coordinate with other developers and quality testing to support them to complete deliverables at earliest
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Mentored junior developers on best practices in SQL development, fostering a collaborative learning environment within the team.
- Developed reusable components for exploitation in coding and documentation.
- Developed, implemented and optimized stored procedures and functions using T-SQL.
Developer Analyst
Fidelity Information Services, AMEX
07.2018 - 01.2022
- Buy on -line card order is a web-based application which was introduced to replace the legacy method of card order through batch process
- By using this new system a client can order a bulk of cards through XML payload
- The payload gets processed based on XSD created and deployed
- The card order details get stored in the SQL database and sent to third party through batch process for card emboss.
- Developed Xml schema for the new application based on XML
- Get the lead (in XML format) as input and validates based on newly created XSD file
- Created new stored procedures to process and load new records in BOL order and payload
- Ensure the batch job has been set up to change the status of orders after shipment confirmation
- Ensure schema file validates the input payload and procedures to load the order details.
- Managed approximately 10 -12 client calls and emails, per day from customers.
- Ensure the card order status changed after the shipment confirmation
- Facilitated knowledge sharing among team members by organizing regular tech talks or coding sessions, fostering an environment of continuous learning.
- Increased project success rates by effectively managing time, resources, and priorities throughout the entire development lifecycle.
- Continuously improved personal skillset with regular professional development opportunities such as workshops or conferences, staying ahead of industry trends.
- Developed and maintained clear documentation for methodologies and applications.
Developer Programmer
Fidelity Information Services
Chennai, India
08.2013 - 06.2018
- Multi threading process introduced in settlement matching tidal job to avoid stopping of matching process while the deadlock occurs
- This process automatically retries 3 times before reporting the error and would log into the table
- Ensure all the subsequent stored procedure under main will detect the error
- Ensure the main procedure would retry the subsequent procedures upon errors
- Ensure the wait delay is maintained between each procedures got invoked
- Created new schema of tables used to save the progress of these procedures and ensuring the data got cleared in the table for the next thread.
- Managed multiple projects simultaneously, ensuring timely delivery of high-quality editorial work.
- Established strong rapport with patients and families through excellent communication skills and empathetic bedside manner.
- Used critical thinking skills, decisive judgment and worked with minimal supervision.
Education
B.E - Electronics and Communication Engineering
Anna University
Tirunelveli04.2012
High School Diploma -
AKDR Girls HSC
Rajapalayam03.2008
P.A.C.R Ammani Ammal Girls' Hr. Sec. School
Rajapalayam2006
Skills
- Strong working experience in agile methodologies (Scrum & Kanban)
- Serviced world-class US Customers like American Express, Citi Bank, GreenDot in Banking and Healthcare domains
- Rich experience in using Scrum works and JIRA
- Extensive experience in Software Development Life Cycle activities like
- Requirements analysis, effort estimation using Story Point Estimation
- Design document creation, coding and review, test case creation, unit testing and deployment
- Handle production issues and provides active production support during release upgrades
- Peer review of team member's work
- Excellent code reviews and code debugging sills
- Extensively involved in writing database scripts
- Hands on experience in writing complex queries and query optimization
- Hands on experience in writing PL/SQL Stored procedures, triggers creating and debugging and table creation
- SQL Server 2016 and Oracle PL/SQL
- Database monitoring,
- Database Development
- Performance Tuning
- Code debugging
- Query Optimization
- Document Management
Accomplishments
- Microsoft Certified Professional in SQL Server 2008, Database Development
- Oracle database SQL Certified associate
- Azure fundamentals AZ -900, Fundamentals of Azure
- PROJECTS#1 Unified Wealth Workstation project (APAC/NAM) - 2022 September to till date
- Tools: Oracle SQL Developer
- Description: Set up a new DB for a new application UWW platform for
- APAC and NAM regions.
Certification
Certified Microsoft Professional in SQL Server 2008, Database Development
And certified as Oracle Database SQL Certified Associate.
Interests
- Travel
- Sports
- Reading
- yoga
Timeline
DBA, Oracle SQL Developer
Citi Bank, Wipro Technologies
05.2022 - Current
Developer Analyst
Fidelity Information Services, AMEX
07.2018 - 01.2022
Developer Programmer
Fidelity Information Services
08.2013 - 06.2018
B.E - Electronics and Communication Engineering
Anna University
High School Diploma -
AKDR Girls HSC
P.A.C.R Ammani Ammal Girls' Hr. Sec. School