SUMMARY

• Senior Business Analyst/ Scrum Master with 8+ years of experience in the IT industry with strong knowledge and experience working with different Software Development Methodologies such as Waterfall; Scrum; Waterfall - Scrum Hybrid.
• Proficient in working on end-to-end IT solutions, multi-tasking as Scrum Master and Business Systems Analyst.
• Served as a liaison between the technical team and the stakeholders of the project whenever needed.
• Analyzed success criteria metrics at the beginning of projects. Ensured relevant benchmark data could be obtained.
• Led project meetings with stakeholders, UX team, developers to gather and prioritize requirements, assign and follow up on deliverables, and address open questions to enable projects to continue moving forward.
• Experience in eliciting and documenting business and functional requirements using various techniques like Requirements Workshop, Joint Application Development (JAD), Job Shadowing, Interviews, Prototyping and Document Analysis.
• Experience in conducting ‘AS-IS’ and ‘TO-BE’ System Analysis, Feasibility Analysis, GAP analysis, Risk Analysis, Cost-Benefit Analysis, ROI analysis to map the compatibility of the new system with the requirements.
• Skilled at managing and breaking-down an Epic in the Product Backlog into User Stories that abide by the INVEST criteria.
• Skilled in drafting Business Requirement Document (BRD), authoring Functional Requirement Specifications (FRS) and Software Requirement Specification (SRS), collaborating with Subject Matter Experts from various departments in the company.
• Efficient in prioritizing Product Backlog Items based on MoSCoW, Kano and Walking Skeleton models and estimating Product Backlog items using techniques like Planning Poker, Relative Mass Valuation, T-shirt Sizing.
• Handled Requirements Churn by evaluating the Change Request. Have successfully performed Technical and Business Impact Analysis to study the effect of the change request and ensure minimal effect on the Triple Constraints of the Project.
• Strong understanding of Business Process Reengineering, Business Process Modeling, Business Analysis and System Analysis.
• Effectively utilized Workflow Management software like JIRA, HP ALM and Version One to track the progress of the project.
• Proficient in constructing Unified Modeling Language diagrams like Use Case Diagram, Activity Diagram, Sequence Diagram and Data Flow Diagrams and Control Flow diagrams utilizing software like Microsoft Visio and SharePoint Designer.
• Facilitated Scrum ceremonies (Backlog Grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective).
• Created and maintained Sprint Artifacts like the Sprint Burndown chart, Sprint Burn-up Chart and Product Burn- Down chart.
• Solid understanding of Database concepts like Data Warehousing, Data Structures, Schemas and Dimensional Modeling.
• Proficient at creating Data Mapping Document and identifying basic transformations to cleanse the data, improving Data Quality.
• Strong working experience in the Development, Implementation and Testing of Data Warehouses.
• Created and involved in maintaining a Design Traceability Matrix to map the Data Model to the Business requirements.
• Skilled at Data Mapping from the source to target database and identifying and eliminating poor quality data.
• Competent in performing OLAP operations such as Roll-up, Drill-down, Slicing and Dicing based on reporting requirements.
• Experience in writing queries/scripts for data analysis and user acceptance testing.
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and validation.
• Experience in overseeing Functional tests, Regression Testing, Integration Testing, Performance Testing and was actively involved in conducting the User Acceptance Testing, assisting the user and documenting any defects/ error that surfaced.
• Extensive knowledge and experience in working with reporting tools like Tableau and Crystal Reports.
• Expertise in developing Test cases, Test plans, Test Scripts and Test procedures in manual and automated test environments.
• Performed defects tracking, prioritized outstanding defects in the reporting system. Coordinated between the development team and the management team to resolve any conflicts with regards to the defects in terms of requirements.
• Proficient in tightly coupled architecture, loosely coupled architecture (including SOA), web services and web methods.
• Comprehensive understanding of Web-Services like REST and SOAP (and involved in their testing using SOAP UI) using XML, WSDL and UDDI using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
• Possess good knowledge of validation scripting like JavaScript. JQuery, AngularJS, HTML and CSS.
• Built workflows from a completely custom Visual studio direction. Developed custom web parts and components for SharePoint.
• Possess solid knowledge of IIS and have working experience in editing web. Config files based on requirements.
• Have experience in Asp.net, C#.net, web parts, master pages, Ajax detailed knowledge of the SharePoint 2007 / SharePoint 2010 client object model. Developed and deployed customized solution packages on SharePoint 2010 server farm.
• Experience in developing windows applications, web applications, windows services and web services in Microsoft Visual Studio .Net IDE using C#.Net 2.0, ASP.NET, ADO.NET andSQL Server.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile Scrum, Waterfall- Scrum Hybrid.

Project Management/ Collaboration tools: JIRA, Rally, MS SharePoint 2007/ 10/ 13, MS Project, HP ALM, Version One

Graphical and Modeling Tools: MS Visio, SharePoint Designer, Balsamiq.

Testing Tools: HP QC, HP LoadRunner, SOAP UI, Oracle Application Testing Suite(OATS).

ETL and Reporting Tools: Informatica Power Centre, Tableau, Crystal Reports

Languages: SQL, PL- SQL, T-SQL, C, C++, C#, HTML, XML

Databases: SQL Server 2000, 2008 R2, Oracle 9i, Oracle 10g, 11g, 12c.

Operating Systems: Windows XP, 7, 8, 10, Linux

PROFESSIONAL EXPERIENCE

SR BUSINESS SYSTEMS ANALYST

Responsibilities:

• Worked as a Business Systems Analyst on a data warehousing project in a Waterfall -Scrum hybrid environment.
• Performed requirements elicitation through use of various techniques: Interviews, JAD sessions and Focus Groups.
• Facilitated the JAD sessions to gather requirements from the marketing team of the Wealth Management Dept.
• Created Pre-JAD and Post-JAD artifacts for better understanding and refining of requirements in coordination with teams.
• Identified the attributes that were vital based on the reporting requirements and ensured they were available.
• Performed a GAP analysis of business rules, business and system process flows, user administration and business requirements, mapping the requirements to the new system and thoroughly documenting the same in the BRD.
• Performed an analysis of the OLTP system in place to assess the data quality and completeness.
• Collaborated with the various technical teams to document these requirements in the Business Requirement document.
• Assisted in drafting the Business Requirement Document, and responsible for getting approval from all stakeholders.
• Assisted the Product Owner and Scrum Master in the conversion of the Business Requirement Document (BRD/HLD) into Product Backlog Items for the development phase of the project.
• Proposed and developed a Business Glossary to unify the definition of key attributes on an organization - wide level.
• Coordinated with the Data Stewards throughout the project to ensure unrestricted access to quality data.
• Elicited and documented on-demand, self-service business intelligence reporting requirements from the end users at various levels. Assisted in design review meetings to make sure all the requirements are covered in the development project scope.
• Participated in refining the Product Backlog Items during the Product Backlog Grooming sessions and used the estimation technique, Planning Poker to assign story points to each user story during the Sprint Planning Ceremony.
• Worked in close collaboration with the Data Architect to the design of the Conceptual and Logical Model of the system. Created Use Case diagrams and activity diagrams (where necessary) in Microsoft Visio.
• Tracked progress of the project on Version One, continuously monitoring scope creep and technical debt at all stages.
• Worked in conjunction with the Data Analyst in the identification of dependencies between data tables.
• Responsible for performing Data Profiling and Data Mapping using the tool Informatica Data Quality (IDQ).
• Deployed the Informatica Data Quality mappings into Informatica Power Centre once development was complete. Used these mappings to create sessions and then appropriate workflows of the same.
• Utilized Consolidation transformations to create unique (golden) records to aid in optimization of OLAP performance.
• Documented the technical specifications of the web service for use in the binding template of the organizations UDDI.
• Mapped the designed URLs for the RESTful web service to the business requirements and operations.
• Scripted business rules for the web service, and assisted in drafting agreements for various web methods in XML format.
• Prepared the documentation for the RESTful web service i.e. the methods its exposing, URIs and description of each method.
• Documented sample requests, depicting the format of the calls to and from the web service.
• Documented request and response between API endpoints in the API Document.
• Collaborated with the QA team to ensure that testing efforts aligned with the system deliveries and business processes.
• Ensured Data Quality and Integrity by performing Balance and Reconciliation queries on data before and after moving it to staging area and after ETL into the Data Warehouse.
• Assisted in creation of test strategy based onbusinessand functional requirements, as well as design details and participated extensively in User Acceptance Testing at the client environment. Developed unit test plans, unit tests, test plans and test cases based on the specification in the System Requirement Specification document.
• Maintained the Requirement Traceability Matrix in Version One throughout the execution of the project.
• Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the Oracledatabase

Environment: Waterfall -Scrum Hybrid, Version One, MS Visio, Informatica Data Quality (IDQ), Informatica PowerCentre (v 9.3), MS Outlook, Oracle 11g, Oracle 12c, Tableau, SOAP UI.

BUSINESS SYSTEMS ANALYST/ SCRUM MASTER

Responsibilities:

• Assisted in the creation of the Product Backlog, and provided clarification on prioritization when required by the Product Owner.
• Met with users and stakeholders to thoroughly grasp the scope of the project
• Provided key input in defining functional requirements and system requirements/ specifications.
• Acted as Scrum Master for Product team with a focus on guiding the teams towards improving the way they work.
• Assisted in the facilitation of JAD sessions, to ensure the technical requirements are clarified.
• Utilized Visa, MasterCard payment gateways to enable online payments of premiums from the website.
• Facilitated Sprint Planning, Backlog Grooming, Sprint Review, Sprint Retrospective and the Daily Standup meeting.
• Also facilitated the Backlog Grooming as and when needed or requested by the Product Owner.
• Effectively broke down epics into User Stories during the Backlog Grooming Sessions.
• Created the data mapping document, identifying and noting the location of tables, business rules and the transformation logics.
• Drafted the Service Level Agreements for the web services consumed.
• Prepared Conceptual Data Model and assisted in the preparation of Logical Data Model assuring alignment with business rules.
• Used MS Visio to create wire frames and mock up screens to present to the stakeholders the User Interface and elicit e feedback early in the development phase.
• Represented the system process using various UML diagrams such as Activity diagrams, Sequence diagrams and State-chart diagram.
• Collaborated with the UX team to meet requirements in terms of the design and layout of the components.
• Created and maintained the Sprint Burndown/ Burnup chart to track team velocity and sprint progress and the Impediments List.
• Eliminated impediments faced by the team, by finding the right approach to reach management.
• Assisted the team in overcoming challenges through cross functional collaboration rather than provide them with direct solutions.
• Mapped the manual system to the automated system to verify if all requirements and gaps have been identified.
• Tracked and prioritized the Defect Log in conjunction with the Development Team using JIRA.
• Extensively involved in the User Acceptance Testing and assisted in scripting test cases.
• Maintained the Requirement Traceability Matrix to track the requirement against the test cases.
• Tested the data binding by checking the changes in the database layer are reflected onto the user interface layer.
• Participated in performing Sanity, Security, functional, Integration, End to End and Regression Testing.
• Interfaced with Program Management Office to ensure project goals and requirements are being met.
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.

Environment: (.Net Framework) Agile Scrum Methodology, JIRA, Confluence, MS Visio, Eclipse (IDE), Java, User Interface- AJAX (HTML, CSS, DOM, JSON, AngularJS), Oracle 10g, HP QC, LoadRunner.

BUSINESS ANALYST

Responsibilities:

• Worked with software engineers and business units, assisted in formulating and defining system scope and objectives through research and fact-finding, combined with a basic understanding of business systems and industry requirements.
• Created the Work Breakdown Structure in MS Project and assisted in the tracking of the project throughout its lifecycle.
• Elicited and documented the Functional and Non-functional requirements pertaining to the customization necessary for the system using techniques like Document Analysis, Interview sessions.
• Composed detailed descriptions of user needs, program functions, and steps required to develop or modify applications.
• Performed a GAP analysis to identify the shortcomings of the existing system and to better understand what the requirements of the new system are.
• As a Business Analyst, was involved in the analysis of source data and created detailed Data mapping document between the new servicing system (MSP) and the various middleware and front-end applications.
• Performed a risk analysis and maintained the Risk Register throughout the product life cycle.
• Performed Data Profiling and prepared the Data Mapping Document by defining the specific data content to ensure efficient data transfer and assisted in identifying dependencies between the data.
• Prepared Mock-ups and Wireframes to present to end users what the interface would look using Balsamiq.
• Designed and developed Use Cases, Use stories, Activity Diagrams, Sequence Diagrams, UML and Business Process Modeling.
• Prepared training material for employees and conducted Corporate trainings for specific segment of users.
• Ensured that business rules are applied to the code written for transformation logic.
• Created and executed test plans for functional tests, QA tests, smoke tests and UAT.
• Worked extensively on HP Quality Center all the way from requirements loading, creating/updating test cases and tying them back to requirements, test execution and defect logging/tracking.
• Provided technical guidance in planning, designing, and executing testing and developing procedures relating to product quality on complex projects.
• Prepared and maintained the Requirement Traceability Matrix.
• Worked closely with the development team to ensure the effectiveness and quality of the components andsystemsdeveloped.
• Utilized understanding of Mainframe technologies, web-based applications, functional and system testing as well as coordinating end to end and user acceptance testing with partnersystems.
• Single point of Contact on providing recommendations on product capabilities and effective delivery of products to the client.
• Extensively involved in Black Box Testing and Systems Testing for verifying and validating purposes.
• Involved in implementing deployment like authoring the user training schedules and conducted user training.
• As part of project close-out activity, was involved in documenting various functional specs for future reference and cleaning-up the Data Mapping document for any errors.

Environment: Oracle10g, Workday (Human Capital Management System) Balsamiq, Informatica, MS Project, Lotus Notes, MS SharePoint 2010, HP QC.

JUNIOR BUSINESS ANALYST

Responsibilities:

• Assisted in the gathering of requirements from the HR and Accounting departments. Prepared detailed reports to present to the senior Business Analyst after reviewing existing documents to study the current state of the system. (Document Analysis)
• Served as a scribe for the JAD sessions facilitated to gather requirements from the technical stakeholders. Circulated session minutes to stakeholder’s present for approval on decided requirements.
• Created a Work Breakdown structure in MS Project and assisted the Project Manager in the creation of the Project Plan.
• Broke down requirements into work packages that were 2 weeks in duration, allocating resources and materials to work packages.
• Assisted in the optimization of control design for improved performance.
• Assisted with the creation of the conceptual model of the system and the architectural and logical design of the system.
• Created mock up screens and Data Requirement Document for the development team for the User Interface based on requirements from the stakeholders.
• Drafted the Functional Specification Document based on the Business Requirement Document from stakeholders and business users.
• Used MS Visio to draw data flow diagram and control flow diagrams to demonstrate the flow of processes in the new system.
• Created Use Case diagrams to depict the interaction of various users with the system and the systems response to the same. Prepared the Use Case Document. Gathered substantial knowledge of the creation of Misuse Case diagrams and Abuse Case diagrams.
• Queried the database using SQL to check validity of the data on the front end.
• Assisted the Project Manager and Senior Business Analyst in tracking the progress of the project on MS Project.
• Developed a team collaboration site for the project on MS SharePoint using Out of the Box features in SharePoint. Created Wiki Pages, announcements and Calendar events on the team site to stimulate team coordination.
• Maintained the RACI matrix for all phases of the project, and assisted in the maintenance of the Requirements Traceability Matrix.
• Gathered requirements for the resources for the web service to be consumes and oversaw that the URI created for each resource followed standards specified to assure easy access.
• Handled the Change Request workflow.
• Automated minor manual processes using workflows in SharePoint, creating a better communication bridge between HR and Accounting departments.

Environment: Waterfall, .Net Framework, C#, MS Project, MS SharePoint, MySQL Server, MS Visual Studio, MS Visio, GitHub, HP QC.

SHAREPOINT DEVELOPER

Responsibilities:

• Interacted with prospects, clients and industry representatives in gathering business requirements and ensure that end deliverables meet original client needs.
• Proactively recommended innovations and modifications which were in compliance with industry requirements and consistent with corporate objectives and goals to improve operational processes, systems, policies and procedures.
• Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
• Also served as the SharePoint Site Collection Administrator.
• Developed and customized Web Parts as per requirements from various end users.
• Studied existing manual work flows, and created data flow diagrams (Level 0 and Level 1), control flow diagrams and the developed software solutions as per requirements from the business stakeholders and the IT management.
• Played a key role in the design of the web pages keeping in mind the theme of the master page and publishing the web pages.
• Designed, developed and maintained key components of the software suite using ASP.Net, SharePoint Server 2007 and new 2010.
• Implemented SharePoint-based workflows as well as developed Business Intelligence dashboards.
• Built proof of concept examples or graphical simulation software. Then maintained product test software and demos for training purposes.
• Participated in the Regression Testing of the Web Service.
• Protected operations by keeping information confidential.
• Performed Unit Testing on all code written. And updated the test plan.
• Assisted in updating and maintain the defect log.
• Actively participated in product design reviews by providing creative and practical ideas and solutions in a teamwork environment.

Environment: SQL Server 2008 R2, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Visual Studio 10.0, .NET 3.5, Microsoft SharePoint 2010, SharePoint Designer.

JUNIOR .NET DEVELOPER

Responsibilities:

• Developed solutions for diverse programming scenarios in C#, employing object oriented programming concepts such as: encapsulation, inheritance, polymorphism and Abstraction.
• Used C# and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies.
• Components were consumed by web applications and windows application utilizing SQL Server and stored procedures to perform logical business transactions.
• Created and Deployed XML Web Services using ASP.NET and Web Services Enhancements(WSE).
• Consumed Web Services from both Windows forms and ASP.NET web Applications.
• Created complex business components in C# using .NET Class Library assemblies while migrating and implementing them in a multi- tier environment suitable for .NET Remoting, XML Web Services, Microsoft Transaction Server (MTS) and COM+ to address application infrastructure issues associated with building scalable enterprise level applications used by many clients.
• Developed ASP.NET user controls/ Classes using C#. Developed class libraries to implement the business rules.
• Used CSS for GUI design and extensively used JavaScript for client side validation. Customized Menu, Label, Toolbar, Data Grid Columns Using Custom Controls.
• Assisted in the documentation necessary for publishing the web service.
• Assisted the Senior Developer in creation of Instance Diagrams
• Writing stored procedure and triggers at the back end. Deployment of Application on Test and Server and testing of application. Optimized data access statements for more performance and efficiency.

Environment: ASP.NET, C# Web Forms, PL/SQL, ADO.NET, IIS, XML, XSLT, Visual Studio 2008, SQL SERVER 2000, Windows XP, HTML, JavaScript.