SUMMARY

• Proactive and result oriented Sr. Business Systems Analyst with 8+ years of experience in business requirements gathering and analysis, object - oriented design, data modeling, application development, maintenance and IT service management.
• Extensive experience in Software Development Life Cycle (SDLC) methodologies and techniques with expertise in Requirements Gathering, Requirements Analysis, Design, Development, and post-production support and maintenance of various applications.
• Well experienced in working with Waterfall, Agile Scrum, Rational Unified Process (RUP) and Waterfall Scrum methodologies.
• Experienced in conducting Focus groups, interviews and requirement workshops with business to gather requirements.
• Excelled at conducting AS-IS and TO-BE business processes, converting requirements into technical specifications and test plans.
• Proficient in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions.
• Skilled in documenting Unified Modeling Language (UML) diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class Diagrams, Data Flow and Business Flow Diagrams using MS Visio and Rational Rose.
• Possess excellent Business writing skills in creating Business Requirements Document (BRD), Use-Case Specifications, Functional Specification Document (FSD), Systems Requirements Specification (SRS), and Test case scenarios and reports.
• Experienced working in SOA Framework, Ajax, SOAP, Web Services, WSDL and Client and Server Validations.
• Possess good working knowledge of validation scripting like JavaScript, JQuery and Angular JS.
• Well versed with the .Net and Java platforms, especially with 3 tier architecture which involves User Interface, Middle Tier, Data Layer, IIS, Tom Cat, Apache, Application Servers, data layer etc.
• Expert in creating Specifications and designing Conceptual, Logical and Physical Entity-Relationship diagrams.
• Extensive involvement with Data Warehousing, Dimensional Modeling, Data Analysis, Data Mapping and Data Modeling
• Extensive Knowledge working with ETL tools like Informatica Power center, Datastage, Microsoft SSIS.
• Proficient in Business Intelligence tools like IBM Cognos, Tableau, SAP, Qlikview and Spot Fire.
• Working knowledge of Structured Query Language (SQL) for data manipulation and retrieval from Data ware house.
• Proficient Knowledge in working with Warehouse Management Systems, Supply Chain Management, Logistics Management.
• Well versed on working with Microsoft Dynamics AX, Microsoft Dynamics GP and Sales Force.
• Extensive years of experience in Business Process Re-engineering, Business Process improvements, Historical Data Analysis.
• Facilitated scrum ceremonies in Agile Scrum Methodology as Scrum Master and responsible for removing team’s impediments.
• Proficient in writing user stories, conducting Planning poker, MoSCoW and other techniques in Scrum Process.
• Proficient in project management tools like Version One, JIRA, HP ALM, TFS and MS Project.
• Excelled in performing Impact Analysis, Cost-Benefit Analysis, Gap Analysis, and SWOT Analysis to check a project’s feasibility
• Knowledgeable at risk management, performance measure development, process development and WBS.
• Experienced in document sharing applications including MS SharePoint and documenting user stories using Rally.
• Possess experience in Functionality Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Load/Stress Testing, Performance Testing and Maintenance testing in different projects.
• Designed, executed test plans, test cases; tracked defects and got them resolved and ensured the given requirements are met.
• Supported projects that dealt with internal system enhancements for large corporate financial and e-commerce companies.
• Extensive knowledge in Fixed Income, Commodity markets, Forex Markets and Rates.
• Strong balance of operational, business, technical aptitude and comprehension of their respective needs.
• Adept in team management, problem-resolution, conflict management and people management, and interpersonal skills.
• Highly experienced in leading different groups within different levels of management satisfying business needs of company.
• Confident in taking ownership and leading teams during the entire life cycle of the project.
• Energetic, positive, and self-motivated. Ability to adapt quickly to challenges and changing environments. Adept at multitasking various projects at one time, while maintaining high attention to detail.
• Dedicated & Self- motivated, proven leadership capabilities and time management skills.
• Exceptional people management skills when interacting with business professionals; from the highest echelons to the lowest possible echelons within an organization.

TECHNICAL SKILLS

Modeling Tools: Balsamiq, Axure, Visio, Erwin, Rational Enterprise Suite, Rational Test Manager, Rational Rose, Requisite Pro, UML.

Application Tools: Microsoft Office Suite, Dealer Management System, Comverse Kenan, Citrix, BMC Remedy, Control M, Rational Rose, HPQC, HP ALM, JIRA, HP PPM, Rally, TFS, web services, Web Methods, Ajax, IIS, Microsoft SSIS

Programming Languages: Java, Perl, PL/SQL, Unix, C, XML.

Development Tools: SQL* Loader, SQL*Plus, Toad, SQL Navigator, Visual Studio, Eclipse, Net Beans, DB visualizer

Web Development: HTML, JavaScript, JQuery XML, Angular JS

Database Integrated tools: Data Modeling, Data cleansing, Data mining, Query Optimization / Performance / Tuning / Testing, Database and Table creation, MS Visual Studio 2005,2008, SQL / 2008 Query Analyzer, DB2, Oracle 11g/10g/9i, PL/SQL, MS Access, MY SQL, SQL Server, SQL Developer, Conceptual (CDM), Logical (LDM), Physical (PDM) Data Modeling

Technical Tools: Data warehousing, Tableau, Cognos, Spotfire, Informatica Power Center, Teradata, Datastage ETL, Siebel CRM, Microsoft SSRS, Crystal Reports.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Managed the project using Agile Scrum methodology and analyzed the business case to understand the client needs.
• Conducted thorough analysis of the Business Requirements and created design specification to accomplish and achieve business needs.
• Conducted and led face-to-face and conference meetings with the team and the business to review business requirements.
• Involved in interviewing business users in detail, recording the requirements and converting into user stories.
• Provided analytical support in the Design, Development and Implementation of the project.
• Helped Product owner understand the technical user stories as the user stories are spilt to get into sprint, as it was difficult for product owner to understand the user stories to prioritize.
• Prioritized user stories using MoSCoW and Kano Analysis along with Scrum team and product owner.
• Facilitated the estimation of efforts required using Planning poker along with Scrum team.
• Used JIRA to keep track of the issues that are logged and in progress along with the person responsible. It helps to generate reports to see the current status of the issues.
• Improved collaboration in the scrum team as the team is new to the process and helped people understand the work dynamics within scrum.
• Facilitated the team to maintain optimal velocity and work on completing story points with a consistent schedule in each sprint.
• Worked on challenges like team issues where the team is supposed to be self-organizing, but the cultural background of the team members made hard for everyone to share responsibility without being authoritative.
• Conducted product backlog refinement meeting to split epics into user stories using Fibonacci series and T-shirt sizing.
• Facilitated Sprint Ceremonies like Sprint Planning Meeting, Daily Scrum Meeting, Sprint Review Meeting and Sprint Retrospective Meeting for each Sprint.
• Maintained and updated Sprint Burn down charts and Release Burn down charts to keep track of the Sprint and the project against the planned work.
• Worked on internal and external impediments of the team by addressing issues within team and working on their personal issues that come up in daily scrum meeting to help the team to perform better.
• Dealt with distractions of the Scrum team during the Sprint like ad hoc requests from external teams and the product owner to keep the sprint on track.
• Understood the compliance norms, regulations and legal obligations that will help build an effective module.
• Worked on networking concepts and protocols like HTTP, FTP, and TCP/IP.
• Experience working with the SQL server in addition to implementing Extract Transform Load (ETL) with direct correlation to the Data Warehouse and Data Marts.
• Used Microsoft Dynamics AX to deal with the integration of product increments during the scrum process and also for quality management.
• Worked on client side validation using JavaScript and experienced working on server side validation.
• Used Cognos for analyzing the test reports generated in the entire project process.
• Ensured all applications were tested for functionality and were adequately controlled in production.
• Led the User Acceptance Testing (UAT) efforts, and opened/closed defects on HPQC.
• Well versed with web services, SOAP and WSDL along with web methods used to develop business logics.
• Validated XML schema for system data documentation including the data requirement document.
• Worked on HPALM to use Requirements Traceability Matrix (RTM) in order to trace the test cases with respect to requirements.
• Reduced the communication gap within the scrum team to perform better by conducting team activities during sprints that made the team members to be more effective team players.
• Generated ad hoc SQL queries using joins, database connections and transformation rules to fetch data from the SQL Serverdatabase systems.
• Protected team from over commitment, managed backlog, prioritized the resolution of defects/bugs as evidenced by the on-time delivery.

Environment: Agile-Scrum methodology, JIRA, MySQL, MS Office (Word, Excel), MS SharePoint (2010), MS Dynamics AX, HP ALM, Cognos, C#, ASP.Net, Mockup screen, Informatica.

Confidential

Responsibilities:

• Gathered the requirements from interviewing business users through to understand what exactly they need to implement.
• Involved in analyzing the need for the business opportunity and made an impact analysis on business and technical aspects.
• As a team member involved in breaking the epic into user stories and estimated the overall effort needed to complete a user story in terms of story points through Planning Poker.
• Re-wrote the user stories for backlogs to let understand the technical team about the item in a better way.
• Experienced writing the requirements documents, product documentation and mapping documents for selected user stories.
• Excelled at writing SQL queries to retrieve the data required for analysis from the data bases using SQL developer, TOAD.
• Performed Complex SQL joins in order to understand the data patterns and derive a possible solution from the analysis.
• Used Informatica Designer, Workflow Monitor to retrieve the mapping details and also to see the workflow of jobs.
• Experienced in using Batch Analyzer to analyze the timings, failures of any batch jobs as part of analysis.
• Used Spring Tool Suite to retrieve the SQL construct of any job function and made SQL code changes if required.
• Excelled at using MS Visio to create Process Flow and Activity diagrams to show the project process in a prototype way.
• Participated in all the Scrum meetings like Daily Scrum, Backlog refinement meeting, Planning meeting, Sprint Review meeting, Sprint retrospective meeting etc.
• Used JIRA task board to create analysis task for prioritized user stories and attach all the related documents to the tasks.
• Involved in test case review sessions with technical and business owners to understand if any changes are needed.
• Used Tableau to create internal reports to show the interactions of the customers on different basis.
• Excelled at using MS SharePoint to share and upload the project documents in project central.
• Assisted the Business owners in conducting the User Acceptance Testing by showing the prototype prior to it.

Environment: Agile Scrum Methodology, JIRA, SQL Developer, TOAD, MS Office (Word, Excel), MS SharePoint (2010), MS Visio, Mockup screen, Informatica, Batch Analyzer, Spring Tool Suite.

Confidential

Responsibilities:

• Conducted GAP analysis to procure the requirements for enhancement of the existing system.
• Wrote Business and System Requirements Documents by interviewing the business users and also conducted JAD sessions to elicit requirements.
• Assisted the project manager on project management tasks such as project scope development, deliverables identification, resource allocation, project estimation & change management.
• Conducted Cost benefit analysis of the two interfaces that we planned to deploy as part of the project requirement
• Worked closely with business stakeholders in all the SDLC phases to make sure the timely delivery of the solutions met the requirements as per the agile scrum methodology.
• Developed Business Requirements Document (BRD), Business Process Documents, Functional Requirements Document (FRD).
• Analyzed and wrote user stories and documented those using Team Foundation Server (TFS) tool.
• Used MS Visio to create Activity diagrams, Sequence Diagrams and Use case diagrams for business stakeholders to understand the business process.
• Wrote test cases for documenting test plans and prepared Requirements Traceability Matrix (RTM) using HPALM.
• Used MS Share point for content management and document management.
• KPI’s were developed and viewed in dashboard using Microsoft Dynamics AX and worked on integration with PerformancePoint Server
• Assisted team in making appropriate commitments through story selection, sizing and task definition. Also participated proactively in developing and maintaining team standards, tools, best practices etc.
• Managed the Product Backlog and Sprint Backlog; tracked and communicated team velocity and sprint/release progress.
• Reviewed and assisted in functional testing of the application prior to demo in the sprint review meeting.
• Good understanding of Jquery and JavaScript used for validation of the inputs.
• Dealt with LoanServ (Mortgage Serv) Application, Interfacing with Loan Origination Systems while integrating into this application module.
• Implemented all stages of application development processes including extraction, transformation and loading (ETL) data from various sources into Data warehouse and Data Marts using Informatica Power Center Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Built SQL queries to retrieve data from data warehouse to verify the integrity of data and identified dimensions and fact tables for the schema as outlined in the requirements.
• Created and reviewed XML documents using XMLspy for the WSLA (Web Service Level Agreement) and data mapping.
• Carried out de-normalization for the Data warehouse using dimensional modeling and Worked extensively in creating a schema to create tables in the database.
• Reported status to Business owners on a weekly and monthly basis using MS Project for project planning, scheduling and status reporting.
• Used Tableau to generate internal reports to study and analyze the planned interfaces.
• Conducted Scrum ceremonies like Sprint planning meetings, Daily Scrum Meeting and Scrum review meetings.
• Facilitated in creating the change management and communication strategy along with the key business users and change management team.

Environment: Scrum-Waterfall Hybrid methodology, TFS, MS Office( Excel, Word, Access),MS Project, MS Visio, HPALM 10.0, Load Runner, JDBC/Java servlets, Informatica Power Center, MS SharePoint, MS Dynamics, MS Visio, DB Visualizer 8.0.12, Loan Serv Application, ERWIN 4.0, XMLspy, Tableau, Mock-up Screens.

Confidential

Responsibilities:

• Elicited requirements by conducting JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the product owner & stakeholders.
• Mapped process flows; assessed as-is processes through user interviews, data collection, analysis, design and evaluation of to-be process solutions.
• Designed and developed Use Case diagrams. Also involved with design team in creation of Activity Diagrams and Sequence Diagrams to depict process flows.
• Developed conceptual and logical ER diagrams for the database and created Data Dictionary for the data models.
• Strong knowledge of Client-Server validations and developed client validations using JavaScript.
• Performed Data Mappings based on the specified business requirements.
• Developed project schedules, timelines, status, system schematics and process work flows.
• Managed changes and worked on the change requests during all phases of the project.
• Presented meeting agendas and progress of the project to the senior management.
• Assisted and guided software architects and developers during the design and development phase.
• Strong knowledge of SOAP and WSDL to understand the requirements.
• Good knowledge on SOA that is predominant for the e-commerce, which is a 3-tier architecture.
• Worked on generating Ad-hoc queries and analytical reports using Microsoft Dynamics and integrated with MS SharePoint.
• Assisted in design review meetings to make sure all the requirements are covered in the development project scope.
• Worked with the project manager to organize project activities and to communicate with other business center managers and stakeholders of the project.
• Involved in writing Test Plans, Test Cases and Test Scripts using HPQC.
• Discussed limitations, risk, dependencies and assumptions pertaining to the scope of the application. Extensive documentation using Word, Excel and Visio and worked on MS SharePoint for document management.
• Prepared change request form to provide details of the changes requests, and obtained approvals from the appropriate stakeholders.
• Involved in User Acceptance Testing (UAT) for successful implementation of requirements and generation of reports.

Environment: Waterfall, MS Visio, MS Word, MS Excel, SQL, MS Access, MS Project, MS SharePoint, MS Dynamics, HPQC, Bottom-line Technology, PayBase application, Webseries.

Confidential

Responsibilities:

• Involved in analysis of Test Plans and Test cases, detecting bugs in the system, preparing the Defect reports using QC and interacted with developers for Debugging.
• Involved in various phases of Software Development Life Cycle (SDLC), including gathering user requirements, screen and report design, in addition to implementation of SOA Architecture and roll out.
• Worked on HPQC to ensure that the test scripts are documented, reported and tracked.
• Involved in logical system architecture, specifying system interface and documenting the algorithms.
• Integrated static data with other systems to maintain a central repository of common data by implementing SOA (Service Oriented Architecture).
• Used tools such as MS-Visio, Excel to define business use cases, activity diagrams, sequence diagrams and state diagrams.
• Created reports, analysis, dashboards and scorecards to monitor business performance and measured results using COGNOS Business Intelligence tool.
• Participated in underwriting of IT projects and maintained the Requirements Traceability Matrix across the deliverables of a project.
• Good understanding of OOAD concepts for implementation of the requirements.
• Validated all operating model considerations and process documentation.
• Performed Gap Analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Developed and wrote test cases for the testing efforts in compliance with the rules and regulations of CMM.
• Worked on the database to upload the files on the internal server using SQL server.
• Worked with QA team to perform different phases of testing like Regression testing, functional testing, UAT testing using QC.
• Performed system analysis on the architecture and its functionality.
• Developed PowerPoint presentations for Project Manager for monthly meetings with senior management.
• Participated in weekly meetings with management to inform stakeholders of overall project progress.

Environment: Agile- Scrum methodology, MS Office(Word, Excel, Power Point) Cognos v8 BI, EDI, MS Project, Windows 2000, SQL server, TOAD, Test Director, MS Visio.

Confidential

Responsibilities:

• Worked closely with key stakeholders, Subject matter experts (SME's) and cross functional teams to gather business requirements and acted as a liaison between the technology team and business users.
• Involved in creating business processes and conceptual and logical data modeling diagrams using Visio.
• Prepared the Functional specifications, and tested the interfaces.
• Conducted meetings to understand the workflow, processes and assisted in System Gap analysis to derive requirements for existing systems enhancements.
• Troubleshooting and advised about various compatibility issues on multiple platforms.
• Synthesized User Interface and Business Process Requirements and translated it into the Business Requirement Document (BRD), to be used as input to the functional design specifications.
• Created Use Case Diagrams, Activity Diagrams, Flow Diagrams.
• Facilitated with JAD sessions with the management groups, vendors, users and the IT Group for open and pending issues to develop specifications.
• Facilitated various issue resolution and defect resolution meetings.
• Conducted Functional Walkthroughs, coaching as well as User Acceptance Testing (UAT) sessions.
• Held team discussions to deliberate over various scenarios that could take place and impact the project.
• Assisted Project Manager with time-capacity and resource management.

Environment: Waterfall methodology, MS-Office Suite, MS-Visio, MS Project, HPQC, SQL, Java script, HTML, SQL server.

Confidential

Responsibilities:

• Gathered business requirements and developed BRD and FSD.
• Conducted interviews with project managers, business users to collect requirement and business process information.
• Developed PowerPoint presentations for monthly meetings with upper management.
• Teamed up with insurance advisors to perform market survey and learn client requirements to assist technical team in Software development.
• Assisted in client-side validation and server-side validation on the data which will be given or submitted by the client.
• Assisted Engineers in coming up with technical documents Functional design documents.
• Used UML to prepare Use Cases from the gathered requirements and created diagrams using MS Visio.
• Conducted JAD Sessions with various stakeholders and project team.
• Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams.
• Assisted in preparation of UAT test plan, test cases, testing cycle schedules, test scenarios and implemented them with QA team.

Environment: Waterfall, SQL Server, MS Office, Java Script, HTML, MS Project, MS Visio