Software Development Life Cycle

PROFESSIONAL SUMMARY:

Having *+ years of experience in the total life cycle of Software products including requirements analysis, solution design, implementation, integration, testing and maintenance. Experience in creating projects/issues in JIRA and tracking and monitoring all the JIRA tasks for different Line of business by helping them create filters for report and JIRA dashboard.

Experience in writing SQL queries. Experience in analyzing logs/alerts/machine data using Splunk. Experience in developing splunk reports and Dashboards.

Experience in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications.

Has technical expertise in SQL, MS Access, Tableau, SAS, SSRS, SSIS, JIRA, MS Excel, Power BI, Crystal Reports, Database Design, Data Warehouse Design, Salesforce Marketing Cloud and Visio.

Good knowledge of entire Software Development Life Cycle, Scrum Framework using Agile Methodology and Iterative Software Development Life Cycle Process.

Proficiently extracted and transformed data from various sources into QlikView to create a unified and clean dataset for analysis.

Sound expertise in Business Analysis, System Analysis, Business Process Engineering, Agile Project Management, Specification Development, System Testing, Release Deployment and Application Support.

Acted as the primary liaison between business stakeholders and technical teams, leveraging Microsoft Teams to facilitate cross-functional collaboration.

Expertise in conducting Feasibility Studies, Requirements Gathering, Analyzing the Business Process, Documentation and Conducting Review Sessions. Adept in Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing, Unit Testing and Multi-Platform Testing.

Skilled in documentation and review of Business Requirements Document, Functional Requirements Document and System Requirement Specifications.

End to end experience in designing and deploying data visualizations using Tableau.

Deep rooted understanding of all phases of SDLC using industry standard methodologies like Waterfall, Iterative/Incremental and Agile. Create and maintain a wide range of UML diagrams, including use case diagrams, class diagrams, sequence diagrams, and activity diagrams using Rational Rose.

Experience in conducting Gap-Analysis, Process Analysis as also as-Is and To-Be analysis and documentation.

Proficiency in creating artifacts like Business Requirement Document, Functional Requirement Document, Use Case Document, User Stories and User Interface Specifications.

Experienced in creating UML diagrams like Use case diagrams, Activity diagrams, Sequence Diagrams and State Charts.

Created current state flow diagrams and depicting the future state flow diagrams in MS Visio by interviewing various SMEs and feedback from IT solution architects.

Created Power BI dashboards for windows 10 migration assisting Info-spec when the feature update fails or faces any issue. Assisted the client in solving computer related issues and orientation of new equipment as deployed using Power BI Dashboards.

Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose / MS Visio / BPMN towards facilitating clear understanding of the business process.

Basic knowledge on Scrum tools and concepts like Scrum Team, Product Backlog, Sprint Backlog, User Stories, Daily Standup Meeting, Burn-Down Charts.

Extensive experience in reviewing and analyzing functional requirement specifications (FRS) and system requirement specifications (SRS) and writing detailed Test Plans, Test Cases, and Test Scripts.

Efficient in writing Business requirements document (BRD), Functional requirements document (FRD), Use Case Specifications, Functional Specifications, Customer requirement Documents and Workflows.

Extensive experience in facilitating user group meetings and gathering system requirements for web application development using Rational RequisitePro, Rally, Rational ClearQuest, Rational ClearCase and DOORS.

Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Adapt at queries, report writing and presenting findings.

Knowledge of the Solution Delivery Framework and Methodology. Familiarity with development methodologies such as Agile, Waterfall, or Rational Unified Process (RUP).

Technical Skills:

Business analysis

JIRA, MS Excel, MS Visio, Rational Rose, BPMN

Data analysis and visualization

Tableau, QlikView, Power BI, Crystal Reports

Software Development Life Cycle (SDLC)

Agile, Waterfall, RUP

Project management

Microsoft Teams, JIRA

UML diagram creation

Rational Rose, MS Visio

Gap analysis

Requirement gathering, Feasibility Studies

User story development

User Stories, Acceptance Criteria

Salesforce expertise

Salesforce.com, Salesforce Marketing Cloud

Database design and data warehousing

Database Design, Data Warehouse Design

Agile methodology

Scrum, Agile, Iterative Development

System and integration testing

Functional Testing, System Testing, Integration Testing

Documentation

BRD, FRD, Use Case Documents, UML Diagrams

Data manipulation and data cleansing

Power Query, SQL queries

Report generation and dashboards

Power BI, Tableau, Crystal Reports

Requirement gathering and management

Business and Functional Requirements

Version control and configuration management

SVN, VersionOne

Data modeling

ERwin

PROFESSIONAL EXPERIENCE:

Client: Micron, Boise, Idaho. Oct 2021 -Present

Role: Sr. Business Analyst

Responsibilities:

Prepared artifacts such as BRDs, FRDs, UML diagrams using MS Visio provided the best practices for OIM functionalities and implementation.

Participate in User Acceptance Testing and bug-related reengineering efforts Provide knowledge transfer and postproduction support activities, as necessary Gathered requirement to perform integration with multiple applications such as AD, Exchange, RDBMS.

LDAP Analyze daily OIM daily access requests to ensure proper provisioning has been completed and verify Active Directory, RACF (Mainframe), ITIMLDAP roles have been successfully created.

Analyze and verify the on boarding and off boarding reports to ensure the Workday feed is properly correlated.

Extensive hands-on experience on SQL and PL/SQL.

Developed and executed detailed project plans using the Waterfall methodology to ensure on-time and within-budget delivery of projects.

Utilized Microsoft Teams to conduct virtual meetings with stakeholders to gather and document business requirements, ensuring alignment with project objectives. Creating Power BI dashboards for End Point Management.

Mapped all as-is business processes using BPMN standards on MS Visio. Developed and maintained Apex code in Salesforce, including triggers, classes, and visual force pages, to implement custom business logic and enhance the functionality of Salesforce applications.

Created comprehensive visual representations, including flowcharts, process diagrams, and data models, using MS Visio to effectively communicate complex ideas and requirements.

Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.

Prepared the Business Requirement Document (BRD) and System Requirement Document (SRD).

Developed the project plan with the PM assistance and included provisions for project scope changes and issues and initiated efforts to make enhancements, created work process flows and work breakdown structures.

Collaborated with cross-functional teams to gather and analyze business requirements and then translated these into detailed UML diagrams using Rational Rose, ensuring alignment between business needs and technical solutions.

Used SQL against SQL server, Access and Sybase databases. Expert in installation, configuration, upgrading and administration of Tableau Server.

Used excel sheet, flat files, CSV files to generate Tableau adhoc reports. Perform data analysis, create dashboards, worksheets using Tableau.

Wrote concise and effective User stories while fostering Agile principles and methods for requirement gathering. Well experienced in working with Waterfall, Agile Scrum, Rational Unified Process (RUP) and Waterfall Scrum methodologies.

Provide Company Wide training for yearly Certifications Have daily, weekly meetings with Business, Developers, and Vendors to drive the implementation of security best practices and standards on boarded various types of applications including Active Directory, DAP, RACF and multiple JDBC applications.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Defined and configured SOD policies for roles based on training Gathered requirements from application teams regarding user aggregation for access reviews and user provisioning using the access request process.

Managed project timelines and milestones by creating and updating project schedules, task lists, and deliverable timelines in Microsoft Teams.

Responsible for Optimization of Informatica mappings, sessions, SQL queries.

Managed projects for design and implementation of OIM, including coordinating with vendor leadership, technical services leadership, and end user customers.

Generated various reports within IIQ to monitor access requests and provisioning status Analyzed the received data VS existing data within IIQ to identify discrepancies within the system.

Prepared the future state as well as current state screen shots presentation slides in PowerPoint, AS IS/TO BE document prepared.

Utilized various MSOffice applications, such as MS Excel, MS Word, and MS PowerPoint, to analyze data, generate reports, and deliver presentations, ensuring accurate and timely information dissemination.

Employed SQL queries to extract and manipulate data from databases, ensuring data integrity and accuracy for analysis purposes, while also optimizing query performance.

Utilized Rational Rose, a visual modeling tool, to create UML (Unified Modeling Language) diagrams, including use case diagrams and class diagrams, for requirements gathering and system design.

Environment: BRD, FRD, UML Diagrams, Microsoft Visio, UAT, Bug Tracking, Reengineering, Active Directory, PL/SQL, RUP, Agile, Waterfall, Microsoft Teams, Power BI, BPMN, Salesforce, Flowcharting, Process Diagrams, Data Modeling, SRD,WBS, Rational Rose, SQL Server, Access, Sybase, Tableau Server, Excel, CSV, Scrum, SOD, Informatica, IIQ, PowerPoint, Word.

Client: UBS, Mumbai, India Feb 2020 – Jul 2021

Role: Sr. Business Analyst

Responsibilities:

Collaborated with third party vendors, implementation partners, integration team, business, and customers to develop appropriate product business requirements. Used Rest API, JSON, and XML technologies to provide details of Integration points and payload information.

Explained business requirements to other stakeholders by developing detailed user stories, acceptance criterion, technical requirements, and spikes for certain areas of project.

Created Mock-up forms in MS word for better visualization and understanding of the software Solution.

Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.

Managed version control and configuration management of UML diagrams and models within Rational Rose, ensuring that all project stakeholders had access to the most up-to-date documentation.

Created detailed process flow diagrams using Microsoft Visio to document current and future state business processes, facilitating clear communication between stakeholders.

Managing projects in both Agile and Waterfall development environments. Keeping the team together all the time to ensure successful sprints. Wrote and tuned SQL scripts to test the flow of online quotations to the database and verify the data.

Executed Data conversion/transformation and mapping activities, which follow Aflac standards.

Analyzed data related to financial transactions to identify the gaps in data delivery and resolve them with appropriate technology team.

Met with project stakeholders and SMEs across company verticals to elicit and document business process models (BPMN), epics, user stories, acceptance criteria, and priorities.

Collaborated with business stakeholders to gather and document requirements for QlikView projects, ensuring alignment with business goals.

Collaborated with cross-functional teams to gather and analyze Salesforce data, providing valuable insights into sales performance, customer behavior, and pipeline trends. Experience in Building, publishing dashboards and customized interactive reports, report scheduling using Tableau server.

Developed and implemented project plans using the Waterfall methodology, ensuring adherence to regulatory guidelines and compliance standards specific to the financial services industry.

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.

Utilized advanced Excel functions, such as financial modeling, data analysis, and complex formulas, to analyze financial data, create financial reports, and support decision-making processes.

Developed and executed SQL queries to extract, manipulate, and analyze large financial datasets, ensuring data accuracy and integrity for reporting and decision-making purposes.

Worked closely with stakeholders to understand their business needs and translate them into detailed Salesforce requirements. Set up and maintained document repositories within Microsoft Teams, ensuring easy access to project-related documents and resources.

Met with project stakeholders and SMEs across company verticals to elicit and document business process models (BPMN), epics, user stories, acceptance criteria, and priorities.

Created compelling visualizations in QlikView, using best practices in data visualization to present complex data in an easily understandable manner.

Utilized Microsoft Visio to design DFDs, effectively mapping data flows, data stores, and data processes, aiding in the identification of data redundancies and optimization opportunities.

Investigated and reported issues and defects related to Business Project Team.

Advised project team about Agile framework to track up stream/downstream dependencies and manager backlog based on business priorities.

Environment: Rest API, JSON, XML, Agile, Waterfall, Version Control, Microsoft Visio, SQL, Data Conversion, Transformation, Data Analysis, Stakeholder, QlikView, Tableau,Microsoft Teams, Power BI, Unified Modeling Language Excel, SQL Queries, JIRA, Salesforce, Data Visualization, DFDs, Agile, Defect Reporting, Scrum.

Client: MERCK PHARMA, Mumbai, India. Aug 2018 – Jan 2020

Role: Business Analyst

Responsibilities:

Implemented solutions that communicated performance metrics, illustrated key trends, and enabled complex business analytics using Tableau, Business Objects, Power BI.

Analyzed business user needs, translating into SRS documents, and worked on SQL for data analysis.

Supported Agile software development team with Scope considerations throughout the development cycle.

Driven process definition and improvement for the release projects and worked closely with Agile Coach on improving overall Agile development.

Employed Microsoft Visio to analyze and optimize workflows within the organization, identifying bottlenecks and proposing improvements to enhance operational efficiency.

Generated monthly reports and graphs using Tableau to identify budget trends and ensure that the unit is meeting the monthly constraints and goals.

Heavily used Waterfall and Agile Methodology across all phases of software development life cycle (SDLC).

Documented user stories, use cases, and functional specifications to guide the development and customization of Salesforce solutions.

Facilitated communication and understanding between business stakeholders and development teams by utilizing Rational Rose diagrams as visual aids during meetings and discussions, ensuring a shared vision for the project.

Generated regular status reports and dashboards using Microsoft Teams' integration with other tools like Microsoft Power BI, providing stakeholders with real-time project updates.

Responsible for SQL error resolution of the DB2 system handling national outages and system abends.

Created and managed issue tracking boards within Teams, allowing for efficient identification, reporting, and resolution of project-related issues. Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

Hands on using industry tools like MS Visio, Rational Rose, I-Rise, Axure, HP Quality Center, MS Share Point, Tableau, JIRA, MS Word, MS Excel, MS PowerPoint, and MS Project to develop various project deliverables.

Prepared the BRD document and explained the process to the management and the development company.

Involve in UAT to check the functionality of the proposed system along with other end users of this application.

Worked on Profiles and Role Hierarchies in Salesforce and Security Settings around them as requested by the Product Owner. Oversaw all the System Development Life Cycle (SDLC) phases of the Waterfall methodology.

Environment: Tableau, Power BI,SQL, Agile, Microsoft Visio, Microsoft Teams, Microsoft Power BI, Waterfall, QlikView, Rational Rose, Microsoft Word, Excel, PowerPoint, Excel Power Pivot, S SharePoint,JIRA, BRD, UAT, Salesforce, SDLC.

Client: Cummins, Mumbai, India Jun 2016 – Jul 2018

Role: Business Analyst

Responsibilities:

Gathered requirements on the online brokerage platform from stakeholders by facilitating JAD sessions and extensive meetings with SMEs. Conducted Gap Analysis and created AS-IS and To-Be Process Flows documentation. Created various Reports and Dashboard with Tableau and Power BI to gain and gather insights.

Interacted with the customers and internal stakeholders in defining project scope boundaries and gathering user requirements and their expectations from the system to create BRD, FRD and SRS.

Strong in writing the SQL queries in SQL Server, Sybase, Oracle and DB2 databases using tools like SQL Programmer and Rapid SQL. On figured and administered VersionOne as the team's Agile management tool.

Using Cognos, Excel, MS Access, PowerPoint, Word, Oxygen XML Editor, SVN file manager. Conducted regular reviews and audits to guarantee the quality and consistency of Rational Rose artifacts.

Ensured data accuracy and consistency by implementing data governance policies within QlikView applications, including data validation and quality checks.

Ability to work with functional teams in an Agile/SCRUM and SAFE environment. Scheduled and conducted virtual meetings, recorded meeting minutes, and distributed action items using Microsoft Teams, ensuring all stakeholders were informed and aligned.

Extensive usage of Pivot Table, V-Lookup & H-Lookup for Data mining in MS Excel. Created business and functional requirement documents and prepared Use Cases models, Sequence Diagrams and Activity Diagrams using tools such as Rational Rose and MS Visio.

Utilized ERwin, a data modeling tool, to create and maintain conceptual, logical, and physical data models, ensuring data consistency, integrity, and alignment with business requirements. Conducted data profiling and data quality assessments using SQL queries, identifying, and resolving data inconsistencies, anomalies, and outliers to ensure high data quality standards.

Worked with the QA team for designing Test Plan and wrote Test Cases for the User Acceptance Testing (UAT) and assisting the Automation Testers in System Testing, Integration and Regression Testing.

Environment: Tableau, Power BI, SQL,Oracle, SQL, Agile, Excel, Access, PowerPoint, Word, SVN, QlikView, Power Query, Power BI, Salesforce, Microsoft Teams, Microsoft Excel, V-Lookup, H-Lookup,Rational Rose, Microsoft Visio, Erwin, Visio, MS Office.

Contact this candidate