SUMMARY

• 8+ years of experience as a Sr. Business Data Analyst in industry domains including Banking, Financial and Mortgages.
• Experience in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments, Data Extraction, Data Cleansing, Data Profiling, Data Mining, Data Consolidation, and Data Quality for various business data feeds.
• Extensive experience on Erwin and ER Studio in several projects in both OLAP and OLTP applications for Data Modeling.
• Expertise in Cleaning, Integrate, Transform, Reduce, Analyze and Interpret large sets of Data.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Normalization/De-normalization, Fact and Dimension tables, Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Excellent in managing Data Domain and Governance, procedures, execution and data integrity with development of data dictionary showcasing lineage.
• Domain industry experience in Regulatory, Credit Risk, Investment Banking, Financial and Commercial Industries.
• Extensive experience with AFS and ACBS (Advanced Commercial Banking System) data processing, system andbusinessanalysis, data mapping, testing, training, conversion, system upgrade,GeneralLedgerAccount balancing, and post-conversion support involving strong analytical and problem-solving skills.
• Proficient in MS Visio to carry out the business modelling, data modelling, and object modelling efforts to develop the business architecture for rapid and controlled application development.
• Performed data mapping by executed SQL scripts at the backend database level to ensure the correctness of the test results.
• Expertise in diverse retail banking sectors including lending, deposits, payments, cards, trade finance, treasury, regulatory reporting (BI), KYC, AML, payment system.
• Expert at Full SDLC processes involving Requirements Gathering, Source Data Analysis, Creating Data Models, and Source to target data mapping, DDL generation, performance tuning for data models.
• Extensively used Excel, SQL programming and Tableau for data mining, predictive & quantitative analysis, designing, reporting and visualization.
• Expertise in providing metadata management, end to end data lineage solution of organizations using Informatica metadata manager (IMM) and Analyst tool (IA).
• Proficient in multiple Business Intelligence tools such asPowerBI& Tableau.
• Expertise in Data ingestion into big data platform from different systems both Structured and Unstructured data.
• Experienced in Dimensional and RelationalDataModeler using Star Schema/Snowflake Modeling, Fact and Dimension Tables, and Physical and LogicalDataModeling.
• Experience in maintaining open communication with customers and private bankers to ensure proper and timely processing and submission of the mortgage application and TRID closings.
• Experience in providing mortgage clients with sound advice based on a full understanding of the client's needs.
• Experience working with Change Management function across Derivatives and Fixed Income Operations and Technology across Rates, Credit, Asset Backed Operations and Mortgage Backed Securities (MBS).
• Excellent understanding of financial instruments and requirements of Banking and Regulatory Compliances: Anti-Money Laundering (AML), Basel Accords, Bank Secrecy Act etc.
• Proficiently demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimum guidance and supervision.
• Extensive experience indatawarehousing tools and technology such as Informatica Power Center, Power Exchange, Metadata Manager, MDM, OBIEE,Qlikview, SSIS, SSRS, Micro Strategy, etc.
• Experience in documenting complete Graphical User Interface (GUI) fields name, type, background queries and access restrictions of an existing application using MS Excel, SQL and MSF Files.
• Experience in developing reports mock-up on MS PowerPoint.
• Experienced in writing SQL queries for enhancing application knowledge.
• Strong experience in the design and development of mappings, transformations, sessions and workflows in PowerCenter.
• Experienced in Handing the ETL process using tools like Informatica & DataStage.
• Experienced in handling large Metadata Repositories and creating Enterprise Wide Standards.
• Advanced Proficiency with Excel, Word, Blackline Financial Account Reconciliation application, Oracle & PeopleSoft General Ledger applications.
• Experience in converting legacy reports to more contemporary programs such as Crystal Reports, Business Objects, MS Excel, MS Access, and SQL, and condensing number of reports to simplify processes.

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr. Data Analyst

Responsibilities:

• Involved in developing 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).
• Manage the end to end change management process using Agile to enable Bank transition from SAS to Oracle Risk Platform.
• Implemented Data Modelling standards, including element-naming conventions.
• Involved in developing strategies for the Data warehouse, while managing the data quality/integrity in the Data warehouse.
• Exploring and examining the mortgage banking data coming from multiple disparate sources using BI tools such as Business Objects and using Tableau. This helps provide a competitive advantage or address a pressing business problem.
• Performing Data Pre-processing using the nature of the source system.
• Performing statistical analysis, data mining and retrieval processes on a large amount of data to identify trends related to Defaulting prediction model, figures and other relevant information.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model for Text Analytics from the Existing ICDW RMI data structures.
• Performed Text Analytics to analyze e-mails, surveys and written correspondence to identify customer complaints and metrics.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models, Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Performed due-diligence with the existing data in data warehouse, Generated ad-hoc SQL queries using joins, database connections and transformation rules to compare and evaluate the prediction models.
• Encapsulated new and existing Business Rules, based in industry standardized MISMO rules as well as tailored validation rules specific to Confidential
• Involved in requirements for interfaces for integration with multiple systems, defined how/what data would be passed in xml, how data mapping would be done for source to target systems integration, how source system would process the data from xml and map it on UI screens
• Involved in handling Source to Target Data Mapping, Technical Specs documentation, and ETL documentations such as Early Data Inventory, Data Profiling, Data Mapping, and Programmer Specs conforming to internal guidelines.
• Developed data stewardship program establishing metadata registry responsibilities
• Worked on Data Mapping using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling using tools like Erwin, E/R Studio and Sybase Power Designer.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling
• Worked on documenting reconciling financial data submitted by Servicers and Trustees for a mortgage loan servicing application.
• Proficient in executing SQL queries using Toad and Oracle SQL Developer. Comfortable in large data analysis using SQL/Excel/Access and GUI navigation design using MS office tools.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Involved in logical/physical database design and review sessions to determine and describe dataflow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application Architects.
• Modified VBA code in Excel to pull data from SQL Server and Teradata.
• Involved in meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Worked on Business Intelligence reports development efforts by working closely with MicroStrategy, Teradata, and ETL teams.
• Involved in data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Worked on functional requirements, ETL Informatica mapping and modelling deliverables using Kimball dimensional modelling methodology and ERWIN toolset.
• Generating reports by querying data in Teradata database for business users.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.

Confidential - NYC, NY

Data Analyst

Responsibilities:

• Worked on Data Domain Management and Data Management & Insight with business partners and technology managers to replace an overly complex, inefficient data management landscape to a simplified target state organized around data domains and new set of governance accountabilities.
• Reviewed data & respond in a timely manner to various, numerous lender & vendor questions/ requests in connection with closing loans and/or ongoing loan covenants; loan document review
• Worked with mortgage originations, servicing, loss mitigations and loan modifications
• Worked closely with Mortgage Specialist and Sales Opener to ensure that all information obtained on application is complete, legible and ready for underwriter review.
• Build detailed financial models to evaluate performance under various operating scenarios and to analyse the impacts of different capital structures, portfolio rebalance and analysis, compliance and credit research.
• Assisted and validated Loan data mapping across Empower application database (OLTP/ODS), Mortgage Data Hub (MDH), Servicing (MSP, MISER), Vendor XML’s and downstream applications (NXG, KYC) flat files.
• Worked on Metadata Management, Data Analysis, Data Profiling & Quality, Data Governance and Master Data management (MDM).
• Develop and establish IBM BPM Workflow Competency Center with services and SLAs, 24hr production pager support
• Facilitating and managing meeting sessions from business areas including Origination, Loan Processing.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Worked with multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere and Cognos.
• Involved in working on interfaces, xml data mapping, web services, integration on multiple interfaces
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling.
• Build Rules Engine and Decision Models for all translations from Legacy to MISMO attributes and MISMO to Legacy.
• Involved in creating DDL for physical model using Erwin and handed over to the DBA team.
• Worked on conducting meetings to present technology managers with information and requirements for the new Enterprise Data Governance (EDG) policies.
• Worked with Database Administrators, Business Analysts and Developers to conduct design reviews and validate the developed models.
• Involved in creating ETL using Informatica by applying best practices and error handling process.
• Involved in Target Data Mapping, Data Profiling, and Transformation rules for OLAP.
• Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Microsoft Word, PowerPoint, Access.
• Worked on data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering in E/R Studio tool.
• Ensured the data accuracy by comparing data checks at source data, database and on the reports.
• Involved in creating various Tableau visualization using Tableau Desktop applying the best practices of report design.
• Involved in data mapping between old data warehouse and new data warehouse (Teradata).
• Assisted with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Documented and track defects, as well as produced detailed report.
• Worked extensively with client requirements to generate customized SQL reports.
• Defined and reviewed the data warehouse requirements with the business users for getting the right data from source system to reporting purpose.
• Write custom SQL that takes marketing campaign definitions, rules and selection criteria and enables execution through Teradata.

Confidential - Cincinnati, OH

Data Analyst

Responsibilities:

• Regular interaction with Portfolio Managers and Research Analysts to understand the current spend trend and derive future trends.
• Used current spend pattern and future trend plots to arrive at the decision of which additional features to implement.
• Involved in writing complex SQL Queries which mainly was hooked up with backend testing.
• Involved in creating Data structures to support collateral related information.
• Build Data Control & Data Quality checks for the processed source data with improved data quality and comprehensive input & output database to support counterparty credit and market risk data.
• Involved in documenting mobile and web mortgage API process flows including configuration management and data mapping/points.
• Used Mega Tool as well as E/R Studio to create Conceptual Data Model. Mega tool was recommended by Enterprise Architecture team to ensure consistent Data Model quality across State Farm.
• Worked on the data flow from front end to backend and used SQL queries to extract the data from the database.
• Worked on transaction records using SQL queries.
• Involved in designing and maintaining the Logical /Physical dimensional data models and generating the DDL statements and working with the database team in creating the tables, views, keys in the database.
• Worked on Pivot tables (for handling dynamic data/tables for averages, Sum and other functions), Used Macros and created custom data validation rules, VLOOKUP, Array formulas in excel.
• Used Access Database with queries to pull data, created reports, exported data into excel sheet.
• Involved in the analysis of the existing credit card processing system and mapping phase according to the functionality and data conversion procedure.
• Worked with the seniors to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Worked on Data Analysis, Data Validation, Data Modelling, Data Profiling, Data Verification, Data Mapping, Data Loading, and Data Warehousing/ETL testing.
• Thorough analysis of available data sources to demarcate the reference data and master data. Designed data flow models to project flow of information from applications to both sets of data.
• Analysed the data using MS Excel, SQL and Access and generate different reports to gain more knowledge in about the business status.
• Worked collaboratively with Business Intelligence and ETL resources to design and develop effective solution.
• Worked on Business Intelligence reports development by working closely with MicroStrategy, Teradata, and ETL teams.
• Involved in creating daily report for the clients using Excel and Access according to the requirements for data validation.
• Used MS Visio to carry out the business modelling, data modelling, and object modelling efforts to develop the business architecture for rapid and controlled application development.

Confidential - Hartford, CT

Data Analyst

Responsibilities:

• Performed source data analysis, data discovery, data profiling, Business rules and data profiling.
• Involved in defining the source to target data mappings, business rules, and business & data definitions.
• Maintained data mapping documents, business matrix and other data design artefacts that define technical data specifications and transformation rules
• Effectively communicated data design to other members of the team to ensure proper implementation and utilization of the data structures; Support development team during process design and during performance tuning
• Involved in data analysis and Data mapping of existing reports to identify and document iteration and business metrics.
• Prepared Data Comparison tool by using VBA (Excel Macro).
• Worked on daily and monthly marketing reports including quantitative analysis of fund performance as well as exposure and attribution data analysis by sector, market cap and country.
• Worked on client database, tracked subscriptions and calculated monthly compliance reports regarding investor breakdowns.
• Performed source data analysis, data discovery, data profiling, Business rules and data profiling.
• Involved in defining the source to target data mappings, business rules, business and datadefinitions.
• Maintained data mapping documents, business matrix and other data design artifacts that define technical data specifications and transformation rules
• Effectively communicated data design to other members of the team to ensure proper implementation and utilization of the data structures; Support development team during process design and during performance tuning
• Involved in data analysis and Data mapping of existing reports to identify and document iteration and business metrics.
• Prepared Data Comparison tool by using VBA (Excel Macro).
• Worked in areas such as Fixed Income, Equities, Risk, Order to cash (OTC) Derivatives, Electronic Trading floor applications, Financial reporting using Business Objects, leading and managing Business Process Re-engineering.
• Worked on profiling the data for understanding the data and ETL specification document.
• Proficient in Excel VLOOKUP and MS word.
• Worked on Service & quality management tools such as Remedy, Service now, Jira, HP Quality Centre.
• Involved in using MS Visio, MS Project, MS Excel, PowerPoint, and SharePoint.
• Involved in extracting, discussing and refining business requirements from business users and team members for generating revenue from credit card transactions.
• Worked with all project team members to ensure project needs are clearly understood and supportable.
• Worked with user testing of system developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Provide management with complex analysis regarding internal asset utilization trends.

Confidential - Portsmouth, NH

Data Analyst

Responsibilities:

• Worked with 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 on 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.
• Worked on tasks among development team monitored and tracked progress of project following agile methodology.
• Assisted in the collection of financial data and conducted data mining.
• Involved in 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 with data profiling for multiple sources and answered complex business questions by providing data to business use.
• Worked on ETL Informatica development task's like creating jobs using different stages, debugging etc.
• 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 with SQL and Data Warehousing for arrangement of customer data.
• Worked with Data Warehousing team in Metadata Modelling and gathering requirements for product catalogue data load specifications for Data mapping and Data Modelling.
• Worked on PL/SQL and Dynamic SQL to extract Data from Oracle databases. TOAD software used for creation of packages and stored procedures. Used Erwin for database modelling.
• Performed the physical database design, normalised the tables, worked with DE normalised tables to load the data into fact tables of Data warehouse.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).