Project Management Information Technology

DILEEP DURGAM

Dekalb, IL +1-224-***-**** **************@*****.***

SUMMARY

Dedicated master’s student in Information Technology, equipped with a strong foundation in SQL, SAP, project management, Tableau, Wireshark, and Python. Eager to contribute my skills and knowledge to a dynamic and growth-oriented environment. Despite being in the early stages of my career, my academic pursuits have cultivated a robust skill set and a fervent passion for leveraging technology to address complex business challenges.

TECHNICAL SKILLS

Programming Languages: SQL, Java, C++, Python.

Databases: Oracle, MS SQL Server, IBM DB2, Teradata.

Tools: Power BI, OSI PI, Databricks, Docker, MS Flows, MS Power Apps, Git.

Cloud: AWS s3, Glue, Glue Catalog.

Additional Tools and Technologies: SAP, Project Management, Tableau, Wireshark, Python

WORK EXPERIENCE

Project 1 Tableau Project: Data Analysis of E-commerce Trends Jan 2024

Utilized Tableau to conduct exploratory data analysis on a dataset sourced from NewChic.com, analyzing 100,000+ records.

Combined and cleaned multiple datasets covering Men, Women, and Kids categories, resulting in a 10% reduction in data inconsistencies.

Developed 5 interactive dashboards to analyze product categories, pricing trends, discounts, and consumer preferences.

Visualized key metrics such as product likes, brand popularity, and color preferences, driving a 15% increase in user engagement.

Identified patterns in consumer behavior, enabling stakeholders to optimize product offerings and marketing strategies, resulting in a 20% improvement in targeted marketing campaign performance.

Project 2 SQL Database Development – Art Gallery Database Jan 23 – May23

Designed and implemented a relational database for an art gallery, consisting of 5 key tables (ARTIST, CUSTOMER, WORK, TRANS, and CUSTOMER_ARTIST_INTEREST) to store and manage artist, customer, transaction, and artwork data with over 10,000 records.

Created robust relationships between tables using primary and foreign keys, ensuring data integrity and reducing redundancy by 25%.

Executed complex SQL queries, including joins and aggregations, for operational tasks such as counting customers per artwork, identifying customer interest in artists, and calculating cumulative transaction values.

Improved sales insights by identifying high-interest customers, generating a 15% increase in targeted marketing effectiveness.

Optimized financial reporting by calculating the maximum transaction value and cumulative art pricing per artist, enhancing revenue forecasting by 20%.

Developed data reports for executive teams, detailing high-value transactions over $4000 and customer purchases within specific date ranges, improving business decision-making by 30%.

Managed large datasets, handling up to 10,000 rows of data across the database tables, ensuring accurate and efficient data retrieval through indexing and query optimization, reducing query execution time by 40%.

Project 3 Python Data Analysis & Automation – Sales Performance Dashboard June23-Dec 23

Developed a Python-based sales analysis tool that processes and analyzes large datasets (over 50,000 rows of sales data) from CSV files using Pandas, enabling automated reporting of key sales metrics.

Implemented data cleaning and transformation processes, handling missing values, duplicates, and formatting issues, improving data quality by 95%.

Designed custom visualizations using Matplotlib and Seaborn to present sales trends, top-performing products, and monthly revenue growth, resulting in more data-driven decision-making.

Visualized monthly revenue trends, which helped the sales team identify a 12% increase in seasonal product sales.

Automated report generation with Python scripting, reducing manual data processing time by 50% by scheduling daily and weekly updates through a cron job.

Optimized performance by refactoring code to reduce runtime by 30%, enabling real-time analysis for key stakeholders.

Integrated the tool with Google Sheets API, enabling real-time updates and collaborative reporting with the broader team.

LICENSES & CERTIFICATIONS

Introduction to Cybersecurity - Cisco

Data Analytics Essentials - Cisco

PCEP – Certified Entry-Level Python Programmer - Python Developer

EDUCATION

Master of Science, Information Technology Dec 2024

Northern Illinois University, Dekalb

Bachelor of Technology, Computer Science July 2022

Jawaharlal Nehru Technological University, India

Contact this candidate