Summary:

• 8 years of experience as a Business System Analyst with expertise in Finance, Insurance and Healthcare industry
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling , Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Extensive experience in analyzing Business Requirement Documents BRD by gathering Business Requirements and Expectations from Subject Matter Experts SME and defining business processes, identifying risks, Feasibility Analysis and Impact analysis.
• Good understanding of the SOX, IRC and Treasury Tax Regulations
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Solid Experience in Collection, Analysis, Documentation of User Requirements, as well as Organizing interviews, User meetings, Workshops and JAD sessions.
• Expertise in UML class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams as a business analysis methodology for application functionality designs using IBM's Rational Rose.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills.
• Comprehensive knowledge of Software Development Life Cycle SDLC including Requirements, Analysis/Design, Development, and Testing
• Proficiency in Agile Scrum methodology of SDLC. Acted as Agile Coach in the Latest Project ensuring the implementation of Scrum smoothly in the Project.
• Proficient in creating UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams using Rational Rose and MS Visio.
• Adept at creating and transforming business requirements into functional requirements and designing business models using UML diagrams- Use Case Sequence and Activity Diagrams Data-Flow Diagrams Data Modeling.
• Good conceptual understanding of Data Warehousing. Proven experience in complete project life cycle - Design, Development, Maintenance and Documentation of Enterprise Data Warehouse, Data Marts, and Operational Data Stores ODS
• Experience in defining Test Cases, creating Test Scripts, analyzing bugs, interacting with QA / dev. teams in fixing errors and User Acceptance Testing UAT .
• Hands on Experience in System, Functional, UAT and BAT.
• Able to work individually and able to work effectively with cross-functional teams.
• Well versed in project management tool MS Project for status reporting, planning and resource allocation.
• Expertise in Business Modeling and UML Diagrams Use Case Diagrams, Activity Diagrams, Sequence Diagrams using MS Visio and Rational Rose.
• Hands on Experience on results-oriented Joint Application Development JAD Facilitator and meetings coordinator with excellent interpersonal skills.
• Good Knowledge of Black Box testing techniques for Web based Applications.
• Good at bug-reporting and bug-tracking using Jira, Bugzilla and Quality Center
• Hands on experience working with analyzing and testing database modules.
• Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions
• Excellent knowledge and deep understanding of industry standard methodologies like Software Development Life Cycle SDLC , Iterative Software Development Life Cycle Process as per Rational Unified Process RUP , CMM Capability Maturity Models and Six Sigma.
• Possess excellent communication and organization skills with the ability to adapt to a new environment.

Technical Skills:

Work Summary

Confidential

Sr.Business Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with senior management of the Research Group and SMEs and document them.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Developed the Project Scope and Vision document in assistance with the Project Manager.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Gathered requirements for the integration of POS system with the supply chain system
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Extensively used MS Visio to develop the solution concept, business timeline and wireframes.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Performed User Acceptance Testing UAT for various web based and database related applications.
• Developed prototype, prepared the test data and checked for the feasibility of the system.
• Interacting with the development and testing teams to improve overall quality of the software.
• Extensively use Microsoft Project or similar tools such as Open Workbench to document project plans.
• Created UI specifications Used IRISE Studio 5.3 for designing and simulation of web applications
• Created screen-mockups using iRise to review the requirements and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Designed the UI of the application, prototyping and wire framing in MS Visio for better illustration of the application.
• Performed extensive requirement analysis including Data analysis and Gap analysis.
• Defined Functional Test Cases, documented, Executed test script in Facets system.
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Have been working on exploring different software systems and databases in order to design a possible solution and identifying vital data points/elements.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Developed small applications with Teradata at the backend.
• Responsible for managing the migration of the department's website using Web Builder and ensuring that there are no broken links on the intranet.

Confidential

Business/Data Analyst

Responsibilities:

• Facilitated Joint Requirement Planning JRP sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Complete study of the in-house requirements for the data warehouse. Analyzed the DW project database requirements from the users in terms of the dimensions they want to measure and the facts for which the dimensions need to be analyzed.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents BRD using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Aimed at significantly improving the efficiency and effectiveness of the firm's global credit risk, interpretation, definition and implementation of Basel II requirements, and amplifying exposure management activities.
• Extensive work experience with Portfolio Managers, Experienced Traders, and Compliance Manager to configure the rule-based scenarios for capturing market and credit risk, general multi-factor sensitivity analyses, and PnL.
• Developed estimates, project plans Microsoft project , training material, BI reports using Microstrategy
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Developed and managed Project Plans and Schedules. Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.credit
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: Informatica 8.5, Oracle 9i, MS-Access, Window NT.

Confidential

Business Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Wrote Business Requirements, analyzed them and tested them.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
• Owned the entire reporting process. Interacted with the ETL team, developer s , management, and account holders to get the requirements, document them, design templates, and write specifications.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Facility planner using Clarity and Open Workbench OWB for the scheduling and tracking of all projects and online capture of actual and subsequent posting of hours to Clarity
• Designed report templates based on the requests by account managers.
• Developed business intelligence reports using Business Objects BO tool for the updated results to the stake holder
• Involved in creating business processes and modeling diagrams using Rational Unified Process RUP .
• Developed estimates, project plans Microsoft project , training material, BI reports using Microstrategy
• Used MS Project to manage project time lines
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Documented all the changes in the initial templates and was responsible for Release Management.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Created Test Scripts Test Scenarios to check report content, layout, and parameters.
• Worked on Report Re-engineering Project and made enhancements to the system flow.
• 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 .
• Worked with ETL team during the upload process.
• Helped with Data Mapping between the data mart and the Source Systems.
• Worked with SQL queries using MS Access for data manipulations.
• Enhanced communication lines between executives, managers, and peers

Environment: MS-Project, MS-Office Suite, MS Visio, MS Visual Source Safe VSS , Web Sphere, XML, SQL Server 2000, Agile, Windows 2000

Confidential

Business Analyst

Responsibilities:

• Used Rational Unified Process RUP methodologies and Unified Modeling Language UML .
• Used MS Visio for creating Use Cases, and Supplementary Specification Documents.
• Used Rational Rose for creating the Use Cases Diagrams, Activity Diagrams, Class Diagrams, and Sequence Diagrams.
• Facilitated and managed Joint Application Development JAD sessions with committee of SME's Subject Matter Experts from various business areas.
• Conducted interviews with key business users to collect requirement and business process information.
• Documented Functional Requirements for business level components, user interface, and system security.
• Defined Core Business Rules and Core Business Validations for the entire application.
• Analyzed the technical specifications and business requirements.
• Developed business requirement specification documents, business process models in RUP to document existing and future business processes.
• Wrote Use Cases, Business Flows and Work Flows Diagrams for effective plans.
• Documented and delivered Functional Specification Document to the project team.
• Involved in benchmarking activities to identify best practices

Confidential

Business Analyst

Responsibilities:

• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Prepared and analysed AS IS and TO BE in the existing architecture and performed Gap Analysis using iRise tools.
• Conducted user interviews and documented business and functional requirements.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Gathered systems requirements through interviews, surveys, prototyping and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business requirement Document.
• Gathered user and business requirements through interviews, surveys, prototyping and observing from portfolio managers and UI User Interface
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Extensively involved in the modeling and development of Reporting Data Warehousing System.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Documented requirements associated change requests with requirements and connected requirements with Use cases.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Used teradata fast load utility to load the tables using UNIX corn shell and SAS.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft SET and Teradata
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Made sure the test cases and test process guarantee accountability to business and systems requirements.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
• Used Rational clear quest for defect management.

Confidential

Business/Data Analyst

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables
• Created tables to capture errors and data that failed validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure Functions as part of the data validation and cleansing process.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Wrote SQL joins, Sub-Queries, tracing and performance tuning for better running of queries.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Tested the ETL process in testing environment and created test cases.

Environment:Informatica Power Center 7.1, Oracle9i, Erwin, Shell Scripting, PL/SQL, UNIX, Windows 2000.