SUMMARY

• Over 8 years of experience as a Business Analyst/Data Analyst with strong understanding of Business Requirements Gathering, Process Flow, Business Process Modeling and Business Analysis.
• Worked in Financial Services Industry in diverseCapital Markets domains in areas such as Fixed Income, Financial reporting usingBusinessObjects and Spreadsheets.
• Extensive skills in Unified Modeling Language (UML )Diagrams like Class,Activity/ State, Sequence, ER diagrams using Rational Rose and Microsoft Visio. Developing Use Casediagrams, Sequence diagrams and Class diagrams,activity diagram, swim - lanediagram, development diagram, integration diagram, Using QC, MySQL, MS Project and prototyping tools.
• Expertise in working with Business Analysis, Processes, Data Mapping, Flow Diagrams and Business Requirement Documents.
• Experienced in financial instruments within investment banking and brokerage environments (Derivatives, Fixed Income, Hedge Funds, Capital Markets, Energy trading, FX, Futures, Options, Commodities, Debt, Equity and Structured Products, Mutual Funds, Swaps, Asset Backed Securities) and wealth management.
• Expertise in diverse retail banking sectors including lending, deposits, payments, cards, trade finance, treasury, regulatory reporting (BI), KYC, AML, payment system.
• Expert in Data Analytics, DW/ETL, BI report development,datamining,datacleansing, analysis and database programming.
• Strong experience in Data Analysis,Data Migration,Data Cleansing, Transformation, Integration,DataImport, and Data Export through the use of MS SQL Server and Informatica Data Quality tools.
• Extensive experience with AFS and ACBS (Advanced Commercial Banking System) data processing, system and business analysis, data mapping, testing, training, conversion, system upgrade,GeneralLedgerAccount balancing, and post-conversion support involving strong analytical and problem-solving skills. Experienced in full project life cycle.
• Experience working withdatamodeling tools like Erwin, Power Designer and ER Studio.
• Extensive experience in data warehousing tools and technology such as Informatica Power Center, Power Exchange, Metadata Manager, MDM, OBIEE,Qlikview, SSIS, SSRS, MicroStrategy, etc.
• Expertise in implementation processes for deploying, upgrading, managing, archiving and extractingdatafor reporting using SQL Server Reporting Services (SSRS).
• Expertise in designing the ETL around Aladdin,BloombergAIM, Eagle Pace and accounting systems.
• Very proficient with Data Analysis, mapping source and target systems fordatamigration efforts and resolving issues relating todatamigration.
• Experience in Data Scrubbing/Cleansing,Data Quality,Data Mapping,Data Modeling, DataProfiling,Data Validation in ETL.
• Extensive hands-on experience creating prescriptive data lineage, active data lineage usingInformatica Metadata Manager combined with Informatica Developer.
• Experience in creating and documenting Metadata for OLTP and OLAP when designing a system.
• Knowledge of Ralph Kimball and Bill Inmon's approaches toDataWarehousing.
• 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.
• Expertise in providing metadata management, end to end data lineage solution of organizations using Informatica metadata manager (IMM) and Analyst tool (IA)
• Experience in preparingbusinessrequirementsdocument (BRD), functional andtechnicalspecifications, systems design andrequirementsspecifications.
• Experience in Reference Data Management (RDM) concepts, Methodologies and ability to apply this knowledge in building enterprise reference data warehouse using Informatica RDM/MDM accelerator and IDD tools.
• Expertise in creating Test Cases on the basis of product features, clientrequirementsandtechnical documents. Developed, executed and maintained Test Scripts.
• Design and review of 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.
• Have a good understanding on Wealth management incapitalmarket.
• Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Excellent understanding of Database management system, Data warehousing concepts, Business Intelligence technologies and Data mining.
• Expert at interacting with stakeholders, Subject Matter Experts (SMEs) and end-users to understand, analyze, communicate and validate requirements using Joint Application Design (JAD) sessions.
• Experience in Software Development Life Cycle (SDLC) process, Software Testing Life Cycle (STLC) and Product Development life cycle including Waterfall, Scrum/Agile, and QA methodologies.
• Created interactive dashboard and Reports in Tableau for monitoring the operation performance on day to day basis.
• Experience on DataStage for extracting, transforming and loading databases from sources includingOracle,DB2and Flat files
• Experience in creating, writing, and executing Test Cases, Test Scripts from Business User Requirement documents and Functional Design Documents.
• Advanced Proficiency with Excel, Word, Blackline Financial Account Reconciliation application, Oracle & PeopleSoft General Ledger applications.
• Conducted review sessions on a regular basis with QA and development teams for preparing status and delivery of operational reports.
• Experience on IBM Datastage Designer to develop jobs for extracting, cleaning, transforming and loading data into data marts/data warehouse.
• Adept at developing models for inventory and purchasing, establishing protocol for inventory analysis, conducting SQL testing, and creating ad hoc reporting procedures, Data Marts.
• 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 .
• Performed GAPP/Data and Cost Analysis of accounting programs, using Account Payable data
• Served as a liaison between Payer Financial Services Management, performing DME Billing and IS Management.

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

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.
• Ensured that Business,DataGovernance and Integration team leads are deeply involved in critical design issues and decisions
• Developeddatastewardship program establishing metadata registry responsibilities
• Implemented metadata standards,datagovernance and stewardship, masterdatamanagement, ETL, ODS, data warehouse, datamarts, reporting, dashboard, analytics, segmentation, and predictive modelling.
• 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. documents to guide Informatica developers on ETL development. Designed and unit tested Informatica mapping as part of lead certifications.
• Involved in Extracting, cleansing, transforming, integrating and loading data into data warehouse using Datastage Designer.
• 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.
• Involved in building data lineage in IBM Infosphere IGC for data comparison across source system, MDM, Enterprise data platform, Reference Data Store, Data Lake and AML engine.
• 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.
• Extract and load the metadata from disparate source systems into MM warehouse using informatica metadata manager packaged models as well as custom models and create data lineage among these systems
• 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.
• Build ETL process to publish reference data to all downstream applications using Informatica PowerCenter (PC)
• Queried database using SQL queries to ensuredataintegrity and to validate the inserted and updateddata.
• Assisted the team to built DDL's from physical database structures using forward engineering technique fromDatamodel and worked with DTG group to get it executed on Database.
• Provided production support and performed enhancement on existing projects.

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Worked with vendors and business partners for requirements clarification, requirements gathering and using Business Process Modeling (BPM)
• Acquired experience in all aspects of retail business including sales tracking, financial reporting, staffing, training & development, staff relations, marketing and inventory control.
• Assisted in developing and documenting Business Requirements, Functional Requirements, and Test Cases for a Retail Sales Analysis Tool Application project.
• Provided assistance to the Quality Analysts team with writing test scripts between hive and oracle and also between excel, csv to hive tables using Spark.
• Worked with the business users and with different levels of management to identify requirements, use cases and to develop functional specifications. Have prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Created reports on Statutory Liquidity Ratio (SLR) or Liquidity Coverage Ratio (LCR), Cash Reserve Ratio, Daily time and demand deposit statuses and Projected Provisions.
• Created UI requirements for vendor website and ensured that UI pages are ADA and WCAG 2.0 compliant.
• Facilitated the scrum meetings and helped to act as a buffer between development team and non-development distractions.
• Working on oracle SQL scripts and hive/impala SQL scripts to load data.
• Performed ingestion strategy and data acquisition with incremental data load in Hive.
• Set up and maintain Retail Banking sales incentive reporting system and developed retail banking application to provide true end-to-end visibility
• Created data warehouse objects - Fact tables, dimension tables, and association tables
• Executed SQL queries to test back end data validation of DB2 database tables based on business requirement
• Worked with SQL Joins and SQL queries extensively to evaluate data process and end user satisfaction
• Performed Gap analysis and implemented updates for the Data Warehousing Application.
• Implemented new test procedures in data warehouse QA environment like validating data availability, incremental data load, data accuracy, data loss and naming standards.
• Review Commercial loan documentation to ensure enhancements are meeting the proper audit standards.
• Used Rational Rose to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams, OOAD using UML.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.
• Worked on Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
• Hands on experience in Big Data architecture (Cloudera Hadoop distributions) and various components like HDFS, Map Reducer, Pig, Hive, Python, Spark, HBASE, Impala, Sqoop.
• Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose.
• Facilitated Joint Requirement Planning (JRP) sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Creating User Stories for Agile SCRUM based development methodology
• Created requirements analysis and design phase artifacts using Requisite Pro, activity diagrams and Sequential diagrams.
• Ran data lineage Analysis to perform Impact analysis and RCA analysis.
• Implemented Front End to a Fixed Income Derivatives Trading System, including trade blotter and interfaces to risk management, accounting, and middle and back office.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Coordinated activities with project manager and various other teams using MS Project.
• Supported User Acceptance testing (UAT) and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements, technical specifications and/or product knowledge.

Confidential, Bethesda, MD

Business/ Data Analyst

Responsibilities:

• 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.
• Developeddatastewardship program establishing metadata registry responsibilities
• 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 existing data model as per business requirements.
• Ensured productiondatabeing replicated intodatawarehouse without anydataanomalies from the processing databases.
• Utilized Informatica toolset (InformaticaDataExplorer, and InformaticaDataQuality) to analyze legacy data for data profiling.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about thedatamodel and business requirements. documents to guide Informatica developers on ETL development. Designed and unit tested Informatica mapping as part of lead certifications.
• Worked with data governance policies, Metadata, Data Quality or Change Management.
• 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 test data through various sources, Records/enusers/SME/BA/meetings and facilitated Testing Performed functional, integration, system, UAT and regression testing Identified problems and isolated software defects,data issues and user issues.
• Queried database using SQL queries to ensuredataintegrity and to validate the inserted and updateddata.
• Assisted the team to built DDL's from physical database structures using forward engineering technique fromDatamodel and worked with DTG group to get it executed on Database.
• Provided production support and performed enhancement on existing projects.

Confidential, Winston-Salem, NC

Data Analyst

Responsibilities:

• Involved withDataAnalysis Primarily IdentifyingDataSets, SourceData, Source Metadata,Data Definitions and Data Formats.
• Involved inDataAnalysis,DataValidation,DataCleansing,DataVerification and IdentifyingData 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 with Data conversion team in order to provide source-to-source stagingdata requirements/ definitions/ for mapping purposes.
• Conducted Data Cleansing 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.
• Involved indataconversionsand extracteddatausing SSIS packages (ETL) to transferdatafrom different server locations and heterogeneous sources like Oracle, Excel, CSV, flat file, XML and Text FormatData.
• Worked on SQL queries to retrieve data from Oracle for white box testing.
• Creating SQL Queries to validate data between source and target systems
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Used SQL Queries to verify and validate Data populated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• 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, Phoenix, AZ

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 Logical Data Models 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
• Was responsible in using MDM to decide how to manage their life cycle, cardinality, complexity and Collect and analyze metadata about the masterdata.
• Loaded operational data from Oracle, flat files, XML files, Excel spreadsheets into Oracle target data mart and used informatica Power Exchange for mainframe sources, such asCOBOLfiles.
• 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 extensive DATA validation using SQL queries and back-end testing
• Contributed to the initial data mining 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 source data versus data in the data warehouse 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 periodic data loading 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.