Data Analyst Power Bi

Ajay Krishna Guduri

+1-940-***-**** LinkedIn ***************@*****.***

PROFESSIONAL SUMMARY

Data Analyst with over 3 years of hands-on experience, specializing in optimizing data workflows to drive business value. Proficient in database management, data visualization, and translating complex data into actionable insights. Engaged with cross-functional teams to gather requirements and deliver impactful BI solutions. Seeking to leverage expertise in a challenging role to contribute to organizational success. TECHNICAL SKILLS AND CERTIFICATIONS

Languages: Java, C, Python, JavaScript, Shell Scripting, SQL, PL/SQL. Tools: Informatica PowerCenter, IDMC, Talend, IBM DataStage, Github, JIRA, Jupyter, Power BI, Tableau, putty. Databases: MS SQL, MYSQL, Oracle, Teradata.

Others: MS Excel, Microsoft Azure(Data Lake Data Factory, Databricks), AWS (S3, Glue, Lamda, EC2, CloudWatch). Certifications: Android Application Development, UiPath RPA, Tableau, Microsoft Power BI Data Analyst. PROFESSIONAL EXPERIENCE

Data Analyst PG&E, India, Cognizant July 2020 – August 2022

• Executed data modeling, transformations, and visualizations to meet business intelligence requirements.

• created complex SQL queries, functions, views, triggers, and stored procedures utilizing Oracle PL/SQL, Teradata, and MS SQL Server.

• Assessed Informatica ETL mappings/workflows and SQL that populates data warehouse and data mart Dimension and Fact tables to guarantee accuracy of business requirements.

• Strong ETL experience of using Informatica 10.5/ 10.4 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.

• Built ETL procedures with Informatica PowerCenter to ensure data consistency and integrity across data sources through effective data extraction, transformation, and loading.

• Leveraged different transformations like Filter, Router, Expression, Lookup, Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter, and Union to develop robust mappings in the Informatica.

• Designed and developed Power BI visualizations like Dashboards, Standard Reports, Scorecards, and charts.

• Gave technical support for users in resolving issues related to utilization and billing.

• Employed JIRA for project management, issue tracking, ensuring seamless communication among development.

• Mentored 2 data engineer trainees in the team through code reviews and guidance on technical design documents.

• Proficient in Windows 10 and Linux environments, utilizing tools such as Putty for secure shell access. ETL Developer CleanTech Ventures July 2019 – July 2020

• Maximized ETL technologies and databases to improve data efficiency by 25% improvement and enhance overall data quality by 15% across diverse systems.

• Experience in creating high level documents, Source to Target mapping document and detailed design level document.

• Conducted data profiling, cleansing and data validations for each data source loaded into database using SQL queries.

• Delivered Unit testing, UAT testing support and deployment support.

• Resolved and fixed critical issues in workflows by collaborating with team. Debugged through complex Joiner and Router transformation logic comprising 1000+ lines of code.

• Optimized the existing job scripts and transformations to accommodate upcoming requirements. EDUCATION

University of Texas at Arlington MS in Computer Science August 2022 – May2024 KL University BTech in Computer Science and Engineering June 2016 – May 2020 PROJECTS

Blood Buddy Android Studio, Firebase Database

• Engineered BloodBuddy (Android), a blood donation management app streamlining user registration (under 2 minutes) and facilitating efficient donor-recipient matching within a 10 km radius.

• Integrated a real-time notification system keeping users informed of nearby blood donation events or urgent requests aligned with blood type. This system resulted in a 45% increase in blood donation participation. Job Recommender System UIPath, Excel

• Steamlined a job recommendation system using UiPath Automation, streamlining the process for connecting students with suitable employment opportunities.

• This technology improved overall placement efficiency and freed up staff members to focus on student aid by cutting down on the amount of time spent on job matching by 40%.

Contact this candidate