Business Systems Analyst Resume
Los Angeles, CA
SUMMARY
- Over 9 Years of experience as Business System Analyst in diverse domains like Investment Banking, Loans, and Commercial Banking. Thorough noledge of Fixed Income including Equity, Asset management, Bonds, Mutual Funds and Securities.
- In depth noledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like requirements, analysis/design, and development and testing.
- Experience in developing UML use case diagrams, work flow diagrams, data flow diagrams, flowcharts, screen mockups and report prototypes. using tools like Rational Rose and MS Visio
- Solid understanding of gap analysis, requirements management, testing and project plans.
- Practical noledge of Waterfall, Spiral, Agile & Extreme Programming (XP) SDLC Methodologies.
- Excellent Business writing skills in writing BRD, Use Case Specifications, SRS, FR, NFR & BR.
- Expertise in requirements gathering using different Elicitation techniques.
- Helped in creating a Data Dictionary having teh business definition of Data Mapping to map teh Logical Data elements in use cases to Physical data elements (record source).
- Experience in conducting Joint Application Development (JAR/JAD) sessions with end - users, expert team, development and QA team for resolving issues and making decisions.
- Excellent skills in analysis, design, development and implementation of ETL tools like Informatica Power-Center, Alteryx and reporting tools like Tableau, IBM Cognos and SSRS.
- Excellent noledge in SQL including writing Views & Joins.
- Experience in SQL Server Database design developing T-SQL queries, function, stored procedures, and triggers using SQL Server and used Data Adapter, Dataset, Data reader as a part of ADO.NET to access and update database in ASP.Net environment.
- Skilled with Data Analysis concepts of Data Modeling, Data Dictionary, Data Mapping and Normalization.
- Comprehensive understanding of Web-Services like WSDL, SOAP using XML and REST using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
- Knowledge about web servers like Apache Tomcat and Internet Information Services (IIS).
- Ability to implement Change Management and Defect Management techniques.
- Good noledge of database relationships and concepts; worked on RDBMS like MySQL and MS SQL server.
- Expertise in creation of UAT Plan, UAT cases covering different Business, functional and non-functional test scenarios and creation of expected test results & UAT execution including defect tracking and resolution.
- Expertise in agile-scrum process facilitation of scrum ceremonies and managing product backlogs.
- Knowledge and experience with widely successful agile techniques: User Stories, Velocity, Story Points, Product/Sprint Backlog, Burndown/Burn-up Charts, Test Driven Development.
- Experience creating test metrics including test coverage, test results, requirement traceability matrix (RTM) and acceptance reports using tools (Test Director, Quality Center) and manually.
- Involved in data warehouse at different layers staging, integration, and access
- Experience in reviewing documentation of developed solutions and authoring of basic instructions guides, and help files to assist in end user training and support.
- Exceptional communication skills aimed at conflict management and resolution
TECHNICAL SKILLS
Operating System: Windows XP/7/8/Server 2003/2008
Methodologies / Frameworks: RUP, Agile/Scrum, Waterfall, Extreme Programming
Business Analysis: Rational Suite (Requisite Pro, Clear Case, Rational Clear Quest,) MS Visio, MS Project 2000, UML, Jira, Rally, Erwin
Front-End Tools: MS Office Suite (Word, Excel, Access, PowerPoint)Data Bases Microsoft Access, MS-SQL Server 2012/2008/2005, Oracle 8i/9i/10g/11g/12c, MYSQL
Testing Tools: HP ALM 11.5, JIRA, HP Load Runner
Project Management Tools: MS Project professional, MS Project Server, and SharePoint 2010
Technical Tools: Java, JavaScript, HTML, CSS, XML, J2EE, HTML, TCP/IP, REST, SOAP, SOA, Visual Studio 2012/2010/2008/2005, .Net, ADO.NET, Eclipse, SQL, MS SQL Server, MySQL, JUnit, jQuery, C, C++, Tomcat, Spring Framework, Hibernate, WebLogic, IIS, SharePoint 2010/2007(MOSS)
PROFESSIONAL EXPERIENCE
Confidential, Los Angeles, CA
Business Systems Analyst
Responsibilities:
- Worked in Agile (Scrum) methodology to include teh continuous change management.
- Performed gap analysis, impact analysis and helped in design requirements.
- Interviewed stakeholders, gathered requirements and documented requirements.
- Analyzed teh market data from Bloomberg and Reuters to find teh consistency and efficiency of data via data mapping.
- Prepared Use cases based on Business Requirements and High Level Design using MS Visio.
- Build teh understanding for teh compliance requirements for fixed income securities.
- Creating normalization logic for teh developers to code and working closely with teh Quality Analysts for testing.
- Extracted raw data from Aladdin xml into excel using Alteryx and made it available to business users.
- Acted as liaison for projects with other corporate departments, including Executive, Legal and Information Services.
- Co-ordinated meetings between Blackrock team and teh Global Investment Support Office(GSO).
Environment: Asset Control, Alteryx designer 10.5, MS Excel 2010, Lotus Notes, Soap UI, Jira, MS Visio
Confidential, Oaks, PA
Business Analyst & Scrum Master
Responsibilities:
- Interviewed stakeholders, gathered requirements and documented requirements.
- Analyzed existing trading procedure and in corporate it into teh new system with improved automation and efficiency.
- Helped in different layers of data warehouse - staging, integration, and access
- Designed and developed project document templates based on SDLC methodology.
- Adept in designing and developing Use Cases, Activity Diagrams, and State Diagrams based on UML.
- Analyzed market data from different sources like Moody’s, Bloomberg, etc.
- Extensively worked with Portfolio Managers, Experienced Traders and Compliance Manager to configure teh rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
- Worked with managers to understand teh requirements for reporting on fixed income securities
- Build teh understanding teh data requirements for reports on fixed income securities.
- Creating different report prototypes for fixed income securities as well as understood teh source of data and how teh data is processed.
- Helped in creating a Data Dictionary having teh business definition of Data Mapping to map teh Logical Data elements in use cases to Physical data elements (record source).
- Created Logical data models and Logical to Physical Data Mappings.
- Acquired data from different systems and worked on Data Mapping.
- Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process.
- Maintained and tracked stakeholder’s requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational Clear Quest.
- Assisted with user testing of systems, developed and maintained quality procedures, and ensured that appropriate documentation is in place.
- Helped conduct User Acceptance Testing (UAT).
- Participated in developing teh test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product noledge.
- Acted as liaison for projects with other corporate departments, including Executive, Legal and Information Services.
- Assisted in development of training materials for new technology and process improvements
Environment: SQL server 2012, Visual Studio 2012, ETL-Informatica, HP ALM 11.5, SoapUI, QTP 8.2, Ajax, Microsoft Office Products like Excel, VISIO, JavaScript
Confidential, Tampa, FL
Business Analyst
Responsibilities:
- Working with Confidential team to understand their hedge fund requirements.
- Participated in various stages of data and requirement analysis for project needs.
- Gathered information from hedge fund managers and prepared business requirement documents and functional required documents.
- Analyzing teh accuracy of hedge fund financial calculations, business rules and transactions for teh application.
- Prepared Use cases based on Business Requirements and High Level Design using MS Visio.
- Understanding teh real end user needs and analyzing their requirements on different platforms performing a cost benefit analysis and Risk analysis.
- Analyzing teh current software and hardware system and evaluating their compatibility and scalability in developing teh present system.
- Developed use case scenarios, class diagrams and Sequence diagrams.
- Conducted various JAD sessions with different stakeholders in order to get a better understanding of ongoing activities and updating every party of their tasks and assigned duties.
- Documented business rules and business integration processes using BRD (Business Required Documentation) based on teh gathered requirements.
- Created Workflow and Activity diagrams using Rational Rose for clear understanding of teh static prototypes.
- Conducted periodic meetings with technical team in order to make sure that developments are adhered to teh business requirements and customer’s expectations.
- Verified that teh requirements are testable and involved in testing for teh software implementation.
- Imparted technical experience assisting database designers in teh development of current project right from teh business transition phase to database design phase.
- Used SQL queries for data validation retrieving teh date from teh back end.
- Developed various Test Plans and Test Cases and even assisted with teh black box testing.
- Verify teh issues raised during teh UAT testing and document them for teh development team to fix them.
- Responsible for resolving teh clients issue by working with Development and QA team.
- Constantly followed and reviewed SDLC methodology at every stage of software development in order to make sure that requirements are testable and necessary changes could be made before moving it to production.
- Preformed System Testing, Regression Testing, Functional Testing and also Conducted UAT (User Acceptance Testing).
Environment: SQL server, HPALM 11.5, QTP 8.2, .Net, Ajax, Microsoft Office Products like Excel, VISIO, JavaScript
Confidential, San Francisco, CA
Business Analyst
Responsibilities:
- Worked in Agile (Scrum) methodology to include teh continuous change management.
- Responsible for gathering business requirements for teh Security trading business, both in terms of enhancements to existing systems and in entirely new web applications.
- Responsible for working with teh Management Division to determine business requirements, converting those business requirements into technical requirements and an overall web strategy/design, and tan work with a team of developers to build, test and implement teh solutions.
- Used Web FOCUS as teh business intelligence platform as well as for ad hoc reporting.
- Extended Use Cases into descriptive sequence diagrams with linkage to constituent classes and objects.
- Operated in a SCRUM development environment along with waterfall methodology till teh requirements phase.
- Defined functional and technical requirements, modeled business processes while applying structured and object-oriented analytic techniques.
- Worked with IT department to develop product functionality and web usability specifications.
- Utilize Joint Application Development (JAD) to ensure greater client satisfaction and speed development times.
- Performed all aspects of teh SDLC including project planning and discovery, requirements analysis, systems design, implementation, integration and testing, quality assurance, deployment, and maintenance.
- Gathered requirements, interviewed end users, programmers and system analysts utilizing teh JAD concept to define teh system. Using Object Oriented Analysis (OOA) methodologies, prepared System Work Flow and Data Flow diagrams (Visio), performed gap analysis, briefed and updated team members (MS Project) and prepared briefings for management.
Environment: Oracle 10g, ETL-Informatica, HP ALM 11.5, QTP 8.2, Java, Ajax, Microsoft Office Products like Excel, VISIO
Confidential
Business Analyst
Responsibilities:
- Technology used: SharePoint, SQL
- Interviewed stakeholders, gathered requirements and documented requirements.
- Developed used case scenarios, class diagrams and Sequence diagrams.
- Conducted various JAD sessions with different stakeholders in order to get a better understanding of ongoing activities and updating every party of their tasks and assigned duties.
- Attention to detail, tenacious drive for problem solving, and ability to maintain grace 'under fire'
- Verified that teh requirements are testable and involved in testing for teh software implementation.
- Worked with team members to deliver new website options, widgets and applications within our product offering
- Responsible for resolving teh clients issue by working with Development and QA team.
- Constantly followed and reviewed SDLC methodology at every stage of software development in order to make sure that requirements are testable and necessary changes could be made before moving it to production.
- Preformed System Testing, Regression Testing, Functional Testing and also Conducted UAT (User Acceptance Testing).
Environment: C#.NET, ASP.NET, SharePoint 2010, SharePoint Designer 2010, Visual Studio.Net 2008, SQL Server 2008, WCF, Business Intelligence, Excel Services, Office 2008, XML, HTML, Cascading Style Sheets (CSS), Java Script and Windows 2008 Server, MS Visio, Quality Centre 10.2, Microsoft Project Manager
Confidential
Business Analyst
Responsibilities:
- Worked in Agile (Scrum) methodology as it was an ongoing project.
- Planned and conducted requirements gathering sessions with teh business team.
- Prepared data process maps and data flow charts to visually present teh proposed system to project management team
- Prepared various artifacts such as use cases, and functional requirement specifications by interacting with end users, project team and teh subject matter experts
- Performed activity based Cost Analysis and ROI and NPV calculations.
- Daily cooperation between business people and developers and welcomed late changes into teh requirement.
- Used detailed noledge of application features, architectures and functions to assess scope and impact of business needs throughout analysis and through teh completion of all enhancement specifications.
- Implemented repositories for teh documents on which work and time has been spent for future needs
- Developed understanding of teh system components such as web services, application servers, and its architecture.
- Lead Business user education and training sessions about teh enhanced system.
- Extensively used Quality Center for recording requirements collected from business users.
- Conducted manual testing of teh application to verify teh functionality and associated requirements.
- Responsible for creating teh test plans and test cases for teh application using Quality Center and mapped them to requirement and use case models for traceability.
- Arranged graphs and reports of defects to teh stake holder, maintained RTM to indicate teh progress and status of testing process.
- Published process documents and procedures as a graphical user guide for using Excel and Visio.
- Conducted JAD sessions to document visual process flow that brought transparency to organizational structure and behavior, quality control and corporate interpersonal relations.
- Created business process flow diagrams using MS Visio and developed PDF files for company wide distribution.
Environment: Quality Centre 10.2, Java, IE. 6.0, MS Visio, Microsoft Project Manager, RTM Services, XML, MS Office and Windows XP, Rally, SharePoint
Confidential
Software Developer
Responsibilities:
- Technology used: Server Side .Net, JavaScript, SharePoint, SQL
- Writing cross - browser compliant HTML, CSS & JavaScript
- Developing multi-user applications within a (SOA) service orientated architecture.
- Expanded noledge of .Net in-house Development system
- Contributed software engineering expertise in teh development of products through teh software lifecycle, from requirements definition through successful deployment.
- Facilitated customization of systems by encouraging software engineering team to adopt emerging standards for software application development architecture and tools.
- Worked with talented Graphic Designers to create elegant, modern, and user-friendly websites
- Advising customers and clients on teh limitations of systems and website functionality.
- Attention to detail, tenacious drive for problem solving, and ability to maintain grace 'under fire'
- Changing teh code, software or graphics of existing websites.
- Continually enhance my development skills and learned about architecting web solutions/technologies
- Worked with team members to deliver new website options, widgets and applications within our product offering
- Keep abreast of teh latest technologies and techniques within teh web development and design fields by working with team members, mentors and by prototyping solutions
Environment: C#.NET, ASP.NET, MOSS 2007, SharePoint Designer 2007, Visual Studio.Net 2005, SQL Server 2005, WCF, Business Intelligence, Excel Services, Office 2005, XML, HTML, Cascading Style Sheets (CSS), Java Script and Windows 2003 Server