SQL Developer -

Hi,

I hope you are doing well.

Candidate Details:

Name: Pranay
Visa : H1B
EXP : 9+
Availability: Immediately
Expected Rate : $65/hr
Resume: [Attached]

Power BI/Business Intelligence/Azure/Tableau Developer/Data Analyst

Career Objective: A highly skilled Business Intelligence (BI) Developer and Data Analyst with over 9 years of experience in leveraging Microsoft BI, Azure, AWS, and Data Warehousing solutions. Adept at designing and implementing advanced data models, ETL processes, and interactive dashboards using Power BI, SSIS, SSRS, SSAS, and Oracle BI. Proven expertise in DAX, SQL, and data visualization to drive actionable insights and support strategic decision-making. Seeking a challenging role that enables me to utilize my technical expertise, leadership abilities, and passion for data to deliver innovative business intelligence solutions in a dynamic and growth-oriented environment.

Professional Summary:

9 years of experience in Microsoft Business Intelligence (BI), Data Warehousing, Data Analytics, and Azure Cloud Platforms, including SQL Server, Power BI, SSIS, SSRS, SSAS, and Oracle BI.
Highly experienced as a Microsoft BI Developerand Data Analyst with expertise in SQL Server 2016/2014/2008, OLTP/OLAP, SSIS/SSRS/SSAS across various domains and environments (Production, UAT, Development).
Highly proficient in DAX (Data Analysis Expressions)for creating complex calculated columns, measures, tables, and advanced formulas for interactive Power BI dashboards and reports.
Implemented Dynamic Row-Level Securityin Power BI Service (Cloud) and Power BI Report Server (On-Premises) for secure data access.
Expertise in designing Power BI composite models, aggregations, and dual storage modes for performance optimization in large-scale datasets.
Developed KPI-based reports, interactive dashboards, and analytical reports using Power BIfor real-time streaming data and management-level insights.
Proficient in Power Queryand M Code for data cleaning, transformation, and performance optimization in Power BI.
Managed Power BI Reportsin different environments (DEV/QA/PROD) using Power BI Premium capacity and deployment pipelines.
Experience in Power BI Data Flows, Data Folding, and Query Reductiontechniques to enhance query performance and optimization.
Strong expertise in ETL Developmentusing SSIS for extracting, transforming, and loading data from various sources, including SQL Server, Oracle, and IBM Cognos BI into data warehouses and marts.
Proficient in Star Schema (Kimball), Snowflake modeling, and Data Martsin both OLTP/OLAP environments for Data Warehousing.
Hands-on experience with Informatica PowerCenterand IBM Cognos BI for ETL and developing reports, dashboards, and scorecards.
Expertise in Oracle BIfor developing analytical reports, working with Oracle Database environments, and integrating with Tableau and Power BI.
Skilled in writing complex SQL scripts(CTEs, derived tables, joins, row-numbering, sub-queries, views) for Big Data aggregation and database optimization across SQL Server, Oracle, PostgreSQL, and IBM DB2.
Proficient in SSRSfor creating Drill-Down, Parameterized, Cascading, Conditional, Ad-hoc, Sub-Reports, and Charts to support business reporting needs.
Strong experience with SSAS, building analytical cubes for multidimensional and tabular models, with proficiency in MDXand DAX for OLAP reporting.
Advanced knowledge of Azure Data Factory, Azure SQL Database, Azure Analysis Services, and Azure Blob Storagefor ETL processes, data integration, and reporting.
Experience in AWS RDS, S3, and Redshiftfor managing SQL databases and integrating them with BI tools for reporting.
Proficient in Oracle Cloudand IBM Cloud environments for hosting BI applications and performing analytics workloads.
Integrated external data sources using RESTful APIsand Web Services for data extraction and loading in Power BI.
Automated reporting workflows using Python scripts, SSIS packages, and Azure Logic Appsto enhance efficiency.
Extensive experience in Apache Sparkand PySpark for processing large datasets and integrating with Power BI for big data analytics.
Implemented Supervised and Unsupervised Machine Learning algorithmslike KNN, Logistic Regression, SVM, Decision Trees, Random Forest, XGBoost, and LightGBM using Python libraries.
Expertise in R programmingfor data wrangling, creating RMarkdown reports, and developing interactive Flex Dashboards for advanced analytics.
Led multiple projects, providing training on Power BI, DAX, M Code, and SQL, and mentoring teams on best practices in BI development.
Strong in communication, presentation, and problem-solving skills, collaborating with cross-functional teams and delivering solutions under tight deadlines.