Data analyst

Hi,

Hope you are doing great.

📄 NOTE : Not For Bench Sales Recruiters. ❌

Please share C2C Requirements to priyanka@realsoftech.com

Candidate Details:

Name: Pranay
Visa     : H1B
Experience: 9+
Relocation: open
Availability: Immediately
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.

Business Skills:

Data Warehousing & Big Data Analytics                                   Data Manipulation & Data Visualization

Data Modeling & Database Design                                            ETL Development & Data Integration

KPI Development & Reporting                                                      Advanced SQL Querying

Data Governance and Security                                                   Client Communication & Stakeholder Management

Project Management & Team Collaboration                          Trend Analysis & Forecasting

Mentoring & Training Teams on BI Tools                                     Error Handling, Debugging, and Performance Tuning

Descriptive and Predictive Statistics                                           Hypothesis Testing and ANOVA

Descriptive and Predictive Statistics                                           Data Marts & Operational Data Stores (ODS)

Correlation and Regression Analysis                                           Mathematical Modeling

Machine Learning, Supervised ML                                               Pandas, NumPy, Matplotlib, Seaborn, Ski-learn, SciPy

Big Data, Apache Spark, PySpark                                                Business Intelligence (Power BI, SSAS, Tableau, Cognos BI)

Technical Skills:

Thanks & Regards,

Priyanka Patnaik,
US Staffing Professional
Realsoft Technologies, LLC
Email: Priyanka@realsoftech.com
Off: 703-689-9945 Ext 151
Fax: (703) 852 7190
www.realsoftech.com
503 Carlisle Drive, #175, Herndon, VA – 20170