Suggestions
James McCloskey
EV Analytics Project Manager at San Diego Gas & Electric
Professional Background
James McCloskey is an accomplished engineer with a passion for utilizing data to tackle complex problems and drive operational excellence. With a robust background in data analytics, business intelligence, and SQL databases, James has honed his skills in various domains, including project management and ad hoc problem-solving. He has amassed a wealth of experience through his work in prestigious organizations, particularly at San Diego Gas & Electric, where he held several impactful positions ranging from Project Manager to Business Systems Analyst.
At San Diego Gas & Electric, James served as the EV Analytics Project Manager, where he spearheaded projects aimed at optimizing electric vehicle infrastructure through data-driven insights. His previous roles at the same organization equipped him with unique insights into business systems, allowing him to blend technical expertise with strategic decision-making. As a Senior Business Systems Analyst and IT Business Systems Analyst, he was instrumental in implementing efficient data management practices, fostering strong relationships with stakeholders, and ensuring that the organization’s data needs were not only met but exceeded.
In addition to his tenure at San Diego Gas & Electric, James has enriched his professional portfolio as a Senior Data Analyst at Harbor Freight Tools, where he leveraged his analytical skills to enhance business operations. His experience as a Database Programmer and AutoCAD Technician at Guida Surveying laid the foundation for his technical expertise in database management and engineering principles.
Education and Achievements
James McCloskey pursued a well-rounded education that combines technology, science, and management. He earned a Bachelor of Science degree in Cognitive Science along with a Bachelor of Arts in Engineering Management from the University of California, San Diego. His academic journey continued at California State University-Northridge, where he obtained a Master’s Degree in Manufacturing Engineering. This diverse educational background empowers James to approach engineering challenges with a multifaceted perspective, making him a versatile asset in any data-centric environment.
In addition to formal degrees, he has completed the Technology Business Creation Certificate at the University of California, San Diego Extension. This program provided him with specialized knowledge in identifying and utilizing business opportunities within technological frameworks, further enhancing his capabilities as a data expert and project manager.
Technical Proficiencies
James is a proficiency powerhouse when it comes to working with various databases. His experience with SQL Server, Oracle, PostgreSQL, Access, and DB2 allows him to write complex queries, views, Common Table Expressions (CTEs), stored procedures, and scripts. One of his remarkable achievements includes managing a colossal table with an impressive 950 million records, demonstrating his capacity to handle vast datasets effectively. He applies best practices in database normalization and indexing to enhance efficiency and data retrieval processes.
In the realm of data analytics, James skillfully utilizes Excel and VBA, crafting intricate formulas that utilize functionalities such as INDEX MATCH, VLOOKUP, IF, nested IFs, and array formulas. His ability to set up pivot tables and utilize the Analysis ToolPak highlights his analytical acumen. James is particularly known for designing insightful dashboards and reports, providing senior management with essential visibility to facilitate informed decision-making in finance, forecasting, inventory allocation, supply chain management, and procurement.
Working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) further enhances James's portfolio. He adeptly builds, processes, and automates data flows to enhance operational efficiency within organizations. His experience includes scheduling SQL server jobs to run overnight and developing automated error reporting systems embedded in emails. Whether executing SQL code, creating parameterized reports, or developing ad hoc reports, James's expertise ensures that data workflows are seamless and reliable.
Additionally, James possesses programming skills in C#, .NET, and PowerShell, allowing him to create custom scripts that interface with other Windows applications. This capability not only showcases James's technical depth but also his innovative approach to problem-solving, where he devises solutions that go beyond reliance on pre-existing tools.
Achievements
James McCloskey’s career is characterized by a series of significant contributions that highlight his commitment to excellence and innovation in engineering and data analysis. At San Diego Gas & Electric, his leadership on the EV Analytics Project has been noteworthy, where his insights and analytics have contributed to shaping the future of electric vehicle integration within the community.
His efforts in building comprehensive dashboards and implementing effective data management practices have streamlined decision-making processes within the organizations he has served. The visibility gained from his reports has empowered senior management to make informed strategic decisions that drive growth and optimize resources.
In addition to his technical and analytical contributions, James’s collaborative spirit and dedication to sharing knowledge have made him a respected figure among his peers. His ability to translate complex technical concepts into understandable terms for non-technical audiences showcases his unique blend of skills—combining technical know-how with exceptional communication abilities.
James McCloskey continues to pave the way for innovative data usage in engineering projects, establishing himself as an influential figure in the realm of data-driven decision-making and engineering management. His dedication to solving difficult problems with precision and insight positions him as a valuable asset in any team-oriented environment.
