SUMMARY

• 7+ years of experience in business process analysis/modeling, gathering business requirements, database design, and development of Web - based and Client/Server applications.
• Comprehensive knowledge of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Broad knowledge and experience in derivatives, including credit derivatives, interest rate derivatives, foreign exchange derivatives, equity derivatives, and commodity derivatives.
• Successful in translating business requirements and user expectations into detailed specifications using Rational Rose and MS Visio and the Unified Modeling Language (UML).
• Experience with Rational tools for creating use cases, version control, defect tracking, and monitoring, as well as using the Rational Unified Process (RUP) methodology in all phases of the software development life cycle.
• Experience in Power BI, Tableau and other data visualization tools in Business Intelligence.
• Knowledge of a diverse range of financial practices and principles, including financial analysis, corporate valuation, equity/capital market research, financial modeling, forecasting, and budgeting, as well as trend analysis, investment banking, asset allocation, portfolio management, risk analysis, and derivatives.
• Extensive experience with requirement analysis, use case design, test plan design, and developing database schemas based on logical models.
• Knowledge of money and capital market instruments.
• Capability to collect business and technical requirements from formal and informal sessions using a variety of software methodologies such as Use Cases and the Rational Unified Process.
• Knowledge of a wide range of technologies, including business process tools like Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, data warehouse concepts, and web design and development.

TECHNICAL SKILLS

Databases: MS SQL Server, ORACLE, MS Access, DB2.

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, Visual Studio, SSDT.

ETL Tools: SQL Server Integration Services (SSIS)

Reporting Tools: Power BI, SSRS, Excel, Tableau.

Programming: T-SQL, PL/SQL, DAX, MDX, Power Query M.

Operating Systems: Windows 7, Windows 10/11, MAC.

PROFESSIONAL EXPERIENCE

Confidential, TX

Senior Business Analyst

Responsibilities:

• Studied and comprehended cutting-edge processes through interaction with stakeholders and in-depth document analysis; also performed GAP analysis as Project Manager in transition planning.
• Collaborated closely with business groups to collect requirements, define business strategy, and build a centralized reporting capability for users to run analytical reports.
• As moderator, I facilitated JAD sessions and questionnaires, and I conducted interviews with various Subject Matter Experts (SMEs) and stakeholders, process reviews, and policy and procedure reviews to elicit requirements.
• Developed various tabular reports using Power BI features and improved them based on user requirements.
• Set up sales security and organizational hierarchy in preparation for Salesforce implementation.
• Personalized page layouts for standard and custom Salesforce objects.
• Created a business requirement document (BRD) and assisted in the creation of a system requirement specification (SRS).
• Conducted a SWOT analysis of business rules, business and system process flows, user administration, and business requirements before mapping them to the new system and thoroughly documenting them in the BRD.
• All EDI clients were migrated to the Oracle operating system.
• Worked with data models with complex relationships in Power BI and connected different data sources to Power BI desktop.
• Completed the EDI client base migration ahead of schedule.
• Created, documented, and implemented Oracle procedures for developing Trading Partner transactions.
• Assisting the business intelligence team with insights on the types of reports to be extracted.
• Determined the critical attributes based on the reporting requirements and ensured their availability.
• As part of requirement, migrated various tableau reports to Power BI.
• Collaborated on requirements gathering for various Relational Database Management Systems (RDBMS) in extracting data into staging areas and populating them onto Data Warehouse.
• Participated in dimensional Modeling processes such as the star schema and the snowflake schema.
• Constructed SQL queries on MS SQL Server and performed data mining to find correlation and patterns in existing data. In addition, JOINS and nested queries were used to export data from the database.
• Using HP ALM, I managed and tracked application life-cycle requirements.
• Collaborated with the QA team to create a Test Plan and Test Cases for User Acceptance Testing (UAT), Functional Testing, and Regression Testing.
• Handled change requests by conducting impact analyses on the business and technology fronts and submitting them to the change control board for approval.

Environment: Waterfall methodology, Salesforce, MS Office, Access DB, Informatica Power Center, MS Visio, MS Project, HP ALM, Power BI, EDI, Wireframes, Mock-Up Screens, MS SQL Server, UML, ETL.

Confidential, Buffalo- NY

Business System Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements for Claim File Process.
• Followed solely RUP methodologies during the project.
• Accumulated system requirements from various departments through surveys and interviews for Claim Management System
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users, and other stakeholders for open and pending issues.
• Created views/reports in Tableau Desktop that were published for Data analysis on weekly, monthly, daily basis and were published to the server
• Involved in Testing by using SQL and work with QA together to develop test Scenarios and test cases.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and ER Diagrams in MS Project.
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Worked extensively with MS Office (Word, PowerPoint, Excel, Visio, and MS access).
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also, responsible for conducting user training and user acceptance testing (UAT) to ensure and verify system is designed according to user needs.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.

Confidential, Foster City, CA

Business Analyst/System Analyst

Responsibilities:

• Examined and analyzed the business environment in order to identify process improvements.
• Analysis of the client's business and system requirements, as well as property and casualty modules
• Contributed to data modeling and the development of the data warehouse's conceptual and logical models.
• Assisting in the mapping of requirements to source systems, DW, and applicable data marts.
• Conducted user interviews, collected requirements, and analyzed them using Rational Rose, Visio, and Requisite Pro - RUP.
• Used MS Project to coordinate activities with the project manager and various other teams.
• The project aims to improve the existing online banking application's user interface, making it more user-friendly.
• Participated in a Business System Migration (Reval) project with a Derivative Management Systems IT group, Treasury Accounting, Regulatory, Murex Market Data, and Trading Systems.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed teh test cases and finalized.
• Define teh contracting terms based on various plans. Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing teh functionality, GUI and security testing.
• Worked in creating and integrating Microstrategy Reports and objects with teh data warehouse.
• Maintained a close and strong working relationship with teammates, developers, testers and management staff by conducted regular one-to-one sessions and group meetings.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans. Designed and developed project document templates based on SDLC methodology.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan wif emphasis on deliverables.
• Assisted teh Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed Test Plans and Test Cases according to Business Requirements.

Environment: Agile methodology, Smart draw, Just in mind, HIPAA, Bugzilla, PL/SQL, MS SQL Server, MS Access and MS Excel, MS Visio, web services, XML.

Confidential, TX

System Analyst

Responsibilities:

• Performed a gap analysis to ensure that the existing system infrastructure is compatible with the new business requirements for the Claim File Process.
• Throughout the project, only RUP methodologies were used.
• Gathered system requirements for the Claim Management System from various departments via surveys and interviews.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Involved in reviewing test plans and test cases and ensuring test cases reflect user needs. Also, responsible for conducting user training and user acceptance testing (UAT) to ensure and verify system is designed according to user needs.
• Contributed to the prioritization of defects and the creation of business requirements to resolve them.
• Conducted JAD sessions with management, subject matter experts (SMEs), vendors, users, and other stakeholders to address open and pending issues.
• Participated in testing using SQL and collaborated with QA to develop test scenarios and test cases.
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Worked extensively with MS Office (Word, PowerPoint, Excel, Visio, and MS access).
• Using UML (Unified Modelling Language) methodologies, planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario, and Use Case Narrative.
• Designed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and ER Diagrams in Microsoft Visio.

Environment: Rational Enterprise Suite (Rose, Requisite Pro, Clear Case, Clear Quest), Case wise modeler, IBM WebSphere, XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro.

Confidential

Business Analyst

Responsibilities:

• Worked as business analyst to support the re-design of the Mortgage Asset Management System. Extensively involved in the development of Reporting Data Warehousing System.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and lending.
• Wrote technical papers, gathered technical requirements, and compiled them to help the design the system.
• Gathered and documented business requirements. Formulated logical statements of business requirements research and evaluated alternative solutions to recommend the most efficient and cost effective solution for system design.
• Established a business analysis methodology around the RUP (Rational Unified Process).
• Analyzed existing systems logic difficulties and revised them as the needed.
• Assisted in building a business analysis process model using Rational Rose and MS Visio.
• Designed and developed use cases, activity diagrams, sequence diagrams, and OOD using UML.

Environment: MS Visio 2000, MS Office, SQL Server, C, MS Access, MS Project 2000, Window OS, Linux OS.