Rushikesh Paamu Email and Phone Number

Develop and maintain sophisticated Power BI dashboards, ensuring they deliver real-time insights and foster data-driven decision-making across the organization.Perform comprehensive data analysis, transforming complex datasets into actionable insights and clear visual representations. This involves meticulous data cleaning, manipulation, and exploration using advanced analytics tools.Manage the organization's databases, overseeing the integrity, accuracy, and security of data. Implement best practices in database management and optimization to support efficient data retrieval and analysis.Engage with stakeholders to present findings and discuss strategic implications of data insights. Tailor presentations to diverse audiences, ensuring information is accessible and effectively communicated.Collaborate with cross-functional teams to gather requirements, define key performance indicators (KPIs), and ensure that analytical projects align with business objectives.Continuously explore new data sources and analytics tools to enhance the organization's business intelligence capabilities. Stay abreast of industry trends and developments in BI technology.

Performed data profiling, created HQL scripts for data cleansing, and standardized address data.Enriched and cleansed data using Informatica BDM, ingested data with SQOOP, and wrote ETL spark scripts.Worked with Apache Thrift Server for connectivity, developed data vault objects, and performed data lineage analysis.Collaborated with stakeholders to build reports and dashboards, created SQL queries and stored procedures, optimized SQL queries, and were involved in PL/SQL programming, database backups, monitoring.

Managed client data using SQL DBX, ensuring accurate storage and meticulous record-keeping as part of comprehensive ETL (Extract, Transform, Load) processes. Spearheaded the implementation of these processes in a pilot project, which was successfully executed and well-received, setting a benchmark for future deployments.Led B2B data exchanges, specializing in complex ETL tasks that involved extracting data from various sources, transforming data through rigorous file conversions (e.g., CSV to XLSX), and loading it into target systems. Implemented automated job runs to optimize these processes, significantly enhancing data interchange capabilities and operational efficiency.Utilized OpenText to diagnose and rectify file transfer errors, ensuring robust and reliable data communications across business units.Directed client onboarding processes, providing detailed instructions on data requirements, the specific ETL tools used, and best practices for data submission to ensure the accuracy and timeliness of data inputs.Coordinated with stakeholders to update and maintain data records in Amplify, supporting consistent data accuracy and availability to facilitate informed decision-making and effective business operations.

Converted Power Center ETL mappings into PySpark jobs and created Python functions for business tasks.Analyzed SQL scripts, designed PySpark solutions, and resolved data quality issues in Informatica mappings.Involved in all stages of application development, from design to deployment.Built ingestion pipelines using Jenkins, Informatica BDM, and shell scripts.