ABSTRACT:

Sr. Business Analyst with over 6+ years of professional experience in Healthcare, Food, Insurance, Banking and Finance; domain knowledge includes Project Management and Business Intelligence.

SUMMARY:

• Worked closely with the Business Intelligence (BI) team to assist Project requirements, functional analysis and converting business requirements into functional requirements
• Adept at preparing business requirements documents (BRDs), defining project plans, writing system requirements specifications (SRS), and delivering project/status reports.
• Well versed with Rational Requisit e Pro for requirements management.
• Experience in developing Use case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using MS Visio so that developers and other stakeholders can understand the business process.
• Lead and worked with cross functional teams to examine and solve business problems by accurately analyzing the needs of clients and helping them achieve improved quality and value for the customers.
• In depth knowledge of RUP, Agile, waterfall Software Development Life Cycle (SDLC) processes
• Proactive team player with demonstrated problem solving and analytical reasoning abilities.
• Skilled at performing Gap analysis, Risk analysis, along with good knowledge of process workflow tools and techniques.
• Familiar with MS Project to manage schedules, deadlines, resources, collaborate with different teams, and analyze project information.
• Familiar with Mercury Quality Center to design and develop test plans and test scripts and good at quickly learning technologies and systems that are organization/project specific.
• Expertise in writing basic SQL queries for testing and data validation
• Experience in new process technology implementation and, and conducting system and user acceptance test (UAT).
• Comprehensively involved in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with .NET, Import/Export data, Bulk insert and BCP.
• Hands on experience in developing Drill through and Drill down reports using SQL Server Reporting Services (SSRS).
• Experience in developing user reports and management reports using MS SQL Server Reporting Services (SSRS).
• Expert at analyzing, designing, and reengineering systems applications and business processes.
• Excellent written and oral communication skills with a results - oriented attitude.
• Business Analysis experience includes conducting JAD sessions, requirements gathering, documentation (Project Charter, BRD, and FSD), diagramming data and process mapping, compiling detailed project plans, and developing test plans and test case scenarios.

TECHNICAL SKILLS:

Analysis & Design: Waterfall, Rational Unified Process (RUP), UML, Use Cases, MS Project

Database: Oracle 7.3, SQL Server, MS Access

Tools: Visual Studio, Macromedia Flash, Adobe Photoshop, Test Director, Omnigraffle, MS Visio.

Packages: MS Office 97/2000/XP, MS Project, SAP ECC 4.7

Operating Systems: Windows 98/ME/XP/NT, DOS, Mac

Architecture: J2EE, .NET

Others: Crystal Reports, Rational Rose, Rational Requisite Pro, Rational Clear Case, MS Visio, PVCS, Win Runner, SAP Solution Manager, SharePoint, Adobe Acrobat pro

PROFESSIONAL EXPERIENCE

Confidential, Anaheim, CA

Business Systems Analyst/ Business Intelligence

Responsibilities:

• Interacted with Users, Developers, Project Manager and SMEs to understand the business processes, identify enhancements and gather Requirements.
• Participated in the identification, understanding, and documentation of requirements including the applications capable of supporting those requirements.
• Prepared Use Cases, Activity Diagrams and Sequence diagrams by using MS Visio.
• Conducted JAD sessions with the stakeholders at regular intervals.
• Documented project related artifacts and sent them for onsite review and stored them in the MS SharePoint site.
• Wrote use cases, designed wire-frames and workflow diagrams to supplement the business requirements and mapped the use cases to corresponding business requirements.
• Interacted with the SME to clarify any doubts on requirements.
• Accessed data from data tables using SQL queries.
• Extensively used Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
• Created and developed the stored procedures to handle complex business rules, history data and audit analysis.
• Middle Office tasks (tool used to prepare Personalized Communication Statements) so that appropriate Personal Communication Statements with accurate data are sent to the participants.
• Reviewed analysis and test plan documentation updates and evaluated the results of the test execution.
• Designed data processing technology and built logical and physical MSSQL database models.
• Provided analysis of database work.
• Resolved Data Warehouse MSSQL database performance issues by improving its architecture.
• Advised new improvements on the reporting tools, used in the MSSQL database.
• Mentored developers on the improvements of the Data Warehouse architecture and various other programs.
• Provided programming, testing, performance tuning, and production support on Oracle database.
• Reviewed analysis of benefits and pension plans.

Environment: RUP methodology, MS tools - Visio, MS SharePoint, MS suite, SSIS, SSRS, BIDS.

Confidential, OR

Sr. Business Systems Analyst

Responsibilities:

• Interacted with Users, Developers, Project Manager and SMEs to understand the business processes, identify enhancements and gather Requirements.
• The project involved creating a Data Warehouse for Food Industry data, by grouping the data by subject area and building data models for the various applications, like Samples, Lab, and Licensing.
• Performed Gap Analysis on the existing Food Repository and drafted the requirements to be built for the Food Data Warehouse accordingly
• Participated in the identification, understanding, and documentation of requirements including the applications capable of supporting those requirements.
• Prepared Use Cases, Activity Diagrams and Sequence diagrams by using MS Visio.
• Conducted JAD sessions with the stakeholders at regular intervals.
• Documented project related artifacts and sent them for onsite review and stored them in the SharePoint.
• Responsible for creating step-by-step guide for the Department supply planning function
• Trace and Track process is developed to find the best solution.
• Wrote use cases, designed wire-frames and workflow diagrams to supplement the business requirements and mapped the use cases to corresponding business requirements.
• Prepared Request for Information (RFI), Business required document (BRD) and Request for Proposal (RFP).
• Interacted with the SME to clarify any doubts on requirements.
• Middle Office tasks (tool used to prepare Personalized Communication Statements) so that appropriate Personal Communication Statements with accurate data are sent to the participants.
• Reviewed analysis and test plan documentation updates and evaluated the results of the test execution.

Environment: Waterfall methodology, MS tools - Omni Graffle, MS suite, Adobe Acrobat Pro, SharePoint

Confidential, Reston, VA

Business Analyst

Responsibilities:

• Conducted requirements elicitation meetings with end users to document business requirements in BRD and used Rational Requisite Pro for management of these requirements.
• Analyze and supervise the data warehousing functions of data compilation, extraction, loading, cleansing and modeling
• Handle the various aspects of the end to end lifecycle related to complex data warehousing and business intelligence projects
• Transformed BRD into Use Cases using UML for new product functionality. Used tools such as MS Visio to define business Use Cases, and activity diagrams.
• Analyzed and documented differences between the As-Is and To-Be processes.
• Made recommendations to development teams regarding the design and implementation of any missing functionality.
• Framed out Business Transaction rules, inventory control rules, supply chain rules for SCM and related Documentation.
• Responsible for working with the manager and other users and creating Work flow diagrams and Business process flow diagram as per the detail requirement analysis of supply chain management.
• Participated in design and status meetings with other team members to discuss problem identification, prioritization and resolution.
• Participated in Release walk-thru, demo & presentation of the new releases and documented the feedback.
• Provided accurate estimates of effort for the new requirements and enhancements.

Environment: MS Visio, SQL Server, Windows 2000, MS Office suite, SAP ECC

Confidential, Richfield, MN

Business Analyst

Responsibilities:

• Gathered Business Requirements from the client.
• Did extensive meeting with the development team to transform the requirements to design high-level design documents.
• Did extensive research by meeting with senior executives and business users.
• Built up and maintain a strong data warehousing system for the organization
• Determine the strategies to design the application, network and data architecture
• Defined Project Scope and maintained Project plan and schedules.
• Identified Risks and Developed Mitigation Plan.
• Bridged between all applications of the project.
• Sat through Detailed design reviews and make sure development conforms to business requirements.
• Create and establish the solution architecture for the Auto Top-Up solution
• Analyze load, stress and performance parameters for the solution
• Review and analyze business requirements and design use cases for the solution
• Review and deliver functional requirements specifications to all component owners
• Review all interfaces related design definition documents
• Manage all technical risks associated with the project
• Participate in customer-facing and senior management meetings to provide weekly updates and status reports
• Worked within an In-Shore & Off-Shore delivery model to ensure solution architecture deliverables and related system requirements were met within time and budget constraints
• Coordinated performance and security testing efforts for the solution.
• Worked with web developers for extending the functionality of a web server and for accessing existing business systems with java servlet technology.

Environment: Windows XP, UML, SQL Server, PL/SQL, Quality Centre, MS-Excel, MS-Visio.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Worked closely with the Project Manager and other key decision makers in understanding the scope of the project - Asset Classes, Legal Entities & data sources.
• Created Business Process Models and work flows detailing all activities of the various business groups in scope from conceptual to procedural level
• Worked with the Project Manager in planning and grouping of the logical components based on RUP guidelines for focused and efficient requirement gathering
• Facilitated JAD sessions with operational and business stake holders for capturing requirements,
• Performed feasibility and risk analysis to identify the critical requirements and prioritizing them based on the user’s need and documented BRD and FRD
• Documented Functional Specifications and created UML diagrams-Use cases, activity diagrams, swim lane, state diagrams.
• Managed requirement change requests using Requite Pro
• Gained knowledge on Relational Database concepts related to ETL, data warehousing, Data Mapping through SSIS.
• Created master test plan and test cases and coordinated testing.
• Worked with QA team during the automated testing and preparation of testing reports using HP Quality Centre.
• Held project level testing status meeting to review new defects and status of open defects

Environment: Microsoft Visio designing, Facets 4.31, Requisite Pro, Rational Rose, UML, Rational Clear Quest, MS Office, MS Project, MS Visio.