PREM KUMAR BALE

linkedin.com/in/prem-kumar-bale +1-571-***-****

https://github.com/PremKumarBale ad2ntp@r.postjobfree.com PROFESSIONAL PROFILE

Data Analyst with two years of experience, skilled in extracting and interpreting complex data to deliver impactful business intelligence and insights. Adeptly balances technical expertise in SQL, Python and cloud-based analytics with a strategic understanding of data-driven optimization and cross-functional collaboration. Proven ability in ETL development and data visualization, driving operational improvements and informed decision-making. CORE COMPETENCIES

Data analysis & Interpretation Business Intelligence & Visualization Data Engineering & ETL development Cloud Architecture & System Design Cross-functional Team Collaboration Software Lifecycle Management TECHNICAL SKILLS

Programming Languages: SQL, Python, R Database Technologies: MySQL, PostgreSQL Data Manipulation and Analysis: NumPy, Pandas, MS Excel ETL Tools: Alteryx, AWS Glue Data Visualization: Tableau, AWS QuickSight, MS PowerBI, Matplotlib Cloud Computing & Management: AWS, Kubernetes Project Management: Jira, Scrum, Kanban Machine Learning Libraries: scikit-learn EDUCATION

Master of Science in Business Analysis – University of North Texas, Denton, TX CGPA: 3.70

• Foundations of Data Management, Data Warehousing, Data Mining, Business Process Analytics, Predictive Analysis & Modelling, Visualization with Tableau, Model Based BI, Information Systems Design. Bachelor of Commerce (Foreign Trade) – EThames Degree College, Osmania University, India CGPA: 8.44

• Business Statistics, Cost Accounting, Managerial Accounting, Marketing & Advertising for Int’l Business, Cross- Cultural Consumer Behavior, Foreign Trade financing Procedures, Elements of Export Marketing. EXPERIENCE

Cloud Engineering Intern Overhead Door Corporation (May 2023 – July 2023) Dallas, TX, USA A Leading Provider of Innovative residential and commercial door solutions specializing in Manufacturing and distributing wide range of high-quality garage doors.

• Collaborated with a cross-functional team to develop custom software solutions for device management and optimization in residential and commercial settings, utilizing AWS EC2 and AWS Lambda for scalable computing and serverless architecture.

• Designed and deployed robust cloud infrastructure using AWS services, including AWS Glue for ETL processes, AWS DynamoDB and AWS RDS for database management, and AWS S3 for data storage, ensuring scalability and robustness.

• Enabled enhanced visibility and monitoring on 500k devices, facilitating operational status analysis and usage pattern tracking.

• Constructed and managed ETL pipelines in AWS Cloud to enable seamless data integration and processing, leading to more efficient data handling.

• Developed dynamic operational performance dashboards in Amazon QuickSight, using SQL to showcase device performance metrics and operational trends, allowing for real-time decision-making and operational adjustments.

• Documented software designs and collaborated with senior developers and QA engineers to maintain high software quality standards.

Environment: AWS Glue, AWS DynamoDB, AWS S3, AWS RDS, AWS Lambda, AWS EC2, Amazon QuickSight, SQL. Process Specialist Amazon India Development Centre Pvt. Ltd (Aug 2021 – May 2022) Hyderabad, India Relay Operations Centre, Amazon is the pivotal hub for orchestrating and optimizing logistics Operations. It employs Advanced Data Analysis and Visualization tools to forecast demand, allocate resources & create dynamic dashboards.

• Leveraged AWS Lambda for serverless data processing, enabling the execution of code in response to high-velocity data streams to identify trends and forecast demand effectively using SQL & Python.

• Spearheaded data automation projects on AWS EC2 instances, optimizing the data collection and reporting processes and ensuring scalable, on-demand computational resources that resulted in increased accuracy.

• Utilized powerful BI tools such as Amazon QuickSight and Power BI to create insightful reports and dynamic dashboards, facilitating the communication of Key Performance Indicators and critical business metrics to internal stakeholders.

• Managed project workflows and team collaboration efficiently using Jira, to document requirements, track updates, and streamline feedback on various tools and processes.

• Contributed to the enhancement of user experience and functionality of Relay systems, by assisting in the development of tools and software for operational support, including tracking and operational systems.

• Provided comprehensive training and support to Relay System users, ensuring they could effectively leverage platforms like AWS, SQL databases, and BI dashboards, with the aid of thorough documentation and user guides maintained in MS Excel. Environment: AWS Lambda, AWS EC2, SQL, Python, Jira, Amazon QuickSight, Power BI, MS Excel. Trade Specialized Compliance Customs Analyst Brokerage Cargomen firm dedicated Logistics to expediting Pvt. Ltd Cross- (Oct border 2020 trade, – July facilitating 2021) Customs Clearances Hyderabad, and Regulatory India Compliance for IT Companies in Special Economic Zones (SEZs) and IT Parks.

• Ensured Swift Customs Clearances for Imports by IT Companies facilitating seamless Cross-border Operations and Managed end-to-end Domestic Tariff Area (DTA) Procurement of IT accessories from local vendors.

• Oversaw Customs regulatory Compliance by filing financial reports i.e. Monthly Performance report (MPR), Software Export Reporting form (SERF) & Software Exports (SoftEx).

• Oversaw the reconciliation of customs duties and taxes, utilizing financial reporting to maintain accuracy in trade-related expenses and budget forecasts.

• Integrated compliance data with financial analytics to provide a holistic view of the company's trade operations, facilitating informed decision-making and risk management.

• Collaborated with cross-functional teams to develop financial risk assessment models, identifying potential compliance issues and mitigating financial exposure in international trade transactions. CERTIFICATIONS & LICENSES

• Completed Agile Project Management certification from the prestigious University of Colorado Lockheed Martin Engineering Management Program.

• Completed JIRA Scrum Certification with hands-on learning from Coursera Project Network.

• Completed Cloud Computing Foundations & Cloud Virtualization, Containers and APIs Certifications from Duke University.

PROJECTS & RESEARCH PAPERS

Enhanced Operational Analytics for Smart Door Systems May 2023 – July 2023

• The project focused on providing operational analytics for Company’s fleet of garage door opener devices which lacked performance visibility. My role involved collaborating with a cross-functional team to design and deploy AWS cloud infrastructure and robust ETL pipelines,

• Utilizing AWS services like Glue, S3, Athena and QuickSight, I created dynamic dashboards that offered real-time performance metrics, significantly improving the monitoring & analysis capabilities for both residential and commercial doors. Dynamic Resource Allocation System for Trailers (Amazon Asset Portal) Oct 2021 – May 2022

• The project was initiated to improve Operational efficiency and aimed to utilize cloud-based technologies and advanced data analytics to create a responsive logistics framework capable of real-time resource allocation.

• My role involved developing algorithms for demand forecasting and resource allocation, integrating analytics with visualization tools and automating the reporting processes. The project resulted in improved operational decision-making, resource optimization, and a marked increase in overall logistical efficiency. Research Paper “Ride Hailing Optimization and Customer Preference Analysis” Aug 2023 – Dec 2023

• Identified critical pricing influencers for ride-hailing services with differentiation between Uber and Lyft's pricing structures & analyzed the impact of external factors like weather conditions on customer ride preferences and dynamic pricing models.

• Conducted a multifaceted analysis utilizing regression and segmentation analysis to understand customer choice determinants & offered strategic recommendations for ride-hailing companies to enhance customer service while maintaining profitability. SPORTS, HONORS & COMMUNITY INVOLVEMENT

• Represented Indian Delegation in Asia World Model United Nations-II held in Thailand.

• Selected to participate in prestigious National Adventure Camp, Scouts & Guides, India.

• Selected to participate in Mountaineering Camp, Nehru Institute of Mountaineering, India.

• Represented my District at the State Basketball Tournament, India.

• Completed NCC(Airforce) - A Certificate with ‘A’ Grade.

• Volunteered as College Student Mentor at Indian Development Foundation.

• Volunteered as Content Creator & Blogger at a Heritage Trails Group called Hyderabad Trails.

Contact this candidate