We provide IT Staff Augmentation Services!

Business Analyst Resume Profile

2.00/5 (Submit Your Rating)

NJ

SUMMARY:

Senior Data Architect, Data Scientist, Data Analyst with extensive experience in Data Management disciplines such as Data Warehousing Business Intelligence, Reference data MDM, Product Security Masters, and Client Masters and Data governance. Specializing in analytics, data management for business functions like Market Risk, Credit Risk, Liquidity Risk , Basel III and CCAR. Strong project and program management skills with excellent communication skills, featured speaker at several conferences. Strong analytic and problem solving skills, ability t build relationships at all levels of organizations.

Additional Specializations in:

Data Architecture

Data Quality

Reference Data MDM

BI/Data Warehousing

Data Integration and ETL

Data Governance

Project Management

Business Data Analysis

Business Process Mgmt BPM

Summary:

  • Over 20 years of diversified Financial Services experience including Big 4 Accenture, PWC and Ernst Young . Extensive experience in managing and delivering large scale Data Management initiatives.
  • Extensive experience in Reference data Customer and Product security master and KYC using tools like Golden Source, Gold Tier and other custom architecture solutions e.g. federated architectures with pub/sub distribution
  • Extensively use IBMs and Teradata FSLM Financial Services Logical Model .
  • Extensive experience in Financial Service industry related t - Credit Risk, Market Risk, Market Risk, Credit Risk, Liquidity Risk , Basel II/III , CCAR.
  • Successfully implemented several large engagements related t business, information and solution architectures that included Big Data , Data Warehouses, Data Marts, OLAP, Business Intelligence BI tools, Enterprise Application Integration EAI , Service Oriented Architecture, Web Oriented Architecture.
  • Extensive experience developing the architecture t support the Data Quality Life Cycle, including data profiling, quantification of data quality impact, implementation of data quality capabilities and ongoing monitoring of data quality.
  • Experience in Data Analysis, Feed Analysis, Data Mapping, Data Modeling, Data Reconciliation, Data Entity Relationship Diagram, Normalization and strong understanding of Relational DBMS. Extensive experience in analyzing and documenting business requirements and system functional specifications including use cases.
  • Expert level experience in managing large volumes of data and addressing complex data integration issues for various backend legacy environments - including both mainframes and open systems.
  • Extensive experience in Business Analysis, Business Process Management BPM , Testing Management. Skilled at analyzing business needs and transforming them into technical designs, applying technical skills and business knowledge to achieve sound results
  • Project/Program: Agile/Scrum, Iterative development, PMP, Budgeting, Prioritization, Change management, MS Project, JIRA, Process Improvement.

Experience Highlights Worked for some of the following companies:

  • UBS Director of Global Data Management Services
  • Bank of America- Merrill Lynch Vice President Enterprise Risk Group
  • Unisys Management Consulting Director Analytics practice lead- Capital Markets
  • Accenture Associate Partner Analytics practice lead- FS - Banking
  • Other Big 4 PWC and Ernst Young

TECHNOLOGY EXPERIENCE:

Category Technology

Languages

PRO C, PL/SQL, SQL

Data Quality Tools

Dataflux, Trillium, Siperian

Financial Data Models

IBM and Teradata FSLDM FS Logical Data Model

MDM Security Master

Siperian, Goldtier, Golden Source

Data Warehouse ETL

Ab Initio, Informatica, Awk, Pearl Unix scripts

Data Warehouse/ Business Intelligence BI tools

Cognos, Information Advantage, Brio, Business Objects, SAS Prime Response

Databases

Oracle , Sybase, UDB/DB2, SQL Server 2005, Netezza

Development Tools

Rational Rose UML , ERWIN, Embarcadero, Visual Caf , Visual Studio, SilverRun, Designer 2000, Developer 2000, Toad

TIBCO, UXEDO, MQ-SERIES, Web Methods

ERP

Oracle Financials, A/P, A/R, G/L, PO, Financial Analysis Reporting

Data-Modeling Techniques

Data Warehouse designs, Star Snowflake designs, Logical Physical designs devices

Project-Management Methodologies

Agile Scrum, Lean Six Sigma, Kimball's DW Full Life Cycle Methodology, Inman's ODS Implementation Methodology

EXPERIENCE:

Confidential

Data Architect/ Solution Manager: Risk Management

  • Managed multiple data management initiatives for risk management group that deals with Market, Credit, Liquidity risk, IT and Capital Markets Product Business Areas Collected business requirements, built consensus and played a role of a liaison between business and IT Conducted JAD session/ Workshops with IT teams t explain the requirement and provide clarification from business/ analytical requirements perspective Used Agile/ Scrum methodology.
  • For Market and Credit risk implemented of Central Data Warehouse. Collected the business requirements/ data requirements, designed the ETL process and Star schema, and generated logical /physical data models. Built OLAP/BI business intelligence tool t view and report the data by positions, counterparty, market data, reference data/ security master and additional risk attributes like VaR, exposure and credit limits built complex extraction and transformations with data quality checks. Performed the reconciliations between the source and target data sets. Leveraged IBM's FSLM Financial Services Logical Model for conceptual and logical model designs.
  • Conducted detailed business analysis and completed the process maps for Basel III Liquidity risk ratios LCR and NSFR Implemented an ODS operational data store t integrated the cash flows by asset classes and performed the netting and aggregation logic t get the 30days out cash flow leg calculation which is further leveraged by CCAR calculations. Conducted end t end stress testing with various scenarios and test cases.
  • Performed data analysis, feed analysis on the staging and data warehouse using complex queries and reporting tools. Mapped business functions t underlying data and data models, performed data reconciliations, gap analysis at function and data level for Basel III and CCAR reporting.
  • Implemented the Data Governance/ Data Quality program for various source systems that are used for Basel III Capital calculation and CCAR reporting Implemented a data reconciliation framework/ architecture that enables researching root cause of breaks on assets/trades/positions for Credit Risk and Market Risk worked with respective IT team t resolve the issues such as data quality, netting errors, calculation errors, etc.
  • Worked with key stake holders such as Quant team for CVA and Counterparty Portfoli Management t perform detailed quantitative business analysis and data modeling, play a role of liaison t IT development team for implementation.
  • Implemented centralized data management capability using Big Data platform store and service Rules/ calculation engines/ models for Credit Risk, Market Risk and Liquidity Risk. Covered major asset classes in the trading portfolios: IRD swaps, swaptions , fixed income securities, MBS, cash equities , futures and options, FX, CDS Single name CDS and Index CDS

Confidential

Sr. Data Architect/ Business Analyst

  • Responsible for implementation of large data initiative for strategic equity and fixed income instrument security master MDM, pricing and data quality initiative.
  • Implemented product reference data for Equity and Fixed income products with Security Master containing over 17 million securities spanning across multiple asset classes
  • Defined the corporate data architecture strategy and led the implementation of the Security Master, which involved integrating data legacy sources, data modeling, data quality, workflows, using BI tools What-if scenari analysis and standard reporting.
  • Implemented next generation federated - MDM solution that directly attributed t benefits such as reduced data management costs, reduced integration costs and indirectly by providing incremental value t existing initiatives such as improved time-to-market, better data quality, reduced development cost, improved cross-functional view, reduced technical complexity with more process-oriented integration.
  • Collaborated with Quant modeling team t implement asset valuation/pricing modules for MBS securities.
  • Established data quality and governance framework t formalize data quality assurance program. This included identifying the data quality issues, building consensus with business and downstream system owners on the data quality issues and building a road map for business efficiency and cost savings.
  • Designed logical data model, source to target mapping of the market data feeds such as Bloomberg, Reuters, Telekurs, ADP, IDSI etc
  • Facilitated design sessions, JAD sessions t define and implement federated architecture for Fixed Income Securities Corporate Government bonds, Munis, ABS, MBS, CDs, etc. . Collected requirements from large number of downstream systems over 200 apps . For the mastering layer, implemented Business Process Management BPM workflow process for exception management, GUI and per Security and data distribution via messaging architecture.
  • Designed data warehousing and reporting layer, Star-Schemas with Dimensions, Facts, Hierarchies Developed Partitions t distribute data across multiple disk volumes.
  • Integrated complex backend sources, designed and developed ETL procedures.
  • Used Agile and Scrum methodology t iteratively define the iterations for building Security Master Reference, Resolved the data quality issues related t ISIN/CUSIP/SEDOL/RIC identifiers and securities data integration.
  • Develop governance and measurement processes/standards t present t the Senior Management and Executive Steering Committee.
  • Evaluated vendors and tools for end t end MDM solution related t Reference data integration. Prototyped solution with vendors like Informatica MDM Siperian .

Confidential

Senior Data Architect- Consultant

  • Senior Data Architect responsible for back office trade and position data warehouse re-platforming including collecting the requirements, defining the function architecture, testing.
  • Implemented the Data Warehouse solution which included collection of the business requirements, data requirements, data analysis, data mapping from source t target, ETL development, Data mart implementation with BI tools for business functions like Credit, Margin, Regulatory Compliance, Client Valuations, Treasury Finance, supporting mainly the middle and back office reporting functions.
  • Developed the star schema, logical model for trade /position and reference data platform t improve time t market.
  • Developed the overall data management and data migration capabilities t extract data from source legacy systems and transferred data using FTP t the Landing Servers t cleanse, transform and load in t the Data Warehouse and distribute it t the Data Marts with Star-Schemas.
  • Business Objects was used for ad-hoc analysis. The data mart was built using DB2 and with star-schema design with multiple subject areas having separate facts and dimension tables.
  • Implemented the dashboard to view the KPIs and evaluate measurable project benefits, i.e. increased revenue, efficiency and control track and present metrics analysis
  • Managed the integration of Oracle ERP package t the trade and position data warehouse.
  • Implemented metadata driven architecture thus providing the flexibility in sourcing strategy, managing large volumes of data and addressing complex data integration issues for various backend legacy environments. Leveraged the best practices for data processing, error handling, workflows, session management and cache management. Evaluated several MDM and reference data tools for sourcing, mastering and distribution of reference data.
  • Conducted the requirement analysis, developed the process flows, defined the functional architecture, and documented the FRD/BRD.

Confidential

Vice President Global Data Management Services Market Risk

  • Implemented Position data warehouse which had position data along with VaR, exposures, Greeks, counterparties, legal entities, limits, margins/collaterals.
  • Developed and managed the Data Acquisition strategy t deliver and manage the functions like data sourcing, data cleansing, data flow management, data de-duping, merging, data distribution and data quality.
  • Implemented reporting environment to report on exposure by facilities, collateral management by products custodians, credit limits reports by facilities industries and VaR reporting
  • Designed and developed BI tool for Compliance and client reporting, Risk Reporting, supporting the Basel II Regulatory reporting requirements.
  • Implemented the MDM solution for single blue print of Customer and Counterparty Master using Goldtier. Defined mappings, customer hierarchies, developed the customer data hub and Customer data integration CDI t clearing and settlement ODS.

Confidential

Vice President, Senior Data Architect Enterprise Risk Group

  • Managed the end-to-end implementation of Credit Risk Market Risk Data Warehouse to support several downstream applications, Quant analytics, Legacy Applications and Data Marts for reporting
  • Defined the corporate data architecture strategy and led the implementation of Risk Financial Data Warehouse, which involved integrating data legacy sources, data modeling, data quality, using BI tools What-if scenari analysis and standard reporting.
  • Re-engineered the Credit Risk Portfoli Management system t support advanced analytics, model development and reporting framework for regulatory and compliance.
  • Supported the economic capital calculations and analytical models for EAD, PD, and LGD.
  • Implemented the reporting environment t support reporting on Exposure calculations, collateral reporting, limits reports, liquidity reports, calculation of risk, etc.
  • Integrated commercial, retail and securitization data for BASEL II compliance and effective enterprise risk management.
  • Managed stakeholders, senior management and business unit leads by effectively communicating and running facilitated JAD sessions.

Confidential

Director - Analytics practice lead- Capital Markets

  • Responsible for data warehousing, data mining, customer relationship management CRM analytics, statistical modeling and marketing strategy, model implementation, marketing campaign analysis and BI reporting to support adhoc analysis
  • Worked with business and technology executives t define the product and customer reference data strategies. Evaluated several MDM tools, helping the senior management visualize the benefits of having a single customer hub strategy with linkages between the business processes, data architecture and infrastructure.
  • Facilitated JAD sessions with the business units t understand the business priorities and formulate the data strategy highlighting the various alternatives, build versus buy analysis, risk mitigation tactics, prototyping.

Confidential

Associate Partner Analytics practice lead- FS - Banking

Client: E TRADE Data Warehouse

  • Led a large Data Warehousing initiative t implement a Data Warehouse with 10 tera bytes of data using SMP architecture and integrated with online trading system.
  • Managed and designed the architecture with hands on involvement t support the development of customer Data Warehouse and Data Marts, used Oracle 8i, XML, Ab Initi ETL tool , and UNIX with SMP technology.
  • Integrating back-end legacy systems that consist of multiple AS/400 DB2, VSAM and COBOL and IBM 3090. Developed the data migration strategy and performed data extraction, data mapping, data cleansing and transformation t integrate and load it int the data warehouse.
  • The Data Warehouse supported various departments through three Major Data Marts,
  • a Customer Insight Data Mart with high performance demoralized Star-Schema data structures, was used by the Business Intelligence group.
  • b SAS Data mart used Teradata as the database, data extraction procedures extracted samples of data from the Data Warehouse to build models and
  • c Campaign Management Data mart that used Prime Response as the campaign management tool.

Confidential

  • Led the implementation of the architecture with multiple parallel initiatives related t customer data warehouse, data mining modeling environments for marketing and risk management, and data marts for customer management acquisitions, and collections.
  • The Data Warehouse architecture was designed t integrate cross functions of the retail banking business such as the Credit card marketing, Credit Card Finance and Collections. The architecture was built with 11 Terebytes of Data Warehouse using UDB database, SMP architecture with 120 RS/6000 nodes.
  • Developed the overall data management and data migration strategy t extract data from source legacy systems such as AS/400 DB2 and COBOL and FDR systems. Transferred data using FTP t the Landing Servers t cleanse, transform and load in t the Data Warehouse and distribute it t the Data Marts with Star-Schemas.
  • Business Objects was used for ad-hoc analysis. The data mart was built using DB2 and with star-schema design with multiple subject areas having separate facts and dimension tables.

Confidential

ERP and Data Warehouse

  • Responsible for end-to-end strategy and implementation of Data Warehouse and Oracle ERP.
  • Implemented the strategy and Vision t integrate several sil data warehouse environments.
  • Successfully implemented Oracle ERP package AP, GL, PO.
  • Conducted JAD sessions t collect requirements from various downstream applications.

Confidential

Data Warehouse and Business Intelligence

  • Led and managed the implementation of large data warehouse using Oracle t integrate data across various departments, thus eliminating redundancy and decreasing operation cost and improving productivity.
  • Integrated retail lines of businesses and supported a companywide relationship management business strategy.
  • Integrated systems t align with re-designed business processes.

Confidential

Data Integration and Analytics

Managed the out-sourcing development t build data integration platform for various financial systems t enable data interchange for the purpose of financial planning and forecasting across departments. Used proven methodology for requirement analysis, design, testing and deployment. The technology used was Oracle, Oracle forms, C and UNIX.

Confidential

Data and Resource Integration

Developed a blue print of the architecture t share resources across department at different geographical locations. Assessed the current architecture, facilitated several requirements gathering meetings and proposed the end state architecture.

We'd love your feedback!