SUMMARY

• 10+ years of Experience as aBusiness Analysis well versed with Requirements Artifacts like Business Requirements Document (BRDs), Functional Specification/Requirements Documents (FSD/FRDs), GUI Prototypes, Flow Diagrams (UML), and Report Mockups.
• DataProfiling,DataMigration,Data Masking, DataIntegration,Datagovernance and Metadata Management, Master Data Management and Configuration Management.
• Created and Executed Documents for Functional, Business Process on various business domains including Banking’s (Consumer and Small Business, Core Banking and Deposits, Treasury, Online Banking, Mobile Banking, Cash Management, Home loan/Mortgage and Wholesale Banking)Excellent understanding of deposit account (DA), how it works, what is the process and its rules and regulations.
• Detailed analysis of the AS - IS and TO-BE business process (GAP Analysis).
• Expert in Understanding of daily transactions including deposit account (DA), loan process and FAP applications; this includes coordination across multiple in-house teams, and the department for application analysis and design documentation and review.
• Well versed with working on different application units such as BOL (Branch Online), CCP (Credit Card Processing), HEJ (Host Electronic Journal), DDA (Demand Deposit System), IDS (Investment Deposit System), TDA (Time Deposit Account system), ACH(Automated Clearing House) etc
• Involved in design, development, integration and change requests as per the business changes in DDA (Demand Deposit Account) and TDA (Trade Development Account) systems and did testing in different scenarios.
• Provided support and knowledge across various banking system modules covering transactional accounts, Demand Deposits, Loans, Document management, Data warehousing, EFT ATM, Credit Cards Anti money Laundering AML, Fraud, IVR, File Manager, General Ledger reconciliation and other core modules.
• Experience in Credit Cards which includes Consumer and commercial credit cards, Cards Payable, Payments, Credit Card Acquisitions, Direct Debit, e-statement, Loyalty (reward points), Marketing, Personalization, Alerts and Messages, Customer Management Services and Fraud workflows.
• Expert level knowledge on Demand Deposit Account (DDA) applications; this included coordination across multiple in-house teams, vendor team, and the department for application analysis and design documentation and review.
• Experience working withdatamodeling tools like Erwin, Power Designer and ER Studio.
• Worked on CCAR Credit Risk Model validation of retail and commercial portfolio for the Bank's Business lines. Complete model validation - Input data, Methodology, Code implementation, Statistical Test, back testing and reporting.
• Expertise in implementation processes for deploying, upgrading, managing, archiving and extractingdatafor reporting using SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting thedata, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
• Expertise in importing data from COBOL Files, EDI, Flat Files (Fixed Width and Delimited), and XML files and different relational sources like Oracle, DB2, and SQL Server.
• Experience in Identifying red flags related to the various fraud types for retail banking or credit card products such as fraudulent checks/unauthorized withdrawals, electronic transfers, identity theft, online banking fraud, and debit card fraud.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot.
• Created interactive dashboard and Reports in Tableau for monitoring the operation performance on day to day basis.
• Well versed in Normalization / Denormalization techniques for optimum performance in relational and dimensional database environments.
• Extensive experience in development of T-SQL, DTS, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Experience indatatransformation,datamapping from source to target database schemas anddatacleansing procedures using Informatica Power Center and SSIS.
• Well versed withDataprofiling,DataMigration andDataConversions.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. Business Analyst

Responsibilities:

• Worked on Demand Deposit Account (DDA) applications; this included coordination across multiple in-house teams, vendor team, and the department for application analysis and design documentation and review.
• Strong Knowledge on Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing, OTC, Mortgage and Credit Cards.
• Experienced in multi-tier, database-driven, client-server, Internet, Web, and wireless development. Focus on making systems better through Agile Methodologies, re-architecture, re-factoring, code cleanup, and redesign.
• Gathered requirements BRD preparation for various functionalities like DDA, Fund transfer, Customer maintenance, Loan IQ, Loan origination and non-functional requirements for Flexcube.
• Involved in Credit Risk Monitoring, Risk Rating (Risk Management & Risk Enterprise) Collateral & Market Analysis.
• Worked with KMC credit monitor, credit edge, and risk calculation to check the quantitative credit analysis solutions for investors.
• Worked on the Setup two new Time deposit retirement products by documenting business requirements, functional requirements, use cases, business rules of financial transactions as bill payments, transfers, deposits and security access.
• Ensured that Business,DataGovernance and Integration team leads are deeply involved in critical design issues and decisions
• Worked along the programmers in building the Time Deposits and Demand Deposit master and transaction history files.
• Drive client satisfaction by acting as clients' primary contact for issue resolution, being easily accessible, facilitating positive interactions, and ensuring adequate follow-up to outstanding issues.
• Worked with Product owner on gathering the business requirements and implementing the changes to the designed screen.
• Documented business requirements, functional requirements, use cases, business rules of financial transactions as bill payments, transfers, deposits and security access.
• Worked on Demand Deposit Account (DDA) applications; this included coordination across multiple in-house teams, vendor team, and the department for application analysis and design documentation and review.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and commercial lending system.
• Strong understanding on Fixed Income, Equities, Equity Trading Cycle, Portfolio Analysis, Bonds and Bond Trading Cycle, Portfolio Management
• Worked on bank conversion for deposit products, sub - product re-alignment, and capacity planning for Z/OS operating system
• Developed IST and UAT plans and test cases for deposit processing, IVR, ATM, bill pay and teller applications.
• Compiled packages of documentation to fulfil due diligence and business process requirements of funding firms.
• Assisted and managed the annual audit process for all funds serviced.
• Assisted fund administration team in the preparation and review of annual and semi-annual financial statements.
• Involved in preparing and reviewing board materials and presented to boards and senior client management.
• Significant experience and expertise in maintaining strong working relationship with external and internal clients and with all fund service providers including transfer agents, custodians, outside counsel and external auditors.
• Formulated and monitored adherence to departmental policies and procedures.
• Worked on Back up ATM Teller, pulled deposit envelopes, and set machine for next business day.
• Closely interacted with developers to understand application functionality and navigational flow and keep them updated about Business strategies.
• Extensively used both Star Schema and Snowflake schema methodologies in building and designing the logicaldatamodel in Dimensional Models.
• Created intricate set of SQL tables to hold user login and user access information with constraints and access errors were logged in to error tables.
• Responsible for creating weekly and monthly reports for management based on Cognosdata.
• Perform gap analysis of current state to desired state and document requirements for control gaps identified
• Implemented Referential Integrity using primary key and foreign key relationships and assigned appropriate cardinality between entities and documented it.
• Reverse Engineered the Existing databases for analysis and complete comparing.
• Changed existingdatamodel as per business requirements.
• Ensured productiondatabeing replicated intodatawarehouse without anydataanomalies from the processing databases.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about thedatamodel and business requirements.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Served as a Analyst in the successful transition from Brokerage DDA to AWM DDA origination platform.
• Worked on Confluence, Demand Deposit Account (DDA), RLS, ARR and FAP applications; this included coordination across multiple in-house teams, vendor team, and the department for application analysis and design documentation and review.
• Worked on conversion of word documents into Confluence product involved in import and manual rewrite of the documents to be submitted into Confluence.
• Credit Risk Requirement Gathering, Analysis Solution Design for Consumer Commercial Schedules and Stress Models.
• Reviewed secured documents on SharePoint and verified documents, folders and PowerPoint presentations for customer personal identification (CPI).
• Analysed business workflow and system needs for conversions and migrations; assisted in data mapping.
• Defined and developed test plan documentation to support system validation and/or user acceptance testing.
• Carried out database validation by running SQL statements to validate data in the source and destination databases.
• Worked with the application developers to create test strategy to implement various phases of testing like Performance, Integration, Unit and User acceptance testing.
• Coordination and delivery of communications across internal and external audiences and create BA artefacts like use cases, activity diagram, sequence diagrams, data models and ER diagrams.
• Assist the organization in performingdatacompiling,miningand analysis required to evaluate the givendata
• Maintain the research database, update and upgrade it from time to time and ensure safe storage ofdata.
• Carry out analysis of the givendataand draw correct inferences, in keeping the objectives of the analysis.
• Review current operationaldatastructures and recommend optimized database design for newdatavrequirements, with integration into the enterprisedatamodels, and MasterDataServices in a federated framework architecture.
• UsedDataBlending techniques, parameters, table calculations, bins, action filter and highlighting for thedatavisualization. Used Excel fordatacleaning and preparation.
• Involved in creating Eztrieve reports for a consolidation project for checking accounts.
• Mapped data for Hogan IDS/ DDA pieces for a recent acquisition. Mapping was based upon Business Requirements, Functional Requirements and field to field Data Requirements.
• Involved in creating reports via Eztrieve for unit test verification purposes.
• Worked on reviewing Business Requirements for accuracy and attended User Group meetings to address any problem areas.
• Participated in test case planning.
• Extensively involved in Agile-Scrum projects, part of running scrum-boards, maintaining backlogs, grooming user stories (BDD based), and organizing sprints.
• Understanding of daily transactions including deposit account (DA), loan process and FAP applications; this includes coordination across multiple in-house teams, and the department for application analysis and design documentation and review.
• Worked in software engineering methodologies or SDLC like Agile and Waterfall methodologies.
• Used JIRA for planning and tracking the portfolios, stories, roadmaps, themes, ideas, defects, tasks, tests and issues.
• Worked with the Product Management team in order to ensure effective scope management and resource planning.
• Designed and reviewed various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Involved in conducting release planning in Agile environment & coordinated releases with development team & software quality assurance team for timely delivery.
• Coordinating efforts across internal organizational units and primary vendors to integrate overall business process workflows to gain operational efficiencies and provide highest level customer service possible.
• Reviewed, analysed, and evaluated business processes and associated IT application requirements for SharePoint and develop and execute test strategies, plans, scenarios, and tracks resolution to identified defects.

Confidential, Houston, TX

Business/Data Analyst

Responsibilities:

• Analyzed the large sets ofdatausing various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Analyzed different source systems ( AMLN, LoanIQ, ACBS, Credit Cards - Target, Maestro,Shaw) and identified the reporting data elements required to report to Dodd Frank and Call Reports.
• Worked on Black Knights Empower LOS for Retail, Wholesale, and Commercial Loans.
• Created custom monthly report whole sales and retail banking (First lean mortgage, Home equity loans, Auto loans, Smallbusinessloans and other consumer loans) for differentloanservices used by the bank.
• Interacted with teams in AFS (Automated Financial Systems) and ACBS (Advanced Commercial Banking System) to extract the information for the reports.
• Monitored daily various financial reports to verified theloan/fee balances were properly reported in thegeneralledgerand ACBS (Advanced Commercial Banking System).
• Assist the organization in performingdatacompiling,miningand analysis required to evaluate the givendata
• Extensively used Remote Deposit Capture(EDS) application to capture images via desktop scanners
• Worked on Web Portal application to convert paper-based deposits to electronic format for immediate and secure delivery to Union Bank over the internet and external machines. It provides easy-to-use tools for creating, managing, and transmitting electronic deposits
• Job also include Test Evaluation, Verification & Validations of Actual Results vis-à-vis the desired results Sent daily status reports with any issues to both the Client as well as senior management
• Creating and maintaining Tests and Test Records, Defect Management, analyzed defect data, performed testing for product release, recommended process improvements, review test procedures, maintain strict adherence to client's prescribed testing guidelines, control processes and procedures
• Performed Database Integrity Testing by executing SQL statements.
• Worked on RDC Smart and RDCO converted and unconverted DDA deposits validation in Host and IPVision/Transaction Processing system tool
• Involved in developing all the ETL processes developed for fetchingdatafrom OLTP systems to the target Market Data warehouse using complex SQL queries.
• Developed PL/SQL procedures that were developed to load thedatafrom temporary tables in staging to target tables in thedatawarehouse
• Maintained all the SQL documents which included installation anddataconversion Procedure documents.
• Extracted thedatafrom the different sources and stored thedatainto the intermediate Staging Database using the SSIS ETL tool.
• Extracteddatafrom Mainframe databases using Power Exchange and loaded into SQL Server Database tables.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Performed Verification, Validation and Transformations on the Inputdata(Text files, XML files) before loading into target database.
• Wrote complex Stored Procedures, coding and triggers to capture UPDATED and deleteddatafrom OLTP systems.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
• Developed test cases and wrote test plans to help developers locate and fix the defects, as well as tracking issues with JIRA and discover possible gaps in corporatedatawarehouse on project scope.
• Effectively explored solutions within and outside the scope and brainstormed new solutions for the problems, and maintained Requirement Analysis Report, Preliminary Design Specification, Detailed Design Specification, Workflow Specification, Future Operational Procedures, and other documents.
• Utilized Oracle SQL queries to accessdatastored in thedatawarehouse for analysis and test the proper implementation of the database.
• Implemented ETL processes for enterprise migration system.
• Developed the mappings using various transformations according to business partners' requirements.
• Generated Matrix Reports, Drill Down, Drill Through, Sub-Reports, and Chart Reports using SQL Server Reporting Services (SSRS).

Confidential, Wilmington, DE

Business/Data Analyst

Responsibilities:

• Involved with Data Analysis Primarily IdentifyingDataSets, SourceData, Source Metadata,Data Definitions and Data Formats.
• Involved in Data Analysis,Data Validation,Data Cleansing,Data Verification and Identifying Data Mismatch.
• Participate in defining and establishing the Client MasterDatamanagement (MDM) organization within the EnterpriseDataOffice
• Responsible for a majorloanaccounting conversion initiative to transfer retailloansto theLoanIQ loanaccounting system.
• Performed reconciliation between Flexcube and Rapid Systems for Loan Origination/Agency and Secondary Loan Trading.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Assess and coordinate the prioritization of requirements of cross enterprise business segments for in corporation into the enterprise masterdatamanagement (MDM) solution.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Performed data analysis and documented Source to Target mapping, Data quality checks, Datasharing agreements and documents.
• Involved in migration projects to migrate data from data warehouses on Oracle and migrated those to DB2.
• Performed data auditing, validation and cleansing as well as metadata mapping and migrations.
• Involved in migration of various objects like, stored procedures, tables, views from various data source to SQL Server.
• Work with Data Migration team in determining the data elements and period for data migration
• Performed the analysis and visualization of the data through Qlikview.
• Involved in developing Oracle PL/SQL and Shell Scripts,DataImport/Export,DataConversions andDataCleansing.
• Extensively used PL/SQL tables and Bulk loader programs for processingdataand loading into Oracle tables.
• Conducted meetings withDataconversion team in order to provide source-to-source stagingdata requirements/ definitions/ for mapping purposes.
• ConductedDataCleansing for migratingdatafrom legacy system to the newdatawarehouse and performedDataconversion validation testing to make sure there is seamless conversion ofdatafrom current system to new System.
• PerformDataConversion/Datamigration using Informatica PowerCenter.
• Reconcile internal & external financial reports to ensure proper account balance are maintained and accurate data which are reflected on client accounts.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Provided technical Expertise on the use of Rational Clear Case, Rational clear quest and Requisite pro, which were used for Data archiving and Requirements Management.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Experienced in writing complexSQLqueries for extracting data from multiple tables.
• Used SQL Queries to verify and validateDatapopulated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Performed source data profiling to verify that data meets the business requirements.
• Worked on issues with migration of Data from development to QA-Test Environment
• UsedmainframeIMS based green screens to create loan test data and to validate loan testing scenarios.
• Queried the DB2 database inMainframesfor the proper validating the loans into the Database.
• Understood core processes of the departments to provide input on re-engineering or Streamline opportunities.
• Worked on different modules and analyzed the bugs in Defect manager in the Test Director reported by the users during the UAT.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Set up definitions and process for test phases including product test, integration test, and system test. Work to fully implement test phase entry and exit quality criteria, standard test reporting metrics and standard test artifacts.

Confidential - Cincinnati, OH

Business/Data Analyst

Responsibilities:

• Document alldatamapping and transformation processes in the Functional Design documents based on the business requirements.
• Involved inDatamining, transformation and loading from the source systems to the target system
• Involved in defining the source to targetdatamappings, business rules, business anddata definitions
• Provided qualitydatareview for completeness, inconsistencies, erroneous and missingdata according todatareview plan
• Prepared High Level LogicalDataModels using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Madedatachart presentations and coded variables from originaldata, conducted statistical analysis as and when required and provided summaries of analysis
• Loaded operationaldatafrom Oracle, flat files, XML files, Excel spreadsheets into Oracle targetdatamart and used Informatica Power Exchange for mainframe sources, such as COBOL files.
• Extensively used Informatica Power Center Designer to create a variety of mappings including expression, sequence generator, source qualifier, router, joiner, update strategy, aggregator, stored procedure, and lookup transformations with embedded business logic.
• Involved in extensiveDATAvalidation using SQL queries and back-end testing
• Contributed to the initialdatamining work and development of tools and technology
• Initiated detailed discussions/functional walkthroughs with stakeholders
• Produced system documents, functional requirements, ETL mapping and modeling deliverables Worked with root cause ofdatainaccuracies and improved the quality ofdataby usingDataFlux
• Resolved conflicts between business and system teams
• Wrote complex SQL, T/SQL Testing scripts for Backend Testing of thedatawarehouse application.
• Assisted developers and testing teams to ensure that the requirements are communicated accurately and that the system being developed is verifiable against the requirements
• Involved in Documenting/Executing business test cases
• Wrote SQL queries to validate sourcedataversusdatain thedatawarehouse including identification of duplicate records.
• Tested whether the reports developed in Business Objects and Crystal Report are as per company standards.
• Tested Ad-hoc reports, drill down and drill through reports using SSRS.
• Tested different detail, summary reports and on demand reports.
• Involved in pre and post session migration planning for optimizingdataload performance.
• Facilitated periodicdataloading by using reusable transformations, mapplets and worklets.
• Used parameter files to define values for mapping parameters and variables to provide flexibility.
• Implemented the Slowly Changing Dimensions (SCD) of type 1 and type 2 (flag, date) for the purpose of incremental loading of target database.
• Worked on performance tuning of the SQL queries, Informatica mappings, sessions, and workflows to achieve fasterdata loads to thedatamart.
• Extensively used SQL DDL/DML commands with TOAD environment to create target tables and perform different testing for accuracy & quality.
• Provided status reports to supervisor on a weekly basis and on-call supports.

Confidential, Richmond, VA

Business/Data Analyst

Responsibilities:

• Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, and Power Designer Developed logical/ physicaldatamodels using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Utilized Informatica toolset (InformaticaDataExplorer, and InformaticaDataQuality) to analyze legacy data for data profiling.
• Performed DetailedDataAnalysis (DDA),DataQuality Analysis (DQA) andDataprofiling on sourceData.
• Normalized the database to put them into the 3NF of thedatawarehouse.
• Database table review anddatamapping for large scaledataconversion project Oracle database to Mainframe.
• Provided technical support during delivery of MDM (MasterDataManagement) components.
• Identified and understood the business function activities, entities,dataattributes, table's metadata and documented detailed design specifications for new system.
• Generated reports (SSRS/Crystal) from SQL Server Database and Cubes and included parameterized and cascading parameterized reports to populate drilldowns, drill through, and sub-report. documents to guide Informatica developers on ETL development. Designed and unit tested Informatica mapping as part of lead certifications.
• Wrote requirements for designingdatamarts that were used as a source for the various reporting systems in the company.
• PerformedDataAnalysis,Dataprofiling andDatavalidation by writing SQL queries using TOAD.
• Involved in defect management, including root cause analysis, solution recommendations (s), and next step coordination.
• Conducted UAT fordataintegrity. Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Responsible for supporting the Operations support team with releases deployed to Production. Helped Business in ad-hoc reporting request anddatapulls.
• Synthesized testdatathrough various sources, Records/enusers/SME/BA/meetings and facilitated Testing Performed functional, integration, system, UAT and regression testing Identified problems and isolated software defects,dataissues and user issues.
• Queried database using SQL queries to ensuredataintegrity and to validate the inserted and updated data.
• Assisted the team to built DDL's from physical database structures using forward engineering technique from Data model and worked with Confidential group to get it executed on Database.
• Provided production support and performed enhancement on existing projects..