Janaki Raman K

• Designed and maintained high-volume production ETL/ELT workflows on the Databricks Lakehouse platform, ensuring data reliability and performance.
• Implemented the Medallion Architecture using Python/PySpark and orchestrated pipelines using Databricks Workflows with Delta Lake versioning.
• Developed comprehensive business intelligence solutions on Domo, utilizing Magic ETL and Beast Mode to deliver actionable insights from the Databricks Silver Layer.
• Consultant for building reports and dashboards in Tableau, Salesforce and Einstein Analytics Studio.
• Build POC for customer demos on BI/AI tools showcasing my knowledge in Tableau and Power BI, Salesforce Einstein AI Capabilities, and Google Cloud Platform.
• Built an Opportunity Prediction Model using Salesforce Einstein Prediction and Google Cloud Platform for customer demos.
• Good understanding of Salesforce Sales Cloud, FinancialForce PSA BPMs and Architecture.
• Consultant for customer engagements involving reports and dashboards building in Salesforce and Einstein Analytics Studio.
• Thorough understanding of Power BI Data modeling, DAX calculations, Power Query, report creation, and dashboard design.
• Built a PoC for customer demo using Tableau by presenting a dashboard using variety of chart types, customizations, and actions to create visually appealing and informative dashboards that effectively communicate key findings.
• Built dashboards to show my Advanced visualization techniques, storytelling with data, and interactive dashboards.
• Preparing the Documentation for the Mappings according to the Business Requirements.

Client - Sol de Janeiro

• Served as a Data Engineer, primarily focusing on maintaining a critical data platform to ensure high data availability for downstream teams.
• Ensured all production ETL/ELT workflows ran flawlessly and on schedule, providing high data availability for downstream teams.
• Owned the entire data ingestion pipeline, utilizing Python and PySpark to fetch high-volume transactional data from key e-commerce and ERP systems (Shopify, NetSuite, Amazon FBA) via their respective APIs.
• Defined and built the Medallion Architecture within Databricks.
• Bronze Layer: Created raw, immutable tables to store source data (JSON/XML) for auditability.
• Silver Layer: Developed transformation scripts to clean, normalize, and deduplicate data, ensuring schema enforcement and business-ready data quality.
• Orchestrated all scripts and notebooks using Databricks Workflows, implementing logging and Delta Lake versioning to ensure data integrity and provide immediate alerts on any pipeline errors.
• Utilized Domo as the primary visualization platform, establishing secure Datasets to fetch clean data directly from the Databricks Silver layer.
• Performed further data transformations within Domo, including using Magic ETL for blending and joining data, and Beast Mode for creating context-specific calculated fields for real-time dashboard metrics.
• Designed and published diverse visualization types (Pivot Tables, Donut Charts, KPIs, Line/Bar Graphs) to build interactive dashboards focused on key performance indicators (KPIs).
• Consistently collaborated with stakeholders to iterate on dashboard design and functionality, ensuring the final output delivered actionable insights for strategic business decisions.

Client - BMS CAT

• Built data warehouse using AWS Redshift. Developed data ingestion with Glue, Storage in S3 and RDS databases.
• Worked as a Tableau Developer and created 15+ Dashboards for this company.
• Demonstrated proficiency in analyzing and visualizing complex data sets across various domains, including sales, finance, and operations.
• Leveraged Tableau's data preparation, cleaning, and blending capabilities to ensure data accuracy and derive meaningful insights.
• Expertly utilized Tableau's features to create clear, informative, and visually appealing dashboards that effectively communicate insights.
• Implemented interactive elements like filters, action features, drill-down capabilities, and tooltips to enable users to explore data dynamically.
• Employed advanced Tableau features such as LOD expressions, table calculations, parameters, and sets to perform sophisticated data analysis and create customized visualizations.
• Applied a solid understanding of business concepts and metrics to create dashboards that aligned with organizational goals and priorities.
• Developed Dashboards showcasing their Revenue and Growth per region using Tableau.
• Using drill down effect developed Dashboards to visualize the Growth% to Goal from region up to 2 levels and implemented the various visualizations to go over their Job counts for individuals present in Sales Team.
• Designed and managed diverse Tableau dashboards such as the Top Tenant Report, Revenue Breakdown, Year-to-Date Job Leads, GP% to Goal, Job Breakdown, and Branch Rankings, among others.
• Developed visualizations to monitor critical business metrics, including Annual Recurring Revenue (ARR), tenant distribution, gross profit, and job performance, segmented by various factors like tenant type, industry, region, and job status.
• Built tools to analyze financial performance over time, featuring 13-month trailing revenue reports and month-end closeout summaries, providing thorough budget and cost evaluations.
• Implemented dashboards to assess branch-level and team performance, facilitating targeted performance reviews and achievement tracking.
• Produced actionable insights through data-driven visualizations, aiding in the optimization of strategies for revenue growth, customer retention, and lead generation.
• Demonstrated proficiency in using Python, APIs, and AWS services (S3, Redshift) to build scalable and efficient data pipelines for data extraction, transformation, and loading (ETL).
• Developed automated data ingestion processes using Python scripts and APIs, ensuring data freshness and reducing manual effort.
• Implemented a Redshift data warehouse for centralized data storage and analysis, enabling efficient reporting and querying.

Client - Nuvolo

• Developed and implemented management reporting in fields like marketing, finance, and budgeting.
• New Out of the Box reports and dashboards were developed in response to client requests and under the guidance of an on-site solution architect and client project manager.
• Successfully modified existing Out of the Box reports and deployed personalized dashboards using Einstein Analytics to provide actionable insights for this project.
• Create new workflows and recipes for custom reports and dashboards.
• Update out of the box Einstein Analytics reports and dashboards.
• Effectively utilized Einstein Analytics' geographic visualization capabilities to map customer distribution, analyze revenue trends by location, and identify key markets.
• Create interactive and engaging dashboards with filters, actions, tooltips, and storytelling capabilities.
• Conducted comprehensive business analytics to identify and track critical KPIs, such as customer distribution and revenue reports, driving data-driven decision-making.

Internal Project:- Opportunity Prediction Model

• Built a working model using Einstein Prediction Builder for prediction of the successful closure of the current Opportunity in out Salesforce Pipeline
• Handled the Data Extraction, Modelling and Data Upload through spreadsheet for Einstein Prediction Builder.
• Built similar model on different platforms such as Microsoft Azure and Google Analytics for further analysis of the existing model and search of any improvement.

Client - NEC

• Developed a POC using Power BI to create a few dashboards for project management, scheduling, and time sheet insights, reducing manual reporting efforts by 30%.
• Integrated data from multiple sources and developed a Data Model in Power BI and automated data refresh schedules and implemented real-time data updates, improving the timeliness and accuracy of reports.

Client - QTS

• Worked as a Tableau developer for creating Dashboards.
• Leveraged Tableau's data preparation, cleaning, and blending capabilities to ensure data accuracy and derive meaningful insights.
• Employed a wide range of Tableau features to create a robust and interactive dashboard, effectively visualizing complex data sets.
• Utilized a variety of chart types, customizations, and actions to create visually appealing and informative dashboards that effectively communicate key findings.
• Implemented filters, actions, and tooltips to enable users to explore data dynamically and gain deeper insights.
• Utilized Tableau's Features such as calculated fields, parameters, analytics, and drill-down capabilities to provide interactive and insightful analysis.
• Leveraged Tableau's data cleaning and preparation features to effectively handle missing values, outliers, and inconsistencies, ensuring data accuracy and reliability for analysis.
• Expertise in selecting appropriate chart types (e.g., bar charts, line charts, scatter plots, maps) to effectively communicate insights.
• Created a comprehensive dashboard using Tableau to analyze and visualize key performance indicators (KPIs) for top tenants.
• Effectively communicated data-driven insights to stakeholders through clear and concise visualizations and implemented techniques to optimize dashboard performance, ensuring efficient data retrieval and rendering.
• Carefully designed dashboards to enhance user experience and facilitate easy navigation and utilized storytelling techniques to guide users through the dashboard and highlight key takeaways.

Internal Project:- Global CRM

• Worked as a developer for data transfer
• Demonstrated proficiency in executing ETL processes for data migration between Salesforce instances.
• Handled various stages of the ETL process, including data extraction, modeling, uploading, and validation.
• Effectively utilized Excel's features to perform ETL tasks, demonstrating proficiency in data manipulation and analysis. Employed Excel functions and formulas to clean, transform, and prepare data for migration.
• Successfully oversaw data migration projects for multiple sister companies, ensuring timely and accurate data transfer.
• Conducted thorough data testing to validate data accuracy and integrity following migration.

Client - Gerdau

• Developed 10 dashboards for the company varying from Finance, Operations, Opportunity, Storage/Warehouse In stock and Sales in Power BI.
• Designed and maintained Power BI dashboards for Finance and Operations, leading to a 20% improvement in tracking accuracy.
• Worked as a Data Engineer which involves cleaning up the data available in PostgreSQL Database.
• Developed complex DAX formulas to create custom metrics and KPIs, enhancing the reporting capabilities for management.
• Integrated data from multiple sources, including SQL databases and cloud services, to provide a unified view of business performance in PostgreSQL Database.
• Collaborated with stakeholders to gather requirements and translate them into scalable Power BI solutions.
• Implemented data security and governance practices within Power BI to ensure compliance with company policies.
• Provided training and support to team members, enabling them to utilize Power BI for their reporting needs.

Client - Lineage Logistics

• Demonstrated proficiency in using Einstein Analytics' Dataflow feature to effectively extract, transform, and load (ETL) data from various sources into the Salesforce environment.
• Created custom recipes to cleanse, standardize, and enrich data, ensuring data quality and accuracy for analysis.
• Leveraged Einstein Analytics' dashboarding capabilities to create visually appealing and interactive dashboards that provided valuable insights into the data cloud.
• Utilized Einstein Analytics' visualization tools to create charts, graphs, and maps that effectively communicate complex data relationships and trends.
• Applied my understanding of business intelligence concepts to develop dashboards that addressed specific business questions and supported data-driven decision-making.

Client - Enterprise Products

• Collaborated with the EBS Team to identify and plan the migration sequence for objects during the initial migration phase.
• Customized workflows in the Source Qualifier to convert old schemas into new schemas, ensuring the object sequence remains intact.
• Developed essential mappings and workflows to facilitate efficient data processing and migration.
• Utilized XML to identify old references that were part of new references, replacing them with updated schemas.
• Achieved a significant reduction in working time, completing the necessary changes within the estimated project timeline.

Client - Omnitracs

• Worked as a ETL Consultant, to establish design documents and mapping sequences.
• Demonstrated proficiency in using Informatica to design, develop, and execute ETL processes for data migration.
• Designed and developed ETL mappings, connecting source and target systems and defining transformation logic.
• Created and managed workflows that orchestrate the execution of multiple mappings and other ETL tasks, ensuring data flows smoothly between systems.
• Conducted thorough data analysis to identify data quality issues, inconsistencies, and required transformations.
• Created comprehensive design documents and mapping sequences to guide the ETL process.
• Designed and developed complicated mappings and workflows as per the requirement.
• Designed and developed complex mappings and workflows to transform data according to specific requirements.
• Tailored mappings and mapplets to meet the unique needs of the client, ensuring data accuracy and consistency.
• Developed migration sequences for various objects, including master data objects like Customer, Campaign, Address, Opportunity, Leads, and Campaigns.

Client - TokenEx

• Create new data sets and dashboard recipes for personalized reports.
• Successfully created and deployed 10+ personalized dashboards using Einstein Analytics to provide actionable insights for this project.
• Effectively utilized Einstein Analytics' geographic visualization capabilities to map customer distribution, analyze revenue trends by location, and identify key markets.
• Create interactive and engaging dashboards with filters, actions, tooltips, and storytelling capabilities.
• Conducted comprehensive business analytics to identify and track critical KPIs, such as customer distribution and revenue reports, driving data-driven decision-making.
• Performed business analytics and discovered KPIs, such as customer distribution and revenue reports.
• Combine multiple visualizations into a single dashboard for comprehensive analysis and create stories to guide users through a series of dashboards and visualizations.

Project:- Feasibility Analysis of Data Storage in Cassandra Database

• Established a seamless connection between Cassandra and Jupyter Notebook to enable interactive data exploration and analysis.
• Developed DDL (Data Definition Language) scripts to define the schema of Cassandra tables and migrated data using Python code, ensuring data compatibility and integrity.
• Demonstrated strong proficiency in Python programming for data migration, pre-processing, and visualization tasks.
• Effectively utilized Cassandra as a scalable and distributed database for storing and managing large datasets.
• Successfully migrated data from various source files to Cassandra using Python scripts, ensuring data integrity and accuracy.
• Employed Python libraries and techniques to clean, transform, and prepare data for analysis, addressing issues like missing values, outliers, and inconsistencies.
• Conducted thorough feasibility studies to assess the suitability of Cassandra for data storage and migration, considering factors like scalability, performance, and cost-effectiveness.

Project:- Automatic Text Summarization of Article (NEWS) Using Lexical Chains and Wordnet

• Developed an automated text summarization system that can efficiently process large volumes of text data and generate concise summaries.
• Improved Efficiency: Reduced the time and effort required for manual summarization, enabling faster information consumption and analysis.
• Demonstrated proficiency in NLP techniques, particularly lexical chains and Wordnet, for text summarization.
• Effectively preprocessed text data, including tasks like tokenization, stemming, and stop word removal, to prepare it for analysis.
• Created and trained models to identify lexical chains and Wordnet relationships within text data, enabling accurate summarization.
• Developed a model capable of generating human-readable summaries by selecting and combining key sentences based on lexical chains and semantic relationships.