Sashi R Email & Phone Number

Cary, Nc, Us

Apex, North Carolina, United States

Implemented dimensional modeling techniques such as star schema and snowflake schema to design efficient and scalable data models.Developed Integration process using Rest API’s in MuleSoft to extract the data from custom application, store it into a stage are and then transform it according to business rules, and load it into the data warehouse using ODI.Collaborated with business analysts and stakeholders to understand reporting data and translate them into technical specifications for data warehouse development.Implemented data quality checks and validation processes to ensure accuracy and consistency of data in the data warehouse.Conducted performance tuning and optimization of ETL processes and SQL queries to improve data loading times and query performance.Created and maintained documentation including data dictionaries, ETL specifications, and data lineage to ensure clarity and transparency in data warehouse processes.Worked closely with database administrators to optimize database configurations and infrastructure for data warehouse performance.Developed and maintained reporting solutions using tools like Tableau.Provided support and troubleshooting for data warehouse processes, identifying, and resolving issues in a timely manner to minimize impact on business operations.Stayed up to date with industry trends and best practices in data warehousing and business intelligence to continuously improve data warehouse solutions.Implemented data partitioning and indexing strategies to optimize query performance and manage large volumes of data effectively in the data warehouse.Collaborated with data architects and database administrators to design and implement data retention policies and archival strategies to manage historical data in the data warehouse efficiently.Implemented data lineage and metadata management solutions to track the flow of data and ensure data governance and compliance within the data warehouse environment

Woonsocket, Rhode Island, United States

Implemented API-led connectivity architecture using MuleSoft, designing APIs with clear contracts and interfaces to promote reusability and agility.Leveraged MuleSoft's Anypoint Exchange to discover, share, and reuse APIs, connectors, and templates, accelerating development and reducing time to market.Integrated MuleSoft applications with cloud-based services such as Salesforce, Workday, and ServiceNow, enabling seamless data synchronization and process automation.Implemented continuous integration and continuous deployment (CI/CD) pipelines for MuleSoft applications using tools like Jenkins or MuleSoft's Anypoint Platform, enabling automated testing and deployment.Designed and implemented caching strategies within MuleSoft applications to improve performance and reduce latency by caching frequently accessed data and responses.Utilized MuleSoft's API Manager to enforce policies such as rate limiting, throttling, and security policies, ensuring compliance with organizational standards and regulatory requirements.Implemented monitoring and alerting solutions for MuleSoft applications using tools like Splunk, ELK Stack, or MuleSoft's Anypoint Monitoring, enabling proactive monitoring and troubleshooting.Integrated MuleSoft applications with third-party identity providers (IdPs) such as Okta, Azure AD, or PingFederate for authentication and authorization, ensuring secure access to APIs and integration endpoints.Designed and implemented MuleSoft APIs to expose legacy systems and databases as RESTful services, enabling modernization and interoperability with new applications and technologies.Implemented MuleSoft error handling strategies such as retries, circuit breakers, and dead-letter queues to handle transient faults and ensure reliability and resilience in integration processes.

Burlington, North Carolina, United States

• Developed and optimized complex PL/SQL code including stored procedures, functions, triggers, and packages to support critical business processes and improve database performance.• Implemented error handling and logging mechanisms in PL/SQL code to ensure robustness and facilitate troubleshooting and debugging.• Collaborated with database administrators to design and optimize database schemas, indexes, and partitions for efficient data retrieval and storage.• Conducted code reviews and provided feedback to ensure adherence to coding standards, best practices, and performance optimization techniques.• Utilized advanced SQL techniques such as window functions, common table expressions (CTEs), and analytical functions to perform data analysis and generate reports.• Designed and maintained data models using tools such as ERwin or Oracle SQL Developer Data Modeler, ensuring alignment with business requirements and data governance standards.• Implemented data migration strategies to move data between different environments, ensuring data integrity and consistency throughout the process.• Developed and maintained documentation including data dictionaries, technical specifications, and process diagrams to facilitate knowledge transfer and ensure maintainability of database objects and ETL workflows.• Participated in cross-functional meetings and workshops to understand business needs and requirements and translate them into technical solutions and ETL workflows.• Conducted performance tuning and optimization of ETL processes, SQL queries, and database objects to improve data loading times and overall system performance.• Worked with third-party vendors and external data sources to integrate data into existing systems and ensure compatibility with internal data structures and ETL workflows.• Provided on-call support and troubleshooting for production issues, diagnosing root causes, and implementing timely solutions to minimize downtime and data loss.

Hyderabad, Telangana, India

Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using Tableau.Used advanced chart visualizations in Tableau—such as dual axis, box plots, bullet graphs, tree maps, bubble charts, and waterfall charts—to solve complex problems and to create interactive dashboards and visualizations.Served as a Tableau Liaison to mentor our team on all Tableau best-practices while supporting other developers specifically in data-source identification.Developed and reviewed simultaneous SQL queries in Tableau Desktop to validate both static and dynamic data for data validation.Conducted data analysis, performed business-analysis tasks (such as creating project plans), received data and records in multiple formats, and worked on performance-turning to help in comprehending joins and data distribution.Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials; also offered at a glance, visual representations of profitability, products, and customers.Created a data-collection template on Excel for reinsurance metrics that were approved for ongoing use.Designed stored procedures, triggers, cursors, tables, and views for several applications while generating comprehensive analytical reports by running SQL queries against current databases to conduct thorough data analyses.Strategically implemented incremental data extracts (which were updated on a timely basis as data updates), refreshed extracts, optimized and tuned applications for maximum memory management, and performed scheduling.Designed and developed visually appealing and user-friendly dashboards using Tableau Desktop, incorporating best practices for data visualization and user experience.

Master'S Degree, Information Technology

Bachelor'S Degree, Computer Science, 3.2