Lakshmi Urjitha Dhadigam

: +1-708-***-**** : adv08r@r.postjobfree.com : https://www.linkedin.com/in/urjithadhadigam/ PROFESSIONAL EXPERIENCE

MSRCOSMOS LLC DATA ANALYST JULY 2022 – FEB 2023

Generated analytical reports by running SQL queries against current data bases to conduct data analysis.

Designed visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms.

Developed PySpark scripts on Azure Databricks to migrate data from on-premises to Cloud (AWS S3).

Worked with development teams to understand and analyze client requirements.

Communicated with business users, business analysts to analyze, design, develop the Cognos Reports, Dashboards, DMRS.

Created Python and SQL scripts to perform data validations across different metrics

Designed and deployed reports with drill down, drill through and drop down menu option and parameterized and linked reports using tableau.

Performed data integrity checks, data cleaning, exploratory analysis using Python and Tableau.

Worked on data shaping, transformation, and modeling in Power Bl using DAX and Power Query Editor. ALLEN REINFORCED PLASTICS, INDIA DATA ANALYST JAN 2019 – DEC 2020

Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, formatted pivot tables.

Developed SQL queries to fetch complex data from different tables in remote databases using joins, database links and bulk collects.

Performed data cleaning and analysis using pivot tables, formulae (V – Lookup and others), data validation, conditional formatting, and graph and chart manipulation using Excel.

Involved in troubleshooting, performance tuning of reports and resolving issues within Tableau server and Tableau Desktop.

Worked on Data Wrangling to clean, transform and reshape the data utilizing NumPy and Pandas library.

Combined views and reports interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and end users.

Developed story telling dashboards in Tableau Desktop and published them on Tableau Server.

Imported data from various data sources and created automated reports in Power BI after cleaning and preprocessing the data.

Collected the data in excel sheets from different regions and integrated them in Power BI to know the loss and profit of the product.

Designed ETL packages dealing with different data sources (SQL Server, Flat files) and loaded the data into target data sources by performing various transformations using SQL Server Integration Services (SSIS). TECHNICAL SKILLS Programming Languages: C/C++, C#, Python, Core Java, SQL, PySpark. Databases: Oracle, SQL Server, MySQL, MongoDB.

BI Frameworks & Tools: Tableau, Power BI, Excel, Numpy, Pandas, Matplotlib, Jira, Git, Databricks. Software Development Methodologies: Waterfall, Agile (Scrum & Kanban). EDUCATION Master of Science: Computer Science Governors State University, Illinois, USA Jan 2021 – May 2022

Relevant Coursework: Project Management, Python, Advance Database Concepts, Dot Net, Java Programming, Big Data Analytics.

Bachelor of Technology: Computer Science & Engineering Malla Reddy Institute of Technology, India July 2015 – May 2019

Relevant Coursework: Programming (C/C#, Java), Database Management, Data Structures & Algorithms, Basics Of Cloud Computing, Object Oriented Programming, Probability & Statistics.

Contact this candidate