Business Analyst Scrum Master

KING NATARAJAN

Primary: 716-***-****

****.*********@*****.***

http://ca.linkedin.com/in/KingNatarajan/

PROFILE HIGHLIGHTS

20+ Years of IT experience supporting large programs in Canada/USA with solid hands on experience as a Business Analyst /Data Analyst.

9+ Years of collective experience in Enterprise Reports (MSTR), Dossiers, IBM Cognos Reports, Data Analytics, Data Warehouse (BI), ETL(Informatica, Oracle ODI), reading / writing complex SQL queries and knowledge of all layers of BI solution.

7+ Years of experience as a Business Consultant / Functional Architect with strong documentations skills which include – Business Process mapping, Data mapping, Business requirements, User stories, Functional & Technical specifications.

5+ Years of functional working experience with Oracle ODI, ESB, FTP, EDI, API and Cloud.

SUMMARY

Strong working knowledge on RDBMS - Green Plum DW, Oracle, Teradata, DB2 & MySQL, ability to write complex PL/SQL queries and strong understating of data and ETL processes. Helped with the Data mapping and the technical specifications of the system. Worked with the business users to capture requirements that needed to be translated to user stories.

Experienced with resolving complex business issues by breaking them down into meaningful components to determine root cause and redesigning internal and external business processes.

3+ Years of strong working experience with Power BI, Data Import, Data models, Reports and Dashboards for data analysis.

Effective communicator across different levels of the organization and external stakeholders.

Outstanding analytical ability to plan, coordinate, and implement practices and procedures to increase efficiency and process improvement resulting in effort & cost savings. Experienced Dashboard creator for Metrics and Reports.

TECHNICAL SKILLS

RDBMS/DW : Oracle, PL/SQL, PostgreSQL, DB2, SQL Server, Green Plum, Informix, My SQL

Reporting / DB Tools : Micro Strategy Web, IBM Cognos, PgAdmin III (1.22.1), SQL Developer 4.0, Toad 8.6, Power BI, AWS Athena

Management Tools : HP-ALM/QC, JIRA, Confluence, Azure Dev-ops, Bugzilla, PractiTest.

Tools/Packages : Putty, WinSCP, FileZilla, MS Project, MS Visio, MS Excel, MS Access, Open Office, Pycharm, Eclipse.

EXPERIENCE HIGHLIGHTS

Worked as a Blue Yonder Business Consultant at Sally Beauty Inc. from Oct 2024 to Till Date.

Worked as a Merchandising Solution Architect at Sephora Inc. from Nov 2023 to Oct 2024.

Worked as a Supply Chain Functional Architect at Baxter International Inc. from Apr 2023 to Nov 2023.

Worked as a Blue Yonder Business Consultant at Cantactix Solutions Inc. from May 2021 to Mar 2023.

Worked as a Blue Yonder Business Analyst - Supply Chain at Walmart Canada. from Dec 2020 to May 2021.

Worked as a JDA / Blue Yonder Business Analyst - Supply Chain at Rexall (McKesson) from Aug 2016 to Nov 2020.

Worked as a Supply Chain Functional / QA Consultant at Loblaws from Feb 2010 to Aug 2016.

Worked as a Retail QA Lead at TCS – Woolworths, Target, British Telecom etc. from Oct 2006 to Apr 2010.

Worked as an Implementation Consultant at Odyssey Technologies Ltd from Aug 2005 to Oct 2006.

PROJECT DELIVERY REXALL PHARMACY GROUP

Business Analyst / Supply Chain Functional

Datawarehouse Programs / Projects: functional area – BI, etl; jda reports; cognos

Project #1 - Datawarehouse re-architecture; Data Reset; Data Migration

Project #2 - Be Well points program; BI Data warehousing reports

Project #3 - Supply Chain & Merchandising Reports ; Data warehousing; data migration

Project #4 - Inventory Control & Narcotics (LP) Reports (Patient, Billing, Inventory);

Project #5 – Blue yonder / JDA reports (SCPO, Merchandising, Category Management)

Project #6 – Rubikloud Integration (Data Analytics)

Environment: Nexxsys (Pharma), JDE(ERP), JDA / Blue Yonder (CKB, PMM, Promo, Demand & Fulfillment), Informatica 9.1 & 10.2, Greenplum DW, Micro Strategy, AS/400, PgAdmin III, Oracle DW, IBM Cognos, Toad, SQL Developer.

Decomposed requirements into Epics and Features and created clear and concise user stories that are easy to understand.

Facilitated discussions with key business stakeholders to generate solution ideas and provide status updates and reporting

Translated Business requirements into ETL requirements, created data mapping documents to help with the ETL developers.

Created Business Process mapping, Data mapping, Business requirements, User stories, Functional & Technical specifications.

Created Workflow / Process flow diagrams, Class diagrams, Business Cases, Use Cases, Data Dictionary and so on.

Created BPMN Process diagrams (Swim lanes, Tasks, flow objects etc.), UML Class diagrams (Class, Attributes, Methods), Use

case diagrams and ERD diagrams to represent the entities, attributes, relationships and cardinality.

Facilitated meetings / workshops / sessions as part of new project / enhancement initiatives.

Created conceptual prototypes and mock-ups, proposed alternative solutions that balance cost and benefit and to help the

business to visualize the end state of the product even before the solution is developed.

Actively participated in the data modeling review and ensured the data model has met the business needs.

Profiled existing production data, performed data analysis to support the business requirement and proactively find gaps (if any)

Created work breakdown structure for various work packages. Decomposed activities to assist with the estimation.

Supported PM with developing Business Case, Project charter, project schedules using industry recognized scheduling techniques.

Developed Baseline Budget, Tracked expenses, cost, Cost Variance, Schedule Variance, Burn Rate etc.

Analyzed Informatica ETL workflow, data transformations that loaded data into Greenplum as per requirements.

Maintained the product backlog, Sprint backlog pertaining to reporting dashboards developed by MicroStrategy.

Closely worked with ETL Team, Architect, DB Admin, MicroStrategy(Vendor) for each release

Performed end 2 end analysis from SOURCE (Staging to DataMart to Cube to Reports) to TARGET in Datawarehouse.

Developed complex PostgreSQL / Oracle queries to support the report validation that involves multiple prompts, filters, calculations and data from various external sources.

Supported Report composition, Report Order, Report format, Report Time range - PTD, QTD & YTD & Custom Time Periods

Facilitated user acceptance test, provided extensive support to business users with testing the deliverables.

Prepared and presented project updates to cross functional teams and partners including updates to internal leadership

Worked closely with the Product owner, Operations teams, IT, and other cross functional partners to drive project deliverables

Retail Programs / Projects:

PROJECT DELIVERY REXALL PHARMACY GROUP

Project 1: JDA (Blue Yonder) Demand & Fulfillment retail module - category Management; Supply Chain

Environment: JDA SCPO-Demand, JDA SCPO-Fulfillment, JDA-PMM, JDA Promo, JDA Category Management Suite, ODI, Toad.

Objective is to implement JDA SCPO Platform version 2018.1 at Rexall. The primary goal is to drive Store level replenishment with a time-phased inventory and replenishment plan based on the demand signal coming from JDA Demand using historical POS data,

Key Responsibilities:

Received corporate training on all the modules of Blue Yonder Demand & Fulfillment suite from Spinnaker.

Gathered Requirements for Blue Yonder Demand & Fulfillment orders, DSD, Store orders and Head Office ordering process.

Provided technical and functional expertise in solution designing and enhancement from post deployment

Created solution design for the interfaces - Item, Loc, SKU, Inventory, Weekly sales, Promotions Interface & CKB Interfaces.

Performed Demand Classification, forecast reconciliation, used different statistical forecasting models / Algorithms such as Moving Avg, AVS-Graves & Lewandowski.

Performed MPQ overrides, MSQ and Sourcing overrides and validated how that would impact the suggested orders.

Performed Recships downloads and validated Plan arrives based on the feeds coming in from JDA PMM, Promo & CKB.

Performed JDA Demand Planning, Forecasting and suggested orders and validated Tables (Import, Base, Export) in SCPO.

Reviewed oracle Packages to understand the logic. Executed procedures manually to support Unit testing. Partnered with both Internal & External Stakeholders to troubleshoot issues and drive resolution.

Ensured JDA Demand Planning, Forecasting and suggested orders are meeting the Business requirement.

Contributed with the Implementation of SCPO - Demand Classification, Demand 360, Fulfillment, Dynamic Allocation and Slow mover & Reporting Modules.

Co-ordinated, tracked and reported project schedule and progress to steering committee / senior leadership.

Project 2: Blue Yonder Category Management retail module - category Management; planogram; supply chain

Environment: JDA-PMM, JDA SP Plus, JDA DM, JDA CKB, JDA Web Pub, JDA Open Access, Oracle, IBM Cognos, Oracle ODI, Toad.

Objective is to bring the Planogram Process inhouse at Rexall with Industry leading software. This provides the ability to create accurate space to sales driven planograms, Enable change and develop solutions that would meet Rexall’s transformational objectives.

Key Responsibilities:

Received corporate training on all the modules of Blue Yonder CMS suite from Cantactix solutions.

Closely worked with Business users and Translated Business needs / Stakeholder needs into solution requirements

Validated Item Interface, Loc Interface, SKU Interface, Inventory, Weekly sales Interface, Promotions Interface & CKB Interface.

Managed all the POGs via Data Manager and performed POG Life Cycle and validated the approved POGs via Web Publisher

Solid working experience on the key Category Management modules such as Space Planning Plus, Data Manager, Open Access

Validated 30+ JDA reports include both Vendor and Head Office reports.

Accountable for delivery of all testing phases including: Unit/SIT/UAT/ Regression utilizing Agile.

Co-ordinated, tracked and reported project schedule and progress to steering committee / senior leadership.

Project 3: JDA PMM / EDI Implementation Ph I & II; Insight Ph3 retail module – supply chain; inventory control

Environment: Oracle B2B, JDA PMM, Oracle, JDE(ERP), ESB, Greenplum DW, Auto Star POS. RF Gun. MSTR Reports

Objective is to provide a detailed solution to process the proposed Vendor(s) EDI856 transaction files being sent to Katz / Rexall for the JDA perpetual inventory. This will also help Rexall to accurately track the products and quantities on hand at the retail locations.

Project 4: JDA PMM Implementation - Perpetual Inventory, Pricing, Consignment, Markdown, DSD

Environment: JDA-PMM, JDE(ERP), Oracle, AS/400, Auto Star POS, Greenplum DW, Micro Strategy, Oracle ODI, Toad, PgAdmin III

Regular upgrades to JDA PMM.

Overall Responsibilities

Worked as a Business Analyst / Product Owner with a focus on Supply Chain, Pharmacy and Business Intelligence.

Contributed with maintaining Business Case and benefits throughout the project life cycle.

Worked with Business users, translated changes and user / organization needs into Business requirements / User stories.

Provided technical and functional expertise in requirement gathering, solution designing and enhancement from post deployment

Documented supply chain (SCPO) process flows for current / proposed process, workflows, context diagrams and data flows.

Created Business Process mapping, Data mapping, User stories, Functional and helped with Technical specifications.

Created work breakdown structure for various work packages. Created activity list and project Milestone to assist the estimation.

Supported PM with developing project schedules using various estimation techniques. Supported Budget tracking and RAID Log.

Created complex SQL queries to generate ad-hoc reports in order to help Business users to monitor DNF ordering process and to proactively take actions in case of an issue (order creation / transmission) with McKesson.

Created multiple PO types (DSD, Pre-Book, Seasonal, POG, Ad-Hoc, NSO etc.) and exchanged with vendors via EDI 850.

Supported EDI 850 (PO), EDI 855 (PO Ack), EDI 856 (ASN), EDI 997 (Ack) with various vendors including McKesson.

Supported various Micro Strategy Reports related to ASN & PI – Outstanding ASN Report, Inventory & Supply Chain reports.

Performed Data Migration analysis (Pre migration, Migration & Post migration) from Legacy database to BI Datawarehouse.

Led, Co-ordinated and technically supported the implementation of EDI Transactions which include 850, 856, 997 and 810 with Vendor service providers (Banyan Corp, Sheralven Enterprises, Perfume Direct & McKesson)

Triaged and provided resolution to EDI and business issues for internal (Buying, Merchandising, Supply Chain and Inventory Control) and external Vendors (Banyan Corp, Sheralven Enterprises, Perfume Direct & McKesson)

Extensively worked with Vendors and achieved smooth implementation of EDI Process.

Worked closely with the development team in all stages of the development life cycle. Bridged the gap between business and technological sides of the solution.

Prepared and presented project updates to cross functional teams and partners including updates to internal leadership

Collaborated closely with other Project stakeholders to ensure quality delivery of the project on time, to scope and on budget.

EDUCATION

Bachelor of Engineering Computer Science & Engineering University of Madras 2004

Master of Business Administration Systems & Management Alagappa University 2006

Contact this candidate