DEVELOPEROracle FinCrime Consultant, Mantas / OFSAAFCCM• Hands on experience in Oracle Financial Services Analytics Application FCCM. (8.0.3) for various geographical regions.• Involved in end to end version migration/upgrade from Mantas 5.8 to OFSAA 8.x version.• Worked on Installation of OFSAA v 8.0.1, 8.0.2 and 8.0.3.• Worked as L3 support for entire Mantas Platform including interactions and delivery management with other upstream and downstream application teams.• L3 support activity includes deep dive analysis of Mantas scenarios, ingestion data, creating reports and proposals for scenario optimization and identifying any monitoring gaps.• Strong PL/SQL development experience for configuring staging environment.• Hands on experience on HIVE programming.• Worked on designing strategies for data repository from Mantas to Big Data platform with country level data security.• Proficient in troubleshooting MANTAS job failures, and hands on experience in managing Mantas Batches.

DEVELOPER• Hands on experience in Oracle Financial Services Analytics Application FCCM. (8.0.3) for various geographical regions.• Involved in end to end version migration/upgrade from Mantas 5.8 to OFSAA 8.x version.• Proficiency in database designing and developing supporting applications to perform manual CASE creation.• Worked on Installation of OFSAA v 8.0.1, 8.0.2 and 8.0.3.• Worked on integration with Teradata and SQL server systems for source data to FCCM application.• Strong PL/SQL development experience for configuring staging environment.• Knowledge of LDAP.• Proficient in troubleshooting MANTAS job failures, and hands on experience in managing Mantas Batches.• Proficiency in User administration setup and knowledge on OFSAACONF tables.• Support all Data mining activities on mantas 5.8 schemas and FCCM 8.0.3 schemas.• Programming and Testing in Oracle PL/SQL, UNIX shell scripting.• Experience in all phases of software development life cycle.• Expertise in Programming in Oracle PL/SQL involving stored procedures, triggers, functions, indexes, packages, Data modelling based on client requirements etc. • Build work plans with users on testing every enhancement or customized solution deployment.• Release planning & management.

DEVELOPER• Automate business processes for clients. Troubleshoot any functional or technical issues for users accessing JDA application.• Expertise in configuring JDA application server, nodepools, process assignment, patch installations.• Hands on experience in configuring WebLogic webserver to support JDA installation.• Handling all admin processes for enabling user/group to operate JDA processes.• Integrating JDA suite with SAP, installation of JDA patches.• Hands on experience in application monitoring, impact analysis, coding and unit testing. • Design and scheduling of Batch scripts to create daily networks in historical data loads, automated JDA process such as Calculate Model, Calculate Plan, BTL, Forecast publishing and Transfer etc.• Took bottom line responsibility in resolution of numerous highly escalated issues by coordinating between multiple teams including Middleware, Message Queues, Infrastructure, and DBA with teams in multiple time zones. • Build work plans with users on testing every enhancement or customized solution deployment.• Release planning & management.

A PEGA PRPC implementation for creating user portals and workflows to automate the new account opening process of users. Responsibilities:• PL/SQL programming which includes Stored Procedures, Triggers, Functions, Cursor Programming.• Tuning of SQLs implemented PRPC coding.• Maintaining the DB scripts throughout construction for proper deployment.• Design the process of automating the flow of account maintenance request having various combinations of data.• Build proper Test Queries for QA team.• Requirement Analysis, Design, Estimations.Environment: Oracle PL/SQL, Toad, SQL Developer, HP Quality Center.