SUMMARY

• Committed professional with over 8+ years of experience delivering, driving improved decision - making and outcomes as Sr. Business Systems Analyst, Business Systems Analyst, and Java Developer.
• Strong knowledge of Software Development Life Cycle process using Waterfall, Scrum, Rational Unified Process (RUP), and hybrid (waterfall-agile) methodologies. Strong knowledge in Scaled Agile Framework (SAFe).
• Proficient in all phases of SDLC like requirements gathering and analysis, design, development, testing, implementation, and support. Collaborated with domestic and foreign cross-functional teams and partners.
• Excellent analytical skills to understand, map out, and document the workflows and functionalities of existing systems and Business Processes in order to provide system-based solutions to increase efficiency and reduce operating costs.
• Experienced in conducting GAP analysis of the ‘as-is’ and ‘to-be’ system to understand areas of improvement and risks involved through SWOT analysis, Cause-effect analysis, Risk analysis, Impact analysis, and ROI estimation.
• Skilled in gathering requirements. Well-versed with various requirements elicitation techniques such as client interviewing, requirement workshops, and joint application development (JAD) sessions to understand requirements and translate them into functional specifications.
• Proficient in UML Modeling and Business Process Modeling and Notations like activity diagrams, sequence diagrams
• Extensive experience in creating various artifacts including Business Requirement Document (BRD), Software Requirement Specification (SRS), Functional Requirement Document (FRD), and Test Requirement Document (TRD)
• Proficient in breaking down epics into user stories format. Well-versed in writing User stories, proficient with different estimation and prioritization techniques such as MoSCoW, Kano Model, Planning Poker, T-Shirt Sizing etc.
• Possess comprehensive understanding of CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote, Forecasting, and Web-to-Lead, Web-to-Case, Email-to-Case.
• Administration, Configuration experience on Salesforce.com spanning all facets of SaaS application implementation Hands on working in SFA, Force.com Apex Classes, Apex triggers, Visual force, Force.com API, SOQL and SOSL.
• Experience in realizing the business requirements to design on salesforce.com platform by designing the required entities like custom objects, creating the relationships/ junction objects like Master-Child, lookups, Entity Relationship data model, Pages, Classes, Interfaces, Workflows & Workflow rules, triggers, Email alerts and business logic.
• Extensive experience in creating Test Deliverables like Test Plan, Test Scenarios, Test Scripts, and Test Reports Experienced with HP Application Lifecycle Management and HP Quality Center (QC) to manage requirements, track defects, perform Root Cause Analysis and verify the adherence to the Requirements Traceability Matrix (RTM)
• Well-versed in various types of testing including Manual and Automation Testing, System Integration Testing, Load and Performance Testing in Load Runner, UI testing using Selenium, Regression and User Acceptance testing (UAT).
• Proficient in using tools like HP Agile Manager, Atlassian JIRA, Rally and Version One tools for requirement documentation, user story tracking and generated various scrum artifacts to be analyzed by the product owner.
• Excellent knowledge in Microsoft suite like MS Project, MS Visio, MS Excel, MS Word and, MS PowerPoint
• Expertise in generating and analyzing custom reports and dashboards for management and various business unit personnel to provide detail information on Metrics and key performance indicators through Tableau.
• Involved in designing, developing and verifying Client-Side and Server-Side validations.
• Adept in Service Oriented Architecture. Involved in designing and developing re-usableWebServices to support application development that involvedXML using SOAP, DTD / XML Schemas, REST, JSON.
• Assisted the data architects in preparing plans for all ETL procedures. Extensive knowledge of Data Warehousing, Databases, Data Marts, Dimensional modelling (Star schema, Snowflake Schema) and OLAP operations such as Roll-up, Drill-down, Pivoting, Slicing and Dicing. Experience in preparing Data Mapping Documents.
• Provided customized dashboards, views of data to entire sales force, channel teams, and executives using Tableau 9.3. Embedded live Tableau dashboards directly into Salesforce Canvas for deeper understanding of data.
• Advanced working knowledge of SQL, in ETL tools, Boom, Informatica On-Demand, Cast Iron and bulk data load process automation, data loader.

TECHNICAL SKILLS

Operating Systems: Windows XP/Vista/7/8/10, Linux, Unix

SDLC Methodologies: Agile-Scrum, Waterfall, Waterfall-Scrum Hybrid and Rational Unified Process

Project Management: MS Project, MS SharePoint Server

Data Warehousing: Data Modeling, Data Marts, OLTP, OLAP, Data Mining, Slice/Dice, Roll Up/ Drill Down, Pivot, Data Dimensions, Star and Snowflake Schemas

Databases: MYSQL, Oracle 11g, SQLite, SOSL

Reporting/BI/ETL Tools: Informatica, Tableau Desktop, IBM Cognos, MS Excel

Languages: jQuery, JavaScript, java, HTML5, CSS3, XML, SQL, Apex

Testing Tools: JIRA, HPQC, HPALM, Load Runner, Rational Clear Quest, and Selenium IDE.

Modeling Tools: Erwin, Moqups, Invision, Mockup Screens, MS Visio, Balsamiq

Others: Dreamweaver, Eclipse, Apache Tomcat, Visual Studio, Microsoft Office, GIT, REST, JSON

PROFESSIONAL EXPERIENCE

Confidential -Phoenix, AZ

Sr. Business Systems Analyst/Scrum Master

Responsibilities:

• Proactively sought out stakeholder needs and recommend new and exciting opportunities to improve the customer service experience, processes and communication as needed
• Collaborated with stakeholders from Sales, Customer Service, and Marketing to gather the CRM requirements.
• Analyzed current state of the existing case management infrastructures, defined and documented Environment setup plan, Migration document and checklist, Maintained the configuration workbook in Salesforce Service Cloud.
• Planned and conducted requirements elicitation meetings with the business to collect functional and non-functional requirements relating to client's Salesforce technology enhancement and initiatives
• Conducted brainstorming sessions with development team to actively involve them during the requirement analysis
• Modified Business Requirement Document, Identified process repetitions, bottlenecks and infrequent routes
• Responsible for identifying and documenting business flow and creating detailed diagrams including use cases, business and data flow diagrams. Created visual work flow diagrams using cloud flow diagrams.
• Created wireframes to efficiently represent the User Interface and communicated it to the development team.
• Assisted in designing training material and training sessions for business users on Salesforce technology functionalities
• Prioritized user stories for the Salesforce development team and also act as the administrator of Salesforce, including things such as resetting passwords, troubleshooting, developed reports and dashboards and configured changes
• Outlined the organization hierarchy and created profiles, roles accordingly in Salesforce; worked on visibility and security settings around them as required by the business.
• Created new custom objects, assigned fields, designed page layouts, custom tabs and components
• Assisted with Test Driven Development, developing and maintaining quality procedures, and ensured that prioritized scenarios are in place. Planned test strategy, created and signed off test-script, executed User Acceptance Test (UAT)
• Led the QA team in automating the UI testing process using Selenium; during the regression testing and in RCA
• Designed different custom dashboards for various user groups based on their business functionalities and needs.
• Designed various types of email templates for auto response to customers
• Worked with multiple scrum teams to coordinate efforts.
• As a Scrum Master, anticipated and remove obstacles from the project’s team path and pushed them to deliver quality results based on schedule. Analyzed the Iteration Burn Down charts and reviewed defects.
• Facilitated the various scrum meetings, which included Sprint Planning meeting, Daily Scrum meeting, Sprint Review meeting and Sprint Retrospective meeting with the development team.
• Successfully managed iteration plans and schedules, ensuring product delivery within scope, budget, time and quality parameters. Managed product backlog with the help of Product Owner and Scrum Development team.
• Tracked team velocity, sprint/release progress and prepared status reports.
• Updated agile tracking systems to provide transparency on product and sprint backlogs.
• Participated in Scrum of Scrums. Collaborated cross-functionally with varied stakeholders to define scope, goals and deliverables for each cycle, on-board newly acquired businesses, and provide tool advice on developing financial reports.

Environment: Scrum, Tableau, MS Visio, MS Project, UML, SOSL, SOQL, SQL, JIRA, Artesian, Heroku, MS Office Suite, Rally, SharePoint Version 2013, Salesforce Service cloud, Apex

Confidential -Cincinnati, OH

Sr. Business Systems Analyst/Scrum Master

Responsibilities:

• Analyzed current state of the existing sales management infrastructures, defined and documented the roadmap to achieve the next implementation of case management in Salesforce Sales Cloud.
• Responsible for identifying and documenting business flow and creating detailed diagrams including use cases, business and data flow diagrams.
• Gathered requirements by interacting with stakeholders through questionnaires and interviews.
• Created Epics and stories from features. Involved in writing user stories with acceptance criteria using JIRA.
• Broke down epics into user stories using the INVEST model.
• Used JIRA for issue tracking, user story management and requirement traceability.
• After understanding web services using WSDL, I created API Documentation and defined the XML schema to validate whether the incoming XMLs and JSON objects are well-formed.
• Worked with 3rd party vendors and applications to test the request and response XMLs using SOAP and REST API
• Active role in defining and customizing and scripting the access to extend API support to external applications
• Assisted the Salesforce development team in writing apex triggers and providing work flows
• Created the data mapping document after data profiling. Validated the data integrity using DML queries.
• Prepared conceptual and logical ER diagrams based on user stories, constraints and relationships.
• Worked with SMEs to write the trouble shooting answers to self-help forums and online communities.
• Involved in verification and validation in multiple stages. Helped in automating in validating the data integrity
• Worked with the BI and reporting team, using Tableau 9.3 we create visual representation of data.
• Built system validation rules. Defined the happy paths and flows like alternative, optional, recovery, exception flows
• Implemented complex approval processes to ensure proper authorization in the high-stakes sales.
• Managed users, hierarchical roles, profiles, security controls and territory management.
• Migrated Accounts, Leads, Contacts, Opportunities and sales data from external systems into SFDC.
• As a Scrum Master, anticipated and remove obstacles from the project’s team path and pushed them to deliver quality results based on schedule. Analyzed the Iteration Burn Down charts and reviewed defects.
• Facilitated the various scrum meetings, which included Sprint Planning meeting, Daily Scrum meeting, Sprint Review meeting and Sprint Retrospective meeting with the development team.
• Successfully managed iteration plans and schedules, ensuring product delivery within scope, budget, time and quality parameters. Managed product backlog with the help of Product Owner and Scrum Development team.
• Tracked team velocity, sprint/release progress and prepared status reports.
• Tailored retrospective meetings and activities to reflect the events of the sprint.
• Effectively communicated the benefits of scrum to ensure its smooth adoption.
• Protected teams from over commitment, managed backlogs, prioritized the resolution of defects as evidenced by on time delivery of initiatives.
• Communicated effectively across company contacts and clients, internal team about project requirements and schedules.
• Coached teams across broad technical, financial and business disciplines. Focused teams on business objectives and tracked progress to ensure project milestones were completed on time, on budget and with the desired results.
• Assessed business implications for each project phase and monitored progress to meet deadlines, standards and cost targets

Environment: Scrum, Tableau, MS Visio, MS Project, MS Office, UML, SOSL, SOQL, SQL, JIRA, IBM Cognos, Rally, SharePoint Version 2013, Artesian, Heroku, Apex, Salesforce Sales Cloud

Confidential -Madison, WI

Sr. Business Systems Analyst/Scrum Master

Responsibilities:

• Worked on a multi-system integration project for Revenue Department, Wisconsin that involved a major data migration from existing sources to the central data warehouse.
• Emphasized the importance of the scrum framework by conducting highly interactive Scrum Workshop for the new cross-functional team members. Clearly demonstrated the scrum framework and ceremonies involved.
• Modeled use cases to represent behavior and the interaction between the various actors and the system.
• Extensively used INVEST model to break down epics to user stories. Vertical slicing of the Epics into smaller user stories during backlog grooming meetings and Sprint Planning meetings with cross-functional development team.
• Responsible for data mapping document. Performeddataanalysis using SQL server and createdDataModels.
• Created Mapping matrix. Used Informatica Power Center to map sourcedataand ingestdata into target staging area.
• Facilitated in estimation of story points for the user stories in backlog grooming meeting and sprint planning meeting.
• Assisted the data architects in planning ETL procedures. Performedbusinessprocess mapping for new requirements and advised on eliciting the additional data requirements from the ODS
• Approved the test cases using HP-ALM and performed different testing such as Black Box Testing, Regression Testing and Smoke Testing.Involved in defect triages to perform Root Cause Analysis (RCA) for the defects raised in reports.
• Worked with source system owners during ETL progress monitoring and maintenance of daily batch schedule run on a nightly basis.
• Coordinated with the Business Objects development team to build various reports like Cross Tab, Master Detail and different charts like Line, Column, Area, and Pie Charts for analysis
• Worked on high availability SQL Server solutions like Log shipping, Mirroring and SQL Server clustering.
• Created staging tables to store validated customer data prior to loading data into customer interface tables.
• Created SSRS reports and OLAP cubes using SSAS and designed complex queries. Used SQL queries and scripts to validate data flow and define expected results for UAT
• Developed Data Quality baseline flow, test plan flow data and error handing.
• Used MS Visio for process modelling, process mapping and business process flow diagrams.
• Conducted knowledge transfer sessions about software development methodologies and quality assurance techniques for the new project teammates.
• Actively involved in daily defect triage meeting and kept track of all priority defects in HP ALM tool.
• Gathered projectbusinessrequirements to create functional specifications, design and create user guides, and write and perform test UAT cases.

Environment: HP ALM, Microsoft SQL Server, ODBC, Informatica, MS Project, MS excel, MS Word, MS Visio, MS PowerPoint, Balsamiq, My SQL workbench, Rally, Waterfall-Agile Hybrid.

Confidential - Boston, MA

Sr. Business Systems Analyst

Responsibilities:

• Assisted project manager in preparing the project plan that included critical milestones, budget estimations, resource allocations, critical path analysis and WBS structure.
• Performed "AS IS" system analysis to understand the business process and design "TO BE" system structure.
• PreparedBusinessRequirement Document (BRD) and convertedbusinessrequirements into System Requirements Specifications (SRS). Responsible for identifying and documenting business rules and creating detailed diagrams including Use Cases, Use Case Diagrams, Business Flow Diagrams, Creating process Models, Data flow diagrams.
• Managed Use case templates, activity diagrams and system flows. Reviewed them along with business users, system architects and developers.
• Created the data mapping document after data profiling. Validated the data integrity using DML queries.
• Prepared conceptual and logical ER diagrams based on user stories, constraints and relationships.
• Involved in verification and validation in multiple stages. Helped in automating in validating the data integrity
• Worked with the BI and reporting team, using Tableau 9.3 we create visual representation of data.
• Built system validation rules. Defined the happy paths and flows like alternative, optional, recovery, exception flows
• Implemented complex approval processes to ensure proper authorization in the high-stakes sales.
• Managed users, hierarchical roles, profiles, security controls and territory management.
• Facilitated the co-ordination and task assignment between offshore and onsite teams, resulting in 100% compliance to the SLA and timely business and technology updates.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application
• Assisted QA in designing the test cases, test scenarios and analyzed the test results once the test reports were generated.

Environment: HP QC, MS Office, MS Project, MS Visio, SQL Server 2008, MS Visio, Oracle SQL developer 3.0, Waterfall-Agile Hybrid Methodology.

Confidential

Business Analyst

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Conducted interviews with project managers, business users to collect requirement and business process information.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.
• Liaise with all the stakeholders at all levels and worked closely with teams of BAs, developers, testers and product control throughout the entire development life cycle to ensure a quality product is delivered.
• 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.
• Participated in SLA (Service Level Agreement) writing for different financial products and insurance products like Auto Finance, Personal finance, Education loan, Housing Loan.
• Experience of managing multiple stakeholders across the organization, and in QA integration of systems
• Conducted a budget planning of the project through walkthroughs and meetings involving various leads from development, QA and Technical Support teams.
• Created Data Flow Diagrams, Activity diagrams and Use cases for the audit planning process.
• Coordinated in developing test scenarios, test cases and implemented test plan with QA team.

Environment: UML, RUP, SDLC, HP QC, HP QTP, JavaScript, HTML, CSS, Notepad++, RUP, Rational Requisite Pro, Rational Rose, Windows XP, Visio.

Confidential 

Java / SQL Developer

Responsibilities:

• Developed reusable web services and created WSDL that contained document oriented information. Worked on developing and consuming SOAP web services using JAX-WS to expose application functionality to internal apps.
• Remodeled BackOffice tool that gives access to in-house API’s, included AJAX calls and jQuery components on UI.
• Developed, and implemented financial-services application to bring multiple clients into standard database format.
• Developed various SQL procedures and shell scripts to automate day-to-day system administration and have also been actively involved in day-to-day system administration.
• Worked on Object-Oriented analysis and design. Very good at various Design Patterns, UML.
• Implemented web services and deploying Java Application Servers like WebSphere, Web Logic, configuring Apache Web Server and configuring various Servlet engines.
• Comprehensive knowledge of physical and logical data modeling, performance tuning.

Environment: Java, Java EE, JDBC, JSP, JavaScript, WebSphere, Oracle PL/SQL, MS Office, MS Project, MS Visio, HP QC, HP QTP, JavaScript, HTML, CSS.