James Freire Email & Phone Number

Atlanta, Georgia, Us

• Established foundational data engineering and analytical workflows for the Enterprise Planning & Tooling team, empowering them to drive standardized development practices across all Home Depot's balanced teams.• JIRA Data Democratization: Designed and implemented ETL processes to extract and transform data from Atlassian Enterprise Insights to support sprint planning standardization and enhance data accessibility across teams at Home Depot. Utilized GCP Data Fusion, Python, Git and internal tools. • JIRA Issue Update Automation: Developed a Python-based automation tool to query Atlassian Enterprise Insights, evaluate JIRA issue conditions, and update JIRA issues via API. Integrated interactive and dry-run modes for change previews and detailed logging for tracking modifications across product teams.• SQL Database ETL Automation: Developed Python code to interact with SQL databases using SQLAlchemy and pandas, automating data extraction and transformation with configuration files.• Compliance Dashboards for Sprint Practices: Built compliance dashboards in Tableau to ensure teams follow standardized sprint practices in JIRA, facilitating process adherence and accountability.• Standardized Git Workflow Documentation: Authored a comprehensive document outlining a standardized Git workflow to enhance consistency and collaboration within an internal team.

Washington, District Of Columbia, Us

Combined my extensive AWS and R experience to help Fannie Mae transition their on-premises analytics platform to the cloud. Worked with business teams to capture requirements, reverse engineer current ETL processes, and plan migration with updated tools and data flows. • Developed ETL code in R to drive analytics reporting utilizing Redshift and Oracle RDS. Leveraging R to efficiently transform raw data into actionable insights for decision-making.• Transitioned the risk analytics reporting platform to AWS with RStudio and SageMaker. This migration ensures enhanced scalability, flexibility, and efficiency in data analysis and reporting processes.• Deployed and managed Redshift instances to facilitate efficient data sharing and collaboration within the organization. • Programmed Redshift queries in R, leveraging ODBC connections to efficiently extract, transform, and load data for ETL processes.

Seattle, Wa, Us

• Advised AWS Security on best practices and leveraging AWS cloud for reporting.• Developed ETL dataflows with AWS Glue for data transformation and ingestion.• Delivered data modeling and developed data infrastructure in AWS Redshift.• Created capacity planning forecasting models and developed dashboards in Tableau.

Austin, Texas, Us

• Optimized customer-facing ticketing processes and helped reduce TTR by 40% via statistical analysis in R.• Developed random forest classification and regression models in Scikit-Learn for root cause, ticket severity classification and incident TTR.• Delivered A/B statistical tests for data center air temperature monitoring, and discovered 10%+ accuracy discrepancies in monitoring equipment.• Delivered statistical analysis and data collection, improving efficiency and reducing data center operational risks. Expert in delivering insights from disparately sourced data and creating compelling visual stories for a wide audience.• Delivered executive KPI reports and dashboards using R, ggplot2, and Oracle Analytics Cloud.• Writes ETL software in Python and Pandas to extract data from ticketing, monitoring, and facilities APIs and other Oracle databases.• Performs failure rate probability forecasting for rack, server, and facility electrical components.

Austin, Texas, Us

Seattle, Wa, Us

● Spearheaded the development and implementation of an innovative iPad-directed workflow tool, revolutionizing facility checks across all of Amazon's AWS data centers. Orchestrated deployment and management of the tool across multiple US facilities, resulting in enhanced uptime and a significant reduction in facility outage risks.● Utilized advanced statistical techniques and regression models in Scikit-Learn, to optimize guided workflows for engineers involved in mechanical maintenance. By leveraging data-driven insights, achieved notable improvements in efficiency and effectiveness.● Devised and executed robust data processing and ETL workflows to facilitate seamless collection of performance metrics and monitoring data for AWS Data Centers. Leveraged cutting-edge technologies such as AWS Lambda (Java, Python), S3, Redshift, and EC2 instances to ensure efficient and accurate data acquisition.● Pioneered the development of an internally available custom skill called 'Alexa for the Data Center.' This groundbreaking solution empowered users to obtain real-time AWS data center performance metrics, including PUE, progress updates, and ticket information, by utilizing the Amazon Echo device.● Led the implementation of data collection workflows aimed at consolidating Amazon's BMS and EPMS control system data into a centralized Redshift data warehouse. This initiative enhanced data accessibility and streamlined decision-making processes.● Designed and implemented a comprehensive Power Utilization Effectiveness dashboard with Ruby on Rails. The dashboard provided key performance metrics and seamlessly integrated with AWS Redshift, while also offering a REST API for internal users.● Led instructional training sessions for Amazon Women in Engineering, imparting valuable knowledge in software development.● Served as a mentor in the Amazon Mentorship program, guiding and supporting junior developers in their professional growth and skill development.

Stamford, Ct, Us

Created statistical analysis and reports in R to forensically examine legacy Solaris infrastructure for transition to Redhat Enterprise Linux• Created statistical reports generated with SQL and R on client Intranet usage. Utilized keyword usage analysis of Apache logs.• Programmed Perl scripts to automate user and data migration from Solaris to Linux virtual hosts.• Transitioned Gartner’s Development, Testing and Production servers from Solaris to Redhat Enterprise Linux running on VMWare ESX hosts.

Stamford, Connecticut, Us

Successfully managed and traded the SAC Select Fund, a systematic quantitative long/short strategy with assets totaling $250,000,000 in gross market value. Demonstrated expertise in overseeing technical development, trading execution (implementation shortfall), and reconciliation processes.● Conducted extensive research to develop and implement effective trading strategies and hedging scenarios. Utilized rigorous backtesting techniques to analyze the performance and viability of these strategies. Specialized in algorithmic transaction cost analysis to optimize trading outcomes.● Demonstrated proficiency in overseeing back-office reconciliation tasks, ensuring accurate and timely reporting of portfolio performance on a daily and weekly basis.● Executed trades across equity cash/swap and options within 50 distinct trading accounts. Leveraged platforms such as Credit Suisse AES, Morgan Stanley, Goldman Sachs, and Liquidnet to execute trades efficiently and effectively.● Achieved a significant reduction of 45% in daily execution slippage, decreasing from over 7 basis points (bps) to below 4 bps. Accomplished this through meticulous trade analysis and customization of algorithms. Leveraged R, Python, TAQ, and SQL for comprehensive research and analysis.● Thoroughly documented all aspects of the trading platform, including strategy rules and daily, weekly, and monthly operating procedures. Ensured clarity and transparency in the trading process.

Stamford, Connecticut, Us

Internship within the technology department and then on the execution trading desk. Eventually, my work would land me directly on the trading desk.

• Led the development of an integrated VoIP PBX product utilizing Asterisk on Redhat Linux, ensuring seamless functionality and performance.• Streamlined the Asterisk configuration process by centralizing it into MySQL and implementing a custom PHP front-end management screen served with Apache. This innovative approach eliminated the need for configuration flat files, enhancing efficiency and ease of management.• Designed and implemented a hosted PBX solution tailored for small-office clients. Leveraged the SIP protocol to connect client telephones to our main servers, which then routed calls to wholesale trunked telephone lines, optimizing communication workflows.• Implemented Nagios company-wide for comprehensive monitoring of Linux systems, enabling proactive identification and resolution of issues across the infrastructure.• Successfully managed a diverse infrastructure of 20+ servers, encompassing Redhat Linux, Debian, and Gentoo systems, for remote and hosted PBX environments. Oversaw day-to-day operations and ensured optimal performance and reliability.• Employed expertise in building Redhat Linux Fedora Core systems on Dell hardware, providing robust PBX servers capable of meeting demanding requirements.• Enhanced PBX capacity, performance, and redundancy by implementing a Storage Area Network (SAN) with QLogic HBAs and Brocade switches. This infrastructure upgrade resulted in improved scalability and reliability.• Conducted installations of PBX systems, programmed Adtran and Rhino channel banks, and performed punch downs of 110/66 blocks, ensuring smooth deployment and functionality.• Orchestrated the installation of T1/T3 lines to customer sites, establishing telephone connectivity to PBX systems and enabling seamless communication for clients.

Us

Conducted comprehensive testing of UNIX systems to ensure Fibre Channel Protocol compatibility and optimal I/O performance. Testing focused on Inrange FC/9000 SAN switches, storage arrays, and HBAs (Host Bus Adapters).• Regularly installed and configured SAN networks for testing purposes, providing a reliable environment for accurate evaluations.• Executed SAN testing on IBM AIX5/L on pSeries (650, 655) and xSeries (345, 206) servers. This involved installing and booting AIX via SAN and monitoring performance throughput using traditional command line tools such as nmon, vmstat, topas, and iostat.• Conducted testing on various SAN switch products, including EMC, Brocade, Cisco, McData, and QLogic, to ensure seamless integration and compatibility.• Tested the throughput capabilities of FC/9000 with leading storage arrays such as EMC Symmetrix, IBM Shark, Hitachi Thunder, and Clariion, providing valuable insights into system performance.• Developed testing procedures and authored documentation to certify products with the FC/9000, ensuring adherence to industry standards and compatibility requirements.• Proficiently utilized Finisar Fibre Channel Protocol Analyzer to troubleshoot Fibre Channel protocol issues between HBAs, switches, and storage arrays, resolving connectivity and performance challenges effectively.• Acted as a representative of Inrange in interoperability testing events with FCIA (Fibre Channel Industry Association), demonstrating expertise and promoting seamless integration of Fibre Channel technologies.• Tested SAN connectivity for IBM zSeries IC4 Mainframes running Redhat Linux using Inrange FC/9000 SAN switches with IBM Shark storage arrays. Responsible for performing Linux installations on IBM Mainframe LPAR (Logical Partitions) and ensuring proper physical ESCON/FICON wiring setup.

Provided fractional T1 internet service to local companies from my own home.

Successfully managed a diverse infrastructure of over 50 servers (Solaris 8, Irix 6.5) dedicated to processing electric utility meter data for bill processing. Ensured uninterrupted operations to process daily utility meter data worth over $500,000 for utility providers Pepco and Exelon.• Oversaw the management of bill processing systems, encompassing Solaris 8 (E220, E420) and Irix 6.5 (Origin 200, 2000) servers, integrated with Oracle 8i and Informix databases.• Designed and executed scalability testing for a 1 million customer database and bill processing system for American Electric Power. This involved thorough testing on Solaris 8 and Oracle 8i to ensure seamless performance and handle increasing data volumes.• Employed SNMP monitoring to assess UNIX system performance, with results centralized and analyzed on an MRTG server. Leveraged command line tools such as SAR, vmstat, iostat, and netstat to maintain optimal performance across individual servers.• Implemented Big Brother as a comprehensive monitoring solution for critical bill processing system uptime, complemented by custom-written Korn and Bash shell scripts to streamline monitoring processes.• Authored comprehensive disaster recovery documentation for all bill processing servers, ensuring a well-defined plan to minimize downtime and expedite recovery in case of unforeseen events.• Orchestrated the deployment of bill image storage servers, establishing SSH tunnel connectivity to Ohio for seamless Samba sharing across Linux and Windows platforms.• Introduced Arkeia as a robust backup solution for a centralized NAS RAID5 storage system running Linux, guaranteeing data integrity and facilitating efficient recovery processes.

Assumed responsibility for website updates and diligently ensured adherence to rigorous performance, stability, and quality standards.• Executed timely and accurate website updates on Solaris 7 servers (E6500, E10000) hosting Vignette Story Server and Netscape Enterprise Server. Leveraged custom-written Perl scripts to streamline the update process and maintain optimal server performance.• Revamped quality assurance testing procedures, optimizing the transition of code from the testing environment to production. Played a pivotal role in guaranteeing seamless code integration and deployment.• Conducted comprehensive stability testing of code in the testing environment using Load Runner 6.5. This meticulous testing approach ensured the reliability and resilience of the website's codebase.• Orchestrated the successful migration of iWon.com from Doubleclick banner-ad hosting to in-house image server clusters. Implemented round-robin DNS for load balancing, resulting in annual savings of $250,000 while maintaining optimal performance and user experience.

B.A, History

Education record