Sign in

Data Project

Edison, New Jersey, United States
January 04, 2018

Contact this candidate


Melody Yi

Senior Business Analyst

Email ID:

Number: 732-***-****

Available for C2C

Professional Summary

Over 10 years of experience as a Business Analyst / Business System Analyst with diverse experience in Finance, Banking, Telecommunication and IT Industries.

Extensive experience in Telecommunication Network Architecture, Wealth Management, Trade Life cycle and Risk Management etc.

Strong customer/ user advocate, with excellent analytical, collaboration, communication, decision-making and organizational skills.

Working knowledge of Software Development Life Cycle (SDLC) methodologies like Waterfall and Agile.

Involved in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SMEs to obtain and clarify project requirements.

Broad Experience in developing Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Unified Modeling Language (UML) Diagrams.

Proficient with GAP Analysis, Risk Analysis, and SWOT Analysis

Experience in working with different telecommunication platform, including Business Support Systems (BSS) to Operational Support System tasks (OSS), Enterprise Resource Planning (ERP) and Customer Relationship System (CRM).

Experience in working with different platform banking platforms like Online Banking, Mobile Banking, Trading System.

Experienced in database testing for data validation, transaction verification and excellent knowledge in SQL query writing and logic development

Highly involved with Development and Quality Assurance (QA) Teams to provide a smooth channel of communication and smooth flow of SDLC.

Facilitated meetings for defining business requirement and User Acceptance Testing (UAT) standards and prioritizing them to manage overall requirement of the project.

Strong skills in playing a primary role in contacting and liaison between management, client, and software vendor in installation, configuration, and implementation of the software product.

Expertise in creating Change Request (CR) and thoroughly analyzing the impact on the existing requirement.

Working knowledge of Data Warehousing Process and its lifecycle.

Experience working with off-shore, on-shore, on-site, off-site individuals and project teams.


Master in Accounting

Technical Skills: Agile Scrum, Rational Unified Process (RUP), Waterfall, Rally, Rational Requisite Pro, MS-Visio, Enterprise Architect, Rational Rose, MS Word, MS PowerPoint, MS Excel, MS Access, Rational Clear Quest, Rational Clear Case, Informatica, Just in Mind, Mercury Quality Center, UML (Use case diagram, Context diagram, Activity diagram, Sequence diagram etc), Oracle, PL-SQL, SQL Server, UNIX, Windows, SharePoint, JIRA, HP QTP

Professional Experience

Debtwire, manhanttan, ny JAN 2017 to till date

Role: Senior Business analyst

Domain: Financial

The assignment involved in working on a couple of enhancement project. The “email marketing” project focused on the development of an email notification for marketing to existing and prospective customers which will allow DEBTWIRE to better tracking of email consumption and delivery. The second project was build new database that provide increased controls on data, reduced maintenance costs, reduce data errors, improve performance, and enforce master data governance.


Gathered and documented business requirements and business process flow, following the existing template and specifying the objects, assumptions, constrains, scope, feature, data flow diagrams, and screen mock-ups etc.

Facilitated cross-team meetings with committees from Operation and Development to allow different stakeholders to communicate their interests and concerns and document meeting minutes.

Collaborated with System Analyst, Technical Lead, and developers to assist them in fully understanding of business requirements.

Performed Gap Analysis (AS IS- TO BE) and create current and future business process flows.

Identified process problems and implemented new and improved policies and processes.

Assisted with draft project documentation including Business Requirement Document (BRD), Project Change Request (PCR), and Issue log to track the status of all the issues and concerns raised during the project.

Review BRD and other documentation with stakeholders and SME's to receive signoff.

Followed a structured approach to name and organize requirements into different hierarchy level groups as Capability, Feature, and Business Requirement for traceability purpose.

Collaborated with the QA team to develop test plans, test scenarios and test cases including execution condition, input description and expected result that will be used in system and user acceptance testing based on business requirements, technical specifications, and product knowledge.

Performed Agile project management, creating product backlog, sprint backlog and bug tracking.

Consolidate sources of documents and provide a source of authorization with the latest and the most updated

file on SharePoint for accomplishments, in-progress items and tasks assigned in the coming week, notify project manager for additional concerns.

Collect data points from multiple analysts and editorial teams for sorting and input into group database

Serve as senior legal analysts on research and development related matters from bankruptcy cases (ch7, ch11, ch15) in the docket.

Assist senior legal analysts in tracking events in multiple court proceedings including motion, order, application, etc. for monthly tracking reports.

Support senior legal analysts in researching capital structures of companies, such as bond, loan, and stock etc.

IDACITI, New york city, NY Jul 2016 to dec 2016

Role: business analyst/Quality assurance

Domain: Financial

Project focused on creating a system for the access and analysis financial and non-financial data.


Managed, developed and supported business applications to meet the organizational needs.

Implemented agile development practices according to the application requirements for the project.

Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other,

resolved any issues and come to an agreement quickly.

Documented use cases, workflows and sequence diagrams according to UML methodology thus defining the

Data Process Models.

Extracted, transformed and loaded data from SEC filings, i.e. 10-K, 10-Q and 8-K into IDACITI database for further analysis.

Verified data by using patterns and trends to ensure compliance with US GAAP.

Interpreted data and analyzed results by using taxonomy explanation and provide report by using of words, charts, graphs and other visualizations to present my finding.

Verified XBRL tagging for SEC outsourcing service to review data for accuracy.

Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Reviewed development plans, quality assurance test plans and user documentation for Black Box testing and

performed Regression Testing and created test scenarios for Beta testing to ensure correct interpretation of

original specifications.

Conducted training sessions to make the users comfortable with the functionality.

Santander Bank, Boston, MA Jan 2015 to Jun 2016

Role: business analyst

Domain: Banking

Project is aimed at enhance the Risk Management and Reporting System. The team also supported implementation of Comprehensive Capital Analysis and Review (CCAR) Stress test, including data collection & data aggregation, review, projection & analysis and regulatory compliance.


Worked as a liaison between Risk, Finance, Operation and IT departments to clarify the expected improvement in datasets, methodologies, approaches, and transfer them into functional requirements and specifications.

Cooperated with CCAR team on delivering of the Basel capital regulatory results to serve the CCAR various reporting forms.

Managed team on various senior management queries consisting of risk validations and Basel 3 rule changes.

Worked on CCAR 14Q report for new FRB requirement like Disposition Loans, Disposed Scheduled Shift & Syndication Loan.

Created efficiencies which allowed expanding the role to include Compliance and Internal Audit initiatives.

Interacted with country user, operation, risk management, product control, finance and other stakeholders to capture business requirements and involved in creating enterprise level flows and timelines.

Performed analysis as part of annual Federal Reserve stress tests such as Comprehensive Capital Analysis and Review (CCAR) and Dodd-Frank Act Stress Test (DFAST).

Design and Develop Reports using AXIOM objects i.e. DataSource, DataModel, ModifyModel, Portfolio, Aggregation, Shorthand, Tabular Report, Freeform Report.

Assisted on CCAR model validation enhancement, including Y9-C and Y14Q models.

From CCAR Dashboards by mapping MDRM keys validated each of the line items in FRY 9C Summary report (Standardized and Advanced).

Identifies and recommends process improvements that significantly reduce workloads or improve quality.

Performed analysis of approaches and models for RWA calculation as well as to assist in investigation, escalation and resolution of the data issues.

Utilized SQL to extract data and understood data schemas and relational data tables in data warehouse.

Jefferies & Company, Inc., Boston, MA oct 2013 to dec 2014

Role: business analyst/data analyst

Domain: Finanical

The project is about trading system that is to provide buy and sell trades of various securities including fixed income, equities and derivatives. The meaning of this project is to promoting efficiency and reinforcing the management through entire trading system.


Managed full delivery cycle of regulatory project work for credit policy and bank regulatory. Included specific analysis and detailed documentation of requirements related to exposure to cash equity, bond, securities financing transactions, and credit and equity derivative deals and incorporation of a single counterparty hierarchy solution.

Familiarized existing system and created As-Is and To-Be document for Gap Analysis.

Gathered and Analyzed requirement by conducting interviews, meetings and JAD session with business users and other SME.

Analyzed fixed income trade process and trade lifecycle from front office to back office systems and documented with diagrams.

Documented user stories and explained the business demands from stakeholders.

Interacted with manager to prioritize the user stories and assigned to each sprint.

Participated in change management requirements gathering for fixed income management calculation area.

Credit Administration, analyzing financial parameters, cash flow, risk assessment and corporate appraisal.

Involved in Risk-Management Process, whereby identifying critical areas of business risk and modifying the business process to reduce the same.

Reinforced financial knowledge and reviewed financial ratios data (Leverage ratio and EPS) and various calculations (bond pricing)

Involved in Data quality gap analysis regarding to database design and data migration by using SQL for developing the KPI’s and benchmark of security.

Created UML Diagrams including Use Case Diagrams, Activity Diagrams by using Microsoft Visio 2016.

Experienced with multiple data, including transactional data, market data and reference data.

China United Network Communications Group Co., Ltd, Beijing, china Jan 2006 to sep 2013

China Unicom is a Chinese multinational telecommunications conglomerate and is the fourth largest provider of mobile telephone services and the largest provider of fixed telephone service in the world.

Project Manager (Wireless) Nov 2009 - Sep 2013

Managed a portfolio of 3G wireless products.

Developed 3G wireless product revenue forecasts and detailed business cases for product development.

Led 3G mobile phone line development and drove product roadmap through product launch and post-launch, as well as on-going sales support & training.

Worked with Finance and Pricing to design 100+ 3G Mobile Data Packs and Plans, covering the mobile phone, labor, packaging, unit overhead, plant expenses and transportation costs, especially introduced Apple products to China.

Tracked and analyzed monthly product revenue to Identified project constraints and opportunities for improvement.

Integrated Managing Across the Life Cycles by incorporating the ITIL Service Management Processes of Service Strategy, Design, Transition, Operation and Continual Service Improvement.

Collaborated with Regulatory, Legal, Revenue and Service Assurance to ensure compliance of product roll out.

Drove quarterly business review with third party vendors to drive business objectives.

Business Analyst (CRM) Jan 2006 – Oct 2009

Configured Business Rules, Work Flows and Business Process Flow and Chart.

Lead creative strategy, development and implement of CRM system to existing China Unicom customers across multiple mediums including Direct Mail, Email and SMS.

Involved in projects and system development life cycle.

Conducted JAD sessions with marketing team, finance department, and the technical team.

Reviewed BRD and other documentation with stakeholders and SME's to receive signoff.

Involved in Dynamics CRM data capture, integration, auditing, data mapping, importing data and creation of interfaces.

Developed and update a customer segmentation plan to align with marketing goals.

Drove market-level integration of CRM campaigns & programs

Managed campaigns: including strategic vision, execution and evaluating key learning to determine next steps

Oversaw creative messaging through all targeted vehicles including in bill, solo mail, SMS, email, landing pages and online banners.

Optimized communication plans by leveraging digital technology and innovation.

Delivered "best-in-class" email marketing: develop and manage email and digital marketing strategy to deliver revenue and retention targets.

Developed customer KPI dashboard to measure monthly customer engagement and value, including new vs. existing customers, spend behavior, channel attribution and marketing contact frequency.

Tracked and analyzed results of campaigns, provide recommendations for modifying programs based on data analysis and goal attainment and evaluate opportunities for testing.

Involved in development of Test Plans & Test Cases and conducting User Acceptance Testing (UAT). Assisted the QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.

Contact this candidate