Software Developer Data Analyst

Karan Gaikwad

Jersey City, NJ - ***** *****.**********@*****.*** +1-551-***-**** LinkedIn GitHub

SUMMARY

Data Analyst and Software Developer skilled in business intelligence tools (Power BI, Tableau) and software development frameworks like Java, Spring Boot, and Flutter. Proficient in analyzing data, building predictive models, designing responsive applications, and optimizing systems. Experienced in data visualization, API design, and utilizing CI/CD tools for workflow automation. Holds an MS in Information Systems with a concentration in Data Science & Analytics, passionate about leveraging technology to solve complex problems, drive growth, and support data-driven decision-making.

EDUCATION

Pace University Seidenberg School of Computer Science and Information Systems New York, NY

Master of Science (MS) in Information Systems Concentration: Data Science & Analytics GPA: 3.74

Vishwakarma Institute of Information Technology Maharashtra, India

Bachelor of Technology (B. Tech) in Information Technology GPA: 9.21/10

PROFESSIONAL EXPERIENCE

Budget Wireless LLC, New York, New York Business Intelligence Developer May 2023 – Dec 2023

•Optimized SQL queries in Microsoft SQL Server, achieving a 90% improvement in report generation speed by designing efficient stored procedures and implementing advanced querying techniques.

•Developed and maintained APIs to support seamless data integration across platforms, enhancing software functionality and efficiency.

•Utilized SQL and advanced Excel functions (e.g., VLOOKUP, Pivot Tables) to create comprehensive business reports, improving the clarity and presentation of key insights.

•Designed interactive visualizations using Highcharts to monitor P&L, Sales, and Inventory metrics (e.g., Month-to-Date and Year-to-Date), driving data-informed decision-making.

•Built an end-to-end ticketing portal with HTML, CSS, C#, .NET Framework, and SQL Server, streamlining issue tracking and improving operational workflows.

•Enhanced client portals by enabling smooth data uploads and accelerating report generation through performance optimization using the .NET Framework and SQL Server.

•Collaborated with cross-functional teams, including project managers and accounting, to ensure accurate financial data handling and improve reconciliation processes within SAP.

IDeaS Revenue Solutions, Maharashtra, India Trainee – Associate Software Developer January 2022 – August 2022

Developed and improved system features using Java with Spring Boot and VAADIN frameworks, enhancing user interfaces and functionality to deliver a more intuitive and responsive user experience.

Independently implemented a module using Embedded Redis Server for cache management, replacing the existing system and significantly boosting data retrieval times.

Resolved 15+ automation test failures in collaboration with the QA team, ensuring robust functionality and smooth software performance.

Leveraged Jenkins CI/CD pipelines to automate build, test, and deployment processes, streamlining software delivery and enhancing workflow efficiency.

Completed 20+ user stories on schedule with a 100% efficiency rate, partnering with development and QA teams to evaluate and improve software systems.

Employed Git for version control, facilitating seamless collaboration and code management across development teams.

CTO-Ninja, Bangalore, India Flutter Developer March 2022 – May 2022

Developed two Android applications using the Flutter framework, contributing to both new UI development and enhancing existing Ul.

Heyoo Community App: Built the UI from scratch for this community-building app, where users can connect with others based on shared interests. Integrated Google Places API for location search, Stream Chat API for real-time messaging, and RESTful APIs provided by the backend team.

Maangal Matrimony App: Enhanced and upgraded the UI for an existing matrimony app tailored to the Garhwali and Kumaoni communities in Uttarakhand. Added new features, including integration of the Stream Chat API and RESTful APIs from the backend team.

Improved application stability by identifying and resolving over 10 critical bugs reported by the QA team.

ISKCON, Maharashtra, India Software Developer January 2021 – December 2021

•Developed REST APIs using Spring Boot for backend services, enabling seamless data integration and retrieval.

•Worked with MySQL for database management, optimizing queries and ensuring efficient data storage and retrieval.

•Executed quality assurance tests to discover errors and optimize usability.

•Coordinated with the senior developer to deploy the application on the Google Play app store.

•Led the migration of code from Flutter v1 to v2, which entailed changing the syntax and replacing the deprecated packages.

ACADEMIC /PERSONAL PROJECTS:

Data Engineering Pipeline Project:

Utilized Azure Data Factory to connect to on-premises SQL Server, copying all tables to the Bronze layer of Azure Data Lake Gen2.

Developed ETL pipelines with Azure Databricks to transform raw data into cleaned datasets in the Silver layer and enriched data in the Gold layer.

Integrated Azure Synapse Analytics for advanced data analytics and reporting, enabling high-performance queries and seamless integration with Power BI.

Implemented governance measures using Azure Key Vault to ensure data protection and regulatory compliance.

Inventory Management System:

Developed an Inventory Management system using Spring Boot for efficient tracking of inventory levels, orders, and product information.

Created REST APIs for CRUD operations, ensuring seamless data manipulation.

Established a CI/CD pipeline using Jenkins and Docker to automate build, test, and deployment processes.

Integrated Git push triggers via webhooks for seamless updates and deployment on AWS EC2 instances.

King County Housing Market Analysis:

Analyzed housing market data using MS Excel, developing a predictive regression model to identify pricing trend drivers.

Validated hypotheses on waterfront property impact and house age, generating actionable insights.

Flight Delay Prediction:

Integrated and cleaned five years of flight data, adding a delay classification column.

Utilized RapidMiner to develop and evaluate models, selecting the Decision Tree Model for accurate delay prediction.

Electric Consumption Analysis:

Conducted descriptive analysis of electric consumption data across New York City's boroughs.

Created graphs depicting electricity consumption and costs.

Developed a predictive model for forecasting electricity consumption.

Car Sales Dashboard Development:

Created a dynamic Car Sales Dashboard using Power BI to track and analyze KPIs such as YTD Total Sales and Average Price Analysis.

Used DAX to create measures for accurate sales metrics calculation, ensuring real-time insights.

Designed various data visualizations (line charts, pie charts, map charts, grids) to illustrate sales trends and distribution.

Provided actionable insights into car sales performance, enhancing decision-making and identifying growth opportunities.

Contact this candidate