Pratheek Sivakuri Email & Phone Number

Johnston, Rhode Island, United States

• Developed complex database programs like SQL triggers and stored procedures for implementing the business rules• Diagnosed and resolved SQL query issues and database performance problems, minimizing downtime and improving system reliability• Implemented SQL-based checks and validations to ensure high data quality and consistency across various datasets.• Leveraged SQL to extract data for use in data visualization tools (e.g., Tableau, Power BI), enhancing data presentation and decision-making capabilities.• Worked closely with cross-functional teams to gather requirements and document Python scripts and data analysis processes for transparency and future reference.• Utilized Python to interact with various APIs for data retrieval and integration, enabling real-time data access and analysis from external sources.• Designed and developed interactive Power BI dashboards and reports to visualize complex data, enabling stakeholders to gain actionable insights and make data-driven decisions.• Utilized SQL to perform data validation and cleansing, identifying and correcting discrepancies to enhance data quality.• Developed complex database programs like SQL triggers and stored procedures for implementing the business rules.• Generated comprehensive SQL-based reports and dashboards, providing key metrics and trends to stakeholders.• Conducted ad-hoc data analysis using SQL to support business decisions and generate actionable insights for various departments• Used Python for determining the important variables, factors, cleaning and preprocessing the data.• Developed interactive dashboards and reports in Power BI, providing real-time insights and visualizations that improved decision-making for business stakeholders.

Hyderabad, Telangana, India

● Devised complex SQL queries for generating weekly, monthly, and termly reports and automated them by scheduling SQL SSMS jobs.● Conducted Business requirement gathering sessions and architected client-specific requirements in A Snowflake based environment.● Constructed and designed Power-bi and Tableau dashboards to visually manifest business data.● Analyzed client’s business requirements and processes through document analysis, interviews, and workflow analysis.● Utilized mathematical modeling to identify trends and patterns, for proactive decision-making.● Built and deployed a classification model to predict if the vendor data is accurate using python.● Used Analytical skills to synthesize information from various sources for decision making.● Developed complex database programs like SQL triggers and stored procedures for implementing the business rules.● Showed in-depth knowledge of project lifecycles to help teams to ensure resource allocation and timely project delivery.● Worked with the team and synthesized client business Intelligence data to produce reports , tableau dashboards, polished presentations, highlighting findings, and recommending changes within the processes● Engaged with the business owners to analyze current operational business procedures, trends, and requirements.● Performed synchronous and real time validations of data objects (URLs, Email address, IP address, using python.● Conducted interviews and with the key business users to collect information on the user requests; Drafted quarterly.and yearly reports on client’s financial metrics to access successes and account for deficiencies.● Developed time series and trend analysis models in R language to depict the sales patterns to improve sales by 25%● Formulated strategic quantitative analysis for client delivery and conducted weekly client facing meetings.● Used Python for determining the important variables, factors, cleaning and preprocessing the data.