System Analyst / Salesforce Integration Analyst Resume
SUMMARY
- IT professional with over 8 years of experience in understanding Application Development, Manual/Automation Testing, Process Improvement, Requirement gathering and elicitation. As a Business Systems Analyst, worked closely with business users, developers, and subject matter experts through all phases of the SDLC in different domains like Capital Markets, Investment Banking, Insurance, Retail and Compliance Operations, E - commerce.
- Worked in environments like Agile-Scrum, SAFe4.0, Waterfall, Kanban and Waterfall-Scrum hybrid.
- Knowledgeable about the compliance regulating the mortgage industry like Truth in Lending Act (TILA), Real Estate Settlement Procedures Act (RESPA), Home Ownership and Equity Protection Act (HOEPA), Homeowners Protection Act (HPA), Home Mortgage Disclosure Act (HMDA), Gramm-Leach Bliley Act, Fair Credit Reporting Act (FCRA), Equal Credit Opportunity Act (ECOA) and the Fair Housing Act.
- In-depth knowledge in Mortgage Underwriting, Brokerage Services, Commercial Banking, Retail Banking, Asset Wealth Management, Cash Management, Capital Market and Credit Risk Fundamentals.
- Assisted Project manager in Planning, Scheduling, Monitoring and Budgeting and strong experience in requirement elicitation techniques like Brainstorming, JAD Sessions, Job shadowing and other analysis like GAP and risk analysis, effort estimation, Cost-Benefit Analysis, Monthly financial summary reports.
- Supported the Project Manager in developing Project Charter and Work breakdown structure for managing work.
- Proficient at creating and transforming Business requirements into BRD, FRD/FSD, Technical Specifications document, Software Requirement Specification (SRS) using UML diagrams such as use case diagrams, Business Process models, activity diagrams, data flow diagrams, Sequence diagrams on Lucid Charts and MS Visio.
- Constructed Requirement Traceability Matrix (RTM) to determine the source of the requirement, to ensure all requirements are easy to locate without affecting the system components when there is a requirement change.
- Designed Mockups and Wireframes for the requirements to get a visual understanding of the application under development, provided Functional/Technical Consulting for the application with a holistic view.
- Designed and Developed UI/UX using Web Forms, HTML5, XML, JavaScript, AngularJS, JQuery, CSS3, Server Controls and experience with various controls -Grid View, Repeater controls, Data List, Textbox, Toggles, Tags, Sliders Calendar, List Controls, and Validation Controls to Insert and Edit Interfaces etc. in Visual Studio.
- Worked closely within a multidisciplinary team, including web developers, business users, programmers and management, to develop and capture user centered requirements specifically as they pertain to UI/UX needs of the project, Communicated and validated UI/UX specifications.
- Worked on various UI development tools alongside developers like GitHub, Bootstrap, Angular.js, Saas, jQuery
- Developed of projects using JavaScript frameworks and switch between them depending on the project.
- Encouraged the development team to follow best practices -Naming Conventions, version control, better exceptions handling, unit testing, source control, continuous integration, continuous deployment, error/exception logging.
- Strong knowledge in mission critical cloud (AWS) based application and various services provided by Amazon Web Services like AWS CloudFormation, AWS CloudWatch, AWS Service Catalog, AWS Systems Manager, AWS CloudTrail, AWS Trusted Advisor, AWS Config, AWS OpsWorks, AWS Lambda, S QS, SNS.
- Experience with system integrations such as SDFC integrated with an LMS, event management system, Marketing Cloud,and a text-to-donate platform.Manage and enhance the enterprise-wide Salesforce.com(SFDC) customer relationship management (CRM) information system to better drive adoption.
- Responsible for performing administrative task in Salesforce CRM such as create/modify pick lists and lookup fields.
- Experience with CRM processes like Sales, Marketing, Customer Service and Customer Support, Business Processes, Campaign Management, and recommended solutions to improve their processes using SFDC.
- Cultivated experience in Salesforce.com Sales and Service Cloud, Marketing cloud, Operations cloud, Salesforce CPQ, Salesforce Communities, and Einstein Data Analytics.
- Worked closely with SFDC APIs such as Salesforce Web Services API,Salesforce Bulk API, Salesforce Rest API.
- Experience in SFDC Administrative tasks like creating Profiles, Roles, Users, Page Layouts, Approvals, Workflows, Processes, Flows, Validation rules, Reports and Dashboards and Custom configuration.
- Assisted in performing automated test scripts for testing API using Postman and SoapUI to check if the API’s are returning the data in JSON, XML format as defined in the API documentation using Swagger Tool
- Cultivated experience in working with web services using SOAP, REST, JSON, XML under various architectures - Three-Tier Architecture, Service Oriented Architecture (SOA), n-Tier architecture.
- Worked on front-end and back-end API’s to define the functionalities of user interface (UI) in application
- Developed Standard Operating Procedure, Training Manual and required documents for the Organization and created User stories with the help of Product Managers/SMEs in Iterative model environment.
- In-depth knowledge on implementing Dimensional data modeling (star & snowflakes schema) and as a part of data warehouse project worked on Data Mapping, and Extract Transform Load (ETL) process using various ETL tools like Informatica, Oracle data Integrator, MuleSoft and Data Spider of Amazon Web Services (AWS).
- Detailed understanding on Data integration, Data Migration, Data table structures, Data Analysis.
- Knowledge of Database concepts including Data Warehousing, Relational Database Management System (RDBMS), Data Marts, OLAP operations: Drill-Down, Roll-Up, Slicing and Dicing and OLTP.
- Worked on Feature Files, Cucumber and Gherkins for Testing in BDD. Utilized Postman testing tool.
- Designed and implemented SQL queries & Stored Procedures using select, insert, having, aliases, joins, unions, group by/order by and aggregate functions to extract data for timely reporting and Validation purposes.
- Proven experience in creating Project plans, Requirements documentation, Test planning documentation.
- Strong experience in creating Test planning, Test scenarios, Test cases for validating Business requirements during User Acceptance Testing (UAT). Apply ultimate test automation tools such as QTP (VB scripting).
- Proficient in functional testing, negative testing, regression testing, System integration testing (SIT), User acceptance Test (UAT), load/performance, security, browser compatibility, and performance testing. Generated multiple reports using different BI tools like Tableau, QlikView and in-house reporting tools.
- Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environment.
TECHNICAL SKILLS
SDLC Methodologies: Waterfall, Scrum, Custom- Agile /Waterfall- Scrum Hybrid,SAFe 4.0
Requirements, Project Management tools.: Atlassian-JIRA (v.6.3,7.0), HP-ALM (v.11.5), MS Project (2010,2013,2016), MS SharePoint Server (2010,2013)
Business Skills: Change Management, Risk Management, Impact Analysis, JAD Sessions, SWOT Analysis, Conflict Management, Effort and Impact analysis, Regression analysis, Why-Why analysis, Problem & Incident Management.
Testing, Modelling and Web services: HPQC (v.11,12), Load Runner (v.11.5,12.02), Cucumber(v.2.0,3.0),Manual - Excel, MS Visio, Draw.io, Google Drawings, SOAP, REST, AJAX, XML, JSON, WSDL, WADL, XSD, DOM, Salesforce CRM.
Development IDE, Reporting Tools: Visual Studio, SQL Management Studio, R- Studio, Macro Editor, Eclipse, PowerShell, Tableau, MS office suite.
Languages: C, C#, Java, JavaScript, AngularJS, HTML5, PowerShell, CSS3, Bootstrap, UML, Python
Databases/ETL: MySQL Server, Oracle, SQL Server Management Studio, Informatica Power Center 8.x/9.x.
Technologies: Salesforce
PROFESSIONAL EXPERIENCE
Confidential
System Analyst / Salesforce Integration Analyst
Responsibilities:
- Conducted Joint Application development (JAD) session, Interviews and Brainstorming Sessions with stakeholders to gather requirements from end user perspectives to identify the functional and nonfunctional Requirements.
- Identified As-is and To-be process maps as part of Gap Analysis and Risk Analysis for new functionality requirements, and thereafter prioritized them to align them Project Scope, Project goals and Objectives.
- Worked on PI planning, creating healthy backlog, Creating Jira Structure board, Worked on issue navigator.
- As a System analyst, I help in managing changes to our business application and reporting structure.
- I work on preparing various reporting documents and data mapping documents when the data is being sent to downstream systems.
- I write technical requirements for front end (UI) data element fields and APPIAN workflow.
- I create various flow diagrams and story mapping flows for better understanding of the workflow.
- I run basic sanity tests and check tests to identify technical requirement gaps, story bugs or defects.
- Engaged in UI/UX issue triage, troubleshooting and defect resolution and checked responsiveness of the web pages.
- I create and manage system integration requirements to integrate the user interface with downstream databases like Client Master, Flexcube and Salesforce CRM.
- Customized the salesforce CRM fields and mapped them according to the trans db and update the data
- I do various analysis on problems, their causes and effects on business operations by removing unnecessary data and implementing changes and modification to current flow.
- Identified all the dead leads i.e the data sources and helped others understand the process.
- Created UML, use case, Activity diagram, Sequence diagrams and Prototypes (wireframes, mockups) to show the developing team and testing team the workflow and the replica of how the system has to work, in MS Visio.
- Designed and developed static and dynamic web pages for the application.
- Used SQL scripts/queries extensively for data verification at the back-end as per the requirements.
- Maintained defects by prioritizing it against the backlog items and tracked them till completion using JIRA.
- Hands on experience working with web service file formats, including XML and JSON.
- I run both manual and automated test-scripts and test-cases for end to end testing.
- Was involved in the creating Test Plan, Test Scenario and Test Cases to provide a holistic view of the system
- Conducted Systems Integration Testing (SIT), Smoke Testing, Regression Testing, White Box Testing, Black Box Testing, Sanity Testing, and User Acceptance Testing (UAT) in both manual and automation test environment.
Confidential
Salesforce Business System Analyst
Responsibilities:
- Conducted Joint Application development (JAD) session, Interviews and Brainstorming Sessions with stakeholders to gather requirements from end user perspectives to identify the functional and nonfunctional Requirements.
- Identified As-is and To-be process maps as part of Gap Analysis and Risk Analysis for new functionality requirements, and thereafter prioritized them to align them Project Scope, Project goals and Objectives.
- Worked closely as part of a large agile development team involved in development of Cloud based application, experienced in working with Salesforce Classic and Lightning UI for custom theming, branding Wave and Einstein Analytics for predictive analysis.Provided training and coaching in the use of CPQ CRM systems. Identify training and development gaps and create plans to address.
- Identified all the dead leads i.e the data sources and helped others understand the Dead Lead Rejuvenation process and the new and improved HARP Guidelines which the main aspects are in building the application.
- Created UML, use case, Activity diagram, Sequence diagrams and Prototypes (wireframes, mockups) to show the developing team and testing team the workflow and the replica of how the system has to work, in MS Visio.
- Developed UI/UX using Web Forms, HTML5, XML, JavaScript, JQuery, CSS3, Server Controls in Eclipse IDE.
- Designed and developed static and dynamic web pages for the application.
- Assisted the ETL process by mapping data from source to destination and also helped in various transformation process using Informatica Power center, worked closely with Data Migration and Integration process.
- Used SQL scripts/queries extensively for data verification at the back-end as per the requirements.
- Good understanding of application development in AJAX, MVC and JAVA and Hybrid environment.
- Maintained defects by prioritizing it against the backlog items and tracked them till completion using JIRA.
- Ensured the team addresses the Cross-site Scripting (XSS) injection attacks by enforcing OWASP practices.
- Used Bulk API, SQS Receive Message API, Amazon API Gateway, REST API (mainly RESTful API) for the applications in the organization’s private cloud on the AWS platform using AWS CloudTrail.
- Integrated Data Sets with salesforce CRM for building the holistic 360 view for any data source for typical dashboard view.
- Hands on experience working with web service file formats, including XML and JSON.
- Maintained one on one customer relationship and their recent updates in the sales cloud CRM.
- Actively monitor tasks and efforts, perform UAT assisted in Systems Integration Testing and route the test cases to the test suite making sure the Requirements are matched and meets the acceptance criteria.
- Was involved in the creating Test Plan, Test Scenario and Test Cases to provide a holistic view of the system
- Conducted Systems Integration Testing (SIT), Smoke Testing, Regression Testing, White Box Testing, Black Box Testing, Sanity Testing, and User Acceptance Testing (UAT) in both manual and automation test environment.
Environment: Agile-scrum, Jira 7.0, Informatica Power center, MS Office Suite, Eclipse IDE, MySQL, REST API, Informatica Power center Selenium v3, MS Project, DB2, MS Visio.
Confidential
SFDC Business Analyst
Responsibilities:
- Understood the existing system by understanding the POS system on Test Environment to perform GAP analysis and documented the results in As-Is and To-Be categories to generate the business requirements from the clients.
- Responsible for budgeting and forecasting, expense reporting, risk management, status reporting, and execution. Conducted JAD sessions, focus group, Interviews and Brainstorming Sessions with stakeholders to gather requirements and end user perspectives to identify deficiencies and areas for improvement.
- Introduced Salesforce CRM application for the company and customized it according to business requirements.
- Deployed the Salesforce Data Analytics Cloud for the intelligent flagging of exceptions as per the business requirement by using Machine Learning and Deep Learning and use of streaming API for the Einstein App.
- Provided Business Rules for the exceptions flagging in the Data Analytics Einstein App in SFDC from the application center (app store) for the mortgage Underwriters and to produce various kind of reports when needed.
- Provided technical strategy and direction to ensure that our SaaS business applications remain aligned with business requirements.Developed project plans with forecasts, estimates, resource assignments, strategy and architecture for clients in alignment with business plans.Created WBS, identified & managed risks in MS Project.
- Extended help to developers in building the front-end (HTML5, JavaScript, JQuery, CSS3,) of the application.
- Engaged in UI/UX issue triage, troubleshooting and defect resolution and checked responsiveness of the web pages.
- Designed and Created engaging, interactive user interface components, iterate wireframes, task flows, use cases, mock-ups, and prototypes to communicate designs effectively to the developers and designers.
- Map projects for budget tracking. Created Risk mitigation plans. Collaborated with participants to determine product timeline. Managed end-to-end delivery. Managed the technical team, which consisted of 15 members.
- Conducted Agile Scrum Meetings to review the day to day progress when Scrum Master was out of office.
- Coordinated with the other business analysts and assisted in Data modeling, Data mapping and Data extraction & Integration in the data mart by using the Informatica Power center from the legacy systems.
- Maintained defects by prioritizing it against the backlog items and tracked them till completion using JIRA.
- Used CRM to improve agility, reimage your business and reduce TCO, tailored the user experience for organisation.
- Used Bulk API, Streaming API, REST API and Soap API for the applications in the salesforce cloud.
- Participated in requirement walkthroughs with the Development teams and Quality Assurance teams with the aim to develop testing strategies, test scenarios and test plans such that test cases reflect user needs.
- Analyzed Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, UI, Performance, Usability and Security requirements
- Conducted Systems Integration Testing (SIT), Smoke Testing, Regression Testing, White Box Testing, Black Box Testing, Sanity Testing, and User Acceptance Testing (UAT) in both manual and automation test environment
Environment: Agile Scrum, Salesforce: Marketing and Data Analytics cloud, Einstein Application, Sandbox, Jira 7.0, Confluence 6.0, MS Project, Oracle SQL Server, Informatica Power center, Postman, MS Office Suite,Tableau.