PROFESSIONAL EXPERIENCE

Sr. Data Analyst

Confidential

Responsibilities:

• More all 9 years of professional experience as a Data Analyst in Finance/Banking Domain.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Proven success as a data analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Deep understanding of enterprise data warehouses.
• Strong experience in RUP Business Modeling process.
• Expertise working on Waterfall and Agile. Also, have performed various roles as a Scrum Master.
• Well versed with client server environment and tools like SQL*Loader, UNIX shell scripts and TOAD
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short- and long-term business and system requirements.
• Worked on GAP Analysis for RDR and HUB Tables for each source system populated in RDR and HUB.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team.

Sr. Data Analyst

Confidential

Responsibilities:

• Facilitated Joint Requirement Planning (JRP) sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Participated in the ETL migration ETI to DataStage and in the DBMS migration Oracle 11g to Teradata
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues for Basel II Credit Risk Mitigation System (CRMT)
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, Abinitio Graphs and Teradata scripts
• Created context sensitive on - line help files for a wholesale banking software. This involved creating animated help screens, writing RTF files, capturing screens, creating hotspots and compiling help files.
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Assisted in the collection of financial data and conducted data mining
• Performed data profiling on datasets with millions of rows on Teradata environment, validating key gen elements, ensuring correctness of codes and identifiers, and recommending mapping changes.
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance
• Involved in supporting over the counter (OTC) derivative trade capture and straight through processing (STP).
• Extensively involved with the trading activities of Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives; and Futures including Commodity Futures Contracts and Financial Futures
• Evaluated Competitors offerings and products including fixed income and derivatives
• Utilized Enterprise Service Platform (ESP) for creating categories/elements, and data marts for the OLAP application in order to meet the compliance reporting requirements.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business use
• Performed ETL Informatica development task's like creating jobs using different stages, debugging etc.
• Work with business users and banks for loan data related issues, loan quality issues, and fraudulent loans; Being the liaison between business and technical teams, work with several internal teams involved for interfaces, and different groups like development, testing, change requests, production team, for processes involved, and getting issues resolved on time
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked on GAP Analysis for RDR and HUB Tables for each source system populated in RDR and HUB.
• Interacted with users for verifying user requirements, and change control process, updating existing process flow, FRD and TDR documents.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage
• Analyzed application requirements with UML modeling (MS Visio) and documented Dialogue application output management and FileNet Enterprise Content Management solutions
• Worked with SQL and Data Warehousing for arrangement of customer data.
• Heavily interacted with Data Warehousing team in Metadata Modeling and gathering requirements for product catalogue data load specifications for Data mapping and Data Modeling.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Performed the physical database design, normalised the tables, worked with Denormalised tables to load the data into fact tables of Data warehouse.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Assist the technical team in translating application functionality into application architecture and the production of a System Functionality document
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Prepared UML Diagrams such as Activity, logical, Component and Deployment views to assist development and engineering in understanding the requirements using Rational Rose.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.

Data Analyst

Confidential - Columbia, MD

Responsibilities:

• Collected and evaluated business requirements, functional specifications, project schedules, documentation and test plans.
• Launched the business requirement collection approach based on the project scope and SDLC Methodology.
• Involved in Scrum Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, Daily Stand - ups, User Stories and Acceptance Criteria.
• Created functional specifications and design requirements for integration of current Wholesale Management System with Dealer Loan System to meet business requirements.
• Evaluated data profiling, cleansing, integration and extraction tools (e.g. Informatica)
• Developed new ETL mappings according to the requirements using Informatica PowerCenter.
• Analysed legacy systems' tightly controlled reporting mechanisms, data catalogues and data dictionaries; documented gaps between SORs, Teradata and integrated regions.
• Tested ETL mappings using Informatica to support the reporting data mart.
• Worked with data quality governance teams to ensure each work-stream and project within the Prohibited Proprietary Trading framework adhered to strict data quality and maintenance standards.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management
• Utilized Data Warehousing technique to store important data and wrote SQL Queries in Oracle Databases.
• Record requirements and business process information via interviews with key business users.
• Analyze and validate quality and accuracy of the production data also analyzing and validating built-in business rules and processes in above data warehouses programs.
• Set up market data including zero curves, correlation matrices, dividend curves, etc., and the underlying financial instruments and then set up derivatives pricing parameters and trade capture options that drive the valuation of trades based on the market data to configure and test the system
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Co-ordinated Golden Gate replication process for transitioning data from source systems to target Enterprise Servicing platform (ESP) for regulatory and business reporting and analysis
• Involved in testing all the data elements in RSIs Mortgage Account Inquiry Service, which is called by CCW to obtain Mortgage loan data from MSP.
• Performed data profiling by running SQL queries in Aqua data Studio to verify if the data fields are correctly populated in the RDR and HUB, as per logic in the mapping documents.
• Directly interacting with the Stakeholders/Business Managers and served as a primary point of contact for Data warehousing and Cognos reporting solutions depending on project requirements.
• Comprehensively work with requirement gathering for Enterprise reporting system using RequisitePro.
• Tested Loan Originating System (LOS) application on FileNet
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk
• Wrote and maintained Business Requirements Documents BRDs and Functional Requirements Documents FRDs defining new systems operations for the Online Banking project using Rational Requisite Pro
• Work on the Data Modeling, Entities and Attributes of the Data points and Templates. Building APIin XML based on the requirements.
• Developed business process models in RUP to document existing and future business processes.
• Performed extensive requirement analysis including data analysis and gap analysis.
• Developed business requirement specification documents as well as high-level project plan.
• Implemented QA testing and report/data validation with basic SQL queries.
• Developed requirement reports for day-to-day retail banking needs for opening account, online baking using Rational SODA.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, and process and revenue streams.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Worked with ETL developers for creating real-time data interfaces and DB extracts (ETL Design).
• As necessary assisted with the process of identifying and recommending vendors, and assisted with the vendor relationship.

Data Analyst

Confidential - Jersey City, NJ

Responsibilities:

• Developed Banking Web Portal Application for Mortgage and Retail Banking
• Involved in the Activities of Data Profiling, Data Integration and Data Quality
• Delivered Enterprise Data Governance, Data Quality, Metadata, and ETL Informatica solution
• Worked on the ETL Informatica mappings and other ETL Processes (Data Warehouse)
• Implemented Data Modeling standards, including element - naming conventions.
• Developed strategies for the Data warehouse, while managing the data quality/integrity in the Data warehouse
• Transferred data with SAS/Access from the databases MS Access, Oracle into SAS data sets on Windows and Unix.
• Planning & scheduling of Teradata hardware and network updates on Pershing infrastructure
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Check for the valid values if its populating correctly in RDR and HUB tables
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Produced system documents, functional requirements, ETL Informatica mapping and modeling deliverables using Kimball dimensional modeling methodology and ERWIN toolset.
• Apply custom changes to Calypso software in order to replicate vanilla and exotic OTC derivative products
• Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing
• Conducted cash trade, repo and pair-off settlements (FED & DTC, Broadridge)
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Identified research, realize, investigate, analyze, define and document business processes and Use Case scenarios.
• Performed GAP Analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Conducted Workflow and Process Diagram to derive requirements for existing systems enhancements.
• Assisted with User Acceptance Testing of Systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Worked with development and testing teams to accomplish Timely Release Objectives.
• Using detailed knowledge of application features and functions assessed Scope and Impact of business needs throughout analysis and completion of all enhancement specifications.
• Developed Use Case Diagrams, Activity Diagrams based on Object-Oriented Design (OOD) using Rational Rose according to the UML methodology to define business processes.
• Using detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all enhancement specifications.