Akash Ahire

Data Analyst @Tata Consultancy Services

Pune, IN

Key Responsibilities -•Collaborated with cross-functional teams in an enterprise data environment to deliver scalable data solutions.•Designed and developed robust ingestion pipelines from SFTP (Unix), SharePoint, databases, REST APIs, files, and real-time streams.•Processed and transformed data for centralized storage in enterprise data warehouses to support downstream applications.•Performed data migration using AWS DMS, ensuring accuracy, consistency, and system performance.•Developed optimized Power BI data models (star/snowflake schemas) enabling self-service BI and analytics.•Delivered impactful dashboards and reports in Power BI using DAX and Power Query.•Executed Power BI POCs to showcase feasibility and business value.•Ensured data quality, performance tuning, and security in ETL and reporting pipelines.•Conducted requirement analysis and authored reusable design components and documentation.•Managed Agile delivery using JIRA and Xray for sprint planning, test execution, and defect tracking.•Collaborated via GitHub for version control, CI/CD, and code reviews.Tasks -•Scheduled and monitored ETL processes as per technical specifications, ensuring timely and reliable execution.•Designed reusable tech components and created complex SQL queries, views, and stored procedures, including MVs.•Analyzed Informatica mappings and restructured logic using SQL for performance optimization.•Supported team in AWS DMS usage for data migration and integration testing.•Built data components for SAP IDT/BO, including automated extract refresh processes.•Orchestrated workflows using Apache Airflow DAGs and internal scheduling via the ABC platform.•Conducted unit and integration testing post-migration to PostgreSQL ensuring full functionality.•Executed test cases based on client requirements using Xray integrated with JIRA.•Developed Power BI dashboards integrated with PostgreSQL and other sources for analytics reporting.

Sinhgad College of Engineering

Bachelor of Engineering - BE, Computer Engineering