MOHAMMED TOUSEF

1. Project Performance Tracker
Role: Power BI Developer | Company: TechBridge

• Built a PMO dashboard to track project milestones, cost variance, and resource utilization.
  Connected Power BI to Azure SQL Database and Jira for live updates.
• Used custom tooltips and drill-through pages for detailed project insights.
• Result: Improved project delivery accuracy by 25%.

2. Financial Reporting Automation
Role: Power BI Developer | Company: FinEdge Corp

• Automated finance reporting by integrating Power BI with Excel-based legacy processes.
• Used Power Query to clean and transform raw GL and P&L data.
• Built dynamic reports with slicers and bookmarks for interactive filtering.
• Result: Saved ~20 hours/month in manual finance reporting.

3. Real-Time Application Monitoring Dashboard

Role: Splunk Analyst | Company: SoftTrack Inc

• Designed and implemented real-time dashboards to monitor application logs across development, QA, and production environments.
• Created custom SPL queries to identify error trends, failed transactions, and high-latency services.
• Built dashboards with drilldowns, base searches, and tokens for enhanced interactivity.
• Integrated Splunk alerts with Slack and PagerDuty to notify the DevOps team of system anomalies.
• Result: Reduced MTTR (Mean Time to Resolution) by 40% and improved visibility into production health.

4. Infrastructure and Security Event Monitoring

Role: Splunk Analyst | Company: CyberTech Solutions

• Set up indexing and parsing rules for collecting logs from Windows servers, firewalls, and cloud platforms (AWS CloudTrail, VPC Flow Logs).
• Built SIEM-style dashboards to monitor authentication failures, port scans, and access anomalies.
• Used tstats, datamodel, and eventstats for performance-optimized queries.
• Developed real-time alerts for suspicious login behavior and resource spikes.
• Result: Detected multiple unauthorized access attempts early, strengthening the incident response workflow.

1. Sales Analytics Dashboard
Role: Power BI Developer | Company: Global Tech Solutions

• Developed interactive dashboards to track regional and product-level sales performance.
• Used DAX to calculate KPIs like YoY growth, AOV, and conversion rate.
• Integrated SQL Server and Excel sources using Power Query.
• Result: Reduced manual reporting time by 60%.

2. HR Attrition and Headcount Dashboard
Role: Power BI Developer | Company: PeopleFirst HR Solutions

• Designed dashboards to track attrition, employee demographics, and tenure distribution.
• Applied Row-Level Security (RLS) for department-specific visibility.
• Created predictive visuals using DAX and trend lines.
• Result: Helped HR identify early warning signs of high attrition, reducing churn by 15%.

3. Customer Data Warehouse Integration
Role: ETL Developer | Company: First American India

• Built ETL pipelines using Talend to migrate and transform data from multiple sources (CSV, JSON, Oracle) into a central data warehouse.
• Used Talend components like tMap, tJoin, tFileInputDelimited, tOracleInput, and tRunJob.
• Implemented error-handling logic and data quality checks with tLogCatcher and tSchemaComplianceCheck.
• Result: Increased data accuracy and reduced load failures by 90%.

4. Billing System ETL Optimization
Role: Talend Engineer | Company: TelcoNet

• Re-engineered existing ETL jobs to optimize billing data ingestion from flat files and APIs.
• Used tParallelize and tBufferOutput for parallel processing.
  Tuned jobs for performance, reducing runtime from 90 minutes to 30 minutes.
• Result: Improved on-time billing SLA compliance.