Rajaneesh Pillai Email & Phone Number

Murray, Utah, United States

Draper, Utah, United States

As the Senior BI Engineer I played a pivotal role in transforming the analytics landscape for the Product department through the successful migration of Quicksight and Looker dashboards to Tableau. This involved meticulous planning and execution, ensuring a seamless transition that not only improved data visualization capabilities but also resulted in significant cost reductions.In addition to this, I led the implementation of the Acryl data catalog tool for the Business Intelligence… Show more As the Senior BI Engineer I played a pivotal role in transforming the analytics landscape for the Product department through the successful migration of Quicksight and Looker dashboards to Tableau. This involved meticulous planning and execution, ensuring a seamless transition that not only improved data visualization capabilities but also resulted in significant cost reductions.In addition to this, I led the implementation of the Acryl data catalog tool for the Business Intelligence department, overseeing the migration of CRM data from multiple instances of Salesforce to a unified instance. I took a proactive approach by creating new data models, addressing issues with existing dashboards, and ensuring a smooth and efficient data retrieval process.Leveraging my expertise in data modeling and transformation using dbt, I optimized data models in Snowflake and AWS Redshift, significantly enhancing the performance and accuracy of the dashboards. My strong SQL querying skills were instrumental in extracting and transforming data from diverse sources, facilitating the integration of valuable datasets into the analytics environment.Furthermore, I designed and implemented a robust data source for Tableau catalog, utilizing Python, GraphQL, and REST API technologies. In the realm of data security, I successfully designed and implemented data access policies for PII data accessed through Tableau, defining specific roles within Snowflake based on user permissions and data sensitivity levels.Throughout this period, I proactively identified and resolved connection issues between Tableau and the Starburst (Presto) data source.Maintaining a vigilant stance, I proactively monitored data queries and performance metrics, detecting potential issues or anomalies and promptly taking corrective actions to mitigate risks. This comprehensive approach ensured a robust and reliable analytics environment, fostering data-driven decision-making within the organization. Show less

Salt Lake City, Utah

In my role as the Lead BI Engineer at CaptionCall, I achieved significant milestones and contributed to the organization's success in various capacities:Spearheaded a successful Proof of Concept (POC) and subsequent deployment of a new visualization platform for self-serve analytics. This initiative resulted in substantial savings in annual costs on licenses, showcasing my ability to drive cost-effective solutions while enhancing analytical capabilities.Collaborated closely with… Show more In my role as the Lead BI Engineer at CaptionCall, I achieved significant milestones and contributed to the organization's success in various capacities:Spearheaded a successful Proof of Concept (POC) and subsequent deployment of a new visualization platform for self-serve analytics. This initiative resulted in substantial savings in annual costs on licenses, showcasing my ability to drive cost-effective solutions while enhancing analytical capabilities.Collaborated closely with data scientists to comprehend their specific data requirements and objectives for building sophisticated data science models. As part of this collaboration, I engineered wide data tables that encompassed a comprehensive range of relevant features and variables, facilitating the creation of robust and insightful data models.Led cross-functional collaboration with multiple departments to plan and execute the rebuilding of the data architecture for migrating a legacy Customer Relationship Management (CRM) system to Microsoft Dynamics. This involved strategic planning, coordination, and execution to ensure a seamless transition with improved functionality and efficiency.Conducted thorough data cleansing, validation, and enrichment processes to ensure the accuracy and integrity of data during and after the migration. This meticulous attention to data quality contributed to a smooth transition and laid the foundation for reliable and trustworthy data-driven insights.Played a pivotal role in mentoring BI Engineers, imparting knowledge and helping them grasp better data modeling concepts. This commitment to knowledge sharing and skill development reflects my dedication to fostering a collaborative and high-performing team.These responsibilities collectively highlight my leadership, strategic planning, technical expertise, and commitment to driving value through data-driven initiatives at CaptionCall. Show less

Salt Lake City Metropolitan Area

In my role as a BI Engineer at CaptionCall, I played a key role in enhancing data operations, analysis, and reporting processes:Developed and implemented stored procedures to efficiently load data from multiple tables into one, optimizing analytical operations. This initiative streamlined data processing and improved the efficiency of analytics workflows.Built SSIS (SQL Server Integration Services) packages to bring in data from diverse sources, consolidating information for… Show more In my role as a BI Engineer at CaptionCall, I played a key role in enhancing data operations, analysis, and reporting processes:Developed and implemented stored procedures to efficiently load data from multiple tables into one, optimizing analytical operations. This initiative streamlined data processing and improved the efficiency of analytics workflows.Built SSIS (SQL Server Integration Services) packages to bring in data from diverse sources, consolidating information for reporting purposes. This approach facilitated a unified and comprehensive view of data, contributing to more accurate and insightful reporting.Conducted in-depth analysis of expense reports, performing a detailed examination to identify and rectify duplicate expenses. Through this analysis, I successfully implemented exception reports, resulting in monthly savings by preventing redundant expenses.Enhanced the security and re-usability of existing SSRS (SQL Server Reporting Services) reports by converting data sets of text queries into stored procedures. Additionally, I applied row-level security measures to ensure controlled access, contributing to improved data governance.Developed SQL Server jobs to automate the distribution of data-driven emails to the 350-member sales team. This automation not only saved time but also ensured timely and consistent communication, contributing to enhanced sales team efficiency.These responsibilities showcase my proficiency in data management, analysis, and reporting, as well as my commitment to optimizing processes for efficiency, accuracy, and cost savings. Show less

In my capacity as a BI Engineer, I actively contributed to the success of data-driven initiatives by undertaking the following responsibilities:Collaborated closely with stakeholders to gather comprehensive functional requirements, documenting key specifications and building detailed models for analytics. This involved a thorough understanding of business needs and objectives to ensure the development of effective data solutions.Created and implemented stored procedures, tables,… Show more In my capacity as a BI Engineer, I actively contributed to the success of data-driven initiatives by undertaking the following responsibilities:Collaborated closely with stakeholders to gather comprehensive functional requirements, documenting key specifications and building detailed models for analytics. This involved a thorough understanding of business needs and objectives to ensure the development of effective data solutions.Created and implemented stored procedures, tables, and databases using SQL Server Management Studio (SSMS) to establish a secure and scalable foundation for reporting. This ensured that data integrity and accessibility were prioritized, leading to reliable and efficient reporting processes.Engineered an OLAP Cube using SQL Server Analysis Services (SSAS) to provide real-time data for analytics. This cube served as a dynamic and interactive platform, enabling users to analyze multidimensional data swiftly and efficiently.Developed Universes using SAP Business Objects, contributing to the creation of reports in web intelligence and crystal reports. This involved designing a semantic layer that simplified data access and interpretation, fostering a user-friendly reporting environment.These responsibilities highlight my proficiency in collaborating with stakeholders, designing secure and scalable reporting structures, utilizing OLAP technology for real-time analytics, and leveraging tools like SAP Business Objects to enhance the reporting capabilities of the organization. Show less

Greater Chicago Area

Master'S Degree, Computer Science

Bachelor Of Technology (B.Tech.), Computer Science