Aruna Ravada
Email: ad2xzd@r.postjobfree.com
Phone: 856-***-****
PROFESSIONAL SUMMARY
Overall 6+ Years of experience as Data Analyst
Enterprise SAP Master Data Analyst primarily responsible for Data Maintenance, Data Governance, Data Stewardship, Data Standards, Data Readiness and Data quality
A highly motivated data analyst with a proven track record of delivering complex, technology-enabled business transformation initiatives. managing and delivering large scale business transformations that need analytical data support.
Involve in multiple global data transformation engagements in the United States, EMEA, Latin America and Asia
Involve in establish business process, reporting analytical solutions in Procurement, Sales, Finance, Supply Chain
Worked for Hospital & Healthcare, Consumer goods, Pharmaceutical and Retail Industries.
Involved in E2E data mapping session with POs, SMEs, Data Stewards, Process Teams, and Conversion Teams
Knowledge in Data Analytics and Data Engineering using SQL & Python
Experienced in complete Software Development Life Cycle and major aspects of technological projects including Requirement Analysis, Design, Development, Database Design, Deployment, Testing, Debugging, and Application Maintenance
Knowledge in SQLite
Knowledge of Data Mining tools like Python, SQL, API, JSON
Strong working knowledge of Python, SQL, API, Json Excel, and Jupyter
Knowledge in providing qualitative & quantitative assessment of data
Knowledge in data scaling, wrangling, and data visualization in Python, SQL, API, Json
Knowledge on Python (NumPy, Pandas, Matplotlib, Json)
Knowledge in using of Python scripts to parse JSON reports and load the information in database
Knowledge in executing the test scenarios, test plans, providing test data, creating test cases, Issuing STR’s upon identification of bugs and collecting the test metrics.
Knowledge with WATERFALL and AGILE methodologies
Good communication and interpersonal skills and analytical skills
Highly motivated team player with the ability to work independently.
Ability to learn new technologies and avid knowledge hunter with good communication skills, hardworking and a good team worker.
EDUCATION
BSc Computers Science, Vinayaka Missions University, Salam Tamil Naidu, India
VISA STATUS
H4 EAD
TOOLS AND TECHNOLOGIES
Languages
Python, SQL, C, C++, HTML
Statistical Analysis
Python (NumPy, Pandas, Matplotlib, Json, SQL, SQLite, API, Json, Excel & Power BI
Tools and Utilities
SAP, S4 HANA Python, SQL, SQLite, API, Json, MS Office Tools, Jira, Confluence, Power BI
PROFESSIONAL EXPERIENCE
Client: JnJ Jan 2023- Aug 2023
Role: SAP Master Data Analyst
Responsibilities:
Perform maintenance and support of SAP Master Data Objects – Material, Customer and Vendor
Perform SAP Production master data (i.e. BoM's and recipes) creation and maintenance activities.
Perform SAP Quality master data creation and maintenance activities.
Troubleshoot master data issues for base business support.
Support Data Stewards to define Data Governance for global master data objects.
Performing Pre-load and Post-Load Master Data Validations
Collaborated with cross-functional teams to provide master data analysis for business decision-making.
Created master data reports and forecasts using data analysis tools such as Excel,SQL and Python providing valuable insights to senior management
Provided expertise and support to finance data migration projects, collaborating with cross-functional teams to successfully migrate financial data from legacy systems to SAP.
Utilized Jira project management tool to track tasks, document issues, and collaborate with cross-functional teams, improving the efficiency and transparency of project workflows.
Client: JnJ
Aug 2022– Jan 2023
Role: Finance Data Analyst
Responsibilities:
Azure Data Lake
Generated detailed studies on potential third-party handling solutions, verifying compliance with internal needs and stakeholder requirements.
Analyzed financial data to support strategic decision-making and financial planning and loading data in different environments.
Managed financial data using SAP's FICO module, ensuring the accuracy and completeness of financial records.
Managed financial data security and access controls within SAP, ensuring the confidentiality and integrity of financial data.
Maintained and updated financial records and reports, ensuring compliance with relevant regulations and standards.
Conducted ad-hoc financial analysis and provided recommendations for improvements.
Collaborated on ETL (Extract,Transform,Load) tasks maintaing data integrity and verfying pipeline stability.
Designed and implementeted effective database solutions to store and retrieve data.
Communicating with teams for new or updates of data.
Develepode database arhitectural strategies at modeling, design and implementing stages to address business.
Designed compliance frameworks for multi-site data warehousing efforts to verify conformity with restaurant supply chain and data security guidelines.
Working with data Warehouse and seperate the data into fact and deimention tables.
Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
created python, SQL database structured in clusters, helps Store raw data and send from streaming analytics
PMO:
Coordination of project manager / team leader.
Resource allocation and conflict resolution.
Maintenance and planning skills.
Collaborating with department leaders and project sponsors to define and develop projects.
Establishing project plans, including deadlines and priorities.
Good level capability with Access, python, SQL and Tableau
Strong analytical, problem-solving, conceptual skills, task prioritization, follow-up, tenacity, creativity and customer service skills
Ability to communicate effectively across written, verbal and presentation formats to a variety of audiences
Ability to multi-task, work independently, and stay focused in a dynamic fast paced environment
Proficient in Microsoft Office (Excel, Access, Word, Visio, and PowerPoint)
Intermediate level capability with Powerpoint, Word,Excel.
Intermediate level capability in statistical data analysis, metric trending and data reporting
Client: Amazon
Dec 2020 – Aug 2022
Role: Amazon Associate
Responsibilities:
Working as a Amazon Associate in Problem Solver, Problem Analytics, Quality Analytics & Data Statics to translate product requirements into comprehensive, complete and accurate business requirements
Partnered with a Product Manager to enable discussion -making on issues related to warehouse and supply chain
Created a meaningful analysis by collecting, analyzing, managing quantitative data that lead to business improvement, cost reductions and compliant
Collaborate with all support teams including Safety, Engineering, Loss Prevention, Quality Assurance, Human Resources to develop plans to meet business objectives.
Responsible for running Daily, Weekly, Monthly reports using SQL Tools
Review and analyses matrix to access performance and accurately allocate loads
Worked with the warehouse team and analyzed data using SQL tools to generate reports, tables, listings and graphs.
Troubleshoot various errors which occur during the inbound and outbound process
Utilizing computer tools for various applications
Matching physical and virtual numbers
Support, mentor, and motivate co-worker at workforce.
Quality Assurance
Played role of leaning Ambassador for new hires
Client: ASM Technology
05/2016 – 09/2017
Role: Developer
Web/Application Developer and coding with analytical programming using Python and SQL
Experienced in complete Software Development Life Cycle and major aspects of technological projects including Requirement Analysis, Design, Development, Database Design, Deployment, Testing, Debugging, and Application Maintenance
Designed and developed horizontally scalable APIs using Python
Design and manage API system deployment using a fast http server and Amazon AWS architecture.
Developed and tested many features for the user interface using Python, Bootstrap, CSS, and JavaScript
Developed real-time multi-tasking systems using Python.
Designed a Python script to load transformed data into cloud services (AWS &Azure)
Worked with Python for data analysis and visualization purposes to get a better understanding about the data.
Client: Narayan e-Techno School
08/2014 – 04/2016
Role: Science Teacher
Responsibilities:
Plan study programs to meet students’ needs, interests, and abilities.
Design curriculum as per the needs of the students.
Evaluate and assess students’ progress on a periodic basis.
Monitor individual student progress.
Take corrective measures to enhance student learning abilities.
Prepare student progress reports.
Instruct students on proper use of equipment, materials, aids and textbooks.
Set and monitor standards of student behavior.
Assist staff members in assessing students’ attitude, learning problems.
Advice parents on students’ progress and development.
Organize class time as per the instructional plans.
Maintain inventory of instructional materials, aids and equipment.
Coordinate and support teaching aides and assistants in their tasks.
Ensure compliance of teaching objectives to state law, administrative regulations and procedures.