Niranjan Rana

Associate Consultant

Hyderabad, Telangana, India9 yrs 9 mos experience

Key Highlights

  • Over a decade of experience in analytics and BI.
  • Delivered dashboards reducing analysis time by 50%.
  • Expert in transforming raw data into actionable insights.
Stackforce AI infers this person is a Data Analytics and Business Intelligence expert in the Healthcare and Banking sectors.

Contact

Skills

Core Skills

Power BiSqlData AnalysisPythonAwsSelenium

Other Skills

Microsoft Power QueryMicrosoft Power BIData ModelingData ScienceData VisualizationData AnalyticsStatistical Data AnalysisLife SciencesPySparkrestapiDAXRetail BankingchaliceAmazon Web Services (AWS)Managing Associates

About

Over a decade work experience from AMD, Capgemini, and Cognizant with strong skills in Power BI, SQL, and Python. I’ve delivered dashboards and reports that cut analysis time by 50%, enabling faster, smarter business decisions. Individually handled multiple clients from different domains like life sciences, finance, banking, and so on. Passionate about data-driven strategy, I specialize in turning raw data into clear insights that drive impact. Currently based in Dubai and available for immediate interviews. 📌 Key Skills: Power BI | DAX | SQL | Python (pandas, numpy) | Data Modeling | Business Intelligence | ETL | Storytelling with Data

Experience

9 yrs 9 mos
Total Experience
2 yrs 3 mos
Average Tenure
1 yr 8 mos
Current Experience

Power bi

Immediate Joiner

Sep 2024Present · 1 yr 8 mos

Cognizant

Senior Associate

May 2023Aug 2025 · 2 yrs 3 mos · Pune District, Maharashtra, India · On-site

  • Power BI, SQL, Python, SQL, Azure cloud
  • Collected, cleaned and transformed large datasets from multiple sources and APIs to combine the data for different departments and create an insightful dashboard.
  • Engaged with stakeholders, clients and business analysts to understand business requirements and prepare a development plan and requirement document that streamlined the reporting process.
  • Designed and built dynamic dashboards and reports with advanced visualizations, such as scorecards, stacked column charts, donut charts, and matrix tables.
  • Built a Study Timeline report replicating MS Project templates, allowing nonlicensed users to visualize and analyze 10+ studies simultaneously.
  • Developed a unified Power BI app with five integrated reports, enabling costefficient, licensefree access for study stakeholders—saving ~$50/user.
  • Delivered a Study Compliance report comparing datasets across Smart Assigner (Biopharma) and Airtable (Oncology), which improved data reconcil
Microsoft Power QueryMicrosoft Power BIData ModelingData ScienceData VisualizationData Analytics+5

Capgemini

Senior Consultant

Jul 2021Apr 2023 · 1 yr 9 mos · Hyderabad, Telangana, India · Remote

  • Led the development of scalable APIs using Python and the Chalice framework for seamless database interactions and AWS integrations.
  • Optimized report rendering time by 30% through data model enhancements.
  • Created interactive Power BI dashboards with filters, drill through, and bookmarks for easy data interpretation.
PySparkrestapiDAXRetail BankingchalicePython+2

Amd

Python Developer

Jun 2020Jun 2021 · 1 yr · Bengaluru, Karnataka, India · Remote

  • Writing automation scripts to read log files for nightly runs and create report.
  • Creating report and dashboard for regression runs of each version.
  • Verifying and filing bugs in JIRA.
  • Creating Docker containers to run test suites in specific environment.
  • Working with Jenkins and python script to Automate daily runs.
Managing AssociatespythonPandasStatistical Data AnalysisPython

Compugain

Software Associate

Jul 2018Jun 2020 · 1 yr 11 mos · Hyderabad, Telangana, India · On-site

  • Responsibilities: • Develop and configure software that delivers test automation suites that meet our business coverage objectives
  • Learn and understand the business domain and application architecture
  • Analyzing stories and manually testing cases.
  • Define, create and execute automated test cases, i.e. unit tests
  • Perform initial diagnosis when automated test suites fail.
  • Designing and writing test automation framework.
  • Automating test cases using selenium and python.
  • Regression run all test cases on daily basis.
  • Creating schedule jobs in Jenkins for Regression runs.
  • Worked on the test automation framework and implemented Test Report Creation, Report Email Generation, etc.
  • Troubleshooting and problem solving.
  • Learn and understand the data pipeline.
  • Writing python script to consume message from kafka.
  • Creating kafka producer and topic to public message from apaas and aws back to Kafka.
  • Writing boto3 code to interact with AWS services.
  • Creating Confluence pages to document test scenarios.
SeleniumPandasMatplotlibPythonDatabasesNatural Language Processing (NLP)

Eidiko systems integrators private limited

Software Engineer

Feb 2015Mar 2018 · 3 yrs 1 mo · Hyderabad, Telangana, India · On-site

CommunicationBankingPythonIIB

Education

GIET University Gunupur

Bachelor of Technology - BTech — Information Technology

Jan 2010Jan 2014

Stackforce found 100+ more professionals with Power Bi & Sql

Explore similar profiles based on matching skills and experience