Summary:

• An accomplished Business Analyst with over 7 years of IT experience involving the Automotive Finance Industry.
• Experience solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Experience in Business Analysis Financial Analysis, Object Oriented Software Analysis documenting, developing process flow diagrams.
• Proficient in process modeling/mapping, requirements gathering/management, systems analysis and design.
• Experience of working with MS Project to develop and monitor project plans.
• Strong command on SWIFT messaging.
• Comprehensive experience in Project Management, cost/benefit analysis, testing, development of business requirements specifications, and project planning working with project managers and business sponsors.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Experienced in SQL Server Reporting Service SSRS , Executing Queries and Running Stored Procedures.
• Extensive knowledge of standard SDLC methodologies, including RUP, MSF, Prototype and Spiral.
• Solid Experience in developing Scope/Vision Documentation and Project Plan.
• Strong Knowledge of SDLC, RUP methodology, and Project life cycles.
• Solid understanding of Rational Unified Process RUP using Rational Rose, Requisite Pro, Unified Modeling Language UML , Object Modeling Technique OMT , Extreme Programming XP , and Object Oriented Analysis OOA .
• Extensive experience in conducting Market Research, Feasibility Studies, Business Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.
• Expertise in the management of User Request Change, and handle User Conflicts.
• Expertise in developing QA Test Plan, Test Conditions, and Test Cases ensuring adequate testing of software both before and after completion conducting and documenting UAT.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.

TECHNICAL SKILLS:

• Programming Languages : C, C , C , C .NET, ASP.NET, Java, SQL, PLSQL
• Operating Systems : UNIX, Windows 95/98/NT/2000/XP, Linux.
• Databases : MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase
• Internet : HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.
• Automation Tools : MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum
• Bug Tracking Tools : Mercury TestDirector, Rational ClearQuest
• Utility Tools : MS Office Suite, MS Project, TOAD, Adobe Photoshop
• Reporting Tools : Crystal Reports, SQL Server Reports SSRS
• Data warehousing Tools : Informatica, Business Objects, Cognos, Erwin
• Testing Tools : Quick TestPro QTP , TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE:

Confidential

Sr.Business Analyst

Responsibilities:

• Gathering market data including real time and historical price data, financial data, and trading news using financial data source named Bloomberg.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Used Test Director, PL/SQL for testing the application
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Prepared scenarios, Use Cases UML State Diagram for scenarios using Rational Rose.
• Responsible for documenting and managing Business Requirements.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Deep understanding of Structured System Development Methodologies
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case VOB
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Worked in Data Analysis, Data Reconciliation and Data Mapping for ETL process
• Created standard test case template according to the company requirements and standards.
• 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 .
• Used MS Visio for Process modeling and Business Process flow diagrams
• Solid Experience in Collection, analyses, and documentation of User Requirements, as well as Organizing interviews, User meetings, workshops, JAD sessions and requirement elicitation sessions
• Proficient in creating Use Cases, Use Case Diagrams, Activity Diagrams etc.

Environment: Windows, MS Access, MS Office MS Word, MS Excel, MS Powerpoint, MS Visio , ETL, .NET, Oracle, JCL, Crystal reports, RUP, UML, SQL, SWOT, Teradata, AGILE, ClearQuest, GAP Analysis, Win Runner

Confidential

Business /Systems Analyst

Responsibilities:

• Performed Requirement Gathering Analysis by actively soliciting, analysing and negotiating customer requirements and prepared the requirements specification document for the application using MS Word.
• Prepared and reviewed Business Requirement Documents and System Specifications Documents for each release.
• Discussed and provided clarification of the requirements to development team, QA team, Insurance Product Management team and SMEs Product Line, Regulatory, Actuarial and Finance during Walkthroughs and Requirements Review meetings.
• Prepared, led and executed Testing Strategies in the certification of IT Releases which included multiple systems, interfaces, financial and reporting of trouble ticket fixes, enhancements and projects.
• Prepared Logical Data Models that contains set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.
• Intensively involved in User Acceptance Testing UAT .
• Prepared and documented System Requirements and workflows for the Content Management Application tool.
• Facilitated JAD sessions with the management, developers and analysts from all the dependant systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
• Wrote test scenarios, created batch calendar using MS Excel and updated UAT tester kit.
• Designed and developed the data load process using XML Style sheets and ACORD.
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Directed the creation of software test plans and coordinated UAT sessions with the client documenting detailed results.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Managed aggressive on time delivery of document capture, retrieval, and orchestration integrations to the AWD workflow system in support of an established workflow migration strategy and roadmap.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Conducted RAD sessions for the report users, requestors, and the developers.
• Involved in testing the application and helping other testers from Underwriting on clarification of test scenarios.
• Created SharePoint folders for each release and uploaded all the documents to the SharePoint site.
• Worked with IT to refresh AS400 UAT environment and requested the test data.
• Involved in executing key transactions New Business, Endorsement, Renewal, Payment in netPOSitive, AS400, Web Endo, SalesX, etc.
• Used various tools and applications as BA that includes Visio, Microsoft Word, Excel, and QA Director automated testing tools.
• Used Quality Center to track defects during UAT testing.
• Attended daily check-in meetings and interacted with development, QA and business stakeholders on the regular basis to discuss and clarify any raised issue, existing and new defects.

Environment: Windows, MS Office MS Word, MS Excel, MS PowerPoint, MS Visio , GuideWire, .NET, Crystal reports, Mainframes, Java, J2EE, RUP, UML, AWD, SQL, SWOT analysis, GAP Analysis, Win Runner.