Ishant Saxena
Software Engineering
Bareilly
Summary
To work in the most challenging position with an organization that provides ample of opportunities to learn and to contribute.
Experience Summary:
10.2 years of IT services experience in delivering technology solutions to customers in Banking and Insurance domain. Experience in Requirement Gathering, Technical Design, Development, Testing and Enhancement of large scale banking applications. Extensive experience in Oracle 10g/11g, SQL, PL/SQL, UNIX shell scripting and Data Science. Understanding the Loans functionality and regularly incorporating changes as per the US Banking and Regulations. Extensive work on Escrow processing. Created a POC on Credit Card Fraud Detection to predict defaulters using Predictive modeling. Received Customer Delight Award for automating a tedious and time consuming job and many other Awards and Recognitions for completing critical jobs with stringent timelines efficiently.
Overview
10
10
years of professional experience
5
5
years of post-secondary education
Work History
Tech Lead
Fiserv India Pvt. Ltd
08.2018 - Current
- Oracle 11g, 12c, Data Science, Predictive Modeling
Oracle Database Developer
04.2017 - 08.2018
- Oracle 11g/10
Technology Analyst
Kotak Mahindra
06.2016 - 11.2016
- Product : Finacle Technology : Oracle 11g/10g, Toad 9.0, IBM AIX 7.0
- Roles & Responsibilities:
- Worked as a PL/SQL developer to support application using Oracle SQL and PL/SQL
- Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction
- Responsible for understanding the business and technology involved
- Worked from Onshore and helped in deployment and testing of code
- Build PL/SQL Stored Procedures, Functions for implementing business logic
- Worked on Cursors, User-defined Object types, Collections, Records, and Tables in PL/SQL Programming
- Used Exception Handling for the ease of debugging and displaying the error messages in the application
- Project : Allstate Roadside
Analyst Programmer
Syntel LTD
Chicago
03.2013 - 05.2016
- Oracle 11g/10g, Toad 9.0, Unix/Linux Shell Scripting
- Roles & Responsibilities:
- Responsible for understanding the business and technology involved in supporting client’s application
- Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic
- Extensively used Cursors, User-defined Object types, Collections, Records, and Tables in PL/SQL Programming
- Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables
- Developed control files for SQL
- Loader and PL/SQL programs for loading and validating the data into the Database
- Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application
- Implemented features including views for better performance of summary tables, Autonomous Transactions
- Developed UNIX shell scripts to run the SQL scripts to generate reports and sending out email
- Generated .txt and .csv reports using UTL files
- Prepared Technical Documentation
- Involved in developing test plans and test cases based on high-level and detailed designs
- Successfully implemented Projects/modules like UNIX to Linux Server Platform Migration, Mortgage Partner Migration to AMC
SQL Developer
- Anaconda Navigator
- DNA is Core banking solution for Financial Institutions used extensively across USA
- Have been working on the Loans functionality of the product, enhancing the module regularly and keeping up with the US banking and regulations
- Roles & Responsibilities:
- Enhancing the Loans functionality and regularly incorporating changes as per the US Banking and Regulations
- Keep adding new features as demanded by the clients and making the application more advanced and at par with other core banking solutions
- Extensive work on Escrow processing
- Created a POC on Credit Card Fraud Detection to predict defaulters using Predictive modeling
- Involved with customer communications, client calls and Point of Contact for query resolutions
- Involve in writing and delivering technical artifacts, Requirement Specification, Impact Analysis, Design specification, Test Cases, Release & Deployment documents
- Have worked on TFS (Team Foundation Server) as code repository and version control
- Project: BCBS Subscription
Visualizer, SQL Developer
Edgeverve Systems LTD
- Genesis is Global Data warehouse of Citi Bank
- BCBS Subscription team keeps track of loading data into the warehouse while fixing any issues that come
- Data comes from various feeds and sources and then is loaded into the staging tables though subscriptions
- Roles & Responsibilities:
- Worked on Subscriptions to load data into the Citi data warehouse Genesis
- Involved in debugging subscriptions to fix the issues that occur while data loading
- Interacted with BA to gather the requirements and implement the same in the project
- Worked on performance tuning
- Involved with customer communications, client calls and Point of Contact for query resolutions
- Involve in writing and delivering technical artifacts, Requirement Specification, Impact Analysis, Design specification, Test Cases, Release & Deployment documents
- Responsible for writing Oracle DB stored procedures/packages
- Involve in supporting the System Test Environment to fix the testing issues
- Have worked on GIT, Gerrit used for checking in the code 3
- Project: SOL Merger
Education
Post Graduate Diploma - Data Science
International Institute of Information Technology
Bangalore 03.2020 - 04.2021
Bachelors of Technology -
Invertis Institute of Engineering And Technology (Gautam Buddha Technical University
Bareilly 08.2008 - 06.2012
Skills
Technical Skillsundefined
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Post Graduate Diploma - Data Science
International Institute of Information Technology
03.2020 - 04.2021
Tech Lead
Fiserv India Pvt. Ltd
08.2018 - Current
Oracle Database Developer
04.2017 - 08.2018
Technology Analyst
Kotak Mahindra
06.2016 - 11.2016
Analyst Programmer
Syntel LTD
03.2013 - 05.2016
Bachelors of Technology -
Invertis Institute of Engineering And Technology (Gautam Buddha Technical University
08.2008 - 06.2012
SQL Developer
Visualizer, SQL Developer
Edgeverve Systems LTD
Similar Profiles
Ajay NarangAjay Narang
Advisor, Software Enginerring at Fiserv India Pvt. LtdAdvisor, Software Enginerring at Fiserv India Pvt. Ltd
Ashok MuruganAshok Murugan
Senior Delivery Manager at Fiserv India Pvt. LtdSenior Delivery Manager at Fiserv India Pvt. Ltd
Swatantra JainSwatantra Jain
Analyst at Fiserv India PVT. LTDAnalyst at Fiserv India PVT. LTD