SUMMARY

• Client focused professional with extensive experience managing, building relationships, performing needs analysis, problem identification and resolution with excellent communication, listening, presentation and people skills.
• Professional Business system analyst and Scrum Master with 8+ years of experience in Insurance and Mortgage
• In - depth knowledge of System Development Life Cycle with through understanding of various phases like requirement gathering, design, development and testing.
• Experience in working with various methodologies such as Waterfall, Hybrid waterfall, Agile Scrum, Scrum Fall, Water Scrum. Sound knowledge in RUP (rational Unified process), Spiral, SAFe, Kanban.
• Prepared various documents such as BRD (Business requirement document), FRD (Functional requirement document), RTM (Requirement traceability matrix), PRD (Product requirement document), RFP (Request for proposal).
• Experience in conducting GAP analysis, Impact analysis, Risk analysis, SWOT analysis, Root cause analysis and operational, technical feasibility study. Proficient in understanding ‘As is’ and ‘To be’ process.
• Experience and knowledge in creating UML diagrams such as use cases, activity diagrams and sequence diagrams using various tools such as Ms Visio, Rational Rose.
• Facilitated Change request meetings and documented them. Carried out impact analysis of change requests, identified the effects on triple constraints and documented the Change impact document. Updated the BRD according to the results from CCB.
• Created Test plans for test groups to deliver an understanding of test scope. Assisted in developing Test cases based upon functionality and features of the product. Involved in designing and maintaining test plans, test cases, test scripts using test director and test manager.
• Led Test Driven Development (TDD), Acceptance Test Driven Development (ATDD) and Behavioral Driven development. Experience in Black Box Testing, smoke testing and UAT
• Well versed with the concept of Software testing life cycle. Excellent understanding in concepts of automated and manual testing in selenium and HPALM.
• Involved in extensive DATA validation by assisting in severalSQLqueries and Involved in back-end testing and worked with data quality issues.
• Experience in ad-hoc reports, dashboards, analyzing graphs, data visualization and report scheduling.
• Experience in generating reports for analytical purposes using reporting tools such as OBIEE, Cognos and Tableau.
• Involved in meeting Subject Matter Experts (SMEs) from underwriting department to discuss the requirements of the project. Sound understanding of mortgage loan types, LTV ratio, ARM, mortgage valuation, BASEL parameters, CFPB, Fannie Mae and Freddie Mac.
• Experience in validating XML using XSD. Experience in writing technical XML document.
• Experience in Data consolidation using data center. Knowledge and understanding in Databases, Data marts, OLTP, OLAP, conceptual modelling, logical modelling, ODS, ETL concepts. Schemas, Data Entity-Relationships.
• Experience in defining and providing business rules for Source Target Mapping (STM) and Extraction transformation and loading (ETL)
• Good command over DCL, DML and DDL languages in SQL and in performing CURD operations on database including joins, order by group by and having functions.
• Good knowledge in understanding of Big Data concepts, practical knowledge with Hadoop ecosystems such as data nodes, name nodes, Sqoop and Oozie. Worked with big data administrators in setting up Hadoop architecture.

TECHNICAL SKILLS

Operating System: Windows 7, Windows 8, Windows Vista, UNIX, Mac OS

Languages: SQL, PL/SQL, Java, XML, HTML, C Programming

Database: Ms SQL server, Oracle, Ms Access, OLAP, Dimensional Data modelling, Data marts, Star and Snowflake Schema

Testing Tools: Selenium, HPALM/HPQC, Bamboo, SOAP UI

Modelling Tools: Ms Visio, Rational Rose, Balsamiq

Big Data: MapReduce, HDFS, Hive, Pig, Sqoop, Oozie, R

ETL Tools: Informatica, SQL Server, SSDT-BI

Reporting Tools: Tableau, IBM Cognos, OBIEE

Project Management tools: JIRA, Rally, VersionOne, Ms Project, Ms Share point

SDLC methodologies: Waterfall, Agile, Extreme Programming(XP), Spiral, RUP, Kanban, Scrum fall, Water-Scrum-Fall

PROFESSIONAL EXPERIENCE

Confidential, Woburn, MA

Business Intelligence Analyst

Responsibilities:

• Gathered, analyzed and documented reporting requirements from the reporting team/ shared services team.
• Prepared the Business Requirement Document and Functional Requirement Documents.
• Involved in conducting and working in Two-week release cycles with Siterra Team.
• Coordinated with the Business Analysts and Project Managers across various teams to gather and document requirements.
• Created and executed SQL queries in SQL Developer for data analysis and data validation.
• Prepared the data mapping document specifying the source and target systems. Developed ad-hoc reports as per reporting team’s request in OBIEE and Cognos.
• Performed black box testing for the data in the data warehouse.
• Developed test plan, test cases with reference to the Functional Requirement Document. Used HP ALM to lock the test cases and approve them.
• Analyzed data quality and data cleansing issues and documented the results in excel sheets.
• Worked with the QA team in testing reports and conducted data validation as a part of UAT.
• Analyzed Change requests and conducted impact analysis to understand the impact of change on timeline, resources and effort.
• Worked with the Project Manager in the Change Request process.
• Performed UAT testing in BI Answers before handing the reports over to the Business Users.
• Used Foot prints and Service now to log PCRs.
• Involved in preparing Training Document and User Manual for the end-users to access subject areas, dashboards, viewing graphs in different forms, role assignment in R12 environment.
• Co-ordinated with the offshore team through a daily stand up meeting call. Made a note of issues being faced and worked in resolving them.
• Co-ordinated the weekly status review meeting with the Project Manager, ensured that the agenda is fixed, and meeting is time-boxed.
• Worked in replication of reports from existing environment to OBIEE.

Confidential, Salt Lake City, Utah

Sr. Business Intelligence Analyst/ Scrum Master

Responsibilities:

• Worked on analyzing several reasons for loan approval and rejection. Generated reports to understand the reasons for non-payment of loans and presented them to the business owner.
• Conduced the Technical and Functional Feasibility study, combined them with the Project Manager’s Legal and Economic Feasibility study. Documented the results.
• Created business workflow diagrams for business process modeling.
• Prepared the BRD and FRD. Validated XSD against the business rules.
• Responsible for validating data that is passed between front end and back end using SQL queries.
• Created Use cases, activity diagrams and Mock up screens using Ms Visio 2013 and Balsamiq. Worked with UI team in creating GUIs using HTML.
• Coached the team about the agile manifesto and methodologies by conducting workshops and quizzes. Used JIRA as a project management tool.
• Facilitated Scrum ceremonies such as sprint planning, sprint review, sprint retrospective and backlog refinement meeting.
• Responsible for integrating internal SOAP API with external third party APIs.
• Responsible for validating SOAP API, XML documents in service oriented architecture.
• Used tableau to develop and design reports for supporting business analysis.
• Developed reports to understand the trend patterns from social media website using Tableau on a weekly basis.
• Trained the cross-functional team to use JIRA for keeping a track of the tasks and generate work progress graphs.
• Identified impediments during the Daily Scrum meetings and solved them.
• Delivered Potentially shippable product increment (PSPI) by the end of every sprint.
• Assisted the Product Owner in identifying the tools and techniques used for ordering the product backlog according to priority. Acted as a Proxy product owner.
• Maintained the Burn-up and Burn-down charts in JIRA for Scrum team.
• Identified dependencies of the user stories and removed blockers, bugs and defects.
• Identified potential technical debt scenarios. Conducted Black Box testing, UAT and Smoke testing.
• Used Kmap clustering to recognize social media profile, subscription services and internet searches of the applicant.
• Used Sqoop and MapReduce to import and export data between Oracle and semi-structured data and unstructured data.

Environment: Ms Visio 2013, HP/Mercury Quality Center, SQL, Big Data, Windows 7, Agile, Waterfall, SharePoint, REST Sqoop, Oozie, MapReduce, HTML, XML, Hive 0.14, Ms Word, Ms Excel, Ms Visio 2013, Jira.

Confidential, Olympia, Washington

Business Systems Analyst

Responsibilities:

• Conducted Gap Analysis to understand the ‘As Is’ and ‘To Be’ system by coordinating with the Data Analyst to understand the legacy systems
• Facilitated JAD sessions for gathering requirements. Conducted interviews to recognize the ‘to be’ model with the Data Analysts.
• Identified and handled data dictionaries for each element. Recognized Source systems.
• Analyzed and handled change requests in coordination with Project manager.
• Documented requirements in BRD, DRD (Data requirement document) by coordinating with technical team and data analysts. Documented Post-migration report.
• Created logical diagrams, conceptual diagram and star schema diagrams using ERWIN
• Updated the weekly progress report. Assisted the project manager in updating project documents such as Project plan and project charter.
• Assisted data analyst in data modelling and data mapping for high level requirements using SSIS.
• Used SSRS for creating, deploying and managing reports.
• Used conditional split to segregate valid and invalid data.
• Performed In-depth analysis of ERD and validated it against the system design.
• Utilized Business objects to investigate complex historical data to look for trends, outliners and platforms.
• Used SSRS to generate reports and dash boards. Analyzed the reports in co-ordination with Data analysts team.
• Accessed multiple OLAP sources to generate report to understand the comprehensive business view.
• Used SQL queries for data profiling and data validation to understand data discover patterns, trends. Used SQL queries to validate that the data redundancy is avoided.
• Created reports using combined queries, slice, dice and drill down.
• Created and managed report check list templates before migrating projects to QA and Production environment.
• Prepared road-map of the data conversion strategy for its physical implementation
• Decomposed policies into business rules for audits performed on the new system
• Oversaw testing of data acquisition process and implementation into production.
• Acted as liaison between stakeholders of the project and the ETL team.
• Determined the data quality by conducting data profiling in SSIS
• Recommended changes by analyzing legacy data and documented data quality issues
• Analyzed and confirmed source and target data in database using Oracle Developer
• Identified SLAs and communicated them with the Data analysts
• Worked with data analysts to identify areas that need data cleansing and ensured that the needs of the stakeholders were met.
• Created hierarchies for drilling down the data from highest the granularity to the lowest granularity.
• Assisted in testing the database administrators to checkfield size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Oracle, Ms Access, Ms Excel, SSIS, SSRS Hybrid Waterfall, Ms Visio, Ms Project, Java, J2EE, Mercury test director, MS SQL server, Business Objects, Informatica,, ERWIN

Confidential, Bloomington, Illinois

Business Analyst

Responsibilities:

• Conducted Gap Analysis, Operational and technical Feasibility study
• Assisted project manager in preparing project charter, project plan and closing documents by providing PRD. Prepared XML documents.
• Acted as liaison between the business and IT departments for communicating the requirements for an enhancement to Salesforce CRM (Customer relationship management) with SAP ERP.
• Responsible for object mapping between APIs.
• Validated the data in the target database using SQL queries.
• Conducted Brainstorming sessions and interviews with internal and external stakeholders to identify, gather and analyze requirements
• Documented the requirements in BRD and FRD.
• Validating XML documents against the business rules and ensured communication between the tiers.
• Communicated with the internal customer support team to understand the requirements.
• Co-ordinated with Enterprise Service bus (ESB) architecture with controllers and web services.
• Prepared UML diagrams such as Use cases, Data flow diagrams and activity diagrams using rational rose to understand business process.
• Documented the XSD and handled Data Mapping Document.
• Involved in change management and initiated change control procedures for scope optimization
• Conducted UAT and documented the results in Test results documents. Conducted Black box testing.
• Generated reports to understand the customer response for the new services being provided.
• Documented user manuals, guides for end users.

Environment: Windows 2000, Microsoft Project 2000, HTML, Rational Rose, Oracle, Ms PowerPoint, Salesforce, SAP

Confidential, New York City, NY

Business Systems Analyst/ Scrum Master

Responsibilities:

• Conducted and facilitated workshops for identifying the product backlog items.
• Made sure the User Stories meet the INVEST criteria. Assisted the PO in forming the Acceptance Criteria and Definition of Done
• Encouraged team to practice agile methodologies and principles.
• Implemented test driven development TDD for the initial sprints.
• Developed mock screens for credit card payment options to be provided by the mortgagor to mortgagee
• Estimated user stories in the presence of PO using Planning Poker technique
• Calculated the estimated velocity and capacity of the team and documented the same in Ms Excel.
• Helped the PO recognize the right tools and techniques for prioritization of PB and enhance business value.
• Used the concept of Kanban chart to make sure that the team’s progress can be visible
• Helped the developers identify technical dependencies and the entire team to identify the functional dependencies using story mapping technique.
• Facilitated Sprint planning meeting and made sure the team takes up the right number of tasks and made sure that the tasks meet the SMART criteria.
• Participated and conducted the Daily Scrum meeting.
• Identified and resolved impediments by classifying them as team-level impediments and organizational level impediments.
• Conducted the Sprint Review meeting. Made sure that the team meets the DoD.
• Identified the changes required and made sure that the team adopts them. Updated the product backlog and revised the release plan.
• Facilitated the retrospective meeting. Used various innovative techniques to make sure that the purpose of the meeting is achieved.
• Updated Rally and used SharePoint 2007 to manage artifacts, velocity tracking, design documentation and documenting meeting minutes.
• Conducted Kanban for two sprints to ensure the sprint goal is reached.
• Assisted the testers in preparing the test scripts, test plan and test data in HP Quality center
• Involved in conducting the black box testing so that the team meets the acceptance criteria.
• Attended Scrum of Scrums to coordinate activities and recognize dependencies of a PBI with other teams.
• Coordinated with various teams to ensure that dependencies between the scrum teams is recognized.
• Attended the PI meetings and represented my teams in SAFe environment.

Environment: Ms Visio, Ms Word, SharePoint 2007, Windows 7, Rally, Rational rose, Rally, HP/Mercury quality center.

Confidential

Associate Business Analyst

Responsibilities:

• Acted as liaison between the Business owners and IT staff to communicate requirements and expectations
• Assisted in conducting risk analysis and cost benefit analysis.
• Identified and gathered requirements using interviews and brainstorming sessions.
• Assisted the project manager in creating the project plan, WBS and project charter
• Identified, gathered, analyzed and documented the requirements in BRD and FRS
• Created UML diagrams such as use case, Sequence diagrams and activity diagrams using Rational Rose
• Developed Test Plan and RTM
• Developed excellent documentation skills and became proficient in spreadsheets and presentations
• Prepared user guide manual and trained end users.

Environment: Ms Word, Ms Project, Ms Excel, Ms Power Point, SQL server 2000, Rational rose.

Confidential

Ms SQL Server Junior Developer

Responsibilities:

• Involved in System study and database design
• Install, configure and upgrade Ms SQL server.
• Migrate legacy data to the new database
• Assisted for development and design the GUI ActiveX controls like tree view and list view
• Generated MIS reports using crystal reports
• Tested and designed ActiveX controls
• Assisted in client side implementation
• Maintained application as per users’ requirements

Environment: Ms SQL server 6.5, Microsoft Visual Source Safe 6.0, Visual Basic 6.0, Windows 2000