Name: Shariq

Sr.Business/DataAnalyst

adb3px@r.postjobfree.com

***-***- ****

PROFESSIONAL SUMMARY:

Proactive, confident, goal oriented, pragmatic and attentive Business Analyst and Business analyst with over 9+ years of experience in Retail, Banking, Health care Ecommerce domains with a focus on designing, development, implementation of business processes and system solutions with the addition of an indepth domain understanding of the entire retail business operations.

Certified Scrum Master with a thorough understanding of agile principles and Scrum ceremonies.

Experienced and have detailed knowledge about Order Management System, RetailPOS Applications, Customer Relationship Management (CRM i.e.Loyalty Program) and Ecommerce platforms.

Extensive knowledge, expertise and involvement in various phases of Software Development Life Cycle (SDLC) in Waterfall, Scrum, Agile (Extreme Programming, TestDriven Development) and Scrum Waterfall Hybrid and SAFe software development lifecycle environments.

Skilled in conducting and facilitating Requirement Gathering Activities to gather SMART (Specific, Measurable, Attainable, Realistic and Timely) requirements using diverse elicitation techniques including, but not limited to Interviews, Requirement Workshops, Prototyping, Survey/Questionnaire, JAD Sessions and Brainstorming.

Excellent writing and documentation skills in creating, modifying and analyzing Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirements Specification (SRS), Use Case Specification, High Level and Low Level Documents (HLD/LLD), User Story.

Detailed understanding of RACI Matrix (Responsible, Accountable, Consulted and Informed) and prepared Requirement Traceability Matrix (RTM) to map requirement with its origin throughout the process to verify adherence.

Proficient in Requirement Management, Sprint Planning, Issue Tracking, Impediment Management, and Work Allocation using tools like JIRA, RALLY, and HP ALM. Helped PM in preparing various artifacts related to the Planning phase.

Experienced in creating Prototypes, Wireframes and MockUp Screens to visualize Graphical User Interface (GUI) as to understand the layout of the interface using tools like BalsamiqMockUps and MockUp Screens.

Proven Track Record in conducting ASIS and TOBE analysis, GAP Analysis, Risk Analysis, CostBenefit Analysis and SWOTAnalysis to assist PM in Release Planning as well as PO in setting better stakeholder expectation.

Integrated Salesforce Force.com IDE platform with Amazon Web Service (AWS), Oracle Database 11g and integrated IBM Sterling Order Management System with IBM Websphere commerce

Experienced in enhancing data warehouse with extensive knowledge ofData mapping, Dimensional Modeling, ETL jobs, OLAP operations.

Experience in Service Oriented Architecture (SOA, WSDL,HTTP).

Well versed in writing SQL queriesandSOQLqueriesin order to do data manipulation for analysis and reporting.

Participated in various Scrum Ceremonies including Daily Scrum, Sprint Planning, Sprint Review, Sprint Retrospective and Backlog Refinement meeting as part of the management framework.Helped PO in maintaining information radiators.

Well versed with backlog prioritization techniques (MoSCoW, Business Value, Kano, And Technical Risk) and estimation techniques (TShirt sizing, Planning Poker, Complexity buckets, value streaming and technical riskbased estimations) to help product owner in picking Product Backlog Items (PBIs) to commit to in the iterations (Sprints).

Proven expertise in developing Test Cases, Test Plans, Procedures and Traceability Matrix and documenting defects using HP QC and HP ALM. Collaborated and monitored BlackBox Testing, Smoke Testing, User Acceptance Testing (UAT) and Regression Testing. Helped testing team in understanding test scenarios regarding Interface testing &API testing.

Thorough understanding of Business Intelligence (BI) and experience in creating interactive, analytical dashboards using Tableau and IBM Cognos for decision making.

TECHNICAL SKILLS

OPERATING SYSTEMS

WINDOWS 10/MACOS 10.13 NOUGAT,LINUX

MODELING TOOLS

MS VISIO,MOCK UP screens, Balsamiq, Draw.io

SDLC METHODOLOGY

WaterfallSDLC, Agile Scrum, Water Scrum fall Hybrid, Safe, XP

BUSINESS SKILLS

Process Modeling, Change Management, GAP Analysis, Impact Analysis, SWOT Analysis, JAD Sessions, Project Scheduling, Project Budgeting

DATA WAREHOUSING

Data Modeling, DataMarts, OLTP, OLAP, Data Mining, Slicing/Dicing, Drill Up/ Drill Down, Pivot, Informatica Power Center,CA Platinum Repository

PROJECTMANAGEMENT TOOLS

MS Project, MS SharePoint Server

REQUIREMENT MANAGEMENT

JIRA, Confluence,Rally,HP ALM, MS Office, TFS

TESTING TOOLS

HP QC, Selenium, Load Runner,Cucumber

REPORTING/BI TOOLS

Tableau, Power BI,MSExcel,IBM Cognos

DATABASES

Microsoft SQL, Oracle, HBase, Amazon Dynamo DB, S3

LANGUAGES

C,PL/SQL

RETAIL TOOLS

IBM WebSphere Commerce platform,IBM’s Sterling order management system, Salesforce CRM

ACADEMICS:

Bachelor’s Engineering and technology JNTU Hyderabad.

PROFESSIONAL EXPERIENCE:

Client: DuPont (Cartiva), Wilmington, DE Feb 2019 - Till Date

Role: Sr.Business Analyst

RESPONSIBILITIES:

SFDC requirement elicitation and coached junior business analyst in converting business requirements to technical specifications, designing the solution and work closely with Stakeholders, Architects, Developers and Deployment teams.

Implemented the requirements for users and customers on Salesforce’s Force.com IDE Plugin using Eclipse.

Managing users, Public Groups, Profiles, and Roles within the Salesforce CRM, this involved designating access to the applicable user within the user hierarchy.

Created Formula Fields, Validation Rules, Workflows and approvals, Process builders for the flexibility and functionality of force platform application and to help automate the different types of actions based on organization processes.

Worked with integrating Salesforce with 3rd party systems using web services and App exchange for greater usability.

Worked with integration platforms, API integrations, with other systems for extracting the data from the homegrown applications by using the homegrown web services.

Supporting the Sales cloud implementation, Service cloud modules, Salesforce SF1, Client interfacing, Chatter when converting leads and dealing with cases for companywide discussions.

Worked with development and deployment of code through change sets from sandbox to production environments.

Designed and created reports to determine most popular items by age range, geography and profession and other parameters to make informed decisions on inventory.

Used SOQL & SOSL Queries with consideration to limits for data manipulation needs of the application using platform database objects and to support various itemlevel analytics on database objects.

Hands on experience on Salesforce Lightning for Customizing Reports and Dashboards for business use.

Used Data Loader for insert, update and bulk import or export of data from SalesforceS Objects Used it to read, extract, and load data from a comma separated value (CSV) file.

Used Force.com developer toolkit including Apex Classes, Apex Triggers, and Visual force pages to help in the development of custom business logic.

Integrated the web services by generating the necessary stubs from the WSDL files for extracting the data from the home

Grown applications by using the homegrown web services.

Designed the Test Cases in API testing, Test Plans for all the processes using CONFLUENCE and tracked defects on JIRA, hence was part of Black Box Testing, and was part of Interface Testing, System Testing.

Environment: AgileScrum,Eclipse,Force.com IDE, Workbench, SOQLxplorer, Jenkins, JIRA/Confluence, Oracle Database server11g,Amazon Dynamo DB(AWS),.Net framework 4.5,Maven,Custom Import Wizard, Apex Data loader,MS Windows, LINUX, Salesforce integration tools, Connect offline, Cucumber, Apex Classes/Controllers, Test Classes, Apex Triggers, Visual force (Pages, Component & Controllers),Standard objects, Workflow & Approvals, SOQL, SOSL, Custom objects, SControls, Analytic Snapshots, Sandbox environments.

Client: Zoetis, Parsippany, NJ Feb 2017 – Jan 2019

Role: Business Analyst

Responsibilities:

Elicited requirements together with the Product Owner to integrate IBM Sterling order management system with LBrands’sIBM WebSphere commerce platform used for a storefront for the complete view on order as well as inventory database.

Implemented DOM with role based access for multiple supply chain participants, created a centralized database as single order repository to monitor complete order lifecycle (inventory availability, order routing, payment processing, shipment).

Integrated two systems by establishing Web Sphere enterprise service bus which translated calls and services from one system to other in terms of API calls to support CRUD operations.

Collaborated with sales teams, independent stores, transportation partners, and customer warehouse to do Out of the box configurations for seamless delivery execution and monitoring of services.

Used CONFLUENCE for drafting the User stories and managing the requirements and integrating with JAMA Project Management Tool ensuring that all the teams are in sync at all times.

Created acceptance criteria for stories in JIRA and Participated in all Scrum Ceremonies Leading Sprint Planning session.

Validated completed stories that passed all the acceptance criteria on behalf of or with the Product Owner in exceptional scenarios and Production validation on behalf of or with the Product Owner/Manager.

Reviewed the Processes, Tools, Techniques used by various Development & QA Teams along with Scrum Master to provide leadership and guidance for improvement with the goal to deliver highquality Product.

Ensured that the Development & QA teams, based on the requirements, have completed the appropriate level of Test.

Planning along with Traceability back to the requirements to ensure complete coverage of the Program increment. Worked extensively with the Dev Ops Team for the successful implementation of the Project.

Helped in designing Test Cases in for API testing, Test Plans for all the processes using Confluence, hence did the Black Box Testing and was part of System Testing. Tracked the identified defects using JIRA.

Used Cucumber for Behavior Driven Development and used MAVEN to build the project and connect it to Jenkins CI Tool.

Assisted Junior Business Analysts with the development of Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MSVisio by analyzing the business processes to describe the functional requirements of the system.

Created and updated training manuals and provided advanced business knowledge and technical support for business requirements development.

Used BI tools like Tableau for reporting and analyzing most profitable channel partners, order replenishment etc.

Environment: Agile Scrum, IBMWebSphereCommercev7, IBMSterlingordermanagementsystemv9.3, JIRA, CONFLUENCE, JAMA, MySQLDB, MSVISIO, APARfixes, JMS API, Tablea, Cucumber, Jenkins, Maven.

Client: GE Healthcare Arlington Heights, IL May 2014 - Jan 2017

Role: Business Analyst / Patient Financial Analyst

Responsibilities:

Facilitated Joint Application Development (JAD) sessions to design Data Flow Diagrams (DFD’s) for the different phases of requirements.Acted as liaison between end users and technical team to address issues and recommend solutions.

Evaluating credit merit of potential client by studying financial history based on the documents submitted, market

Documented workflow for each of the batch process feeding to the master database.

Analyzed source database, identified cardinalities and Created conceptual, logical ER diagrams. Responsible for identifying different data sources and conducted data profiling using Informatica.

Involved in identifying facts and dimensions and created data mapping document. Coordinated with database developer to create star dimension modeling and enhanced the target Data warehouse with respect to agricultural data parameters.

Analyzed ETL jobs and mappings to document the existing transformation logic and understand ETL strategies used.

Assisted in developing different dimensions such as slowly changing, rapidly changing, and conformed dimensions and fact tables with facts and measures as per business requirement.

Led BI and dashboards development and trained core executive users on usage of developed BI platform.

Maintained metadata of the data warehouse in the CA Platinum repository by identifying different types of metadata.

Assisted testing team and Responsible for creating and monitoring Requirements traceability matrix, test cases, test plans, defining User Acceptance criteria and tracking defects using HPALM.

Responsible for Debt Reporting periodically to the financial Director

Assisted data analyst in enhancing OLAP cubes by communicating new business rules and Performed Rollup, Drill down, Slice and Dice operation to provide secured, timely, accurate insights.

Helped to create operations document and knowledge transfer to the operations team.

Environment: WaterfallSDLC, MS Access, MS Excel, MySQL DB, MSOffice, Informatics, HPALM, PowerBI, CA

Platinum Repository, Oracle Database 10g

Client: Indegene Life Systems Pvt LTD - Bangalore, India June 2011 - Jan 2014

Role: Business Analyst/Data Analyst

Responsibilities:

Conducted feasibility analysis for new requirements, cost benefit analysis and assisted the project manager in risk analysis.

Updated existing models to integrate new functionality into an existing application.

Conducted one-on-one sessions with business users to gather data warehouse requirements.

Created dimensional model for the reporting system by identifying required dimensions and facts using Power Designer.

Created DDL scripts for implementing Data Modeling changes. Created Power Designer reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs ' to apply the data model changes.

Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.

Developed normalized Logical and Physical database models to design OLTP system

Maintaining and implementing Data Models for Enterprise Data Warehouse using Power Designer

Create and maintain Metadata, including table, column definitions

Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.

Analyzed Data sources and requirements and business rules to perform logical and physical Data modeling.

Defined the key columns for the Dimension and Fact tables of both the Warehouse and Data Mart

Wrote MySQL queries from scratch and created views on MySQL for Tableau.

Interacted with the End users frequently and transferred the knowledge to them

Responsible for defining the naming standards for data warehouse.

Possessed strong Documentation skills and knowledge sharing among Team, conducted data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility.

Extensive experience in PL/SQL programming - Stored Procedures, Functions, Packages and Triggers

Massaged the existing model to create new logical and physical models that formed the basis for the new application.

Used Power Designer for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information

Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).

Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management.

Conducted User Acceptance Test (UAT) by setting up UAT environment utilizing HPALM.

Environment:ScrumWaterfall(Hybrid),JIRA,Tableau,SQLServer,.Netframework3.5,MockUpScreens,UML,MSOffice Suite, MS Visio, HPALM.

Contact this candidate