SUMMARY:

• Expertise in Supply Chain domain with a focus on Procurement, Resource Allocation, Merchandise Planning, Pricing and Invoicing, Demand Planning & Forecasting, Reverse Logistics, Warehouse Management System (WMS), Transport Management System, Accounting and baseline change requirements per contractual terms & earned value methods
• Well versed in analyzing CRM business processes that include Forecasting, Campaign management, Lead Management, Role Hierarchy, Territory Management, Order Management, Inventory Management, Account Management, Case Management and merging managemen t in a multi - tier business environment.
• Familiar with Business Process Modeling, Data Modeling, Change Management, Software Development methodology
• Elicited requirements using various techniques such as Joint Application Development ( JAD ) sessions, Interview sessions, Document analysis, Focus Groups, Requirement workshops, Surveys and Questionnaire over the years
• Using standard company proprietary guidelines, developed BRD's ( business requirements), SRS's (system requirements) and FSD's (functional requirements), Requirement traceability matrix for multiple paths of the project.
• Proficient in assessing Project feasibility through Cost-benefit analysis, SWOT analysis, Break-even analysis, What-if analysis, Gap analysis, ABC analysis, Risk analysis, ROI Analysis, and Value chain analysis, Monte Carlo simulations.
• Knowledge in several AWS services EC2, VPC, S3, Cloud Watch, Kinesis, Auto scaling configurations
• Knowledge in using different protocols like SSL, HTTP, HTTPS, Force.com IDE, Validation rules, SOQL SOSL
• Used JIRA for managing User stories, defect lifecycle management and contributed in Scrum Ceremonies like Release Planning, Backlog grooming, Sprint Planning, Sprint Review and Retrospective while assisting Product owner in choosing prioritizing techniques like Moscow, Kano and estimating techniques like Agile Poker, T-shirt Sizing.
• Documented solutions using Share point, Confluence and used Reporting tools like Tableau, Power BI, Excel
• Worked with the Training Group to build training materials and provided any suggestions to assist in User Training
• Functional experience with concentration on Use Case modeling using Unified Modeling Language (UML)
• Hands on Experience in creating High Fidelity Interactive Graphic User Interface Design (GUI), UI mock-ups, Wireframes using Lucid Chart, Invision, Moqup, Balsamiq and Proto to enhance the UI/UX experience .
• In-depth knowledge of implementing Databases, Data Table Structures, Data marts, Data Analysis, Data Integration, Data Modeling, Schemas and OLAP operations viz. Slice, Dice, Pivot, Roll-up, and Drill-down and various schemas like star, snowflake, galaxy schema & conducted Proof of Concept (POC) demos and project reviews
• Knowledge in the ETL (Extract, Transform and Load) of data using INFORMATICA and other ETL tools into a data ware house/date mart and Business Intelligence (BI) tools like SQL2005, Einstein analytics, Business Objects Modules.
• Knowledge in retrieving data using SQL queries like Joins, views, Aggregate functions like max, min, sum & average
• Strong and concrete understanding of Service Oriented Architecture (SOA), 3-tier and n-tier architecture systems, Extensible Mark-up Language (XML), and JavaScript Object Notation (JSON), web service concepts like HTML, CSS, WSDL, WADL, SOAP, UDDI, REST, JSON, Parsers - SAX, DOM
• Proficient in test data management, API, Web Services Testing and documenting in Open API Specification (OAS 3.0) using Postman, Soap UI and documenting it using Swagger tool along with automating test workflows.
• Experienced in QA testing, & Systems Testing of client server and web-based systems using tools like HPALM and HP QC
• Extensive knowledge of Continuous Integration and Continuous Deployment (CICD) using GIT, Jenkins, Bamboo
• Encouraged best practices including continuous integration, test-driven development (TDD), Behavioral driven development (BDD), Acceptance Test Driven Development ( ATDD ), pair programming .
• Dynamically participated in Post Production Validation (PPV) making sure the entry and exit criteria are met.
• Designing online survey & Managing CRM data for Ad & marketing campaigns with proficiency in A/B multivariate testing

TECHNICAL SKILLS:

Database & Data Analysis tools: Tableau, MS SQL server, Oracle 8/9/10, DB2, MS Access, Informatica Power Centre 9.6.1, MuleSoft, Slicing, MS SSRS, google analytics

Programming Languages: MY SQL, C, C++, R, JAVA, JQL, HTML, PHP

Requirements, Test & Defect Management: JIRA (v.6.3,7.0), HP Quality Centre (v.11, 12), Confluence, Selenium (v. 3.3, 3.4, 3.5, 3.6), Cucumber (v.2.0,3.0), Postman (v.3,4,5,6), IBM, Rational Requisite Pro, Swagger (v.2.0,3.0)

Modelling Designing: MS Visio, Smart Draw, Process Model, Balsamiq

Productivity tools: MS Office, MS Project, MS SharePoint, MS Word, MS PowerPoint, MS Excel

Operating Systems: Windows XP, Windows 8, Windows 10, LINUX, UNIX, Ubuntu

SDLC Methodologies: Agile/Scrum, SAFe, Waterfall, XP, Kanban, Scrumban, Water Scrum Fall

Web Services API: AJAX, SOAP, REST, B-PIPE, XML, FIX, STML, YAML

Technologies: AWS Redshift, Confidential S3, Confidential EC2, Kinesis, Salesforce.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Assisted Project Manager in creating Project Charter, Work Breakdown Structure (WBS) and Scope statements .
• Aided Product Owner to identify Scope Creep & created mitigation plans for requirements churn with stakeholders.
• Interacted with various business user groups for Gathering the Requirements for salesforce CRM implementation
• Extensively used Jira and Confluence for converting requirements to User stories by assisting the Product Manager.
• Assisted in writing acceptance criteria and framing Definition of Done (DOD) on SCRUM and KANBAN board for Potentially Shippable Product Increment (PSPI) and help enforce WIP limits for optimized process flow.
• Coordinating with ECC team for customizations in ERP to handle Ariba orders, receipts, contracts, PO and invoice
• Worked towards preparation of Requirements Management Plan, Business & Functional Requirement Documents.
• Assisted with Automation of Business Rules with Record Types, Validation Rules, Work Flows and Process Builder.
• Using journey builder created movable data extension, Lead generation in Marketing Cloud of Salesforce platform.
• Aided in using Mule Connectors like FTP, Salesforce, HTTP connector, Database, as part of Integration usage and executed RAML files for different entity creations and respective associations.
• Worked on various Salesforce.com standard objects like Accounts, Leads, Campaigns, Reports and Dashboards.
• Involved in creating inbound & outbound flows for MULE ESB in HTTP and orchestration using XPath .
• Supported and Administrate CRM application, Configure Price Quote (CPQ) tools enhancement and Google analytics
• Used different data tools - Apex Data Loader, Excel Connector, Import Wizard, SFDC Data Export .
• Maintained user roles, security, profiles and workflow rules wherever necessary.
• Performed and documented Data Mapping, converting legacy data element values for inclusion in the Functional Detail Design Specification (FDDS) documents and map it to the related module.
• Aided in Batch Integration process by making REST s Bulk API calls from the application to the API to upload the data and Lightning Bolt to fetch the data from Salesforce.
• Created custom handler to insert customer data in Salesforce Marketing Cloud using Soap API.
• Designed and prepared the Use Case diagrams, Class diagrams, Sequence diagrams for current activity, shipment association, lookups and web service using MS Visio.
• Functioned on defining the Test Cases to cover the Sourcing, P2P processes that includes Master Data and Transactional data for P2P process and Purchase Order to Invoice automation.
• Conducted User Acceptance Testing (UAT) and actively participated and facilitated testing of the system during Smoke Testing, Integration Testing, Black Box Testing and Regression Testing with the help of QA

Environment: Agile, SAFe4.0, Confluence (6.4), JIRA (7.0), Tableau (9.0), MS Office suite 2016, MS-Visio (1.5), Apache Tomcat, MySQL Java, REST, Swagger, MuleSoft (3.7), MS Visio, SFDC.

Confidential

Sr. Business Systems Analyst

Responsibilities:

• Facilitated JAD sessions with SMEs and business analysts from other systems for a detailed analysis and a better understanding the impact of various aspects on each other.
• Worked closely with business users to prioritize & scope out the Product Backlog Items (PBI) based on priority
• Lead and participated in multiple ongoing project meetings using iterative and Agile project methodologies.
• Problem solving skills and building a liaison between business and technical ends of the project.
• Collected business requirements to set rules for proper data transfer from Data Source (SAP) to
• Data Target (REDSHIFT Server) in Data Mapping along with the supporting Data Architecture and SQL Code.
• Created GAP analysis of AS - IS, TO-BE documents to identify existing system and identify deficiencies, enhancements
• Facilitated meetings with Salesforce Admin, Developers and Architect to determine the data that should be integrated into
• Salesforce platform, as it was used for powerful data integration of OMS and IMS
• Collected, assembled data from data sources as input to run research spikes to identify visualization solutions
• Responsible for mapping and modeling the Conceptual, Logical and Physical models (using INFORMATICA), specific to AWS Redshift and capture data from database
• Streams via kinesis with aggregations in EC2 instance & Redshift.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL to filter data and assisted in
• Creation of Hash tables referencing the Surrogate Key tables for efficient lookup to Dimensions.
• Participated in server deployment on Cloud, (EC2) Optimization / cost reduction of Confidential AWS services
• EC2, S3, EBS, ROUTE53, and VPC) and defining the conceptual and logical model of the data warehouse.
• Perform Data investigation as part of UAT and Standardized Data Quality Processes like Data Profiling, Cleansing
• Established the ETL Informatica Mappings, Maplets for importing data from ODS into subsequent data marts.
• Used data services for importing metadata from repository, new job categories and creating new data elements.
• Higher Salesforce ETL processes using Informatica, Salesforce Web Services, Java API & Scheduled Sessions based on demand, run on time and run only once using Informatica Server Manager.
• Linked tableau and salesforce with adaptors to provide reporting insights imbedded into the employee dashboards.
• Worked with several SFDC objects like Accounts, leads, opportunities, reports and created custom objects.
• Assisted on Jenkins and GitHub on many internal build systems for the core development team on an enterprise- level Java-based cloud orchestration/automation tool to streamline Continuous Integration.
• Experience in Functional, Data Driven Testing, Load, Performance Testing & Validating WSDL using POSTMAN.
• Prioritizing API function call for testers and documenting the API according to system, Performance & experience.
• Verify security testing to make sure which authentication is required & if sensitive data is encrypted over HTTP.

Environment: Confidential Redshift, Informatica power center 9.6, Confluence (6.2), JIRA 7.0, GIT, Jenkins, VPC, EC2, S3, Salesforce, Tableau 8.2, Postman (5.0), MS Office Suite, Agile SCRUM

Confidential

Business Systems Analyst

Responsibilities:

• Authored progress and completion reports which were then submitted to project manager on a weekly basis.
• Bring about the product development of a proprietary system enabling the integration of electronic invoicing with traffic, billing systems, order fulfillment and customer reviews using Salesforce CRM
• Captured requirements in the form of User Stories and defined user Acceptance Criteria for each of them.
• Identified and documented Salesforce APIs like REST, SOAP, Bulk and Analytical APIs.
• Providing the migration strategy from SAP CRM to Salesforce CRM platform in phase wise model
• Formed workflow diagrams, sequence diagrams, use cases, Analysis & Design Document, Interface Control Document, and Data Mapping Document for incorporating design changes.
• Used Informatica to extract and transform data from various relational database to the data warehouse.
• Used Tableau to derive business insights from OLAP cube and used Salesforce-
• Tableau connector (Canvas Adapter) to embed those insights to employee dashboards to generate better reports for the end client and project managers
• Secondhand Sales performance management software Optymyze to improve operations and execute sales strategy
• Acted as a resource in assisting team members in the development and executing test/use cases/negative tests.
• Assisted in API testing using Postman to check if the API's are returning the data in JSON, XML format as defined in the API documentation (Using Swagger Tool) along with automating the workflows.
• Created various Reports & Dashboard with Tableau to assist managers to better utilize Salesforce Cloud as a Sales Cloud, Marketing Cloud, Service Cloud & Analytics Cloud and capitalize on the leads and opportunities.
• Worked with several SFDC objects like Accounts, contacts, leads, opportunities, reports and created custom objects.
• Supervised testing team in UI testing using Selenium and documented the defects in the Jira

Environment: WaterScrumFall, Salesforce, Java, Swagger (2.0), HPALM (12), Tableau, Selenium3.4.x, XML, JASON, Optymyze, Salesforce Classic UI, REST service, Jira 6.0, Confluence (6.0), Postman (4.0), MS project 2013.

Confidential

Business Analyst

Responsibilities:

• Utilized my communication skills to conduct JAD sessions, Interviews, Brain Storming, Surveys, Prototyping and other elicitation techniques to collect requirements for the project simultaneously performed the Cost/Benefit Analysis (CBA), SWOT analysis, GAP analysis, Impact Analysis to check the feasibility of solution provided.
• Created project plans in accordance with project management standards and procedures and Identified ongoing issues and gaps within project plans, to eliminate implementation issues and updated them on SharePoint.
• Worked closely with the product development team during various phases of Product lifecycle management (PLM).
• Consistently tracked the project status and reported it to all the stake holders using SharePoint.
• Assisted in creating the UML diagrams and interactive Hi - Fidelity Mock ups and GUI for development team to better understand the requirements in an orderly manner and updated the Requirements Traceability Matrix
• Established Salesforce.com S-controls with flex builder & Action Script for new account custom workflow
• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com objects and used it to read, extract and load data from comma separated values (CSV) files, flat files, Html files, CRM data, temp tables.
• Responsible for leading testing efforts, ensuring that issues are identified, tracked, reported on and resolved in a timely manner and assisted the development team to perform UAT testing and updated status in the SharePoint.

Environment: Salesforce, Java, Windows, Swagger, HPALM, SharePoint, XML, JASON, Optymyze, Salesforce Classic UI, REST service, Jira (v.5.3), Confluence, Postman (v.4), Tableau.

Confidential

Jr. Business Analyst

Responsibilities:

• Acted as a liaison between the SME's and the stakeholders to assess the Risk, process reviews and policy reviews to elicit the requirements precisely and conducted meetings with business & technology groups at both organizations
• Prepared overall financial model for Cost Benefit Analysis between existing legacy system and SFDC
• Partner with internal users to learn their business, processes, challenges and strategic objectives
• Adhere to DOD (definition of done) and deployed Workflows, Validation rules, formulas & Approval Processes
• Analyzing existing processes and mapping them onto Salesforce CRM platform making sure of co-relation of fields.
• Saved a Requirements Traceability Matrix (RTM) to keep the clients & all the teams up-to-date with the progress.
• Identifying the need of third-party tools, required number of licenses, users and documenting the compliances.
• Developed Salesforce.com ETL processes using Informatica, Java and Salesforce Web Services Java API.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Business processes streamlining and processes re-engineering and estimating migration project efforts.

Environment: Salesforce, SAP, API, Informatica (9.5), RTM, Word, Power Point, SSRS, JIRA, Apache, XM, REST, CRM, SharePoint 2010, HpQC

Confidential

Marketing Analyst

Responsibilities:

• Ran weekly/monthly performance reports provide updates/root cause analysis.
• Worked with SMEs and business partners to gather business requirements
• Conducted as a liaison between the marketing team and technology team for feedback and requirements.
• Managed LinkedIn and other social media, hit 2500 average views per post (105% increased)
• Spearheaded implementation of new Return to Vendor (RTV) process leading to cost recuperation upwards of $12000 within a three-month time period of the implementation phase.
• Performed Google Analytics for the website, analyzed the landing page and conversion rate, suggested the managing team to optimize the website and assisted in content creation for the Ad campaigns both online & paper.
• Perform market research, identified the target customers and presented new market insights to the team for Retail Pricing Management and launched a product capturing upwards of 67% market share value.
• Assisted in developing E-mail marketing campaigns using Mail-chimp and helped in A/B multivariate testing.
• Executed SEO and local SEO for the business, get rank top 5-10 on Google Map
• Worked extensively with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables), Microsoft Word, Power Point.

Environment: Waterfall, WordPress, Google Ad Words, Google Analytics, Hub Spot CMS, Hub Spot E-mail, Marketing, Microsoft Excel (2007), Microsoft word, Power point, MS Access (2007), Google Online Marketing, Apache, PHP

Confidential

SQL/Web Analyst

Responsibilities:

• Partnered with vendors (onshore and offshore) stakeholders, and customers to provide, develop and implement innovative business and technical solutions Led the Google AdWords, analytics team, managed PPC campaigns,
• Wrote and edited 300 product descriptions and posted them to the SQL database using SQL queries.
• Created SQL statements & CRUD operations to validate the data in the backend process.
• Requirements Elicitation, Analysis, Communication support and guidance to Business users and end customers .
• Was responsible for Cost benefit analysis, Risk assessment, and SWOT, GAP analysis .
• Improved data entry by using an image API web service to obtain a list of image URLs
• Integrating Google Analytics API V3.0, integrating PayPal Transparent Redirect using Payflow Gateway API.
• Responsible for GUI design, Workflow analysis, Prototyping and Business development
• Designed the online survey and Managed CRM data and helped finance team to extract data from the database.

Environment: Waterfall, JOOMLA, SQL, Visio, WordPress, Windows XP, SOAP, XML, SSIS (2008), SSRS, SSAS, Microsoft Office suite, Apache, PHP, HubSpot, Mailchimp, MS Access (2007), Linux Ubuntu, Microsoft CRM, Sugar CRM.