Saranya Ashok
Northville,MI
Summary
Oracle certified SQL Developer - Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
No Visa Sponsorship required. - Immediate joiner
Overview
14
14
years of professional experience
1
1
Certification
Work History
Software Engineer III
Bank Of America
08.2021 - Current
- Highly efficient in SQL and in preparing reports for Business Analytics and Statistical purpose.
- Develop from-scratch modules using AIS Actimize Modeler to track and alert Fraud/Anti Money Laundering activities.
- Actively participated in Business discussions to gather requirements and further develop Design documentation.
- Worked on creation of automated jobs using AUTOSYS.
Senior Software Developer
Ally Financial Services
05.2019 - 12.2020
- Create from-scratch web applications for in-house applications to be used by the organization using Oracle APEX integrated with Oracle PLSQL.
- Enhance the existing web applications using Oracle APEX as per the requirements from the business.
- Create BI reports to furnish customer requested data using Oracle APEX.
- Delivered high-quality code on time by effectively managing project timelines and prioritizing tasks accordingly.
Data Analyst
Sam Financial & Accounting
12.2018 - 04.2019
- Use of Tableau Visualization Tool to Further Enhance and Present Dashboards for Easy Understanding.
- Use of SQL Programming Skills to Fetch Data from Relevant Tables to Prepare Data Reports.
- Provide Application Support for the Software which Is used To Run Weekly Paystubs.
- Analyze the Data to prepare Data Charts, Dashboards to Study and Understand Financial Pattern.
- Produced monthly reports using advanced Excel spreadsheet functions.
Software Engineer
Bank of America
06.2014 - 02.2016
- Developed and Enhanced modules using Actimize Modeler as per requirements.
- Effectively handle customer inquiries and Resolved incidents reported by the end-users in terms of incorrect data on the reports within the SLA (Service Level Agreement)
- Created UNIX shell scripts to import data from different sources and use them for analytical and statistical purpose
- Made root-cause analysis whenever an incident was reported for any fraudulence and permanent solutions were devised to avoid such errors in the future
- Good knowledge on HTML in understanding the tags, formatting styles and fonts.
- Provided technical guidance to junior developers, fostering a positive team environment and promoting professional growth.
- Maintained existing software systems by identifying and correcting software defects.
- Improved software performance by identifying and resolving bottlenecks in the code
Oracle SQL PLSQL Developer / App Support
Uti Logistics, HCL Technologies
04.2010 - 06.2014
- Created Custom data reports and data Forms using Oracle Forms and Reports (version 9i)
- Created automation scripts to Purge data from Oracle tables based on the age and relevance of the data.
- Involved in testing of applications end to end both web application and character-based application
- Testing web application included data quality, latency of the website, functionalities of each menu/tab, behavior of the website.
- Mentored junior PLSQL developers, fostering an environment of collaboration and continuous learning.
- Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
Education
Bachelor Of Engineering - Electronics and Communication -
Anna University
Skills
- SQL
- PLSQL
- UNIX
- Object-Oriented Programming
- JIRA
- HTML and XML
- Database programming
- Code Development and Debugging
- Actimize Modeler
- Risk Case Manager (RCM)
- Oracle APEX
- Data Analysis/Technical Analysis
Certification
- Oracle Certified SQL Associate
- ITIL Certified Software Programmer
Timeline
Software Engineer III
Bank Of America
08.2021 - Current
Senior Software Developer
Ally Financial Services
05.2019 - 12.2020
Data Analyst
Sam Financial & Accounting
12.2018 - 04.2019
Software Engineer
Bank of America
06.2014 - 02.2016
Oracle SQL PLSQL Developer / App Support
Uti Logistics, HCL Technologies
04.2010 - 06.2014
Bachelor Of Engineering - Electronics and Communication -
Anna University
Similar Profiles
Sabien Brown Jr.Sabien Brown Jr.
Business Banking Centralized Specialist at Bank of AmericaBusiness Banking Centralized Specialist at Bank of America
Nicholas ShakanNicholas Shakan
Vice President, Portfolio Manager at Bank of America Private BankVice President, Portfolio Manager at Bank of America Private Bank
ROSEMARY LOPEZROSEMARY LOPEZ
Customer Service Representative at Bank of AmericaCustomer Service Representative at Bank of America
Yara JovineYara Jovine
Relationship Banker at Bank of AmericaRelationship Banker at Bank of America
Jeffrey WicklanderJeffrey Wicklander
Barber at Northville BarbersBarber at Northville Barbers