Sushmitha S

ad471i@r.postjobfree.com

614-***-****

PROFESSIONAL SUMMARY:

Experienced Power BI developer with 6 years of experience in designing, developing, and deploying PowerBI dashboards.

Results-driven and analytical Power BI Developer with five years of hands-on experience translating complex business requirements into impactful data visualizations.

Proven expertise in designing, implementing, and optimizing Power BI solutions for diverse industries.

Adept at transforming raw data into actionable insights, driving informed decision-making.

Demonstrated proficiency in creating interactive dashboards and reports that enhance organizational performance.

Extensive experience in developing custom visuals, reports, and dashboards using Power BI Desktop and Power BI Service.

Expertise in handling complex data scenarios, including relationships, calculated columns, and measures.

Strong background in designing and implementing efficient data models, ensuring optimal performance for large datasets.

Skilled in extracting, transforming, and loading (ETL) data from various sources into Power BI using Power Query and M Power Query formula language.

Collaborated with data engineers and analysts to ensure data quality, accuracy, and consistency across different data sources and platforms.

Experience in implementing incremental data refresh strategies for improved data loading efficiency.

Proficient in creating advanced DAX calculations, including time intelligence, statistical, and financial functions.

Implemented row-level security to ensure data confidentiality and compliance with privacy regulations.

Successfully optimized report performance by identifying bottlenecks and implementing performance-tuning techniques.

Familiarity with data compression methods and strategies for minimizing report refresh times.

Understanding of machine learning concepts for potential integration with Power BI.

Applied agile methodologies to ensure flexibility and responsiveness in project delivery.

Experience working with data warehousing concepts, including star and snowflake schemas.

Provided training and support to end-users on Power BI features and functionalities, such as report navigation, filtering, and exporting.

Familiarity with cloud platforms, particularly Azure, for scalable and secure deployment of Power BI solutions.

Proven track record of delivering high-quality products on time and within budget, while collaborating with cross-functional teams and stakeholders, and adhering to agile development methodologies.

Experienced in Git for continuous integration and deployment.

Excellent communication skills, with the ability to work independently or as part of a team in a fast-paced and dynamic environment.

TECHNICAL SKILLS:

Programming Language

DAX, M, Python

Microsoft

PowerBI

Azure

Data Factory – pipelines, triggers, Blob, Azure SQL, App Services, Key vault, DevOps – Agile boards, Build/ Release pipelines, AppInsights.

Design Patterns:

Star Schema Design, Micro services

Data Access:

LINQ, T-SQL, ODBC, SSIS, Snowflake

UI Technologies

HTML5, JavaScript, Typescript, jQuery, Bootstrap, Ajax, CSS 3.0.

IDE:

Power BI Desktop

BI Tools:

SSRS, PowerBI, Tableau

PROFESSIONAL EXPERIENCE:

Caterpillar Inc., Peoria, IL Sep’22– present

Role: PowerBI Developer

Responsibilities:

Asset Tracker and Customer Access Management:

Created and maintained Power BI reports and dashboards for the “Asset Tracker” and “Customer Access Management” systems.

Collaborated with stakeholders to understand business requirements and translated them into effective data visualizations.

Established data models in Power BI Desktop, including defining relationships, creating calculated columns and measures using DAX, and optimizing performance for efficient reporting.

Implemented data governance and security best practices within Power BI Service, including managing access permissions, roles, and row-level security to ensure data confidentiality and compliance.

Automated data refresh schedules and optimized data loading processes to ensure reports and dashboards are up-to-date and performant.

Collaborated with the internal Caterpillar offshore team who will eventually be supporting the two systems once they are up and running to ensure smooth transition/knowledge transfer.

Developed custom visuals and templates in Power BI to meet specific business requirements and enhance data visualization capabilities.

Conducted data analysis and implemented complex data transformations using Power Query Editor to ensure data accuracy and integrity.

Optimized performance by enabling query folding, which pushes transformations back to the data source.

Generated and delivered quality reports to customers by conducting quality assurance checks and recorded a 65% increase in customer satisfaction.

Environment: PowerBI Desktop, Power Query, DAX, PowerBI Service, PowerBI Report Server, SQL Server, Snowflake, Gateway Installation, Git, Python.

Accenture, Hyderabad Apr’19 – Aug’22

Client: nbn co ltd

Role: Data Integration/PowerBI Developer

Description: Developed PowerBI dashboards to identify the KPIs which boosts customer’s engagement behavior in Omni-channel marketing team that focuses on developing the solutions for generating campaigns and maintaining customer relations throughout their journeys.

Responsibilities:

Gathered requirements for the existing application and analyzed the possibilities of any enhancements that could be accommodated into the new dashboard.

Developed and maintained interactive dashboards and reports in Power BI to visualize key performance indicators (KPIs), trends, and insights for business stakeholders.

Collaborated with cross-functional teams to identify data sources, extract data, and load it into Power BI for analysis and reporting purposes.

Created efficient and optimized data models within Power BI using star schemas, snowflake schemas, and slowly changing dimensions.

Used DAX expressions for creating calculated columns, measures, and custom calculations.

Developed ETL processes to extract data from various sources, transform it (using Power Query or other tools), and load it into Power BI datasets.

Connected Power BI to diverse data sources (SQL databases, APIs, cloud-based platforms) for comprehensive data consolidation.

Implemented security rules based on user roles to restrict data access.

Use Git or other version control systems to manage changes to Power BI files

Improved dashboard usability by implementing interactive visualizations resulting in a 20% increase in user engagement.

Environment: PowerBI Desktop, Power Query, DAX, PowerBI Service, PowerBI Report Server, SQL Server, Snowflake, Gateway Installation, Git, Python.

Cognizant Apr’18 – Mar’19

Client: Google Inc.,

Role: Python Developer

Responsibilities:

Developed and maintained Python-based applications, scripts, and tools to support business operations and workflows.

Enhanced data processing pipelines and ETL (Extract-Transform-Load) workflows using Python libraries and frameworks.

Developed and maintained web applications using Python-based frameworks such as Django or Flask.

Written unit tests to ensure code quality, reliability, and maintainability.

Supported the automation of repetitive tasks and processes using Python scripts, improving efficiency and productivity.

Worked with DevOps teams to streamline deployment pipelines and implement continuous integration/continuous deployment (CI/CD) practices using tools like Jenkins or GitLab CI.

Involved in codebase refactoring efforts to improve code structure, readability, and maintainability, following established coding standards and guidelines.

Participated in Agile development processes, including sprint planning, daily stand-ups, and retrospectives, to deliver software iterations on time and within scope.

Environment: Python 3.5, Jupyter Notebook, conda, Numpy, pandas, SQL, Django, pytest, Git.

EDUCATION:

Bachelor in Technology, JNTU-HYD

Contact this candidate