Priyadarshini Thota
Houston,TX
Summary
Data engineer with 5+ years of experience in designing and implementing complex data solutions in Power B, azure cloud. Experienced in building and maintaining data pipelines using azure services. Experienced Power BI Developer with expertise in designing and modernizing intuitive dashboards for Privileged Access Management. Skilled in developing advanced Power BI models and implementing DAX queries to handle large datasets efficiently. Proficient in MSSQL database management, including data storage structuring, query optimization, and seamless integration with Power BI. Strong background in designing and implementing ETL processes to ensure accurate and timely data ingestion and transformation. Adept at ensuring compliance with security standards such as ISO 27001 and implementing role-based access control (RBAC) for secure data handling. Proven ability to collaborate with stakeholders to translate complex business and security requirements into actionable technical solutions. Experienced in automating workflows with tools like Power Automate and optimizing Power BI performance through fine-tuned data models and query execution. Dedicated to delivering high-quality dashboards and reports, supported by comprehensive documentation and ongoing user feedback integration.
Overview
5
5
years of professional experience
Work History
Power BI developer
Vorizo Info Tech INC
Sugarland, Texas
12.2023 - Current
- Company Overview: Company website (https://vorizoit.com/technology.html)
- Designed user-friendly Power BI dashboards for Privileged Access Management, delivering actionable insights to stakeholders and improving usability
- Managed MSSQL databases to optimize data storage and retrieval, reducing query times by 40% and enhancing integration with dashboards
- Implemented DAX queries and Power BI models for datasets exceeding 10 million records, ensuring high performance and accuracy
- Collaborated with cross-functional teams, gathering technical requirements and translating complex business needs into solutions aligned with organizational goals
- Ensured data security compliance (ISO 27001) by implementing role-based access controls
- Conducted rigorous testing to resolve data inaccuracies and functional issues, ensuring over 95% accuracy pre-deployment
- Documented workflows, creating a robust knowledge base for maintenance and scalability
- Company website (https://vorizoit.com/technology.html)
- Environment: Business Intelligence Tools: Power BI (Report Development, Dashboard Design, DAX), Database Management: MSSQL Server, SQL (Stored Procedures, Views, Indexing, Query Optimization)
Power BI developer
Bizmetric
Sugarland, Texas
08.2023 - 11.2023
- Company Overview: Company website (https://www.bizmetric.com)
- Partnered with data engineers to create streamlined ETL processes using MSSQL for precise data handling.
- Manage and optimize MSSQL databases by structuring data storage, improving query performance, and ensuring seamless integration with Power BI dashboards.
- Developed intuitive Power BI dashboards for Privileged Access Management, enhancing data clarity and user experience.
- Develop advanced Power BI models, and implement DAX queries to handle large datasets, ensuring optimal dashboard performance and scalability.
- Collaborate with stakeholders, including business and security teams, to gather requirements, translating complex business and security needs into actionable technical solutions.
- Ensure data handling and reporting processes comply with organizational security policies and industry standards, such as ISO 27001, to support privileged access management.
- Executed comprehensive testing and quality assurance to ensure dashboard functionality complies with business objectives.
- Document dashboard designs, ETL processes, data models, and workflows to support ongoing maintenance, scalability, and effective knowledge transfer across teams.
- Implemented role-based access control (RBAC) and other security measures within Power BI and data systems to ensure proper governance of sensitive data.
- Monitor and optimize Power BI dashboard performance by fine-tuning data models, query execution, and computing resources.
- Automate business processes and workflows using tools like Power Automate to streamline data updates and reporting tasks.
- Create SQL views, stored procedures, and other database objects to enable efficient data retrieval and transformation for Power BI reports.
- Support ongoing dashboard enhancements by gathering user feedback, identifying areas for improvement, and implementing updates to meet evolving business needs.
- Collaborate with cross-functional teams to develop solutions that align with security compliance and business requirements, ensuring consistent delivery of high-quality dashboards and reports.
- Company website (https://www.bizmetric.com)
- Environment: ETL, GCP BigQuery, Power BI, Apache Airflow, C, Java, HTML, Linux, JavaScript, Microsoft Excel, AWS, Python, Microsoft Office, Docker, Kubernetes, Python.
Data Analyst
University of Houston Downtown
Houston, Texas
08.2022 - 05.2023
- Company Overview: Company website (https://www.uhd.edu/)
- Created, updated, and maintained dashboards in Smartsheet
- Created, updated, and maintained dashboards in Microsoft Power BI
- Received training in Power BI to enhance skills
- Assisted in creating dashboards for various units within the IT Department
- Provided support in generating useful information for IT staff and leadership
- Collaborated with team members to ensure effective dashboard creation
- Demonstrated proficiency in utilizing Power BI for data visualization and analysis
- Ensured accuracy and reliability of data presented in dashboards
- Actively participated in team discussions and brainstorming sessions
- Communicated effectively with stakeholders to gather requirements for dashboards
- Implemented best practices in dashboard design and development
- Customized dashboards to align with changing business needs and priorities.
- Responded promptly to feedback and made necessary adjustments to dashboards
- Maintained confidentiality and security of sensitive data within dashboards
- Provided training and support to end-users on navigating and utilizing dashboards
- Demonstrated professionalism and courtesy in all interactions within the department
- Received commendation for exemplary job performance and dedication to duties
- Worked with complex SQL views, Stored Procedures, Triggers, and packages in large databases from various servers
- Used Azure Logic Apps to develop workflows which can send alerts/notifications on different jobs in Azure
- Used Azure DevOps to build and release different versions of code in different environments
- Well-versed with Azure authentication mechanisms such as Service principal, Managed Identity, Key vaults
- Created External tables in Azure SQL Database for data visualization and reporting purposes
- Company website (https://www.uhd.edu/)
- Environment: Power BI, Data Bricks, SQL, C, Java, HTML, Linux, Microsoft Excel, AWS, Python, Microsoft Office, Docker, Kubernetes, Python
Application Developer
IBM
, India
08.2019 - 08.2021
- Company Overview: Company website (https://www.ibm.com/in-en)
- Performance testing and debugging of applications and systems to ensure functionality and performance
- Create and maintain documentation for system configurations, processes, and procedures
- Work with cross-functional teams, including developers, analysts, and project managers, to deliver solutions
- Interact with clients to understand their requirements and provide technical assistance
- Involved with architecture team and data analysts for processing customer related user data based on the business requirements
- Actively working on technologies like AWS Glue, S3, Cloudera, Spark, Scala, Python, pyspark, Hive, snowflake
- Created Python job to create or delete the AWS resource like EC2, Athena table, Glue Job etc on ad-hoc request
- Captured the data of insurance members and analyse the interest of members in the insurance process
- Create S3 Buckets to store the raw data and to maintain the ETL scripts and Written Glue jobs to ingest the historical data into the Athena tables
- Developed spark programs with python and applied principles of functional programming to process complex unstructured and structured data sets on top of EMR
- Created Airflow DAGs to schedule the ingestions, ETL jobs and various business reports
- Support Production Environment and debug issues using Splunk logs
- Stage the API or Kafka Data (in JSON file format) into Snowflake Database by flattening the same for different functional services
- Created data ingestion framework in snowflake for both Batch and Real-time data from different file format (XML, JSON, Avro) using snowflake stage and Snowflake Data Pipe
- Company website (https://www.ibm.com/in-en)
- Environment: C, Java, HTML, Linux, Javascript, Microsoft Excel, AWS, Python, Microsoft Office, Docker, Kubernetes, Python
Education
Bachelor in Technology - Computer Science
JNTUH
INDIA05-2021
Master in science - Data Analytics
University Of Houston Downtown
Skills
- Power BI
- Python
- R
- SQL
- MySQL
- AWS
- Azure
- ETL
- Data Structures
- Tableau
- RDBMS
- Microsoft Visual Studio
- R Studio
- GitHub
- Agile/Scrum
- SDLC
Timeline
Power BI developer
Vorizo Info Tech INC
12.2023 - Current
Power BI developer
Bizmetric
08.2023 - 11.2023
Data Analyst
University of Houston Downtown
08.2022 - 05.2023
Application Developer
IBM
08.2019 - 08.2021
Master in science - Data Analytics
University Of Houston Downtown
Bachelor in Technology - Computer Science
JNTUH
Similar Profiles
RAHUL SHARMARAHUL SHARMA
SALES, TRAINING AND QUALITY MANAGER at Highlands Info Tech Pvt. Ltd.SALES, TRAINING AND QUALITY MANAGER at Highlands Info Tech Pvt. Ltd.
Thiyaga Lakshmi VellaiSamyThiyaga Lakshmi VellaiSamy
Senior Software Implementation Specialist at DigiSME Pvt Ltd (a) Majulah Info-Tech Pvt LtdSenior Software Implementation Specialist at DigiSME Pvt Ltd (a) Majulah Info-Tech Pvt Ltd
Chaoqiong XuChaoqiong Xu
Team Assistant at Digital China Info Tech Co.,LtdTeam Assistant at Digital China Info Tech Co.,Ltd