SUMMARY

• 10+ years of experience in Credit Risk Management, Business Intelligence, Change Management, Application Programming, Business Analysis and Testing on IBM Mainframe, SAS, Business Objects, Application server and Teradata environment with the ability to adapt to a variety of working environments.
• Domain knowledge in Confidential, Commercial Leasing and Lending, Regulatory Reporting, Banking Finance and its implementation in Data - warehouse Environment including various interface technologies.
• Proficient in liaising between business and technical areas, solutions suggestions, requirements gathering, documenting design, test planning and execution.
• Strong expertise in client handling with exceptional customer facing background. Worked in maintenance of Application Products, Enhancements and Production support.
• Excellent communication & interpersonal skills and clear understanding of fast-changing & multi-cultural work environment

TECHNICAL SKILLS

• Credit Risk Management
• Confidential
• Business Scorecard
• Regulatory reporting
• Commercial Leasing and Lending
• Default and Loss
• General Ledger
• Business Objects
• Informatica
• SAS
• COBOL
• JCL
• BMC Remedy
• Service Now
• Moody’s Risk Frontier
• Teradata SQL Assistant
• Oracle SQL developer
• HP ALM defect tracking
• MS Products- MS Project, MS Office, MS Excel, MS Word, MS Powerpoint, MS Visio
• Teradata
• DB2, Oracle
• SQL server
• Operating Systems
• IBM OS/390, Z/OS
• Windows XP/7, Unix

PROFESSIONAL EXPERIENCE

Confidential, Norwalk CT

Senior Business Analyst

Environment: Teradata, Business Objects, Moody’s Risk Frontier, Informatica, SQL server

Responsibilities:

• Defined and implemented the new feed from Treasury system to get the spread rates for the reference yield LIBOR curves to calculate the interest rates related to counterparties whom Confidential Capital has given different loans
• Confidential process helps in decision making using Model portfolio and loan-level credit risk information (expected and unexpected loss, distribution of values, losses, and capital) and analyse concentrations by industry, region, asset type, and counterparty.
• Quantify the impact of new deals or trades within a portfolio and impact of adding the new deal portfolio management using Risk Frontier.
• Pulling data from IRIS system after consolidation process where Customer Mastering is done to get the information of the Main business entity under which its sub-business has taken loan and leases from Confidential Capital.
• Treasury data integrated along with IRIS data and loaded to Portfolio Analytics Data-warehouse to create data elements for Moody’s Risk Frontier environment to calculate the Confidential values for the Expected and Unexpected losses.
• Mapped Transaction level data from IRIS system to Instrument level data such as Bond, Bullet, Term loan Amortizing and Revolver from Treasury system including CUSIP number (from S&P) to identify issuer of the bonds and the related information.
• Mapping of Risk Rating values (from Moody's, S&P) to PD values to generate final rating of the obligor on Internal scale.
• This Moody’s tool has built in capability to provide different data insights related to Risk attributes once the data loaded from different Moody’s environment including Prestage, Stage and Core.
• Worked with consultants from Big-4 from Financial Advisory services to establish the overall process checks related to Confidential and Basel Implementation.
• Ensuring the correct data loaded in CORE and then running the Analysis using Risk Frontier tool to calculate the overall EAD
• Backtrack issues related to interest rate data from Treasury Data lake (Greenplum) using PGAdmin tool in case if data is not correct.
• Generating business reports once the Analysis is successfully completed
• Created Confidential related Process document and saved using Atlassian cloud(confluence) for internal risk management audit.
• Changing the LGD (Downturn and Shock Downturn LGD) values as per business requirement for the LGD Risk Models to calculate the EAD in worst case economy scenarios

Confidential, Norwalk CT

Business Analyst

Environment: Teradata, Business Objects, Spotfire, Web server, HP ALM

Responsibilities:

• Involved in Requirement gathering, facilitate meeting with Business user, functional analyst/architects/other stakeholders to identify the requirements/needs.
• Co-ordinate effort for High Level/Low Level Design. Review functional and technical specification and obtain Functional users, Business users and Solution architects sign off.
• Prioritize projects in the beginning of the year according to the importance of the Regulatory reporting needs which is required to be implemented during Q1, Q2, Q3 or Q4.
• Worked mainly in Credit Risk Management domain along with the regulatory requirements for Federal Reserve Board submission such as CCAR, SNC, FRY9C, Basel 3 reports.
• Feed from Basel 3 reports also shared with International business to submit compliance reports to Prudential Regulation Authority.
• Created BRD for IRIS data warehouse system for collecting, managing, aggregating, utilizing and performing Risk (Credit, Market, Interest etc.) calculations for Head Quarter of Confidential Capital
• Analyse enhancement request, identify impacted modules and Reporting environment where changes need to be implemented.
• Creating Change Request which includes UAT signoff, deployment script, Backup and Rollback Plan for deploying the changes by DBA team on Teradata on quarterly basis.
• Interact with client, business, functional module experts, third party systems lead through regular workouts and open item discussion for capturing the business and functional requirements for implementing the solutions to Business Objects, Spotfire, BAV and IRIS Web.
• Preparing Project Plan in line with the Business plan for BO, Spotfire, BAV and IRIS Web Application. Also, managing

Confidential

Project Lead

Environment: Teradata, IBM Mainframe, Z/OS, Cobol, JCL, SAS, changeman

Responsibilities:

• Requirement Analysis of the project including creation of HLD LLD and Control Plan documents for Anti Money Laundering Applications.
• Ensuring right Teradata utilities used in JCLs according to the total number of records and their percentage future growth.
• Participate in review and creation of code, HLD/LLD, BRD and Load Schedule document to ensure it follow the set standards.
• To change Teradata PARMS if it is not coded with proper standards in order to minimize Load on Teradata Platform.
• Running queries using Teradata SQL Assistant to generate dashboard, Weekly and Monthly reports related to Teradata environments using HLQ, Heat Map, MPLS specific to applications for performance and capacity trends.
• Automated code review process by creating set of jobs running using SAS programs to save 54000$ annually as part of value adds.
• Working closely with project teams to classify RFCs for impact and risk analysis associated with it with respect to production Platform and ensuring stability and availability of Teradata Platform.
• Review and follow-up with the ongoing projects for overall performance optimization of the teradata warehouse starting from the initial phase till the implementation in production involving reviews related to code, SLA, Architect to ensure all set standards are met.
• Creating mapping document details to map different fields with the table structure.
• To develop test strategy, test plan and test scripts and test all components present in Changeman Packages which are in frozen status according to Test Cases.
• To create all New, Dummy, Decommission and NDM jobs in the Changeman Package for major migration projects (Migration from Midrange to Mainframe Platform).
• Functionality testing of different modules introduced to Shared site with the new test cases for the modules for managing Teradata environment.

Confidential

Developer

Environment: IBM Mainframe, COBOL, DB2, JCL, SAS, Endevor

Responsibilities:

• Responsible for development and enhancement of Application programs based on business rules provided by users in form of RFS.
• Participation in coding, Unit testing and final Implementation of the Project.
• Developed SAS programs and debug SAS intranet reports.
• Involved in Impact Analysis, Requirement analysis and Effort estimation.
• Testing of Mainframe applications using Test Cases (Plan, Prepare and execute) for high quality deliverables.
• Resolving daily production issues (incident request) related to assigned applications.
• Handling user support ticket and periodic routines using BMC Remedy Tool.
• Performance optimization by reducing storage and CPU consumption and Stopped jobs to run during Peak hours in Tivoli Workload Scheduler using special resource and saved 95 thousand Euros annually.
• Perform root cause analysis and provide resolution to recurring issues.
• Preparation of Continuous Improvement Plans for the applications.
• Create test cases and co-ordinate with the users during User Acceptance Test.
• On-call support for applications for first 5 banking days of the month
• Proactive monitoring of critical application and quick fix in case of failure.
• Create AOD (Application Overview Document) after Knowledge Transfer within the team.
• Update client QMS (Quality Management System) documents for the changed modules