I collaborated closely with cross-functional teams primarily focusing on optimizing database performance, maintaining codebase quality, and resolving technical issues. My key responsibilities included:
Database Management & Optimization: Developed and implemented database models and queries in alignment with the dynamic needs of tech and product teams. Constantly sought innovative strategies to enhance database and query performance, ensuring optimal functionality.
Codebase Quality Assurance: Upheld a high-quality standard throughout the codebase by actively participating in comprehensive peer review processes for all database and query-related changes, contributing detailed pull request (PR) reviews.
Issue Resolution & Collaboration: Worked in tandem with tech and product teams to promptly investigate and resolve issues as they emerged, fostering a collaborative environment for efficient problem-solving.
Utilizing Blockchain-Derived Data Structures: Managed databases housing information derived from blockchain data across Ethereum mainnet and two other testnet blockchains. This was done utilizing tools like Postgresql, Prisma, and Datadog for effective database management and monitoring as well as optimizing data models and queries for efficient operations.
Collaboration & Tech Stack: Collaborated extensively with backend engineers, ensuring alignment with GraphQL, and REST API. While my primary focus was on database administration I maintained an awareness of broader tech components, such as Nest, Redis, AWS, Helm, ArgoCD, Tenderly, Jest, Swagger, Docker, and BullMQ, contributing to a comprehensive understanding of the overall tech ecosystem.
My proficiency in technologies like Postgresql, Prisma, Datadog, and Git, coupled with a deep understanding of backend technologies, enabled me to effectively contribute to the success of the team.
As a data analytics consultant specializing in blockchain and NFTs, I collaborated with clients to provide valuable insights and dashboards utilizing Dune Analytics. Key responsibilities and achievements included:
Query Development: Developed complex queries using PostgreSQL, SparkSQL, and most recently DuneSQL within Dune Analytics to extract insights on price trends, trading activity, NFT sales, and more. Utilized advanced SQL methodologies to analyze blockchain data effectively, enhancing query performance and extracting valuable insights.
Visualization Creation: Utilized Dune Analytics' visualization tools to create informative charts and tables, including bar, pie, scatter, line, and area charts, to present data-driven insights in a visually compelling manner.
Client Collaboration: Engaged with clients, including individuals and management from large companies within the NFT and crypto/blockchain industry, to understand their analytics needs. Tailored queries, dashboards, and visualizations to meet their specific requirements and preferences.
Networking and Communication: Built a network within the NFT and crypto/blockchain industry, collaborating with individuals and companies ranging from startups to AAA-style video game developers. Facilitated effective communication to ensure alignment with client objectives and preferences.
My freelance experience involved providing actionable insights and customized analytics solutions to clients in the blockchain and NFT space, contributing to informed decision-making and strategic planning.
As a Database Administrator at American Public Resource, I played a pivotal role in managing our databases using Microsoft SQL Server's RDMS solution, focusing on SQL programming development. Key responsibilities and achievements included:
SQL Development Proficiency: Spearheaded SQL programming development encompassing the creation of stored procedures, views, triggers, and functions within the Microsoft SQL Server environment, ensuring optimized data retrieval and manipulation.
Database Management & Optimization: Managed and maintained databases, adeptly implementing modifications and updates to enhance database structures and optimize data performance. Diligently monitored system performance, swiftly identifying and resolving any arising issues to uphold uninterrupted operations.
Data Handling Expertise: Demonstrated comprehensive expertise in all facets of data handling, exhibiting proficiency in data standardization, normalization, and manipulation. Profoundly engaged with vast data sets, including managing voter records comprising millions of rows and handling raw data efficiently.
Communication & Efficiency: Facilitated efficient dialing and marketing operations through effective communication with management and the call controller, ensuring seamless coordination to optimize outcomes and performance.
Throughout my time as a database administrator I showed a dedication to maintaining robust database structures, optimizing data handling processes, and fostering efficient communication channels crucial for streamlined operations and successful marketing endeavors.
As a Script Developer at American Public Resource, I specialized in crafting sophisticated scripts to automate telephone calls for political and charitable fundraising campaigns. My responsibilities encompassed:
Script Automation Expertise: Developed intricate scripts tailored to automate telephone call processes, playing a crucial role in optimizing fundraising initiatives. These scripts were meticulously designed to streamline operations and enhance campaign efficiency.
Server Auditing & Maintenance: Managed and maintained a multitude of Windows and Linux servers, ensuring their seamless performance and reliability. Conducted rigorous audits to uphold server integrity, ensuring uninterrupted campaign activities.
Collaborative Project Execution: Orchestrated projects necessitating cross-functional collaboration with team members and management. Fostered a collaborative environment to ensure seamless integration of scripts and alignment with overarching campaign objectives.
My tenure was marked by a commitment to crafting sophisticated automation solutions, maintaining server infrastructure, and fostering collaborative efforts to drive successful fundraising campaigns.
As a 3D artist I was integral to the creation and optimization of 3D assets for mobile games, employing Blender to craft immersive environments, characters, props, and more. My responsibilities included:
Comprehensive 3D Asset Creation: Produced a wide array of 3D assets utilizing Blender, contributing to the visual richness of mobile games. This encompassed the creation of environments, characters, props, and various elements vital to captivating gameplay experiences.
Rigging, Animation, and Texturing: Demonstrated proficiency in rigging and animating models, bringing them to life with dynamic movements. Additionally, applied texturing expertise to enhance the visual appeal of all 3D assets, ensuring a cohesive and engaging game environment.
Image Rendering for Games and More: Leveraged experience in rendering high-quality images for in-game use and external promotional content.
Optimization for Mobile Devices: Played a crucial role in optimizing all assets to meet the varied specifications of mobile devices, ensuring seamless performance across different platforms. This required a meticulous approach to balancing visual quality with performance efficiency.
Collaboration Across Teams: Navigated a collaborative landscape by working closely with developers, product managers, and community managers. Engaged in the creation of promotional content, fostering a cohesive relationship between the creative and technical aspects of game development.
3D Modeling Software/Game Engine Pipeline: Developed a deep understanding of the pipeline between 3D modeling software and game engines, facilitating seamless integration of assets into the gaming environment.
In my role I was at the forefront of driving creativity and optimization in the production of 3D assets for mobile games. The collaborative spirit shared with developers, product managers, and community managers significantly contributed to our project successes.
As a Script Developer at Feature Films for Families, I specialized in crafting sophisticated scripts to automate telephone calls for movie and book sales as well as political and charitable fundraising campaigns. My responsibilities encompassed:
Script Automation Expertise: Developed intricate scripts tailored to automate telephone call processes, playing a crucial role in optimizing sales and fundraising initiatives. These scripts were meticulously designed to streamline operations and enhance campaign efficiency.
Server Auditing & Maintenance: Managed and maintained a multitude of Windows and Linux servers, ensuring their seamless performance and reliability. Conducted rigorous audits to uphold server integrity, ensuring uninterrupted campaign activities.
Collaborative Project Execution: Orchestrated projects necessitating cross-functional collaboration with team members and management. Fostered a collaborative environment to ensure seamless integration of scripts and alignment with overarching campaign objectives.
My tenure was marked by a commitment to crafting sophisticated automation solutions, maintaining server infrastructure, and fostering collaborative efforts to drive successful sales and fundraising campaigns.
Engaged in delivering compelling product presentations and articulating information on political and charitable initiatives to prospective and established clients, utilizing effective sales scripts. Managed sensitive data, including payment and delivery information, with strict confidentiality and accuracy.
In customer service, adeptly handled queries and resolved complaints from clients and supporters, leveraging strong communication skills and maintaining a professional and positive demeanor. Responsibilities included meticulous data entry and ensuring prompt resolution to enhance overall customer satisfaction.