Ajay K.
MSBI | SQL | TSQL| POWER BI
- Role
- Senior Data Developer at 摩根大通
- Location
- Hyderabad, IN
- LinkedIn followers
- 500 followers
About Ajay K.
Having 7 years of professional experience in the industry, with extensive involvement in…
Experience
Senior Data Developer
Oct 2021 — Present
Proficient in designing and developing interactive Power BI dashboards and reports with Advanced DAX calculations and KPIs to business decision making.•Expertise in DAX (Data Analysis Expressions) — including CALCULATE, FILTER, SUMX, RANKX, SWITCH, RELATED, and ALL for creating dynamic measures and time intelligence functions.•Skilled in data modelling and schema design, creating Fact and Dimension tables, star and snowflake schemas, and implementing Row-Level Security (RLS) in Power BI.•Hands-on experience in Power Query for data transformation, cleansing, and combining datasets from diverse sources such as SQL Server, Excel, and flat files.•Strong SQL programming skills - writing and tuning complex T-SQL queries, Stored Procedures, Views, Indexes, and Functions for analytical and reporting purposes.•Experience in ETL development using SSIS: designing data extraction, transformation, and loading workflows with components like Lookup, Merge Join, Conditional Split, and Derived Columns.•Implemented incremental load strategies and error handling mechanisms in ETL processes for performance and reliability.•Expertise in data integration from multiple sources and formats to ensure consistency, accuracy, and completeness across analytical datasets.•Created drill-down, drill-through, and parameterized Power BI enabling detailed insights and user interactivity.•Experienced in database performance tuning, query optimization and index management to improve data retrieval speed and efficiency.•Adept at analysing business requirements, translating them into technical specifications, and delivering insights through visual storytelling and dashboards.•Hands-on experience using Power BI Service for publishing reports, Managing datasets and sharing dashboards securely.•Proficient in data warehousing concepts, creating staging, fact, and dimension tables and ensuring data quality and integrity throughout the pipeline.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.