Supply Chain Data Analyst

BHAVANI Business/Data Analyst/Project Lead Phone: 559-***-**** EMail: ************@*****.***

Professional Summary

Overall, 10 years of professional IT experience in Corporate Finance and Banking services, Automotive Retail Domain, Supply chain and Pharmaceutical (Health Care), Industry.

Strong experience with various Software Development Life Cycle Methodologies (Iterative, Agile Scrum and Waterfall)

Proficiency in writing Business Requirement Document (BRD), Functional Requirement Document (FRD) and detailing into System requirement specification (SRS), Subject Matter Expert (SME), Software Development Lifecycle (SDLC).

Solid Experience working with teams integrating platforms and systems in a Treasury, Fashion Retail & Ecommerce environment including MuleSoft.

SAP Product Lifecycle Management (PLM), SAP OTC and ECC TO S/4 HANA focusing on methodologies, tools, processes involved in managing the entire lifecycle.

Experience in configuring and customizing CRM, ServiceNow applications and modules to suit business needs, without necessarily needing to code.

Facilitating the integration of ServiceNow with other enterprise tools and systems to streamline workflows and data exchange.

Experienced in ERP to Oracle PLM, Workday modules (Accounts Receivable, Accounts payable, Asset management, Corporate Financial Accounting setup, Supply chain, GL)

Extensive experience working on Commercial and Wholesale lending technologies on Loan IQ, ACBS/CLS to support complex financial transactions and improve customer satisfaction.

Drafting required API selection and evaluating potential API to ensure they meet the business functional performance and security requirements/

Good understanding in Database and Data warehousing concepts (OLTP & OLAP).

Highly skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Worked on NetSuite, ADP configuration for reporting, Business process analysis, Data Management, Integration.

Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS).

Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.

Understanding for the end-to-end global process design and 3E solution delivery scope and implementation method.

Expertise in SQL Server Analysis Services (SSAS) to deliver online analytical processing (OLAP) and data mining functionality for business intelligence applications.

Designed, developed, tested various Power BI/Tableau visualization for dashboard and ad-hoc reporting solutions.

Created interactive data visualizations in Tableau, using relational and aggregate data sources.

Created incremental refreshes for data sources on Tableau Server.

Created report schedules, data connections, projects, groups in Tableau Server.

Developed Tableau Dashboards/Story's from multiple data sources using Data Blending.

Developed various Cloud data platforms (Data Bricks & Snowflakes), PLM(Product Lifecycle Management), for large subset of GCP, AWS products as well as open source and commercial products for automation, monitoring, operations, security.

Operational knowledge in working and supporting for Data Migration/Integration tools and projects to manage throughout the project’s lifecycle.

Building, publishing customized interactive reports and dashboards, report scheduling using both Power BI and Tableau server.

Experienced in analyzing and creating Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Workflow Diagrams, Wireframes, Class Diagrams, and Sequence Diagrams using MS Visio, IBM Rational Software Tools.

Proficient in SAP Project Lifecycle Management, OTC - working as a liaison between the client and development teams, managing requirements, maintaining issue logs, status updates, and establishing schedules while adhering to the objectives from the project's inception through deployment.

Supported Data Modeling teams, captured Data Requirements, documented ER diagrams, created Metadata Documents - Data Mapping documents and Data Dictionaries.

Skills Summary

Languages/Methodologies

SQL, PL-SQL, JavaScript, Agile, Waterfall Technologies JSP, Servlets, JDBC, CSS.

Web Technologies

HTML/HTML5, CSS2/CSS3, DHTML, XML, XHTML, JavaScript, AJAX, jQuery.

IDE

Visual studio, visual code, Eclipse, Dreamweaver, Text Wrangler, Notepad++, Sublime Text, HTTP web server, Apache Tomcat server 7.0.63, Sublime, WS.

Frameworks

Angular Js 1.2,4 MVC, Nodejs, spring, hibernate.

Version Control

VSS, CVS, SVN, GitHub.

Development Tools

Adobe Photoshop CS5, Google Ad Words, Yahoo Search Marketing.

Application Servers

Apache, Web logic, Web Sphere, Tom Cat, JBoss, HTTP webserver Sun java System Web Server, Glassfish, Netscape Enterprise Server.

Defect Tracking Tools

JIRA, Test Director, Quality Center, Rational Clear Quest

Operating Systems

Linux, UNIX/LINUX, Windows, Mac.

Mic

Adobe Photoshop, Gimp, servlets, MS Office, Jira, Firebug, Chrome Developer Tool, Windows Movie Maker.

Other Technologies

Karma, Jasmine, Web pack, Grunt, Gulp, Bower, Protractor, Mocha, Agile methodologies, Jenkins, LESS, SASS.

Data Bases

PL/SQL, MySQL, MSSQL, Oracle 9i/10g/11g/12c.

ORM

Hibernate, MyBatis, Java Data Objects, Enterprise JavaBeans (EJB)

Education:

Bachelor’s IN COMPUTER Science, JNTUH, 2014 MASTER’S IN COMPUTER SCIENCE, Northwestern Polytechnic University, 2016

Professional Experience

Role: Business Systems Lead Client: Charles Schwab, San Francisco, CA Jul 2022 – Ongoing

Project Description: Being a Lead Project BA, I have done reporting initiatives through business analysis, SME in business domain gathering accurate requirements, SAP S4 HANA, OTC to ensure the product data is layered through multiple channels, understanding business process, ensuring the proposed solutions meet the requirements of the client with technology blend using Workday Modules, data visualization tools like Product Development, POWER BI & Tableau, SQL, Teradata, Data cleansing using Notepad ++ and Microsoft Excel to extract key insights of the project.

Charles Schwab focuses on corporate financial services that provides the range of services like brokerage, Investment management and banking. They offer online trading platforms, investment advice and retirement planning and various financial products for Individual investors and institutions.

Responsibilities:

Responsible for stakeholder management, SLA adherence using SME service improvement value adds etc. specific to business unit for ensuring stability.

Understanding of retail and corporate finance banking, trade finance or other specific areas of banking that are relevant to the organization.

Expertise in implementation, optimization, and ongoing support of workday financial modules within our organization from initial system configuration and testing to leading cross-functional teams.

Designing and executing tailored solutions that address unique organization challenges, leveraging workday’s robust capabilities in financial management.

Instrumental in automating corporate financial process, enhancing reporting capabilities and improving financial data accuracy.

SAPH4 HANA expertise that involves managing product data across multiple channels to enhance Centralized Data Management, Product Catalog Management.

Performs regular ad-hoc data querying and analysis to better understand areas impacted by S/4 HANA such as billings, bookings, revenue.

Strong understanding of data transformation from ECC to SAP S/4 HANA ERP modules relevant to the business operations to analyze business processes, identify inefficiencies and propose solutions that leverage the technology to address these issues.

Experience configuring sales various CRM, Sales force modules limited to cash management, workflows, profiles, roles sharing rules and reports.

Develop a cloud-based business management using (Data bricks, Snowflakes) suite being BA by configuring custom fields, forms, workflows.

Proficient in importing the data from NetSuite, ADP to ensure the data is accurate and integrity.

Managing the financial aspects (Treasury) like managing, cash, investments, financial risks, risk, and compliance management to ensure the stability and liquidity of the organization.

Support ERP data migration and integrate with source applications.

Designing API Integration solutions for better understanding of pricing models, scalability, reliability of API SERVICES.

Configuring SAP S4 HANA to develop the customizing adobe forms to meet business requirements.

Provide the expert analysis on various data sets, create models, and provide insights that will help shape our strategic decisions.

Implementation of Oracle PLM, ERP modules – Accounts receivable which manages Customer set up, Invoicing and billing, Credit management, Receipts and Cash application, Collection Management and Revenue recognition for data conversion process.

Experience in Teradata, Azure, Data Bricks, Data Factory for big data integration workflows.

Accounts payable for Vendor set up, Invoice processing, payment processing, expense management discounts and other terms to transform the data and convert the file formats, media types and other data systems.

Actively identify the data quality checks and issues to communicate it to relevant stakeholders across the globe.

Strong analytical skills with the ability to collect, organize and analyze significant amounts of Informatica Power Center with attention to detail and accuracy.

Data analysis reporting and dashboard creation using POWER BI’s intuitive interface.

Implementation gathering the requirements gathering to configure for testing and deployment.

Testing and Quality Assurance after the API Integration is implemented to ensure performance of API.

Data preparing and modelling between different columns and measures for efficient and accurate analysis and visualization.

Environment: Project management – SAP OTC, Monday.com, Teradata, JIRA, Confluence, Word, Excel; Data and Reporting Analysis; Diagrams and modelling – Microsoft Visio, Collaboration – Microsoft teams and Slack.

Role: Business analyst Lead Client: Bristol Myers Squibb, Lawrence Township, NJ May 2021– June 2022

Project Description: As a Data Analyst, I have supported Data migration projects using SAPH4 HANA, SAS ID, Product Development, Macros, Notepad ++, ETL operations, MS Excel, Corporate financials for automation purpose to streamline the efficiency. Handled various types of raw data dump from legacy systems

Bristol Myers Squibb is a global biopharmaceutical company to discover, develop and deliver the innovative medicines. They are dedicated for advance science to improve patients’ life that aid individuals in overcoming severe illnesses. Bristol Myers is involved in SAP product life cycle of research and development to manufacture and market medications.

Responsibilities:

Analyzing the domain knowledge, bridging the communication gap, problem solving, assessing risks involved, providing the validation of solution for risks triggered ensures SME.

To analyze and interpret data to support business decisions within the pharmaceutical industry.

Liaise and be part of our extensive Workday reporting – Custom reporting & variance analysis.

Workday Accounts Payable & Receivable streamlines invoice processing and payments which improves cash flow management, enhancing vendor and customer relationships.

Providing training to end users on how to use new systems and solutions effectively to integrate seamlessly with SAP data and workflows.

Leveraging SAP S/4 HANA OTC functionalities and Adobe document services to enhance efficiency and improve user experiences.

SAP S/4 HANA OTC expertise to maintain product information through various platforms like Ecommerce, retail partners, Market places)

Deep understanding of health care products through QTC various clinical trials, treatments, healthcare products to the final cash collection ensuring minimal errors and delays.

Expertise with Data Migration and Integration projects to manage the project lifecycle.

Expertise in working with Data engineering team to share the functional aspects of the project management Informatica Power center.

Experience in Azure, Data Bricks, Data Factory for big data integration workflows.

Experience in ETL operations with data migration and integration models, data pipelines, and complex data sets.

Experience in migrating data from legacy system for mapping, cleansing, and ensuring data is accurate during the migration process.

Involving the Oracle PLM, general ledger posting journal entries, financial reporting, Intercompany Transactions, Consolidating the data transfers to take some advice from Project Managers and Stake holders on activities.

Understanding the functional requirements using Supply chain management to track the Inventory and order management, Demand planning, Forecasting, Logistics and Transportation Management.

Understanding the cross functional teams to leverage statistical and analytical tools to extract valuable information from various data sets relating to drug development, clinical trials, and other aspects of company’s operations.

Able to view and test QA cases for user acceptance.

Proficiency in JIRA and Confluence Safe Agile.

Collection of data, creating reports, identifying trend analysis, providing the insights make strategic decision making.

Knowledge of system administration tasks including installation, configuration, maintenance of Finastra Equation.

Experience in utilizing SAS procedures, Macros and other SAS applications for data extraction, cleansing, loading, reporting purposes.

Strong Excel cost-effective including Formulas and Pivot Tables, VLOOK UPS.

Working knowledge of cloud platforms (Databricks and Amazon Redshift) like AWS, GCP, OpenStack, OpenShift to build the blocks through NO SQL.

Creation of reports in SAS and exported to excel spreadsheets, web reports using Web report studio.

Strong knowledge in SAS/BASE, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/STAT in UNIX and Windows environment.

Monitor management through Informatica Power center to identify the sale trends, spot issues and reports on progress in retail sector.

Great knowledge in Reporting & Analysis, Treasury technology, Corporate financial planning, forecasting.

Environment: Google workspace, Microsoft Edge, Microsoft Office, ZOOM and Teams collaboration, MYSQL, Unix, QTC.

Role: Lead Business Intelligence Developer Client: Silicon Valley Bank, Santa Clara, CA Nov 2018–April 2021

Project Description: I have played a key role as a Developer involving in BI tools (Micro soft Power BI, Tableau, Qlik View), Oracle PLM, NetSuite, ADP for creating the interactive dashboards and reporting purposes. Data Warehousing tools to manage large data sets for analysis, ETL (Extract, Transform and Load) the data from SSIS, SSRS, Teradata, SQL, SAP OTC, Corporate Financials packages to transform it for BI purposes.

SVB expertise in Innovation, life sciences and venture capital sectors to provide wide range of financial tailored services to the unique needs of startups, financial need of companies, private equity in the technology. Our vision is to support our clients from credit and cash management to international banking services in the dynamic and fast paced world.

Responsibilities:

SAP OTC BAs ensures the business process and solutions are aligned to Compliance and regulation.

To implement technology solutions to enhance banking operational efficiency and customer experience.

Workday’s Asset Management involves managing lifecycle of tangible and intangible assets to optimize the asset tracking, depreciation calculations, maintenance scheduling and leading to better utilization.

Corporate Financial Account setup ensures the financial statements to reflect the organization true financial position to support strategic planning and external reporting requirements.

To understand business requirements in the BI context and design data models to convert raw data to meaningful insights.

To create dashboards and visual interactive reports using Power BI.

To design, develop, and deploy Power BI scripts and perform efficient detailed analysis.

Great understanding on technical requirements for API integrations got selecting the potential API and evaluate its performance.

Adhering to API security best practices and compliance requirement to avoid the data encryption.

Extensive experience in ETL design, development and maintenance using Oracle (PLM), SQL, Informatica, Teradata, Power center v 5.x/6.x/7.x/8. x.

To define and design new systems by analyzing current ETL processes.

To analyze subject matter expertise from ERP to CLOUD (GCP, AWS) which includes Customer set up, Invoicing and Billing, Credit Management, Receipts and Cash apps.

Able to view and test QA cases for user acceptance.

Proficiency in JIRA and Confluence Safe Agile.

Good understanding of Treasury operations, Process improvements, Stakeholder management, Training & support to operate the functional aspects of the project.

Proven experience working in Ecommerce, Retail or Supply chain & logistics sectors.

Great understanding on Hadoop Cluster architecture and monitoring the cluster.

To make technical changes to existing BI systems and depth understanding of GCP (Google cloud platforms), OpenStack with scalable data solutions using a range of new and emerging technologies.

Experience in managing and reviewing Hadoop log data files.

Develop and maintain working knowledge of credit risk data bases to provide the data and analytical support to senior management.

Strong knowledge and experience with Microsoft BI stacks such as Power Pivot, SSIS, SSRS, and SSAS.

Strong ability to write SAS programming for extraction of data from flat files, Excel spreadsheets and external RDBMS tables using LIBNAME and SQL PASSTHRU facility.

Skills in BI tools systems, such as Power BI, SAP FICO experience, Tableau, etc., creating data-rich dashboards, implementing Row-level Security (RLS) in Power BI, writing DAX expressions, developing custom BI products with scripting and programming languages such as R, Python, etc.

Environment: HTML, Microsoft Edge, Data Analysis &Reporting tools, SAS (Software as a service) Information Architecture, Microsoft Visio, Microsoft Teams, Trello.

Role: Business Systems Analyst Client: Macy’s Tech, San Francisco, CA Sep2016 – Oct2018

Project Description: Well-versed carrying out ETL frameworks, SAS for analyzing the statistical data, Data visualization tools (Tableau and POWER BI) for plotting the trends, Automotive Retail Domain, Service now, Workday, Customer relationship management, SQL, Teradata, CLS/ACBS, Sales force platform to view the custom feeds, sales margins to cope up with customer Interactions.

Macy’s is an omnichannel retail organization that operates department stores, websites, mobile applications. It’s known for diverse selections of brands and products to cater as per customer preferences, it also organizes events and promotions to contribute its status as a predominant and popular departmental store in United states.

Responsibilities

To understand trend and insights, Competitive analysis, Customer behavior, Sales data analytics, Functional dynamics in retail industry to stay up to date in the market using ARD (Automotive Retail Domain).

Efficient knowledge in analytical skills, problem solving, people management skills to collaborate technical Informatica Power center to the stakeholders to perform Cross-Functional Collaboration.

Experience in Teradata, Azure, Data Bricks, Data Factory for big data integration workflows.

Strong knowledge of and experience with reporting packages (Business Objects), databases (SQL), programming (XML, JavaScript, or ETL frameworks)

Expertise in loan origination, servicing, and syndication processes through loan IQ, additionally CLS/ACBS has allowed me to significantly contribute to streamline loan administration and portfolio management through Commercial lending techniques.

Exposure to MS SQL 2008 and SQL 2012 databases.

Leveraging the Workday adaptability to integrate the Insurance claims process efficiency, policy management and regulatory compliance tracking.

Customizing the deployment of Corporate Financial Management for accurate financial reporting, improved compliance with industry regulations and enhanced decision-making capabilities.

Hand on experience in writing SSIS packages & exposure to SSRS and SSAS.

Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

Able to view and test QA cases for user acceptance.

Proficiency in JIRA and Confluence Safe Agile.

Extensive knowledge of advanced SAS/STAT procedures including UNIVARIATE ANALYSIS, DBMS & CRM platforms.

E2E Data engineering and lifecycle (Including non-functional requirements and operations)

Performed data extraction, analysis and published results using SAS WEB REPORT STUBIO.

Hands on experience on Data Visualization tools like Tableau and Power BI.

Well versed in handling the POINT OF SALE (POS), Inventory management (IM), E-Commerce.

Experience in Service now platform, CRM Sales force platform to manage customer interactions, processing of retail systems.

Optimizing the Supply chain management through Cloud (GCP, AWS), SAP H4 HANA Integrated business planning.

Environment: HTML, Cloud (GCP, AWS), Microsoft Edge, AJAX, Information Architecture, MYSQL, Unix, Data and Reporting Analysis.

Role: IT Business Analyst Client: Invesco, Hyderabad, India June 2014 – April 2015

Project Description: Extensive knowledge working on JIRA, Confluence as per ticketing system, Microsoft Excel, ETL (SSRS AND SSIS), Notepad ++ for extracting the large data sets, CA workload automation, Service Now, CRM, LOAN IQ & CLS/ACBS – to generate reports, SQL – for Data Analysis (Extraction, Cleaning, Loading)

Invesco is Investment management company that allows our clients to choose what they need to diversify the investments like mutual and exchange trade funds. It helps clients to achieve their Corporate financial goals by offering portfolio management, Corporate financial advisory and wealth management services.

Responsibilities

Conduct detailed analysis on stakeholder management to regulate Corporate financial requirements.

Worked on Daily reporting resources and created SSIS packages to retrieve data from source systems.

Strong and in-depth knowledge of SQL language, query optimization and data loading techniques using SSIS

Designed databases and ensuring their stability, reliability, and performance.

Operational knowledge in Loan IQ and CLS/ACBS with cost effective way of managing and servicing commercial Wholesale lending portfolios.

Establishing a feedback loop with users and stakeholders to continuously identify areas for improvement in ServiceNow applications.

Designed, created, and implemented database systems based on the end user's requirements and improved the application's performances.

Solid experience in database design or integration experience with SQL Server databases

skilled in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.

Able to view and test QA cases for user acceptance.

Proficiency in JIRA and Confluence Safe Agile.

Worked on CA workload automation to generate reports

Worked on SSAS CUBES to load the data

Excellent verbal and written communication skills

Exposure to MS SQL 2008 and SQL 2012 databases

Hand on experience in writing SSIS packages & exposure to SSRS and SSAS.

Worked on Requirement analysis, design and development of modules using Power BI, Tableau, SSIS and SSRS.

Worked on client problem understanding, requirement building, documentation and translation of the requirements into dashboard solutions.

Building, publishing customized interactive reports and dashboards, report scheduling using both Power BI and Tableau server.

Created stored procedures and SQL queries to pull data into power pivot model

Developed Tableau visualizations and dashboards using Tableau Desktop.

Developed Tableau workbooks, Power BI reports and dashboards from multiple data sources using Data Blending.

Responsible for providing 24x7 Production support, Database and Log Backups & Restoration, Scheduling Backups. Backing up master & system databases and restoring them when necessary.

Export reports in various formats like MS Excel, PDF, MS Word, Text, CSV.

Involved in performing incremental loads while transferring data from OLTP to data warehouse.

Experienced in migrating SSIS packages and stored procedures to the newest version.

Collaboration with Solutions management, Product lifecycle management PLM and IT Development – Gathering input and data for design of current and future solutions.

Prepared documentation for database applications and memory management for database systems.

Developed database schemas, tables, dictionaries to ensure the data quality and integrity of databases.

Demonstrate understanding and proven track record for cloud-based solutions (GCP, AWS), continuous integration/deployment, cloud architecture.

Environment: SQL server, AppDynamics (reporting tool), Excel sheet, Cloud (GCP, AWS), Microsoft Edge, 1EACM Platform, snipping tool. Aderant Visual & Design studio.

Contact this candidate