Post Job Free

Resume

Sign in

Pl Sql Regulatory Reporting

Location:
Rancho Cordova, CA
Posted:
July 11, 2023

Contact this candidate

Resume:

Parthasarathy Boobalan Mobile: +1-916-***-****

adx74s@r.postjobfree.com

OBJECTIVE

To work in a challenging environment where I can constantly learn and operating as a group, which will utilize my skills and abilities for the growth of an organization as well as for my individual growth.

PROFESSIONAL SUMMARY

• Around 8+ years of experience in Development with sound knowledge in Axiom Controller View and Oracle SQL, PLSQL.

• 3+ Years, Relevant experience Axiom Controller View for Regulatory Reporting.

• Designed and developed reports using both AXIOM CV (V9, V10).

• Good knowledge in Axiom Controller View, Control-M, Unix, and Oracle SQL.

• Involved in creating Axiom objects like Data Source, Data Model, Modify Model, Shorthand, Portfolio, Aggregation and Free Form & Tabular Reports.

• Loading the data from different source into Axiom using the Data Source.

• Involved in Migration from V9 to V10

• Worked on axiom functionality like Archival, Purge, Calendar, Signoff, Code deployment, Code comparison and Permission setup.

• Knowledge in different data storage methods.

• Built and maintained SQL queries for data analysis and extraction, managing database using collections, Functions, Procedures, Cursors, Exception Handling, Triggers, Oracle Advanced Queuing, creating new jobs and creating Packages as per the client requirements.

• Knowledge in Query Optimization and Performance Tuning

• Interacting with business users for requirement understanding, SIT/UAT verification and production deployment.

• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Work Experience:

Hana E Solutions Inc (June 2023)

CGI, Bangalore (Nov 2021 – Mar 2023)

Role: Axiom Developer- Regulatory Reporting

Client: PNC Bank

Developing Reports in AXIOM Controller View and mentoring and guiding team members

Worked in FED reporting like FRY 9C, FRY 14Q, CCAR Report.

Interacting with business users for requirement understanding, SIT/UAT verification, Production deployment and regularly verifying production reports.

Developing reports using AXIOM objects i.e. Data source, Data Model, Modify Model, Aggregation, Portfolio, Short hand, workflows, Taxonomy mapping, Dimensions and measures, Hyper cube, Free form etc.

Developing Control-M scheduler for automation and Workflow execution

Involved in migration from V9 to V10

Lansern & Toubro Infotech Chennai (Nov 2020 to Nov 2021) Role: Axiom Developer- Regulatory Reporting

Client: SCB (Standard Charted Bank)

Developed data models, modify models, portfolios, Shorthand’s and aggregation to configure the report mapping in freeform reports.

Worked for MAS reporting like MAS610 reporting.

Knowledge in creating Axiom objects like Data Source, DataModel, Modify Model, Shorthand, Portfolio, Aggregation and Free Form &Tabular Reports.

Worked on axiom functionality like Archival, Purge, Calendar, Code deployment, Code comparison and Permission setup.

Implemented updates and make sure Data is thoroughly analyzed for consistency as per the guidelines received from BA’s.

Tamil Infotech, Dindugal(Nov 2019 to Nov 2020)

Role : Axiom Developer- Regulatory Reporting

Client: BNP Paribas Bank

Involved in creating Axiom objects like Data Source, Data Model, Modify Model, Shorthand, Portfolio, Aggregation and Free Form & Tabular Reports.

Worked on Canada Reporting like A2 Reports, K3 Reports,BCH4 reports.

Working on FRD for developing report and schedule it in scheduler

Migrating code once development is completed in dev to UAT

Involved in requirement analysis, coding, debugging and unit testing various modules in a software development life cycle (SDLC).

Gathered and analyzed the business requirement of new change request from client.

Pyrmaid IT Consulting Private Limited, Chennai(June 2019to Nov 2019) Role : PL SQL Developer

Involved in fixing production bug fixes

Worked on converting the SQL queries directly written in Oracle forms to Stored PLSQL objects like Procedures. Functions, Cursor’s and Collections

Interacted with the clients to get clear picture about the requirements

Implemented changes to existing codes to improve the performance

Created documents on changes or fixes implemented to make things easier to back track

AB Info Tech Trichy (May 2015 to June 2019)

Role : PL SQL Developer

Worked on writing function, stored procedures and triggers to support application development

Ensure the data quality and integrity in databases

Fix any issues related to database performance and provide corrective measures

Test databases and perform bug fixes

Develop best practices for database design and development activities TECHNICAL SKILLS:

Operating System : MS-DOS, Microsoft Windows XP/Window7,UNIX. Language : PL/SQL, SQL

Database : Oracle 9i/10g/11g.

Tools : AXIOM (V9, V10), SQLDeveloper, PL/SQLDeveloper, ControlM Declaration:

I certify that to the best of my knowledge and belief, this CV correctly describes me and my qualifications.

Place : Chennai

Date : Parthasarathy



Contact this candidate