SUMMARY

• A results - driven and dedicated IT Professional with more than 11 years of experience in domains like Corporate, Investment Banking, Regulatory Reporting, e-commerce and public sector
• Experienced in managing global client interactions, expectations and requirements
• Mentored and coordinated with cross-functional teams consisting of Technical and Business stakeholders to ensure successful execution of critical business processes
• Hands-on experience in requirement gathering, analysis, design, development, testing and maintenance of software applications
• Worked extensively on Regulatory Reporting tools like AxiomSL, Oracle SQL, PL/SQL, Performance Tuning, UNIX, Data Warehousing and ETL using Oracle Warehouse Builder (OWB), Informatica and Tableau
• Experienced in design, data modelling and implementation of relational databases and complex data warehouses utilising dimensional design concepts
• Project development and Certificate course in Big Data & Hadoop from Edureka with hands-on experience on HDFS, MapReduce, Pig, Hive, Hbase and Oozie
• Well recognized abilities in process improvement, optimization and automation to reduce manual effort and improve project quality
• Delivered multiple CMMI level 5 projects in Agile mode, fast paced and deadline oriented environment within time and budget constraints
• An effective communicator and dedicated professional with high attention to detail, strong analytical, problem solving and organizational abilities

TECHNICAL SKILLS

Programming Languages: Oracle SQL, PL/SQL, Perl, Unix shell scripting

RDBMS: Oracle 9i/10g/11g, Microsoft SQL Server 2012

Web Technologies: HTML, J2EE, XML

Operating Systems: Unix/Linux (Red Hat Enterprise Linux 5), Windows

Tools: and utilities: SQL Plus, Toad for Oracle, SQL Developer, PLSQL developer, SQL*Loader, Microsoft SQL Server Management Studio 17, Oracle Enterprise Manager (OEM), PuTTy, Quest CodeXpert, Sonar, Aqua Data Studio, FLEXCUBE RAD tool

ETL Tools: Oracle Warehouse Builder 11g, Informatica Power Centre 8.6

Regulatory Reporting Tool: Axiom SL v9.9.15

Issue Tracking Tools: JIRA, HP ALM/Quality Centre, Bugzilla, Mantis

Version Control Tools: IBM Rational ClearCase V7.0, Tortoise SVN, MS Visual Source Safe

Scheduling Tool: Autosys

Release Tool: BMC BladeLogic

PROFESSIONAL EXPERIENCE

Senior Designer-Development

Confidential

Responsibilities:

• Development of Regulatory reports such as Liquidity Coverage Ratio (LCR), Additional Liquidity Monitoring Metrics (ALMM) and Net Stable Funding Ratio (NSFR), PRA110, Funding Plans, RFB002 (Ring Fenced Banking) using Axiom Controller View
• Preparation and configuration of XBRLs using COREP Taxonomy modules provided by Axiom
• Worked extensively on EBA Reporting Framework 2.9, 2.10; BREXIT reporting
• Experienced working in all Axiom Controller View components like Data Sources, Data Models, Aggregation, Portfolio, Shorthands, Workflows, Hypercubes and reports such as Free Form Reports, Tabular reports etc.
• Assisted business in Regulatory submission of reports by setting up Firms, Enterprise Report Calendar and mapping
• Development and enhancement of Axiom Web Dashboards used by internal Treasury stakeholders for movement analysis, stress testing etc. by providing various features such as graphs, colour coding and dynamic input of values
• Hands-on experience in installation, set-up and configuration of Axiom as well as Dashboard services
• Performance tuning, optimization and troubleshooting of daily production batches along with continual process improvement
• Upstream change impact analysis and proactively averting risks on Axiom reporting
• Involved closely with Business and technology team members for requirement gathering, analysis and identifying strategic fixes
• Change request prioritization, effort estimation, functional and technical solution design and documentation along with SIT and UAT support
• Production Release support by preparation of release artefacts, change management activities and post release support for any production incidents and data anomalies
• Ensure timely reporting to internal and external stakeholders and minimise incidents by providing third line and BAU support during daily production runs
• Root cause analysis and strategic fix for ad-hoc queries raised by business users during internal and external data validations
• Management of Knowledge sharing activities for continuous improvement within the team and upscale new team members

Software Designer

Confidential

Responsibilities:

• Development of Regulatory Reports - Daily Flows (FSA047) and Enhanced Mismatch (FSA048) Reports submitted to PRA for Liquidity Management
• Change request prioritization, requirement analysis, effort estimation, functional and technical solution design and documentation, impact analysis, release packaging and deployment
• Creating complex code units using Collections, Stored Procedures, Functions, Packages, Sequences etc. along with OWB transformations like Joiner, Aggregator, Expression, Filter etc.
• Performance tuning and optimization, troubleshooting, Job creation and scheduling
• Data modeling, exception handling, bug fixing, SIT and UAT support, Code review
• Implementation and post release support for any production incidents and data anomalies
• Ensure timely reporting to internal and external stakeholders by assisting production support teams in monitoring and troubleshooting daily batch processing
• Root cause analysis and strategic fix for all technical and functional issues like balance movements, data validation, reconciliation with front office and ledger etc. raised by users which involved knowledge of General Ledger, Trade Life cycle etc.
• Upstream change impact analysis on Liquidity application and Disaster Recovery test support
• Query creation, optimization and support for BI and Visualisation tools like Spotfire used for data movement analysis and stress testing
• Liquidity specific technical and functional trainings for development, testing and support teams
• Solution design, analysis and guidance for task allocation to team members
• New Regulatory Reporting requirement for handling huge volume of mortgages data using Big Data HDFS and Hive

Senior Oracle Developer

Confidential

Responsibilities:

• Functional understanding and enhancement of FCUBS modules like Core Entity, Core Services, Customer and Customer Account Maintenance, General Ledger Chart of Accounts for Corporate Banking - Cash Management, Transaction Services
• Requirement analysis, data modeling, functional and technical specification documentation
• Extensive use of Universal Banking Development Workbench ‘RAD tool’ for FLEXCUBE frontend screen development, generating scripting files, packages, upgrading the development changes to latest FLEXCUBE release
• Backend database development of functions, procedures, packages, tables, views etc.
• Deployment and functional testing of FLEXCUBE module changes in FCUBS schema
• Frontend/ Backend Unit testing and bug fixing for Quality Assurance

Senior Systems Engineer

Confidential

Responsibilities:

• Requirement analysis, optimal project design and technical specification documentation
• Data model changes using Data Warehousing concepts like Start and Snowflake schema etc.
• Development, defect handling and testing of Views, stored procedures, packages, triggers etc.
• Development of workflows and mappings using Informatica Power Centre for migration of data from ORD/ODS database and Feed files to load the Finance Data Mart
• Data extraction/conversion/transformation as part of the ETL batch using Joiner, Sorter, Expression, Stored Procedure, Sequence Generator, Aggregator, Filter, Mapplets etc.
• Data validation/integrity check for workflow mappings by creating SQL queries as generic validation scripts which were also used by testing team
• PL/SQL code quality check using Toad CodeXpert and Sonar

Systems Engineer

Confidential

Responsibilities:

• Red Hat Enterprise Linux 5 ‘System Administration’ including OS installation, configuration, performance monitoring, networking, security and troubleshooting
• Oracle 10g/11g ‘Database Administration’, involving tasks like database installation/upgradation, configuration, troubleshooting, schema object creation, data transfer, backup, recovery, user management, services and security in both RAC as well as single node environments
• Acquired working knowledge of technologies like virtualization, cloning, clustering, cloud computing, SAN (NFS), NTP, load balancing, hardening and Oracle RAC