Sumandeep Kaur Email: ad3y23@r.postjobfree.com

Contact: 341-***-****

PROFESSIONAL SUMMARY

Highly motivated Power BI developer with excellent problem-solving skills and the ability to prioritize workload.

Possesses strong technical support experience in different operating systems such as Windows and Mac, and has worked with SQL and ORACLE, MS Access Databases, and integrated with BI tools to get data and transform.

Has a strong desire to work in a collaborative environment and is able to coordinate with other teams throughout the global organization.

Experienced in testing REST web services using Postman and familiar with REST API methods such as POST, GET, PUT, UPDATE, DELETE.

Proficient in testing on Cross-Browser and collecting them. HAR and network logs from the browser.

Has good experience in Authorization methods like Public, private, Organizational accounts, OAuth, and their visibility.

Possesses excellent listening and questioning skills, combined with the ability to interact confidently with clients to establish what the problem is and explain the solution.

Has good interpersonal and customer service skills and is able to communicate both verbally and in written form.

Has strong reading skills and follows the Product documentation up to date and understands the product behavior and updates and new features.

Experience with ETL tools: Mention your experience with ETL tools such as SQL Server Integration Services (SSIS), Azure Data Factory, and Power Query. Highlight your ability to extract, transform, and load data from various sources into a data warehouse.

Data modeling skills: Emphasize your ability to design and implement data models that support business requirements. Mention your proficiency in creating relationships between tables, defining calculated columns, and writing DAX formulas.

Data visualization skills: Highlight your experience with data visualization tools such as Power BI, Tableau, and QlikView. Mention your ability to create interactive dashboards, reports, and visualizations that provide insights into business performance.

Category

Skills

Databases

My SQL Server, Oracle, MS Access

Database Tools

MS SQL Server, MS-Access, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS)

Languages

Java Script, CSS, HTML, REST API’s Web Services

Software Methodologies/Tools

SDLC, Waterfall, Agile, XP, Scrum, MS Project, SQL Profiler

Reporting and ETL

SQL Server Integration Services (SSIS) and Reporting Services (SSRS), Microsoft Power BI, Informatica, DTS, SharePoint Server 2010, PerformancePoint Server 2010

Version Control Tools

SVN, GIT

Operating Systems

Windows XP, Windows 7, Windows 8, Win 2003/2008/2008 R2

LTI-Mindtree Ltd. Redmond, WA 08/2019 - Present Day

Power BI Developer

LTI Mindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. They deliver digital transformation and technology services from ideation to execution, enabling Global 2000 clients to outperform the competition. The company has a location in Redmond, Washington

Responsibilities:

Developed and maintained Power BI reports and dashboards for various departments.

Collaborated with business analysts to understand their requirements and translate them into technical specifications.

Created DAX formulas to calculate KPIs and other metrics.

Designed and implemented data models using Power BI Desktop.

Worked with SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources.

Conducted data analysis and provided insights to stakeholders.

Created custom visuals using the Power BI Developer Tools.

Worked with the Power BI REST API to automate report generation and distribution.

Created Azure Blob Storage for Import/Export data to/from .CSV File.

Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports

Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps

Explore data in a variety of ways and across multiple visualizations using Power BI

Used Power BI Gateways to keep the dashboards and reports up to date.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Troubleshooting refresh scenarios.

Worked with Azure like setting up users, B2B invitation, adding and removing licenses, etc.

Had worked with the product team closely in solving complex problems.

knowledge on the refresh failures and how to fix them, until and unless it’s a bug and needs to be fixed by the product team.

Providing ramp activities, knowledge sharing, technical coaching, and mentoring

Experience working with Power Apps and Automate.

Crossmatch, Fremont, CA 03/2018 – 12/2018

Jr. ETL Engineer

Cross Match Technologies, Inc. provides biometric identity management solutions to defense, finance, government, law enforcement, retail, restaurant, and enterprise markets worldwide. It offers authentication and verification solutions, such as Digital Persona Altus, an authentication solution for access to networks, applications, and digital data, hardware, OEM modules, embedded sensors, and professional services. The company also provides Webs Enrollment solution to collect and manage biometric enrollment data.

Responsibilities:

Involved in creating Business Risk Levels to determine Test Priorities.

Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, involved in both Manual and Automation Testing.

Extensively used SQL Queries to verify and validate the Database Updates.

Performed data analysis and data profiling using SQL and Informatica on various source systems including Oracle and Teradata.

Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.

Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.

Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.

Responsible for Reviews and documentation for reporting the status to the project manager.

Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.

Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Environment: Informatica 8.1, Test Director 8.0, Win Runner 5.0, Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005, Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP 9.0

Road link Carrier: Union City, CA: 08/2016 to 01/2018

Responsibilities:

Created and maintained ETL processes to ensure data accuracy and consistency.

Designed data models to convert raw data to meaningful insights based on business requirements in the BI context.

Created dashboards and visual interactive reports using Power BI.

Identified KPIs with clear objectives and monitored them consistently.

Collaborated with other teams to identify data sources and integrate them into the data model.

Developed and maintained technical documentation for the data model and reports.

Troubleshot and debugged issues with the data model and reports.

ACADEMIC QUALIFICATION:

Degree

Institute

Field of Study

Year of Study

Master’s

Northwestern Polytechnic University

Computer Science

2015-2016

Bachelor’s

S.L BAWA DAV college Batala

B.COM professional

2011-2014

Bachelor’s

Punjab Technical University

Bachelor of Computer Application (BCA)

2010-2012

Contact this candidate