mohamed ibrahim

Data & Business Intelligence Analyst

Chennai 5+ yrs exp 95 · Outstanding

About

Data Analyst with 5 years of professional experience spanning data analytics, business intelligence, SQL development, workflow automation, and application development at LTIMindtree. Experienced in Microsoft SQL Server, PostgreSQL, SQL*Plus, Python, Power BI, Excel, MongoDB, and data warehousing concepts. Skilled in developing complex SQL queries, stored procedures, views, functions, and indexes, as well as creating interactive Power BI dashboards and reports to visualize KPIs and deliver actionable business insights. Experienced in data collection, cleaning, processing, validation, exploratory data analysis, ad-hoc analysis, data modeling, and stakeholder collaboration. Strong background in translating business requirements into data-driven solutions and troubleshooting technical issues across enterprise applications.

Skills & Expertise (37)

Power BI Advanced

8.5/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

SQL Advanced

8.0/10

Years Exp

Data Modeling Intermediate

7.5/10

Years Exp

Data Warehousing Intermediate

7.0/10

Years Exp

Python Intermediate

7.0/10

Years Exp

Microsoft SQL Server Intermediate

7.0/10

Years Exp

Business Intelligence Intermediate

7.0/10

Years Exp

Data Processing Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Ad-hoc Analysis Intermediate

7.0/10

Years Exp

Exploratory data analysis Intermediate

7.0/10

Years Exp

Postgresql Intermediate

6.5/10

Years Exp

Pivot Charts Intermediate

6.0/10

Years Exp

XLOOKUP Intermediate

6.0/10

Years Exp

Pivot Tables Intermediate

6.0/10

Years Exp

VLOOKUP Intermediate

6.0/10

Years Exp

Conditional Formatting Intermediate

6.0/10

Years Exp

Smartforms Intermediate

6.0/10

Years Exp

SDLC Intermediate

6.0/10

Years Exp

Query Optimization Intermediate

6.0/10

Years Exp

Complex SQL queries Intermediate

6.0/10

Years Exp

STLC Intermediate

6.0/10

Years Exp

Unit Testing Intermediate

6.0/10

Years Exp

Stored Procedures Intermediate

6.0/10

Years Exp

MongoDb Intermediate

6.0/10

Years Exp

End-to-End Testing Intermediate

6.0/10

Years Exp

Data Validation Intermediate

6.0/10

Years Exp

KPI Reporting Intermediate

6.0/10

Years Exp

Prompt Engineering Beginner

5.0/10

Matplotlib NumPy Pandas Indexes Functions SQL Loader SQL Plus

Work Experience

Data Analyst / BI Analyst

LTIMindtree

Aug 2024 - Present

Developed interactive Power BI dashboards and reports to visualize key performance indicators (KPIs) and communicate actionable insights to stakeholders. Developed optimized data modeling tables using advanced SQL (CTEs, subqueries, joins), improving query execution speed by 40% across large datasets. Designed and delivered complex Power BI reports based on client business requirements, supporting data-driven decision-making and business intelligence initiatives. Designed and deployed an interactive E-commerce Power BI dashboard for 100+ business users, leveraging bookmarks, navigation buttons, and matrix visualizations to reduce reporting turn-around time by 25%. Developed complex SQL queries for reporting and dashboard development using Microsoft SQL Server. Optimized SQL queries and developed stored procedures, database views, functions, and indexes to support reporting and analytical requirements. Collaborated with cross-functional teams to understand business requirements, analyze business problems, and develop data-driven solutions. Performed ad-hoc data analysis and generated insights to support strategic initiatives and business objectives. Created and maintained data models and relationships to support Power BI reporting and analytical requirements. Monitored and validated key metrics and data from daily reports to ensure data accuracy, consistency, and integrity. Collected, cleaned, and processed large datasets from multiple sources to prepare reliable data for reporting and analysis. Applied knowledge of database management systems and data warehousing concepts to support enterprise reporting and analytics requirements.

K2 Developer / SQL Developer

ConocoPhillips

Dec 2021 - Jul 2024

Developed and maintained enterprise applications using K2 / Nintex based on business and client requirements. Configured and enhanced K2 forms, views, workflows, and SmartObjects to implement application and workflow requirements. Configured 10+ automated enterprise workflows and resolved over 100 end-to-end application defects, significantly enhancing platform reliability and user experience. Developed SQL stored procedures and database components to support application functionality and business requirements. Worked on front-end and back-end defect resolution using K2 Designer and SQL databases. Designed and configured K2 workflows to support workflow automation and business processes. Created and maintained K2 forms, views, workflows, and SmartObjects based on functional requirements. Used K2 Management to monitor application issues, inspect errors, troubleshoot workflow problems, and support defect resolution. Collaborated with stakeholders to understand enhancement requirements and translate them into technical solutions. Supported application maintenance, troubleshooting, testing, and production issue resolution.

PEGA Developer

Mondelez Global

Apr 2021 - Sep 2021

Developed PEGA 8.1 cases based on client business requirements for multiple regions, including AMEA and APAC. Configured application sections and implemented business logic to support workflow automation requirements. Performed unit testing and end-to-end testing to validate application functionality and business requirements. Worked on application development activities based on functional and technical requirements. Supported workflow automation and application enhancements across multiple regional requirements.