SUMMARY

• Sr. Business System/ Data Analyst with 7 + plus years IT experience, and extensive knowledge of Software Development Life Cycle (SDLC) phases and RUP, Waterfall, Agile methodologies, QA Testing Methodologies and the inter - dependencies of the phases through the project life cycle.
• Skilled in Requirements elicitation techniques-conducting user interviews, document analysis, conducting JAD sessions, prototyping, surveys etc.
• Adept at documenting the existing As-Is Systems, process flows and working on Business Process Reengineering/Gap Analysis of legacy systems.
• Proficient in analysing Business Requirement Documents (BRD) and creating Functional Specification Documents.
• Experience in Data Profiling, Data Manipulating and Data Parsing using complex SQL queries against various Database Environments.
• Experience working on large datasets and data manipulation using complex SQL queries.
• Experience working with Excel functions like Pivot, VLOOKUP and Confidential working knowledge of VBA.
• Experience on creating Source to Target Mapping documents, gathering business requirements from business/user, creating Process Flows and Data Flow Diagram (DFD). Working directly with ETL team for data extraction, Data Quality (DQ) team for validation.
• Worked with Data Management team for exceptional data handling.
• Hands on experience in testing ETL mappings and Business Object (BO) reports.
• Experienced with writing and executing Structured Query Language (SQL).
• Good Analytical skills coupled with excellent problem solving skills.
• Competent in developing Use Cases and creating Use Case Diagrams, Analysis model, Activity diagrams (UML methodology), process flow diagrams & Wireframes using Visio, Rational Rose and Enterprise Architect.
• Reviewed and assisted in creation of manual test plans, test scenarios, test cases for Functional, System, Integration and Regression Testing based on requirements. Coordinated User Acceptance Testing (UAT) based on the Requirements document.
• Analysed defects and interacted with QA / Development teams to fix issues using Defect Life Cycle tracking and Bug-reporting tools.
• Clear communication and interpersonal skills, with ability to interact and convey precise technical details with individuals at all levels.
• Open to dynamic work environment and ability to work collaboratively with business analysts, testers, developers and other team members in the overall enhancement of software product quality.
• Conducted training sessions with power points presentations for junior analysts in Business Analysis Concepts.

TECHNICAL SKILLS

Management Tools: MS Office, One Note, MS Project, MS Visio, Documentum, JIRA

Business Process Tools: SharePoint, Confluence, Slack, Rational DOORS, Requisite Pro

Test Management: QTP, Quality Center, Rational Quality Manager

Data Analysis: MS Excel, Pivot Tables, VLOOKUP, TOAD, SQL

Object Oriented Programs: C#, ASP.Net, UML

Methodologies: AGILE/SCRUM, RUP, Water Fall, STLC, Defect Life Cycle

Data Base/DWH/BI: Oracle, SQL Server, Tableau, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential, Riverside, RI

Sr. Business Data Analyst

Responsibilities:

• Worked as Confidential business analyst to build enterprise reporting system to Risk Management, Credit Risk, Support Risk Analysis, Securities and their Valuation, Asset Management, risks and returns, Bond Pricing, MBS, ABS, Derivatives (repos, interest rate swaps), Money Market Instruments and used strong knowledge of financial statements, cash flow, Financing Structures, Capital Management, Portfolio Analysis, Budgeting, trade capture application, risk management, and Investment Accounting.
• Created cash flow models for Mortgage Backed Securities, Whole Loans, Structured Securities using Bloomberg, Intex and ADCO data
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities
• Created data visualizations using Tableau, support end users on using Tableau Desktop and Server, and maintain projects and user groups on the Tableau server
• Generated requirements for Capital Markets - Fixed Income Investment Management Business, Portfolio Management, Hedge funds, corporate actions, Brokerage and Trading Model within the scope of both the Front and Middle Office.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality issues
• Wrote specification to implement application feed for trade-processing lifecycles from pre-trade analysis to post-trade risk management, settlement and regulatory compliance with SunGard's Capital Markets and Investment Banking solution.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Operating SWIFT messaging service for financial messages, such as letters of credits, payments, and securities transactions, between member banks worldwide.
• Translated business requirements into functional requirements and prepared an extensive project plan to reduce inter-company transactions in equity derivatives and foreign exchange trades.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Datastage, Data Warehousing, WebSphere and Cognos.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Conducted market research and analysis in Capital Markets consisting of Stock Market and Bond Market
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database
• Worked on data modelling and produced data mapping and data definition documentation
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in Confidential MS SQL Server 2005 environment
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment: Microsoft Office Suite, MS Visio, Windows XP, Dreamweaver, RUP, SQL, PLSQL, XML, VB, ASP, UNIX, Crystal Reports, Adobe Photoshop, Mercury TestDirector, WinRunner, LoadRunner

Confidential, Emeryville, CA

Business/Data Analyst

Responsibilities:

• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB.
• Documented the Process Flows for B2C and B2B in the High Level Requirements Document.
• Worked on Oracle Manufacturing and Supply Chain Management modules including OM, Shipping and Execution, Pricing, Inventory, and AR.
• Experienced in designing Master Data Management CRUD & Business Processes required to run, improve, and transform the business.
• Created advanced chart types, visualizations and complex calculations in Tableau to manipulate the data.
• Used SQL queries for organizing and abstracting data from MS access data bases, created reports, forms on Ms Access.
• Captured Data flow diagrams and formatting of the data flowing modeling through interfaces.
• Accumulated system requirements from various departments like accounting, IS (Information Systems) through surveys and interviews.
• Assigned tasks among development team monitored and tracked progress of project following agile methodology.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have Confidential clear-cut picture of the project
• The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Gathered Web Content Management requirements from business units, translated those requirements into wireframe designs, and delivered HTML and CSS wireframe prototypes to client for implementation.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint, and MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint.
• Provided expertise in strategic planning, business process modeling, business process analysis, object-oriented analysis & design, use case modeling, use case analysis, component-based development, and quality assurance.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure Confidential stable and accurate solution.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering
• Created exceptions report which were then submitted to project lead and stakeholders on Confidential regular basis.
• Facilitated user acceptance testing and test strategies with Information Systems Group.
• Performed manual front-end testing to check all functionalities of different modules.
• Demonstrated business on in-house developed Content Management System CMS template with developers to deploy the application.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion

Environment: HTML, XML, Clear Case, Clear Quest, Agile, Rational Rose, JAD, MS Visio, UML, MS Project, SharePoint, Oracle 11i, MS SQL Server, MS Access, MS Excel and MS Word.

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Complete project leadership of ecommerce solution for target.com business platform for multiple sales channels - Business direct (B2B), Consumer Direct (B2C) and Retail channels using Microsoft Project for Web 2.0 architecture with Agile software development.
• Monitored customer activity with Digital Services and developed corrective action plans to address issues/defects.
• Participated in the business processes conducted and controlled through Salesforce.com and requirements of the tool
• Supported the GSA (Manhattan's Professional Services Automation Tool) Roll Out globally
• Define technical goals and business processes for the ecommerce platform.
• Experience with packages like Endeca, ATG, FatWire, Sterling Commerce Yantra, Unica, e-Commerce, Demand Ware, etc.
• Help analyse, troubleshoot, and/or tune Sterling Commerce product performance or deployment issues when required
• Responsible for providing technical and functional expertise and direction for the Sterling (formerly known as Yantra) OMS (Order Management System) delivery.
• Conceptualize and define an ecommerce platform that is highly available, highly scalable, with low maintainability and high performance, built using reusable components and optimized
• Created estimates, budgets and shuffled resources between tasks as needed.
• Using Tableau to create executive dashboards for Supply Chain Management
• Help develop and propose Sterling OMS-centric processes, policies, and standards
• Expert knowledge of Sterling Order Management System components, API's, and related Interfaces
• Created WBS, negotiated Triple Constraints, wrote RFP and evaluated proposals
• Full project lifecycle experience on several large, complex Sterling Commerce/Yantra solution implementations
• Worked with internal users for bug management and bug triaging.
• Played Confidential substantial role in defining processes and in gathering business and functional requirements for selecting the right stock option for the customers.
• Utilized Requisite Pro for preparing the Business requirements document.
• Created data models and business process models using Rational Rose. Followed top down leveled technique for building the Business Process Models.
• Participated in the process of preparing verification master plan to clearly and concisely describe the company's philosophy, expectations, and approach.
• Interacted with Business Users to generate and review business test cases to upgrade User Interface system.
• Manage Risks: Risk management and mitigation. Anticipate, enumerate and plan for contingencies.
• Streamline operations and optimize resources for ecommerce platform.
• Detailed reporting on pre and post deployment activities and tasks.
• Define release plans for ecommerce platform with release managers according to gathered information from various IT departments.
• Saved over $4.5 million over complete lifecycle of ecommerce project by incorporating advance research and implementing project optimization techniques.

Environment: Ascential Data Stage 6.x/7.x, Oracle 11i, Agile, Sterling/Yantra OMS, IBM DB2, Syncsort, Erwin 4.0, Business Objects 5.x, IBM AIX-UNIX 5.0, Windows NT, Shell Scripting, SQL, PL/SQL, Test Plan, Test Cases, Test Scripts, COBOL, VSAM Files, TSO, MVS, ISPF, JCL, XML, XSLT, XSD, XML Spy.

Confidential, Montvale, NJ

Business Analyst/ QA

Responsibilities:

• Involved in analysing the Mainframe Legacy System documents to understand the business process, the limitations and the rules related to promotion management across the stores as stated in the BRD.
• Worked closely with business users while facilitating the requirements gathering sessions, analysing and verifying business & technical processes from the stakeholders.
• Authored the Functional Requirements Documents and validated it with the business.
• Created Activity diagram to define the Coupon Data Flow and Screen Navigation Diagrams.
• Responsible for creating wireframes using MS Visio to design the data field migration from the old system to the new platform.
• Worked with the Development lead in charting out Confidential deployment plan for co-issuance of promotions and migrating to the new systems.
• Assisted Testing lead in creating different Testing scenarios pertaining to the various promotions and their interlinking, defined Test scripts and reviewed defects with developers.
• Acted as Confidential point person for the business to help them conduct the UAT Testing.
• Interacted with quality analysts to make sure that the new screens meets requirements and managed defects through the UAT and production phases.
• Used Quality Center for Planning, Execution and Bug Tracking.
• Worked on documenting for Version Control, to maintain up to date changes in the documents.
• Provided end user training for users for the new systems.

Environment: Oracle Database, Retek, SQL, Oracle Forms, Reports, MS Visio, HP QC, MS Project, TOAD