SUMMARY

• An innovative and dynamic, technologically savvy Business Analyst with 8+ years experience, successful background in Business Analysis, Business Modeling, Requirement Gathering, Technical Documentation and Data Analysis.
• Domain experience in Assets and Financial Management and as well as all phases of the Software Development Life Cycle and a firm understanding of the technologies involved including Tableau, SharePoint, SOA (web services, XML) and SQL. Proficient in the use of CASE tools in gathering, analyzing and documenting requirement artifacts.
• Results driven business analyst with 8+ years of experience in core business processes supporting Finance, Accounting, stocks, mutual funds, FIIs, cash, Portfolios and risk management.
• Strong understanding of all financial instruments within investment banking and brokerage environments (Equity, FI, FX, Derivatives, Structured Products); Basel II Compliance (Credit, Market, Operational); Portfolio Risk (Credit Risk; Market risk, VAR Modeling, Back Testing, Stress Testing); Trading Lifecycle, Trade Settlement and Clearing, and Messaging Concepts (STP, FIX and SWIFT).
• Strong experience with the General Ledger to ensure that all transactional data conformed to GAAP standards.
• Strong knowledge and experience with International Financial Reporting Standards (IFRS).
• Experience conducting Joint Application Development (JAD) sessions and Joint Application Requirements (JAR)
• Experience in Business Process Modeling (BPM), Documenting BRD&FRD, creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams and Process mapping.
• Thorough experience with wireframe tools including Visio, Dream Weaver and Axure.
• Project Management: Risk Analysis and Risk Management, Impact Analysis and Change Management, Resource Planning, WBS, Gantt charts, SWOT and Cost Benefit Analysis
• Excellent Team worker with experience working with offshore and cross - functional teams.
• Experience in creating Test Plans, Test Cases, Test scenarios and Test strategies to ensure Quality Assurance and test all the business requirements.
• Intensive knowledge on HTML, XML, CSS in creating static and dynamic prototypes.
• Exposure to Mercury Test Director, and Quality Centre Experience in creating Requirement Traceability Matrixes (RTM) and tracing back the requirements.
• Experience in manual and automated testing with functional testing, system testing, regression testing.
• Hands-on experience in User Acceptance Testing and training of end users. Defined and documented business training requirements for new product releases.
• Experience in Data Warehousing, data analysis, data mining, data mapping, SQL queries, and Data Modelling (Conceptual, Logical, & Physical), ETL.
• Hands-on experience in MS SharePoint
• Understanding of different SDLC software’s not limited to PMP and Agile software.
• Good communication and customer service skills, Responsible, self-motivated and organized, excellent written, verbal Skills and an effective presenter.

TECHNICAL SKILLS

Méthodologies: SDLC; Waterfall, Spiral, Agile (RUP & XPtools, and SCRUM), Six Sigma (DMAIC, Green Belt)

Platform: Windows 98/2000/XP/Vista/7, UNIX, Mac OSX, LINUX, ERP, SOA.

Business Management Tools: GAP, SWOT, RISK, ROI, COST-BENEFIT & IMPACT Analysis

Databases: Oracle, MS Access, MS SQL, Main Frame Altova XMLSpy, Microsoft Visual

Languages: Java, C, HTML, VB scripting, .ASP, Visual Studio, Python, SOA (XML), SQL.

Business Process Modeling Tools: MS VISIO, RUP Tools (Rational Requisite Pro, Rational Rose, Rational Clear Case)

Testing Tools: HP Quality Center, Mercury QC

Documentation Tools: IBM Rational DOORS 9.5, SharePoint 2013, MS Office(Word/Excel/Power Point/ Visio)

Other Tools: Web X, MS Outlook, Rally, MS Excel Marketing Engineering, Oracle crystal ball.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Sr. Business Systems Analyst

Responsibilities:

• Assisted the team in producing design artifacts and ensuring all the documents are up to date with the current build.
• Created the Source to Target Mapping for all the interfaces for Security Master.
• Procedure involved collaborating with Requirements Teams and MDM team to ensure accurate landing and pre-landing table design.
• Documented all the current solutions (functional, non-functional/operational) applicable for both the work streams mentioned in Common Stakeholders Requirements Document (CSTK) in the Solution Specification.
• Familiarity with equities and derivatives of Security Master and Party Master.
• Author for multiple non - functional documents including: Informatica Application Requirement Document, Operations Manual.
• Tracked all defects and represented the team in Defect Review Meetings on a routine basis. Work involved triaging the defects with internal and external teams in different environment
• Collaborated with various service providers from multiple teams to safeguard standard Interface Control Documents were provided; delivered reviews to the team before giving final sign-off.
• Helped organize the team on quality control by standardizing process in the Internal SharePoint site.
• Used Oracle TOAD to validate business rules.
• Used MS Excel and Excel VBA to generate reports.
• Used to IBM Rational DOORS to generate Requirements Traceability Matrix by ensuring proper linking between design documents and business requirements.
• Used SQL to define transformation rules and business logics for an end-to-end basis.
• Created data models and defined processes using Microsoft Visio.
• Acted as the POC for document deliverables for the Project Management Office (PMO) ; gave LOE’s and provided feedbacks on risk items highlighted by the PMO team.
• Used UNIX scripts to check active directory before doing clean up in the own environment
• Used UNIX in order to do look up and check in autosys files.
• Used IBM ClearQuest to check in Autosys, PowerCenter code and files for migration.
• Familiar with Modified Waterfall Methodology implemented by Confidential .
• Hosted meetings and acted as the chair in large participants using WebEx one click and Microsoft Outlook.

Environment: Informatica Power Center 9.5.1 Hot Fix 2, IBM Rational DOORS 9.5, Oracle 11gr2, Microsoft SharePoint 3.5, Autosys R11, I Cart 7.1.1.4, IBM ClearCase 7.1.1.4, ESB 2.0, EPF 2.7, EPV, Cisco Jabber 9.6.3, Cisco VPN Client 5.0.05, Meeting Planner 5.5, Microsoft Office Suite 2007/2010, Mozilla Firefox 31.3, Putty 0.59, Remedy Client 7.1, Text Pad 5.0.3, WebEx Meeting Center 29.8, VPN Soft Token 4.1.0, WinSCP Wintel Desktop 5.1, WinZip 18.

Confidential, Pennington, NJ

Sr. Business Systems Analyst

Responsibilities:

• Coordinated with PM to discuss and create template for Project Technologies, Methodologies, Budget, Time factor, Risk register, MS project timeline, Project mile stones, WBS, Critical path analysis.
• Planned and supervised target meetings (with SME’s such as Financial Advisors), JAD sessions (with all Project stakeholders including Tech Leads), direct interview sessions, conference calls and produced detailed artefacts such as Surveys/Questionnaires and minutes of meetings covering issues discussed.
• Gathered, analyzed, documented high level business requirements and produced corresponding technical requirement artefacts such as Business Requirement Documents (BRD), System Requirement Documents (SRD), Test Cases, Requirement Traceability Matrix and all the affiliate artefacts like UML diagrams (Use Case, Activity, and Sequence Diagrams).
• Conducted Gap analysis, SWOT analysis, Decision Point Analysis, Communication Analysis, Business Rules Analysis, Document Analysis and other related analysis such as Scope creep assessments and Goal Orientation Assessments.
• Conducted detailed Process Analysis and Decision Tree Analysis and assisted in Business Process Re-engineering procedures including identifying bottle necks and failure points, and developing alternative paths for process flow.
• Exposure to Six Sigma methodology including different layers (yellow and green belt).
• Effectively managed project risks by creating and managing a Risk Register, which identifies, prioritizes and measures risk, risk drivers and expected loss.
• Assisted the Project Manager in developing, tracking and managing the project triple constraint: schedule, cost, resources and scope using MS Project.
• Applied Agile SCRUM and conducted Sprint Planning meeting, stand up meetings, retrospect meeting and created spring backlog.
• Exposure to Business Intelligence tools: IBM Cognos
• Monitored offshore and cross-functional teams closely to ensure all members are focused in meeting goals.
• Assisted UI/UX team in translating client graphical requirements to reality by creating Mock-up Screens.
• Effectively managed change by deploying change management techniques such as Change Assessment and Impact Analysis.
• Assisted design and validation processes by performing explanatory Data Mapping and supervised Data Migration protocols.
• Ability to read and understand coding language to transform functional to technical requirements documents.
• Facilitated the Designed and development of Business Rule Engines to support SOA architecture and web services.
• Worked closely with System Architect to implement Service Oriented Architecture (SOA), Client side Validations, Server side Validations, Web Method definitions and data modeling.
• Involved in defining the business logic for making decision about aggregating federated information in real time, resolving sourcing system conflict and coordinating data visibility with data quality rules incorporated in the in-house application.
• Used UNIX to look up active directories.
• Identified and documented Business Rules, created detailed Use Cases, and Conducted User Acceptance Testing.
• Played role as a mentor for Jr. Business Analysts to help them better understands different goals of the project.
• Made recommendations to increase stability/mitigate risks.

Environment: Water Fall, AGILE SCRUM Methodology, RUP Tools (Requisite Pro, Rational Rose), Oracle 10G, SQL Server, MS Word, MS Access, MS Excel and MS Project, HP Quality Centre.

Confidential, Jersey City, NJ

Business System Analyst

Responsibilities:

• Planned and facilitated JAD sessions focused on functional areas that required integration and created the functional requirements specification from the business requirements.
• Partnered with Wealth Management teams to understandbusinessobjectives, technical and integration requirements based on all functional areas that were to be merged.
• Performed GAP analysis for the application to identify the AS-IS and TO BEbusinessprocess to improve the process in the project.
• Identified relevant issues, propose solutions, recognize alternatives and present this in a logical and objective manner.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Business Process Flow, Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Scheduled meetings with developers, SAs (SystemAnalyst) and testers to collaborate resource allocation and project completion using MS Project.
• Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
• Regularly worked with the UI/UX teams on the CMA (Content Management Application) and CDA (Content Display Management) teams.
• Wrote complex business rules for client-side and server-side validations to explain interactions between different tiers.
• Conducted Change Assessment and Impact Analysis when the stakeholder demanded a Change Request.
• Using MSSQL validated, performed Data Mapping and supervised Data Migration protocols.
• Participated in Disaster Recovery events.
• Assisted the SA to document all custom and system modification and notify problems to appropriate software development team for fixes.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in Requisite Pro.
• Authored progress and completion reports which were then submitted to project management on a weekly basis.
• Managed the triage, resolution, communication, and problem review for major incidents.
• Prepared test cases and test plans and carried out the UAT as per the perspective of the users.
• Coordinated UAT of the productwith Business Users UsedMS Project for status reporting and planning.
• Trained Jr. Business Analysts for the development of the team.

Environment: MS visual Studio, Windows Advanced Server, UNIX Oracle Platform, MS Visio, RUP 2008, Load Runner, Rational Rose, Rational Robot 2008, Rational Clear Quest 2008, Rational Clear Case 2008.

Confidential, New York City, NY

Business Analyst

Responsibilities:

• Explained the users and senior management thecurrent design challengesin supportingEquitiesfor USA.UsedPowerPointfor creatingpresentations.
• Documented the'current state'and'future state'of the data extraction and enrichment process and performedgap analysis.
• Developed the system to capture any possible incidents of dealing ahead of a price sensitive announcement.
• Discussed and reviewed the enhancements required supportingListed Derivativesfor Americas and EMEA.
• Proposed bothstrategicandtacticalsolutions towards fillings the gap for supporting Listed Derivatives.
• Discussed the Shares Equivalent concept with users and created sample report templates depicting the same.
• Formulatedcalculationsthat depict the client's / traderstradingpattern by looking at the net executions in last 3 days and comparing them over with their prior history.
• Generated risk reports and provided status on risk items to Project Management Office (PMO)
• Created risk ledger for the team accounting all the possible risk exposures in different iterations.
• Interacted with portfolio analysts and asset managers to finalize the Business Requirements for the application.
• Conducted JAD (Joint Application development) for the requirement gathering and used Rational Requisite pro to analyze and prioritized the requirements.
• Worked on Accounting Principles: ledgers, statements, cash flow, tables, and accounts including accounts receivable.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Extensive work on IBM File Net process engine for data collection and data management.
• Used RUP methodology to define user’s requirements and to design the final system.
• Produced the visual models for the application using Rational Rose to create use cases, state charts, sequence diagrams, deployment diagrams and activity diagrams.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed.
• Involved in mapping and improving the current business process.
• Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing the functionality, GUI and security testing.
• Performed operationalRISKgap analysis involving front/middle/back office to identify and rectify regulatory compliance (DoddFrank) and internal fraud weaknesses.
• Assisted the stakeholder meet its overall strategy to implement a more efficient way to meet regulatory and compliance reporting requirements by studying and researching the DoddFrank.
• Performed risk analysis of the requirements to identify the key business risk areas for the project and prioritized the application development and testing.
• Facilitated the weekly meetings with the review teams to continuously improve the QA process for the application development.
• Writing Test cases and uploading to Quality Center for testing in QA as well as Production and uploading test approval proofs in QC for passing the test.
• Used power point presentations for conduction walkthroughs with the stakeholders.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.

Environment: Microsoft Office suites (Word, PowerPoint, Access, Excel Pivot, Rational requisite pro, Outlook, Project, Visio), Microsoft SQL Server, HTML, Oracle, UML, Object Oriented Analysis and Design, SQL, IBM File Net, Quality Center, Accounting tables.

Confidential

Business Analyst

Responsibilities:

• Participated in meetings with each department with responsibilities on the checklist to ensure accuracy of the checklist and to explain how it would be used with the future mutualfund portfolio merger projects and new mutualfund portfolio launches.
• Involved in Business Process Management, Documentation, External and Internal Communications, Governance Processes, Program Issues and Risk, Risk Mitigation, Audit and Change Requests.
• Managed stakeholder’s expectations and satisfaction issues ranging from process building, to services delivery, to support.
• Coordinated participation and sign-off of various business partners and customers.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Followed solely RUP methodologies during the course of the project.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Made sure the test cases and test process guarantee accountability to business and systems requirements.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Reviewed current SOX compliance reports worked with the business users to automate the SOX regulations to the system and reported the gaps to the management

Environment: Rational Rose and Requisite Pro, MS Visio, MS Project, UML, Rational Clear Quest, Rational Clear Case, RUP, Business Objects, Mainframe, Microsoft Excel, Microsoft Word, Microsoft Power Point

Confidential

Business Analyst

Responsibilities:

• Gather the requirements for arriving at the reach a breakeven point where the firm starts making profit for itself and its stakeholders.
• Prepare the complex business logic to feed to the software that evaluates the breakeven using various methods such as Discounted cash flow method (DCF), NPV, IRR method to reach to the acceptability
• Gathered the data for the Industry analysis, market share, Key growth driver in mobile services industries, Telecom services revenue, data voice, Non-voice ARPU, Global broadband penetration
• Fed the data to the software that analyzes the sensitivity to see how the variance in the critical parameters changes the impact on revenue and effects the decision
• Studied the 5-year of forecast of ARPU taking into account the industry growth, the structure of the company, the market share and historical CAGR, as well as the projected demographics details.
• Gathered the syndicated historic data of ARPU of existing 3G businesses of developing and developed nations.
• In order to develop the forecasting model, we take assumptions based on PWC report and FICCI,HSBC Global Research in order to achieve the same.
• Documented specifications for calculating and analyzing of the BETA (systematic risk) using linear regression model, Sensitivity analysis for variance in factors mentioned earlier, hence highlighting the most critical factors. Measuring skewness (how biased the data is towards one side) & Kurtosis of projected 3G ARPU.
• Created detailed sequence diagrams, class diagrams and activity diagrams to elaborate the behavior, structure and process flow for the use-case models.
• Assisted in developing test cases to check the system functionality
• Implemented Requirement Traceability Matrix (RTM) to tracking functional/non functional requirements to test cases.
• Assisted users to perform paper trading during UAT and created user guides for end users

Environment: UML, MS Visio, MS SQL, MS Office Suite, Mercury Quality Centre, UML, Quality Center, J2EE technology, UNIX / Oracle Platform, waterfall

Confidential

SQL Developer

Responsibilities:

• Provided assistance to development teams in the design, development, testing, tuning and implementation of database applications.
• Developed Data Models (Operational, Dimensional and Data marts) to map data from mid tier to Database.
• Developed Extract, Transform, Load (ETL) routines for backend databases using PL/SQL / OWB and Oracle / Teradata Data.
• Developed Database DB Objects (Tables, Views or Materialized Views, Stored Procedures & triggers).
• Involved in Data Integration from various Oracle DWs into AEDW (Active Enterprise Data Warehouse) Teradata Environment.
• Generated ad-hoc Data Extracts and Reports from data warehouses based on business needs using queries.
• Analyzed Data in case of data privacy/data mismatch incidents raised by end users or clients.
• Involved in Data security management/Encryption initiatives.
• Assisted technical team with Bug fixes/Issue resolution working directly with Oracle supports team.
• Supported and generated Daily Data Migration to different production environments.
• Health and integrity monitoring (using Microsoft OEM) of Databases.
• Backup and Recovery of Database.

Environment: Pair Programming Methodology, Oracle Open Source Stack (MySQL, Java), MS SQL Server, MS Suite (MS Word, MS Access, MS Excel and MS Project)