SUMMARY

• Creative, detail oriented self - starter with an MBA and solid knowledge in Credit risk management, collaborative team building and in-depth understanding of the structure of the global economy.
• Possess excellent problem solving, Strongcritical thinking,analytical and writing skills and adept at working independently and under pressure.
• Excellent written, oral and analytical skills with the ability to prioritize and develop effective strategies to deliver timely solutions that meet customer goals.
• Data Governance and Regulatory Reporting, Dodd Frank rule, Volker’s rule, Core Banking, Wholesale & retail exposures
• Netezza, Ab Initio, Collibra Metadata Manager tool, Tableau, OATS, CATS Equity capital Model, Calypso FX(V14,V11) and Patch ups
• Crystal reporting with visual studio through different data sources Microsoft Excel, SQL databases,SQl server reporting services, MS access, Oracle databases
• Reportig tools Tableau, Axiom, SSRS
• Report analytics using various analytics methodologies, knowledge of architecture and base of enterprise data,recommending and producing dashboards and reports.
• 3-5 years experience with OBIEE 11g and Business intelligence (BI)
• ETL - loading packaging data (Intersystem and intrasystem data transfer) also data movement from one platform to entirely different platform.
• UI design Wireframing
• Loan origination systems Loan IQ, ACBS, ACLS, MRR, Murex, FDR
• BCBS 239, AML, OFSAA, RWA calculations, Liquidity & Leverage ratioRatios, Cash flow
• 5+ years experience on oracle OFSAA platform BI dashboard and crystal reports
• Python 2 & 3 Coding experience with QZ platform
• SAS risk data modeling for Risk parameters from business prospective
• Financial Data Analysis with SQL server reporting services and PL SQL in Oracle database
• Solid knowledge of BASEL II, Basel III, Risk Calculation, Risk Management and regulatory compliance
• Data architect and data modeling for various reports.
• Wholesale (Power one) and SAS (Retail Risk management).
• Expert in SQLs, TOAD and Oracle Database applications.
• OFSAA tool for BASEL II and III calculations.
• Clarity systems, Share point management.
• MQC Mercury quality center (HPQC), CRM, Content management
• Solid Knowledge of Microsoft Windows, Microsoft office programs like - Word, Excel /XML, PowerPoint, Data
• Strong Knowledge of Software Development lifecycle and methodologies like Waterfall, agile methodology and Scrum approach

PROFESSIONAL EXPERIENCE

Confidential

Sr. Consultant Regulatory Functional BA

Responsibilities:

• Assisting on implementing SCCL (Single Counterparty Credit Limit) regulation and various testing during development.
• Managed Collibra data governance(Business Metadata and Technical Metadata) for Business elements for SCCL reporting, driving governance activities for all participating line of businesses and ensuring all work activity is completed on time and to standards; while mitigating risks as needed.
• As a Senior Business Consultant involved in the Europian exposures (SCCL) Single Counterparty Credit Limit project to adhere to the prudential standards of Dodd Frank compliance rule in US.
• Work collaboratively with MIS, Data Management, and Financial Reporting to validate the data lineage and logic is accurate.
• Work with upstream (data sourcing) applications (like Enterprise Business Registry, Enterprise Name, Legal Entity Service, Commercial Credit Management System, Trading Credit Analytical Layer etc..) to conduct data analysis and understand the current Client Reference data, Product level data to carve out the FBO (European exposures) related exposure to report under IHC level as required for FBO SCCL extract.
• Cross verifying quarterly data and sources of FR Y 2590 with others like FR Y 9C, FR Y 11 and FFIEC009 reports and all other BHC reports, along with supporting work papers, variance analysis
• Regulatory Reporting Quality Assurance department is responsible for various training programs in relation to regulatory reporting. Arrange the various training programs with different target audiences, and pursue higher quality of regulatory reporting as a result of those trainings
• Development of Process Documentation
• Maintain a working knowledge of enterprise data warehouses for the purposes to automating regulatory reports.
• Built interface to import FXNDF trades data into Calypso from SS and generate Risk Models for these exposures out of Calypso to SQL server reporting system, core banking counterparty exposures.
• Worked closely with Back Office Operation Desk to come up with configuration required to support FXNDFs in Calypso.

Confidential

Responsibilities:

• Reviewed document provided from Siebel team (data migration team) and provided report on migration process.
• Generated documentation of the customer requirements and project plan (functional specification, time management and coordination).
• Designed and developed CRM solutions with Dynamics CRM Microsoft and monitoring all the project stages.
• Used CRM web service and developed a custom service using Windows Communication Foundation to provide extended functionalities to the common methods of Dynamic CRM
• Led training and education sessions for the stakeholders of the customer enterprise (training material, guide and presentations).
• Designed and Analyzed the requirement for this project which has database as AS400, SQL server and data warehouse as data source
• Used various kinds of Filters, List reports, Cross tab and sub queries. Used Visio for creation of logical E-R Diagram before creating the Catalog
• Created a dashboard for merchandising department to have a display of all the aspects of the merchandising report, which is roughly a combination of eight reports and few extra fields.
• Assessment of website’s architecture, usability as well as design of user. Define site structure and create site maps for front end Wireframing.
• Identified gaps in migration process and documentation and discussed with key business stakeholder regarding possible short comes.
• Presenting designs to cross-functional teams and negotiate trade-offs
• Managing all aspect of projects, including scheduling, ensuring milestones are met, tracking issues, and making design recommendations
• Conducted JAD session with data migration and provided information on integrity of data.
• Produced Standard Practices and Policy guideline for Data Migration for New York state department
• Provided reports to key business stakeholders

Confidential

Regulatory Functional Business Analyst

Responsibilities:

• Working on report deconstruction for all regulatory and risk reports and map line items to physical database.
• Utilized Axiom technologies and Casewise for automation of workflows like process flow, data flow, data narrative, process narrative for implementing BCBS 239 data quality.
• Created guidelines to automate key risk reports and use of various tools eg tableau in automation.
• Automated couple risk reports as pilot from OFSAA to Wdesk (reporting tool).
• Facilitated end user request into variances and anomalies with FTP processing for determining risk appetite for wholesale loan portfolios.
• Overseen developing and maintaining analytics around digital banking properties including dashboards, penetration monitoring, business cases, risk assessments and system performance metrics
• Worked on OFSAA Application for creating members and hierarchies and for running the predefined batches process in order to populate the resultant tables.
• Conducted data mapping and lineage effort for key Business elements.
• Performed an equity valuation by analyzing comparable public companies and building a pro forma financial model in the cloud-computing also using OATS and CATS.
• Produced process flow and data flow documents for key business elements.
• Implemented and validated data quality control on process and data flow.
• Assessment of risk and identification of provisioning points in flows.
• Conducted sessions to define key business elements in accordance with risk infrastructure frame and guideline and maintained KDE in abnitio.
• Prepared BRD for BCBS 239 requirements and automation for pilot reports.
• Worked on definition of key business elements and maintain data dictionary in collibra and abnitio. analyze & document all Finance requirements, liaise with IT developers to communicate requirements, plan/coordinate all user testing, coordinate implementation/migration, communicate to project leadership
• Prepared BRD's for Enhancement and test environment when developed by Misys Loan IQ
• Managed testing environments requirements and created comprehensive testing scripts for a project involving the addition of new enhancements in Loan IQ. Also created general regression scripts in Loan IQ for use in major software upgrades.
• Interpreted impacts of new regulatory requirements on existing market and credit risk processes from a data perspective
• Helped establish the design principles, methods, deliverable templates for data definitions and data management requirements validation, data analysis and functional design of large, complex, front to back projects, then work with developers, testers and PMs in risk reporting, as well as other teams to drive the project through to release
• Created and maintained Fireworks templates for the company name usability team Risk analysis team. Extended Fireworks functionality by creating custom Flash object state and style sheet panel for use by company name usability team.
• Gathering and analyzing user or business requirements as well as developing, modifying and enhancing advanced reports using Cognos 10/11 and related components such as Report, Metric, Query, Event and Analysis Studios

Confidential

Business Analyst

Responsibilities:

• Working as program manager Developing, implementing and managing annual enterprise risk assessment and the organization action plan to address enterprise risks.
• Written Data quality control specifications for manual data quality checks.
• Overview and validation of data from OFSAA to risk reporting MRR (operational risk)
• Centralized all business element using technical metadata and business metadata using Collibra and abnitio.
• Expert knowledge of Axiom objects like Data Source, Data Model, Aggregation, Portfolio, internal risk, free form Reports and Tabular Reports
• Used Axiom SL controller view to develop, modify and support Regulatory Financial Reporting for banking institutions.
• Overviewed monthly fund transfer pricing (FTP) process, LIBOR Transition and worked with methodology manager to determine methodologies and leverage those in risk assessment of portfolios.
• Responsible for providing support in facilitating cross-team coordination and ultimately help to develop credible enterprise LIBOR transition plans
• Reported directly to high-level executives on reporting and Line of business.
• Conducted requirement gathering sessions to understand source data for consumer, commercial and small business credit cards and how they map to the CCAR credit card monthly (M) schedule.
• Performed source to target data mapping from multiple sources (Loan Origination system, FDR and TSYS - loan servicing system) to CCAR credit card schedule. Included CCAR mapping documents, metadata, reference tables etc
• Successfully organized and planned quarterly Steering Committee meetings and CCAR reporting from various business units domestic and international.
• Managing cross line of Businesses from regulatory reporting prospective.
• Reporting to Senior Executive committee on BCBS 239
• Conducted internal system audits and partnered with key stakeholders, Legal, Business leaders to ensure compliant recertification of Business systems and programs resulting in compliance with regulations.
• Check Basel III calculations and capital adequacy, transformations written in Python code.
• Involved in Planning, training employees Developing a clear vision of the program context and objectives and consistently ensuring that Finance's needs are being well served.
• Understanding and communicating the business justification for the program & sub-projects.
• Ensuring effective coordination of all resources involved in the program, focusing in on identifying and managing interdependencies between groups.
• Managing stakeholder expectations, particularly as they impact Finance and ensuring that all groups' requirements are being met by implementing the solutions we are developing.
• Created Master Data (MDM) it’s required to cleanse and standardize data. For example: Suppose from one source system some data is been loaded, which have some special character in first name. MDM tool removes these special characters and loads the fresh and clean data. This process is called data cleansing. To test data cleansing functionality we develop SQL queries with regular expression checking.
• Overview Microsoft Dynamic CRM reports and risks related incidence and determining the appropriate actions for resolution
• Use the technology stack surrounding Dynamics CRM (HTML5, WCF & SSRS) to further enhance client solutions
• Design, architect and create complex and multi-threaded integrations between CRM and other applications
• Creating and validating FR-Y 14a and Q reports. Process Documentation to demonstrate the data flow of information into and out of Capital (Lineage), End to End Process Mapping and created lineage for specific source systems and maintaining KDE using abnitio.
• Data warehousing for Regulatory and Risk reports includes data mapping from source to target and establish reg. data repository
• Undertaking procedure/policy documentation writing experience in the data governance/management area, risk/compliance reporting for Basel III standard and advance.
• 8+ years experiencedeveloping and enhancing the Financial Reporting&Analysis Job-CostingAnalysis,Completion Cost analysis, and compliance reports.
• Map END TO END and metadata for regulatory reporting FFIEC 101, FR-Y 14,FR-Y9C and maintained
• Undertake Procedure/policy documentation, process flow (RPA) writing experience in the data governance / management area, Risk/Compliance reporting for Basel III standard and Advance.
• Carry out Metadata and data quality control for market risk, credit risk, interest rate risk, counter-party risk, liquidity risk, operational risk, inflation risk, and systematic risk data.

Confidential

Senior Regulatory Business Analyst

Responsibilities:

• Worked on creating and validating FR-Y 14 a and Q reports with sql server reporting services.
• Monitor the Control - M jobs to make sure the SLAs are met using APP-View.
• Analyzed and design of CCAR (FR Y-14A schedules of Income statement and balance sheet), FR Y9C (few schedules), report requirements in AXIOM.
• Developed CCAR data models for wholesale commercial real estate and oversee model development, validation, and deployment efforts including integresion and UAT testing.
• Worked with large datasets and complex algorithms to solve data science challenges
• Ensured the CCAR stress Scenarios and compliance of development and validation of data models tables with respect to internal audit and external regulatory guidelines
• Developed business and functional requirements and obtain timely sign-off by all respective parties. Developed good practices for risk modeling procedures related to CCAR/DFAST (Dodd-Frank Act Stress Test).
• Overviewed Implementation of OFSAA solutions for FSDF, PFT, Liquidity Risk, and GL Recon for Advanced and Standardize Approach.
• Worked with high level business stakeholders to test FTP system (LIBOR) for model validation (Ad hoc work), worked with LOBs to create ad-hoc pricing scenarios.
• Using MDM resolved Data quality issues caused by inconsistency and redundancy in master data elements like items, vendors, customers
• LIBOR driven products and/or how LIBOR as a benchmark rate operates and drives products, interest rate derivatives and fixed income markets, commercial banking and business loans.
• RWA calculation validation and change request to python 2 based codes.(ad-hoc work)
• Worked on well-known Commercial Lending product Misys Loan IQ on all modules from Risk calculation prospective
• With team created operating model and detailed valuation model for target’s print and digital business components and buyout of minority stake and equity control option in target’s ownership of an online dealer using OATS (Ad-Hoc work)
• Management of volumes of data produced by multiple applications and information sources though MDM and business element using abnitio.
• Process Documentation to demonstrate the data flow of information into and out of Capital (Lineage)
• Responsible for implementing BCBS 239 and creating data quality control
• Gathered CCAR PPNR and supplementary metrics (FRY 14) forecast from different business units also Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems
• Performed CAPs review, preparations, CCAR validation and CCAR CAP's Quality Assurance and took key initiatives to identify data gaps and potential areas of improvement in report preparation process for Basel compliance.
• End to End Process Mapping and created lineage for specific source systems and lobs
• Document Business Metadata for regulatory requirement, Creating Technical Metadata using Collibra Ab Initio.
• Creating Data Controls Templates and control for Table and Attribute level
• Document Data Controls in place across the end to end data flow
• Identify gaps in the current control based on the minimum required controls per the standards
• Identify Control opportunities above and beyond the required controls, Close identified gaps in the Controls
• Procedure/policy documentation writing experience in the data governance / management area
• Risk/Compliance reporting for Basel III, Basle III standard and Advance.
• Worked with Business Users, Customers and Subject Matter Experts (SMEs) to understand the existing system and the current business process and methods to identify deficiencies and areas for improvement and enhancement.
• Interacted extensively with customers and UI designers to determine ways to improve the UI feel and the user experiences. Documented the gathered business requirements into detailed Business Requirement Documents (BRDs) for Basel III and its Addendum.
• Translated Business Requirements into functional and non-functional requirements using industry standard documentation processes like Data Flow Diagram (DFDs) and UML Diagrams (Use Case, Sequence and Activities Diagrams).
• Worked on market risk, credit risk, interest rate risk, counter-party risk, liquidity risk, operational risk, inflation risk, and systematic risk
• This included leading and/or overseeing credit scoring/risk rating model development and BB transformation projects in support of key risk factors and strategies to mitigate these risk factors
• Stress testing methodology development. This would include development of Stress testing impact analysis and documentation of results for presentation to Senior management, interal Audit Board and Regulators.

Senior Application Developer

Confidential

Responsibilities:

• As a Senior Business Analyst, contribution to strengthen of Risk, Regulatory and Compliance practice.
• Contribution to strengthen and develop DW&BI (Data Warehouse & Business Intelligence) Center of Excellence.
• Design and development of OBIEE 11g RPD layer, dashboards and reports
• Develop the source to target mapping documents and ETL code to load data from source to target warehouse
• UI Developing workflows, user task analysis, personas, interaction flows, wireframes, low fidelity mock-ups, navigational flows, and high fidelity prototypes
• Information Architecture: creating information architecture and website organization would be a plus
• Create technical documentation for all new or modified objects
• Worked on formatting SSRSreports using the Global variables and expressions.
• Createdparameterized reports, Drill downandDrill throughreports using SSRS.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Unit test data loads and write scripts for data validation
• Design and configuration of Tableau sites, projects and corresponding security, ETL processes, dashboards and reports
• Support QA, UAT and performance testing phases of development cycle
• Understand and incorporate required security framework in the developed OBIEE and ETL objects
• Gathered requirements using Use Case analysis and Developed system requirements (SFD, HLD, SRD) from business requirements (BRD) and architect approach documents.
• Created requirements and design phase artifacts using RequisitePro.
• Analyzed and maintained business and systems requirements over SOA based applications.
• Performed the data mapping for the new Web services elements between Front end, Middleware & Back end systems.
• Participated Agile-Scrum story writing secessions and wrote executable stories for the projects assigned.
• Participated in Iteration planning secessions and added the stories & Technical tasks in Jira.
• Acted as liaison between Requirements Engineers, Developers & Testing Team to determine RTM in traceability.
• Worked on preparing metadata for regulatory reporting FFIEC 101, FR-Y 7, FR-Y7Q, FR-Y 14,FR-Y9C, FR-2248,FR 2236, BQ1,BQ2, BL1,BL2, AND on other regulatory reports.

Confidential

Senior ETL Developer

Responsibilities:

• UNIX to check the Data marts, Tables and Updates made to the tables.
• Gathered CCAR PPNR and supplementary metrics (FRY 14) forecast from different business units also Supported CCAR and BASEL data acquisition teams to validate and reconcile data coming from various systems.
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008database and configuration of Report manager.
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Performed CAPs review, preparations, CCAR validation and CCAR CAP's Quality Assurance and took key initiatives to identify data gaps and potential areas of improvement in report preparation process for Basel compliance.
• Strong knowledge of data warehouse architecture, OFSAA internal architecture and experienced in dimensional modeling on data modeling tool (ERWIN).
• Managed and utilize Business Intelligence platforms for reporting, forecasting, and implementing proactive strategies to increase asset value using EAM
• Validated codes for FTP calculator created by reverse engineering the QRM method for FTP purposes, advised ECR (enterprise credit Risk) and Market Risk LOBs regarding changes in FTP and Market pricing and adjust pricing model minimums accordingly.
• Managed and work with onsite/offshore team to plan and execute automated regression testing and provide results & defect updates to higher
• Translated business requirements into functional specifications. Designed and developed process flows for ETL to load data to the data warehouse.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin.
• Worked with Enterprise Architects to do dimensional modeling for the data warehouse. Developed Fact and Dimension tables implementing Star Schema in the data warehouse
• Extracted Erwin physical models into repository manager using Informatica Power Plug.
• Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracle 10g, SQL Server 2005, MS-Access and loaded data into Oracle using Informatica PowerCenter.
• Basel III calculation validation using Python code.
• Worked on Wholesale ECRIS, IRR, Enterprise Risk, Enterprise Capital Management data sets, equity valuation CATS
• Enterprise provisioning standards, metadata and lineage, Process controls and data quality
• Data Migration from source to Hadoop and to ETL staging, CCAR - Post Stress test capital ratio
• Regulatory capital Calculations, Data migration from Source to ETL stage, Creating procedures for forecasting modeling based regulatory requirement.
• Using MDM, data consolidation by linking all of an enterprise’s critical data to one file called a master file that provides a common point of reference
• Data cleansing and matching to lower redundancies that identifies data quality issues, eliminates duplicate data records, identifies data elements in master data structure through data normalization, and also maps existing data to new master data structure
• Oracle OBIEE 11.2g and BI Applications product to develop industry solutions with pre-built dashboard, custom data model and sample data from ETL. (2)FSI Solution: Install and config OFSAA product based on banking’s business scenario, and integrate with other ERP and Microsoft Dynamics CRM systems.
• Creating required functions and integrating into procedure, Creating tables, loading data into tables
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Actively participated Functional, System and User Acceptance testing on all builds and supervised releases to ensure system / functionality integrity.
• Data quality check for performed migration or data load.
• Running procedure and VAPS to calculate derived values in DRV tables.
• Debugging codes and provides fixes to the procedure or function.

Confidential

Sr. Business System Analyst

Responsibilities:

• Develop and review Business Requirement Documents (BRDs), Functional Requirements document (FRDs) and other documents as part of the project life cycle.
• Develop business and functional requirements from stakeholders and legacy code bases.
• Participate in meetings with the appropriate subject matter experts to receive specifics on requirements for capital and equity calculations.
• Ensure that high-level business requirements have been decomposed properly into useable functional requirements
• Process Modeling Sessions & JAD Workshops Lead efforts in identifying Analyzing, defining, documenting and translating High-level business requirements into clearly articulated, detailed functional specifications, Lead efforts in Creation of Business Process Flow Diagrams.
• Designed the project development plan based on Agile methodology of SDLC.
• Perform analysis to determine and verify business requirements and functional design
• Worked with ASP.NET 3.5/3.0/2.0 Web Forms, Win Forms, Web Services, and Caching features, configuring optimizations and securing the web application.

Confidential

Sr. Business Analyst

Responsibilities:

• Defining Business & Information requirement using Agile Methodology.
• Interact with the Business team for Requirement Elicitation & Validation
• Business & Data Requirement Documentation
• Define Business Definitions & Derivation Logic for Data elements
• Work with the Technology teams and guide them on core domain concepts & Regulatory guidelines
• Worked on data Migration from EDW database to TERADATA.
• Used agile methodology for logic implementation for Mortgage Banking attributes.
• Involved in JAD sessions for defining logic and process.
• Prepared data lineage and data mapping documents
• Tested data and validated data from EDW to Teradata Migration.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Participated and overseen full end to end implementation of ISO27001 2013 framework and ISO27002 code of practice.
• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata
• Developed complex mapping using Informatica PowerCenter tool.
• Extracted data from Oracle, Flat file, Excel files and performed complex joiner, Expression, Aggregate, and Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Works directly with the project manager, technical resources, and partners to best support business needs.
• Gathers, manages, and maintains business requirements.
• Gather/analyze requirements, create designs Including Conceptual System, Architectural & Deployment Views.
• Reviewed functional and non-functional system requirements and constructed a conceptual design and detailed designs that align processes and technologies to achieve business objectives.
• Writing advanced SQL Queries to query the data from Data marts and Landings to verify the changes has been made.
• Involved in writing SQL queries and stored procedures using Query Analyzer and matched the results retrieved from the batch log files
• Created Technical specifications for the Business Objects Reporting Applications.
• Generated reports through Business Objects and further analyzed data through Excel Used Pivot tables, Vlookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• Identifies, analyzes, and translates business needs into functional specifications

Confidential

Sr. Business Analyst/PMO

Responsibilities:

• Directly reported to higher level stakeholders (Sr. VP and CIO)
• Expertise as OFSAA consultant in implementing and upgrading risk, performance and compliance applications using OFSAA in banking industry. Demonstrate technical knowledge for software implementations including activities around field to field mapping data mapping, conversion validation, system and security configuration, user acceptance testing, and system integration testing; and understand priorities, scope, timeline; develop and customize Rules, Scenarios, User Interface and workflows in AML, KYC and RRS solutions; deliver high - level presentations to audience ranging from executives to business users on OFSAA risk models and compliance application; and prepare design, process flow and architecture document as per OFSAA application.
• Involved in Informatica MDM hub configuration, IDQ cleanse function implementation, Hierarchy Configuration in MDM hub.
• Worked on risk calculation on european portfolio in line with the European Banking Authority (EBA) guidelines on the SREP process RPA,3 as well as the BCBS 239 principles
• Developed complex mapping using Informatica PowerCenter tool. Extracted data from Oracle, Flat file, Excel files and performed complex joiner, Expression, Aggregate, and Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Provided guidance and oversight, as well as hand-on development and execution, for all digital products and services and ongoing enhancements
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Asset Lifecycle Management - provide accurate and timely supporting data to enable optimal decisions on asset deployment, management and retirement/disposition
• Writing PL SQL Procedures for entire program (Data compare source to target) and its functions.
• Wrote SQL queries for data validation on the backend systems and used various tools like TOAD &DB Visualizer for DBMS (Oracle).
• As a Data analyst, worked on automating all source systems for Data Quality Check (QRM).
• As data Analyst, I was Responsible for testing for my source system in each release.
• Developed risk infrastructure and data warehousing that included data mart, schemas, tables and columns for each source systems.
• Created metadata for PNC business element for report FFIEC101.
• Creating filters and joining criteria for tables.