Pravallika Kunala Email & Phone Number

United States

Project Description: Requirements to remediate several deficiencies cited by supervisory authorities about its data ecosystem, specifically reconciliation, including both financial reconciliation to the General Ledger, reconciliations to ensure comprehensiveness of static and references data between the source and Aggregation Layer and data transfer validation or reconciliations for non-financial systems. The General Ledger (GL) data will be on boarded to enterprise data platform through the normal data onboarding process, however only results data will be sent that has already undergone GL reconciliation internally in each entity and the result amounts will not be changed throughout the processingResponsibilities• Analyzing reporting requirements and developing various Dashboards, using trend lines and reference lines• Worked with different types of Data sources and performed extensive Data Analysis to identify latest business trends, patterns, and anomalies.• Created no. of views, calculated tables, calculated columns, and measures.• Used Tableau to develop data analysis prototype and visualize reports.• Generated context filters and data source filters while handling a large volume of data.• Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, and single-number cards.• Used various sources to pull data into Tableau such as SQL Server, Oracle, SQL Azure, etc.• Created many complex Query's and used them in Tableau directly to generate reports on the fly.• Created different data visualizations using Lines, Pies, Histograms, Maps, Scatter, Bullets using Tableau.• Adheres to department, organization and industry guidelines, standards, policies, and procedures.• Worked with Deployment pipeline, Row level security, Parameterization, and Server management.• Good knowledge of data warehouse and ETL (Extraction, Transformation, and Loading) concepts.

India

Project Description: This project is targeted to provide analytical reporting solutions for the marketing and sales modules for dairy Industry. The project includes all the functionality of dairy from procurement to invoice and stock maintenance and needs to provide all types of reporting solutions from Oracle data Warehouse.Responsibilities:• Understand the ETL specifications and build the ETL applications like mappings in SQL.• Involved in Data Analysis of source data and resolved data quality issues.• Created the SQL scripts as per requirement of business to implement the logic.• Performed the unit testing and data validation on the target tables.

United States

Project Description: This Project goal is to provide overall company’s supply chain timely delivery and tracking on budget with forecasts. Also involves data analysis related to procurement, logistics and IT departments to enhance service delivery.Responsibilities:• Worked closely as a team player to develop and design data analysis reports as per project requirement.• Develop and implement data management monthly/quarterly reports and quality check procedures on reports to support them.• Analyze pharmaceutical datasets to identify patterns, trends, and insights that drive decision-making.• Ensure accuracy of data reports by implementing delivery rigorous validation and quality control processes.• Assist in the design and development of data systems and processes.• Deliver regular reports in Tableau on data trends and changes.• Mapped current business and operational processes and recommended areas for improvement.

United States

Project Description: This project supports company’s product validations through analyzing the accuracy of the Product information and forwarding the correct information to the respective department. The products were qualified to be sent to the client’s locations. It resulted in the company’s growth to acquire more products and expand locations within the company’s site.Responsibilities:• Collaborated closely with cross-functional teams to understand business objectives and identify analytical requirements.• Developed SQL scripts based on the report requirements and maintained business dashboards.• Performed data extraction, transformation, and loading (ETL) processes.• Conducted thorough data analysis to derive actionable insights and recommendations.• Presented findings to stakeholders through clear and compelling visualizations and reports.• Continuously learn and stay updated with industry trends and best practices in data analysis.• Wrote and optimized diverse SQL queries, working knowledge of RDBMS like Oracle.