Data Analyst Business
Resume:
Pavani Venkatayogi
***********.******@*****.***
LinkedIn profile : https://www.linkedin.com/in/pavani-venkatayogi-3488a637/ Work Authorization: H4 EAD Valid till APR 2027
Experience Summary:
1. 16 years of IT experience in Advanced SQL, Data Analysis, Oracle Retail/RETEK (ERP) applications, Business Analysis and Quality Assurance / Testing, Data Profiling. 2. 16 years’ experience as Senior Data Analyst / Senior Business Analyst in Retail and Healthcare domains, Data space.
3. 6 years of experience working with Health care data and in an EDW space with primary focus on Data and Analysis, writing complex SQL queries, stored procedures on Netezza, Snowflake, Oracle, and SQL Server, DBT, Azure Dev Ops.
4. 5 years of experience in workforce management tools like Kronos, Lawson, SAP SuccessFactors, JIRA Data
5. 9 plus years of experience working with Enterprise Data Warehouse (EDW): Netezza, Snowflake. 6. Proficiency in advanced SQL.
7. Experience working with Business Intelligence developers to create KPI’s that are needed for their reporting dashboards. Created mapping documents for Business Intelligence developers and business users to have a reference to the KPI transformation logic. 8. Created Mappings for Historic, transactional, financial, sales, foundation data to Enterprise Data Warehouse (Netezza/Teradata).
9. Perform Data Profiling as needed to help the Enterprise Data Warehouse team with the source metadata identification from several source systems. 10. I have a very good knowledge of EDW Concepts and Data Models. 11. I trained and worked in Epic EMR EHR Clarity Data Models and Caboodle EPIC DW knowledge. 12. 15 years dedicated to ensuring quality data across Enterprise. Was responsible for building data integrity controls to support critical business processes. As a Lead Business and Data Analyst, I worked with multiple business and technology teams across Enterprise to understand their control needs relative to the Data Integration Standard and support in creating documentation such as Source to Target Mapping documents from several sources, Requirement Specification Documents, Stakeholder Management and Communication.
13. 8 years’ experience as Business Analyst Lead / Data Analyst Lead. 14. Manufacturing Domian experience, Oracle DWH ODI migration to Snowflake. Certifications: Introduction to Oracle9i: SQL (1Z0-007) EPIC SQL 1 and SQL 2 Certified
Skills:
Database Oracle 9i/10g/11g/12c, IBM Pure Data for Analytics (Netezza), Snowflake, SQL server Operating System Windows 98, XP,7,10
Tools SQL Plus, SUN see beyond, SQL Developer, Snowflake UI, Aginity workbench, Dbeaver, DataStage 11.5, ER Studio Data Architect, Erwin, Rational Clear Quest, Rational Clear Case, HP Quality Center, Putty, WINSCP, Bug DB, TOAD, Microsoft project planner, Microsoft Visio, ALM, Control-M/Enterprise Manager 7.0, Front Range - IT Service Management (ITSM), ALM, JIRA, Confluence, Oracle BI Publisher, Oracle reports, Oracle Business Intelligence Enterprise Edition (OBIEE), Visual Studio Code, DBT, HPSM, Bit Bucket, Cornerstone, Tele tracking, Qualtrics, Git hub Enterprise, Collibra EDW:
ENTERPRISE DATA
WAREHOUSE
Carilion Clinic’s EDW:
• Write Complex SQL which involves coding for business logic to bring data into curated layer objects, Unified data model objects.
• Develop unit test stored procedures to bring data into snowflake Data Lake objects.
• Develop unit test stored procedures for creating datasets out of EDW for third party vendors, which will be sent in the form of files.
• Create DataMart’s inside EDW specific to a project, like Covid, contact tracing etc.
• Document data lineage.
• EDW Migration efforts to move from IBM Netezza to snowflake. Oracle Retail Datawarehouse:
2
Oracle Retail Data Warehouse (RDW) provides retailers with a fully functioning out-of-the-box solution, complete with Business Intelligence.
SQL/Reporting/Integration • Create facts, dimensions, data marts in EDW by writing complex SQL queries as views which are passed onto Data Engineers to create data pipelines.
• Subject Matter Expert for Covid NHSN HHS Federal reporting, VHASS and VDH State reporting. Created 80 plus views to arrive at metrics needed for covid federal reporting, these were never reported out of EDW and worked with Data Architect to create a new data model for federal reporting.
• Primary point of contact for Covid contact tracing business logic views.
• Write custom SQLs for reporting in oracle BI publisher editor.
• Write customized reports using OBIEE
• Write Materialized views to provide RMS, RPM snapshot data, Oracle Financials data to EDW, RDW.
• Create Data Mappings for Historic, transactional, financial, sales, foundation data between RMS/RPM to Enterprise Data Warehouse (Netezza/Teradata)
• Worked with RDW team, to provide the source related data (querying the database), analyzing the data required for the KPI’s.
• Validate the data points across different source applications including Oracle Financials and compare against Finance cubes, EDW, RDW.
• Wrote SQLs to write data into staging tables from RMS, RPM, e-business suite to send the data across to EDW.
• Train Business users on customized reports, new functionality, forms that were newly created.
• Used small reporting tools which were created internal to Ascena, to create custom reports to store teams, to evaluate financial performance of store by identifying key metrics.
• Used RETL (Retail Extract Transform Load) XML interface to validate that correct data is passed onto the RDW from RMS, RPM, and Oracle Financials. There are 700 in built data models for close to 200 KPI’s in RDW, and EDW team required frequent input from source teams to make sure that reporting was accurate.
• Subject Matter Expert for Oracle Retail Implementation (RMS, RPM, Oracle Financial Apps) which required integration of source systems to load, build and maintain EDW(Teradata/Netezza) for Catherine, Lane Bryant Brands.
• Lawson, Kronos, SAP Success Factors, Strata.
Business Analyst Skills
Business Intelligence
Developer Skills
Data Analyst Skills
SQL Developer Skills
Business Analysis, Microsoft Office, Microsoft Excel, SQL, Microsoft PowerPoint, Business Process Improvement, Requirements Analysis. Project Management, Software Development Life Cycle (SDLC),Data Analysis, Agile Methodologies, System Development, Walkthroughs, Analytical Skills, Requirements Gathering, Data Analytics,Business Operations, Reporting, Data Visualization, OBIEE, Process Management, Business Process Mapping, Microsoft Power BI,Data Integration, Scenario Analysis, Big Picture View, Process Orientation,Intellectually Curious, Presentation Skills, Product Management, Scrum,Documentation, Business Intelligence (BI),Customer-focused Service, Extract, Transform, Load (ETL), Strategic Planning
,Communication,Data Warehousing,Data Architecture, Data Governance, Data Profiling, Data Quality, Post- production Support, Production Implementation, Oracle Database, Data Import/export, Data Conversion, Data Migration, Data Mining, Business Intelligence Tools, Data Models, Creative Problem Solving, Research, Oracle Isupport - Metalink - logging SRs, follow-up and OWCs. Oracle BI Publisher, OBIEE, Oracle Reports, Application Implementation Methodology (AIM).
Testing /SQA Black box testing, Test strategy, Master test plan, Test planning and test preparation, Defect triage, Defect management, Test Estimation, Test Scenarios/Conditions/cases, Test Execution, Software Quality Assurance, System testing, Functional testing, Integration testing, Data Migration testing, Negative testing, Risk-based testing, Database and Smoke testing. SQL and RDBMS. Java applications testing, XML testing, UNIX testing, Pro*C and Ksh batch testing, MQ Series testing. Automation test script execution - QTP, test validations and troubleshooting results. Experience in an agile/SCRUM environment. Oracle Retail (RETL) and Oracle Retail Data Warehouse Testing. ELT testing: Stored Procedures. ATG and OMS – Ecomm platforms Achievements:
• Multiple appreciations from team members, higher management on leading the project end to end for Covid dashboards, federal reporting, VHASS reporting. CCT project.
• Received prestigious Carilion Clinic 2021 Challenge Coin for the work done during pandemic.
• Received HULK AWARD Certificate- 2017 for being part of SSG-APP-MERCHANDISING-SYSTEMS- SUPPORT (Ascena Retail Group) has managed to the team to HULK Smash all the issues and to keep number of Production support issues to be minimum.
• Played a lead role for Integration/System/Functional testing project Super-Fusion - Oracle Retail Implementation (Supervalu Client).
3
• Numerous Client appreciations.
• Member of training team for delivering knowledge sharing sessions to client.
• Trained Litmus7company associates on RPM functionalities.
• Won “Innovation Contest” in July 2010, at Oracle Retail (Oracle - Fulltime).
• Won “Recognition Award” for project Super-Fusion - Oracle Retail Implementation (Supervalu Client) project.
• Won “On the Spot Award” for contribution in SE QA team on Mar 2011, at Oracle Retail (Oracle - Fulltime). LinkedIn Recommendations Received:
https://www.linkedin.com/in/pavani-venkatayogi-3488a637/ PROJECT DETAILS:
1. Cornerstone Building Brands (Feb 2025 – Jul 2025) Project
Description
Cornerstone Building Brands is North America's largest manufacturer of exterior building products. Cornerstone is comprised of a family of companies operating manufacturing facilities across the United States and Mexico, with additional sales and distribution offices throughout the United States, Canada, and Costa Rica. Worked on a project for Cornerstone Building Brands – they are migrating from on-prem Oracle to Snowflake Employer
Client: Cornerstone Building Brands
Employer: CBTS
Start - End Period Feb 2025 – Jul 2025
Role Senior Data Business Analyst / Product Owner
Contribution • Supported CBB’s Enterprise Data Warehouse (EDW) to Snowflake migration project. Worked closely with project teams, business users, and application teams to ensure a smooth cutover to Snowflake. Demonstrated strong BI knowledge as Power BI is our primary reporting tool.
• Coordinated with project teams and business users to plan, test, and execute the migration of applications from EDW to Snowflake.
• Acted as a liaison between technical teams and business stakeholders to gather requirements, define objectives, and ensure successful transition.
• Developed and executed test plans to validate data migration, application functionality, and integration with Snowflake.
• Collaborated with BI teams to ensure Power BI reports and dashboards function correctly post-migration.
• Worked closely with other application teams to assess dependencies, impacts, and mitigation strategies.
• I identified and documented potential risks, issues, and resolutions throughout the migration process.
• Provided post-migration support and assist in optimizing Snowflake performance.
• Experience in data warehouse migrations or cloud-based platforms.
• Strong understanding of Snowflake, EDW, and data migration methodologies.
• Knowledge of Power BI and experience in coordinating BI/reporting tool integrations.
• Proven ability to collaborate with cross-functional teams and manage project timelines effectively.
• Strong analytical, problem-solving, and communication skills.
• Experience in data validation, testing strategies, and stakeholder coordination.
• Advanced SQL, data modeling, and cloud-based data platforms.
• Experience in agile methodologies and working in fast-paced environments.
• Background in ETL processes and data governance best practices.
• Prior experience working in large-scale enterprise data migrations
• Azure DevOps, Product owner and Scrum master role in addition to the above roles and responsibilities.
• Coordinated cross-functional teams and third-party vendors to ensure delivery of key milestones
• Facilitated business requirements gathering, fit-gap analysis, and solution design workshops
• Ensured system configuration aligns with operational needs and strategic objectives
• lead cross-functional project teams and manage complex, multi-site deployments
• Strong understanding of business process mapping, systems integration, and change management
• Excellent interpersonal, communication, and leadership skills
• Experience working with structured project methodologies (e.g., Agile, Waterfall, or hybrid).
• Help build developers required infrastructure for optimal extraction, transformation of complex sets of data 4
and loading of data from various data sources
• Help build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics
• Ensured deliverables have Executive presence and efficient processes
• Worked with Bi developers to help them build insightful reports and presentations for business uses; Works beyond requirements to have visual storytelling and scalability
• Identified designed, and implemented internal process improvements including re-designing processes for greater scalability, optimizing data delivery, and automating manual processes
• Worked with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
• Ensured data architecture, data model and dashboards standards are followed. 2. Baylor Scott & White Health: Enterprise Data Warehouse (Jun 2024- Oct 2024) Project
Description
Built Marketing Campaign Data models from multiple confidential source systems for customers and Campaigns for Baylor.
Built Medication and Pharmacy model for the entire organization Employer
Client: Baylor Scott & White Health
Employer: Medsys Group LLC
Start - End Period Jun 2024 to Oct 2024
Role Senior Data Business Analyst / Product Owner
Contribution Displayed Healthcare business understanding, and experience with Snowflake and SQL, DBT. Worked with a variety of stakeholders, including service lines, technical teams, and healthcare leaders, to develop data models that track
the performance and return on investment (ROI) of specific healthcare campaigns. Ensure data integrity, accuracy, and consistency across the enterprise. Created ER lookup design documents and ER lookup scripts. End to End process flow diagrams.
- Collaborated with service lines, healthcare leaders, and technical teams to design and create data models.
- Developed models to analyze the impact and ROI of healthcare campaigns aimed at improving patient outcomes.
- Lead the collection and analysis of data from various sources to identify key metrics for campaign success.
- Used Snowflake, SQL, and other data processing tools to build and maintain data models.
- Communicated findings and insights to stakeholders through clear presentations and reports.
- Worked with the reporting team to ensure accurate data visualization and reporting.
- Experience in data modeling and working with SQL databases, particularly Snowflake.
- Excellent communication and presentation skills. Extensive experience in creating and maintaining conceptual, logical, and physical data models. Risk & Controls Domain: Experience in data modeling within a risk and controls environment for a large enterprise. Communication: Excellent verbal communication skills to explain complex data concepts clearly to business stakeholders.
Data Analysis and Data Profiling: Proficient in performing data analysis and understanding risk, data authority, and data use case. Dedicated to ensuring quality data across Enterprise. Was responsible for building data integrity controls to support critical business processes. As a Lead Business and Data Analyst, worked with multiple business and technology teams across Enterprise to understand their control needs relative to the Data Integration Standard and support in creating documentation such as Source to Target Mapping documents from several sources, Requirement Specification Documents, Stakeholder Management and Communication. 5
3. Carilion Clinic: Enterprise Data Warehouse (Jan 2020- Jun 2024) Project
Description
• Carilion Clinic’s Enterprise Data Warehouse hosts the data from multiple source systems which include Epic Clarity data, financial data, timekeeping data, operational data to name a few. Data is brought into EDW raw which is referred to as Data Lake, and EDW team de-normalizes the data to make it ready to be consumed by Analytics teams across the entire organization. Analytical data is organized into three categories: Curated layer, Unified Data Model layer, Data Mart layer.
• Carilion’s legacy Datawarehouse is on IBM Netezza, and the new Datawarehouse is a cloud-based Snowflake Datawarehouse.
• Keys projects included Data Migration project from Netezza to Snowflake. COVID Dashboards, Federal reporting, VHASS reporting, Contact tracing, several outbound file creations for vendors, curated layer build, UDM layer build, DBT layer for staging models, Finance payroll dashboard project, Covid dashboard, Clearpoint, RUMP Employer Carilion Clinic
Start - End Period Jan 2020 to Jun 2024
Role Lead Data Business Analyst / Product Owner
Contribution • Handled multiple complex projects end to end, acting as a Lead Business Analyst, Data Analyst.
• Create Requirements document with mappings in excel by talking to Business stakeholders, BI Developers.
• Create complex SQL’s which involve transformations to be done as part of Business logic to arrive at KPI’s.
• Create JavaScript based Snowflake stored procedures to load data into Data Lake tables and get data ready in snowflake tables which will be used to create outbound files.
• Check the data models in ER Data studio, to understand the models better and to be able to explain to BI Developers and Data Engineers.
• Work very closely with Data Modelers, to come up with Business logic for curated layer objects, UDM Fact and dimension objects.
• Developed Views to implement the logic for creation of facts and dimensions, which will be used in stored procedures to load the curated layer, EDW facts and dimensions.
• Worked with Data Architect, BI Developer to come up with a robust Data model for COVID reporting, which involved creation of dimensions, facts, and data marts.
• Helped on call support team, to resolve some of the complex CCT defects, incidents.
• Trained in clarity data model, which helped to learn some of the major health care terminologies and data points.
• Developed the relationship with requirements/business process partners.
• Grooming the JIRA tickets, creating, updating issues in JIRA.
• Worked on projects: Cipher health, Evolent, Claro, 340B, Medisolv, AJRR, Nthrive, NRC, RX Strategy, Perfect Serve, T3, Strata, Visit Pay, VDH, Xifin, Cactus, NHSN, Outreach, TT synapse (Tele Tracking), Trinetx, Quest, Pressganey, Meti stream (Finance), CSOD (Cornerstone).
• Data Migration of several SQLs for various projects from Netezza into Snowflake.
• Worked as scrum master and Product owner for several projects.
• Worked on Healthy Planet project Claims data for HEDIS, Rosters – Humana, Aetna Aco, Aetna MA, United ACO, NGACO, UHC ACP, VPHP, Anthem, VAPREMIER, MSSP like Attribution, Claim Header, Demographic, Diagnosis, Membership/Eligibility, Medications, Procedures, Service Line, medical claims, lab claims, pharmacy claims and case management data.
• Project management role for covid projects.
• Scrum Master: Extensive experience running and facilitating Sprint Planning, Daily Standups, Backlog Refinements, Sprint Reviews, Sprint Retrospectives, and Sprint Demos
• Experience turning requirements into user stories. Identified and quickly resolved blockers and assessed technical risks.
• Product Owner: Evaluated user enhancement requests, created user stories, maintained the product backlog, and contributed to the product roadmap.
• Data Modeler: Designed and applied changes to logical and physical data models in collaboration with Business Analysts to satisfy the reporting and advanced analytic needs of the business, optimized for reuse of data and interoperability of BI solutions. Participates in Joint Application Design (JAD) sessions.
• Developed and maintained entity relationship models in collaboration with the Business Analyst and Data Engineer’s while adhering to technical solution standards and demonstrated flexibility when required.
• Loaded the data dictionary and business glossary with agreed upon terms, metadata, definitions, descriptions, and related values.
6
• Built and maintained conceptual, physical, and logical data models in ER studio for Dimensions, Facts, Curated layer and custom models for projects at Carilion Clinic.
• Trained in below EPIC EMR EHR courses:
• COG170: Cogito Fundamentals
• CDW110v: Caboodle Data Model Fundamentals
• CLR110: Clarity Data Model Fundamentals
• COG240: Clinical Data Model
• Dedicated to ensuring quality data across Enterprise. Was responsible for building data integrity controls to support critical business processes. As a Lead Business and Data Analyst, worked with multiple business and technology teams across the Enterprise to understand their control needs relative to the Data Integration Standard and support in creating documentation such as Source to Target Mapping documents from several sources, Requirement Specification Documents, Stakeholder Management and Communication. 4. Ascena Retail Group (APR 2014 – JUN 2019)
Project
Description
PROJECT 1:
Ascena RMS Project - RMS/RPM Release 1 and 2
BRANDS: LB and CA
From 2014 to 2015 Dec
Maintenance and Support for Brands LB, CA, Maurices and Dressbarn Post go-live from Jan 2016 – Jun 2019
This project is the first of a three-phased initiative to standardize merchandising processes and technologies across the Ascena brands. Lane Bryant and Catherine’s will be the first brands to deploy the Oracle Retail v13.2 merchandising systems and realign their processes to gain efficiencies as well as apply best practices as employed within Oracle Retail solutions.
The Oracle Retail solutions have been selected as the enterprise solutions for Ascena merchandising capabilities and the following applications were in scope for this implementation.
• Oracle Retail Merchandising System (RMS)
• Oracle Retail Pricing Management (RPM)
• Oracle Retail Integration Bus (RIB)
• Oracle Fusion Middleware
Other applications involved in Oracle Retail Implementation are: CDL (Integration Common Data Layer),Fry(eCommerce Front End), PkMS -Warehouse Management, GXS-Vendor and Transportation Integration-EDI, Audit works-Sales Audit, Lawson-Financial Systems, Aspen-Invoice Matching and Accounts Payable for Domestic Vendors, EDW-Enterprise Data Warehouse-Teradata/Netezza and BI,ADP -HR- Employee, IPPOS - Point of Sale,ORPOS - Point of Sale, RDW-Retail Datawarehouse, Allocation- Merchandise Allocation,E3-ASR -Merchandise Replenishment-Stores,E3-AWR-Merchandise Replenishment-Replenishment Orders, ATG,OMS.
Integration of Purchase orders, Suppliers, and Items from Flex PLM. PROJECT 2:
Oracle Retail applications Integration to Oracle EBS applications APR 2014 to 2015 Dec
Integration between Oracle Retail systems and Oracle E-Business Suite Financials (including Oracle General Ledger and Oracle Payables), as developed and supported by Oracle Application Integration Architecture (AIA). Extracting and Integrating Stock Ledger financial data from RMS (oracle Retail apps) and making it available to Oracle EBS. Supplier Interface, freight terms, currency exchange rates, payment terms and GL – code combinations from EBS to RMS. PROJECT 3:
RMS/RPM functional resource for EComm ATG OMS Fusion middleware implementation project Jan 2016 to Feb 2017
BRANDS: LB and CA
Maintenance and Production support FEB-2017 to JUN -2019 PROJECT 4:
RMS/RPM functional resource for EComm ATG OMS directly from RMS/RPM bypassing middleware Feb2017 to Dec2017
BRANDS: LB and CA
Maintenance and Production support DEC-2017 to JUN -2019 Data transfer from RMS RPM to ATG OMS pertaining to ITEM and Price Feed by skipping Middleware. 7
ATG and OMS will get item feed from RMS, price feed from RPM. RMS/RPM would send a pipe delimited file to the middleware which would do the necessary transformation and deliver the XML to OMS. Built a new conflict checking price engine within RPM separately for EComm (ATG/OMS) and this works differently from ORPOS brick and mortar store interfaces. RPM to ORPOS pricing was left to work as-is with RPM in built pricing engine and integration capabilities.
PROJECT 5:
Reclass hierarchy for Maurices, Dressbarn, CA & LB JAN 2018 to JULY 2018
PROJECT 6:
Implementation of Mark down optimization and Size pack optimization for Maurices, Dressbarn, CA & LB AUG 2017 to OCT 2018
PROJECT 7:
Implementation of JDA Allocations for Maurices, Dressbarn, Justice, CA & LB JULY 2018 to JUN 2019
Data transfer from RMS to JDA. This was done via middleware. Foundation data: items, location, merchandise hierarchy and organization hierarchy, stores etc Purchase orders, receipts, shipments, and Worklist data. Employer
Ascena Retail Group, Columbus, OH
Role Lead Business Analyst / Data Modeler
8
Contribution • Identified and highlighted business issues and risks
• Identified impact of changes to both the business and respective project activities
• Developed the relationship with requirements/business process partners.
• Created Data mapping documents for integration of RMS/RPM to/from systems for all the projects above.
• ETL – Extract Transform and Load data requirements to integrate RPM/RPM for inbound / outbound data.
• Familiar with EDW, RDW database concepts like dimensions, facts, and DataMart’s.
• Background in Oracle BI publisher and OBIEE, to write custom SQLs to send reports to Merchandising Operations, Store teams, Inventory and Financial teams.
• Familiar with relational database and client-server concepts, including ability to use SQL for data analysis, data profiling as needed.
• Closely worked with Oracle through oracle meta link, conducted OWCs, logged SRs, got patches and hot fixes for the products, helped to retrofit the patches to PROD and its regression testing.
• Complex data analysis for PROD data issue / incident resolution and support.
• Reviewed RFC s and approved them prior to implementation or migration in PROD.
• Data Modeling: Built and maintain conceptual, physical and logical data models for Dimensions, Facts, and custom models for projects at Ascena.
• Lead the creation of business requirements document, the business process design activities and ensure the process and solution design meets business requirements.
• Supported and guided the SME/business process owners in key decisions associated with the process and solution design.
• Collaborated with design and technical teams to resolve issues.
• Responsible for communicating team status to project manager and escalating any issues.
• Collaborated with testing/UAT teams in the development of test scripts and expected results.
• Developed functional specifications for application configuration and modifications.
• Ensured that all designs, including configuration, custom/bolt on, and integration do not prevent or complicate future upgrade paths.
• Responsible for initial design and coordinating all phases of testing, including functional, integration, and end-to- end.
• Responsible for approving testing scenarios and results, assigning testing resources and coordinating testing efforts with solution providers.
• Served as a liaison between the business community and the IT organization to deliver technology solutions and facilitate communications for topics including but not limited to negotiated agreements and commitments, business requirements, status updates, workflow engagement, testing efforts, deployments, and post-implementation steady state activities.
• Analyzed and presented business data to support system design, decision making and incident resolution.
• Translated business requirements into functional specifications for the IT organization and managed changes to said specifications.
• Articulated complex technical topics for non-technical audiences.
• At ease in working with customers, partners, and suppliers at all levels within the business.
• Worked with relational databases, used SQL for data analysis.
• Subject matter expert on Oracle’s Retail Merchandising Suite (RMS) and Retail Pricing Management (RPM). Knowledgeable in Oracle Retail Integration Bus (RIB), Oracle Retail Datawarehouse (RDW) and Oracle Retail Point of Service (ORPOS) beneficial.
• Worked on SDLC and deliverables associated with each phase. 5. Rent-A-Center, Plano TX - Oracle Retail –WMS Red Prairie - Business Analyst - Aug 2012 till FEB 2013 Project
Description
• Worked with a business solutions team that supports Oracle RMS. Project was to integrate Red Prairie WMS to a new distribution model in Mexico having ORMS etc. Transfers, Inventory adjustments, RTVs, Purchase orders, Stock ledger are the modules. This will include: New integration with RP WMS, as well as consideration to existing interfaces with:
• RAC point-of-sale system (both SIMS and High Touch)
• Lawson financial system
• Master Data Management (MDM) system and
• Data warehouse
Employer
Rent-A-Center, Plano, TX
9
6. Academy Sports and Outdoors - Oracle Retail Implementation-NEXUS RMS project: Jan – Mar 2012 Project
Description
The NEXUS RMS project is one part of the larger NEXUS Program whose goals are to support aggressive short term and long-term corporate growth strategies by:
• Increasing the stability, maintainability, and scalability of the systems supporting our core business processes
• Effectively adapting,
Contact this candidate