Information Technology Power Bi

Dinesh A

***********@*****.*** 512-***-**** www.linkedin.com/in/dkna

Education:

● Master of Science in Information Technology & Business Management / GPA: 3.79/4.00 Lindsey Wilson College, Kentucky, USA August 2022 – December 2023

● Bachelor of Computer Science / CGPA: 8.0/10

Acharya Nagarjuna University, Guntur, INDIA June 2018 – December 2021 Technical Skills:

● Programming Languages: Python (Pandas, NumPy, Scikit-learn), R, SQL, Shell Scripting

● Data Processing: PySpark, Apache Spark, ETL (Azure Data Factory, AWS Glue, Informatica)

● Data Analysis & Reporting: Excel (Pivot Tables, Data Modeling), Power BI, Tableau Big Data: HDFS,HIVE,Spark,Scala

● AI/ML: LLMs,NLP, Scikit-learn, TensorFlow, Keras Deep Learning:CNNs, RNN, LSTM

● Cloud Platforms & Databases:Azure (Blob Storage, Synapse), AWS (Glue, Athena, S3) and SQL Server, MySQL, PostgreSQL, Snowflake, Azure SQL, NoSQL Data Integration & Modeling: Postgres, Oracle, FAST, SAP ECC P08, SAP S4, SAP Ariba, EDI

● Data Engineering & Automation: Tools: Apache Spark, Airflow, Jenkins, Docker Version Control: Git

● GIS & Mapping: Tools: ArcGIS, QGIS Process Mapping & Documentation: Visio, Lucidchart, BPMN, Confluence

● Collaboration Tools: JIRA, Teams, Slack, Zoom, Google Docs, SharePoint Project Management: Agile, Basecamp, PowerPoint

● Operating Systems & Networking: Windows, Linux, MacOS and TCP/IP, DNS, DHCP, VPN, LAN/WAN

● SIEM & Security Tools: ArcSight, Splunk, Testing & Validation Tools: JIRA, TestRail,Web Development: Django,Node JS, Ruby

● Customer Support & Help Desk: Troubleshooting, Incident Management (ITIL), Support Workflow Management

● AnalyticsTools: Google Analytics, SEMrush, Statista Office Software: Microsoft Office (Word, Excel, PowerPoint, Outlook)

● Certifications: (MS Azure Data Engineer link ) (SOC Analyst ) Soft Skills:

● Communication Skills, Adaptability, Attention to Detail, Leadership, Problem Solving, Critical Thinking, Teamwork, Work Ethic, Curiosity, Analytical Thinking, Multitasking, Stress Management, Collaboration, Time Management, Emotional Intelligence,

● Conflict Resolution, Decision Making, Client/Customer Service, project Management, Business Acumen, Process Improvement, Stakeholder Management, Risk Management, Budget Management, Strategic Planning, Change Management, Decision Making, Vendor Management, Performance Monitoring, Resource Allocation,Business Analysis Experience:

Data Engineer / Analyst

Blueorigin Itstaffing, Remote January 2024 – Present

● Collected, cleaned, and processed data using ETL workflows with Python (Pandas) and SQL.Analyzed data, identified trends, and created reports using Excel and Power BI. Developed interactive dashboards in Tableau to present actionable insights.

● Wrote SQL queries to extract and manipulate data from relational databases (MySQL, PostgreSQL).Built predictive models with Python (Scikit-learn) to forecast business outcomes.

● Analyzed and visualized spatial data using GIS tools like ArcGIS and QGIS and creating maps and spatial reports. Collaborated with teams to understand business needs and share insights through Jupyter Notebooks. Automated repetitive tasks and data pipelines using Python and SQL

Founder / CEO

Saturnadkn, Austin, TX July 2024 – Present

● Business Strategy: Developed growth strategies, identified new market opportunities, and helped startups scale effectively. Product Development & Market Fit Assisted startups in refining products to match market needs and ensure scalability. Fundraising: Helped startups secure funding by refining business pitches and connecting them with investors.

● Mentorship & Leadership: Mentored founders in team building, leadership, and setting business goals.Operations Management: Improved operational efficiency by streamlining processes and setting performance targets.Networking: Built relationships with industry experts, investors, and partners to support startup growth.Financial Management: Guided financial planning, budgeting, and cash flow management for startup success. Risk Management: Helped startups identify potential risks and develop strategies to mitigate them.Sales & Marketing: Supported startups in developing sales strategies, marketing plans, and brand positioning Business Analyst

Lindsey Wilson college, Columbia, USA June 2023 – December 2023

● I assisted in gathering and analyzing business data, identifying trends and insights to support decision-making. I worked closely with stakeholders to gather and document business requirements, ensuring alignment with project goals. I collaborated with different teams to gather data and build reporting systems, providing real-time business insights.

● I helped create process flow diagrams and documentation to identify inefficiencies and suggest improvements. Additionally, I developed a Power BI Data Model using data from Postgres, Oracle, and FAST, and integrated data from SAP ECC P08, SAP S4, SAP Ariba, and EDI systems to enhance reporting and analysis.

● I prepared reports and dashboards to facilitate informed decision-making, supported the testing and implementation of systems, conducted market and competitor research, and ensure data integrity. I also contributed to continuous improvement initiatives and maintained detailed project documentation.

Junior Data Analyst

Rekindle Technologies, Bengaluru, India Aug 2022 – January 2023

● Worked with different teams to gather requirements and build data reporting systems for real-time business insights. Created Power BI data models using data from Postgres, Oracle, and FAST to support decision-making. Presented insights to executives through dashboards, offering data-driven recommendations.

● Built a new data mart in SQL Server to store data from multiple sources using SQL and ETL tools. Developed processes for extracting, transforming, and loading data from various sources with SQL. Worked with QA to fix data quality issues, improving data accuracy by 80%. Used Excel (Pivot Tables, VLOOKUP) to reconcile account values, reducing the risk of incorrect payments by 85%. Automated report deployment using Power BI web services, increasing efficiency by 40%. Support Analyst

Tech Mahindra, Hyderabad, India January 2022 – June 2022

● Provide technical support to customers via phone, email, and chat. Troubleshoot and resolve hardware, software, and network issues. Install and set up operating systems, software, and hardware. Apply software updates and security patches to systems.

● Manage user accounts and access permissions.Document issues and solutions in a ticketing system (e.g., ServiceNow, Jira). Deploy software and updates across the organization.Offer remote support to off-site or remote users.

● Track and manage IT equipment and software inventory.Work with other teams to resolve complex technical issues.

● Ensure security and privacy standards are followed. Assist with onboarding new employees and provide training. Communicate effectively with users to explain solutions. Follow up on open issues to ensure customer satisfaction. Projects:

Current Project (AI-Powered Visual Storytelling: Text-to-Image and Video Generation) Saturnadkn, Austin, TX

● This project will showcase your ability to combine different techniques in Generative AI and Deep Learning, creating a cutting-edge application that combines text-to-image generation with video synthesis. Designed and implemented a deep learning model capable of transforming descriptive text into detailed images and short video clips.

● Optimized model architecture to improve the accuracy and quality of generated visuals. Collaborated with a cross-functional team of engineers and designers to refine the user experience and visual output quality. Integrated real-time feedback loops to fine-tune the AI model’s output and user interaction.

Sales Forecasting Using Azure Synapse and Machine Learning Rekindle Technologies August 2022 – October 2022

● Developed a predictive sales forecasting model using Azure Synapse Analytics for data storage and Python for model training.Applied machine learning algorithms (Linear Regression and Time Series Analysis) to predict future sales based on historical data.

● Created data pipelines using Azure Data Factory for efficient data processing and integrated them with Power BI for data visualization.Presented forecasting results to stakeholders, enabling better inventory and demand planning. Big Data Analysis and Reporting Using Hadoop and Agile Methodology Lindsey Wilson College April 2023 – June 2023

● Developed a data analytics platform using Hadoop (HDFS, Apache Hive) to process large datasets and generate reports and Applied Agile methodology with bi-weekly sprints to deliver iterative solutions, improving report generation time by 30%. Cost-Effective Web Application on AWS

Lindsey Wilson College September 2022 – December 2022

● Developed a web application hosted on AWS, using EC2 for server hosting, S3 for storage, and RDS for database management.

● Implemented a serverless architecture with AWS Lambda and API Gateway for backend processing. Integrated IAM for secure access control and CloudWatch for monitoring,logging.

SIEM Implementation with ArcSight for Enhanced Security Monitoring SIEM Xperts August 2021 – December 2021

● Configuration & Setup: Installed and configured ArcSight Logger and ArcSight Manager to aggregate and analyze logs from various network devices and endpoints. Log Management to Create custom parsers and rules to efficiently process and categorize event logs from a variety of sources, including firewalls, intrusion detection systems (IDS), and application logs. and Incident Detection & Response for Designed and implemented correlation rules for identifying potential security threats,such as unauthorized access attempts and data breaches.

Contact this candidate