SUMMARY

• 8 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Well - versed with all the phases of SDLC, including methodologies like Waterfall approach, IBM RUP, Agile and Scrum.
• Experienced in Object Oriented Analysis and Design (OOAD) and preparing UML diagrams including class diagrams, use-cases and activity diagrams.
• Excellent writing skills in Business requirements document (BRD), Functional requirements Specification (FRS), Systems Design Specification, Systems Requirements Specification (SRS).
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, Data Modeling and Design.
• Worked with Business Intelligence (BI) Tools like MicroStrategy and Informatica
• Expertise in RDBMS concepts, SQL queries and PL/SQL functions, stored procedures and triggers
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures
• Knowledge of Data-warehouse and ETL process
• Experience in Microsoft business intelligence(MSBI) tools- SSIS, SSAS and SSR
• Familiar with Client-Server architecture, Service Oriented Architecture (SOA) and Model-View-Controller (MVC) paradigm
• Experience working in various domains like Accounting/Auditing, Loan/Mortgage, Financial (Banking) and well-versed in Fixed Income, Equity Income and Derivatives (Futures, Forwards, Options and Swaps)
• Experienced implementing Operational Risk Management and Mitigation strategies.
• Possess an understanding of the trading and settlement process to be able to put the activities of front, middle and back office into perspective.
• Well-versed with managing documents using Microsoft SharePoint Server and VSS.
• Experienced in writing test plans and defining test cases involving GUI Testing and Prototype Testing, Regression Testing and User Acceptance Testing (UAT).
• Experienced in manual and automated testing for both front-end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis and Risk Analysis.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Experienced in tracking, documenting, capturing, managing and communicating the requirements using Requirement Traceability Matrix (RTM)

TECHNICAL SKILLS

Operating Systems: Windows XP/2000/NT/98/2008, UNIX, Linux, Ubuntu

Programming Languages: SQL, PL/SQL, T SQL, Visual Basic 6.0, XML, HTML, JAVA, Javascript, CSS, Piglatin, Hive

Big Data Ecosystems: Hadoop, MapReduce, Cloudera, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, flume

Databases: NoSQL, Oracle 10g/9i/8i, MS SQL Server 2000/ 2005/2008 , MS Access

Testing Tools: NetBeans, Eclipse

Data modeling tools: ERwin 4.O, Sybase Power Designer, Rational Rose, MS Visio

ERP: SAP R/3 4.6C, ECC 6.0

Reporting Tool: BEx Explorer, Webi Rich client, Microstrategy web, Microstrategy desktop, SSRS

Data warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables, OLAP, OLTP, SAP-BW 3.5, SAP BI 7.0, SAP BW 7.3, IBM Data Stage, SSIS, SSAS

Software Package: IBM Sterling Order Management

PROFESSIONAL EXPERIENCE

Business System Analyst

Confidential, Mooresville, NC

Responsibilities:

• Gathered business requirements for the Order Capture aspect of Sterling from account managers and business owners.
• Prepared Business Requirement Document (BRD) for the project.
• Participated in Change Management and Performance activities throughout the Project.
• Elicited business requirements from user interviews and then translated requirements into business model, process model, workflows, functional and technical specifications.
• Interacted with SMEs of different divisions (Information Technology, Finance, legal and Operations) to establish a thorough understanding of the business requirements.
• Designed Use Case diagrams, Blue prints, Activity diagrams, and Process flows
• Responsible for the completion of project work flow, change management and dealing with vendor relationships and vendor management.
• Played a key role in Review and approval of the Solutions document and the detailed design documents.
• Played a key role in Review and approval the test cases and assisted in test activities.
• Actively participated in defect monitoring and tracking.
• Created Change Requests and Decision papers.
• Built traceability matrix.

Environment: Windows, Microsoft Office SharePoint, Clarity, Rational Requisite Pro, MS Office, SQL Server, MS Project, MS FrontPage, MS Access, EDI, Documentum2.0, UML, IBM Sterling Commerce suite

Business Analyst / Data Analyst

Confidential, Miamisburg, OH

Responsibilities:

• Was extensively involved in every phase of the RUP process starting from Inception to Transition
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Organized requirements into high level Use Cases and low level Use Case Specifications; and modeled them into Use case, Activity and Sequence Diagrams.
• Prepared graphical depictions of Use Cases, Business process diagrams, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and technical design (UI screen) using Rational Rose and MS Visio.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Created Test cases from scratch by using Business & Functional Requirement Specifications and Wire Frames.
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Worked on developing and maintained the project plan using MS Project
• Worked closely with the ETL team to design the ETL process for data warehousing to support business logic for BI reports
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process
• Created DTS Packages for migration of data between MS SQL Server database and other databases like Oracle, MS Access, MS Excel and Flat Files.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Collaborated with the ETL team in Creating and Testing theSSISpackages developed for security.
• Collaborated with the ETL team creatingSSISpackages to migrate large amounts of data.
• Collaborated with the ETL team in usingSSASDatasources in Microstrategy web reports
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, MS Project, RUP, Documentum, Windows NT/XP, Linux, MS SQL Server 2000/2005/2008 R2, SSRS, SSIS, SSAS, Sybase, Oracle 10g, MS Access, MicroStrategy Intelligence Server, MicroStrategy Desktop 8.0, MicroStrategy Web 8.0, Quality Center, Adobe Photoshop, Caliber RM, Test Director, LoadRunner, Win Runner, QTP

Business Analyst

Confidential, Detroit, MI

Responsibilities:

• Coordinated Requirements gathering sessions with the LOB (Line of business) and made sure the requirements were clear and un-ambiguous, and documented them using Caliber RM.
• Involved in preparing Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Gathered user and Business requirements through interviews, surveys, prototyping and observing from senior managers and UI (User Interface).
• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Entity-Relationship(ER) Diagrams using MS Visio/Erwin.
• Conducted JAD sessions with management, vendors, users and other stakeholders for open and pending issues.
• Participating in Weekly Status Meetings and Discussions with Client
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro.
• Scheduled meetings with developers, System Analysts and testers to collaborate resource allocation and project completion using MS Project and assisted the System Analysts to document all custom and system modification.
• Assigned problems to appropriate software development team for fixes and suggested measures and recommendations to improve the current application performance.
• Authored progress and completion reports which were then submitted to project manager on a weekly basis.

Environment: MS Word 2003, MS Excel 2003, MS Access 2003, MS Project 2003, Agile Scrum, HP Quality Center 9.2, MS Share point 2003, IBM Websphere commerce, Enterprise Architect, SQL Server 2005, Oracle 10g

Business Analyst

Confidential, Tucson, AZ

Responsibilities:

• Interviewed Business Users and SMEs to gather Business Requirements and goals; and also to convert such requirements and goals into Functional Specifications.
• Worked with production staff to identify and map detailed current processes, identify gaps and failure points, perform root cause analysis and develop functional requirements that supported overall strategy, goals and objectives.
• Liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the ETL process.
• Perform Gap Analysis to identify and validate requirements in agile methodology.
• Conducted user interviews, gathered requirements and analyzed the requirements using Requisite Pro.
• Identified, researched, investigated, analyzed, defined and documented business processes.
• Coordinated multiple projects Star and Pace implementing in Agile methodology and at the end of each iteration, the team re-evaluates project priorities.
• Assisted with user testing of systems, developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Extensively worked on Data Staging for transformation and mapping in ETL process
• Supported programmers through the ETL development processes on IBM Data Stage and PL/SQL
• Responsible for identifying and documenting business rules, created detailed Use Cases and conducted User Acceptance Testing(UAT)
• Developed Custom SharePoint Branding, SharePoint web content management (WCM) and document content management features and functions.
• Collaborated with development architect to develop both high-level and detailed application architecture to meet the business needs.
• Implemented the web-based administration module for the project.
• As necessary, assisted in the process of identifying and recommending vendors and assisted in the vendor relationships
• Conducted and participated in JAD Sessions periodically with various Subject Matter Experts at various phases of the Development Life Cycle to discuss open issues and resolve them
• Producing the required paper work and getting necessary approvals/permissions for the release
• Actively participated in user training for User Acceptance Testing(UAT) within organization and client sites

Environment: ASP.NET, JSP, Oracle, SQL Server 2005, IBM Data Stage, Windows NT, Visio, UML, Agile Scrum, Rational Clear Quest, MS Project, MSBI(SSIS, SSAS, SSRS)

Business Analyst

Confidential, Jersey City, NJ

Responsibilities:

• Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, management, SME (Subject Matter Expert), stakeholders, lenders, underwriters.
• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
• Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
• Prepared Business Requirement Documents (BRD) and used Requisite Pro to manage, analyze, and convert business requirements into functional specifications.
• Conducted and participated in JAD sessions with stakeholders and system users to collect the software requirement specifications (SRS)
• Used RUP methodology to analyze and translate business requirements into system specifications, communicating with the business on a broader scale and with an in-depth view too.
• Used Rational Rose and UML to produce models like context, use case, sequence, activity etc.
• Used ClearCase to keep different versions of the documents and ClearQuest to report bugs or defect.
• Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing (UAT) to improve overall quality of the Application.

Environment: UML, RUP, Windows 2000, Oracle 9i, Rational Rose, Requisite Pro, ClearCase, ClearQuest, MS Project, MS Word, MS Excel, Java, Web Logic, DB2.