SUMMARY

• Proficient Business/Data Analyst with over 8 years’ experiences in fields of Information Technology and Finance Industry.
• Within depth knowledge of the Software Development Life Cycle (SDLC) (Agile, Waterfall, RUP) in capturing/analyzing Business and technical Requirements.
• Rich Experienced in Data analysis, Data profiling, Object - Oriented Design/ Modeling, Service Oriented Architecture and Project Management.
• Extensive experienced in gathering, managing and documenting business and functional requirements, communicating effectively with upper management, developers and QA engineers.
• Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Automation UAT.
• Well versed with regulatory reporting and stress testing (Dodd Frank/CCAR, and Basel III), Portfolio Risk (Credit Risk, Market risk across all assets) and Compliance regulatory (KYC and Customer on Boarding).
• Excellent knowledge on Trade Lifecycle: Trade Capture, Trade Execution and Trade Settlement.
• Depth knowledge in financial instruments within investment banking and brokerage environments (Derivatives, Fixed Income, Equity, Capital Markets, FX, Futures, Options, Commodities, Debt, Swaps)
• Adept at business models using UML diagrams - Use Case, Work Flow diagrams and data flow diagrams.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaires, interviews, brainstorming and JAD sessions. Excellent communication skills with dealing different stakeholders.
• Experience in ETL Processing, DataAnalysis,DataProfiling,DataMining,DataMigration,Data Integration, Data Mapping and Configuration Management.
• Experience inDataModeling in creating Star & Snow-Flake Schemas, FACT and Dimension table.
• Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration, and Scheduling.
• Have exposure in educating internal customers on business systems and procedures and working with other analysts and QA team to set priorities and schedules.

TECHNICAL SKILLS

Methodologies: Rational Unified Process (RUP), Agile (Scrum), Waterfall.

Business Tools: MS Office Suite (Word, Excel, PowerPoint, Project, Visio, Outlook, etc.), QuickBooks, Mercury Quality Center, JIRA, Axiom Controller View.

Database: SQL Server, Data Warehouse, Access, Adaptive Insights, Python

PROFESSIONAL EXPERIENCE

Confidential, Maspeth, NY

Business Analyst / Data Analyst

Responsibilities:

• Planned projects defining goals, schedule, scope / deliverables, and budget.
• Participated in scope analysis with the 3rd vendor to identify business needs.
• Lead the project teams in internal process redesign and new software implementation efforts.
• Involved in gathering and synthesizing business requirements and reviewed functional and non-functional requirements to be used as input to the functional design specifications.
• Interacted with technical Architects to identify and analyze the given information, procedures and decision flows and evaluated existing procedures.
• Facilitated Joint Application Development (JAD) sessions for communicating and managing expectations with SME’s and to understand thoroughly the business process and the interface requirements, which need to be incorporated in the application.
• Performed lot of Customizations, Enhancements, Updates and changing functionalities of web page.
• Integrate and analyze multiple marketing information resource including sales price and sales quantity by references from the competitors; Use Access to create sale trend report for inventory control.
• Participated in UAT and wrote testing review for the 3rd part vendor.
• Confirm financial status by monitoring revenue and expenses; coordinate the collection, consolidation, and evaluation of financial data; prepare special reports.
• Coordinated oversea manufactory, and provided weekly order plans for oversea manufactory by monitoring weekly sale and inventory, which required strong analytic skill in Excel and QuickBooks.
• Collaborated with sales department collecting popular tire sizes to create Excel template to effective control inventory.

Confidential, Princeton, NJ

Sr. Business Analyst

Responsibilities:

• Identified and analyzed Business Requirements and worksheets from business users - Regulatory Reporting Team and other SMEs. Documented user stories in JIRA.
• Communicated with stakeholders and SMEs in all phases, make sure the process on the right track.
• Collaborated with regulatory reporting team and Axiom configuration team to confirm manual data input templates which could be consumed by Axiom Controller View.
• Worked close with data sourcing team to identify data sources and target data, documented and analyzed SQL queries to against databases and upgrading data mapping documents into SharePoint for automation purpose.
• Performed data validation based on data requirements in data souring stage (FTDR) and Regulatory Reporting Data Mart (ESP).
• Lead on the data sourcing effort for schedules pertaining to CCAR and the FRY 14Q reporting to FRB.
• Analyzed (MDRM) and design of CCAR FRY 9C (HC-L Derivatives, OTC - Option, Futures).
• Collaborated with Axiom developers to link data to Federal Reserve Schedule templates.
• Created and managed the project schedule, monitored the whole team to complete tasks in timely manner. Recorded issue and work status to represent to Project Managers.
• Involved in documenting detailed Functional Requirement Specification based on CCAR requirements.
• Assisted the data sourcing team to integrate data using ETL tools, and involved in implementing complex Business Objects reporting solutions
• Participated in Axiom automation UAT. Identified and analyzed variances in the Reconciliation input and output form. Traced data work flow in Axiom.
• Acted as liaison between business users and Axiom configuration team.
• Resolved issues and conflicts between different stakeholders, found out proper resolutions to make all stakeholders satisfied.

Confidential, New York City, NY

Sr. Business Analyst

Responsibilities:

• Supported documentation of project scope and made project schedule with the Project Manager.
• Communicated with regulatory team to gather business requirement and worksheets. Created user stories on based on business requirements. Good understanding of stress testing and liquidity coverage.
• Worked on data analysis by identify source of data and target data for FRY - 14Q Schedule A Retail.
• Identified data requirements with data souring team and provided data mapping to “Control M”.
• Validated data based on data requirements by run SQL queries and set validation rules.
• Uploaded and maintained the most updated version of Data Mapping into Share Point.
• Confirmed Manual data input templates with Business Users and got sign- off.
• Performed testing phase by providing test cases and identified variances between expecting value and output.
• Defined and documented Requirements Traceability Matrix to provide requirements to test case linkage for audit purpose.
• Requested Quarter 4 2016 legacy filing from reporting team. Identified variances from Recon Form.
• Liaised between stakeholders and reporting team to identify and confirm issues for submission purposes.

Confidential

Business Analyst

Responsibilities:

• Captured and analyzed requirements through interactions with stakeholders.
• Project was implemented using the Agile Methodology to produce artifacts in the different phases of the Software Development Life Cycle (SDLC).
• Conducted meetings and review of the documents with the concerned teams.
• Accumulatedbusinessrequirements from variousbusinessusers and translated intobusinessrequirements.
• Documented discussions, stored the requirements and tracked the changes maintaining.
• Created use case scenarios and documents work flow andbusinessprocess with use case diagrams.
• Worked on wireframes and screenshots for the application to easily communicate it to business users and developers, using MS Visio to assist development and engineering in understanding the requirements.
• Participated meetings with review teams to continually improve the QA process for application developments.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change thebusinessspecifications for the product and ensured that the developers were updated.
• Employed Microsoft Project to manage schedules, deadlines, and resources and collaborate on the project implementation and management
• Facilitate UAT to ensure all applications were tested for functionality and were adequately accepted by user community.

Confidential, Stony Brook, NY

Responsibilities:

• Worked on Functional testing by provide testing documents, such as BRD, FRD, specification.
• Supported UAT, demo to end user. Worked on documenting change request, and impact analysis.
• Utilized 4C, 4P, SWOT strategies to analyze the current market competition and identified new markets of dyslexia and language learning markets, increased potential customers from 1 million to 48 million.
• Planed and launched the marketing campaign for CES (Consumer Electronics Show) in Vegas in January, 2014 with over $2 million investment.
• Assisted the company to obtain over $1 million research funding from the National Institute for Disability and Rehabilitation Research.
• Analyzed and improved the product function to expand the target market from one million to seven million.

Business Analyst / Data Analyst

Responsibilities:

• Participated in brainstorm workshop, worked on writing technical document.
• Supported developer by providing data mapping documents, data modeling and data formatting.
• Won the final prize of $20,000 for the initial fund by contributing market researches for a startup company-Forever Fuel to help them to improve the new product development process (NPD) and optimized the commercialization progress.
• Diversified business segments and identified potential markets for the company aboard, created a feasibility plan, developed a feasible approaches to commercialization.
• Applied market strategies and NPD to identify the problems of product development for commercialization a research result.
• Assisted the founder to estimate segments, and determined the target market of biodiesel companies.