RAJAN PATEL

• Played a pivotal role as a key member of the data analytics and reporting team, collaborating closely with various analytics managers and product managers to address their data analysis and business intelligence requirements.
• Demonstrated proficiency in SQL databases and data warehousing, with a track record of formulating database queries and creating stored procedures.
• Designed complex Tableau dashboards catering to diverse business verticals, enabling product managers to track historical product performance and analyze critical metrics such as volume, revenue, cost, margins, conversion rates, marketing channel performance, and lender performance.
• Successfully executed SQL database tasks involving the creation of complex queries, stored procedure, and MySQL events to meet organizational data needs.
• Utilized Python scripting for the development of ETL jobs and automation tasks, including handling flat files, data related alerts via mail and Slack.

• Collaborated with stakeholders to understand and document data analysis requirements.
• Transformed complex Oracle queries into MS SQL for cloud migration.
• Formulated SQL queries to extract project-specific insights.
• Designed and implemented organization-specific data models.
• Implemented database admin and access policies.
• Developed Power BI reports and dashboards, querying relational databases for insights.
• Managed Power BI online infrastructure, including workspace, report publishing, and dataset scheduling.

• Collaborated cross-functionally to gather and document data analysis requirements.
• Assisted the data engineering team in selecting and implementing suitable database infrastructure.
• Designed and tested new data models for accuracy.
• Formulated SQL queries and conducted data mining for project-specific insights.
• Extracted data from databases to create interactive reports and dashboards.
• Conducted ongoing reviews of internal IT systems to identify potential data analytics opportunities.

• Collaborated cross-functionally to gather and document data analysis requirements. Assisted the data engineering team in selecting and implementing suitable database infrastructure

• Designed and tested new data models for accuracy

• Formulated SQL queries and conducted data mining for project-specific insights

• Extracted data from databases to create interactive reports and dashboards

• Conducted ongoing reviews of internal IT systems to identify potential data analytics opportunities